Issue while performing People Tools 8.51 Upgrade May 24, 2011
Posted by Nilotpal Mrinal in PeopleSoft, Uncategorized.Tags: People Tools Upgrade, PeopleSoft, PeopleSoft Upgrade
7 comments
Currently I am doing an application Upgrade from FSCM 8.9 to 9.1. As part of that we are upgrading Tools from 8.48 to 8.51.
While running DBTSFIX.sqr, we faced this error -
SQR 1500: (SQR 1500) Array element out of range (32767) for array ‘a_dbts_list’ on line 125.
We tweaked the sqr as below -
Locate the create-array name=a_DBTS_list statement in sqr.
Update the size of the array to 131070 (double the delivered size of 65535).
This help us run the sqr successfully. Oracle validated the fix later.
I hope this will help folks who are upgrading to Tools 8.51.
Load-Balancing setup for verity January 7, 2011
Posted by Nilotpal Mrinal in PeopleSoft.Tags: People Tools, PeopleSoft, Verity
add a comment
Sometimes we get load-balanced environment where we might have multiple(2/3) application server,process scheduler and a web server.
To setup verity in such environment -
- We have to create a shared location which is accessible by all servers.This will be the location where indexes will be created and application server will search for them.
- We have to make following changes in application server configuration file -
Modify the section “[Search Indexes]” with values -
RSFSRA =//shared_location
RSFSRB = //shared_location
- We can do the same for specific indexes ( like Resumes in Candidate gateway).
- Make the above changes in all other application server( different machine) configuration files.
- Make the above change in Process Scheduler configuration file too.
- Clear cache and Restart app/web and process scheduler.
This will help you setup verity in load-balancing environment.
Monitoring Application Server September 30, 2010
Posted by Nilotpal Mrinal in PeopleSoft.Tags: application server, monitoring, PeopleSoft
3 comments
Recently , I came across a situation where an application server domain should be monitored always and whenever it is down , an email should go to concerned team.
Application server was on a windows 2003 server.
To get an email , first of all we need to setup SMTP in psappsrv.cfg. Then we will require any kind of third party tool like bmail or sendmail. I have used sendmail.
I have written a bat file which runs infinitely , and gather application server status after every 1 minute and take this output in a text file . Whenever application server is up , it will have BBL.exe process running . Search for ‘BBL.exe’ in text file and if found do nothing , delete the text file and continue the infinite loop.
If not found , go to send mail procedure , which will send emails to an individual or a group , and will keep mailing at fixed interval until application server is up.
Enabling Bypass Signon January 24, 2010
Posted by Nilotpal Mrinal in PeopleSoft.Tags: Forgot Password, People Tools, PeopleSoft, PeopleSoft Signon
2 comments
Happy New year to all of you.Its been long since my last post.
Recently I was implementing forgotten password functionality in PeopleSoft. Earlier it was taken care by Portal. But now customer is decomissioning Portal system they want to implement this functionality on Finance homepage.
The first step for this was to create a new site and make it bypass signon enabled.
Even for a single server domain , multiple sites can be create. The http port will be same. Once the site is created , make following changes to configuration.properties file and bounce the webserver.
byPassSignOn = True
defaultUserId = <UserId>
defautltPWD = <UserPwd>
Also make public access enabled in Web Profile for the user id given in configuration.properties file.
After that change the PIA link from http://<myserver>/psp/<sitename>/?cmd=login to http://<myserver>/psp/<sitename>/?cmd=start.
This change makes webserver to check for bypass signon , and thus didn’t ask for authentication.
Once this is set you can create an userid with appropriate permissions ( which will only access forgotten password component ) and give that as a direct link on the signin.html page.
Benefits in Singapore January 2, 2010
Posted by Ken in Benefits, HCM/HRMS, PeopleSoft.add a comment
Neil, I am finally here. This is my first post. I think in 2009 you cursed me enough. I made you change the appearance and name too. But never posted anything till today. But finally I am posting. My long lost wish.
Now I am your partner.
The easiest thing I can write at this time is the project I am working now. We are implementing benefit system for one of our customer in Singapore. Now if you have worked in past with North American customers then need to remember that systems here is far more simplified. But for developer it becomes more difficult as we are actually developing a bolt-on. We found PeopleSoft’s Base Benefits and Ben Admin systems far complicated then the need of the customer.
Like employers around the world companies here in Singapore provide similar benefits related to medical & dental insurance, reimbursement of health screening, hospitalization & surgical expenses. There are also other benefits like leave and vacation which are managed in PeopleSoft’s Absence system. Traditionally and in NA we used to calculated leave and vacation entitlement in Benefit system as rules were highly simple. Here rules are not very complicated but types of leaves are too many to manager in Benefit system. Hence Absence Management is used. It provided great rules processing and delivered integration with Global Payroll system.
Back to benefits. Much of what I am going write here is about my client, because this is my first and only project related Benefits in this region. We have primarily Medical, Dental, Health Screening, Hospitalization and Surgical, and Travel Insurance benefits. Apart from there are many allowances and fringe benefits but they are outside the scope as they are managed in Payroll system.
Medical benefits include cashless service at panel clinics, doctors, polyclinics (govt hospitals) and private hospitals. It can be reimbursement if patient visit doctor or clinic not on panel of the employer or insurance company. This benefit is applicable to General Practitioner or Specialist. Specialist claims are subject to letter from GP. All the reimbursements are subject to 10% co-payment by employees. The monetary value of the provided benefit is not very exciting and it has too many rules on policy document. Fortunately customer did not expect us to implement all of them.
But that is Asia. Lack of trust.
Dental claims are subject to reimbursement of S$ 150 to S$ 250. Very simple. Not much of the rules.
Health Screening reimbursements are provided to employees over the age of 40. Till 45 you get 1 health check paid by company in two years. After 45 you get same benefit every year. This is primarily for management and staff above that grade/band.
Travel Insurance is for all staff members who travel for company business. They are eligible to standard travel insurance that is fully outsourced.
Hospitalization and Surgical claims can be made by all employees based up on their eligibility. Eligibility varies in the form for total amount, type of hospitals, beds and services selected.
Unlike NA, here employee do not contribute any amount towards premium for medical and dental insurance.
This was in nutshell. There are different kind of eligibility rules and automatic processing which we have developed. Consider this as initial draft and starting point. Buzz if you have any questions. That will make this post more interesting and complete.
Thank you Neil for making me a partner. And this post good or bad is dedicated to you.
Consider this as new year gift.
Large demo database on PeopleTools 8.48 and above September 25, 2009
Posted by Nilotpal Mrinal in PeopleSoft.Tags: People Tools, PeopleSoft Database size
add a comment
This increase in size is due to the PT8.48 enhancement for supporting locally managed tablespaces. This brings following changes to the XXDDL.SQL tablespace creation scripts:
1) Add SEGMENT SPACE MANAGEMENT AUTO clause
2) Change the EXTENT MANAGEMENT from LOCAL AUTOALLOCATE to LOCAL UNIFORM nnnK or nnnM
e.g.
OLD:
CREATE TABLESPACE PSINDEX DATAFILE ‘/u04/oradata/<SID>/psindex.dbf’ SIZE 160M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
/
NEW:
CREATE TABLESPACE PSINDEX DATAFILE ‘/u04/oradata/<SID>/psindex.dbf’ SIZE 2500M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO
/
The addition of the following clause to the tablespace script was the performance enhancement proposed.
SEGMENT SPACE MANAGEMENT AUTO
The change that impacts the footprint size was the storage allocation change from:
EXTENT MANAGEMENT LOCAL AUTOALLOCATE (This was the old way, it rendered a smaller DB footprint)
to
EXTENT MANAGEMENT LOCAL UNIFORM nnnk
While this is more efficient, this clause has the negative impact of causing the DB’s to have a bigger storage fooprint.
By using the combination below the Oacle DB’s result in a smaller storage footprint.
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
Starting with 8.48 Tools, the LOCAL UNIFORM option is being delivered as the default option for the Create TableSpace syntax. This brings better space management on future inserts, but also will dramatically increases the initial database footprint. It is possible to revert to the AUTO ALLOCATE option, which will minimize the initial footprint.
One possible workaround in one situation for a demo FSCM 9 database, was to reduce extent size for the PSINDEX tablespace. Instead of using the default extent size of 1MB, a reduced size of 512 KB is used.
Oracle has come up with updates which will bring these modifications , or if you download newer version of tools you will get the modifies scripts.
People Tools and Application Compatibility August 17, 2009
Posted by Nilotpal Mrinal in Uncategorized.Tags: People Tools, PeopleSoft
add a comment
To find the minimum People Tools version for your application:
In Metalink 3 click on the Product Certifications tab.
In the Certifications menu (immediately below the tabs but above the Search area) click on Product Roadmap.
For Calendar Year, choose All Years
For Calendar Quarter, choose All Quarters
For Product Line, choose PeopleSoft Enterprise
Click on Search.
In the Results, you can click on the Product Family column title to sort by Product Family.
Click on the link for your Product Release
Click on the triangle beside Technology to open up the Technology Release which is the minimum supported People Tools version.
This version is for installs only, not for upgrades. The minimum version does not include the Required for Installation People Tools patch.
For upgraded environments please refer to your Upgrade Homepage for your upgrade path.
For the maximum version of People Tools:
While PeopleSoft has a minimum People Tools version required for each application and version, there is no upper limit for applications that are 8.40 or greater.
So you can safely upgrade your People Tools without needing to upgrade your application.
But Enterprise Portal application is very closely tied to People Tools. Certain versions of Enterprise Portal require specific bundle levels for specific People Tools versions.
You should view Product Certification pages on Metalink 3 to see if your database, operating system and third party applications are supported on the newer version of People Tools
Application Designer Login in 3-tier and PC Debugger May 25, 2009
Posted by Nilotpal Mrinal in PeopleSoft.Tags: Application Designer, PC Debugger, PeopleSoft
add a comment
Open Configuration Manager -> Profile ->Edit.
Select Connection Type as Application Server.
Machine Name or IP Address should be your machine IP address on which application server domain resides.
Port Number should be WSL port number.

