My Oracle Support Banner

ReIM: ORACLE_SITE_ID Is Incorrectly Populated In IM_AP_STAGE_HEAD (Doc ID 2554410.1)

Last updated on DECEMBER 05, 2019

Applies to:

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

Symptoms

If a supplier has two or more supplier sites, while posting the invoice, Retail Invoice Matching (ReIM) does not validate the supplier site used when the invoice is created and instead uses some random site for that supplier.

Steps to Reproduce:
1. Select a supplier that has at least 2 supplier sites.
2. Ensure all the supplier sites (from step 1) have 06 ADDR setup in ADDR table (REMITTANCE ADDRESS).
3. Create a Non Merchandise Invoice (NMRCHI) for supplier site 1. Do not enter any order Number. The Invoice will get created in Approved status.
4. Create a Non Merchandise Invoice for supplier site 2, ensure that the same location and cost is used as the previous NMRCHI. Do not enter any order Number. The Invoice will get created in Approved status.
5. Run the posting batch.

Observe both the invoices created show data in IM_AP_STAGE_HEAD.ORACLE_SITE_ID for supplier site 2.

 

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!


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