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

    Oracle EBS REST APIs with OE_ORDER_PUB Interface

    4167378

      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.