PeopleSoft FS notes

From 2017 and may not be current:

People1 - connect id (people) password

People123 - weblogic server admin password

pstest-psfststws601:fstest:/usr/opt/app/psoft/psofthome>ps -ef | grep fsdbug

psdev 2203 1 1 Mar07 ? 1-02:17:32 java -server -javaagent:/usr/opt/app/psoft/AppDynamics/javaagent.jar -Xms2048m -Xmx2048m -Dtoplink.xml.platform=oracle.toplink.platform.xml.jaxp.JAXPPlatform -Dcom.sun.xml.namespace.QName.useCompatibleSerialVersionUID=1.0 -Dweblogic.Chunksize=65536 -Djava.util.logging.config.file=/usr/opt/app/psoft/fsdbug/webserv/fsdbug/piaconfig/properties/logging.properties -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Dweblogic.Name=PIA -Dps_vault=/usr/opt/app/psoft/fsdbug/webserv/fsdbug/piaconfig/properties/psvault -Djavax.net.ssl.trustStore=/usr/opt/app/psoft/fsdbug/webserv/fsdbug/security/tmw.jks -Dweblogic.ProductionModeEnabled=true -Djava.security.policy=/usr/opt/app/bea/weblogic122/wlserver/server/lib/weblogic.policy -Dssl.debug=false -Dps_home=/usr/opt/app/bea/tools85609 weblogic.Server

pstest 6287 82400 0 08:39 pts/0 00:00:00 grep --color=auto fsdbug

psdev-psfststws602:fsdvlp:/usr/opt/app/psoft/psofthome>ps -ef | grep fsdbug

psdev 40323 1 1 Mar07 ? 1-03:33:29 java -server -javaagent:/usr/opt/app/psoft/AppDynamics/javaagent.jar -Xms2048m -Xmx2048m -Dtoplink.xml.platform=oracle.toplink.platform.xml.jaxp.JAXPPlatform -Dcom.sun.xml.namespace.QName.useCompatibleSerialVersionUID=1.0 -Dweblogic.Chunksize=65536 -Djava.util.logging.config.file=/usr/opt/app/psoft/fsdbug/webserv/fsdbug/piaconfig/properties/logging.properties -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Dweblogic.Name=PIA -Dps_vault=/usr/opt/app/psoft/fsdbug/webserv/fsdbug/piaconfig/properties/psvault -Djavax.net.ssl.trustStore=/usr/opt/app/psoft/fsdbug/webserv/fsdbug/security/tmw.jks -Dweblogic.ProductionModeEnabled=true -Djava.security.policy=/usr/opt/app/bea/weblogic122/wlserver/server/lib/weblogic.policy -Dssl.debug=false -Dps_home=/usr/opt/app/bea/tools85609 weblogic.Server

pstest-psfststapp601:fstest:/usr/opt/app/psoft/fstest/appserv/fstest/LOGS>ps -ef | grep BBL

psdev 11265 1 0 Feb12 ? 00:30:15 BBL -C dom=fsdvlp_38538 -g 30002 -i 0 -u psfststapp601 -U /usr/opt/app/psoft/fsdvlp/appserv/fsdvlp/LOGS/TUXLOG -m 0 -A

psdev 11731 1 0 Feb12 ? 00:40:37 BBL -C dom=fsdvlpib_125924 -g 30002 -i 0 -u psfststapp601 -U /usr/opt/app/psoft/fsdvlp/appserv/fsdvlpib/LOGS/TUXLOG -m 0 -A

psdev 12448 1 0 Feb12 ? 00:29:19 BBL -C dom=fsdbug_254215 -g 30002 -i 0 -u psfststapp601 -U /usr/opt/app/psoft/fsdbug/appserv/fsdbug/LOGS/TUXLOG -m 0 -A

pstest 24357 1 0 08:33 pts/0 00:00:00 BBL -C dom=fstest_232009 -g 30002 -i 0 -u psfststapp601 -U /usr/opt/app/psoft/fstest/appserv/fstest/LOGS/TUXLOG -m 0 -A

pstest 25753 24154 0 08:40 pts/0 00:00:00 grep --color=auto BBL

pstest-psfststapp602:fstest:/usr/opt/app/psoft/fstest/appserv/fstest/LOGS>ps -ef | grep BBL

pstest 7681 1 0 May27 ? 00:02:23 BBL -C dom=fstestib_210515 -g 30002 -i 0 -u psfststapp602 -U /usr/opt/app/psoft/fstest/appserv/fstestib/LOGS/TUXLOG -m 0 -A

psdev 10881 1 0 Feb12 ? 00:31:37 BBL -C dom=fsdvlp_60602 -g 30002 -i 0 -u psfststapp602 -U /usr/opt/app/psoft/fsdvlp/appserv/fsdvlp/LOGS/TUXLOG -m 0 -A

psdev 11345 1 0 Feb12 ? 00:26:26 BBL -C dom=fsdvlpib_69890 -g 30002 -i 0 -u psfststapp602 -U /usr/opt/app/psoft/fsdvlp/appserv/fsdvlpib/LOGS/TUXLOG -m 0 -A

psdev 11679 1 0 Feb12 ? 00:30:28 BBL -C dom=fsdbug_97629 -g 30002 -i 0 -u psfststapp602 -U /usr/opt/app/psoft/fsdbug/appserv/fsdbug/LOGS/TUXLOG -m 0 -A

pstest 19335 1 0 08:34 pts/0 00:00:00 BBL -C dom=fstest_115473 -g 30002 -i 0 -u psfststapp602 -U /usr/opt/app/psoft/fstest/appserv/fstest/LOGS/TUXLOG -m 0 -A

pstest 20096 19081 0 08:41 pts/0 00:00:00 grep --color=auto BBL

FSPROD

sys U_nnhzPAEhzR58BVb

system M_2ZXuh7xE3z6Z5Xe

FSTEST

sys Z_GC3HLU7ZfguQxgw

system j_qxU5c6rknCwWGWZ

FSDVLP

sys M_X2yT3qrv5TCu5L5 incorrect

sys Z_GC3HLU7ZfguQxgw corrected June 28th 2022

system j_qxU5c6rknCwWGWZ

FSDBUG

sys v_YHk3vaC8bb2PCuJ

system j_qxU5c6rknCwWGWZ

FSCNV1

sys Z_GC3HLU7ZfguQxgw

system j_qxU5c6rknCwWGWZ

Saturday Aug 14th

