Flashback query has been a boon from Oracle since its introduction in 9i. In a PeopleSoft environment there are many areas a DBA can utilize this feature. The commands are straightforward and will make your life easier if you remember them.
þ Consider a scenario where you are doing a data fix in production database. You [...]
From the category archives:
PeopleSoft FieldBook
I was composing this post when there was a comment from “Spamboy” for my previous post where he provided the SQL to identify the portal navigation. Thanks for your comments!!
In this post I will share the SQL I use when I want to determine the portal navigation. Here it is …
SELECT LPAD(‘–’,2*(LEVEL-1)) || PORTAL_LABEL “NAVIGATION”
FROM [...]
While working on my previous projects, I had some difficulties identifying the menu navigation for a process or report in PeopleSoft. So I developed this SQL that will help determine the navigation.
select distinct b.menugroup||’ > ‘ ||b.menulabel||
‘ > ‘||barlabel||’ > ‘||a.itemlabel||’ > ‘
||d.pnlgrpname||’ – ‘||prcstype||’ – ‘||prcsname“Navigation”
from psmenuitem a, psmenudefn b, ps_prcsdefnpnl c, pspnlgroup d
where [...]
As an Oracle DBA administering a PeopleSoft database, we would like to ensure that all PeopleSoft queries (PRIVATE or PUBLIC) are optimized. There is always a possibility of introducing a HINT to tune the SQL generated by PeopleSoft in Query Manager. Here are the steps to add the HINT.
1. Create a new expression
2. Click“Add Field” [...]
Continuing from my previous post, here are the steps to load the upg.sqc data relevant for our manipulation into the Oracle database.
1. Create record HX_COMP_TBL in App Designer as shown below.
2. Build/create the table
3. Add it to Query Security if you need to access it using PeopleSoft Query Manager.
4. Create Download upg_sqc.txt file
5. Create SQL*Loader [...]
As a DBA, I do not always trust Application Designer when it comes to following tasks.
Merging projects – typical example is migration of 2 or more bundles using a merged project.
Quickly changing the update flags based on KEEP/DROP decisions on a huge project
Any other manipulations
There are many approaches to monitor the PeopleSoft process scheduler. One of the options that come to mind is to have a script running on the OS hosting the process scheduler to monitor the OS process. But having process schedulers running on multiple OS (PSUNX and PSNT) will need development of scripts running on both [...]
