Fifgldn3.pc Batch is Not Posting Records to STG_FIF_GL_DATA Table for Tran_Code 23

(Doc ID 1991122.1)

Last updated on MARCH 30, 2017

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.




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms