Customer Interface Creates Duplicate Party Sites Used in Multi-Org (MOAC).
Last updated on AUGUST 18, 2016
Applies to:Oracle Receivables - Version: 12.0.5
This problem can occur on any platform.
RACUST - Customer Interface
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
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.
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