Passing PL/SQL Table Type variable to RESTful API inserts NULL values
Testing in arc-
{
"ALMA_RECORDS_IN_LOG_TABLE": {
"@xmlns":"http://xmlns.oracle.com/apps/ap/rest/XXUMF_ALMA_LOG/insert_values_stg_prc/",
"RESTHeader": {
"xmlns":"http://xmlns.oracle.com/apps/fnd/rest/header",
"Responsibility": "PAYABLES_MANAGER",
"RespApplication": "SQLAP",
"SecurityGroup": "STANDARD",
"NLSLanguage": "AMERICAN",
"Org_id": "101"
},
"InputParameters": {
"I_ALMA_INVOICETYPE":
[ {
"ORGANISATION_NAME": "University",
"INVOICE_SOURCE": "ALMA",
"INVOIVE_NUMBER": "CLAN45",
"INVOICE_LINE": "1",
"VOUCHER_NUMBER": null,
"ORIG_SYSTEM_VENDOR_REF": "100005",
"SUPPLIER_SITE_CODE": "Australia",
"INVOICE_DATE": "29-SEP-21",
"INVOICE_AMOUNT": "50",
"INVOICE_LINE_AMOUNT": "50",
"INVOICE_RECEIVED_DATE": null,
"INVOICE_DESCRIPTION": null,
"CURRENCY_CODE": "GBP",
"DISCOUNTABLE_AMOUNT": null,
"LINE_TYPE": "ITEM",
"DISTRIBUTION_DESCRIPTION": null,
"GL_CHARGE_CODE": "G000003",