Post Patch 1304908 CCG Component Configure Fails On Create Functions On Target ORA-29471: DBMS_SQL access denied ORA-06512 (Doc ID 2101265.1)

Last updated on OCTOBER 10, 2023

Applies to:

Symptoms

On :  5.5.1 version, Other Issues not covered by existing components

When attempting to configure CCG Component failed while configure Create Functions on Target,
the following error occurs.

ERROR
-----------------------
ORA-29471: DBMS_SQL access denied ORA-06512: at "SYS.DBMS_SQL", line 1183 ORA-06

User-Defined Exception
Error while Deploying CCG Apps.
ORA-29471: DBMS_SQL access denied
ORA-06512: at "SYS.DBMS_SQL", line 1183
ORA-06512: at "AMHOME.AM_DEPLOY_PKG", line 497
ORA-29471: DBMS_SQL access denied
ORA-06512: at "SYS.DBMS_SQL", line 1183
ORA-06512: at "AMHOME.TICK_SNAPSHOT_HOME_PKG", line 4055
ORA-29471: DBMS_SQL access denied
ORA-06512: at "SYS.DBMS_SQL", line 1183
ORA-06512: at line 38
ORA-24344: success with compilation error
ORA-06512: at "SYS.DBMS_SQL", line 1199
Error in deploy_apps.
User-Defined Exception
ORA-29471: DBMS_SQL access denied
ORA-06512: at "SYS.DBMS_SQL", line 1183
ORA-06
+--------------------------------------------------------------------
| Statement# : 1, executing on SBHCCGT
| Description : Create Functions On Target
| Date and Time : 29-DEC-2015 15:16.29
| Ignore Errors: N
+--------------------------------------------------------------------
begin apsdply_pkg.create_functions_on_target(101); end;
Error in am_deploy_pkg.perform_sqlset : ORA-29471: DBMS_SQL access denied
ORA-06512: at "SYS.DBMS_SQL", line 1183
ORA-06512: at "AMHOME.AM_DEPLOY_PKG", line 497
ORA-29471: DBMS_SQL access denied
ORA-06512: at "SYS.DBMS_SQL", line 1183
ORA-06512: at "AMHOME.TICK_SNAPSHOT_HOME_PKG", line 4055
ORA-29471: DBMS_SQL access denied
ORA-06512: at "SYS.DBMS_SQL", line 1183
ORA-06512: at line 38
ORA-24344: success with compilation error
ORA-06512: at "SYS.DBMS_SQL", line 1199


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 1304908
2. Configure CCG, Create Functions On Target fails with the above error.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run audit reports on EBS.

Cause

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