SQL> set time on

15:27:04 SQL> set timing on

15:27:07 SQL> drop user dbadmin cascade;

User dropped.

Elapsed: 12:49:33.51

04:16:53 SQL>

FSPROD EXPORT:

******************************************************************************

Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:

/usr/opt/app/dbdump/export/fsproddbadmin01.dmp

/usr/opt/app/dbdump/export/fsproddbadmin02.dmp

/usr/opt/app/dbdump/export/fsproddbadmin03.dmp

/usr/opt/app/dbdump/export/fsproddbadmin04.dmp

Job "SYS"."SYS_EXPORT_SCHEMA_01" completed with 1 error(s) at Sun Jun 27 18:45:54 2021 elapsed 0 00:56:41

Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:

/usr/opt/app/dbdump/export/fsproddbadmin01.dmp

/usr/opt/app/dbdump/export/fsproddbadmin02.dmp

/usr/opt/app/dbdump/export/fsproddbadmin03.dmp

/usr/opt/app/dbdump/export/fsproddbadmin04.dmp

Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at Sat Aug 14 09:03:01 2021 elapsed 0 00:59:16

oracle-psfsdb601:fsprod:/usr/opt/app/dbdump/export>scp fsproddbadmin* oracle@psfsdb602:/usr/opt/app/dbdump/export

fsproddbadmin01.dmp 100% 15GB 67.0MB/s 03:53

fsproddbadmin02.dmp 100% 15GB 68.8MB/s 03:50

fsproddbadmin03.dmp 100% 16GB 68.2MB/s 04:01

fsproddbadmin04.dmp 100% 3332MB 65.3MB/s 00:51

fsproddbadmin.log 100% 6152KB 57.4MB/s 00:00

13 mins to transfer from psfsdb601 to psfsdb602

Sat Aug 14 09:21:00 CDT 2021

oracle-psfsdb601:fsprod:/usr/local/oracle>scp /usr/opt/app/dbdump/export/fsproddbadmin0* oracle@psfsdb602:/usr/opt/app/dbdump/export

fsproddbadmin01.dmp 100% 16GB 68.8MB/s 03:55

fsproddbadmin02.dmp 100% 16GB 68.2MB/s 03:57

fsproddbadmin03.dmp 100% 16GB 66.5MB/s 04:05

fsproddbadmin04.dmp 100% 3123MB 68.4MB/s 00:45

fsproddbadmin.log 100% 6152KB 73.7MB/s 00:00

create user DBADMIN identified by fs5809_Prod temporary tablespace temp default tablespace PSDEFAULT profile app_account_profile;

grant create session to dbadmin;

connect dbadmin/fs5809_Prod

connect / as sysdba

create user DBMONTR identified by For_d2n32 temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to dbmontr;

connect dbmontr/For_d2n32

connect / as sysdba

create user DBSNMP identified by ax39CCnVmyz6QAr_x temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to dbsnmp;

connect dbsnmp/ax39CCnVmyz6QAr_x

connect / as sysdba

create user DSLOADS identified by Znzkm6R9GRgbnXW_t temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to dsloads;

connect dsloads/Znzkm6R9GRgbnXW_t

connect / as sysdba

create user EMAILINTERFACE identified by email_1Nterface temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to emailinterface;

connect emailinterface/email_1Nterface

connect / as sysdba

create user EMPLOYMENT identified by empl0y_Ment temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to employment;

connect employment/empl0y_Ment

connect / as sysdba

create user EPROINTERFACE identified by epro_1Nterface temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to eprointerface;

connect eprointerface/epro_1Nterface

connect / as sysdba

create user EXPINTERFACE identified by exp_1Nterface temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to expinterface;

connect expinterface/exp_1Nterface

connect / as sysdba

create user GLINTERFACE identified by gl_1Nterface temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to glinterface;

connect glinterface/gl_1Nterface

connect / as sysdba

create user HVRADMIN identified by hvr_1Nterface temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to hvradmin;

connect hvradmin/hvr_1Nterface

connect / as sysdba

create user ITAUDITADMIN identified by N_gvsPmgM36m92p8Y temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to itauditadmin;

connect itauditadmin/N_gvsPmgM36m92p8Y

connect / as sysdba

create user LASERFISH identified by G05hres33_G temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to laserfish;

connect laserfish/G05hres33_G

connect / as sysdba

create user MEXPINTERFACE identified by mexp_1Nterface temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to mexpinterface;

connect mexpinterface/mexp_1Nterface

connect / as sysdba

create user PEOPLE identified by People_123 temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to people;

connect people/People_123

connect / as sysdba

create user PROJECT identified by proj_1Nterface temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to project;

connect project/proj_1Nterface

connect / as sysdba

create user PS identified by People_123 temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to ps;

connect ps/People_123

connect / as sysdba

create user PSHYDRMSTAG identified by usethis_Jan2018 temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to pshydrmstag;

connect pshydrmstag/usethis_Jan2018

connect / as sysdba

create user PYGLINTERFACE identified by pygl_1Nterface temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to pyglinterface;

connect pyglinterface/pygl_1Nterface

connect / as sysdba

create user APINTERFACE identified by ap_1Nterface temporary tablespace temp default tablespace users profile app_account_profile;

grant create session to apinterface;

connect apinterface/ap_1Nterface

connect / as sysdba

alter user dbsnmp identified by ax39CCnVmyz6QAr_x profile app_account_profile;

connect dbsnmp/ax39CCnVmyz6QAr_x

connect / as sysdba

OAK273

ODMS55

OJGM4

OJM79

OMC276

ORS424

OSSP14

Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT

ORA-39083: Object type OBJECT_GRANT failed to create with error:

ORA-01917: user or role 'APINTERFACE' does not exist

Failing sql is:

GRANT SELECT ON "DBADMIN"."PS_VENDR_PY_TMW_VW" TO "APINTERFACE"

Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY

oracle-psfsdb601:fsprod:/usr/local/oracle>expdp parfile=expdp_schema_paralell.par

Export: Release 12.1.0.2.0 - Production on Wed Jul 14 11:50:00 2021

Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:

/usr/opt/app/dbdump/export/fsproddbadmin01.dmp

/usr/opt/app/dbdump/export/fsproddbadmin02.dmp

/usr/opt/app/dbdump/export/fsproddbadmin03.dmp

/usr/opt/app/dbdump/export/fsproddbadmin04.dmp

Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at Wed Jul 14 12:48:49 2021 elapsed 0 00:58:46

