Reimcomplexdealupload Batch Creates Deal Documents With Order Number as Zero Instead of Null Value

(Doc ID 2296285.1)

Last updated on AUGUST 15, 2017

Applies to:

Oracle Retail Invoice Matching - Version 16.0 and later
Information in this document applies to any platform.


Reimcomplexdealupload batch is creating debit memo with ORDER_NO as 0 even though STAGE_COMPLEX_DEAL_DETAIL table has a null value. This is causing failure during posting of debit memo.

Steps to Recreate:
1. Create a bill back rebate complex deal.
2. Create multiple orders after deal becomes active.
3. Run all deal batches including vendinvc batch. Notice that data gets created in staging tables STAGE_COMPLEX_DEAL_HEAD and STAGE_COMPLEX_DEAL_DETAIL with ORDER_NO as null.
4. Run reimcomplexdealupload batch and notice that debit memo created with ORDER_NO as 0 instead of null value.


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