Bulk Create BP Record Webservice Fails For All Records, If At Least One Record Fails (Doc ID 2898088.1)

Last updated on SEPTEMBER 23, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR

When attempting to bulk create Business Process (BP) records, and a Data Element (DE) entry requires a unique value and one or more fields are invalid for the unique constraint, all subsequent entries fail and the records are not created.

EXPECTED BEHAVIOR

When attempting to bulk create BP records, and a DE entry requires a unique value and one or more fields are invalid for the unique constraint, only the fields that fail the unique constraint should not be created.

STEPS TO REPRODUCE:

-----------------------

The issue can be reproduced at will with the following steps:

1. Using REST web services attempt to bulk create BP records using the Create BP Record method.
2. The value for a "Unique DE" intentionally replicates that of an existing record (failing a unique constraint).
3. Other records and their fields are passed in the REST call.
4. A status is received stating "The value for field "Unique DE" must be unique. There is another record containing the same value for this field."
5. None of the other records are created.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.