CCG Agent Configuration Job Error in am_deploy_Pkg.perform_target_sql -- ORA-01920: user name 'AM_AGENT' conflicts with another user or role name (Doc ID 1542783.1)

Last updated on OCTOBER 03, 2024

Applies to:

Symptoms

When trying to configure an EBS instance the CCG Agent Configuration Job throws Error in am_deploy_Pkg.perform_target_sql -- ORA-01920: user name 'AM_AGENT' conflicts with another user or role name. The job log looks similar to :

Error while configuring the instance.  
ORA-01920: user name 'AM_AGENT' conflicts with another user or role name  
ORA-06512: at "SYS.DBMS_SQL", line 1199  
Error configuring the instance. User-Defined Exception  
ORA-01920: user name 'AM_AGENT' conflicts with another user or role name  
ORA-065  
+--------------------------------------------------------------------  
| Statement# : 1, executing on TBGDEV_SYSTEM_DBLINK  
| Description : Create CCG Agent User  
| Date and Time : 02-APR-2013 08:17.24  
| Ignore Errors: N  
+--------------------------------------------------------------------  
SQL statement suppressed from logfile.  

Error in am_deploy_Pkg.perform_target_sql -- ORA-01920: user name 'AM_AGENT' con  
flicts with another user or role name  
ORA-06512: at "SYS.DBMS_SQL", line 1199  
***** ORA-01920: user name 'AM_AGENT' conflicts with another user or role name  
ORA-06512: at "SYS.DBMS_SQL", line 1199  
***** Terminating SQL Set due to error on a statement with IGNORE_ERRORS=N. 

Cause

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