PeopleSoft Learning

IPC resources are operating system resources, such as message queues, shared memory, and semaphores. When an application server shuts down properly all IPC resources used are removed from the system. In some cases, however, an application server may fail to shut down properly and stray IPC resources may remain on the system. When this happens, it may not be possible to reboot the application server.

The command to remove IPC resources, tmipcrm, resides in TUXDIR/bin. This command reads the binary configuration file (TUXCONFIG), and attaches to the bulletin board using the information in this file.

To list all IPC resources

"tmipcrm -n [TUXCONFIG]" (Ex. tmipcrm -n D:\PS\appserv\PSDEMO\PSTUXCFG)

To Clean/remove all IPC resources used by the BEA Tuxedo system

Application Server Command
tmipcrm -y /apps/psoft/pt844/appserv/PSDEMO/PSTUXCFG

Process Scheduler Command
tmipcrm -y /apps/psoft/pt844/appserv/prcs/PSDEMO/PSTUXCFG

This will remove the IPC resources associated that particular domain…

The ERP Connectors are used with the Integration Broker product. If you do not plan to utilize the Integration Broker portion of PeopleTools, reply NO to the prompt. If you do plan to use Integration Broker, reply YES to the prompt. If you reply NO to the prompt but then later decide to use Integration Broker you will have to go back and reinstall PeopleTools. The YES will cause files to be unloaded to your PsHome for use with the Integration Broker product.

Issue: While running the database Setup step during installation we received the error shown in the screen shot…

Solution:

Add this parameter in the Oracle DB parameter file & restart the DB.

NLS_LENGTH_SEMANTICS=CHAR

How to grant access for a User to perform object migration

To create user who can perform object migration from one environment to another environment, without having write access to the Application Designer objects like record, field, Application Engine, PepleCode etc.

Solution:

Login to PIA:

Go to Home > People Tools > Maintain Security > Use > Permission Lists open the permission list the user has.  Then go to People Tools tab, tick Application Designer Access.  You may set different objects permissions to read only if you click the links for Definition Permissions, Tools Permissions, and Miscellaneous Permissions.
You should have "full access" to project.

You can set Build script only or more in Build / Data Admin of Tools permission. Once the user has this permission list, the user should be able to migrate the project and build the project only.

With Peoplesoft Internet Architecture don't have local cache files on work station. All the cache files are on your Web Server and Application Server.

Web Server CACHE:

If you are using Web Logic as web server: The cache files are under Web Logic/My Server/Public_html/"PIA Instance name"/Cache.
If you are using Apache as web server: The cache files are under Apache Group/Apache/psftdocs/"PIA Instance name"/Cache.

App Server CACHE:

You also need to cache on App server domain which can even corrupt some times.
App server cache is located under your App server Box's PS_HOME/Appserv/"Domain Name"/Cache.

Workstation:

The only cache files on workstation when you use Peoplesoft Internet Architecture are Browser cache and cookies. You can delete browser cache from Internet Options->delete Temporary internet files.
Cookie, it downloads for the first time you signin for each PIA instance and every user you signed in from that work station's Browser. You can check these from Browser->tools->internet options->General Tab->settings Button->View files. You will see different files by name with cookie. The only way to delete them is manually each cookie or all the contents from this directory. Once you delete cookie, you get a new cookie created on browser when you sign back-in

To Change the Access ID password, possible methods are listed below:

There are ONLY 3 ways to do this. These options MUST be done in 2 tier and your application servers, Process Schedulers, and Web Servers MUST BE DOWN and ALL users need to be logged off if possible.

METHOD # 1 - (Preferred Method) Log into Data Mover as the Access ID (Bootstrap mode).

Then run this command:

CHANGE_ACCESS_PASSWORD sa1 (This is your symbolic ID) cloud123 (This is the new password for the Access ID);

And hit the Green traffic light.

NOTE - This method does NOT work in PT 8.14 or 8.15, but is now fixed in PT 8.16 (T-JPELAY-AU4QW) so use method 2 or method 3. You MUST also make sure that the password for the Access ID has successfully been changed at the Database level because prior to PT 8.17 this method would not change the database level password. To do this go through your SQL tool (SQL Plus, Query Analyzer) and make the change in the database users table.

METHOD # 2 - (Second best method) You need to change the Access ID Password at database level then log into Data Mover in bootstrap mode and run:

update PSACCESSPRFL set ACCESSID = 'what your Access ID is' , ACCESSPSWD = 'your New Access Password' , ENCRYPTED = 0, where SYMBOLICID = 'whatever the SYMBOLICID is';

Then run

ENCRYPT_PASSWORD *;

Note: If you have more than 45,000 rows in the PSOPRDEFN table then you may not be able to run the ENCRYPT_PASSWORD *; command in Data Mover. In that case just logon as a valid user in 2 tier and that will encrypt the Access ID in the PSACCESSPRFL table.

This will synch up the PSACCESSPRFL table with the same password stored at the database level for your Access ID.

