Welcome To Peoplesoft Admin

This is our PeopleSoft Admin blog where a team of PeopleSoft Admin professionals document the day to day PSAdmin tasks we learn and experience for the benefit of us and for other PeopleSoft administrators. We also have a forum to discuss the topics or issues related to PeopleSoft administration and other related technologies.

Blog

PeopleSoft admin Blog

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
  • Team Blogs
    Team Blogs Find your favorite team blogs here.
  • Login
    Login Login form
Recent blog posts

Posted by on in PeopleTools

ORA-00022: invalid session ID; access denied - DbFlags Parameter.

Issue: Users getting "ORA-00022: invalid session ID; access denied" error on various pages across PeopleSoft HRMS application.

Cause: SQL error was triggered whenever GetNextNumberWithGapsCommit PeopleCode function is called within the PeopleSoft pages. The purpose of this function is to increment a counter and return that next value. Specifically designed to be used with secondary connections, this function can improve concurrency by holding the lock on the counter as briefly as possible.

Resolution:  We were using the default DbFalgs parameter 0, which leaves the secondary DB connection open for reuse by subsequent GNNWGC calls, which is why the ORA-00022 sporadically occurs. Changing DbFlags parameter value in Application server psappsrv.cfg file from 0 to 8, which establish a secondary connection, increment and retrieve the value, and subsequently close the secondary DB connection resolved the issue. This is a bug in PeopleTools discovered in earlier versions and still exists in PT 8.51. 

When the GetNextNumberWithGapsCommit() function is used with the DbFlags=4 setting, the primary connection is used to increment and retrieve the next value, often increasing contention on the counter considerably. This use of only one connection changes the GetNextNumberWithGapsCommit() to be the function equivalent to GetNextNumberWithGaps() resulting inconsiderable contention in an active database.

When the GetNextNumberWithGapsCommit() function is used with the DbFlags=8 setting, a secondary connection is established, used to increment and retrieve the value, and subsequently closed. The use of the secondary connection can considerably decrease contention on the counter since locks are held as briefly as possible. 

When this function is used with the DbFlags=0 setting, meaning neither the 4 or 8 setting is used, a secondary connection is established on “first use,” and the connection is left open for subsequent use until the process terminates or is recycled.

Continue reading
Hits: 2079 0 Comments
0

Posted by on in PeopleTools

PeopleSoft Update Manager(PUM) - Create PeopleSoft Environment using PeopleSoft Image:

Oracle has changed the way all maintenance and functionality is being delivered starting in PeopleSoft 9.2  using the new PeopleSoft Update Manager (PUM). The PeopleSoft Image(PI) for your application is released on a published schedule and is cumulative. Only the most current PI will be available at any given time and it will provide all the cumulative updates you need.

The PeopleSoft Update Manager PIA Application was delivered starting with PeopleTools 8.53 as part of the Lifecycle Management suite of tools. The PeopleSoft Update Manager PIA Application and the PI work together: the PI contains the updates, and the PeopleSoft Update Manager PIA Application is the search tool and custom change package definition generator. PeopleSoft Change Assistant orchestrates the entire process flow. Change Assistant is the tool used to analyze and compare changes, apply the changed objects to your environment, add your customizations, and generate custom change packages.

Below article guides you to create a virtual PeopleSoft environment using PeopleSoft Image which is much needed from PeopleSoft 9.2 applications.

1. Download PeopleSoft Image for the Application we need using below Doc ID from Oracle Support. 

PeopleSoft Update Manager (PUM) Home Page (Doc ID 1641843.2)

I have downloaded the latest FSCM Image 9.2.011 from the FSCM Update Image Home page. 

b2ap3_thumbnail_PUM1.PNG

2. Install virtual box software for windows 64 bit downloaded from www.virtualbox.org on your windows host computer. 

b2ap3_thumbnail_PUM2.PNG

 

 3. Hardware requirements : Windows host where we install virtual box software must be a 64-bit stand-alone windows machine and it cannot be another virtual machine. The PeopleSoft VirtualBox appliance requires a minimum of 6 GB available RAM to run a PI and it requires 150 GB of free disk space to initialize the virtual appliance.

4. Extract and merge the downloaded PeopleSoft Image to create Oracle Virtual Appliance(OVA) file.

