Fixed Merchandise Deal Batch Does Not Post Income Correctly To GL If A Department Has No Items For The Vendor On The Deal

(Doc ID 2218780.1)

Last updated on DECEMBER 30, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.0.6 to 13.0.7 [Release 13.0]
Information in this document applies to any platform.


Fixed merchandise deal batch [dealfinc] does not post income correctly to General Ledger (GL) if any department on the deal does not have items for the vendor chosen.

Steps to Reproduce:

  1. Create a new fixed deal.
  2. Select a vendor and two departments where vendor has some items for one department and no items for a second department.
  3. Run the dealfinc batch program.
  4. Verify the stg_fif_gl_data and fixed_deal_gl_ref_data tables.
  5. Note the total deal income produced is less and also  duplicate records are inserted for same reference_trace_id in fixed_deal_gl_ref_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