Peoplesoft Admin Interview Questions

Any and all sys audit related discrepancies can and should be resolved using People Books Reference : How to Run SYS AUDIT report. For each discrepancy there is a specific set of actions and some of t...

Orphaned Records

Synchronus Process

IGNORE_DUPS & UPDATE_STATISTICS

Ans:-  Grant User & ENCRYPT_PASSWORD

Before asking the DBA to truncate the table, we can check the number of rows in that table, followed by table truncation, and for stats we can populate fake stats using the row count number before table truncation.

One way to handle such temp tables is to delete stats and then lock stats so that the scheduled update stats job does not update stats on them. One example I have is the PS HRMS (Oracle DB), &quo...

The tool for migration will depend on the type of customization.
If the changes are data related then you can create Data Mover scripts. If its PeopleSoft Object then it can be moved using the App Designer. Its is assumed that it is tested and staged in UAT before moving to Prod.

Application Disgner : To move customization from Dev to prod database

Or You can user Questat tool to move customization from one database to other.

Using tmadmin we can start the process scheduler
psadmin -p start -d database name.

1) Client status
2) Queue status
3) Server status

2. In REN Server, How would you allocate buffer size?... ANS :You can set io_buffer_size parameter of PSRENSRV section in psappsrv,cfg file. Ex., [PSRENSRV] ;=====================================...

You can set io_buffer_size parameter of PSRENSRV section in psappsrv,cfg file.  Ex.,[PSRENSRV];=========================================================================; Event notification server...

1.How can we trace PeopleCode in Application Engine ...

ans: In Config Mangager check the People code that need to trace

Regards

Go to below navigation: PeopleTools-> Process Schedular-> Processes. Enter Process name and then go to the override tab. Enter the trace option as per your requirement(below is an example) -TRACE 391 ...

Using Db owner id and Password

Using Peolesoft Dababase SuperUser(Access id)

we have to apply patches only after install new software . then we have to run ptpatches.dms to updaqte peopletools about it

we have to apply patches only after installing new upgrade software .

PIA Components:-

3 mandatory components :

1) Web Server 2) Application Server 3) Database Server

Optional components

1) Batch Server

PIA Components can be classified into
1. Web server
2. Application server
3. Batch server

We need to compare the peoplesoft objects by generating compare report before and after migration using Application Designer:
We need to notice two things in the Appdesigner:
1)the UPGRADE tab should be checked
2)the DONE tab should be unchecked

We should compare objects before and after migration to ensure whether all objects are migrated successfully or not.Because  sometimes developers may forget to include a particular object&nb...

First it should be applied on DEMO and then to dev/test environments.

The relationship between a database server and an application server is a one-to-many model.That is, a single database server can have multiple application servers connecting to it. Thedatabase server...

oracle

A forced shutdown is a nonquiescent shutdown that immediately terminates all of the processes in the domain. Normally, you use the forced shutdown only when a Bulletin Board Liaison (BBL) process encounters errors and cannot be shut down by using a normal shutdown.

8.42

Change Assistent tool and Purge cache not avaliable.

8.46

Purge cache option avaliable in Peoplesoft Administraton Domain menu

Change assistent tool avaliable in $PS_HOME

The best way to find out differrences is to analyse rel DMS scripts from 8.42 to 8.46 like rel843.dms etc.

When you build the table, check the Alter table option, and in options under Alter tables tab, select alter with table rename.
Once you build the project, then run the script to alter the table
This will keep all the data.

While building the record options select Alter table Chekc box.