Inbound process in peoplesoft

Q:  how to export data from CSV file to multiple application tables by using filelayout and application engine with code ?

Ans: You can use App Engine,File Layout and Component Interface concept for this. 

Steps: 

1) Create Component Interface for the component in which your application tables exists 
2) Now write app engine program. 
Steps in AE: 
a) Read the data to staging table by using file layout. 
b) after loading the data, use CI concept to load the data in to your application tables.

Q: My exact requirement is to upload the data from CSV file to Peoplesoft 

Delivered tables using staging tbale,file layout and app engine. For this requirement, I have created a staging table, file layout and when I dragged file layout into app engine Peoplecode action then I ran the process data will upload to the staging table only. 

But in this I need to send data into 4 application tables from this staging table. 

Can you please suggest what actions would be needed for this requirement? 

Ans:After loading the data in to the staging table by using file layout concept, do the following 

1) Create the CI for your component (in which your application tables exists). 
2) Test the component interface after giving the security. 
3) Create one more step (people code action) after the file layout coding in the App Engine. 
4) Drag and drop the CI in to the people code action. 
5) Get the staging table values one by one into state record and assign these values to the your component rec fields (i.e your application tables). 

Or alternatively , after step 4 above, there could be one peoplecode action where there is a loop through to upload data from your staging tables to App tables by using the classic methods of inserting data using peoplecode.