My Oracle Support Banner

AIF: Gross Margin is NULL (Doc ID 2971738.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

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

Goal

After loading the Sales into RI and then moving the data to RSE and CIS using the Master_Adhoc jobs, the Sales U , R , AUR are visible in the CIS application but Gross Margins are null.

The Sales Files loaded has these columns :
ITEM
ORG_NUM
DAY_DT
MIN_NUM
RTL_TYPE_CODE
SLS_TRX_ID
SLS_QTY
SLS_AMT_LCL
LOC_CURR_CODE
DOC_CURR_CODE

It does not have any data for the column : SLS_PROFIT_AMT_LCL .

Is it necessary to load a sales file with data in SLS_PROFIT_AMT_LCL to be able to see Gross Margins Data in ASC and RSE ? 
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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