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!

thanks for the input Lepa

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

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

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.