OA job data submit_request exception: ORA-06550
search cancel

OA job data submit_request exception: ORA-06550


Article ID: 45755


Updated On:


DSERIES- SERVER CA Workload Automation DE - System Agent (dSeries)


User installed the patch OA (Oracle E- Businees Suite) and jobs result in these error(s):

04/29/20XX 16:23:07.832 WEST+0100 3 OAPlugin.oa Internal Thread.OaDbHandler.submitRequest[:723] - call fnd_request.submit_request( CA, XXXX_XXXX_XX, 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 XXXXXSAPPPRD01 JavaAgent#tcpip@MANAGER



Agents versions 11.3.4


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. 


The cyber_oa_pkg package is installed.