Home » Applications » Oracle Fusion Apps & E-Business Suite » Not able to create PO with XML gateway (R12)
Not able to create PO with XML gateway [message #392019] Mon, 16 March 2009 00:58
nageshy
Messages: 1
Registered: March 2009
Junior Member
Hi,

We are using XML gateway for Creating PO in Oracle EBS.
We are using Inbound XML gateway.

The Transaction monitor shows the message to be completed sucessfully, whereas we are not able to see the PO in Oracle Sales Order.
1) oe_order_headers_all
2) Sales Order Oracle Form







Transaction monitor Shows the following deatils:

Document ID OT7

Internal Control Number 1893

External Transaction Type PO

External Transaction Subtype PROCESS

Party ID 4429

Party Type

Trading Partner Name N/A

Site Name N/A

Processing Date 10-Mar-2009 15:47:03

Processing Status Success

Processing Message Message successfully processed.

Module Name ecx.plsql.OAG.in.PO.PROCESS.1514.log







The transaction Partner details are as follows


Trading Partner Type : 'Customer' (without quotes).
Trading Partner Name : 'Business World' (without quotes).
Trading Partner Site : '2391 L Street San Jose CA 95106' (without quotes).

Transaction type = 'ONT'
Transaction sub type = 'POI'
Standard Code = 'OAG'
External transaction type = 'PO'
External transaction subtype = 'PROCESS'
Direction = 'IN'
Map = 'ONT_3A4R_OAG72_IN'
Source Trading partner location code = 'BWSANJOSE'












The SOAP message is as follows for Invoking the XML Gateway:

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header>
<ns1:XMLGateway_Header xmlns:ns1="http://xmlns.oracle.com/apps/fnd/XMLGateway">
<MESSAGE_TYPE>XML</MESSAGE_TYPE>
<MESSAGE_STANDARD>OAG</MESSAGE_STANDARD>
<TRANSACTION_TYPE>PO</TRANSACTION_TYPE>
<TRANSACTION_SUBTYPE>PROCESS</TRANSACTION_SUBTYPE>
<DOCUMENT_NUMBER>OT7</DOCUMENT_NUMBER>
<PARTY_SITE_ID>BWSANJOSE</PARTY_SITE_ID>
</ns1:XMLGateway_Header>
<wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" soapenv:actor="" soapenv:mustUnderstand="0">
<wsse:UsernameToken wsu:Id="UsernameToken-21762307" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
<wsse:Username xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">Operations</wsse:Username>
<wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">welcome</wsse:Password>
</wsse:UsernameToken>
</wsse:Security>
</soapenv:Header>
<soapenv:Body>
<ReceiveDocument xmlns="http://xmlns.oracle.com/apps/fnd/XMLGateway">
<PROCESS_PO_007>
<CNTROLAREA>
<BSR>
<VERB>PROCESS</VERB>
<NOUN>PO</NOUN>
<REVISION>007</REVISION>
</BSR>
<SENDER>
<LOGICALID/>
<COMPONENT>BPEL</COMPONENT>
<TASK>POISSUE</TASK>
<REFERENCEID>refid</REFERENCEID>
<CONFIRMATION>2</CONFIRMATION>
<LANGUAGE>ENG</LANGUAGE>
<CODEPAGE>US7ASCII</CODEPAGE>
<AUTHID>APPS</AUTHID>
</SENDER>
<DATETIME qualifier="CREATION">
<YEAR>2002</YEAR>
<MONTH>10</MONTH>
<DAY>09</DAY>
<HOUR>16</HOUR>
<MINUTE>45</MINUTE>
<SECOND>47</SECOND>
<SUBSECOND>356</SUBSECOND>
<TIMEZONE>-0800</TIMEZONE>
</DATETIME>
</CNTROLAREA>
<DATAAREA>
<PROCESS_PO>
<POORDERHDR>
<DATETIME qualifier="DOCUMENT">
<YEAR>2002</YEAR>
<MONTH>10</MONTH>
<DAY>09</DAY>
<HOUR>16</HOUR>
<MINUTE>40</MINUTE>
<SECOND>34</SECOND>
<SUBSECOND>000</SUBSECOND>
<TIMEZONE>+0100</TIMEZONE>
</DATETIME>
<OPERAMT qualifier="EXTENDED" type="T">
<VALUE>107.86</VALUE>
<NUMOFDEC>6</NUMOFDEC>
<SIGN>+</SIGN>
<CURRENCY>USD</CURRENCY>
<UOMVALUE>1</UOMVALUE>
<UOMNUMDEC>0</UOMNUMDEC>
<UOM>Ea</UOM>
</OPERAMT>
<POID>refid</POID>
<POTYPE>Mixed</POTYPE>
<CONTRACTS/>
<DESCRIPTN/>
<NOTES index="1"/>
<USERAREA/>
<PARTNER>
<NAME index="1"/>
<ONETIME>0</ONETIME>
<PARTNRID/>
<PARTNRTYPE>SoldTo</PARTNRTYPE>
<PARTNRIDX>BWSANJOSE</PARTNRIDX>
</PARTNER>
</POORDERHDR>
<POORDERLIN>
<QUANTITY qualifier="ORDERED">
<VALUE>1</VALUE>
<NUMOFDEC>0</NUMOFDEC>
<SIGN>+</SIGN>
<UOM>Ea</UOM>
</QUANTITY>
<OPERAMT qualifier="UNIT" type="T">
<VALUE>107.86</VALUE>
<NUMOFDEC>6</NUMOFDEC>
<SIGN>+</SIGN>
<CURRENCY>USD</CURRENCY>
<UOMVALUE>1</UOMVALUE>
<UOMNUMDEC>0</UOMNUMDEC>
<UOM>Ea</UOM>
</OPERAMT>
<POLINENUM>1</POLINENUM>
<ITEMRV/>
<NOTES index="1"/>
<ITEM>LAP-DLX</ITEM>
<POLINESCHD>
<DATETIME qualifier="NEEDDELV">
<YEAR>2002</YEAR>
<MONTH>10</MONTH>
<DAY>09</DAY>
<HOUR>00</HOUR>
<MINUTE>00</MINUTE>
<SECOND>00</SECOND>
<SUBSECOND>000</SUBSECOND>
<TIMEZONE>+0100</TIMEZONE>
</DATETIME>
<QUANTITY qualifier="ORDERED">
<VALUE>1</VALUE>
<NUMOFDEC>0</NUMOFDEC>
<SIGN>+</SIGN>
<UOM>Ea</UOM>
</QUANTITY>
<PSCLINENUM>1</PSCLINENUM>
<USERAREA/>
</POLINESCHD>
</POORDERLIN>
</PROCESS_PO>
</DATAAREA>
</PROCESS_PO_007>
</ReceiveDocument>
</soapenv:Body>
</soapenv:Envelope>

Can please some body help me out where we are going wrong.
Please find the zip file for further deatils and errors.

Nagesh,
Previous Topic: Price List Security across Operating Unit
Next Topic: error while install EPS
Goto Forum:
  


Current Time: Sun Dec 04 13:06:29 CST 2016

Total time taken to generate the page: 0.09734 seconds