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.

1 comment:

currentAppUi built in variable in VBCS

$global.currentAppUi.id :- The id of the App UI $global.currentAppUi.urlId :-The id of the App UI as shown in the URL $global.currentAppUi.d...