My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.