It can be done in two ways. Either run the batch file which is in the first zip file from the downloaded files or manually extract the zip files one by one and merge the files and create Oracle Virtual Appliance using command line like below. 

copy /b FSCM-920-UPD-011_OVA_1of11+FSCM-920-UPD-011_OVA_2of11+FSCM-920-UPD-011_OVA_3of11+FSCM-920-UPD-011_OVA_4of11+FSCM-920-UPD-011_OVA_5of11+FSCM-920-UPD-011_OVA_6of11+FSCM-920-UPD-011_OVA_7of11+FSCM-920-UPD-011_OVA_8of11+FSCM-920-UPD-011_OVA_9of11+FSCM-920-UPD-011_OVA_10of11+FSCM-920-UPD-011_OVA_11of11 FSCM-920-UPD-011.OVA  

5. Importing OVA into Virtual Box.

 Launch virtual box software installed in step no. 2 and navigate to File -> Import Appliance and choose the OVA file created in the previous step.

b2ap3_thumbnail_pum1.PNG

Click Next and you can change the Virtual disk image paths, if you would like in order to place the virtual image files in a different path other than the default directory.

b2ap3_thumbnail_pum2.PNG

Click on Import and wait for the virtual image files to be created and imported into the virtual box. 

b2ap3_thumbnail_pum3.PNG

 Here you can see the virtual image is uploaded and the instance is in powered off mode.

 b2ap3_thumbnail_pum4.PNG

 

Check the Network settings and make sure it is set to the right option based on your requirement before you start the virtual instance. I set it as Host-only Adapter because i dont need the virtual environment to be accessed outside of this host computer. For Enterprise installations, typically you will choose bridged adapter to enable the environment to be the accessed across the enterprise network. 

b2ap3_thumbnail_pum5.PNG

6. Starting Virtual Envrironment. 

 Select the virtual Image uploaded and click on Start to start the virtual environment.

b2ap3_thumbnail_pum6.PNG

 Enter Y to proceed and enter the unix password which is required later to login to linux server.

b2ap3_thumbnail_pum7.PNG

There are two types of network configuration namely Dynamic and Static. Choosing Dnyamic option will genearate its own IP address and it is preferred, only when you create a temporary environment like this. If we need an environment to be used for long term, choose N in the below screen and it will prompt you to enter Static IP address, Subnet mask and gateway details. Your Organization's network team would be able to assign an IP address in the network and you can choose that IP address to proceed with the installation. They can also assign a dns name for the IP address they have created and you should be able to access the virtual environment using that dns name across the enterprise.

b2ap3_thumbnail_pum9.PNG

Follow the screen and provide all the neccessary details like database name, connect password etc. 

b2ap3_thumbnail_pum12.PNG

It automatically installs the database and all the necessary peoplesoft components. It will also install SES if you choose Y, when it prompts. I have skipped SES for this installation by choosing N.

b2ap3_thumbnail_pum13.PNG

b2ap3_thumbnail_pum14.PNG

Successfully logged into the PeopleSoft environment created using the PeopleSoft Image. This PeopleSoft environment can be used as demo environment or as  a source for the upgrade and to apply patches using Change Assistant.

b2ap3_thumbnail_pum15.PNG

Continue reading
Hits: 5999 0 Comments

Posted by on in PeopleSoft CRM

CRM 9.2 - First operand of . is NULL, so cannot access member GetRow. (180,236) when opening case in 360 degree view:-

Issue :- When we Add or search or open a case in CRM 9.2 application after the upgrade, We are having issue and have below error in the appserver log.

(IE 8.0; WINXP) ICPanel](0) First operand of . is NULL, so cannot access member Ge
tRow. (180,236) RB_TD_360.Tree.OnExecute  Name:GetViewRowsCount  PCPC:38691  Statement:627^M
Called from:RB_TD_360.Tree.OnExecute  Name:MergeNodesViewRows  Statement:1419^M
Called from:RB_TD_360.Tree.OnExecute  Name:GetNodesInformation  Statement:1493^M
Called from:RB_TD_360.Tree.OnExecute  Name:populateRootNodes  Statement:1506^M
Called from:RB_TD_360.Tree.OnExecute  Name:DisplayTree  Statement:1528^M
Called from:RB_TD_AGENT_VIEW.Activate  Statement:81


