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: 11.5.10.2 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.

Symptoms

On :  11.5.10.2 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.

ERROR
-----------------------
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)


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

WORKAROUND
------------------------
Retry the Error workflows and the records process through.

Cause

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