R12.2 AR Credit Management - Cannot Create/update Credit Application And Case Folder
(Doc ID 2670252.1)
Last updated on JANUARY 28, 2022
Applies to:
Oracle Credit Management - Version 12.2.9 and later Information in this document applies to any platform.
Symptoms
On : 12.2.9 version, General Issues
When attempting to create a credit application or update an existing case folder, the following error occurs.
ERROR ----------------------- Exception Details. oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT AR_CMGT_WF_ENGINE.get_credit_limit(:1, 'P') OVERALL_CREDIT_LIMIT FROM DUAL at oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3383) at oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:4022)
## Detail 0 ## java.sql.SQLException: ORA-04063: package body "APPS.AR_CMGT_WF_ENGINE" has errors at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
Steps to Reproduce: The issue can be reproduced at will with the following steps: Responsibility: Credit Management Create a new credit application or update an existing case folder and get the java error.
BUSINESS IMPACT ----------------------- The issue has the following business impact: Due to this issue, users cannot create a new credit application or update an existing case folder.
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!