We have enabled SQL & Peoplecode trace and replicated the issue and found below error inaddition to the above error in the trace.

 Caught Exception: First operand of . is NULL, so cannot access member Value. (180,236) RBQ_BOSRCH_QCREATE.Runtime.Adapter.FieldHandler.OnExecute  Name:SetFieldBuffer  PCPC:29024  Statement:662^M
Called from:RBQ_BOSRCH_QCREATE.Runtime.Adapter.Manager.OnExecute  Name:SetBOAssignedFieldBuffer  Statement:242^M
Called from:RBQ_BOSRCH_QCREATE.Runtime.Extension.Extension.OnExecute  Name:SetBuffer  Statement:372^M
Called from:RBQ_EXTENSIONS.Support.OnExecute  Name:InitializeBuffer  Statement:12^M
Called from:RBQ_BOSRCH_QCREA

Cause :- This issue is happening due to application cache gets corrupted.

Solution :-

Login to Application Designer and then Open Application Engine Program RD_CACHE_DEL and run the Application Engine to delete the Application Cache Objects . This will delete the Application Cache.

This can be validated by checking the count using below SQL before and after running the application engine program.

SELECT COUNT(*)  FROM PSCONTDEFN  WHERE CONTTYPE = 8;

The CONTTYPE = 8 is RowsetCache data.

Bounce and clear cache of the application servers as well.

How RD_CACHE_DEL different from clearing Application Server cache:

The RD_CACHE_DEL loops through all Application Cache objects and delete them.

Application cache is something that CRM maintains for faster performance on BO searches, config searches , app security etc.. This is maintained in a combination of CRM and PeopleTools tables and the RD_CACHE_DEL AE deletes from those. For e.g. some data is deleted from PSCONTENT table, which is a PeopleTools table but has application data in it, it is managed by application and PeopleTools.  So the RD_CACHE_DEL program deletes the application data that CRM manages/ adds.

Application Server cache is the PeopleTools level cache, when deleting application server cache, tools level cache is deleted

 

 

Continue reading
Hits: 3926 0 Comments

Posted by on in PeopleTools

 

Enabling Multi-Language Entry for Editing data in multiple languages in PeopleSoft

Multi-language entry makes it more intuitive for a multilingual user to maintain data in several languages before saving a page.

Using the multi-language entry option provides significant benefits over simply changing the session language and overwriting existing base language descriptions with their translations. It allows you to:

Enter or edit data in multiple languages during the same session without changing the sign-in language.

View all translations of a row of data in a single session, which may be important for multilingual implementations that need to describe data in a different language.

Easily recognize which fields on a page are language-sensitive and which are language-neutral.

Change Multi Language Entry option to "Yes" by Navigating to Main Menu -> My Personalizations -> Personalize General Options

b2ap3_thumbnail_Capturemulti.PNG

Now you should be able to change the data language from the drop down below. 

b2ap3_thumbnail_Capture.PNG

 

Continue reading
Hits: 2430 0 Comments

Posted by on in PeopleTools

PT 8.51+ - Disable Autocomplete or Type Ahead in PeopleSoft application.

1. In PIA, navigate to PeopleTools -> Web Profile -> Web Profile Configurations.

2. Search for webprofile and open the right webprofile used by your application.

3. Click on "Custom Properties" tab. 

      Add custom properties (if it doesn't exist): 
     

       Propery Name: EnableAutocomplete

      Vaildation Type: Boolean 

      Property Value: false

4. Save the Webprofile and bounce the webservers. 

Continue reading
Hits: 1723 0 Comments
0

Disclaimer

All content provided on this "peoplesoftadminblog.com" website is for informational purposes only and are only the author's views and not that of Oracle or any other product or tools provider. Opinions or comments expressed by visitors are not endorsed or recommended by the author. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site.

The owner of [peoplesoftadminblog.com] will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses or damages from the display or use of this information. This PeopleSoft blog is a repository of tips and suggestions which are neither Oracle suggested nor the author's employer suggested. Please ensure you follow your organization standards and procedures while implementing the suggestions provided in this blog or any references from/to this blog.