OA job data submit_request exception: ORA-06550

Document ID : KB000045755
Last Modified Date : 14/02/2018
Show Technical Document Details

PROBLEM :

We installed the patch OA (Oracle E- Businees Suite)  for running jobs.

 

We execute jobs and these are in error:

 

"04/29/2016 16:23:07.832 WEST+0100 3 OAPlugin.oa Internal Thread.OaDbHandler.submitRequest[:723] - call fnd_request.submit_request( CA, XXSON_FOUND_DATA, null, p_cmArgs = )

04/29/2016 16:23:07.846 WEST+0100 1 OAPlugin.oa InternalThread.CybWOBRunOaHandler.processWob[:123] - Problem with OA job data submit_request exception: ORA-06550: line 1, column 13:

                                                                                                      PLS-00201: identifier 'CYBER_OA_PKG.SUBMIT_REQUEST' must be declared

                                                                                                      ORA-06550: line 1, column 7:

                                                                                                      PL/SQL: Statement ignored AFM: 20160429 16230768-0100 B2BEBSAPPPRD01 JavaAgent#tcpip@DSEPRD "

 

 

ENVIRONMENT:

 

1 - DSeries Server version 11.3..3.0 build 1366 and agents versions 11.3.4
2 - DSeries server Oracle version 11g and the agents Oracle versions 11g (11.2.0.4)

SOLUTION:

 

Run the script documented below : 

 

"Install the cyber_oa_pkg Database Package 

 

The agent plug-in requires the cyber_oa_pkg database package to manage workload. The cyber_oa_pkg database package is a wrapper for selected OA API calls. You require this wrapper to work around some JDBC limitations, such as the lack of support for Boolean data types. 

 

Note: You must install this package on every CA WA Agent for Oracle E-Business Suite system. 

 

To install the cyber_oa_pkg package 

Go to the agent installation directory from the operating system. 

Log in to the Oracle E-Business Suite database as apps using sqlplus. 

sqlplus apps/appspassword@appsinstance 

Run the oa_install.sql script to create the cyber_oa_pkg package. 

@oa_install.sql 

The cyber_oa_pkg package is installed."