Reimcomplexdealupload Batch is Creating Debit Memo With Order Number as 0 Causing Posting to Fail

(Doc ID 2300869.1)

Last updated on AUGUST 28, 2017

Applies to:

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

Symptoms

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.

Cause

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