oracle-psfsdb601:fsprod:/usr/opt/app/dbdump/export>scp fsproddbadmin* oracle@psfststdb602:/usr/opt/app/dbdump/export

fsproddbadmin01.dmp 100% 16GB 26.4MB/s 10:07

fsproddbadmin02.dmp 100% 16GB 26.5MB/s 10:09

fsproddbadmin03.dmp 100% 16GB 25.8MB/s 10:51

fsproddbadmin04.dmp 100% 2588MB 24.6MB/s 01:45

fsproddbadmin.log 100% 6152KB 25.3MB/s 00:00

Wed Jul 14 11:56:00 2021

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

SQL> set time on

11:56:02 SQL> set timing on

11:56:05 SQL> drop user dbadmin cascade;

User dropped.

Elapsed: 14:17:20.84

-rw-------. 1 oracle dba 1656 Jun 28 10:26 upggrant_5.sql

-rw-------. 1 oracle dba 1791 Jun 28 10:26 dbowner_4.sql

-rw-------. 1 oracle dba 2114 Jun 28 10:25 connect_3.sql

-rw-------. 1 oracle dba 190 Jun 28 10:25 RowCounts_AfterImport_602.sql

-rw-------. 1 oracle dba 3061 Jun 28 10:24 psadmin_2.sql

-rw-------. 1 oracle dba 3576 Jun 28 10:23 psroles_1.sql

SQL>@RecompileAllSchmeas.sql

SQL>alter user dbadmin identified by fs5809_Prod account unlock profile app_account_profile;

SQL> connect dbadmin/fs5809_Prod

Connected.

SQL> @RowCounts_AfterImport_602.sql

SQL> set time on

10:36:02 SQL> set timing on

10:36:02 SQL> create table RWCNTS_AFTER_IMPORT as select /*+ NO_INDEX */ table_name, get_rows( user||'.'||table_name) row_count from user_tables order by table_name;

Table created.

Elapsed: 00:10:41.32

10:55:08 SQL> connect people/People_123

Connected.

11:06:22 SQL> connect / as sysdba

alter system set global_names=false scope=spfile;

2021 Aug 14th:

oracle-psfsdb602.tmw.com:fsprod:/usr/local/oracle>ls -lrt nohup*

-rw-------. 1 oracle dba 6355937 Jun 28 21:44 nohup.out

oracle-psfsdb602.tmw.com:fsprod:/usr/local/oracle>rm nohup.out

oracle-psfsdb602.tmw.com:fsprod:/usr/local/oracle>nohup time impdp_bg_script.sh &

[1] 3794558

oracle-psfsdb602.tmw.com:fsprod:/usr/local/oracle>nohup: ignoring input and appending output to 'nohup.out'

oracle-psfsdb602.tmw.com:fsprod:/usr/local/oracle>tail -f nohup.out

Import: Release 19.0.0.0.0 - Production on Sat Aug 14 09:24:08 2021

Version 19.12.0.0.0

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

ORA-39082: Object type PACKAGE BODY:"DBADMIN"."SELSTAT" created with compilation warnings

Job "FULLEXPORT"."SYS_IMPORT_SCHEMA_01" completed with 606 error(s) at Sat Aug 14 14:41:15 2021 elapsed 0 05:17:03

Command exited with non-zero status 5

10.41user 4.95system 5:17:09elapsed 0%CPU (0avgtext+0avgdata 24644maxresident)k

83880inputs+13240outputs (18major+2095minor)pagefaults 0swaps

SQL> select db_link from dba_db_links;

DB_LINK

--------------------------------------------------------------------------------

SYS_HUB

EMPLOYMENT_HRPROD

EMRINTERFACE_FCPROD

EPROINTERFACE_HRPROD

HRPROD_EXPINTERFACE

HRPROD_JABINTERFACE

HRPROD_PYGLINTERFACE

PSHYDRMSTAG

SQL> connect / as sysdba

Connected.

SQL> drop database link SYS_HUB;

Database link dropped.

drop synonym PS_ACCT_INT_TMW_DRM;

drop synonym PS_ASSOCIATIONS;

drop synonym PS_CUBES;

drop synonym PS_DEPT_INT_TMW_DRM;

drop synonym PS_DEPT_TBL_VW_HR;

drop synonym PS_DEPT_TBL_VW_TMW;

drop synonym PS_DIMENSIONS;

drop synonym PS_EMP_INT_TMW;

drop synonym PS_GL_EXP_PDVW_TMW;

drop synonym PS_HIERARCHIES;

drop synonym PS_HR_ACCTG_LINE;

drop synonym PS_HR_DRCT_REP_TMW;

drop synonym PS_HR_LINE_SYN_TMW;

drop synonym PS_JAB_SN_EE_TMW;

drop synonym PS_JOB;

drop synonym PS_MEMBERS;

drop synonym PS_NAMES;

drop synonym PS_PERSONAL_DATA;

drop synonym PS_PROJ_INT_TMW_DRM;

drop synonym PS_SNM_MSTR_TMW;

drop synonym PS_STORES;

drop synonym PS_STORE_FACTS;

TMWNFS\INTERDEV\tmw\fstest19_in

TMWNFS\INTERDEV\tmw\fstest19_am

TMWNFS\INTERDEV\tmw\fstest19_ar

TMWNFS\INTERDEV\tmw\fstest19_ap

TMWNFS\INTERDEV\tmw\fstest19_gl

TMWNFS\INTERDEV\tmw\fstest19_pv

TMWNFS\INTERDEV\tmw\fstest19_tr

TMWNFS\INTERDEV\tmw\fstest19_trdata

For the directories above, please give read/write access to the following plus pstest:

Please create TMWNFS\INTERDEV\tmw\fstest19_log_output

The following should have read / write access

pstest <-- resource account

PSOFT <-- resource account

Karen Leist - KRL25

John Mannion – JTM3

Xavier Raj – XJ1

Ken he – KH167

Tizza – TP47

Mark S – JMS161

Lennard – LS90

Larry – LOC1

James Yelderman – JDY4

Dianne – DMM101

Gail – MGF6

Joyce – JM193

Melanie – MDT14

Lesley – LAM58

Iain – IDK1

Sara – SEP28

Rita – REF1

Julia – JAC62

Rita – RYV1

Jan – JGM4

Ajay – AK273

Mark – MC276

Olivia – OD6

Brittany Butler (BSB11)

Patel, Manan B (MP356)

Wester, Rachael (RW155)

Montoya, Jose (JM199)

Benson, Stacey L (SLB65)

Higginson, Tiffany R (TRH5)

Morales, Jessica E (JM487)

Chen, Danielle (DC271)

Adrian Davis (AD298)

Adnan Khan (AMK61)

Gladys Urbano (GBU2)

Jessy Varghese (JTV4)

Thien Nguyen (TN104)

Shonna Miller (SM468)

Jennifer Brown (JB495)

Thanks

TMWNFS\INTERPROD\tmw\fsprod19_in

TMWNFS\INTERDEV\tmw\fstest19_am

TMWNFS\INTERDEV\tmw\fstest19_ar

TMWNFS\INTERDEV\tmw\fstest19_ap

TMWNFS\INTERDEV\tmw\fstest19_gl

TMWNFS\INTERDEV\tmw\fstest19_pv

TMWNFS\INTERDEV\tmw\fstest19_tr

TMWNFS\INTERPROD\tmw\fsprod19_log_output

TMWNFS\INTERDEV\tmw\fstest19_trdata

SeasOfCheese2025!

PeopleTools / Multi Channel Framework / Email / Sample Pages /

in fstest19: PSMOBILEFSTEST / SeasOfCheese20_25! on psmail.tmw.com as of Nov 2021 USE TO BE on mailhost.tmw.com or SMTP_mail.tmw.com

The IB node that we use is PSFT_EMC_GETMAIL

PeopleTools Workflow began supporting Transport Layer Security (TLS) for SMTP Servers for Outbound email with PeopleTools 8.54, and the functionality was back ported later into PT 8.53.24

tbitstmail.tmw.com

Effective 2025 Dec 5th:

SeasOfCheese2021! <-- old password

psmobilefstest / SeasOfCheese20_25!

psmobilefsprod / SeasOfCheese20_25!

Installing Application Server-Based Digital Certificates, Press Enter to collapse

Add CA authorities and install root certificates.

Select PeopleTools > Security > Security Objects > Digital Certificates.. The Digital Certificates page displays.

pstest-psfststps601:fstest19:/usr/opt/app/psoft/pt858/fstest_cfg/appserv/prcs/fstest>echo $PS_TREEBASEDIR

/usr/opt/app/psoft/pt858/fstest_tree_loc

pstest-psfststps601:fstest19:/usr/opt/app/psoft/pt858/fstest_cfg/appserv/prcs/fstest>cd /usr/opt/app/psoft/pt858/fstest_tree_loc

pstest-psfststps601:fstest19:/usr/opt/app/psoft/pt858/fstest_tree_loc>ls

KH167

pstest-psfststps601:fstest19:/usr/opt/app/psoft/pt858/fstest_tree_loc>cd *

pstest-psfststps601:fstest19:/usr/opt/app/psoft/pt858/fstest_tree_loc/KH167>ls

Ex_accts_tbi.txt

pstest-psfststps601:fstest19:/usr/opt/app/psoft/pt858/fstest_tree_loc/KH167>ls -lrt

total 64

-rw-rw---- 1 pstest psoft 62666 Sep 20 18:59 Ex_accts_tbi.txt

pstest-psfststps601:fstest19:/usr/opt/app/psoft/pt858/fstest_tree_loc/KH167>tail Ex_accts_tbi.txt

6A DEPR_OTHER 675980 675999 N

6ADEPR_AUTO DEPRECIATION G5 DEPR_OTHER

6A DEPR_AUTO 675900 675979 N

6AINTEREST_OTHER INTEREST G5

6A INTEREST_OTHER 700000 700099 N

6A INTEREST_OTHER 700431 700899 N

6AINTEREST_EXP INTEREST G5 INTEREST_OTHER

6A INTEREST_EXP 700100 700430 N

6AAMORT_LOAN_COST INTEREST G5 INTEREST_EXP

6A AMORT_LOAN_COST 676100 676100 N

pstest-psfststps601:fstest19:/usr/opt/app/psoft/pt858>ls -lrt

total 4

drwxr-xr-x 29 pstest psoft 4096 Jul 16 12:42 fstest_pt85809

drwxr-xr-x 11 pstest psoft 153 Jul 22 14:38 fscm92_fstest

drwxr-xr-x 5 pstest psoft 54 Jul 22 14:39 fstestcust

drwxr-xr-x 5 pstest psoft 119 Sep 20 13:55 fstest_cfg

drwxrwxr-x 3 pstest psoft 18 Sep 20 18:59 fstest_tree_loc

Images for FS:

located on both webservers:

/usr/opt/app/psoft/fsprod/webserv/fsprod/applications/peoplesoft/PORTAL.war/fsprod/images_tmw/corp , msp , pcr

Nvision - copied files:

tmwapppst701 log in as psoftadmin / 850ps!ATD

G:\app\psoft\pt858\fsprod\fsprod_pt85809\fsnvision

G:\app\psoft\pt858\fsprod\fsprod_pt85809\nvision

service to start the batch service is not working, but launch psadmin to start / stop process

G:\app\pt\ps_home8.58.09\appserv\xdo.cfg

G:\app\psoft\pt858\fsprod\fsprod_pt85809\appserv\xdo.cfg

Font micr

copy file to MICRE13B.ttf to c:\windows\fonts

tmwapppsttst701 log in as pstestadmin / 850ps!New

G:\app\psoft\pt858\fstest\fstest_pt85809\appserv\xdo.cfg

Font micr

copy file to MICRE13B.ttf to c:\windows\fonts

tmwctxpst501

L:\app\pt\ps_home8.58.09\nvision

L:\app\pt\ps_home8.58.09\config and L:\app\config <--- for the BAT scripts to start / stop service

L:\app\pt\ps_home8.58.09\appserv\xdo.cfg

<fonts>

</font>

</fonts>

Font micr

copy file to MICRE13B.ttf to c:\windows\fonts

For elastic search to work, both IB appserver and webserver needs to be up and running

eproftp / sftponly

Check Administer File Attachments

2021 Oct 18th:

oracle-psfsdb602.tmw.com:fsprod:/usr/opt/app/dbdump/export>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 18 10:57:57 2021

Version 19.12.0.0.0

SQL> set time on

10:58:03 SQL> set timing on

10:58:05 SQL> drop user dbadmin cascade;

User dropped.

Elapsed: 13:52:49.10

00:51:11 SQL>

