Error When Creating Dunning Plans (Doc ID 1377840.1)

Last updated on FEBRUARY 23, 2015

Applies to:

Oracle Advanced Collections - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms


Encountered message " You have encountered an expected error. Please contact the System Administrator for assistance".

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM
(SELECT
IexDunningPlansEO.DUNNING_PLAN_ID as DUNNING_PLAN_ID,
IexDunningPlansEO.START_DATE as START_DATE,
IexDunningPlansEO.END_DATE as END_DATE,
IexDunningPlansEO.ENABLED_FLAG AS ENABLED_FLAG,
IexDunningPlansEO.AGING_BUCKET_ID AS AGING_BUCKET_ID,
IexDunningPlansEO.SCORE_ID AS SCORE_ID,
IexDunningPlansEO.NAME AS NAME,
ScoresEO.SCORE_NAME as SCORE_NAME ,
AgingBucketsEO.BUCKET_NAME as BUCKET_NAME ,
IexDunningPlansEO.DUNNING_LEVEL as DUNNING_LEVEL ,
IEXLookupsV.MEANING as MEANING ,
nvl(IexDunningPlansEO.DUNNING_TYPE,'DAYS_OVERDUE') AS DUNNING_TYPE,
IEXLOOKUPSV1.MEANING AS DUNNING_TYPE_MEANING,
IexDunningPlansEO.INCLUDE_CURRENT AS INCLUDE_CURRENT
FROM
IEX_DUNNING_PLANS_VL IexDunningPlansEO,
IEX.IEX_SCORES ScoresEO,
AR.AR_AGING_BUCKETS AgingBucketsEO,
IEX_LOOKUPS_V IEXLookupsV,
IEX_LOOKUPS_V IEXLOOKUPSV1
WHERE IexDunningPlansEO.SCORE_ID = ScoresEO.SCORE_ID(+)
AND AgingBucketsEO.AGING_BUCKET_ID(+) = IexDunningPlansEO.aging_bucket_id
AND IEXLookupsV.LOOKUP_CODE(+) = IexDunningPlansEO.DUNNING_LEVEL
AND IEXLookupsV.lookup_type(+) = 'IEX_RUNNING_LEVEL' AND
IEXLookupsV.ENABLED_FLAG(+) = 'Y'
AND IEXLookupsV1.LOOKUP_CODE(+) =
nvl(IexDunningPlansEO.DUNNING_TYPE,'DAYS_OVERDUE')
AND IEXLookupsV1.lookup_type(+) = 'IEX_DUNNING_PLAN_TYPE' AND
IEXLookupsV1.ENABLED_FLAG(+) = 'Y') QRSLT WHERE (( UPPER(Dunning_Level) =
UPPER(:1) AND (Dunning_Level like :2 OR Dunning_Level like :3 OR
Dunning_Level like :4 OR Dunning_Level like :5))) ORDER BY Name ASC

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