IM_FINANCIALS_STAGE Table Was Populated Incorrectly When Posting an Invoice Within Detail Level Tolerance (Doc ID 1268150.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

In Oracle Retail Invoice Matching (ReIM) 12.0.x, when matching an invoice to a receipt that is outside of summary level tolerance but within detail level tolerance, the IM_FINANCIALS_STAGE table is populated with incorrect amounts.


Steps to Reproduce:

    Condition: Create a PO for Supplier 73851, Location 1917
    PO and Receipt Total Cost = 21115, Total Qty = 15
    Invoice Total Cost = 16880, Total Qty = 12

    Item A 100001901, UnitCost = 1299, Qty = 5
    Item B 100001908, UnitCost = 1099, Qty = 5
    Item C 100001909, UnitCost = 1825, Qty = 5
    Total Cost = 21115, Total Qty = 15

    Create Receipt:
      Item A Qty = 5,
      Item B Qty = 5,
      Item C Qty = 5.
      Total Cost = 21115, Total Qty = 15

    Create Invoice: (make Invoice date 'ReIM virtual date - number of 'Discrepancy days before routing', so that when automatch is run it will do Summary Match then Detail Match immediately)
      Item A, UnitCost = 1298, Qty = 4
      Item B, UnitCost = 1098, Qty = 4
      Item C, UnitCost = 1824, Qty = 4
      Total Cost = 16880, Total Qty = 12

    Use the following tolerance setting in Retail Invoice Matching (ReIM):
    In System Tolerance Maintenance: Tolerance Level: System, Lower Limit 0, Upper Limit 1 billion.

    Summary Qty: 0 favor of Rtlr
    Summary Qty: 0 favor of Supplier
    Summary Cost: $1 favor of Rtlr
    Summary Cost: $1 favor of Supplier

    Line Item Qty: $1 favor of Rtlr
    Line Item Qty: $1 favor of Supplier
    Line Item Cost: $1 favor of Rtlr
    Line Item Cost: $1 favor of Supplier



Steps to Reproduce:

1. Log in to ReIM.
2. Invoice is sent into ReIM and in 'Ready to Match' status.
3. Run AutoMatch batch.
4. Click on 'Document Maintenance' tab, click on ' Document Search'.
5. Select 'Merchandise Invoice' from 'Document Type' drop-down, enter invoice number into 'Document ID' field, click on 'Search'.
6. Invoice is retrieved with status of 'Matched'.
7. Run Posting batch.
8. Log in to Oracle Database and run query:

select AMOUNT, TRAN_CODE, DEBIT_CREDIT_IND, ORDER_NO from IM_FINANCIALS_STAGE WHERE VENDOR = 73851 and ORDER_NO = PO #
--------------------------------------------------------------------------------------------------
"AMOUNT" "TRAN_CODE" "DEBIT_CREDIT_IND" "ORDER_NO"
21112    "UNR"       "DEBIT"            5316972
4232     "VWT"       "CREDIT"           5316972
16880    "TAP"       "CREDIT"           5316972

--------------------------------------------------------------------------------------------------


Expected Results: 

UNR should be 21115, which is the receipt amount, not 21112; the number is off by 3.  VWT should be 4235, instead of 4232.

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