Incorrect Supplier Site Id On IM_AP_STAGE_HEAD Table (Doc ID 3066880.1)

Last updated on JANUARY 10, 2025

Applies to:

Symptoms

Supplier 61115, that has a few child supplier sites, e.g. 1000847, 2825, etc.

Created an invoice against a supplier site id 1000847, and matched against a PO receipt. The invoice got posted and a record got created in IM_AP_STAGE_HEAD table with Oracle_Site_id = 2825. It should have used site id 1000847 (i.e. same as that on the invoice).

NOTE: The PO is raised against a completely different Supplier. (i.e. Supplier/Site = 61114/9550). Used Supplier Groups functionality to match this PO receipt against the Invoice.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. PO receipt for supplier/site 61114/9550
2. Invoice created for supplier/site 61115/1000847
3. Supplier 61115 has multiple sites within it.
4. Configure Supplier Groups to allow Receipt from 61114 to match against Invoice from 61115.
5. Run Automatch & Posting

Expected result:
IM_AP_STAGE_HEAD must get a record with Oracle_site_id = 1000847

Actual Result
IM_AP_STAGE_HEAD has a record with Oracle_site_id = 2825

Cause

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