My Oracle Support Banner

VPN Not Cascading To Child Items On Item Creation Through Induction (Doc ID 3066667.1)

Last updated on JANUARY 09, 2025

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

 

The VPN is not cascading to child items on Item creation through induction even though CASCADE_IUD_ITEM_SUPPLIER in CORESVC_ITEM_CONFIG is set to Y.

Testing was done for creation of 3 level item through ods file where VPN was set for the level 1 parent item only in the ods file. When loaded, only the VPN for present only for Style and not for the child items.


Steps to Reproduce :
--------------------


1. Tasks - Items - Download Items from RMS - Template itemmaster
                                                                                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                                                                                                
select * from rms01.svc_item_supplier where  process_id=1810108;
 

PROCESS_ID CHUNK_ID ROW_SEQ ACTION PROCESS$STATUS ITEM SUPPLIER PRIMARY_SUPP_IND VPN SUPP_LABEL CONSIGNMENT_RATE SUPP_DIFF_1 SUPP_DIFF_2 SUPP_DIFF_3 SUPP_DIFF_4 PALLET_NAME CASE_NAME INNER_NAME SUPP_DISCONTINUE_DATE DIRECT_SHIP_IND CONCESSION_RATE PRIMARY_CASE_SIZE CREATE_ID CREATE_DATETIME LAST_UPD_ID LAST_UPD_DATETIME DEFAULT_EXPENSE_PROFILES REFRESH_EXPENSES_FROM_PROFILES
 1810108 1000001 2 NEW P 6003 2400 Y TEST test           PAL CS INR   N     RETAIL.USER 15/11/2024 RETAIL.USER      
 1810108 4000001 3 NEW P 60031 2400 Y               PAL CS INR   N     RETAIL.USER 15/11/2024 RETAIL.USER      
 1810108 6000001 4 NEW P 600311 2400 Y               PAL CS INR   N     RETAIL.USER 15/11/2024 RETAIL.USER      
 1810108 6000001 5 NEW P 500312 2400 Y               PAL CS INR   N     RETAIL.USER 15/11/2024 RETAIL.USER      


2. see the results in item_supplier table

select * from rms01.item_supplier where item in ('6003','60031', '600311','600312'); 

 

ITEM SUPPLIER PRIMARY_SUPP_IND VPN SUPP_LABEL CONSIGNMENT_RATE SUPP_DIFF_1 SUPP_DIFF_2 SUPP_DIFF_3 SUPP_DIFF_4 PALLET_NAME CASE_NAME INNER_NAME SUPP_DISCONTINUE_DATE DIRECT_SHIP_IND CREATE_DATETIME LAST_UPDATE_DATETIME LAST_UPDATE_ID CONCESSION_RATE PRIMARY_CASE_SIZE CREATE_ID
6003 2400 Y TEST test           PAL CS INR   N 15-Nov-24 15-Nov-24 RETAIL.USER     RETAIL.USER
60031 2400 Y   test           PAL CS INR   N 15-Nov-24 15-Nov-24 RETAIL.USER     RETAIL.USER
600311 2400 Y   test           PAL CS INR   N 15-Nov-24 15-Nov-24 RETAIL.USER     RETAIL.USER
600312 2400 Y               PAL CS INR   N 15-Nov-24 15-Nov-24 RETAIL.USER     RETAIL.USER

                                                                                                                                                                                                                                                                                                           


The VPN "TEST" is not inherited to the level 2/3 items.
This was expected with the parameter CASCADE_IUD_ITEM_SUPPLIER=Y,

 

 

Changes

 

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
Changes
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.