oracle-psfsdb601:fsprod:/usr/local/oracle>expdp parfile=expdp_schema_paralell.par

Export: Release 12.1.0.2.0 - Production on Mon Oct 18 18:09:20 2021

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

FLASHBACK automatically enabled to preserve database integrity.

Starting "SYS"."SYS_EXPORT_SCHEMA_01": /******** AS SYSDBA parfile=expdp_schema_paralell.par

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 518.5 GB

[...]

. . exported "DBADMIN"."PS_ZONE_INV_LANG" 0 KB 0 rows

. . exported "DBADMIN"."PTGRANTTBL" 0 KB 0 rows

. . exported "DBADMIN"."S1" 0 KB 0 rows

. . exported "DBADMIN"."TKPROF_TABLE" 0 KB 0 rows

. . exported "DBADMIN"."UPG_CP_RULE_TAO" 0 KB 0 rows

. . exported "DBADMIN"."WSSITETREELANG" 0 KB 0 rows

. . exported "DBADMIN"."WSSTETREDEFNLNG" 0 KB 0 rows

Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:

/usr/opt/app/dbdump/export/fsproddbadmin01.dmp

/usr/opt/app/dbdump/export/fsproddbadmin02.dmp

/usr/opt/app/dbdump/export/fsproddbadmin03.dmp

/usr/opt/app/dbdump/export/fsproddbadmin04.dmp

Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Oct 18 19:14:32 2021 elapsed 0 01:05:11

to transfer files to psfststdb601 - fsdvlp: 36mins

oracle-psfststdb601.tmw.com::/usr/opt/app/dbdump/export>scp oracle@psfsdb601:/usr/opt/app/dbdump/export/fsproddbadmin* .

fsproddbadmin01.dmp 100% 16GB 25.6MB/s 10:38

fsproddbadmin02.dmp 100% 17GB 24.9MB/s 11:42

fsproddbadmin03.dmp 100% 17GB 25.8MB/s 11:20

fsproddbadmin04.dmp 100% 4386MB 27.4MB/s 02:39

fsproddbadmin.log 100% 6152KB 26.3MB/s 00:00

To transfer files to psfsdb602 - fsprod19: 18 mins

oracle-psfsdb601:fsprod:/usr/local/oracle>scp /usr/opt/app/dbdump/export/fsproddbadmin* oracle@psfsdb602:/usr/opt/app/dbdump/export

fsproddbadmin01.dmp 100% 16GB 56.9MB/s 04:47

fsproddbadmin02.dmp 100% 17GB 55.7MB/s 05:14

fsproddbadmin03.dmp 100% 17GB 51.5MB/s 05:40

fsproddbadmin04.dmp 100% 4386MB 50.7MB/s 01:26

fsproddbadmin.log

oracle-psfsdb602.tmw.com::/usr/opt/app/dbdump/export>tail -f /usr/local/oracle/nohup.out

Import: Release 19.0.0.0.0 - Production on Tue Oct 19 07:58:28 2021

Version 19.12.0.0.0

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Master table "FULLEXPORT"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded

Starting "FULLEXPORT"."SYS_IMPORT_SCHEMA_01": fullexport/******** parfile=impdp_schema.par

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

[...]

ORA-39082: Object type VIEW:"DBADMIN"."PS_TE_SUBCAT_VW" created with compilation warnings

ORA-39082: Object type PACKAGE BODY:"DBADMIN"."SELSTAT" created with compilation warnings

Job "FULLEXPORT"."SYS_IMPORT_SCHEMA_01" completed with 37 error(s) at Tue Oct 19 13:47:09 2021 elapsed 0 05:48:38

SQL> select db_link from dba_db_links;

DB_LINK

--------------------------------------------------------------------------------

EMPLOYMENT_HRPROD

EMRINTERFACE_FCPROD

EPROINTERFACE_HRPROD

HRPROD_EXPINTERFACE

HRPROD_JABINTERFACE

HRPROD_PYGLINTERFACE

PSHYDRMSTAG

7 rows selected.

drop database link EMPLOYMENT_HRPROD;

drop database link EMRINTERFACE_FCPROD;

drop database link EPROINTERFACE_HRPROD;

drop database link HRPROD_EXPINTERFACE;

drop database link HRPROD_JABINTERFACE;

drop database link HRPROD_PYGLINTERFACE;

drop database link PSHYDRMSTAG;

DROP SYNONYM PS_HR_ACCTG_LINE;

DROP SYNONYM PS_JOB;

DROP SYNONYM PS_NAMES;

DROP SYNONYM PS_PERSONAL_DATA;

DROP SYNONYM PS_SNM_MSTR_TMW;

FS_PostRefreshScripts.sql

SQL> set time on

13:56:45 SQL> set timing on

13:56:52 SQL> @RowCounts_AfterImport_602.sql

13:56:54 SQL> set time on

13:56:54 SQL> set timing on

13:56:54 SQL> create table RWCNTS_AFTER_IMPORT as select /*+ NO_INDEX */ table_name, get_rows( user||'.'||table_name) row_count from user_tables order by table_name;

Table created.

Elapsed: 00:13:51.40

14:10:45 SQL> 14:10:45 SQL>

update tnsnames on psfsdb602 to point to prod.

update GRANT script for just SELECT access and not insert,update,delete

Run GRANT script. started at 2pm , duration is 3 mins

Checking Administer File Attachments : Setup Financial / , check for #2 being active

update dbadmin.ps_pycycl_prnt_tmw

set descr50 = '\\tmwapppst701\TreasuryChecks'

where descr50 = '\\tmwapppst401\Treasuryadvice';

1 row

update dbadmin.ps_pycycl_prnt_tmw

set descr50 = replace(descr50,'tmwapppst401','tmwapppst701');

5 rows

Check PSUNX and PSNT to distribute to same OS and remove nVision from PSUNX

install OEM on psfsdb602 - DONE

psoft-psfsps601.tmw.com:fsprod:/usr/opt/app>ls -lrt ./psoft/pt858/fsprod_pt85809/projects/PPLTLS84CUR/PPLTLS84CUR.XML

-rwxr-xr-x 1 psoft psoft 1303455968 Jan 13 2021 ./psoft/pt858/fsprod_pt85809/projects/PPLTLS84CUR/PPLTLS84CUR.XML

psoft-psfsps601.tmw.com:fsprod:/usr/opt/app>mkdir /usr/opt/app/psoft/psreports/XML

