ReSA Totals Without Rollup3 Definition Have ATTRIBUTE5 Populated in STG_FIF_GL_DATA
(Doc ID 2879415.1)
Last updated on JANUARY 15, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and laterInformation in this document applies to any platform.
Symptoms
ReSA totals, which do not have any rollup3 defined, have ATTRIBUTE5 populated in STG_FIF_GL_DATA extract file.
The behavior is not consistent for all such totals.
Also, for the same store-day, total_id some records have ATTRIBUTE5 populated while other records have it as NULL.
Steps to Recreate:
- Total GUS_SLT_S does NOT have a Rollup3 defined in the total definition.
- The SA_GL_CROSS_REF.ATTRIBUTE5_MAP is NULL for the total_id GUS_SLT_S.
- ReSA total table (SA_TOTAL) has REF_NO3 populated as NULL.
- The GL Extract file from Oracle has ATTRIBUTE5 populated as ‘MPC’.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |