Invoice Approval Fails with Error ORA-29471:Dbms_sql Access Denied after upgrading to 11g

(Doc ID 1259725.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version: and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.


On : version, Approval Workflow Post 11iFinC
When attempting to Initiate AP Invoice workflow for new invoices that need to be approved after database upgrade to 11g,
the following error occurs.

Workflow Errors: APINV, 3162801_1
Failed Activity Identify Approver
Activity Type Function
Error Name -29471
Error Message ORA-29471: DBMS_SQL access denied

Error Stack AME_ENGINE.fetchItemClassData(20548) AME_ENGINE.setContext(20549)
AME_ENGINE.updateTransactionState(20550) AME_API2.getNextApprovers4(20551)
AME_API.getNextApprover(20552) APINV.Get_Approver(APINV, 3162801_1, 166884,
call AME_API to getNextApprover. ) Wf_Engine_Util.Function_Call(AP_WFAPPROVAL_PKG.get_approver
, APINV, 3162801_1, 166884, RUN)

The issue can be reproduced at will with the following steps:
1. Payables Responsibility >Invoices . Entry > Invoices
2. Action >Initiate

Retry the Error workflows and the records process through.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms