My Oracle Support Banner

Gl_REF_NO Not Being Populated For All Inventory Adjustment Records (Doc ID 1267143.1)

Last updated on DECEMBER 28, 2019

Applies to:

Oracle Retail Merchandising System - Version 13 and later
Information in this document applies to any platform.


After creating a transfer that is short received by the receiving location, a TRAN_DATA.TRAN_CODE '22'  is created in the stock ledger, but the TRAN_DATA.GL_REF_NO  is NULL.

Steps To Reproduce:
1) Create a transfer
2) Ship the transfer
3) Short receive the transfer in the receiving location
4) Check the TRAN_DATA table and observe that the TRAN_CODE '22' records for the adjusted quantity will have GL_REF_NO as NULL.

FIFGLDN2 batch job is failing due to the above error, as there is no mapping.




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.