Cannot Open Strategy Template - JBO Errors

(Doc ID 2041802.1)

Last updated on FEBRUARY 07, 2017

Applies to:

Oracle Advanced Collections - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Opening a Strategy Template in the Setup Checklist results in the following error:


oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT IEXStrategyGroupsEO.GROUP_NAME,
  IEXStrategyGroupsEO.ENABLED_FLAG,
  IEXStrategyGroupsEO.GROUP_ID,
IEXStrategyGroupsEO.CATEGORY_TYPE,
  IEXStrategyGroupsEO.CHECK_LIST_YN,
  IEXStrategyGroupsEO.CHECK_LIST_TEMP_ID,
  IEXStrategyGroupsEO.VALID_FROM_DT,
  IEXStrategyGroupsEO.VALID_TO_DT,
  IEXStrategyGroupsEO.OBJECT_FILTER_ID,
  IEXStrategyGroupsEO.STRATEGY_LEVEL,
  IEXStrategyGroupsEO.CHANGE_STRATEGY_YN,
  IEXStrategyGroupsEO.SCORE_TOLERANCE,
  IEXStrategyGroupsEO.SCORING_ENGINE_ID
  ,lookups.meaning categorytype_meaning
  ,checklist.strategy_name checklisttemplate_name
  ,lookups1.meaning strategylevel_meaning
FROM IEX_STRATEGY_TEMPLATE_GROUPS IEXStrategyGroupsEO
,iex_lookups_v lookups
,iex_strategy_templates_vl checklist
,iex_lookups_v lookups1
where
IEXStrategyGroupsEO.CATEGORY_TYPE=lookups.lookup_code
and lookups.lookup_type ='IEX_DELINQUENCY_STATUS'
and checklist.strategy_temp_id(+)=IEXStrategyGroupsEO.CHECK_LIST_TEMP_ID
and lookups1.lookup_type ='IEX_STRATEGY_LEVEL'
and IEXStrategyGroupsEO.STRATEGY_LEVEL=lookups1.lookup_code) QRSLT WHERE (GROUP_ID = :1)



## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

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