Tuesday, May 31, 2011

Peoplesoft Inbound integration

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. 2015810409Integration Gateway Error

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

  
  PURCHASE_REQUISITION_LOAD 
  Async 
  PSFT_EP 
  PSNEW 
  
   
   
   
  
 
  EP840MST 
  
 
 
  N