1 Reply Latest reply on Jan 13, 2020 6:07 AM by Azar

    Oracle EBS REST APIs with OE_ORDER_PUB Interface

    4167378
    4167378 Jan 10, 2020 7:01 PM

      I am not able to figure out how to use the EBS Rest APIs. I need to process Sales Orders on my EBS Rest API. I am using the OE_ORDER_PUB interface. The rest calls that I am using include the Process_Header, Process_Lines and Get_Order. I deployed the APIs and that is working, but I am not why my requests are returning null. I don't know which Base Table that these APIs are saving/retrieving from.

      Here is my request body for creating Process Header.

      {
      "InputParameters":{
               "P_HEADER_REC" : "G_MISS_HEADER_REC",
               "P_ORG_ID":2131,
               "P_OPERATING_UNIT":"test"
      }

      Here is part of the Response:

      {
      "OutputParameters": {
               "@xmlns": "http://xmlns.oracle.com/apps/ont/rest/order/process_header/",
               "@xmlns:xsi": "http://www.w3.org/2001/XMLSchema-instance",
               "X_HEADER_OUT_REC": {
               "ACCOUNTING_RULE_ID": null,
               "PARTY_TYPE": null,
               "AGREEMENT_ID": null,
               "ATTRIBUTE1": null,
               "ATTRIBUTE10": null,
               "ATTRIBUTE11": null,
          ....[alot of key:value with null]
               },
               "X_RETURN_STATUS": "E",
               "X_MSG_COUNT": "8",
               "X_MSG_DATA": "ONT OE_BOTH_VAL_AND_ID_EXIST N ATTRIBUTE operating_unit "
      }

      I do not know how to create a proper payload. I know that is those are the correct parameter names, but I am not sure what else there is.