Oracle PeopleSoft File Layout Tutorial - Basics to Advanced - Siva Koya

Subscribe - 👉tinyurl.com/pe...
In this tutorial, you will learn
What is File Layout?
Steps to load File data using File Layout?
How to import simple file data using File Layout?
How to import complex file data using File Layout?
Episode 1
Oracle PeopleSoft File Layout Tutorial (Basics to Advanced)
• Oracle PeopleSoft Fil...
Episode 2
Oracle PeopleSoft File Layout Tips & Tricks
• Oracle PeopleSoft File...
Episode 3
Mastering Data Export in PeopleSoft Application using File Layout
• Mastering Data Export ...
#peopletools #peoplesoft

[@srinivasb8299]

Excellent for new learners

[@PeopleSoftChannel]

Thank you Srinivas for taking the time to share your feedback here. I really appreciate it.
Thanks,
Siva

[@elsichannel4552]

Great. That shows greatness of Peoplesoft even in 2024.

[@PeopleSoftChannel]

I agree. PeopleSoft is still most flexible ERP software out there in the market.
Thanks,
Siva

[@raziashaik674]

wonderful explanation

[@PeopleSoftChannel]

I am glad to to hear my content was helpful to you 😊

[@lawrencelaw12]

Thanks for your teaching of PeopleSoft!

[@PeopleSoftChannel]

You're Welcome

[@punnaspoorthy7136]

What if the input file contains first 10 rows of data as empty and if the file is corrupted

[@Parameshwar5678]

Thanks bro.. eagerly waiting for next session

[@PeopleSoftChannel]

Thank you for letting me know. I am working on it.
Thanks,
Siva

[@aayushigupta9550]

@PeopleSoftChannel thank you for teaching. Excellent Video

[@PeopleSoftChannel]

Thank you for your encouraging words 😊. It means a lot to me.
Thanks,
Siva

[@jormantag]

Greetings Siva, how can this processing be implemented but with an .xlsl file?

[@PeopleSoftChannel]

Hi @jormantag,
I believe File Layout only supports CSV format not .xls file
If you want to export PeopleSoft data to .Xls format I would recommend to use BI Publisher report.
Thanks,
Siva

[@TheKingsCamp]

Excellent tutorial! Would you be able to demonstrate how and where in the code to modify a field during import?

[@PeopleSoftChannel]

Could you please elaborate on your question please?
Thanks,
Siva

[@TheKingsCamp]

Hi Siva, using a chart of accounts as an example: If when a row is getting imported and has Account field = 123 AND DepartmentID field = 456 Then update the ProjectID field to 999999 for that row@@PeopleSoftChannel

[@punnaspoorthy7136]

Can we use inbound and outbound in the same application engine ?

[@PeopleSoftChannel]

Thank you for reaching out. Yes this is possible. You can create a separate step for inbound and outbound in your app engine program and include appropriate PeopleCode logic