Page : Master detail with interactive grid for details
Apex version : 20.2
No dynamic actions on the page. Similar page in application works smoothly. Tried all possible solution available on google. No luck.
Pls help
Debug log:
e have 1 rows. Determining DML operation types.
0.048910.00118parsing generated DML statement: update "SSR_PLAN_HEADER"
set "PATIENT_ID"=:APEX$VAL2,"STATUS"=:APEX$VAL3,"START_DATE"=:APEX$VAL4,"NAME"=:APEX$VAL5,"DOCTOR"=:APEX$VAL6,"TYPE"=:APEX$VAL7,"VERSION"=:APEX$VAL8,"CHIEF_COMPLAINT"=:APEX$VAL9,"RADIOGRAPH"=:APEX$VAL10,"NOTES"=:APEX$VAL11,"PATIENT_PRICE"=:APEX$VAL12,"TOTAL"=:APEX$VAL13,"CLINIC_AMOUNT"=:APEX$VAL14,"PAYMENT"=:APEX$VAL15
where "PLAN_ID"=:APEX$PK1
0.050090.00131execute query select "PATIENT_ID","STATUS","START_DATE","NAME","DOCTOR","TYPE","VERSION","CHIEF_COMPLAINT","RADIOGRAPH","NOTES","PATIENT_PRICE","TOTAL","CLINIC_AMOUNT","PAYMENT" from"SSR_PLAN_HEADER"
where "PLAN_ID"=:APEX$PK1
for update nowait for row version checksum
0.051400.000511 rows fetched
0.051910.00014Exception in "do_execute_dml, row 1":
Error Stack: ORA-20987: Current version of data in database has changed since user initiated update process.
Backtrace: ORA-06512: at "APEX_200200.WWV_FLOW_EXEC_LOCAL", line 2491
0.052040.00008DML returned SQL code: -20987
0.052120.00035Add error onto error stack
0.052460.00002Error: Current version of data in database has changed since user initiated update process.
0.052490.00002- display_location: INLINE_IN_NOTIFICATION
0.052500.00001- is_internal_error: false
0.052510.00001- is_common_runtime_error: false
0.052530.00001- apex_error_code: APEX.DATA_HAS_CHANGED
0.052540.00001- ora_sqlcode: -20987
0.052550.00001- ora_sqlerrm: ORA-20987: Current version of data in database has changed since user initiated update process.
0.052560.00003- error_statement: "SSR_PLAN_HEADER"
0.052600.00033- component: APEX_APPLICATION_PAGE_PROCESS Process form on SSR_PLAN_HEADER (35697305086684228)
0.052920.00058Exception in "Process form on SSR_PLAN_HEADER":
Error Stack: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APEX_200200.WWV_FLOW_PROCESS", line 636
ORA-06512: at "APEX_200200.WWV_FLOW_REGION", line 1001
ORA-06512: at "APEX_200200.WWV_FLOW_REGION", line 1046
Backtrace: ORA-06512: at "APEX_200200.WWV_FLOW_PROCESS", line 636
ORA-06512: at "APEX_200200.WWV_FLOW_REGION", line 1001
ORA-06512: at "APEX_200200.WWV_FLOW_REGION", line 1046
ORA-06512: at "APEX_200200.WWV_FLOW_FORM_REGION", line 1241
0.053500.00052Exception in "Process form on SSR_PLAN_HEADER":
Error Stack: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APEX_200200.WWV_FLOW_FORM_REGION", line 1256
ORA-06512: at "APEX_200200.WWV_FLOW_PROCESS", line 636
ORA-06512: at "APEX_200200.WWV_FLOW_REGION", line 1001
ORA-06512: at "APEX_200200.WWV_FLOW_REGION", line 1046
ORA-06512: at "APEX_200200.WWV_FLOW_FORM_REGION", line 1241
ORA-06512: at "APEX_200200.WWV_FLOW_FORM_REGION", line 2255
ORA-06512: at "APEX_200200.WWV_FLOW_PROCESS_NATIVE", line 1211
ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 2757
Backtrace: ORA-06512: at "APEX_200200.WWV_FLOW_FORM_REGION", line 1256
ORA-06512: at "APEX_200200.WWV_FLOW_PROCESS", line 636
ORA-06512: at "APEX_200200.WWV_FLOW_REGION", line 1001
ORA-06512: at "APEX_200200.WWV_FLOW_REGION", line 1046
ORA-06512: at "APEX_200200.WWV_FLOW_FORM_REGION", line 1241
ORA-06512: at "APEX_200200.WWV_FLOW_FORM_REGION", line 2255
ORA-06512: at "APEX_200200.WWV_FLOW_PROCESS_NATIVE", line 1211
ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 2757
ORA-06512: at "APEX_200200.WWV_FLOW_PROCESS", line 203
0.054020.00011< APEX_APPLICATION_PAGE_PROCESS Process form on SSR_PLAN_HEADER
0.054130.00003...Inline Errors detected, performing rollback
0.054160.00118Emit errors as JSON
0.05534-service "YKWQMPQG4DXMZLI_DB001_low.adb.oraclecloud.com" is already active. No need to switch.