My Oracle Support Banner

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.

Symptoms


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 25423391
--Bug 26529498 added the join to consider the account_ID
CURSOR c_site_use IS
  SELECT site_use_id
  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
-----------------------

Error messages from Order Management
Validation failed for the field - Customer Location
There is an error in order submission



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order with an inactive site
2. Submit order
3. Error

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
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.