MarkView Database - Apps Trigger Error : ORA-06508: PL/SQL: could not find program unit being called

Applies To

• ERP System: Oracle
• MarkView Version: MarkView 5.x

Behavior

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.

Known Causes

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.

Resolution

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