CMT - Discount Is Not Getting Triggered. (Doc ID 2158491.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On :  7.5.0.6.0 version, Conversion Manager

ACTUAL BEHAVIOR  
---------------
No Discounts were not getting trigger because of the following issue.

The value “-1” of group_obj_id0 field is missing, leading to miss the discounting process at subscriber level.


EXPECTED BEHAVIOR
-----------------------
-1 value of group_obj_id0 field should be present and discount should be triggered.

STEPS
-----------------------
Step 1: Run pin_cmt command: ./pin_cmt -import -file <XML_FILENAME> <STAGE_ID>
XML_FILENAME - xml filename
STAGE_ID - number to be given (Example:25)

Step 2: Check in DB for sql: select * from ORDERED_GROUPS_T where OBJ_ID0 in(select POID_ID0 from ORDERED_BALGROUP_T
WHERE ACCOUNT_OBJ_ID0 IN(SELECT POID_ID0 FROM ACCOUNT_T WHERE ACCOUNT_NO='ACCOUNT_NUMBER'));


No default /group/sharing/discounts entry for which group_obj_id0=-1 is present. (which is expected)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot migrate Discounting information.

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