Hi, When a employee undergoes hiring process in peoplesoft V9.0, does his user profile gets automatically generated? If this is possible, please could you give me the steps to do the same. Thanks in advance. –Asha

Thanks for posting your question!

As per PeopleSoft delivered process, User Profile is not at all created while hiring a Person. But we can use the below options to create the same.

  1. Create a Process to generate User Profile for a new hire and then call that process while hiring
  2. Create a Generic Batch Process to create a User Profile for a new hire
  3. Using IB, we can create a User Profile while hiring

Thanks

Kannappan K

Hi,I have to write an inbound program to read multiple files and processing them in PeopleSoft. After processing I have to move them to different folder.

1)How to handle multiple file in peoplecode (first I have to search for files In particular place then I have to process one by one )
2)How to move processed files to dump folder.

We are using Peoplesoft Finance 9.0 and Tools 8.48 , NT server, SQL server 2005 data base.

Thanks for posting your question!

Below are the steps to be done by using Application Engine:-

1. Execute FTP/OS commands to search for files by using EXEC or WINEXEC built-in functions

2. Using GetFile function to read the remote file

a. Used the Filename directly only when we read only one File

b. In case of multiple files, Filenames should be stored in a table and then use GetFile function(to read the files) by looping through data on the table

3. Either we can directly read the data on the file or we can read the data by using FileLayout for the file (Use SetFileLayout  method to assign the File data to FileLayout object and then use ReadRowset method to read the data)

a. Based on the input file format, we need to decide the reading of data on the file

b. Say for example, if the input file is of CSV format, we can read the data by both ways. But the simple way is to read directly by using GetFile andSplit

(Used to split the data based on delimiter) functions

4. Execute FTP/OS commands to move the processed files to the specified locations by using EXEC or WINEXEC built-in functions

Thanks

Kannappan Krishnan

Hi,can u explain how to read multiple data’s from a flat file(csv) to database using component interface

Thanks for posting your question!

Below are the steps to be done by using Application Engine:-

  1. Using GetFile function to read the remote file
    • Use the Filename directly only when we read only one File
    • In case of multiple files, Filenames should be stored in a table and then use GetFile function(to read the files) by looping through data on the table
  1. Either we can directly read the data on the file or we can read the data by using FileLayout for the file (Use SetFileLayout  method to assign the File data to FileLayout object and then use ReadRowset method to read the data)
    • Based on the input file format, we need to decide the reading of data on the file
    • Say for example, if the input file is of CSV format, we can read the data by both ways. But the simple way is to read directly by using GetFile andSplit(Used to split the data based on delimiter) functions

  1. Data Processing can be done either by using Peoplecode or using Component Interface
  2. If it is Component Interface(CI),  use below mentioned steps in Application Engine
    1. Get the current session using %session
    2. Call the Component Interface by using one of the Session methods GetCompIntfc ( SessionApiObject.GetCompIntfc(CompIntfc.CI Name) )

Before Calling CI, CI should be tested by using Test Component Interface Popup menu option in Application Designer. This menu option will be applicable only when we open the CI in Application Designer.

    1. Setting the True/False Boolean value to CI modes ( Interactive / GetHistoryItems / EditHistoryItems)
    2. Assigning the values to Key Fields of the Component Search Record
    3. Calling CI methods – Get/Create (Based on requirement, call either of these methods.)

Create method will be accessible only when the Component is having ADD action mode

    1. Assign values to all the Collection Fields of the CI (Collection Fields are nothing but Record Fields present in each Levels of the Component)
    2. Call CI method – Save to save the data into the database
    3. Finally call CI method – Cancel to close the CI sessions

Thanks

Kannappan K.

Posted by Nitin Pai
Comments (0)
September 5th, 2008

Comments (0)