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)