Bulk Data Access Assigment APIs Returning 200 OK or 400 Bad Request For A Payload That Worked Before 19B Update (Doc ID 2563788.1)

Last updated on JUNE 04, 2020

Applies to:

Symptoms

On : 11.13.19.04.0 version, Other Issues

When attempting to call the "Create Data Access" Rest API provided by Oracle in order to upload in BULK. The following error occurs.

ERROR
-----------------------
Returns 200 OK or 400 Bad Request error code, no records are added  and the Response Body is incorrect.

STEPS

-----------------------
The issue can be reproduced at will with the following steps:
1. Call the "Create Data Access" Rest API with the payload below for a single record
{
"SecurityContext" : "Business Unit",
"SecurityContextValue" : "General BU",
"RoleNameCr" : "Business Practices Director",
"UserName" : "ABC"
}

OR the payload below for multiple records:

{
"parts": [
{
"id": "part1",
"path":"/dataSecurities",
"operation": "create",
"payload":
{
"SecurityContext" : "Asset book",
"SecurityContextValue" : "YYYY TAX BOOK",
"RoleNameCr" : "Employee",
"UserName" : "ABCDE"
}
},
{
"id": "part2",
"path":"/dataSecurities",
"operation": "create",
"payload":
{
"SecurityContext" : "Asset book",
"SecurityContextValue" : "XXXX CORPORATE BOOK",
"RoleNameCr" : "Employee",
"UserName" : "DEFGH"
}
}
]
}

Changes

Cause

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