EBS Customizations (MOSC)

MOSC Banner

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",

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center