W_RTL_SLS_TRX_TMP.TAX_AMT CALCULATION is INCORRECT
Last updated on NOVEMBER 09, 2017
Applies to:Oracle Retail Merchandising Insights - Version 13.2.4 and later
Information in this document applies to any platform.
Net tax in Retail Analytics (RA) Sales Fact is calculated on the basis of Vat_type='C' instead of 'R'. (VAT = Value Added Tax), which causes Tax amount as null for few items in Sales transaction fact/aggregates in the OBIE reports.
Steps to Recreate:
- Run SDE_RETAIL_SALESTRANSACTIONFACT
- Verify the data in RA_DATA_MART.W_RTL_SLS_IT_LC_DY_A
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 hundreds of Community platforms