Discount Is Not Getting Triggered (Doc ID 2158491.1)

Last updated on FEBRUARY 01, 2024

Applies to:

Symptoms

On :  7.5.0.6.0 version, Conversion Manager

ACTUAL BEHAVIOR  
---------------
No Discounts were getting trigger because of the value “-1” of group_obj_id0 field is missing.


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>
where
XML_FILENAME - xml filename
STAGE_ID - number to be given (Example:25)

Step 2:
Check in DB with 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)

 

Changes

Cause

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