Revision Order Is Fetching Wrong Account If There Is More Than One Account With The Same Name (Doc ID 2964017.1)

Last updated on JULY 28, 2023

Applies to:

Symptoms

Incorrect Account Id getting updated on revise Order if there is more than one Account Present with the same Name and different Site(Location)
 

The issue can be reproduced at will with the following steps:
1. Create 3 Account records with below details
Name = Test; Type = Residential; Site = 1(Example Row Id = 1-ABC)
Name = Test; Type = Residential; Site = 2(Example Row Id = 2-ABC)
Name = Test; Type = Residential; Site = 3(Example Row Id = 3-ABC)
2. Create Order with Account has Row Id = 2-ABC
3. Drilldown on the Order Number and Navigate to the Line Items View Tab
4. Add Product in Line Items
5. Submit the Order
Verify the Account Id by using below sql

6. Click on the Revise Button
7. Execute the same SQL to check the Account Id on Revision Order
Notice that the Account Id is different on the New revision order

Changes

Cause

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