psoft-psfsps601.tmw.com:fsprod:/usr/opt/app>mv ./psoft/pt858/fsprod_pt85809/projects/PPLTLS84CUR/PPLTLS84CUR.XML /usr/opt/app/psoft/psreports/XML

alias changes - 2

snapshot backups - 3

name datastage server - Murty

kris -

Craig to have new citrix icons - 2pm

Ashish -

109876 emp id Christina

013108 emp id

aug 25th

the title is Colorado

8005260157 - title dept

fsprod.tmw.com (172.31.102.38)

port 80 on LB should route traffic to 21780 on pool members

port 443 on LB should route traffic to 21743 on pool members

fsprodib.tmw.com = fsprodib92.tmw.com (172.31.102.37)

port 80 on LB should route traffic to 21880 on pool members

port 443 on LB should route traffic to 21843 on pool members

Name: psfsws601.tmw.com

Address: 172.31.102.29

Name: psfsws602.tmw.com

Address: 172.31.102.30

Thanks

2021 Nov 11th

On FSPROD19:

SQL> l

1* select username, account_status from dba_users where account_status <> 'OPEN' order by username

SQL> /

USERNAME ACCOUNT_STATUS

-------------------------------------------------------------------------------------------------------------------------------- --------------------------------

ANONYMOUS EXPIRED & LOCKED

APINTERFACE LOCKED

APPQOSSYS LOCKED

AUDSYS LOCKED

DBMONTR LOCKED

DBSFWUSER LOCKED

DIP LOCKED

DSLOADS LOCKED

EMAILINTERFACE LOCKED

EMPLOYMENT LOCKED

EPROINTERFACE LOCKED

USERNAME ACCOUNT_STATUS

-------------------------------------------------------------------------------------------------------------------------------- --------------------------------

EXPINTERFACE LOCKED

GGSYS LOCKED

GLINTERFACE LOCKED

GSMADMIN_INTERNAL LOCKED

GSMCATUSER LOCKED

GSMUSER LOCKED

HVRADMIN LOCKED

ITAUDITADMIN LOCKED

LASERFISH LOCKED

MEXPINTERFACE LOCKED

OJVMSYS LOCKED

USERNAME ACCOUNT_STATUS

-------------------------------------------------------------------------------------------------------------------------------- --------------------------------

OLAPSYS LOCKED

ORACLE_OCM LOCKED

OUTLN LOCKED

PROBEADMIN LOCKED

PROJECT LOCKED

PSHYDRMSTAG LOCKED

PYGLINTERFACE LOCKED

REMOTE_SCHEDULER_AGENT LOCKED

SYS LOCKED

SYS$UMF LOCKED

SYSBACKUP LOCKED

USERNAME ACCOUNT_STATUS

-------------------------------------------------------------------------------------------------------------------------------- --------------------------------

SYSDG LOCKED

SYSKM LOCKED

SYSRAC LOCKED

WMSYS LOCKED

XDB LOCKED

XS$NULL EXPIRED & LOCKED

39 rows selected.

. . exported "DBADMIN"."TKPROF_TABLE" 0 KB 0 rows

. . exported "DBADMIN"."UPG_CP_RULE_TAO" 0 KB 0 rows

. . exported "DBADMIN"."WSSITETREELANG" 0 KB 0 rows

. . exported "DBADMIN"."WSSTETREDEFNLNG" 0 KB 0 rows

Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:

/usr/opt/app/dbdump/export/fsproddbadmin01.dmp

/usr/opt/app/dbdump/export/fsproddbadmin02.dmp

/usr/opt/app/dbdump/export/fsproddbadmin03.dmp

/usr/opt/app/dbdump/export/fsproddbadmin04.dmp

Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at Fri Nov 12 19:48:39 2021 elapsed 0 01:00:24

oracle-psfsdb601:fsprod:/usr/opt/app/dbdump/export>ls -lrt fsproddbadmin*

-rw-r----- 1 oracle dba 17616527360 Nov 12 19:48 fsproddbadmin01.dmp

-rw-r----- 1 oracle dba 17781358592 Nov 12 19:48 fsproddbadmin03.dmp

-rw-r----- 1 oracle dba 5896060928 Nov 12 19:48 fsproddbadmin04.dmp

-rw-r----- 1 oracle dba 17610252288 Nov 12 19:48 fsproddbadmin02.dmp

-rw-r--r-- 1 oracle dba 6299628 Nov 12 19:48 fsproddbadmin.log

oracle-psfsdb601:fsprod:/usr/opt/app/dbdump/export>scp fsproddbadmin* oracle@psfsdb602:/usr/opt/app/dbdump/export

fsproddbadmin01.dmp 100% 16GB 72.2MB/s 03:52

fsproddbadmin02.dmp 100% 16GB 71.5MB/s 03:55

fsproddbadmin03.dmp 100% 17GB 72.1MB/s 03:55

fsproddbadmin04.dmp 100% 5623MB 75.0MB/s 01:15

fsproddbadmin.log 100% 6152KB 61.2MB/s 00:00

/dev/mapper/dbdump_vg-dbdump_lv 400G 210G 191G 53% /usr/opt/app/dbdump

oracle-psfsdb602.tmw.com:fsprod:/usr/opt/app/dbdump/export>ls -lrt fsproddbadmin*

-rw-------. 1 oracle dba 17616527360 Nov 12 19:55 fsproddbadmin01.dmp

-rw-------. 1 oracle dba 17610252288 Nov 12 19:59 fsproddbadmin02.dmp

-rw-------. 1 oracle dba 17781358592 Nov 12 20:02 fsproddbadmin03.dmp

-rw-------. 1 oracle dba 5896060928 Nov 12 20:04 fsproddbadmin04.dmp

-rw-------. 1 oracle dba 6299628 Nov 12 20:04 fsproddbadmin.log

oracle-psfsdb602.tmw.com:fsprod:/usr/opt/app/dbdump/export>

oracle-psfsdb602.tmw.com:fsprod:/usr/local/oracle>nohup time impdp_bg_script.sh &

oracle-psfsdb602.tmw.com::/usr/local/oracle>tail -f nohup.out

Import: Release 19.0.0.0.0 - Production on Fri Nov 12 20:11:32 2021

Version 19.13.0.0.0

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

[..]

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX started at 10.15pm

[..]

ORA-39082: Object type VIEW:"DBADMIN"."PS_TE_TYP_PRDM_VW3" created with compilation warnings

