GIFT_WRAP_IND For L3 Items Is Not Defaulting from L2 Item Via Item Induction or XITEM

(Doc ID 2366013.1)

Last updated on MARCH 05, 2018

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.

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

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