Zutshi Group LLC - tech:psoft

Configuring App Engine Trace

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Configuring App Engine Trace Append to Parameter List for the process definition: -TRACE 131 -TOOLSTRACEPC 3596 -TOOLSTRACESQL 31

All Processing Suspended: Restart OPRID=%1 RUNID=%2, PI=%3

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

All Processing Suspended: Restart OPRID=%1 RUNID=%2, PI=%3 When restarting an app engin program gives you the dreaded: All Processing Suspended: Restart OPRID=%1 RUNID=%2, PI=%3 Do the following: delete from PS_AERUNCONTROL where OPRID = %OPRID% and PROCESS_INSTANCE = %PI%

Application Server SSL Certificates

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Application Server SSL Certificates You may have to move App server SSL certificates from one PS database to another. Using datamover you can export certificates out of the following tables: In PeopleTools 8.49 and lower: PSCERTDB PSKEYDB In PeopleTools 8.50 and higher:

PeopleSoft Audit Trigger

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

PeopleSoft Audit Trigger The trigger below audits any changes to the PeopleSoft PSOPRDEFN table and writes the pertinent information to PS_NX_AUD_OPRDEFN. CREATE OR REPLACE TRIGGER AUDIT_PSOPRDEFN AFTER INSERT OR UPDATE ON SYSADM.PSOPRDEFN FOR EACH ROW DECLARE NXCONNECTINFO VARCHAR2(64); NXUSER VARCHAR2(30); NXOPRID VARCHAR2(30); NXTIME DATE; BEGIN SELECT 'user='||sys_context('userenv','os_user')||' ip='||sys_context('userenv','ip_address')|| ' host='||sys_context('userenv','host') into NXC…

Blaze Rules Engine to PS Integration Broker Checklist

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Blaze Rules Engine to PS Integration Broker Checklist * On appserver is /blaze mounted? * On PIA is /blaze mounted? * IB Node Properties (bindings, JMSUser/JMSPassword) * Are MQ jar files on WAS? WEB-INF/lib along with providerutil.jar? * Restart PIA

Add a user to the CDM Report Distribution

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Add a user to the CDM Report Distribution Add myself to Report Dist. insert into PS_CDM_AUTH select CONTENTID, PRCSINSTANCE, 'ZUTSHAY', '2' from PS_CDM_AUTH where PRCSINSTANCE = :1

Configure a PeopleSoft REN Server

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Configure a PeopleSoft REN Server A REN (Remote Event Notification) server is used in PeopleSoft primarily for nVision on the web transactions. It also may be used for the optimization engine and that other new crap that PeopleSoft is now pushing. I don't really know a whole lot about.

Copied JRE Appserver will not boot

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Copied JRE Appserver will not boot AppServer wont boot with PUBSUB=Yes. Failing at: exec PSPUBDSP -s PSPUBDSP_dflt:Dispatch -- -C psappsrv.cfg -D FS89PRF -S PSPUBDSP_dflt : CMDTUX_CAT:1864: INFO: Process ID=479386 Assume failed (pipe). tmboot: CMDTUX_CAT:827: ERROR: Fatal error encountered; initiating user error handler

Use Dynamic SQL for Prompts - SqlText

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Use Dynamic SQL for Prompts - SqlText (from: ) Normally you can not use dynamically generated SQL at runtime as your prompt record. You can use %EDITTABLE to specify the prompt table you want to use, but it has to be predefined. There is this little known property SqlText for Field Class, which allows you to do exactly that.

HCM 8.9 to ELM 9.0 Integration Notes

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

HCM 8.9 to ELM 9.0 Integration Notes HCM.Def Version ELM.Def Version Shared Alias HCM Routing Notes ELM Routing NotesPERSON_BASIC_SYNC.INTERNAL PERSON_BASIC_SYNC.VERSION_3PERSON_BASIC_SYNC.INTERNALNAHMTF_TR_IA(INTERNAL to VERSION_3)PERSON_BASIC_FULLSYNC.VERSION_3

