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 

 

 

Table of Contents - Learn Chinese, Free online audio courses

Table of Contents - Learn Chinese, Free online audio courses

Dynamic View

Today I tried something new . I have craeted a dynamic view and placed it as prompmt table . During tetsing user entered a wrong value and page allowed him to submit it . Strange , recoed field propertied has the prompt with edit field on .. tried various P&C , it didnot work . Then I concluded there si some issue with this combination , had to write a validation people code .

Do Select Statement in application engine

Do select always mystify me in application engine . Today I did a small test to understand who it really work . This hands one need a small project in app designer

1. TEST record ( It has three rows)
2.TEST_AET
3.PS_AE Application engine :It will have a Do-Select statement and a subsequent Peoplecode

%Select (BUSINESS_UNIT )
SELECT BUSINESS_UNIT
FROM PS_TEST

Peoplecode :

Local File &myfile;
&myfile = GetFile("testfile.log", "a", %FilePath_Relative);
&myfile.WriteLine(" my name is ");


A) First I made it reselect .


What would be output : Yes it will go infine because reslect always open a new cursor every time . So after 10 min u will have a huge file and u need to kill the file . Now change the code

%Select (BUSINESS_UNIT )
SELECT BUSINESS_UNIT
FROM PS_TEST
where business_unit <> ' '

Local File &myfile;
&myfile = GetFile("testfile.log", "a", %FilePath_Relative);
&myfile.WriteLine(" my name is ");
SQLExec(" UPDATE PS_TEST SET BUSINESS_UNIT =' ' ");

I didnot put any exclusive commit and commit level was default . bingo it did work as charm .


B) Made it restartable

%Select (BUSINESS_UNIT )
SELECT BUSINESS_UNIT
FROM PS_TEST

Peoplecode :

Local File &myfile;
&myfile = GetFile("testfile.log", "a", %FilePath_Relative);
&myfile.WriteLine(" my name is ");

bingo it had only one line , because in restartable it keep same cursor for a long time .

and in last but not least

select fetch ... it is like restartable but no commit work in between ... ,

Cannot Import Package

Hi All

One more new thing for 2day , I tried to import a class but Got an error "

Package not found , but that package was in my class ... After banging on my head on wall for 10 minute I figured out classes are case sensitive ... so used to normal People coding :-)

Wipping out date from the page

Today I had a small and silly requirement . MY manager asked me to remove date field from page if one of the field is not present . Bingo : I got caught , How to remove the date

1. I tried to be clever and assign "" to date field but it didnot allow me to save the page ..
2. Then tried to assign NULL to the fields , oops so sad page has NULL instead of the blank values .
3. at lease I passed a local variable to assigneed it to my system . bingo it worked like charm ...


Took 15 minute to work it out , got a good feeling from inside :-)

CI Based WEb Service

For a customer we are implementing a CI based web service , Though I am not involved in the project still I am passive developer . One of my team mate asked me a question on webservice migration .

After initial Google search , I came across following results :

All Peoplesoft objects can be migrated along with Peoplosft project like service , service operation , operation handler and message . To migrate message schema we need to run psibmsgschema_exp.dms (export) and psibmsgschema_imp.dms scripts similarly psibwsdl_exp.dms (export) and psibwsdl_imp.dms (import) to migrate the WSDL to migrate WSDL