Received ORDER_TYPE As 'F - Fixed' In The File But Base Table Loaded With 'V - Variable'
(Doc ID 2835222.1)
Last updated on JANUARY 25, 2022
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.
Received ORDER_TYPE as 'F - Fixed' in the file but base table loaded with 'V - Variable'
The ORDER_TYPE column in ITEM_MASTER table has the value 'F' in the file as well as the SVC table, but has been loaded with 'V' in base table when the SALE_TYPE is 'L'.
It is expected that the data should be loaded with the same ORDER_TYPE as stated in the file.
1.Login to DC tool.
2.Load the dc_item file via DC Tool using 'DC_ITEM' entity.
3.Proceed with 'Import' step of DC Tool, post which you'll be able to see the data in the SVC table (rdc01.svc_item_master).
4.Using this query, the order_type can be verified in the staging table and make a note of it.
7.Compare the query results of Step 4. and Step 6. (change in order_type values can be seen).
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