Reimcomplexdealupload Batch Creates Deal Documents With Order Number as Zero Instead of Null Value
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