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)