My Oracle Support Banner

FIFGLDN2 Fails Per TRAN_DATA.GL_REF_NO Null For TRAN_CODE 65 With TRAN_CODE 87 (Doc ID 2906702.1)

Last updated on NOVEMBER 02, 2022

Applies to:

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


When there is a stock load, tran  code 65 is created with the 87 but does not have the GL_REF_NO and puts NULL in the transaction which causes a failure in the fifgldn2.pc program in the night batch.

 Steps to recreate: 

  1. Create an RTV and fill in the "Restocking Fee" data by adding the Item in the Add Items option
  2. Approve and Embark the RTV
  3. Note that the value of the field TRAN_DATA.GL_REF_NO is null for the TRAN_CODE = 87 generated by the TRAN_CODE = 65
  4. Run the process fifgldn2
  5. Observed the batch failed with the error.


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.