Skip to content

Instantly share code, notes, and snippets.

@iversond

iversond/PUMManualUpload.sql

Created May 24, 2017 13:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save iversond/3261b84244b4464208d1cc59fa4597ee to your computer and use it in GitHub Desktop.
Save iversond/3261b84244b4464208d1cc59fa4597ee to your computer and use it in GitHub Desktop.
Download ZIP
SQL to manually upload an environment into a PeopleSoft Image and make it accessible in the Update Manager Dashboard.
Raw
PUMManualUpload.sql
insert into PS_PTIASPUSERTGTS values ('VP1', 'FS92DEV');
insert into PS_PTIASPTARGETS values ('FS92DEV', ' ', '8.53.10', '8.53', '10', 'ENG');
insert into PS_PTIASPTARGETLNG values ('FS92DEV', 'ENG');
-- REM INSERTING into PS_PTIASPLOGTGT;
Insert into PS_PTIASPLOGTGT (DBNAME,PTIASPRPTNO,PTIASPPKGAPPLYDT) values ('FS92DEV',16245533,to_timestamp('29-MAR-14','DD-MON-RR HH.MI.SSXFF AM'));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment