Customer Interface Creates Duplicate Party Sites Used in Multi-Org (MOAC). (Doc ID 802175.1)

Last updated on AUGUST 18, 2016

Applies to:

Oracle Receivables - Version: 12.0.5
This problem can occur on any platform.
RACUST - Customer Interface

Symptoms

Customer Interface creating duplicate party site uses
when interface is run for multiple Operating Units.

Run Customer Interface (with a user which has access to all Operating Units used). Do not specify any Operating Unit while running Customer Interface program.

The error "ORA-1422 exact fetch return more than one row" is raised in Customers User Interface when trying to add a site use for a site imported using Customer Interface.

Duplicate party site uses are created in hz_party_site_uses table.

Verify using query :

SELECT party_site_id , site_use_type,Count(1) FROM
hz_party_site_uses
WHERE status = 'A'
GROUP BY party_site_id , site_use_type
HAVING Count(1) > 1


Same issue is not reproducible when Customer interface is used to import
sites for one Operating Unit at a time.

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