Receiptwriteoff Batch Changes SHIPMENT.INVC_MATCH_STATUS to 'C' Even When Batch Aborts With an Error

(Doc ID 2421030.1)

Last updated on JULY 19, 2018

Applies to:

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

Symptoms

Reimreceiptwriteoff batch is changing INVC_MATCH_STATUS to 'C' for receipts which are eligible for write-off though write-off posting fails for valid reason.

Steps to Recreate:
1. Ensure that there are few receipts eligible for write-off by using below query. Also, ensure that write-off postings fail due to valid reason.
    SELECT s.shipment, s.receive_date, s.order_no, s.bill_to_loc, o.supplier,
               o.currency_code, o.exchange_rate
    FROM shipment s, period p, ordhead o, v_im_supp_parent_attrib_expl so,
             im_system_options sys, sups su
    WHERE s.order_no = o.order_no AND o.supplier = su.supplier
    AND vdate >= ( s.receive_date + DECODE(nvl(so.close_open_shipment_days,0), 0, sys.close_open_receipt_days, so.close_open_shipment_days ) )
    AND s.receive_date IS NOT NULL
    AND s.status_code IN ('R','U','C')
    AND nvl(s.invc_match_status, 'U') = 'U'
    AND nvl(su.supplier_parent, su.supplier) = so.supplier;

2. Run the receipt write off batch, notice that INVC_MATCH_STATUS for receipts was changed to 'C' though write-off postings fail for valid reason.

3. Notice that no entries are posted into IM_FINANCIALS_STAGE table for the above receipts which is an issue.

Changes

 

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