My Oracle Support Banner

ORMB Price Item Screen Does Not Show Records In Relationship Zone (Doc ID 2668241.1)

Last updated on MAY 12, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.8.0.0.0 version

ACTUAL BEHAVIOR
---------------
ORMB Price Item Screen does not show records in relationship zone, a blank zone appears, however when we click on Add/Edit hyperlink, it shows data.

It looks like SQL used in Zone should not have CI_PRODUCT table or should be used as outer join or a separate SQL with Union to add CI_RPODUCT table feature

SELECT DISTINCT a.PRICEITEM_CHLD_CD, a.PRICEITEM_PAR_CD, a.START_DT, a.END_DT, a.PRICEITEM_REL_TYPE_FLG, d.DESCR as relTypeDesc, l.descr as priceItemDesc,p.BUNDLE_TYPE_FLG,
FN_GET_PRICE_PARM_INFO_STRING(null,a.PRICEITEM_CHLD_CD ,a.START_DT,a.PRICEITEM_PARM_GRP_ID) as PRICING,PD.PROD_BUNDLE_TYPE_FLG
FROM CI_PRICEITEM_REL a, CI_LOOKUP d, CI_PRICEITEM_L l, CI_PRICEITEM p, C1_PRODUCT PD
WHERE 1=1
AND a.PRICEITEM_REL_TYPE_FLG = d.FIELD_VALUE
AND d.FIELD_NAME = 'PRICEITEM_REL_TYPE_FLG'
AND D.LANGUAGE_CD = :LANGUAGE
AND a.PRICEITEM_PAR_CD=:H1
AND l.priceitem_cd = a.priceitem_chld_cd AND l.language_cd = :LANGUAGE
AND p.PRICEITEM_CD = a.PRICEITEM_PAR_CD
AND PD.PROD_BUNDLE_TYPE_FLG = P.PRICE_ITEM_TYPE_FLG
[(F1) AND a.PRICEITEM_CHLD_CD like UPPER(:F1)]
[(F2) AND l.DESCR like(:F2)]
[(F3) AND a.START_DT >= NVL(:F3,a.START_DT)]
[(F4) AND a.PRICEITEM_REL_TYPE_FLG = :F4]
[(PAGENEXT) and a.PRICEITEM_CHLD_CD > :C2]
[(PAGEPREV) and a.PRICEITEM_CHLD_CD < :C2]

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
Cause
Solution
References


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