METHOD # 3 - (Last and most discouraged method) Go into Application Designer / Tools / Miscellaneous Objects / Access Profiles.

Highlight the Symbolic ID and push the Edit button, enter the old password, new password, and confirm new password.

If you change it in Application Designer it does not change at the database level. This is because we do not GRANT to the database in PT 8. You MUST also make sure that the password for the Access ID has successfully been changed at the DB level. To do this go through your SQL tool (SQL Plus, Query Analyzer) and make the change in the database users table.

Creating HTML output from SQR

To use the HTML procedures listed below, your program must reference the HTML procedures.

Issue the following two commands at the start of your program:

#include html.inc

do html_on

The file html.inc is located in the SAMPLE (or SAMPLEW) directory.  Use the command-line flag -I to indicate this location.

There are 6 types of HTML procedure that can be used to easily create HTML o/p files.

General Purpose Procedures

Heading Procedures

Highlighting Procedures

Hypertext Link Procedures

List Procedures

Table Procedures

Eg:-        

1) Html_br

Produces the specified number of line breaks in a paragraph using the HTML<BR> tag.

This causes the paragraph to be continued onto the next line.

Syntax: html_br(number count, string attributes)

count    = the number of HTML <BR> tags that are inserted.

            Attributes          =          the HTML attributes that are incorporated inside the HTML <BR> tag.

Example: Producing a line break:

            Print 'Here is some text' ()

            Do html_br (3,'')

            Print 'Here is some three lines down' ()

2) Inserts an image using the HTML <IMG> tag. This can also be done using the command PRINT-IMAGE;

However, the procedure html_img provides the ability to specify the full set of available HTML attributes.

Syntax:             html_img (string attributes)

Attributes          =          the HTML attributes that are incorporated inside the HTML <IMG> tag.

Some common attributes:

Src       =          URL of the image to be inserted (Ex:  src=/images/abc.gif)

Height =            height of the image in pixels (Ex:  height=200)

Width   =           width of the image in pixels (Ex:  width=400)

Example:          Producing an image:

Do html_img('src="/images/stop.gif"')

-Posted by

Ganesh A.M

http://www.roughsea.com/vids/SQL_Best_Practices.html

-Ganesh A.M

Field default event Peoplecode in Peoplesoft

The People code in this event is used to initialize the default values for the fields in the component.

What happens when the field has default value defined in the record field properties and has People code assign the different value in the Field default people?

The Field default event People code will only fired when there is not default value defined for that field in the record field properties, so the value assigned in the record field properties will be initialized to that field.

-Ganesh A.M

Common Query Access Issues

a) User cannot see a table they wish to query from in query manage

   User does not have access to the table via one of their Access Group. Double-Click that they have the Proper Access group on one of their Permission lists an ad the table to an Access group if necessary.

b) A user cannot see a public query from search screen in either query manager or query viewer.

     Once you have determined that the query does in fact exist, and I s indeed a public query, then the user probably does not have access to all the tables being used in the query. If a user does not have access to all the tables involved in a query, the search screen itself will filter out the query, so that it does not even appear in the list. Double-Check that they have the proper Access group on one of their permission lists and add the table to an Access group if necessary.

Posted by

-Ganesh A.M

Row Level Security in Peoplesoft HRMS

The Default department security is name DEPT_SECURITY and the SetID is the share, although you may choose to create one to operate with a different Setid, depending on your environment.

Root level on this tree represents your company or organization. Below that you are adding departments in a hierarchical manner until you have built on organizational char of your company’s department structure.

When you click the link on one of department levels to either insert a child or a sibling node, you will be allowed to either choose an existing department that has been created or to create a new department on the fly by clicking Add.

Tie date Permission lists to Your Trees

Define Business Rules - > Administer HR systems -> Use -> Maintain Row level Security

1)       Select a Permission list – It needs to created in the maintain security menu.

2)       Peoplesoft standard is to generally preface them with DP

3)       In the Data security profile page, you need to add the Departments that this permission list will have access to.

4)       You need to provide SetID for the Department Security Tree you are using and then enter the DeptID for the node you are choosing.

5)       Department Security Tree is hierarchical, that by adding an access to a department, you are automatically granting access to all the departments below that node as well.

If you need to exclude the data from a particular ‘Sub-Department’ you will have need to add that department separately to this list, and choose ‘No Access’ as the Acess code instead of the default of ‘Read/Write’.

Change the security Basis for the System

The final step to implement Row level security in HR is to change all the search views controlling which data is accessed on various pages. Luckily you don’t have to change it manually change each one, as Peoplesoft has delivered a process that takes care of it all for you. Please note that you only run this Process when turning on Department security System-Wide, Or when removing it from the system.

Define Business Rules -> Define General options - > Process - > Change Row Security Basis.

You need to choose option for Department security, to turn Department security on, or the Option of ‘None’, to turn Department security off.

-Posted by

Ganesh A.M

To enable change control in the Application Designer, navigate to the link [shown in the picture] in the application designer and check the check box appropriately.

• Use change control locking

• Use change control history