Error While Opening Existing Collection Strategy Group in Setup Checklist

(Doc ID 1989080.1)

Last updated on MARCH 15, 2016

Applies to:

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

Symptoms

You are receiving an unexpected error page while clicking on the Strategy template in the Strategy template setup page.

ERROR
 
You have encountered an unexpected error. Please contact the
  System Administrator for assistance.

 

Review of the Java error indicates the following select is failing:

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)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Collection Administrator > setup checklist> Create collection strategy
2. Click to view any strategy templates
3. Receive Error Page: You have encountered an unexpected error. Please contact the
     System Administrator for assistance.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot review strategy templates.

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