My Oracle Support Banner

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 later
Information in this document applies to any platform.


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’.




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

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