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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Why do we get JBO-27123: SQL error

Summary:


Why do we get JBO-27123: SQL error

Content (please ensure you mask any confidential information):

Hi Team,

Greetings!

We have observed that the payroll flow (using HCM Extract) has been ending with Completed with Alert status.

There is no data shown for the error message but the log file has below error-

JBO-27123: SQL error during call statement preparation. Statement: BEGIN DBMS_APPLICATION_INFO.READ_MODULE(:1,:2); END;

This issue is found for the flows submitted with the different set of users i.e. the issue is not due to any setup for the submitter user.

Is there any defined root cause for JBO-27123: SQL error?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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