My Oracle Support Banner

Reimcomplexdealupload Batch Creates Deal Documents With Order Number as Zero Instead of Null Value (Doc ID 2296285.1)

Last updated on MARCH 03, 2019

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.


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.