My Oracle Support Banner

Invoice Approval Fails with Error ORA-29471:Dbms_sql Access Denied after upgrading to 11g (Doc ID 1259725.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Payables - Version 11.5.10.2 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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.