Posts

Showing posts from December, 2010

List of Delivered PeopleTools Table Names

-- RECORDS AND INDEXES PSRECDEFN; PSRECDEFNLANG; PSRECFIELD; PSINDEXDEFN; PSKEYDEFN; PSDDLMODEL; PSDDLDEFPARMS; PSSPCDDLPARM; PSRECDDLPARM; PSIDXDDLPARM; PSRECFIELDDB; PSRECTBLSPC; -- FIELDS PSDBFIELD; PSDBFIELDLANG; PSDBFLDLABL; PSDBFLDLABLLANG; -- FIELD FORMATS PSFMTDEFN; PSFMTITEM; -- TRANSLATES PSXLATDEFN; PSXLATITEM; PSXLATITEMLANG; -- PAGES PSPNLDEFN; PSPNLFIELD; PSPNLTREECTRL; PSPNLHTMLAREA; PSPNLCNTRLDATA; PSPNLBTNDATA; PSPNLDEFNLANG; PSPNLFIELDLANG; PSPNLHTMLLANG; PSPNLBTNLANG; PSPNLACTIVEX; -- MENUS PSMENUDEFN; PSMENUDEFNLANG; PSMENUITEM; PSMENUITEMLANG; PSXFERITEM; -- PANEL GROUPS PSPNLGRPDEFN; PSPNLGDEFNLANG; PSPNLGROUP; PSPNLGROUPLANG; -- PEOPLECODE PSPCMPROG; PSPCMNAME; -- QUERIES PSQRYDEFN; PSQRYDEFNLANG; PSQRYBIND; PSQRYBINDLANG; PSQRYCRITERIA; PSQRYEXPR; PSQRYFIELD; PSQRYFIELDLANG; PSQRYFLAGS; PSQRYLINK; PSQRYRECORD; PSQRYSELECT; -- TREE STRUCTURES PSTREESTRCT; PSTREESTRCTLANG; -- TREES PST

To migrate Route Control Profiles from one DB to another

PeopleSoft does not deliver a means to migrate Workflow Route Control data from one PeopleSoft database to another, however, this can be accomplished with Datamover scripts. Create Datamover script rcexp.dms to export Workflow Route Control data from Source Database; SET LOG C:\TEMP\RouteControl_exp.LOG; SET OUTPUT C:\TEMP\RouteControl.dat; EXPORT RTE_CNTL_TYPE; EXPORT RTE_CNTL_PROF; EXPORT RTE_CNTL_HDR; EXPORT RTE_CNTL_LN; Or For more exact Route Control migration, example; SET LOG C:\TEMP\RouteControl_exp.LOG; SET OUTPUT C:\TEMP\RouteControl.dat; EXPORT RTE_CNTL_TYPE WHERE RTE_CNTL_TYPE='Administrative Area'; EXPORT RTE_CNTL_PROF WHERE RTE_CNTL_PROF = 'Admin Area (All)'; EXPORT RTE_CNTL_HDR WHERE RTE_CNTL_TYPE='Administrative Area' AND RTE_CNTL_PROF = 'Admin Area (All)'; EXPORT RTE_CNTL_LN WHERE RTE_CNTL_TYPE='Administrative Area' AND RTE_CNTL_PROF = 'Admin Area (All)' AND RTE_FROM_VALUE='AM' AND RTE_TO_VALUE='TR'; Crea

View XML, Resubmit and Cancel links Grayed out on Service Operation Monitor

The user who is signed in and wanting to View XML, Edit XML, Download XML, Resubmit, or Cancel a service operation must have full access to that service operation. This can be set in either of two places. 1- Navigate to PeopleTools>Integration Broker>Integration Setup>Service Operation. Enter the service operation in question. On that component there is a Service Operation Security link. Click on that. Enter a role permission list that is associated with the userid that needs full access to service operation in the monitor. Set it to full access. Click Return and Save the Service Operation. OR 2- Navigate to PeopleTools>Security>Permission & Roles>Permission List. Enter the role permission list that is associated with the userid. Click on the Web Services Page and insert a row for the desired service operation. Click on Edit and assign full access. Click Ok and Save. If the links or push buttons are still grayed out, then sign out, delete browser cache by g