My Oracle Support Banner

Data Conversion - ITEM_SUPP_COPUNTRY_LOC Not Generated For Domestic Items (Doc ID 2786464.1)

Last updated on AUGUST 06, 2021

Applies to:

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

Symptoms

Records not generated for domestic items in table ITEM_SUPP_COPUNTRY_LOC

Steps to replicate:
1- Prepare dat files for ITEM_MASTER, ITEM_SUPPLIER, ITEM_SUPP_COUNTRY for 2 items
cat item_supp_country.dat
1000003,2200,US,10,1,2,1,1,C,50,50,50,50,,,FLAT,Y,Y,EA,1,1,,,,,,,EA,,,,,,,0,,,,
1000004,2500,CN,5,1,2,1,1,C,50,50,50,50,,,FLAT,Y,Y,EA,1,1,,,,,,,EA,,,,,,,0,,,,

1st item for country with the same currency as system base currency
2nd item is for a foreign country different currency

2- Load items
3- Prepare NIL file for both items as below:
$ cat nil_detail.dat
1000003,S,1211,2200,US,<item_desc>,A,E,,Y,1,1,,<item_desc>,,,,N,S,,10,EA,0,,,Y,N
1000003,S,1111,2200,US,<item_desc>,I,E,,Y,1,1,,<item_desc>,,,,N,S,,12,EA,0,,,Y,N
1000003,W,10001,2200,US,<item_desc>,A,E,,Y,1,1,,<item_desc>,,,,N,S,,10,EA,0,,,Y,N
1000003,W,10002,2200,US,<item_desc>,A,E,,Y,1,1,,<item_desc>,,,,N,S,,8,EA,0,,,Y,N
1000004,S,1211,2500,CN,<item2_desc>,A,E,,Y,1,1,,<item2_desc>,,,,N,S,,100,EA,0,,,Y,N
1000004,S,1111,2500,CN,<item2_desc>,I,E,,Y,1,1,,<item2_desc>,,,,N,S,,120,EA,0,,,Y,N
1000004,W,10001,2500,CN,<item2_desc>,A,E,,Y,1,1,,<item2_desc>,,,,N,S,,100,EA,0,,,Y,N
1000004,W,10002,2500,CN,<item2_desc>,A,E,,Y,1,1,,<item2_desc>,,,,N,S,,80,EA,0,,,Y,N

result:
No records for 1st item in ITEM_SUPP_COUNTRY_LOC table
V_ITEM_SUPP_COUNTRY_LOC has unit cost as 10 for all locations, though ITEM_LOC_SOH has the correct unit_cost.

expected result
V_ITEM_SUPP_COUNTRY_LOC should reflect the unit costs uploaded in NIL file
exception records should be populated in ITEM_SUPP_COUNTRY_LOC

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