Today , I got an opportunity to work on Peoplsoft inbound XML integration work . I love in house work , because you can just play with any configuration , and there isn't any time limit . Exact requirement was to sync Requisitions details from third party system to People soft system . Initially we discussed about a custom CI based web service approach but some one told me about existing ERP loader .
Wolla !!! we have an existing service operation PURCHASE_REQUISITION_LOAD.. I just need to make routing , queue and other stuff active and I am good to go .I shared People soft gateway URL and input xml schema with other team and thought I am done ... Aww .. living in fool's paradise , nothing works in single shot when you work in people soft .
It didnot work , then I tried to test it through send master . Error was
1.20 158 10409 Integration Gateway Error
PURCHASE_REQUISITION_LOAD Async PSFT_EP PSNEW EP840MST N
Wolla !!! we have an existing service operation PURCHASE_REQUISITION_LOAD.. I just need to make routing , queue and other stuff active and I am good to go .I shared People soft gateway URL and input xml schema with other team and thought I am done ... Aww .. living in fool's paradise , nothing works in single shot when you work in people soft .
It didnot work , then I tried to test it through send master . Error was
1.
classic peopelsoft error . : I looked closely and understood my mistake . I need to give httplistner error
http://<>webserver>/PSIGW/HttpListeningConnector
2. Did it help , no ....I pasted my XML and thought it will work ...Na It will not do t
"The server encountered an unexpected condition which prevented it from fulfilling the "
then I realize something wrong with my xml ... I forget to include header in my xml . A sample one is attached here
This comment has been removed by the author.
ReplyDeleteThe third party team with whom I was working , was using an XSLT program to transfer this message . It seems that their XSLT cannot parse this . Peoplebook jhas suggest another way of doing that ... Using the query string peoplesoft httplistner url
ReplyDeletehttp:///PSIGW/HttpListeningConnector?&Operation=PURCHASE_REQUISITION_LOAD&OperationType=Async&From=PSFT_EP&Password=&OrigUser=PSNEW&OrigNode=&OrigProcess=&OrigTimeStamp=&FinalDestination=PSFT_EP&To=&SubChannel=&NonRepudiation=N&MessageVersion
wollad ! same results ..