You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Multiple Extracts ending in error JBO-27123: SQL error during call statement preparation

Summary:

Multiple Extracts ending in error JBO-27123: SQL error during call statement preparation

Content (please ensure you mask any confidential information):

Hi Team,

Greetings!

Have any one come across the error in HCM Extract flow run as-JBO-27123: SQL error during call statement preparation

Complete error message as shown below -

Resumed TRUE
Post Processing
Unknown Failure
JBO-27123: SQL error during call statement preparation. Statement: BEGIN DBMS_APPLICATION_INFO.READ_MODULE(:1,:2); END;
oracle.jbo.server.DBTransactionImpl.createCallableStatement(DBTransactionImpl.java:3994)
oracle.jbo.server.DBTransactionImpl2.createCallableStatement(DBTransactionImpl2.java:387)
oracle.apps.hcm.batchProcesses.core.util.PayCallableStatement.<init>(PayCallableStatement.java:32)
oracle.apps.hcm.batchProcesses.core.util.PayPrepStatement.getCallableStatement(PayPrepStatement.java:488)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!