Issue on JSON data insertion in ATP table
Content
Hi Experts,
I am trying to insert JSON file data into ATP table through OIC JSON file is in Master child data form so I am inserting master data "PENN_DREQ_PartsListDetails" in table A and child data "PENN_SREQ_P41202Components_Repeating" in table B with "Item Number" as join condition.
I am able to insert master array data but falied to insert child array data. JSON file attached.
I have attached JSON file
Getting below error :
"detail" : "Internal server error. Please contact oracle support for details.",
"o:errorCode" : "500",
"o:errorDetails" : [ {
"type" : "UnMappedFault:NA",
"instance" : "NA",
"title" : "Stored procedure invocation error.\nError while trying to prepare and execute the ADMIN.XXPEM_BRANCH_LOTS_PKG.XXPEM_BRANCH_LOTS_PROC API.\nAn error occurred while preparing and executing the ADMIN.XXPEM_BRANCH_LOTS_PKG.XXPEM_BRANCH_LOTS_PROC API. Cause: java.sql.SQLException: ORA-21700: object does not exist or is marked for delete\n\nCheck to ensure that the database objects exists(stored procedures,table,view..etc) in the database and the parameters match the signature of the API-like not exceeding the column range or is not NULL or is already existing value.Please examine the error message carefully to determine a resolution. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add