Thursday, October 7, 2021

Running the Customer Interface throwing "racina: ORA-00001: unique constraint (AR.HZ_LOCATIONS_PK) violated and racina: Error inserting addresses." Errors

When trying to Import customers using Customer Interface (RACUST) and receive the following error:

ORA-00001 running Customer Interface

racina: ORA-00001: unique constraint (AR.HZ_LOCATIONS_PK) violated

racina: Error inserting addresses.


The Customer Interface process is attempting to insert an existing location_id in the HZ_LOCATIONS table.

at
Labels:

1 comment:

Subscribe to: Post Comments (Atom)

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...