Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue in Process order API to create Sales Order Header through Rest Web service in R 12.2.6

Vikas_SuraniApr 24 2018

Hello ,

i need to create Sales Order header, through REST Web service,

i have deployed the process order API of type PL/SQL.

Service Operation is Process Order Header.

WADL and xsd is created.

i am using below payload data for my web service test through postman.

{

   "PROCESS_HEADER_Input":{

      "RESTHeader":{

         "Responsibility":"ORDER_MGMT_SUPER_USER",

         "RespApplication":"ONT",

         "SecurityGroup":"STANDARD",

         "NLSLanguage":"AMERICAN",

         "Org_Id":"204"

      },

      "InputParameters":{

      "P_HEADER_REC": {

      "ACCOUNTING_RULE_ID":null ,

  "PARTY_TYPE":null,

  "AGREEMENT_ID": null ,

  "ATTRIBUTE1": null ,

  "ATTRIBUTE10": null ,

  "ATTRIBUTE11": null ,

  "ATTRIBUTE12": null ,

  "ATTRIBUTE13" : null ,

  "ATTRIBUTE14" : null ,

  "ATTRIBUTE15" : null ,

  "ATTRIBUTE16" : null ,

  "ATTRIBUTE17" : null ,

  "ATTRIBUTE18" : null ,

  "ATTRIBUTE19" : null ,

  "ATTRIBUTE2" : null ,

  "ATTRIBUTE20" : null ,

  "ATTRIBUTE3" : null ,

  "ATTRIBUTE4": null ,

  "ATTRIBUTE5" : null ,

  "ATTRIBUTE6" : null ,

  "ATTRIBUTE7" : null ,

  "ATTRIBUTE8": null ,

  "ATTRIBUTE9" : null ,

  "BOOKED_FLAG" : null ,

  "CANCELLED_FLAG" : null ,

  "CONTEXT" : null ,

  "CONVERSION_RATE" : null ,

  "CONVERSION_RATE_DATE" : null ,

  "CONVERSION_TYPE_CODE" : null ,

  "CUSTOMER_PREFERENCE_SET_CODE" : null ,

  "CREATED_BY" : null ,

  "CREATION_DATE" : null ,

  "CUST_PO_NUMBER" : null ,

  "DELIVER_TO_CONTACT_ID" : null ,

  "DELIVER_TO_ORG_ID" : null ,

  "DEMAND_CLASS_CODE" : null ,

  "EARLIEST_SCHEDULE_LIMIT" : null ,

  "EXPIRATION_DATE" : null ,

  "FOB_POINT_CODE" : null ,

  "FREIGHT_CARRIER_CODE": null ,

  "FREIGHT_TERMS_CODE" : null ,

  "GLOBAL_ATTRIBUTE1" : null ,

  "GLOBAL_ATTRIBUTE10" : null ,

  "GLOBAL_ATTRIBUTE11" : null ,

  "GLOBAL_ATTRIBUTE12" : null ,

  "GLOBAL_ATTRIBUTE13" : null ,

  "GLOBAL_ATTRIBUTE14" : null ,

  "GLOBAL_ATTRIBUTE15" : null ,

  "GLOBAL_ATTRIBUTE16" : null ,

  "GLOBAL_ATTRIBUTE17" : null ,

  "GLOBAL_ATTRIBUTE18" : null ,

  "GLOBAL_ATTRIBUTE19" : null ,

  "GLOBAL_ATTRIBUTE2" : null ,

  "GLOBAL_ATTRIBUTE20" : null ,

  "GLOBAL_ATTRIBUTE3" : null ,

  "GLOBAL_ATTRIBUTE4" : null ,

  "GLOBAL_ATTRIBUTE5" : null ,

  "GLOBAL_ATTRIBUTE6" : null ,

  "GLOBAL_ATTRIBUTE7" : null ,

  "GLOBAL_ATTRIBUTE8" : null ,

  "GLOBAL_ATTRIBUTE9" : null ,

  "GLOBAL_ATTRIBUTE_CATEGORY" : null ,

  "TP_CONTEXT" : null ,

  "TP_ATTRIBUTE1" : null ,

  "TP_ATTRIBUTE2" : null ,

  "TP_ATTRIBUTE3" : null ,

  "TP_ATTRIBUTE4" : null ,

  "TP_ATTRIBUTE5" : null ,

  "TP_ATTRIBUTE6" : null ,

  "TP_ATTRIBUTE7" : null ,

  "TP_ATTRIBUTE8" : null ,

  "TP_ATTRIBUTE9" : null ,

  "TP_ATTRIBUTE10": null ,

  "TP_ATTRIBUTE11": null ,

  "TP_ATTRIBUTE12": null ,

  "TP_ATTRIBUTE13": null ,

  "TP_ATTRIBUTE14": null ,

  "TP_ATTRIBUTE15": null ,

  "HEADER_ID" : null ,

  "INVOICE_TO_CONTACT_ID" : null ,

  "INVOICE_TO_ORG_ID" : null ,

  "INVOICING_RULE_ID" : null ,

  "LAST_UPDATED_BY" : null ,

  "LAST_UPDATE_DATE" : null ,

  "LAST_UPDATE_LOGIN" : null ,

  "LATEST_SCHEDULE_LIMIT" : null ,

  "OPEN_FLAG": null ,

  "ORDER_CATEGORY_CODE" : null ,

  "ORDERED_DATE" : null ,

  "ORDER_DATE_TYPE_CODE" : null ,

  "ORDER_NUMBER" : null ,

  "ORDER_SOURCE_ID" : null ,

  "ORDER_TYPE_ID" : 1437 ,

  "ORG_ID"  : 204 ,

  "ORIG_SYS_DOCUMENT_REF" : null ,

  "PARTIAL_SHIPMENTS_ALLOWED" : null ,

  "PAYMENT_TERM_ID" : null ,

  "PRICE_LIST_ID" : 1000 ,

  "PRICE_REQUEST_CODE" : null ,

  "PRICING_DATE" : null ,

  "PROGRAM_APPLICATION_ID" : null ,

  "PROGRAM_ID" : null ,

  "PROGRAM_UPDATE_DATE" : null ,

  "REQUEST_DATE" : null ,

  "REQUEST_ID" : null ,

  "RETURN_REASON_CODE" : null ,

  "SALESREP_ID" : null ,

  "SALES_CHANNEL_CODE" : null ,

  "SHIPMENT_PRIORITY_CODE" : null ,

  "SHIPPING_METHOD_CODE" : null ,

  "SHIP_FROM_ORG_ID" : 204 ,

  "SHIP_TOLERANCE_ABOVE" : null ,

  "SHIP_TOLERANCE_BELOW" : null ,

  "SHIP_TO_CONTACT_ID" : null ,

  "SHIP_TO_ORG_ID" : 1031 ,

  "SOLD_FROM_ORG_ID": null ,

  "SOLD_TO_CONTACT_ID" : null ,

  "SOLD_TO_ORG_ID" : 1007 ,

  "SOLD_TO_PHONE_ID" : null ,

  "SOURCE_DOCUMENT_ID" : null ,

  "SOURCE_DOCUMENT_TYPE_ID": null ,

  "TAX_EXEMPT_FLAG" : null ,

  "TAX_EXEMPT_NUMBER" : null ,

  "TAX_EXEMPT_REASON_CODE" : null ,

  "TAX_POINT_CODE" : null ,

  "TRANSACTIONAL_CURR_CODE": null ,

  "VERSION_NUMBER" : null ,

  "RETURN_STATUS" : null ,

  "DB_FLAG" : "T" ,

  "OPERATION" :  "CREATE" ,

  "FIRST_ACK_CODE" : null ,

  "FIRST_ACK_DATE" : null ,

  "LAST_ACK_CODE" : null ,

  "LAST_ACK_DATE" : null ,

  "CHANGE_REASON" : null ,

  "CHANGE_COMMENTS" : null ,

  "CHANGE_SEQUENCE" : null ,

  "CHANGE_REQUEST_CODE"  : null ,

  "READY_FLAG" : null ,

  "STATUS_FLAG": null ,

  "FORCE_APPLY_FLAG" : null ,

  "DROP_SHIP_FLAG" : null ,

  "CUSTOMER_PAYMENT_TERM_ID": null ,

  "PAYMENT_TYPE_CODE" : null ,

  "PAYMENT_AMOUNT" : null ,

  "CHECK_NUMBER" : null ,

  "CREDIT_CARD_CODE" : null ,

  "CREDIT_CARD_HOLDER_NAME" : null ,

  "CREDIT_CARD_NUMBER" : null ,

  "CREDIT_CARD_EXPIRATION_DATE": null ,

  "CREDIT_CARD_APPROVAL_CODE" : null ,

  "CREDIT_CARD_APPROVAL_DATE" : null ,

  "SHIPPING_INSTRUCTIONS" : null ,

  "PACKING_INSTRUCTIONS" : null ,

  "FLOW_STATUS_CODE" : null ,

  "BOOKED_DATE" : null ,

  "MARKETING_SOURCE_CODE_ID" : null ,

  "UPGRADED_FLAG" : null ,

  "LOCK_CONTROL" : null ,

  "SHIP_TO_EDI_LOCATION_CODE" : null ,

  "SOLD_TO_EDI_LOCATION_CODE" : null ,

  "BILL_TO_EDI_LOCATION_CODE" : null ,

  "SHIP_FROM_EDI_LOCATION_CODE": null ,

  "SHIP_FROM_ADDRESS_ID" : null ,

  "SOLD_TO_ADDRESS_ID" : null ,

  "SHIP_TO_ADDRESS_ID" : null ,

  "INVOICE_ADDRESS_ID" : null ,

  "SHIP_TO_ADDRESS_CODE": null ,

  "XML_MESSAGE_ID" : null ,

  "SHIP_TO_CUSTOMER_ID" : null ,

  "INVOICE_TO_CUSTOMER_ID" : null ,

  "DELIVER_TO_CUSTOMER_ID" : null ,

  "ACCOUNTING_RULE_DURATION": null ,

  "XML_TRANSACTION_TYPE_CODE": null ,

  "BLANKET_NUMBER" : null ,

  "LINE_SET_NAME" : null ,

  "FULFILLMENT_SET_NAME" : null ,

  "DEFAULT_FULFILLMENT_SET" : null ,

  "QUOTE_DATE" : null ,

  "QUOTE_NUMBER" : null ,

  "SALES_DOCUMENT_NAME" : null ,

  "TRANSACTION_PHASE_CODE" : null ,

  "USER_STATUS_CODE" : null ,

  "DRAFT_SUBMITTED_FLAG" : null ,

  "SOURCE_DOCUMENT_VERSION_NUMBER": null ,

  "SOLD_TO_SITE_USE_ID" : null ,

  "MINISITE_ID" : null ,

  "IB_OWNER" : null ,

  "IB_INSTALLED_AT_LOCATION" : null ,

  "IB_CURRENT_LOCATION" : null ,

  "END_CUSTOMER_ID" : null ,

  "END_CUSTOMER_CONTACT_ID" : null ,

  "END_CUSTOMER_SITE_USE_ID" : null ,

  "SUPPLIER_SIGNATURE" : null ,

  "SUPPLIER_SIGNATURE_DATE" : null ,

  "CUSTOMER_SIGNATURE" : null ,

  "CUSTOMER_SIGNATURE_DATE" : null ,

  "SOLD_TO_PARTY_ID" : null ,

  "SOLD_TO_ORG_CONTACT_ID" : null ,

  "SHIP_TO_PARTY_ID" : null ,

  "SHIP_TO_PARTY_SITE_ID" : null ,

  "SHIP_TO_PARTY_SITE_USE_ID" : null ,

  "DELIVER_TO_PARTY_ID" : null ,

  "DELIVER_TO_PARTY_SITE_ID" : null ,

  "DELIVER_TO_PARTY_SITE_USE_ID" : null ,

  "INVOICE_TO_PARTY_ID" : null ,

  "INVOICE_TO_PARTY_SITE_ID" : null ,

  "INVOICE_TO_PARTY_SITE_USE_ID" : null ,

  "END_CUSTOMER_PARTY_ID" : null ,

  "END_CUSTOMER_PARTY_SITE_ID" : null ,

  "END_CUSTOMER_PARTY_SITE_USE_ID" : null ,

  "END_CUSTOMER_PARTY_NUMBER" : null ,

  "END_CUSTOMER_ORG_CONTACT_ID" : null ,

  "SHIP_TO_CUSTOMER_PARTY_ID" : null ,

  "DELIVER_TO_CUSTOMER_PARTY_ID" : null ,

  "INVOICE_TO_CUSTOMER_PARTY_ID" : null ,

  "SHIP_TO_ORG_CONTACT_ID" : null ,

  "DELIVER_TO_ORG_CONTACT_ID" : null ,

  "INVOICE_TO_ORG_CONTACT_ID" : null ,

  "CONTRACT_TEMPLATE_ID" : null ,

  "CONTRACT_SOURCE_DOC_TYPE_CODE": null ,

  "CONTRACT_SOURCE_DOCUMENT_ID" : null ,

  "SOLD_TO_PARTY_NUMBER" : null ,

  "SHIP_TO_PARTY_NUMBER" : null ,

  "INVOICE_TO_PARTY_NUMBER" : null ,

  "DELIVER_TO_PARTY_NUMBER" : null ,

  "ORDER_FIRMED_DATE" : null ,

  "INSTRUMENT_SECURITY_CODE" : null ,

  "CC_INSTRUMENT_ID" : null ,

  "CC_INSTRUMENT_ASSIGNMENT_ID": null ,

  "SOLD_TO_CUSTOMER_REF" : null ,

  "SHIP_TO_CUSTOMER_REF" : null ,

  "INVOICE_TO_CUSTOMER_REF" : null ,

  "DELIVER_TO_CUSTOMER_REF" : null ,

  "SHIP_TO_ADDRESS_REF" : null ,

  "INVOICE_TO_ADDRESS_REF" : null ,

  "DELIVER_TO_ADDRESS_REF" : null ,

  "SOLD_TO_ADDRESS_REF" : null ,

  "SOLD_TO_CONTACT_REF" : null ,

  "SHIP_TO_CONTACT_REF" : null ,

  "INVOICE_TO_CONTACT_REF" : null ,

  "DELIVER_TO_CONTACT_REF" : null

    },

  "P_ORG_ID":204 ,

  "P_OPERATING_UNIT" : "Vision Operations"

  }

  }

}

