Duplicate Site Uses Created when API has loop (Doc ID 2203842.1)

Last updated on NOVEMBER 30, 2016

Applies to:

Oracle Receivables - Version 12 and later
Oracle Trading Community - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

Release 12 version, Customers Module, Trading Community

Data corruption is observed for existing accounts when using a loop in the api and a duplicated site uses are accidently created.
The api errors but then inserts both ship_to site uses.
The table hz_cust_site_uses_all contains duplicate records which are active with same location and site_use_code. (different site_use_id)
This is causing problem in other screens which make use of customer data while selecting this customer.

The issue of the duplicated sites uses can not be created via UI. The data corruption is done when using the api to create site uses and the same site use for the same site is entered before exiting the api.

The issue has the following business impact: the table hz_cust_site_uses_all has corrupted data inserted for accounts.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Customer
2. The API hz_cust_account_site_v2pub.create_cust_site_use is setup to create site uses in a loop

The issue the duplicate sites are not created via UI. The issue is not happening when stand alone API called It is only happening with created via loop using custom code.

Cause

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 hundreds of Community platforms