Get a File out of the PeopleSoft Report Repository from Java

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Get a File out of the PeopleSoft Report Repository from Java I used the Apache Jakarta HttpClient libraries to accomplish this. HttpClient is available from Make sure that you have the following jar files in you CLASSPATH: * commons-codec-1.3.jar

PSFT Authentication token failed for Node PSFT_HR

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

PSFT Authentication token failed for Node PSFT_HR ISSUE: Local default node pings ok, but remote node (for another PeopleSoft 8.48 env ) produces the error Authentication token failed Example: HRMS and Financials environments. HRMS environment has a local default node called PSFT_HR. Local default node PSFT_HR pings ok. In the HRMS environment, there is a remote node called PSFT_EP for the financials environment. When pinging remote node via the PIA browser, get the following error …

Integration Broker Overview and Tuning

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Integration Broker Overview and Tuning Internal Processes: PSBRKDSP – Message Broker Dispatcher PSBRKHND – Message Broker Handler PSPUBDSP – Publication Contract Dispatcher PSPUBHND – Publication Contract Handler PSSUBDSP – Subscription Contract Dispatcher PSSUBHND – Subscription Contract Handler

Integration Broker Permission List Security

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Integration Broker Permission List Security Working with PeopleSoft integration broker >= Pt 8.48, there is a new concept where a Service Operation has to have a permission list associated with it in order for the Service Operation to function correctly. The SQL below allows you to insert a permission list for every Service Operation available in the system. Typically you would attach the permission list that every user has in the system.

Interactive Services Repository

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Interactive Services Repository PeopleSoft has tons and tons of integrations via Integration Broker (IB). These can be referenced at Interactive Services Repository.

Create IB Service Operation Security.

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Create IB Service Operation Security. PSAUTHWS contains the Permission list security for IB for each service operation we are using Z_CR_PT_BASE_USER permission list for all Service Operations. insert into PSAUTHWS select distinct 'Z_CR_PT_BASE_USER', A.IB_OPERATIONNAME , 4 from PSAUTHWS A where not exists (select 'x' from PSAUTHWS where CLASSID = 'Z_CR_PT_BASE_USER' and IB_OPERATIONNAME = A.IB_OPERATIONNAME)

How to Setup MQ / Peoplesoft Connectivity- WebSphere

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

How to Setup MQ / Peoplesoft Connectivity- WebSphere Culled from the internet somewhere Setup MQM Client Libraries. * Create user called mqm home directory /opt/mqm * You can download the MQM Client Libraries from MQ all you need following jar files to support MQ:

Troubleshooting PT 8.48 PT 8.49 Integration Broker

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Troubleshooting PT 8.48 PT 8.49 Integration Broker Troubleshooting guidance for publication process, subscription process, and other possible problems. Publication Process Problems Possible publication process problems include: * Publication contract is not created.

Index Redirect

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Index Redirect Often we have to redirect somesite.com to somesite.com/ps/signon.html You can replace the index.html file in $PS_HOME/webserv/peoplesoft/applications/peoplesoft/PORTAL with the file below: PeopleSoft Redirect

Installing PeopleSoft on Gentoo Linux

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Installing PeopleSoft on Gentoo Linux General Gentoo Setup: My USE Flags: USE=“-doc -kde -qt -postgres -xemacs mmx sse acl usb pam sftplogging bzip2 toolbar menubar tiff caps server” Portage Commands: emerge --update --deep --newuse world emerge -pv depclean

Installing BEA Tuxedo on Linux

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Installing BEA Tuxedo on Linux These instructions specifically pertain to Gentoo Linux but I guess the probably apply to all flavors of Linux. Tuxedo 8.1 * Make sure that you have installed compress/uncompress. You may get all kinds of errors about

Annoying LLE deprecation Messages in Weblogic PIA and Appserver

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Annoying LLE deprecation Messages in Weblogic PIA and Appserver Appserver * Edit the Tuxedo Domain's /appserv//psappsrv.ubx file. * At the bottom of that file there is a section for environment settings. Add a new environment variable

PeopleSoft

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

PeopleSoft psoft index

Removing a NATIONAL_ID for a PDI Message

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Removing a NATIONAL_ID for a PDI Message PeopleSoft PDI mappings are usually one-to-one. For example let's say you have an LDAP field called “xID”. This is mapped to PS_PERS_NID.NATIONAL_ID. Now the PS_PERS_NID table is keyed by two fields NATIONAL_ID_TYPE and NATIONAL_ID. If a person has multiple rows in the PS_PERS_NID table, say a social security number and an EDIPI number (if in the military) and any one of these values is changed the LDAP field

PeopleSoft RC Scripts

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

PeopleSoft RC Scripts Actual Start/Stop Script #!/usr/bin/ksh logger() { echo "$1" >> $RCLOG } init_log() { logger "***************************************************************" logger "** STARTING NEW INSTANCE of RC SCRIPT **" logger "***************************************************************" } set_environment() { export PATH=/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/ccs/bin:/usr/ucb:. unset IS_PS_PLT unset PSJLIBPATH unset PSLIBPATH …

Using PeopleSoft SOAP Classes

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Using PeopleSoft SOAP Classes Overview There are a number of ways to implement SOAP transactions in PeopleSoft. Here we are demonstrating the use of simple PeopleSoft SOAP classes. The goal of this exercise is for some third party system to send an OPRID and a SSN to our system, we will respond with a true or false message depending on whether the SSN is actually valid.

PSA_ACCTGGL ORA-600 Error

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

PSA_ACCTGGL ORA-600 Error The Application Engine PSA_ACCTGGL program sometimes errors out with an ORA-600 error. Manual Fix * Run the SQL below and restart the job. * The job may fail more than once. Repeat the analyze steps below and continue restarting the Application engine program until it goes to success.

Content Reference Heirarchical Query

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Content Reference Heirarchical Query PIA navigation to any given component: select distinct rtrim(reverse (sys_connect_by_path(reverse (portal_label), ‘ > ‘)), ‘ > ‘) path from psprsmdefn where portal_name = ‘EMPLOYEE’ and portal_prntobjname = ‘PORTAL_ROOT_OBJECT’ start with portal_uri_seg2 = :1 connect by prior portal_prntobjname = portal_objname

Creating Nodes

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Creating Nodes Here is a gotcha: When creating nodes, you have to enter “Portal” (psp) and “Content:” (psc) URL's. Make sure that you have a trailing slash!

Build SQL from PSQueries

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Build SQL from PSQueries See “QRY_SQL.Activate() Page PeopleCode” Declare Function Declare Function WriteQueryToApi PeopleCode QRYFUNCTIONs.QRYQUERYFUNCS FieldFormula; Local ApiObject &aQuery; Local number &x; &aQuery = %Session.GetQuery(); &x = &aQuery.create(, False, 1, "", ""); WriteQueryToApi(&aQuery); &string = String(&aQuery.SQL); &aQuery.Close();

PT_BRANDING Adding Custom Message to your PeopleSoft Application

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

PT_BRANDING Adding Custom Message to your PeopleSoft Application Open Application Package PT_BRANDING, Application Class BrandingBase, Method GetIScriptHPDefaultHdrHTML. Placing the Custom Heading on the Home Page Replace: Greeting = &Portal.Homepage.Greeting;

Drop Materialized View Logs

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Drop Materialized View Logs Drop materialized view logs for Nextel dev/test databases. -- drop materialized view logs from dev/test database SELECT * FROM DBA_MVIEW_LOGS / DROP MATERIALIZED VIEW LOG ON SYSADM.PS_PAYGROUP_TBL / DROP MATERIALIZED VIEW LOG ON SYSADM.PS_PAY_CALENDAR / DROP MATERIALIZED VIEW LOG ON SYSADM.PS_PAY_EARNINGS / DROP MATERIALIZED VIEW LOG ON SYSADM.PS_PAY_OTH_EARNS / SELECT * FROM DBA_MVIEW_LOGS / COMMIT /

SYSAUDIT SEC-28 "Invalid entries in the PSAUTHITEM table"

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

SYSAUDIT SEC-28 "Invalid entries in the PSAUTHITEM table" PeopleBooks has a gawd awful bit of SQL to resolve the SEC-28 error for Invalid entries in the PSAUTHITEM table. It is impossible to actually run the SQL as there is a mismatch of “(” and

SYSAUDIT SEC-28

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

SYSAUDIT SEC-28 delete FROM PSAUTHITEM WHERE (PSAUTHITEM.MENUNAME NOT LIKE 'WEBLIB_%' AND PSAUTHITEM.MENUNAME NOT IN ('CLIENTPROCESS', 'DATA_MOVER', 'IMPORT_MANAGER', 'OBJECT_SECURITY', 'QUERY', 'PERFMONPPMI' ) AND PSAUTHITEM.MENUNAME NOT LIKE ('APPLICATION_DESIGNER%') AND PSAUTHITEM.MENUNAME <>'REN' AND NOT EXISTS (SELECT 'X' FROM PSMENUITEM MI WHERE PSAUTHITEM.MENUNAME = MI.MENUNAME AND PSAUTHITEM.BARNAME = MI.BARNAME AND PSAUTHITEM.BARITEMNAME = MI.ITEMNAME AND ( MI.ITEMTY…

SYSAUDIT SEC-34

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

SYSAUDIT SEC-34 DELETE FROM PSAUTHWS A WHERE NOT EXISTS (SELECT 'X' FROM PSCLASSDEFN B WHERE B.CLASSID = A.CLASSID)

SYSAUDIT SEC-36

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

SYSAUDIT SEC-36 DELETE FROM PS_SCRTY_SRCHGRP A WHERE NOT EXISTS (SELECT 'X' FROM PSPTSF_SRCCAT B WHERE B.PTSF_ISGBLSRCH = 'Y' AND B.PTSF_SRCCAT_NAME = A.PTSF_SRCHGRP_NAME)

Restarting PUBSUB from the command line

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Restarting PUBSUB from the command line To restart PUB SUB without rebooting the Application Server domain Use tmadmin (tuxedo command line - option 5 in psadmin) Stopping PUB SUB shutdown -g PUBSUB Starting PUB SUB boot -g PUBSUB

How to start/shutdown application server processes dynamically.

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

How to start/shutdown application server processes dynamically. Issue: How to start/shutdown application server processes dynamically. This could be helpful when trying to handle a temporary increase/decrease in load on the system. Solution: Server processes are started using the

Command Line SQR in Unix

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

Command Line SQR in Unix Running sqr programs through the command line in UNIX is not difficult. Steps for running SQR's in UNIX: * Set your Environment * Create the run_sqr shell script * Run the SQR Setting your environment After connecting to the unix environment, set up your PeopleSoft Environment. Notice that the command below contains a dot

SQL Time consumed by UNKNOWN SQL Statements in COBOL Trace

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

SQL Time consumed by UNKNOWN SQL Statements in COBOL Trace ISSUE: When running trace on Global Payroll process(GPPDPRUN) with the “COBOL Statement Timings” Debug Flag set, a significant amount of SQL time is consumed by “UNKNOWN” statements. What are the

WebLogic and PeopleSoft

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

WebLogic and PeopleSoft With PT8.47, there were no problems with using Weblogic in a PeopleSoft setting. Unfortunately with PT8.49, I ran into some issues! Weblogic seemed to work just fine serving up the PS Web Client and PeopleBooks. Unfortunately Weblogic would crash hard every time I tried to use the PeopleBooks search functionality. God damn Stack Overflow errors!

(Windows) Take Ownership and grant permissions to a folder for a user

anonymous@undisclosed.example.com (Anonymous) — Fri, 21 Jun 2024 16:04:03 +0000

(Windows) Take Ownership and grant permissions to a folder for a user On windows - this is sometimes useful takeown /f C:\PSOFT /r /d y icacls C:\PSOFT /grant psoft:F /t