You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue on JSON data insertion in ATP table

edited Apr 16, 2022 7:54AM in Autonomous Database


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!