ORA-39082: Object type VIEW:"DBADMIN"."PS_TE_TYPE_MERCHNT" created with compilation warnings

ORA-39082: Object type VIEW:"DBADMIN"."PS_TE_CATEGORY_VW" created with compilation warnings

ORA-39082: Object type VIEW:"DBADMIN"."PS_TE_SUBCAT_VW" created with compilation warnings

ORA-39082: Object type PACKAGE BODY:"DBADMIN"."SELSTAT" created with compilation warnings

Job "FULLEXPORT"."SYS_IMPORT_SCHEMA_01" completed with 36 error(s) at Sat Nov 13 00:51:46 2021 elapsed 0 04:40:12

SQL> select db_link from dba_db_links;

DB_LINK

--------------------------------------------------------------------------------

EMPLOYMENT_HRPROD

EMRINTERFACE_FCPROD

EPROINTERFACE_HRPROD

HRPROD_EXPINTERFACE

HRPROD_JABINTERFACE

HRPROD_PYGLINTERFACE

PSHYDRMSTAG

7 rows selected.

DROP SYNONYM PS_HR_ACCTG_LINE;

DROP SYNONYM PS_JOB;

DROP SYNONYM PS_NAMES;

DROP SYNONYM PS_PERSONAL_DATA;

DROP SYNONYM PS_SNM_MSTR_TMW;

drop synonym PS_ACCT_INT_TMW_DRM;

drop synonym PS_ASSOCIATIONS;

drop synonym PS_CUBES;

drop synonym PS_DEPT_INT_TMW_DRM;

drop synonym PS_DEPT_TBL_VW_HR;

drop synonym PS_DEPT_TBL_VW_TMW;

drop synonym PS_DIMENSIONS;

drop synonym PS_EMP_INT_TMW;

drop synonym PS_GL_EXP_PDVW_TMW;

drop synonym PS_HIERARCHIES;

drop synonym PS_HR_DRCT_REP_TMW;

drop synonym PS_HR_LINE_SYN_TMW;

drop synonym PS_JAB_SN_EE_TMW;

drop synonym PS_MEMBERS;

drop synonym PS_PROJ_INT_TMW_DRM;

drop synonym PS_STORES;

drop synonym PS_STORE_FACTS;

From: Murugappan, Gillian (GM15) <Gillian.Murugappan@tailoredbrands.com>

Sent: Wednesday, September 8, 2021 1:31 PM

To: Miller, Janette G (JGM4) <Jan.Miller@tailoredbrands.com>; Venkat Gangula <venkat@kastechssg.com>

Subject: RE: payment elastic search build

Thanks Venkat for identifying the patch.

We will need to add this patch for bug 28515952, on Go-live day, as well as to fsprod19 for testing. I will do the fsprod19 this week.

Will also update the Jira ticket

Jan, let me know when you have time to go through PUM40 to pull out what we need for the bug 30922794 , Page not found issue. Appling 2000+ patches is not acceptable.

Thanks

export log

import log

count table names

April 20th Lucernex access on Kira

new group HOU-NFS-P2-TB-LXProd-Guest, populated as requested. Applied group to "TMWNFS\INTERPROD\tb\lx_prod" ACL with Read-only permissions.

Built FSCNV1

FSCNV1

sys Z_GC3HLU7ZfguQxgw

system j_qxU5c6rknCwWGWZ

PDBADMIN j_qxU5c6rknCwWGWZ

May 9th 2022:

PSAPPSRV.17775 (543) 1-5834692 17.36.08 0.000019 Cur#1.17775.FSTEST RC=0 Dur=0.000003 Bind-1 type=25 length=26 value=2022-02-17-17.36.08.406656

PSAPPSRV.17775 (543) 1-5834693 17.36.08 0.000012 Cur#1.17775.FSTEST RC=0 Dur=0.000002 Bind-2 type=2 length=4 value=JGM4

PSAPPSRV.17775 (543) 1-5834694 17.36.08 0.000011 Cur#1.17775.FSTEST RC=0 Dur=0.000003 Bind-3 type=2 length=14 value=172.31.107.240

PSAPPSRV.17775 (543) 1-5834695 17.36.08 0.000012 Cur#1.17775.FSTEST RC=0 Dur=0.000002 Bind-4 type=25 length=26 value=2022-02-17-17.08.51.979063

PSAPPSRV.17775 (543) 1-5834696 17.36.08 0.000034 PSORA pid=17775 - OCIBindByName(1,54,5)

PSAPPSRV.17775 (543) 1-5834697 17.36.08 0.000021 PSORA pid=17775 - OCIAttrSet(OCI_HTYPE_BIND,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)

PSAPPSRV.17775 (543) 1-5834698 17.36.08 0.000016 PSORA pid=17775 - OCIAttrSet(OCI_HTYPE_BIND,81,OCI_ATTR_MAXDATA_SIZE)

PSAPPSRV.17775 (543) 1-5834699 17.36.08 0.000036 PSORA pid=17775 - OCIBindByName(2,512,5)

PSAPPSRV.17775 (543) 1-5834700 17.36.08 0.000019 PSORA pid=17775 - OCIAttrSet(OCI_HTYPE_BIND,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)

PSAPPSRV.17775 (543) 1-5834701 17.36.08 0.000016 PSORA pid=17775 - OCIAttrSet(OCI_HTYPE_BIND,768,OCI_ATTR_MAXDATA_SIZE)

PSAPPSRV.17775 (543) 1-5834702 17.36.08 0.000021 PSORA pid=17775 - OCIBindByName(3,512,5)

PSAPPSRV.17775 (543) 1-5834703 17.36.08 0.000016 PSORA pid=17775 - OCIAttrSet(OCI_HTYPE_BIND,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)

PSAPPSRV.17775 (543) 1-5834704 17.36.08 0.000015 PSORA pid=17775 - OCIAttrSet(OCI_HTYPE_BIND,768,OCI_ATTR_MAXDATA_SIZE)

PSAPPSRV.17775 (543) 1-5834705 17.36.08 0.000024 PSORA pid=17775 - OCIBindByName(4,54,5)

PSAPPSRV.17775 (543) 1-5834706 17.36.08 0.000016 PSORA pid=17775 - OCIAttrSet(OCI_HTYPE_BIND,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)

PSAPPSRV.17775 (543) 1-5834707 17.36.08 0.000022 PSORA pid=17775 - OCIAttrSet(OCI_HTYPE_BIND,81,OCI_ATTR_MAXDATA_SIZE)

