Bulk Import: Import Fails If Any Party_id Value in the Staging Table Is Invalid

(Doc ID 729520.1)

Last updated on JANUARY 18, 2018

Applies to:

Oracle Trading Community - Version 11.5.10 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Goal

During Bulk Import, if only one record in the staging table HZ_IMP_PARTIES_INT has an invalid value for the party_id column then the bulk import process completely fails for all records and does not proceed forward. (By Running Data Load Stage1,Stage2.....etc).

Ideally Bulk Import should report the problem record and proceed importing the other records in the batch.

If the import is for party sites (HZ_IMP_ADDRESSES_INT) and one of the records has an invalid Party OSR value then the problem record is reported and the process continues successfully for the other records.

This behaviour should be consistent for all tables for the Bulk Import process. Bulk Import should proceed further and successfully process all records which do not have any data issues.

Solution

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