- ERP System: Oracle
- MarkView Version: MarkView 5.x
Workitem transitions to Error Queue because of an error in the rule code attempting to execute SFOA_AP_Util.ApplyInvoiceHold
ORA-06508: PL/SQL: could not find program unit being called Unexpected error in the trigger AX_AP_H ORA-06512: at "APPS.APP_EXCEPTION", line 27 ORA-06512: at "APPS.AX_EXCEPTIONS_PKG", line 28 ORA-06512: at "APPS.AX_MESSAGE_PKG",line 553 ORA-06512: at "APPS.AX_AP_HOLDS_ARI1", line 31 ORA-04088: error during execution of trigger 'APPS.AX_AP_HOLDS_ARI1'
This can start to occur after the application of Oracle patchsets.
This is likely to be a Definer / Invoker Rights issue.
The trigger code in Apps can contain calls to Apps packages that the MarkView database user does not have execute rights on.
To resolve this, simply grant execute rights to the MarkView database user on the Apps packages referenced in the trigger code.
Keywords: workflow, error queue, oracle applications, trigger