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,
|
|
|