My Oracle Support Banner

FIFGLDN2 Batch Is Treating -ve Sales Amount From Tran_data As +ve in STG_FIF_GL_DATA (Doc ID 2880731.1)

Last updated on JANUARY 10, 2024

Applies to:

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

Goal

FIFGLDN2 batch is treating negative Sales amount from TRAN_DATA as positive in rollup to DEPT level to populate STG_FIF_GL_DATA

Example:

TRAN_DATA:

DEPT LOCATION LOCATION SUM(TOTAL_RETAIL)
660 1068 -14


STG_FIF_GL_DATA:

ATTRIBUTE1 ATTRIBUTE4 SUM(ENTERED_DR_AMOUNT)
660 1068 14



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!


In this Document
Goal
Solution


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