Istore Sold To Site Validation Error Due To Party Site Assigned To Multiple Ous.
(Doc ID 2615005.1)
Last updated on NOVEMBER 27, 2019
Applies to:Oracle iStore - Version 12.2.8 and later
Information in this document applies to any platform.
Istore sold to site validation error due to party site assigned to multiple ous.
Recently upgraded to 12.2.8. Needed to start mapping SOLD_TO_PARTY_SITE_ID in order for sold to site use (customer location to map on sales orders). There is a bug in the ASO_ORDER_INT package that does not account for a party site being assigned to more than one OU.
Here is the cursor causing the issue.
--Bug 26529498 added the join to consider the account_ID
CURSOR c_site_use IS
FROM hz_cust_site_uses_all a
WHERE CUST_ACCT_SITE_ID = (select CUST_ACCT_SITE_ID from HZ_CUST_ACCT_SITES_ALL b
WHERE PARTY_SITE_ID = p_qte_rec.SOLD_TO_PARTY_SITE_ID and org_id = p_qte_rec.org_id and CUST_ACCOUNT_ID = p_qte_rec.CUST_ACCOUNT_ID and status = 'A')
AND SITE_USE_CODE = 'SOLD_TO';
as you can see it does not consider if the site use is active and in the correct org_id.
Error messages from Order Management
Validation failed for the field - Customer Location
There is an error in order submission
The issue can be reproduced at will with the following steps:
1. Order with an inactive site
2. Submit order
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