Employee ID Series based on Category

Many times there is requirement to have diffenre series of employee ID, instead of having only one Generic series. To elaborate more say different series like RG00001 for Regular series of employee, CW00001 for Contract employee and so on. This article describes how this can be achieved in PeopleSoft HR.
Last Employee ID generated is stored in PS_INSTALLATION Table. TO achieve this

1. First step is to create a custom place holder to store LAST Id for different category. The structure of table can be something like
CATEGORY PREFIX LAST ID
Regular RG 10001
CWR CW 10001
2. Next, we need to customiz the function where delivered code to generate ID is written.
3. Open FUNCLIB_HR.EMPLID.FieldFormula and modify the function to get the last number.

Function AssignNextId(&Recname As string, &Fieldname As string,

....

If &Fieldname = "EMPLID_LAST_EMPL" Then
&NextId = GetNextAutoNumber(recordname, LastID);

4. Save and Test

PeopleSoft and sLDAP

Here are the steps to be followed to configure Secure Active Directory Integration through PeopleSoft.

Step1:- Create Wallet manager for Application Server

Step 2: Launch Oracle wallet Manager (owm)

Step 3: Create a New Wallet (Wallet> New)

Step 4: Set the Password for New Wallet.

Step 5: Click No when prompted for requesting certificate. We will import the Root CA at Later point of time.

Step 6: Go to Operations > Import Trusted Certificate to import Root Certificate.

Step 7:- Click OK to select a file. This will ask to select a file

Step 8:- If certificate is not available, you can select option “paste the certificate” (Optional).

Step 9:- Choose the Certificate file, which you want to import. Now, you will see a new entry for your root CA certificate Or Select Paste the certificate option to paste certificate. (Optional)

Step 10:- Save the wallet

Step 11:- You will be prompted for the location to save the wallet, Put it under “/psoft/pt848/hr90/install/wallet”

Step 12:- Now you will see a file called ewallet.p12 file under /psoft/pt848/hr90/install/wallet. You will need this file for the SSL connection in PeopleSoft.

Step 13:- Test the connectivity using secured port with LDAPSEARCH provided by Oracle Client installation. You can find it under $ORACLE_HOME/BIN (eg. /oracle/product/10.2.0/BIN)
ldapsearch -h <> -p 636 -W "file:/psoft/pt848/hr90/install/wallet" -P Welcome1 -U 2 -D "<>" -w "wallet Password" -b "Base entry" "objectclass=*"

Step 14:- Repeat above steps to create wallet on Process Scheduler Server.

Step 15:- Business Interlink Change in Application Designer

Step 16:- Open Business Interlink LDAP_BIND and set Port as 636 under Input Tab

Step: 17 Select the Setting tab and set following parameters
SSL= YES
SSL_DB = file:<> (e.g. file:/psoft/pt848/hr90/install/wallet)
SSL_DBPW = Wallet Password

Step 18 Repeat above steps for Business Interlink LDAP_SEARCH.

Step 19:- Navigate to Enterprise components > Directory Interface > Definition > Directory Configurations. Set the SSL Port to 636.

Step 20:- Click on “Test Connectivity” Tab.