3 Replies Latest reply: Aug 14, 2014 11:26 AM by Cuauhtemoc Amox RSS

    X_RETURN_STATUS = 'E' from oracle applications adapter while creating sale order from purchase order

    2700980

      I am  using J Developer 11.1.1.7

      I am using Oracle Applications Adapter to Generate Sale Order from Purchase Order. I am configuring Oracle Applications Adapter to use oe_order_pub.Process_Order Api. When i run the composite i got X_RETURN_STATUS = 'U'. I searched over the internet and found out that this is an UNEXPECTED ERROR BY THE APPS and that i need to initialize the apps i.e configuring user_id,responsibility_id and apps_id etc.

      Now for that purpose i use two more oracle applications adapter to use FND_GLOBAL.APPS_INITIZLIZE and MO_GLOBAL.INIT respectively. First i invoke FND_GLOBAL.APPS_INITIZLIZE and pass it user_id,responsibility_id and apps_id and Then i invoke MO_GLOBAL.INIT and pass it P_APPL_SHORT_NAME AND P_SYNC. By doing so now i don't get  X_RETURN_STATUS='U' instead i am getting X_RETURN_STATUS='E' with error message 'ONT OE_INVALID_ATTRIBUTE N ATTRIBUTE Order Type'


      Do anybody have any idea of what's going on???


      Here is my payload

       

       

      <InputReceiveActivity>
      <part  name="body">
      <Root>
      <Child>
      <operation>CREATE</operation>

       

      <order_type_id>1597</order_type_id>

      <sold_to_org_id>110290</sold_to_org_id>

      <ship_to_org_id>20367</ship_to_org_id>

      <price_list_id>86089</price_list_id>

      <pricing_date>2014-08-07</pricing_date>

      <transactional_curr_code>USD</transactional_curr_code>

      <flow_status_code>BOOKED</flow_status_code>

      <cust_po_number>UsmanTest</cust_po_number>

      <order_source_id>2</order_source_id>

      <payment_term_id>2324</payment_term_id>

      <ship_from_org_id>1072</ship_from_org_id>

      <user_id>1175</user_id>

      <responsibility_id>52092</responsibility_id>

      <application_id>660</application_id>

      <p_appl_short_name>S</p_appl_short_name>

      <p_sync/>

      </Child>

      </Root>

      </part>

      </InputReceiveActivity>