My Oracle Support Banner

Fifgldn3.pc Batch is Not Posting Records to STG_FIF_GL_DATA Table for Tran_Code 23 (Doc ID 1991122.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.2.5 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.


When there are 2 non shortage adjustments (tran_code 23) done for the same item/deptartment/location with different reason codes, the fifgldn3.pc is not posting these records to STG_FIF_GL_DATA table. 

Steps to Reproduce:

  1. Create a non shortage adjustment of 10 units (tran_code 23) for item/department/location with reason code.
  2. Create a non shortage adjustment of -10 units (tran_code 23) for the same item/department/location in step 1 with different reason code.
  3. Run salstage.pc, saldly.pc, salapnd.pc, salweek.pc, salmth.pc batches and close the month.
  4. Run fifgldn3.pc. Notice that there is no posting for the tran_code 23 in STG_FIF_GL_DATA table.


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.