Retail Insights: Few Queries On System Options (C_ODI_PARAM) (Doc ID 3002477.1)

Last updated on FEBRUARY 06, 2024

Applies to:

Goal

Retail Insights: Few queries on system options (C_ODI_PARAM)

1. RI_INV_HIST_DAYS - Is it to delete the record having zero stock on hand from the related tables? Please help on tables as well.
2. LY_SHIFT_TYPE - What is the significance or meaning of these values 'UNSHIFT, SHIFT, for fiscal calendar and GUNSHIFT' for Gregorian calendar?
3. ITEM_GRP1_IS_INCREMENTAL - If this parameter is set to N and loaded the initial data multiple times with/without any variance , then every time will the data get overridden that means the existing data will be deleted and new data will be loaded?
4. RI_INT_ORG_DS_MANDATORY_IND - Is this required to load the data through files using file transfer? And is it applicable to v23 and what value should be set?
5. RI_PROD_DS_MANDATORY_IND - Is this required to load the data through files using file transfer? And is it applicable to v23 and what value should be set?
6. HIST_ZIP_FILE - Is this required to load the data through files using file transfer? If not loading the data through files, then can this be null?
7. RI_AGG_FULL_LOAD_TYPE - What is aggregation utility and what is the significance/meaning of F.FS,FE,NA?
8. IS_INCREMENTAL - What is the significance or meaning of this parameter? What should be its value while Initial load and daily delta load?
9. WHOLESALE_CHANNEL - The mentioned parameter is not available in the system, whereas we found new parameter
10. RA_SRC_STORE_TYPE_WHOLESALE added with value 'Wholesale'. Please find attached the screenshot. Is it correct? What is its significance and what should be valid values?
11. RA_SLS_TAX_IND -If it is set to Y, then it will have sales retail excluding VAT, as per the description, but still can we get sales retail inclusive VAT from some table within RI? And it applies at transaction level or at aggregate level by item/location?
 

Solution

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