My Oracle Support Banner

ReSA Totals Without Rollup3 Definition Have ATTRIBUTE5 Populated in STG_FIF_GL_DATA (Doc ID 2879415.1)

Last updated on JUNE 27, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information 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:

  1. Total GUS_SLT_S does NOT have a Rollup3 defined in the total definition.
  2. The SA_GL_CROSS_REF.ATTRIBUTE5_MAP is NULL for the total_id GUS_SLT_S.
  3. ReSA total table (SA_TOTAL) has REF_NO3 populated as NULL.
  4. 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


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