PSAPPSRV.17775 (543) 1-5834708 17.36.08 0.000023 PSORA pid=17775 - Cursor #1: bind buffers set size=1

PSAPPSRV.17775 (543) 1-5834709 17.36.08 0.000013 PSORA pid=17775 - Cursor #1: about to Execute

PSAPPSRV.17775 (543) 1-5834710 17.36.08 0.000012 PSORA pid=17775 - OCIStmtExecute()

PSAPPSRV.17775 (543) 1-5834711 17.36.08 0.001589 PSORA pid=17775 - OCIAttrGet(OCI_HTYPE_STMT,OCI_ATTR_ROW_COUNT)

PSAPPSRV.17775 (543) 1-5834712 17.36.08 0.000013 Cur#1.17775.FSTEST RC=0 Dur=0.002274 EXE

PSAPPSRV.17775 (543) 1-5834713 17.36.08 0.000114 PSORA pid=17775 - PS_sqlopc(0000000001448AF0)

PSAPPSRV.17775 (543) 1-5834714 17.36.08 0.000016 PSORA pid=17775 - Cursor #3: connected to DBADMIN@FSTEST

PSAPPSRV.17775 (543) 1-5834715 17.36.08 0.000010 Cur#3.17775.notSamTran RC=0 Dur=0.000089 Open Cursor Handle=0000000001448AF0

PSAPPSRV.17775 (543) 1-5834716 17.36.08 0.000019 PSORA pid=17775 - ClientInfo= , , , ,,

PSAPPSRV.17775 (543) 1-5834717 17.36.08 0.000018 PSORA pid=17775 - OCIAttrSet(OCI_HTYPE_SESSION, , , , ,,, OCI_ATTR_CLIENT_INFO)

PSAPPSRV.17775 (543) 1-5834718 17.36.08 0.000016 PSORA pid=17775 - OCITransCommit(0)

PSAPPSRV.17775 (543) 1-5834719 17.36.08 0.001696 PSORA pid=17775 - ClientId=

PSAPPSRV.17775 (543) 1-5834720 17.36.08 0.000024 PSORA pid=17775 - OCIAttrSet(OCI_HTYPE_SESSION, , 1, OCI_ATTR_CLIENT_IDENTIFIER)

PSAPPSRV.17775 (543) 1-5834721 17.36.08 0.000023 PSORA pid=17775 - OCITransCommit()

PSAPPSRV.17775 (543) 1-5834722 17.36.08 0.000447 Cur#3.17775.FSTEST RC=0 Dur=0.002372 Mon OprID= OSUserName= MachineName= TuxedoDomainName= ChargeBackAccount=

PSAPPSRV.17775 (543) 1-5834723 17.36.08 0.000063 PSORA pid=17775 - Pre-OCIStmtPrepare2() for NULL hStmt

PSAPPSRV.17775 (543) 1-5834724 17.36.08 0.000012 PSORA pid=17775 - OCIStmtRelease()

PSAPPSRV.17775 (543) 1-5834725 17.36.08 0.000019 PSORA pid=17775 - OCIStmtRelease() succeeded, Cursor #3, Statement (null)

PSAPPSRV.17775 (543) 1-5834726 17.36.08 0.000012 PSORA pid=17775 - Cursor #3: dropped

PSAPPSRV.17775 (543) 1-5834727 17.36.08 0.000055 Cur#3.17775.FSTEST RC=0 Dur=0.000171 Disconnect

PSAPPSRV.17775 (543) 1-5834728 17.36.08 0.000021 Cur#1.17775.FSTEST RC=0 Dur=0.000003 Commit

May 12th 2022

Logicsource

userid/password for URLID LOGIC_SOURCE_TMW

tailoredbrands_psoft_system/P1ckf1l3$N0wP13od

sftp tailoredbrands_psoft_system@sftp.logicsource.com

psoft-psfsps601.tmw.com:fsprod:/usr/opt/app>sftp tailoredbrands_psoft_system@sftp.logicsource.com

tailoredbrands_peoplesoft_syst@sftp.logicsource.com's password:

Connected to sftp.logicsource.com.

sftp> pwd

Remote working directory: /tailoredbrands/peoplesoft

userid/password for URLID LOGIC_PROD_TMW

/P1ckf1l3$N0wP13od

tblxuser / j19B#U3aD3Xu <-- sftp user for Lucernex / Accruent

this account has read/write access to:

/interfaces2/tb/lx_prod

/interfaces2/tb/lx_test

sftp103.lucernex.com old IP 34.136.102.161 , new IP 35.224.176.52

username: tailoredbrands

Password: T773Z9UhQ6Xc

Port 22 so for Accruent on Windows server.

2022 May 18th

psfststdb602 :

/rd120 100GB

/rd110 100GB

/rd210 100GB

psfststapp602:

/usr/opt/app 100GB

psfststapp601:

/usr/opt/app 50GB

2022 May 19th:

FSCNV1

sys Z_GC3HLU7ZfguQxgw

system j_qxU5c6rknCwWGWZ

developers password to fscnv1: tempFSCNV_1

https://psfststws601.tmw.com:21343

//psfststapp601.tmw.com:21245 < in IB for HRDBUG for PSFT_EP node to FSCNV1 8.59.09

21245 is Jolt listener on FSCNV1

https://pshrtstws602.tmw.com:20643/PSIGW/PeopleSoftListeningConnector on hrdbug on 2022 Oct 21st

2022 Oct 24th

Project Costing attachments

eproftp / sftponly account used to SFTP

eproftp / letmeftp <-- this was the original password

psfststps601 and psfsps601

/usr/opt/app/sftp/pc_attach

[root@psfsps601 sftp]# ls -lrt

total 18712

drwxr-xr-x 2 eproftp sftponly 6 Oct 24 12:41 pc_attach

drwxrwxrwx 2 eproftp sftponly 16470016 Oct 24 13:11 sftp_attach

http://bcibeta.stapleslink.com/invoke/StaplescXML/receive11

2023 November 29th

1099 UPDATE FOR 2023 (Patchset)

updPRJ35823868.zip 1.2 MB

p2scoupauser/password123 defined in the anonymous node in FSTEST for Bushan

Search This Blog

Groovy DBA

PeopleSoft FS notes

Comments

Post a Comment

Popular posts from this blog

Postgres: To list table owners

Postgres: Clean up stopped replication slot

DB2: To check table status in the event of SQLCODE=-668, SQLSTATE=57007