My Oracle Support Banner

REIM Allows Same Invoice Number For a Same Supplier And Site When Create an Obligation (Doc ID 2593467.1)

Last updated on SEPTEMBER 30, 2019

Applies to:

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

Symptoms

Retail Invoice Matching (ReIM) allows same invoice number for a same supplier and site when creating an Obligation.

Steps To Recreate :

  1. Create a PO in Retail Merchandising Systems (RMS) .
  2. Create shipment and receipt in RMS.
  3. Create a Merchandise invoice and invoice is in RMTCH status.
  4. Created an Obligation (ASN Shipment level) for the Order. Use same supplier and supplier site which used in merchandise invoice.
  5. Obligation is approved.
    Note : Give the invoice number while creating Obligation in such a way that REIM created invoice and Obligation invoice both should have the same invoice number.
  6. Executed reim injector batch.
  7. Invoice loaded in APPRVE status in IM_DOC_HEAD.
    Now, for a same supplier, supplier site - there are two invoices in IM_DOC_HEAD with same invoice number (ext_doc_id).
  8. Match the Merchandise invoice and invoice is matched in REIM.
  9. Executed the necessary ReIM jobs.
  10. Both the invoice status is POSTED and records in IM_AP_STAGE_HEAD and DETAIL.

      Noticed that Merchandise & Non Merchandise Invoice with same ext_doc_id and ReIM system is allowing the same and posting the same into Account Payables (AP) stage tables.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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