In this article I have included details of
1) How PeopleSoft Update Manager (PUM) collects information about Target Database and Source Image?
2) What information PUM collects about Target Database through Change Assistance?
Answer :
Information about target database is stored in Source Image when you upload target database information to source image in change assistance (Tools -> Upload Target Database to Source Image).
Change Assistance initiate Java process which connect to Target database to pull information from target database and connect to Source Image to upload information in source database.
Data from below tables pulled from Target Database after login Authentication using PeopleSoft User.
1)PSLANGUAGES2)PSRELEASE3)PS_MAINTENANCE_LOG4) PSRECFIELD and PSDBFLDLABL (Recursive SQL)5) PS_INSTALLATION6) PSSTATUS
Data uploaded in below tables in Source Image1) PS_PTIASPTARGETS2) PS_PTIASPTARGETLNG3) PS_PTIASPUSERTGTS4) PS_PTIASPLOGTGT5) PS_PTIASPINSTPRD
I have uploaded trace files for reference. This is helpful to know what exact information from above tables fetched by PUM.
PUM uses information from above tables to Create Change Package or Upgrade template.
Below select statements in trace shows data selected from Target Database :
------------------------------------------------------------------------------------------------------
SELECT LONGNAME, LANGUAGE_CD FROM PSOPTIONS
SELECT LANGUAGE_CD FROM PSLANGUAGES WHERE INSTALLED = 1
SELECT TO_CHAR(CAST((RELEASEDTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), RELEASELABEL FROM PSRELEASE WHERE RELEASEDTTM = (SELECT MAX(D.RELEASEDTTM) FROM PSRELEASE D)
SELECT RELEASELABEL FROM PS_MAINTENANCE_LOG WHERE RELEASELABEL LIKE '%PeopleTools%' ORDER BY RELEASELABEL DESC
SELECT DISTINCT A.UPDATE_ID, TO_CHAR(CAST((A.DTTM_IMPORTED) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF') FROM PS_MAINTENANCE_LOG A WHERE A.DTTM_IMPORTED = (SELECT MAX(B.DTTM_IMPORTED) FROM PS_MAINTENANCE_LOG B WHERE A.UPDATE_ID = B.UPDATE_ID)
SELECT FIELDNAME, LABEL_ID, USEEDIT FROM PSRECFIELD WHERE RECNAME = :1
SELECT ALTACCT_OPTN FROM PS_INSTALLATION
SELECT SHORTNAME, LONGNAME FROM PSDBFLDLABL WHERE FIELDNAME = 'ALTACCT_OPTN' AND (LABEL_ID = ' ' OR (' ' = ' ' AND DEFAULT_LABEL = 1))
SELECT COMMITMENT_CNTL_AP FROM PS_INSTALLATION
SELECT COMMITMENT_CNTL_AR FROM PS_INSTALLATION
SELECT COMMITMENT_CNTL_BI FROM PS_INSTALLATION
SELECT COMMITMENT_CNTL_EX FROM PS_INSTALLATION
SELECT COMMITMENT_CNTL_GL FROM PS_INSTALLATION
SELECT COMMITMENT_CNTL_GM FROM PS_INSTALLATION
SELECT COMMITMENT_CNTL_IN FROM PS_INSTALLATION
SELECT COMMITMENT_CNTL_PC FROM PS_INSTALLATION
SELECT COMMITMENT_CNTL_PO FROM PS_INSTALLATION
SELECT COMMITMENT_PROCARD FROM PS_INSTALLATION
SELECT DC_INSTALLED FROM PS_INSTALLATION
SELECT JETFORMS FROM PS_INSTALLATION
SELECT MULTIBOOK_FLAG FROM PS_INSTALLATION
SELECT PROC_PART_GL FROM PS_INSTALLATION
SELECT ADBA FROM PS_INSTALLATION
SELECT AM FROM PS_INSTALLATION
SELECT AP FROM PS_INSTALLATION
SELECT AR FROM PS_INSTALLATION
SELECT AUC FROM PS_INSTALLATION
SELECT BI FROM PS_INSTALLATION
SELECT CA FROM PS_INSTALLATION
SELECT CAT FROM PS_INSTALLATION
SELECT CCM FROM PS_INSTALLATION
sELECT CCU FROM PS_INSTALLATION
SELECT CFG FROM PS_INSTALLATION
SELECT CP FROM PS_INSTALLATION
SELECT DEAL FROM PS_INSTALLATION
SELECT DMI FROM PS_INSTALLATION
SELECT DP FROM PS_INSTALLATION
SELECT EB FROM PS_INSTALLATION
SELECT EG FROM PS_INSTALLATION
SELECT ES FROM PS_INSTALLATION
SELECT EX FROM PS_INSTALLATION
SELECT FAA FROM PS_INSTALLATION
SELECT FCA FROM PS_INSTALLATION
SELECT FO FROM PS_INSTALLATION
SELECT FO_PBM FROM PS_INSTALLATION
SELECT FP FROM PS_INSTALLATION
SELECT FPA FROM PS_INSTALLATION
SELECT GL FROM PS_INSTALLATION
SELECT GM FROM PS_INSTALLATION
SELECT GVC FROM PS_INSTALLATION
SELECT HR FROM PS_INSTALLATION
SELECT INV FROM PS_INSTALLATION
SELECT IP FROM PS_INSTALLATION
SELECT ITAM FROM PS_INSTALLATION
SELECT ITK FROM PS_INSTALLATION
SELECT MG FROM PS_INSTALLATION
SELECT MPA FROM PS_INSTALLATION
SELECT OM FROM PS_INSTALLATION
SELECT PC FROM PS_INSTALLATION
SELECT PGM FROM PS_INSTALLATION
SELECT PM FROM PS_INSTALLATION
SELECT PO FROM PS_INSTALLATION
SELECT PPALM FROM PS_INSTALLATION
SELECT PPESA FROM PS_INSTALLATION
SELECT PPFIN FROM PS_INSTALLATION
SELECT PPSCM FROM PS_INSTALLATION
SELECT PRD FROM PS_INSTALLATION
SELECT PV FROM PS_INSTALLATION
SELECT QS FROM PS_INSTALLATION
SELECT RE FROM PS_INSTALLATION
SELECT RISK FROM PS_INSTALLATION
SELECT RS FROM PS_INSTALLATION
SELECT SCMT FROM PS_INSTALLATION
SELECT SP FROM PS_INSTALLATION
SELECT SPL FROM PS_INSTALLATION
SELECT TD FROM PS_INSTALLATION
SELECT TPM FROM PS_INSTALLATION
SELECT TR FROM PS_INSTALLATION
SELECT WO FROM PS_INSTALLATION
SELECT WR FROM PS_INSTALLATION
SELECT TOOLSREL, UNICODE_ENABLED FROM PSSTATUS
SELECT PTPATCHREL FROM PSSTATUS
Below insert statements shows data Uploaded to PUM Source Image :
------------------------------------------------
INSERT INTO PS_PTIASPTARGETS (DBNAME, LONGNAME, RELEASELABEL, PTIASPTOOLSMAJOR, PTIASPTOOLSMINOR, LANGUAGE_CD) VALUES (:1, :2, :3, :4, :5, :6)
INSERT INTO PS_PTIASPTARGETLNG (DBNAME, LANGUAGE_CD) VALUES (:1, :2)
INSERT INTO PS_PTIASPUSERTGTS (USERID, DBNAME) VALUES (:1, :2)
INSERT INTO PS_PTIASPLOGTGT (DBNAME, PTIASPRPTNO, PTIASPPKGAPPLYDT) VALUES (:1, :2, TO_DATE(:3,'YYYY-MM-DD'))
INSERT INTO PS_PTIASPINSTPRD (DBNAME, PTIASPPRDGRPCD, PTIASPPRDCD, PTIASPPRDNAME, PTIASPINSTALLTBL) VALUES (:1, :2, :3, :4, :5)
Thanks,
Ketan.
