Oracle OEBS Jobs will not run through Automic

Document ID : KB000117295
Last Modified Date : 15/10/2018
Show Technical Document Details
Issue:
OEBS Jobs GL Auto Posting and Accounts Payable Trial Balance will not run via Automic, but run fine via Oracle EBS. These are native reports with no customizations. The error we receive when running is: j

ava.sql.SQLException: ORA-20096: Cannot submit concurrent request for program APTBRPT
Check if the concurrent program is registered with Application Object Library.
Check if you specified the correct application short name for your concurrent program.

Runtime Exception:

ORA-06512: at "STN_AUTOMIC.UC4_OAE_PK", line 466
ORA-06512: at line 1
Caused by: java.sql.SQLException: (ErrorCode 20096) (SQLState 72000) uc4_oae_pk.aw_submit_conc
Environment:
12.1.1+build.9812
OEBS Agent solution version undefined.
Cause:
Incorrect PROGRAM definition under the OEBS tab. 
Resolution:
During investigation, it was found that the Program App Shortname was SQLGL. This parameter is under the OEBS tab, and there is also a field that defines the parameter PROGRAM. In this field, FND was defined and the field was grey (unable to modify). To resolve this:

1) Export the affected job(s).
2) Change FND to SQLGL
3) Import the job, replacing the last definition.

 
Additional Information:
If this does not resolve the issue, follow the below steps:

1) In the Agent's .ini file under the [TRACE] section, set: 

RA=99 

2) Save the .ini file, then restart the Agent so it will take effect. 

3) Reproduce the issue. 

4) Shut down the Agent, and modify the RA= parameter back to 0. 

5) Start the Agent again. 

Once this has been accomplished, please provide the following files to Support via a new case for analysis: 

1) Agent log file 
2) Agent trace file 
3) Job report 
4) RunID of the job in question