You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Data conversion in peoplesoft

5 replies [Last post]
krisvamsi2005's picture
User offline. Last seen 7 years 16 weeks ago. Offline
Joined: 03/11/2008
Posts: 17

HI All,

I am working on a conversion. I have to pull the data from the staging tables into the sPro Application tables.I have large amount of data that has to be pulled.

Could you please tell me the approach that I have to go ahead with to pull the data successfully into sPro App tables.There are lot of validations to take place before the data gets loaded into PS App tables.I am thinking of loading the data from the staging table into a temporary table, do the manipulations in the temporary table and then load the data within the temporary table into the PS app tables

It would be great if you can let me know if there are any delivered PS programs in FSCM which does a similar type of functionality.

Thanks

Thanks,
Vamsi Krishna

Lepa's picture
User offline. Last seen 2 years 2 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Data conversion in peoplesoft

The Create Purchase Orders Application Engine (PO_POCREATE) looks at PO staging tables and create POs on the core tables. Take a look at it, it might help.

Good luck!

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

krisvamsi2005's picture
User offline. Last seen 7 years 16 weeks ago. Offline
Joined: 03/11/2008
Posts: 17
Re: Data conversion in peoplesoft

thanks for the input Lepa

Thanks,
Vamsi Krishna

Guest's picture
Guest (not verified)
Re: Data conversion in peoplesoft

Hi ,

I have to convert Accounts Payable data from peoplesoft 8.4 to 9.1.Can anypone guide me with the approach to follow on this.Just a guideline will do.

Thanks,
Achin

Guest's picture
Guest (not verified)
Re: Data conversion in peoplesoft

Can anyone tell me the approach to convert Accounts Payable from peoplesoft 8.4 to 9.1.

SunLight19's picture
SunLight19 (not verified)
Re: Data conversion in peoplesoft

In the past I have done the Data conversion from legacy to PeopleSoft as part of an implementation project. Our approach:
1)Data from the legacy system was dumped into our PeopleSoft's Oracle database under a different schema.
2)Created temporary tables with record structure as that of the application tables with in the PeopleSoft database.
3)Created a component interface based on the Component where the data needs to be converted to. Eg: Items, POs, vouchers etc
4)Created an Applicaton Engine program. This program first gets the legacy data based on the required criteria and populates the PeopleSoft's temporary tables. Then reading each row from these temporary tables, loaded into PeopleSoft application tables using the component interface. We had two fields in each temporary table(Error Flag & Error Descr) to error track which rows were successfully converted. If any row fails, we are also trapping the error message as to why it failed.

Using this apporach we can make sure that all data is converted successfully. Comp Interface ensures that all the business rules & logic are applied on the data that is converted. In some scenarios it may not be possible to use CIs in which case you can use SQL inserts in its place.