Opening Scoring Model Page Results in oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation (Doc ID 2193921.1)

Last updated on OCTOBER 17, 2016

Applies to:

Oracle Credit Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Trying to open the Scoring Models page results in an error -

You have encountered an unexpected error. Please contact the System Administrator for assistance
 
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select score_name ScoreName,to_char(Total) , avg(risk_factor10) risk_factor10,avg(risk_factor20) risk_factor20,avg(risk_factor30) risk_factor30,

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms