The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Tuesday, 21 January 2014

PeopleSoft Feature 9.2 Pack Release (PUM Image 4)

Shortly after the bigger release of PeopleSoft 9.2, now Oracle has come up with the first value addition with its Feature Pack release. Feature Pack is an older concept and now everything done through Images. The new features are now released with PeopleSoft 9.2 image 4. PeopleSoft 9.2 customers can now go and upgrade to the latest release of 9.2 by using Make Me Current option with the PeopleSoft 9.2 Image# 4. Now with the help of PeopleSoft Update Manager, customers can even select and apply only the features required by them.

From the FSCM side, PeopleSoft has introduced many new features including but not limited to, Mobile Approvals and Transactions, eMail Approvals, Real Time Bottom Line system for use with inMemory machines, Project Discovey applications with Endecca for use with Oracle Exalogic systems, New additions to WorkCenters and more Search capabilities. Human Capital Management systems has released greater integrations with the Taleo systems.

To get the full list of features released with image 4, existing PeopleSoft customers can download the release value proposition from this link.

Monday, 6 January 2014

Finding components where a particular field is used

As a part of impact analysis while doing any major development work in PeopleSoft, often you may have to search for definition references of fields and other objects.  The Find In will bring out list of all the pages where the field might be used. Now to find out the component list where these pages are used, you may have to end up doing the Find In for each and every page. Sometimes if the referenced pages are more, it will become a tiring work. I want to share a simple SQL which could reduce most of your work if you are looking for component references for a field.

Again, the SQL provided here is a simple one and for example purpose. However you could explore more on the system tables and come up with such simpler and time saving SQL’s. If you already do have some, keep sharing the same in the comments section.

SELECT nvl(b.pnlgrpname,'Not added in any component.') AS Component,
  a.pnlname         AS Page,
  a.pnlfldid        AS FieldId
FROM pspnlfield a,
  pspnlgroup b
WHERE a.recname = 'RECORD_NAME'
AND a.fieldname = 'FIELD_NAME'

AND a.pnlname   = b.pnlname(+);