My Oracle Support Banner

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

Last updated on MARCH 13, 2019

Applies to:

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


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:

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.