My Oracle Support Banner

When Using Restful API to Import Multiple LOV Records, If It Fails with Error (SBL-DAT-00225), All Records Will Be Rejected (Doc ID 2733216.1)

Last updated on MAY 13, 2022

Applies to:

Siebel Field Service - Version 18.9 and later
Information in this document applies to any platform.


While using RESTFul API to import LOV records, if the request contains multiple LOV records to be imported and one of them fails with an error, all records will be rejected from the import.

The steps to replicate the issue are:

1. Implement Siebel REST API to import LOV

2. Try to run the API for one record: The creation of 1 record is working fine.

3. Try to run the API for multiple records: If any record is failing all other records are also not created/updated.
         - 3 LOVs imported.
         - If 2 are correct and 1 incorrect because for LOV Type is not present, all the records are rejected. The expectation is to have 2 records created.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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