| 0.01624 |
0.00608 |
Session State: fetch from database (exact)
|
4 |
1.30546005502547396161951730383761905375 |
| 0.02232 |
0.00002 |
... sentry+verification success
|
4 |
.004935982453655416918830987668628183172163 |
| 0.02234 |
0.00026 |
...Session ID 2252466788421 can be used
|
4 |
.0564418863178858543327195546456179206208 |
| 0.02261 |
0.00008 |
< APEX_APPLICATION_AUTH Internal Authentication
|
3 |
.0178124584197130262723031294128756175343 |
| 0.02269 |
0.00011 |
SESSION Language (CHINEME): wwv_flow.g_browser_language=en maplang=en
|
4 |
.0244653043355094577715970693140701252881 |
| 0.02280 |
0.00225 |
Setting NLS: NLS_DATE_FORMAT="mm/dd/yyyy"
|
4 |
.4832970645926956044003210534674203697265 |
| 0.02505 |
0.00002 |
...NLS: date_format=mm/dd/yyyy timestamp_format=DD-MON-RR HH.MI.SSXFF AM timestamp_tz_format=DD-MON-RR HH.MI.SSXFF AM TZR decimal separator=".", group separator=","
|
4 |
.004935982453655416918830987668628183172163 |
| 0.02508 |
0.00001 |
...NLS: Language=en
|
4 |
.001931471394908641403020821261637115154325 |
| 0.02509 |
0.00012 |
...metadata, fetch translated app info
|
4 |
.0255383439993475918843864144594240781516 |
| 0.02521 |
0.00014 |
Setting NLS: NLS_DATE_FORMAT="mm/dd/yyyy"
|
4 |
.029615894721932501512985926011769099033 |
| 0.02534 |
0.00002 |
...Check for session expiration:
|
4 |
.004077550722584909628599511552345020881352 |
| 0.02536 |
0.00036 |
...Metadata: Fetch Page, Computation, Process, and Branch
|
4 |
.0779026795946485365885064575526969778911 |
| 0.02573 |
0.00014 |
...Validate restricted (internal) items.
|
4 |
.0300451105874677551581016640699106801784 |
| 0.02587 |
0.00001 |
...Check for session state inputs on Branch To Page Accept
|
4 |
.002146079327676268225578690290707905727027 |
| 0.02588 |
0.00008 |
...Check for protected items on Branch To Page Accept to non-protected page
|
4 |
.0163102028903396385143980462093800835254 |
| 0.02595 |
0.00219 |
...Check authorization security schemes
|
4 |
.469991372761102741401733173665031354219 |
| 0.02814 |
0.00002 |
> APEX_APPLICATION_AUTHORIZATION Flow: EDIT
|
3 |
.004077550722584909628599511552345020881352 |
| 0.02816 |
0.00001 |
... passed (using cache)
|
4 |
.002146079327676268225578690290707905727027 |
| 0.02817 |
0.00004 |
< APEX_APPLICATION_AUTHORIZATION Flow: EDIT
|
3 |
.007511277646866938789525416017477670044596 |
| 0.02821 |
0.00005 |
Session State: Save form items and p_arg_values
|
4 |
.0113742204366842215955670585407519003532 |
| 0.02826 |
0.00007 |
Processes - point: ON_SUBMIT_BEFORE_COMPUTATION
|
4 |
.0148079473609662507564929630058845495165 |
| 0.02833 |
0.00001 |
> APEX_APPLICATION_PROCESSES set flow page
|
3 |
.00236068726044389504813655931977869629973 |
| 0.02834 |
0.00008 |
...Process "set flow page" - Type: NATIVE_PLSQL
|
4 |
.0169540266886425189820716532965924552435 |
| 0.02842 |
0.00001 |
>> APEX_APPLICATION_AUTHORIZATION Flow: EDIT
|
3 |
.003004511058746775515810166406991068017838 |
| 0.02843 |
0.00001 |
... passed (using cache)
|
4 |
.001931471394908641403020821261637115154325 |
| 0.02844 |
0.00029 |
<< APEX_APPLICATION_AUTHORIZATION Flow: EDIT
|
3 |
.0624509084353794053643398874596000566565 |
| 0.02873 |
0.00261 |
begin wwv_flow_f4000_util.set_flow_page;
end;
|
4 |
.5601267045235060068760381658747633947541 |
| 0.03134 |
0.00019 |
Session State: FB_FLOW_ID=>228 (Type difference: Item=NUMBER, Value=VARCHAR2)
|
4 |
.0416339389569196035762265916397333711043 |
| 0.03154 |
0.00008 |
Session State: FB_FLOW_PAGE_ID=>1 (Type difference: Item=NUMBER, Value=VARCHAR2)
|
4 |
.0165248108231072653369559152384508740981 |
| 0.03161 |
0.00024 |
Session State: F4000_P1_FLOW=>228
|
4 |
.0519351197297656910590043050351313185941 |
| 0.03185 |
0.00015 |
Session State: F4000_LAST_VIEW=>1
|
4 |
.0319765819823763965611224853315477953327 |
| 0.03200 |
0.00003 |
< APEX_APPLICATION_PROCESSES set flow page
|
3 |
.007296669714099311966967546988406879471893 |
| 0.03204 |
0.00207 |
Branches - point: BEFORE_COMPUTATION
|
4 |
.4440238128962198958722310211474656949219 |
| 0.03411 |
0.00004 |
Process point: AFTER_SUBMIT
|
4 |
.008369709377937446079756892133760832335406 |
| 0.03415 |
0.00005 |
> APEX_APPLICATION_PAGE_COMP P598_PARSE_AS
|
3 |
.0107303966383813411278934514535395286351 |
| 0.03420 |
0.00011 |
...Perform computation of item: P598_PARSE_AS, type=QUERY
|
4 |
.0244653043355094577715970693140701252881 |
| 0.03431 |
0.00030 |
select /*+qb_name(apex$4000_598)*/owner from wwv_flows where id = :P598_IMP_FLOW_ID and security_group_id = :P598_LOGGED_IN_COMPANY
|
4 |
.0648115956958233004124764467793787529562 |
| 0.03461 |
0.00008 |
Session State: P598_PARSE_AS=>ATTDBA
|
4 |
.0163102028903396385143980462093800835254 |
| 0.03469 |
0.00002 |
< APEX_APPLICATION_PAGE_COMP P598_PARSE_AS
|
3 |
.003648334857049655983483773494203439735946 |
| 0.03470 |
0.00265 |
Tabs: Perform Branching for Tab Requests
|
4 |
.569569453565281587068584403153878179953 |
| 0.03736 |
0.00003 |
Branches - point: BEFORE_VALIDATION
|
4 |
.00708206178133168514440967795933608889919 |
| 0.03739 |
0.00285 |
Validations:
|
4 |
.6109887845894335638222531257645407604847 |
| 0.04024 |
0.00021 |
Perform basic and predefined validations:
|
4 |
.0452822738139692595597103651339368108403 |
| 0.04045 |
0.00009 |
Perform custom validations:
|
4 |
.0191001060163187872076503435873003609705 |
| 0.04054 |
0.00001 |
> APEX_APPLICATION_PAGE_VAL version must be compatible
|
3 |
.002789903125979148693252297377920277445135 |
| 0.04055 |
0.00005 |
...Validation "version must be compatible" - Type: FUNC_BODY_RETURNING_BOOLEAN
|
4 |
.0109450045711489679504513204826103192078 |
| 0.04060 |
0.00001 |
......Skip because "When Button Pressed" doesn't match with REQUEST
|
4 |
.002146079327676268225578690290707905727027 |
| 0.04061 |
0.00001 |
< APEX_APPLICATION_PAGE_VAL version must be compatible
|
3 |
.00236068726044389504813655931977869629973 |
| 0.04062 |
0.00001 |
> APEX_APPLICATION_PAGE_VAL valid export file
|
3 |
.00236068726044389504813655931977869629973 |
| 0.04063 |
0.00002 |
...Validation "valid export file" - Type: EXPRESSION
|
4 |
.004292158655352536451157380581415811454055 |
| 0.04065 |
0.00001 |
......Skip because "When Button Pressed" doesn't match with REQUEST
|
4 |
.001931471394908641403020821261637115154325 |
| 0.04066 |
0.00001 |
< APEX_APPLICATION_PAGE_VAL valid export file
|
3 |
.002146079327676268225578690290707905727027 |
| 0.04067 |
0.00001 |
> APEX_APPLICATION_PAGE_VAL component export from same app
|
3 |
.002146079327676268225578690290707905727027 |
| 0.04068 |
0.00002 |
...Validation "component export from same app" - Type: EXPRESSION
|
4 |
.003648334857049655983483773494203439735946 |
| 0.04070 |
0.00001 |
......Skip because "When Button Pressed" doesn't match with REQUEST
|
4 |
.001931471394908641403020821261637115154325 |
| 0.04071 |
0.00003 |
< APEX_APPLICATION_PAGE_VAL component export from same app
|
3 |
.005579806251958297386504594755840554890271 |
| 0.04074 |
0.00001 |
Branches - point: BEFORE_PROCESSING
|
4 |
.002789903125979148693252297377920277445135 |
| 0.04075 |
0.00001 |
> APEX_APPLICATION_PAGE_BRANCHES f?p=&APP_ID.:48:&SESSION.:COMP:&DEBUG.:::
|
3 |
.002146079327676268225578690290707905727027 |
| 0.04076 |
0.00002 |
...Branch "f?p=&APP_ID.:48:&SESSION.:COMP:&DEBUG.::" - Type: REDIRECT_URL
|
4 |
.00472137452088779009627311863955739259946 |
| 0.04078 |
0.00001 |
......Skip because "When Button Pressed" doesn't match with REQUEST
|
4 |
.00236068726044389504813655931977869629973 |
| 0.04079 |
0.00002 |
< APEX_APPLICATION_PAGE_BRANCHES f?p=&APP_ID.:48:&SESSION.:COMP:&DEBUG.:::
|
3 |
.004077550722584909628599511552345020881352 |
| 0.04081 |
0.00003 |
Processes - point: AFTER_SUBMIT
|
4 |
.005365198319190670563946725726769764317568 |
| 0.04084 |
0.00001 |
> APEX_APPLICATION_PAGE_PROCESS install components
|
3 |
.00236068726044389504813655931977869629973 |
| 0.04085 |
0.00021 |
...Process "install components" - Type: NATIVE_PLSQL
|
4 |
.0452822738139692595597103651339368108403 |
| 0.04106 |
0.24313 |
begin begin
wwv_flow_imp_parser.parse (
p_file_id => :P598_FILE_ID,
p_parse_as_schema => :P598_PARSE_AS,
p_install_as_flow => :FB_FLOW_ID,
p_original_flow_id => wwv_flow_imp_parser.get_flow_id(:P598_FILE_ID),
p_adjust_offset => false
);
end;
end;
|
4 |
52.17827051759141224896237064506852431293 |
| 0.28419 |
0.01142 |
begin
wwv_flow_imp.import_begin (
p_version_yyyy_mm_dd=>'2023.10.31'
,p_release=>'23.2.6'
,p_default_workspace_id=>1461414179252961
,p_default_application_id=>228
,p_default_id_offset=>136389206362609312
,p_default_owner=>'ATTDBA'
);
end;
|
4 |
2.45146641600460119407853791907564071198 |
| 0.29561 |
0.01238 |
begin
-- replace components
wwv_flow_imp.g_mode := 'REPLACE';
end;
|
4 |
2.65749003146152294373409218698359966178 |
| 0.30800 |
0.00039 |
Exception in "wwv_flow_imp_shared.create_task_def":
Error Stack: ORA-00001: unique constraint (APEX_230200.WWV_TASK_DEF_STATIC_ID_UK) violated
Backtrace: ORA-06512: at "APEX_230200.WWV_FLOW_IMP_SHARED", line 11607
|
2 |
.0841263096449097144426846593957499044995 |
| 0.30839 |
0.00369 |
Exception in "install components":
Error Stack: ORA-20001: call=wwv_flow_imp_shared.create_task_def, id=805363798038706040, component=Request - Manager Approval, sqlerrm=ORA-00001: unique constraint (APEX_230200.WWV_TASK_DEF_STATIC_ID_UK) violated
ORA-06512: at "APEX_230200.WWV_IMP_UTIL", line 138
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_SHARED", line 228
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_SHARED", line 11657
ORA-00001: unique constraint (APEX_230200.WWV_TASK_DEF_STATIC_ID_UK) violated
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_SHARED", line 11607
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SQL", line 1721
Backtrace: ORA-06512: at "APEX_230200.WWV_IMP_UTIL", line 138
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_SHARED", line 228
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_SHARED", line 11657
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_SHARED", line 11607
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "APEX_230200.WWV_FLOW_APP_INSTALL_INT", line 231
|
2 |
.7927617036436134825287681933875003755639 |
| 0.31208 |
0.00411 |
Add error onto error stack: Execution of the statement was unsuccessful. ORA-20001: call=wwv_flow_imp_shared.create_task_def, id=805363798038706040, component=Request - Manager Approval, sqlerrm=ORA-00001: unique constraint (APEX_230200.WWV_TASK_DEF_STATIC_ID_UK) violated
<pre>begin
wwv_flow_imp_shared.create_task_def(
p_id=>wwv_flow_imp.id(805363798038706040)
,p_name=>'Request - Manager Approval'
,p_static_id=>'REQUEST_REMOTE_LOCAL'
,p_subject=>'&ATTENDANCE_TYPE. Request for &EMPLOYEE. (&START_DATE. to &END_DATE.)'
,p_task_type=>'APPROVAL'
,p_priority=>3
,p_expiration_policy=>'NONE'
,p_max_renewal_count=>3
,p_details_link_target=>'f?p=&APP_ID.:13:&SESSION.::&DEBUG.:RP,13:P13_TASK_ID:&TASK_ID.'
,p_actions_sql_query=>wwv_flow_string.join(wwv_flow_t_varchar2(
'SELECT ID, EMPLOYEE_ID, START_DATE_TIME, END_DATE_TIME, PART_OF_DAY_ID, ATTENDANCE_TYPE_ID, LOCATION_ID, LOCATION_OTH~
|
2 |
.8809655640111081066000523643355953009447 |
| 0.31619 |
0.00020 |
...Execute Error Handling Callout defined on Page or Application Level
|
4 |
.0437800182845958718018052819304412768314 |
| 0.31639 |
0.00350 |
begin declare
l_error wwv_flow_error_api.t_error;
begin
l_error := wwv_flow_error_api.g_error;
wwv_flow_error_api.g_error_result := wwv_flow_error_dev.internal_error_handler (
p_error => l_error );
end;
end;
|
4 |
.7504839408883909984848679946605546327414 |
| 0.31989 |
0.10137 |
DBMS_SYS_SQL found
|
2 |
21.75437692878879574904606773884789877373 |
| 0.42126 |
0.00009 |
Error: Execution of the statement was unsuccessful. ORA-20001: call=wwv_flow_imp_shared.create_task_def, id=805363798038706040, component=Request - Manager Approval, sqlerrm=ORA-00001: unique constraint (APEX_230200.WWV_TASK_DEF_STATIC_ID_UK) violated
<pre>begin
wwv_flow_imp_shared.create_task_def(
p_id=>wwv_flow_imp.id(805363798038706040)
,p_name=>'Request - Manager Approval'
,p_static_id=>'REQUEST_REMOTE_LOCAL'
,p_subject=>'&ATTENDANCE_TYPE. Request for &EMPLOYEE. (&START_DATE. to &END_DATE.)'
,p_task_type=>'APPROVAL'
,p_priority=>3
,p_expiration_policy=>'NONE'
,p_max_renewal_count=>3
,p_details_link_target=>'f?p=&APP_ID.:13:&SESSION.::&DEBUG.:RP,13:P13_TASK_ID:&TASK_ID.'
,p_actions_sql_query=>wwv_flow_string.join(wwv_flow_t_varchar2(
'SELECT ID, EMPLOYEE_ID, START_DATE_TIME, END_DATE_TIME, PART_OF_DAY_ID, ATTENDANCE_TYPE_ID, LOCATION_ID, LOCATION_OTH~
- Additional info: Contact your application administrator.
Details about this incident are available via debug id "3576788".
- Display location: ON_ERROR_PAGE
- Association type:
- Item name:
- Region id:
- Column alias:
- Row:
- Model instance id:
- Model record id:
- Internal error: true
- Common runtime error: false
- APEX error code: WWV_FLOW_IMP_PARSER.RUN_STMT_ERROR
- SQL code: -20001
- SQL error: ORA-20001: call=wwv_flow_imp_shared.create_task_def, id=805363798038706040, component=Request - Manager Approval, sqlerrm=ORA-00001: unique constraint (APEX_230200.WWV_TASK_DEF_STATIC_ID_UK) violated
ORA-06512: at "APEX_230200.WWV_IMP_UTIL", line 138
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_SHARED", line 228
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_SHARED", line 11657
ORA-00001: unique constraint (APEX_230200.WWV_TASK_DEF_STATIC_ID_UK) violated
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_SHARED", line 11607
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SQL", line 1721
- Backtrace: ORA-06512: at "APEX_230200.WWV_IMP_UTIL", line 138
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_SHARED", line 228
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_SHARED", line 11657
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_SHARED", line 11607
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "APEX_230200.WWV_FLOW_APP_INSTALL_INT", line 231
- Statement:
- Component: APEX_APPLICATION_PAGE_PROCESS install components (209196524386496728)
|
1 |
.0199585377473892944978818197035835232614 |
| 0.42135 |
0.00003 |
......Values changed by callout:
|
4 |
.006223630050261177854178201843052926608379 |
| 0.42138 |
0.00003 |
...Show Error on Error Page
|
4 |
.005579806251958297386504594755840554890271 |
| 0.42140 |
0.00393 |
......Performing rollback
|
4 |
.8440529995750762931200988913354193224398 |
| 0.42534 |
0.00721 |
Show page template header
|
4 |
1.54732319525458939064223569960040002919 |
| 0.43255 |
0.00004 |
session state access is disabled
|
4 |
.009228141109007953369988368250043994626217 |
| 0.43259 |
0.00004 |
session state access is disabled
|
4 |
.007725885579634565612083285046548460617298 |
| 0.43263 |
0.00401 |
session state access is disabled
|
4 |
.8599339865998806779893811994866578248198 |
| 0.43663 |
0.00316 |
session state access is disabled
|
4 |
.6770880278818626251700767867183442568771 |
| 0.43979 |
0.00018 |
Rendering form open tag and internal values
|
4 |
.0384148199654052012378585562036715125138 |
| 0.43997 |
0.00057 |
Processes - point: AFTER_ERROR_HEADER
|
4 |
.1225411296103149156805432155994214170133 |
| 0.44054 |
0.00003 |
Processes - point: BEFORE_ERROR_FOOTER
|
4 |
.006009022117493551031620332813982136035676 |
| 0.44057 |
0.00001 |
Show page footer
|
4 |
.002146079327676268225578690290707905727027 |
| 0.44058 |
0.00004 |
Show page tempate footer
|
4 |
.009228141109007953369988368250043994626217 |
| 0.44062 |
0.00004 |
session state access is disabled
|
4 |
.008798925243472699724872630191902413480812 |
| 0.44066 |
0.00004 |
session state access is disabled
|
4 |
.007725885579634565612083285046548460617298 |
| 0.44070 |
0.00004 |
session state access is disabled
|
4 |
.008155101445169819257199023104690041762704 |
| 0.44073 |
0.00003 |
session state access is disabled
|
4 |
.005365198319190670563946725726769764317568 |
| 0.44076 |
0.00315 |
session state access is disabled
|
4 |
.6760149882180244910572874415729903040136 |
| 0.44391 |
0.00005 |
session state access is disabled
|
4 |
.009871964907310833837661975337256366344326 |
| 0.44396 |
0.00006 |
session state access is disabled
|
4 |
.0120180442349871020632406656279642720714 |
| 0.44401 |
0.00004 |
session state access is disabled
|
4 |
.007725885579634565612083285046548460617298 |
| 0.44405 |
0.00394 |
Rendering form close tag and page checksum
|
4 |
.8464136868355201881682354506551980187396 |
| 0.44799 |
0.00055 |
Exception in "install components":
Error Stack: ORA-20987: APEX - Execution of the statement was unsuccessful. ORA-20001: call=wwv_flow_imp_shared.create_task_def, id=805363798038706040, component=Request - Manager Approval, sqlerrm=ORA-00001: unique constraint (APEX_230200.WWV_TASK_DEF_STATIC_ID_UK) violated
<pre>begin
wwv_flow_imp_shared.create_task_def(
p_id=>wwv_flow_imp.id(805363798038706040)
,p_name=>'Request - Manager Approval'
,p_static_id=>'REQUEST_REMOTE_LOCAL'
,p_subject=>'&ATTENDANCE_TYPE. Request for &EMPLOYEE. (&START_DATE. to &END_DATE.)'
,p_task_type=>'APPROVAL'
,p_priority=>3
,p_expiration_policy=>'NONE'
,p_max_renewal_count=>3
,p_details_link_target=>'f?p=&APP_ID.:13:&SESSION.::&DEBUG.:RP,13:P13_TASK_ID:&TASK_ID.'
,p_actions_sql_query=>wwv_flow_string.join(wwv_flow_t_varchar2(
'SELECT ID, EMPLOYEE_ID, START_DATE_TIME, END_DATE_TIME, PART_OF_DAY_ID, ATTENDANCE_TYPE_ID, LOCATIO~
Backtrace: ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1111
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1569
ORA-06512: at "APEX_230200.WWV_FLOW_APP_INSTALL_INT", line 256
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 1122
|
2 |
.1176051471566594987617122279307932338411 |
| 0.44854 |
0.00013 |
Exception in "begin begin
wwv_flow_imp_parser.parse (
p_file_id => :P598_FILE_ID,
p_parse_as_schema => :P598_PARSE_AS,
p_install_as_flow => :FB_FLOW_ID,
p_original_flow_id => wwv_flow_imp_parser.get_flow_id(:P598_FILE_ID),
p_adjust_offset => false
);
end;
end;":
Error Stack: ORA-20987: APEX - Execution of the statement was unsuccessful. ORA-20001: call=wwv_flow_imp_shared.create_task_def, id=805363798038706040, component=Request - Manager Approval, sqlerrm=ORA-00001: unique constraint (APEX_230200.WWV_TASK_DEF_STATIC_ID_UK) violated
<pre>begin
wwv_flow_imp_shared.create_task_def(
p_id=>wwv_flow_imp.id(805363798038706040)
,p_name=>'Request - Manager Approval'
,p_static_id=>'REQUEST_REMOTE_LOCAL'
,p_subject=>'&ATTENDANCE_TYPE. Reque
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 3081
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1519
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1554
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 1446
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 3034
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 2924
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810
Backtrace: ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 3081
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1519
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1554
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 1446
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 3034
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 2924
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 3081
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1519
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1554
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 1446
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 3034
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 2924
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607
|
2 |
.0270405995287209796422914976629196121605 |
| 0.44867 |
0.00020 |
Exception in "plsql process":
Error Stack: ORA-20987: APEX - Execution of the statement was unsuccessful. ORA-20001: call=wwv_flow_imp_shared.create_task_def, id=805363798038706040, component=Request - Manager Approval, sqlerrm=ORA-00001: unique constraint (APEX_230200.WWV_TASK_DEF_STATIC_ID_UK) violated
<pre>begin
wwv_flow_imp_shared.create_task_def(
p_id=>wwv_flow_imp.id(805363798038706040)
,p_name=>'Request - Manager Approval'
,p_static_id=>'REQUEST_REMOTE_LOCAL'
,p_subject=>'&ATTENDANCE_TYPE. Reque
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 126
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2647
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 3081
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1519
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1554
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 1446
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 3034
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 2924
ORA-06512: at line~
Backtrace: ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 3081
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1519
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1554
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 1446
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 3034
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 2924
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 126
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2647
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 3081
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1519
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1554
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 1446
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 3034
ORA-06512: at "APEX_230200.WWV_FLOW_IMP_PARSER", line 2924
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810
ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 97
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 430
ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC", line 614
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC_LOCAL", line 3062
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC", line 2823
ORA-06512: at "APEX_230200.WWV_FLOW_EXEC", line 2861
ORA~
|
2 |
.0422777627552224840439001987269457428224 |
| 0.44886 |
0.00325 |
Exception in "final_exception_handler":
Error Stack: ORA-20987: APEX - Execution of the statement was unsuccessful. ORA-20001: call=wwv_flow_imp_shared.create_task_def, id=805363798038706040, component=Request - Manager Approval, sqlerrm=ORA-00001: unique constraint (APEX_230200.WWV_TASK_DEF_STATIC_ID_UK) violated
<pre>begin
wwv_flow_imp_shared.create_task_def(
p_id=>wwv_flow_imp.id(805363798038706040)
,p_name=>'Request - Manager Approval'
,p_static_id=>'REQUEST_REMOTE_LOCAL'
,p_subject=>'&ATTENDANCE_TYPE. Reque
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1519
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1554
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS", line 650
Backtrace: ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1519
ORA-06512: at "APEX_230200.WWV_FLOW_ERROR", line 1554
ORA-06512: at "APEX_230200.WWV_FLOW_PROCESS", line 650
ORA-06512: at "APEX_230200.WWV_FLOW", line 4241
|
2 |
.6979049973603224269581900825382109424293 |
| 0.45211 |
0.00035 |
service "uapex19.admin.gov.ky" is already active. No need to switch.
|
4 |
.075112776468669387895254160174776700446 |
| 0.45246 |
0.01331 |
Log + final commit
|
4 |
2.85578776133881012777756316984501015096 |