SQL Update on PSURLDEFN, Application Server and GetURL(URL.XXXX) - All connected

Today, we had an interesting issue at one of our customer site.

When a PeopleSoft environment is refreshed (production / post upgrade refresh), Environment Management team (DBAs) will mask sensitive data using scripts or tools. PSURLDEFN is one of the key table to be masked.

We recently had a environment refresh (Post Upgrade). One issue was reported where the connectivity to the third party system was lost after the refresh (upgrade). On analysis, the PSURLDEFN was blanked out during the refresh process and not reverted with actual values. So, the DBAs repopulated the data using SQL scripts. Post URL data population also, the same connectivity issue was encountered.

On further Analysis, GetURL(URL.XXXX) was used in PeopleCode to get the third party system URL. GetURL() function fetches the information from the App Server Cached details. This was designed for a quicker response on the Application Server. The issue was finally resolved by DBAs clearing the cache and Application Servers bounced.

So, if there are any SQL update on the PSURLDEFN table, its good practice to clear the Application Server Cache.

PeopleSoft demonstrations at UKOUG APPS14

It is our pleasure to share with you some PeopleSoft insights that we presented during the UK Oracle User Group APPS14 conference held from 8th - 10th December. We successfully demonstrated practical solutions and tools that transform enterprise performance. Below is a brief synopsis about our involvement.

If you require more details, please feel free to contact our PeopleSoft Consulting Practice on peoplesoft.team@kovaion.com. We will be in touch shortly to determine if we can assist you in any way with your Oracle, PeopleSoft or Fusion requirements.

UKOUG APPS14

APPS14 is the UK Oracle User Group’s Applications Conference & Exhibition 2014 and is the largest event that UKOUG delivers for this community. The conference took place from 8th - 10th December. Over 800 attendees came together at the ACC Liverpool to expand their Oracle knowledge through an extensive agenda and learn about the latest products on the market from the leading Oracle Applications vendors.

PeopleSoft @ UKOUG APPS14

The PeopleSoft agenda covered four streams (Human Resources, Financials, Global Payroll and Technology) presented over two days. Speakers from Oracle, end users and suppliers focused on product development, real world experiences and innovative ideas.

The agenda for PeopleSoft included:

·         The PeopleSoft Community Keynote was delivered by Gwennan Goriot on an update about the Oracle PeopleSoft product line.

·         Graham Smith demonstrated the PeopleSoft Portal to delegates.

·         Mark Thomas presented a session on the best practices in PeopleSoft 9.2 upgrade.

·         An open Q&A discussion lead by Gwennan Goriot allowed delegates to put their questions to Oracle

·         Roundtables brought together like-minded delegates to discuss challenges particularly focusing on Upgrades.

Kovaion presented 2 sessions on PeopleSoft and also took part in the Round table discussion.

·         PeopleTools 8.5x – The New Experience

o   Oracle-PeopleSoft is determined and bringing new features to PeopleTools. More than 1000 new enhancements have been added by Oracle on PeopleTools 8.5x (including new applications). Kovaion demonstrated the practical usage of PeopleTools Portal Technologies (Related Content), Integration Technologies (REST based service with JSON) and PT 8.54 Fluid MSS page/dashboard.

·         Automate PeopleSoft Testing

o   Application testing is one of the many challenges organizations face as part of a new implementation, upgrade or system changes. Complex as it is, testing involves ensuring that the application delivers expected results in the areas of functional specifications, user interface interactions, security and performance. Kovaion, using practical experience gained in the field, showcased the ROI on testing automation and  test methodologies. We also demonstrated the capabilities of PeopleSoft Test Framework for Regression Testing together with JMeter for Performance testing. Watch this space for the launch of our PeopleSoft Test Factory.

·         9.2 Upgrade Planning & Execution Open Discussion

o   PeopleSoft 9.2 has generated a huge amount of interest with users – with over 1,000 new features including the new fluid mobile approach. This round table focused on bringing together a number of users that have either completed or are currently undertaking an upgrade. They  discussed  their challenges from business case inception to successful deployment. Mark Thomas (Hays) hosted the discussion with Nanda Kumar(Kovaion), Graham Smith (Oxfam), Adrian Nuttall (Oceaneering) and Chris Pannell (Allen & Overy) as panel members.

  

Kovaion has been helping companies transform their IT landscape by providing services around ERP, Analytics, Cloud, Mobility and Testing.  As a trusted partner, we offer services with greater flexibility and are different by virtue of our determination, conviction and creativity in handling customer requirements. We provide niche services on the terms of consulting, implementation, upgrade, training and staffing. Let us know if we can help you or get in touch via info@kovaion.com. 

Wish you merry Christmas and a very Happy New Year ! ! ! 

Regards,

Nanda Kumar

Founder & Director

Kovaion Consulting

m: +44 (0) 75741 64244
e: nanda.kumar@kovaion.com

w: www.kovaion.com

“Had a good show at UKOUG APPS14 Conference. Follow #ukoug_apps14”