My Oracle Support Banner

Price Item Relationships not Available on the Price Item Screen (Doc ID 2580008.1)

Last updated on AUGUST 26, 2019

Applies to:

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

Symptoms

On RMB v2.7.0.1.0 version, Price Item Relationships not available on the Price Item UI.

ACTUAL BEHAVIOR
------------------------------
The Price Item Relationship section does not reflect any Price Item relationships.

The Zone Query is as under:

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) ND 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]A


EXPECTED BEHAVIOR
-----------------------------------
The Price Item Relationship should be in Price Item UI screen.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Navigate as Menu --> 1. Navigate to the Price Item screen as under:
2. Click on the hyperlink under the Price Item Information Column from the Search Price item results section.
3. The selected price item details are populated on the Price Item UI. The UI is populated with all the underlying setup made for the Price item in sections as under:
- Price Items
o Main
o Price Item Characteristics
o Record Actions
o Record Information

- Parameters
- Divisions
- Price Item Relationship
4. The Price Item Relationship section does not reflect any Price Item relationships. However, the relationships are correctly reflected on the Price Item Relationship – Add/Edit.

BUSINESS IMPACT
-----------------------------
The issue has the following business impact:
Incorrect system behavior. Workaround available, but still need a permanent solution.

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.