E-PORTAL: How to Find the Link Between a PIA Component and PORTAL_OBJNAME (Doc ID 618875.1)

Last updated on JULY 25, 2017

Applies to:

PeopleSoft Enterprise PRTL Interaction Hub - Version 8.4 and later
Information in this document applies to any platform.
***Checked for Relevance 15-Oct-2013***

Symptoms


The Customer needs to find the PIA page(s) that access/update particular fields or records.  Using App Designer they can determine the Page, Component and Menu that are used, but can't connect the Menu with the portal navigation, to discover how to get the menu in PIA.

Using SQL with the PTools tables, they can capture the component and menu using tables such as PSPNLFIELD, PSPNLGROUP and PSMENUITEM.  If they know the PORTAL_OBJNAME, they can use the PSPRSMDEFN table to determine the navigation, based on the parent object name kept in that table.  How do they connect the MENUNAME with a PORTAL_OBJNAME?

For example: In the PIA, the customer can look in PeopleTools > Portal > Structure & Content.  From there they can select a Content Reference, such as Budget Period Analysis.  It has a portal objectname of PF_BP_REV_INQ_COMP2_GBL.  On that same page they can associate that portal object with a Menu, a Market and a Component.  In this case with EPM 8.8, they are associated with the menu BUDGETS_INQUIRY and component BP_REV_INQ_COMP2.  What is the name of the database table that contains the linking that they see on this PIA page, and how do they join them?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms