Does ASI Business Services Support ObjectLevelTransactions Input Argument ? (Doc ID 1236083.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Goal

Customer has an ASI based Inbound Web Service using Upsert method. It receives a SOAP XML message with Parent and Child data. The requirement is to only update the Child records and never insert them. We have defined the appropirate user keys at both the Parent and the Child level.

It so happens that one or more of the Child record in the XML does not exist in the database for the Parent record and fails because it tries to create the child record and fails because of the required field error message. Now this error message is acceptable but the problem is that for the child records that did match the existing record the update does not happen.

Is there a way for ASI Business Service to commit the records that were successfull and only error out on the unsuccessful ones ?

Solution

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