Showing posts with label PeopleSoft. Show all posts
Showing posts with label PeopleSoft. Show all posts

Monday, July 20, 2015

Fixing Login Application Designer PeopleSoft Invalid username and password

Solution 1:
Login using SQL*Plus as user SYSADM, password: SYSADM
[oracle@ptud fmw]$ sqlplus sysadm/SYSADM@FIN92DMO

SQL*Plus: Release 12.1.0.1.0 Production on Mon Jul 20 10:41:46 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Last Successful login time: Mon Jul 20 2015 10:29:00 +07:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> update PSACCESSPRFL set ACCESSID='VP1', ACCESSPSWD='VP1', ENCRYPTED=0
where SYMBOLICID='SYSADM1';
SQL> commit;


Solution 2:
Running with Data Mover.
Open file PS_HOME/scripts/resetpswd.dms

Tuesday, July 14, 2015

Example Running Data Mover PeopleSoft

PeopleSoft Financials and Supply Chain Management  (FSCM 9.2) Directory:

FSCM_HOME=/home/oracle/peoplesoft/PT9.2
export $FSCM_HOME

Syntax of Data Mover Scripts:

Usage: psdmtx [-CT DB2|DB2ODBC|DB2UNIX|INFORMIX|MICROSFT|ORACLE|SYBASE]
[-CS server name]
[-CD database name]
[-CO user id]
[-CP user pswd]
[-CI connect id]
[-CW connect id pswd]
[-I  process instance]
[-FP filename]
 or
psdmtx [parmfile]

Example:
[oracle@ptud1 PT8.54]$ $PS_HOME/bin/psdmtx -CT ORACLE -CS ptudvtg149 -CD FIN92DMO -CO SYSADM -CP SYSADM -CI people -CW people -FP /home/oracle/peoplesoft/PT9.2/scripts/fin92dmoora.dms

PeopleTools 8.54 - Data Mover
Copyright (c) 2015 PeopleSoft, Inc.
All Rights Reserved

Started:  Tue Jul 14 17:09:40 2015
Data Mover Release: 8.54
Database: FIN92DMO (ENG)
Input file: /home/oracle/peoplesoft/PT9.2/data/epzhsa.db (ENG

-CT ORACLE : The type of database to connect to.
-CS ptudvtg149 : Server name
-CD FIN92DMO :  database name
-CO SYSADM : user id
-CP SYSADM : user id password
-CI people : connect id
-CW people : connect id password
-FP /home/oracle/peoplesoft/PT9.2/scripts/fin92dmoora.dms  The filename for the Data Mover import script (DMS) to run. < $FSCM_HOME/scripts/ora.dms>