0 Replies Latest reply: Aug 12, 2014 12:07 PM by Rohit Chaube RSS

    R12.2.3 - REST web Service for - OE_INBOUND_INT PROCESS_ORDER - returns success but no Sales Order Created

    Rohit Chaube

      I am trying to test a REST based web service for PL/SQL package - OE_INBOUND_INT.PROCESS_ORDER  for EBS R12.2.3.

      Using the Java code in Oracle EBS SOA Gateway - Developer Guide as a reference (Pg 160).

      I have been successful in calling the web services, but the Sales Order does not get created. I am not sure if additional parameter values are needed.

      Any suggestions or inputs would be really appreciated.


      Have tested the API using SQL Developer and the PL/SQL code is able to generate a Sales Order for the input values.

       

      thanks

      Rohit

      Input values passed


      private static final String xmlRequest4 = "<ns:GET_Input xmlns:ns=\"http://xmlns.oracle.com/apps/fnd/soaprovider/plsql/rest/fnd_profile/get/\""

                                              + " xmlns:ns1=\"http://xmlns.oracle.com/apps/fnd/soaprovider/plsql/rest/fnd_profile/header\">"

                                              + " <ns1:RESTHeader>"

                                              + " <ns1:Responsibility>ORDER_MGMT_SUPER_USER</ns1:Responsibility>"

                                              + " <ns1:RespApplication>ONT</ns1:RespApplication>"

                                              + " <ns1:SecurityGroup>STANDARD</ns1:SecurityGroup>"

                                              + " <ns1:NLSLanguage>AMERICAN</ns1:NLSLanguage>"

                                              + " <ns1:Org_Id>202</ns1:Org_Id>"

                                              + " </ns1:RESTHeader>"

                                              + " <ns:InputParameters>"

       

                                              // Input for OE_INBOUND_INT.PROCESS_ORDER - service

                                              + " <ns:P_API_VERSION_NUMBER>1.0</ns:P_API_VERSION_NUMBER>"   

                                              + " <ns:P_INIT_MSG_LIST>T</ns:P_INIT_MSG_LIST>"

                                              + " <ns:P_RETURN_VALUES>T</ns:P_RETURN_VALUES>" 

                                              + " <ns:P_ACTION_COMMIT>T</ns:P_ACTION_COMMIT>"

                                              // SO Header Information

                                              + " <ns:P_HEADER_REC>"

                                                  + "<ORDER_TYPE_ID>1000</ORDER_TYPE_ID>"

                                                  + "<ORDERED_DATE>SYSDATE</ORDERED_DATE>"

                                                  + "<PRICE_LIST_ID>1000</PRICE_LIST_ID>"

                                                  + "<SHIP_FROM_ORG_ID>207</SHIP_FROM_ORG_ID>"

                                                  + "<SHIPPING_METHOD_CODE>DHL</SHIPPING_METHOD_CODE>"

                                                  + "<SOLD_FROM_ORG_ID>204</SOLD_FROM_ORG_ID>"

                                                  + "<SOLD_TO_ORG_ID>1005</SOLD_TO_ORG_ID>"

                                                  + "<TRANSACTIONAL_CURR_CODE>USD</TRANSACTIONAL_CURR_CODE>"

                                                  + "<OPERATION>CREATE</OPERATION>"         //OE_GLOBALS.G_OPR_CREATE

                                              + "</ns:P_HEADER_REC>"   

                                              + " </ns:InputParameters> + </ns:GET_Input>";