I have run into problems with APEX approvals records. I am stuck with delete of approvals records wjich have some underlying connections to records in other tables which have been deleted.
The approvals record is linked to contracts in the apex system, but the contract id which this approval records is linked to is deleted in the system, THEN i get the exception:
Error: System of record(s) associated with this task instance is not found
- Additional info: Contact your application administrator.
Details about this incident are available via debug id "1592977662".
- 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: APEX.TASK.ACTION.DATA_NOT_FOUND
- SQL code: 1
- SQL error: ORA-06510: PL/SQL: unhandled user-defined exception
- Backtrace: ORA-06512: at "APEX_230200.WWV_FLOW_APPROVAL", line 876
I need help to get these approvals records out of the system, not able to cancel the task with the api also, get the same error as above.
BEGIN apex_approval.cancel_task( p_task_id => 1234 ); END;