GIFT_WRAP_IND For L3 Items Is Not Defaulting from L2 Item Via Item Induction or XITEM (Doc ID 2366013.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

When attempting to create Level 3 item by having GIFT_WRAP_IND as "Y", the following error occurs.

"L_item= 100550048 L_error_message=Error ORA-20001: Invalid value.GIFT_WRAP_IND,ITEM:100550048 returned by program unit CORESVC_ITEM.PROCESS_CHUNK."

The issue can be reproduced with the following steps:
1. Create Level 1 Item by having gift wrap indicator as Y
2. Create Level 2 Item by having gift wrap indicator as Y
3. Create Level 3 Item by having gift wrap indicator as Y
Note the above error

Due to this issue, you cannot create Level 3 item by having GIFT_WRAP_IND as "Y".

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.