1 Reply Latest reply on Oct 8, 2007 2:23 PM by 159563

    Creating Sales Order in APPS using oracle Apps Adapter.

    595538
      I am trying to create a sales order in oracle Apps using oracle Apps Adapter.

      Inbound file is 850 EDI file.
      Integration B2B is used to create the EDI-XMl.
      Mapping is created in BPEL.

      Exceprts form BPEL Console Audit section

      <P_API_VERSION_NUMBER xmlns="">1.0
      </P_API_VERSION_NUMBER>
      -<P_HEADER_REC xmlns="">
      <ORDERED_DATE>2007-10-08T16:38:11+05:30</ORDERED_DATE>
      <ORDER_TYPE_ID>1696</ORDER_TYPE_ID>
      <SHIP_TO_ORG_ID>11683</SHIP_TO_ORG_ID>
      <TRANSACTIONAL_CURR_CODE>USD</TRANSACTIONAL_CURR_CODE>
      </P_HEADER_REC>
      -<P_HEADER_VAL_REC xmlns="">
      <INVOICE_TO_ADDRESS1>BT
      </INVOICE_TO_ADDRESS1>
      <INVOICE_TO_ADDRESS2>Ashland Distribution Inc
      </INVOICE_TO_ADDRESS2>
      <INVOICE_TO_ADDRESS3>9
      </INVOICE_TO_ADDRESS3>
      <INVOICE_TO_ADDRESS4>2016136689005
      </INVOICE_TO_ADDRESS4>
      <SHIP_TO_ADDRESS1>ST
      </SHIP_TO_ADDRESS1>
      <SHIP_TO_ADDRESS2>Ashland Distribution Inc
      </SHIP_TO_ADDRESS2>
      <SHIP_TO_ADDRESS3>9
      </SHIP_TO_ADDRESS3>
      <SHIP_TO_ADDRESS4>2016136689005
      </SHIP_TO_ADDRESS4>
      </P_HEADER_VAL_REC>
      -<P_LINE_TBL xmlns="">
      -<P_LINE_TBL_ITEM>
      <ORDERED_ITEM>1
      </ORDERED_ITEM>
      <ORDERED_QUANTITY>10
      </ORDERED_QUANTITY>
      <ORDER_QUANTITY_UOM>LB
      </ORDER_QUANTITY_UOM>
      <UNIT_SELLING_PRICE>7.5
      </UNIT_SELLING_PRICE>
      </P_LINE_TBL_ITEM>
      </P_LINE_TBL>
      </InputParameters>

      This shows that mapping is working correctly.

      But invocation of Adapter is giving problem.Following is the error.

      <summary>
      file:/D:/product/10.1.3.1/OracleAS/bpel/domains/default/tmp/.bpel_EDI850InboundService_1.0_973a35abc5c4e4b30f414886437b790d.tmp/writeEDIData2OracleService.wsdl [ writeEDIData2OracleService_ptt::writeEDIData2OracleService(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'writeEDIData2OracleService' failed due to: Error while trying to prepare and execute an API.
      An error occurred while preparing and executing the APPS.XX_BPEL_WRITEEDIDATA2ORACLESER.OE_ORDER_PUB$PROCESS_ORDER API. Cause: java.sql.SQLException: ORA-00902: invalid datatype
      [Caused by: ORA-00902: invalid datatype
      ]
      ; nested exception is:
           ORABPEL-11811
      Error while trying to prepare and execute an API.
      An error occurred while preparing and executing the APPS.XX_BPEL_WRITEEDIDATA2ORACLESER.OE_ORDER_PUB$PROCESS_ORDER API. Cause: java.sql.SQLException: ORA-00902: invalid datatype
      [Caused by: ORA-00902: invalid datatype
      ]
      Check to ensure that the API is defined in the database and that the parameters match the signature of the API. Contact oracle support if error is not fixable.
      </summary>

      I am not sure how to go abt it.
      Any inputs would be appreciated.

      Regards
      Lalit