OEBS job ended with return code '2'.

Products

• CA Automic One Automation

Issue/Introduction

Oracle EBS jobs are failing with return code '2'.

U00011003 Job 'JOBS.OEBS.32836562' (RunID '0001902039') on Host 'VWASOEBS01_RA_OEBS_01' aborted (return code='0002'). Remote ID=

The job report reveals the following exception:

2021-09-08 14:27:52             -----  prompts  -----
ORA-20993:  aw_submit_conc error 
 A check_triple_local=N. resp_name=Here. resp_appl_name=Wrong fnduser_name=Something language_territory= org_id=
[ORA-20095: No matching responsibility for name Here and option FND
 A check_triple_local=N. resp_name=Here. resp_appl_name=Wrong fnduser_name=Something language_territory= org_id=]
ORA-06512: at "APPS.UC4_OAE_PK", line 224
ORA-06512: at "APPS.UC4_OAE_PK", line 484
ORA-06512: at line 1

java.sql.SQLException: ORA-20993:  aw_submit_conc error 
 A check_triple_local=N. resp_name=Here. resp_appl_name=Wrong fnduser_name=Something language_territory= org_id=
[ORA-20095: No matching responsibility for name Here and option FND
 A check_triple_local=N. resp_name=Here. resp_appl_name=Wrong fnduser_name=Something language_territory= org_id=]
ORA-06512: at "APPS.UC4_OAE_PK", line 224
ORA-06512: at "APPS.UC4_OAE_PK", line 484
ORA-06512: at line 1

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
	at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223)
	at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:56)
	at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:907)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
	at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1300)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887)
	at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4230)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079)
	at com.uc4.ra.jdbc.DBCall.runProcedure(DBCall.java:484)
	at com.uc4.oebs.agent.JobDB.runProcedure(JobDB.java:67)
	at com.uc4.oebs.agent.RunJob.submit(RunJob.java:78)
	at com.uc4.oebs.agent.RunJob$submit$0.call(Unknown Source)
	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47)
	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:136)
	at Default.runJob(OEBSAgent.groovy:1452)
	at com.uc4.extensibility.types.CITAgent.dispatchJob(CITAgent.java:258)
	at com.uc4.ex.cit.CITJob.execute(CITJob.java:195)
	at com.uc4.ex.Job.run(Job.java:461)
	at com.uc4.ex.ThreadPool$RunnableDecorator.run(ThreadPool.java:53)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: Error : 20993, Position : 0, Sql = BEGIN uc4_oae_pk.aw_submit_conc (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 ) ; END;, OriginalSql = { call uc4_oae_pk.aw_submit_conc (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }, Error Msg = ORA-20993:  aw_submit_conc error 
 A check_triple_local=N. resp_name=Here. resp_appl_name=Wrong fnduser_name=Something language_territory= org_id=
[ORA-20095: No matching responsibility for name Here and option FND
 A check_triple_local=N. resp_name=Here. resp_appl_name=Wrong fnduser_name=Something language_territory= org_id=]
ORA-06512: at "APPS.UC4_OAE_PK", line 224
ORA-06512: at "APPS.UC4_OAE_PK", line 484
ORA-06512: at line 1

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
	... 31 more

 

Cause

Configuration.

Environment

Release : 4.3

Component : RA ORACLE EBS

Resolution

The values provided for "User Name", "Application" and "Responsibility" are incorrect.

Once this is corrected the Oracle EBS job ends with return code '0'.

U00011002 Job 'JOBS.OEBS.32836562' (RunID '0001901057') on Host 'VWASOEBS01_RA_OEBS_01' ended normally. Remote ID=7589885 Remote status=Completed - Normal

2021-09-08 19:24:21             runId 1901057 wasRestarted null
2021-09-08 19:24:21             -----  prompts  -----
2021-09-08 19:24:21             userName : SYSADMIN
2021-09-08 19:24:21             application : SYSADMIN
2021-09-08 19:24:21             responsibility : System Administrator
2021-09-08 19:24:21             appShortName : FND
2021-09-08 19:24:21             language : 
2021-09-08 19:24:21             program : FNDSCURS
2021-09-08 19:24:21             printer : 
2021-09-08 19:24:21             printerStyle : 
2021-09-08 19:24:21             copies : 
2021-09-08 19:24:21             saveOutput : N
2021-09-08 19:24:21             printTogether : N
2021-09-08 19:24:21             xmlAppShortName : 
2021-09-08 19:24:21             xmlTemplate : 
2021-09-08 19:24:21             xmlLanguage : 
2021-09-08 19:24:21             xmlOutputFormat : 
2021-09-08 19:24:21             operatingUnit : 
2021-09-08 19:24:21             checkTriple : N
2021-09-08 19:24:21             warningEndOk : false
2021-09-08 19:24:21             RA_CAPTURED_APPLICATION_JOBID : not defined
2021-09-08 19:24:21             -----  prompts  -----
2021-09-08 19:24:48             7589885 Completed
2021-09-08 19:24:48             register output: /u01/install/VISION/fs_ne/inst/EBSDB_vwasoebs01/logs/appl/conc/log/l7589885.req
2021-09-08 19:24:48             register output: /u01/install/VISION/fs_ne/inst/EBSDB_vwasoebs01/logs/appl/conc/out/o7589885.out