My Oracle Support Banner

Cannot Open Strategy Template - JBO Errors (Doc ID 2041802.1)

Last updated on FEBRUARY 22, 2019

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

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.