Receiptwriteoff Batch Changes SHIPMENT.INVC_MATCH_STATUS to 'C' Even When Batch Aborts With an Error
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.
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,
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.
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