Customer Interface (RACUST) Performance Issue When Populating HZ_PARTIES Data into R12.1.3 from Legacy Database in Bulk

(Doc ID 2001675.1)

Last updated on AUGUST 04, 2016

Applies to:

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

Symptoms

Using the seeded API's to populate the data and insert in HZ PARTIES.

You are running the Customer Interface (RACUST) concurrent request, to populate the data into the HZ_PARTIES and other relevant tables, and find there is a huge performance issue.

For 10000 records, the process is taking approximately 30 minutes, but actual data may be about 4000000 records.

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