Turn on Debugger Service. Bring the following changes in your PSAPPSRV.CFG file
Psappsrv.cfg:
..[People Code Debugger]
;————————————————————————-
PSDBGSRV Listener Port=15000
.
..
[PSAPPSRV]
;=========================================================================
; Settings for PSAPPSRV
;=========================================================================
;————————————————————————-
; UBBGEN settings
Min Instances=2 Give >= 2
Max Instances=2
Service Timeout=0 Give >= 2
————————————————————
Go to PSADMIN -> Quick Configuration. Check whether the PC Debugger feature is enabled or not. Make it yes, and start the application server domain.

Open Configuration Manager -> Trace
In People Code Debugger Section, Local PSDBGSRV Listener Port number should be the same as provided in PSAPPSRV.CFG.

Handy Reference for Object Value and corresponding Object Type May 4, 2009
Posted by Nilotpal Mrinal in PeopleSoft.Tags: PeopleSoft
add a comment
ObjectValue and corresponding ObjectType according to PeopleTools 8.49- 0 Record 1 Index 2 Field 3 Field Formats 4 Translate 5 Page 6 Menus 7 Component 8 RecordPC 9 Menu People Code 10 Query 11 Tree Structures 12 Trees 13 Access Groups 14 Colors 15 Styles 16 Business Process Map 17 Business Process 18 Activities 19 Role 20 Process Definition 21 Server Definition 22 Process Type Definition 23 Job Defination 24 Recurrence Definition 25 Message Catalog 26 Dimensions 27 Cube Definitions 28 Cube Instance Definitions 29 Business Interlinks 30 SQL 31 File Layout 32 Component Interface 33 AE Program 34 AE Sections 35 Message Nodes 36 Message Channel 37 Message 38 Approval Rule Set 39 Message Peoplecode 40 Subscription PeopleCode 41 Channel PeopleCode 42 Comp Interface People Code 43 AE Peoplecode 44 Page PC 45 Page Field PeopleCode 46 Component Peoplecode 47 Component Record PeopleCode 48 Component Record PC 49 Image 50 Style Sheets 51 HTML 52 File Reference 53 Permission List 54 Portal Registry Definition 55 Portal Registry 56 URL 57 Application Packages 58 Application Package PC 59 Portal Registry User homepage 60 Problem type definition 61 Archieve templates 62 XSLT 63 Portal Registry User Favorite 64 MobilePages 65 Relationships 66 Component Interface Property PeopleCode 67 Optimization Models 68 File Reference 69 File Reference Type Codes 70 Archive Object Definition 71 Archive Template 72 Diagnostic Plug-In 73 Analytic Models 79 Services 80 Service Operations 81 Service Operation Handlers 82 Service Operation Versions 83 Service Operation Routings 84 IB Queues 85 XMLP Template Definition 86 XMLP Report Definition 87 XMLP File Definition 88 XMLP Data Source Definition
Project Backup April 6, 2009
Posted by Nilotpal Mrinal in PeopleSoft.Tags: Application Designer, Backup, PeopleSoft
1 comment so far
Batch program for taking daily backup of your PS projects -
- Create a text file including all the projects that need to be backed up.
- Create the batch file as below-
set pside=e:\PT849\bin\client\winx86\pside.exe
set folder=%date:~10,4%_%date:~4,2%_%date:~7,2%
set export_path=E:\projectexports\%folder%\
set dbtype=MICROSFT
set user=VP1
set pwd=VP1
set srcdb=FNDMO