Uploading Customizations into PeopleSoft PUM 








PeopleSoft Change assistant 8.55+ gives us the ability to upload customizations in to the PUM appliance. This allows us to generate reports to let us know which customizations will be affected by any bug fixes. One issue I have come across is that Oracle expects you to load all of your customizations into a single project (for example UPGCUST), export to file and then upload.

What if you want to collect all of your customizations each within their own project and then upload them individually? Well, here's my trick...

To upload the customizations first we need to export them from an existing copy of production.


    

  1. Get a list of all of the project names for your customizations. Typically your customizations project names should all share a common prefix, This SQL script will generate a list of all customizations and update the project flags if they are set incorrectly.

--dump list of project names that use your customizations prefix
select projectname from psprojectdefn
where projectname like 'MYCUST%'; 
--update project flags based on the same list
UPDATE PSPROJECTITEM
SET COPYDONE = 0, TAKEACTION = 1
WHERE PROJECTNAME IN (select projectname from psprojectdefn
where projectname like 'MYCUST%';

    2. 

  2. Take the export list and combine it with the script below to export all projects to file with Application Designer.

REM script stolen and modified from link below
REM http://peoplesofttipster.com/2008/11/17/quickly-export-multiple-projects/
 
set pside=C:\apps\psoft\PT854\bin\client\winx86\pside.exe
set export_path=C:\temp\exports\
set dbtype=ORACLE
set user=oprid
set pwd=password
set srcdb=database
FOR /F %%a IN (project_list.txt) DO %pside% -HIDE -PJTF %%a -FP %export_path% -CT %dbtype% -CO %user% -CP %pwd% -CD %srcdb% -QUIET -AF 0 -DDL 1 -PPL 0 -CFD 0 -CFF 0 -LF %export_path%%%a.log
pause

    3. 

  3. Finally you can import the customizations using Change Assistant.
a)Open Change assistant 
b)Select Tools-> Upload Customer Data to Image 
c)Click Add Project for each project you have (yes you have to do it one at a time). Alternatively there is a vbscript at the bottom of this page that will automate the clicks for you. 
d)Set the Project Content column to 'Customization Impact - All' unfortunately I can’t seem to change this setting without using a mouse. If you can figure this out we can also automate the click with vbs
    4. 




VBScript for keystrokes in change assistant 



' VBScript to send keyboard strokes to change assistant for loading custom project_list
' --------------------------------------------------------' 
'VARIABLES TO SET
strProjectlistFilename = "C:\temp\ProjectsForPUM\project_list.txt"
strProjectRootFolder = "C:\temp\ProjectsForPUM\"

Dim tmp
tmp = InputBox("Warning, this script is not perfect but typically works. You can kill it with the command in the text box below. Please copy it to your clipboard and save it to .bat file. BE SURE YOU HAVE SET THE VARIABLE PATHS IN THE TOP OF THE SCRIPT. Then, Click OK to continue",,"taskkill /im wscript.exe /f")
set objShell = CreateObject("WScript.Shell")
set WshShell = WScript.CreateObject("WScript.Shell")
WScript.Echo("Start PeopleSoft Change Assistant and open the 'Tools->Upload Customer Data to Image Window'")
Do Until Success = True
Success = objShell.AppActivate("Upload Customer Data to Image")
Loop
WScript.Echo("Window Found, Click OK to continue")
Wscript.Sleep 500
objShell.SendKeys "{TAB}", True
Wscript.Sleep 500
objShell.SendKeys "{TAB}", True
Wscript.Sleep 500
objShell.SendKeys "{TAB}", True
Wscript.Sleep 500
objShell.SendKeys "{TAB}", True
Wscript.Sleep 500


'Adding projects

Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.OpenTextFile(strProjectlistFilename)

Do Until f.AtEndOfStream
objShell.SendKeys " ", True
Wscript.Sleep 500
'Send the Alt commands twice (sometimes they fail to send)
objShell.SendKeys "%{n}", True
Wscript.Sleep 100
objShell.SendKeys "%{n}", True
Wscript.Sleep 500
objShell.SendKeys "^{a}", True
Wscript.Sleep 100
objShell.SendKeys "^{a}", True
Wscript.Sleep 500
objShell.SendKeys "{BACKSPACE}", True
Wscript.Sleep 500
wshshell.sendkeys strProjectRootFolder
wshshell.sendkeys f.ReadLine
Wscript.Sleep 500
objShell.SendKeys "%{o}"
Wscript.Sleep 1000
Loop

f.Close



WScript.Echo("The loading of the project list is done, however you still need to set the project content column to 'Customization Impact - All' ")

Comments

Post a Comment

Popular posts from this blog

Create a custom backup report with BI Publisher for Oracle Enterprise Manager/Cloud Control 13c

Image
Recently I was tasked to build out an OEM 13c instance to manage a few Oracle Database servers and their associated instances. As a part of the setup, I needed to generate a daily email report to confirm the backup status of all databases in the OEM inventory. Unfortunately, it seems Oracle has overlooked this in the default reports, so I had to create a custom report. Here's how this was accomplished. The EM Repository database keeps track of the last database backup timestamp for each database. This is shown on the home page for any database. We can use this information to create a daily report and confirm that each database has been backed up in the last 24 hours. Login the BI publisher site https://oemserver.yourdomain:9851/xmlpserver with your account or sysman. Near the top right corner click “catalog”. In the tree on the left create a new folder under “Shared Folders” called custom reports. Within the custom reports folder create a new folder called “custom d
Read more

Active Directory Authentication with an Oracle Database

Image
Wouldn’t it be nice to not have to manage user passwords in your Oracle Databases? Setting up Active Directory aka Kerberos Authentication is a way to avoid having to manage passwords and allows users to authenticate against your Active Directory. Below is a list of useful links and My Oracle references that were used when setting up this example: EDIT - This post gets a lot of hits so I will include some updated information. If you're on 12c you need to add kerberos5pre to your list of services. e.g. SQLNET.AUTHENTICATION_SERVICES= (beq,kerberos5pre,kerberos5) If you are an Oracle Support Customer check out How To Configure Kerberos Authentication In A 12c Database ( Doc ID 1996329.1 ). If not, here is a good 3rd party write up  https://wiki.loopback.org/display/KB/Oracle+Database+12c+Kerberos+Configuration   Master Note For Kerberos Authentication (Doc ID 1375853.1) Configuring ASO Kerberos Authentication with a Microsoft Windows 2008 R2 Active Directory KDC (Doc ID 13
Read more

Oracle Enterprise Manager notify when Recovery Area low

Image
I seem to be on the Oracle Enterprise manager kick lately, so why not one more post on it. Recently I hit the 85% mark on the Fast Recovery Area due to archive log bloat and did not see any alerts triggered in OEM. Well as I discovered, part of the reason for this is that according to MOS, "If using Fast Recovery Area (FRA) for the archive destination and the destination is set to USE_DB_RECOVERY_FILE_DEST, then the Archive Area % Used metric will not trigger anymore." Well that is annoying. However, I did find that the alert does trigger, but it is buried and doesn't show up on any main pages. To see it, go to the target database home page. Then navigate to Oracle Database->Monitoring->All Metrics . In the left pane you can scroll down to “ Recovery Area->Recovery Area Free Space ”.  There you will see your alert if active. When viewing the All Metrics page, click on the alerts icon to see active alerts. If you want to see it triggered just temporaril
Read more