And below is the response i get.

{

    "OutputParameters": {

        "@xmlns": "http://xmlns.oracle.com/apps/ont/rest/OE_ORDER_PUB_H/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,

            "ATTRIBUTE12": null,

            "ATTRIBUTE13": null,

            "ATTRIBUTE14": null,

            "ATTRIBUTE15": null,

            "ATTRIBUTE16": null,

            "ATTRIBUTE17": null,

            "ATTRIBUTE18": null,

            "ATTRIBUTE19": null,

            "ATTRIBUTE2": null,

            "ATTRIBUTE20": null,

            "ATTRIBUTE3": null,

            "ATTRIBUTE4": null,

            "ATTRIBUTE5": null,

            "ATTRIBUTE6": null,

            "ATTRIBUTE7": null,

            "ATTRIBUTE8": null,

            "ATTRIBUTE9": null,

            "BOOKED_FLAG": null,

            "CANCELLED_FLAG": null,

            "CONTEXT": null,

            "CONVERSION_RATE": null,

            "CONVERSION_RATE_DATE": null,

            "CONVERSION_TYPE_CODE": null,

            "CUSTOMER_PREFERENCE_SET_CODE": null,

            "CREATED_BY": null,

            "CREATION_DATE": null,

            "CUST_PO_NUMBER": null,

            "DELIVER_TO_CONTACT_ID": null,

            "DELIVER_TO_ORG_ID": null,

            "DEMAND_CLASS_CODE": null,

            "EARLIEST_SCHEDULE_LIMIT": null,

            "EXPIRATION_DATE": null,

            "FOB_POINT_CODE": null,

            "FREIGHT_CARRIER_CODE": null,

            "FREIGHT_TERMS_CODE": null,

            "GLOBAL_ATTRIBUTE1": null,

            "GLOBAL_ATTRIBUTE10": null,

            "GLOBAL_ATTRIBUTE11": null,

            "GLOBAL_ATTRIBUTE12": null,

            "GLOBAL_ATTRIBUTE13": null,

            "GLOBAL_ATTRIBUTE14": null,

            "GLOBAL_ATTRIBUTE15": null,

            "GLOBAL_ATTRIBUTE16": null,

            "GLOBAL_ATTRIBUTE17": null,

            "GLOBAL_ATTRIBUTE18": null,

            "GLOBAL_ATTRIBUTE19": null,

            "GLOBAL_ATTRIBUTE2": null,

            "GLOBAL_ATTRIBUTE20": null,

            "GLOBAL_ATTRIBUTE3": null,

            "GLOBAL_ATTRIBUTE4": null,

            "GLOBAL_ATTRIBUTE5": null,

            "GLOBAL_ATTRIBUTE6": null,

            "GLOBAL_ATTRIBUTE7": null,

            "GLOBAL_ATTRIBUTE8": null,

            "GLOBAL_ATTRIBUTE9": null,

            "GLOBAL_ATTRIBUTE_CATEGORY": null,

            "TP_CONTEXT": null,

            "TP_ATTRIBUTE1": null,

            "TP_ATTRIBUTE2": null,

            "TP_ATTRIBUTE3": null,

            "TP_ATTRIBUTE4": null,

            "TP_ATTRIBUTE5": null,

            "TP_ATTRIBUTE6": null,

            "TP_ATTRIBUTE7": null,

            "TP_ATTRIBUTE8": null,

            "TP_ATTRIBUTE9": null,

            "TP_ATTRIBUTE10": null,

            "TP_ATTRIBUTE11": null,

            "TP_ATTRIBUTE12": null,

            "TP_ATTRIBUTE13": null,

            "TP_ATTRIBUTE14": null,

            "TP_ATTRIBUTE15": null,

            "HEADER_ID": null,

            "INVOICE_TO_CONTACT_ID": null,

            "INVOICE_TO_ORG_ID": null,

            "INVOICING_RULE_ID": null,

            "LAST_UPDATED_BY": null,

            "LAST_UPDATE_DATE": null,

            "LAST_UPDATE_LOGIN": null,

            "LATEST_SCHEDULE_LIMIT": null,

            "OPEN_FLAG": null,

            "ORDER_CATEGORY_CODE": "MIXED",

            "ORDERED_DATE": null,

            "ORDER_DATE_TYPE_CODE": null,

            "ORDER_NUMBER": "69486",

            "ORDER_SOURCE_ID": null,

            "ORDER_TYPE_ID": "1437",

            "ORG_ID": "204",

            "ORIG_SYS_DOCUMENT_REF": null,

            "PARTIAL_SHIPMENTS_ALLOWED": null,

            "PAYMENT_TERM_ID": null,

            "PRICE_LIST_ID": "1000",

            "PRICE_REQUEST_CODE": null,

            "PRICING_DATE": null,

            "PROGRAM_APPLICATION_ID": null,

            "PROGRAM_ID": null,

            "PROGRAM_UPDATE_DATE": null,

            "REQUEST_DATE": null,

            "REQUEST_ID": null,

            "RETURN_REASON_CODE": null,

            "SALESREP_ID": null,

            "SALES_CHANNEL_CODE": null,

            "SHIPMENT_PRIORITY_CODE": null,

            "SHIPPING_METHOD_CODE": null,

            "SHIP_FROM_ORG_ID": "204",

            "SHIP_TOLERANCE_ABOVE": null,

            "SHIP_TOLERANCE_BELOW": null,

            "SHIP_TO_CONTACT_ID": null,

            "SHIP_TO_ORG_ID": "1031",

            "SOLD_FROM_ORG_ID": null,

            "SOLD_TO_CONTACT_ID": null,

            "SOLD_TO_ORG_ID": "1007",

            "SOLD_TO_PHONE_ID": null,

            "SOURCE_DOCUMENT_ID": null,

            "SOURCE_DOCUMENT_TYPE_ID": null,

            "TAX_EXEMPT_FLAG": null,

            "TAX_EXEMPT_NUMBER": null,

            "TAX_EXEMPT_REASON_CODE": null,

            "TAX_POINT_CODE": null,

            "TRANSACTIONAL_CURR_CODE": null,

            "VERSION_NUMBER": null,

            "RETURN_STATUS": "U",

            "DB_FLAG": "F",

            "OPERATION": "CREATE",

            "FIRST_ACK_CODE": null,

            "FIRST_ACK_DATE": null,

            "LAST_ACK_CODE": null,

            "LAST_ACK_DATE": null,

            "CHANGE_REASON": null,

            "CHANGE_COMMENTS": null,

            "CHANGE_SEQUENCE": null,

            "CHANGE_REQUEST_CODE": null,

            "READY_FLAG": null,

            "STATUS_FLAG": null,

            "FORCE_APPLY_FLAG": null,

            "DROP_SHIP_FLAG": null,

            "CUSTOMER_PAYMENT_TERM_ID": null,

            "PAYMENT_TYPE_CODE": null,

            "PAYMENT_AMOUNT": null,

            "CHECK_NUMBER": null,

            "CREDIT_CARD_CODE": null,

            "CREDIT_CARD_HOLDER_NAME": null,

            "CREDIT_CARD_NUMBER": null,

            "CREDIT_CARD_EXPIRATION_DATE": null,

            "CREDIT_CARD_APPROVAL_CODE": null,

            "CREDIT_CARD_APPROVAL_DATE": null,

            "SHIPPING_INSTRUCTIONS": null,

            "PACKING_INSTRUCTIONS": null,

            "FLOW_STATUS_CODE": null,

            "BOOKED_DATE": null,

            "MARKETING_SOURCE_CODE_ID": null,

            "UPGRADED_FLAG": null,

            "LOCK_CONTROL": null,

            "SHIP_TO_EDI_LOCATION_CODE": null,

            "SOLD_TO_EDI_LOCATION_CODE": null,

            "BILL_TO_EDI_LOCATION_CODE": null,

            "SHIP_FROM_EDI_LOCATION_CODE": null,

            "SHIP_FROM_ADDRESS_ID": null,

            "SOLD_TO_ADDRESS_ID": null,

            "SHIP_TO_ADDRESS_ID": null,

            "INVOICE_ADDRESS_ID": null,

            "SHIP_TO_ADDRESS_CODE": null,

            "XML_MESSAGE_ID": null,

            "SHIP_TO_CUSTOMER_ID": null,

            "INVOICE_TO_CUSTOMER_ID": null,

            "DELIVER_TO_CUSTOMER_ID": null,

            "ACCOUNTING_RULE_DURATION": null,

            "XML_TRANSACTION_TYPE_CODE": null,

            "BLANKET_NUMBER": null,

            "LINE_SET_NAME": null,

            "FULFILLMENT_SET_NAME": null,

            "DEFAULT_FULFILLMENT_SET": null,

            "QUOTE_DATE": null,

            "QUOTE_NUMBER": null,

            "SALES_DOCUMENT_NAME": null,

            "TRANSACTION_PHASE_CODE": "F",

            "USER_STATUS_CODE": null,

            "DRAFT_SUBMITTED_FLAG": null,

            "SOURCE_DOCUMENT_VERSION_NUMBER": null,

            "SOLD_TO_SITE_USE_ID": null,

            "MINISITE_ID": null,

            "IB_OWNER": null,

            "IB_INSTALLED_AT_LOCATION": null,

            "IB_CURRENT_LOCATION": null,

            "END_CUSTOMER_ID": null,

            "END_CUSTOMER_CONTACT_ID": null,

            "END_CUSTOMER_SITE_USE_ID": null,

            "SUPPLIER_SIGNATURE": null,

            "SUPPLIER_SIGNATURE_DATE": null,

            "CUSTOMER_SIGNATURE": null,

            "CUSTOMER_SIGNATURE_DATE": null,

            "SOLD_TO_PARTY_ID": null,

            "SOLD_TO_ORG_CONTACT_ID": null,

            "SHIP_TO_PARTY_ID": null,

            "SHIP_TO_PARTY_SITE_ID": null,

            "SHIP_TO_PARTY_SITE_USE_ID": null,

            "DELIVER_TO_PARTY_ID": null,

            "DELIVER_TO_PARTY_SITE_ID": null,

            "DELIVER_TO_PARTY_SITE_USE_ID": null,

            "INVOICE_TO_PARTY_ID": null,

            "INVOICE_TO_PARTY_SITE_ID": null,

            "INVOICE_TO_PARTY_SITE_USE_ID": null,

            "END_CUSTOMER_PARTY_ID": null,

            "END_CUSTOMER_PARTY_SITE_ID": null,

            "END_CUSTOMER_PARTY_SITE_USE_ID": null,

            "END_CUSTOMER_PARTY_NUMBER": null,

            "END_CUSTOMER_ORG_CONTACT_ID": null,

            "SHIP_TO_CUSTOMER_PARTY_ID": null,

            "DELIVER_TO_CUSTOMER_PARTY_ID": null,

            "INVOICE_TO_CUSTOMER_PARTY_ID": null,

            "SHIP_TO_ORG_CONTACT_ID": null,

            "DELIVER_TO_ORG_CONTACT_ID": null,

            "INVOICE_TO_ORG_CONTACT_ID": null,

            "CONTRACT_TEMPLATE_ID": null,

            "CONTRACT_SOURCE_DOC_TYPE_CODE": null,

            "CONTRACT_SOURCE_DOCUMENT_ID": null,

            "SOLD_TO_PARTY_NUMBER": null,

            "SHIP_TO_PARTY_NUMBER": null,

            "INVOICE_TO_PARTY_NUMBER": null,

            "DELIVER_TO_PARTY_NUMBER": null,

            "ORDER_FIRMED_DATE": null,

            "INSTRUMENT_SECURITY_CODE": null,

            "CC_INSTRUMENT_ID": null,

            "CC_INSTRUMENT_ASSIGNMENT_ID": null,

            "SOLD_TO_CUSTOMER_REF": null,

            "SHIP_TO_CUSTOMER_REF": null,

            "INVOICE_TO_CUSTOMER_REF": null,

            "DELIVER_TO_CUSTOMER_REF": null,

            "SHIP_TO_ADDRESS_REF": null,

            "INVOICE_TO_ADDRESS_REF": null,

            "DELIVER_TO_ADDRESS_REF": null,

            "SOLD_TO_ADDRESS_REF": null,

            "SOLD_TO_CONTACT_REF": null,

            "SHIP_TO_CONTACT_REF": null,

            "INVOICE_TO_CONTACT_REF": null,

            "DELIVER_TO_CONTACT_REF": null

        },

        "X_RETURN_STATUS": "U",

        "X_MSG_COUNT": "2",

        "X_MSG_DATA": "FND FND_AS_UNEXPECTED_ERROR N PKG_NAME OE_Delayed_Requests_PVT N PROCEDURE_NAME LOGREQUEST N ERROR_TEXT ORA-06502: PL/SQL: numeric or value error: NULL index table key value "

    }

}

Am i missing anything ?

Please help me.

Thanks

Vikas

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2018
Added on Apr 24 2018
0 comments
594 views