Posts

How to hide Menu while transferring from one page to another page (with in Peoplesoft)

There are various ways to achieve this. When I google for this I am able to see one javascript to be placed in target page. But most of the Technical Guru's won’t accept this solution since we need to add HTMLAREA in your delivered page. But below solution will work. Instead of Transfer please use below approach… &MyURL = GenerateComponentContentURL(%Portal, %Node, MenuName.menu, "GBL", Component.Component, Page.Page, "U",keys); ViewContentURL(&MyURL, True);

Cannot find project or library - Spreadsheet Journal Import not working on Excel 2007 with Windows 7 or Vista

After we open the Journal Import Spreadsheet in Windows 7 or Windows Vista, it does not let us click on any buttons to create journals, etc... We get, "Compile error, Cannot find project or library". The spreadsheet journal import, JRNL1.XLS, can be used so long as the Microsoft delivered XML library file msxml.dll exists on the environment. It does not exist with Windows 7 nor Windows Vista. Please copy the msxml.dll file from the Windows XP computer to the workstation with Windows 7 or Windows Vista. Place the file under the windows directory where it is referenced, as follows. --Open JRNL1.xls and then go to the VB Editor (Tools > Macro > VB Editor) or ((Developer > Visual Basic for Office 7) --With JRNLMCRO highlighted, click Tools > Reference There should be a reference to the Microsoft XML DLL library file (msxml.dll). Microsoft has several versions of this library (msxml2.dll / msxml3.dll / etc.) and they coexist on some computers. NOTE: • For Windows 7, t...

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...

How to Bulk Delete Messages from Message/Service Operation Monitor in Error Status

The following is how to delete messages in Error status by a delivered way. 1. Run messaging achieve process at PeopleTools>Integration Broker>Service Operation Monitor>Monitoring>Archive Monitor Data. This will archive all the service operations in Done or Cancel status. 2. Run appmsgpurgelive.dms to delete all the service operations in status other than "Done" or "Cancel" including Error. WORKAROUND: You can customize PSAPMSPURGELIVE.DMS. Set where clause in every delete statement at PSAPMSPURGELIVE.DMS. "where IBTRANSACTIONID in (Select IBTRANSACTIONID from PSAPMSGPUBHDR where PUBSTATUS=0 AND PUBLISHTIMESTAMP " " Now you can run the appmsgarch process. =============================================================================== In PT8.48 or above, You can actual use the filter in the service operation monitor to identify service operations in ERROR status. You need to go to the operation instance, publication contract and subcontrac...

Interation Broker:The 'IsChanged=Y' flag is always present in the XML's , what are they ? and what do they signify ?

When sending and receiving messages, all blank data values get stripped. As a result, you cannot determine if a field value is blank by definition, or if its value was stripped in the messaging process. The PeopleCode functions - CopyRowset, CopyRowsetDelta and CopyRowsetDeltaOriginal, feature an IsChanged attribute that automatically gets set to identify fields that have been changed. Any field that has been changed displays the attribute IsChanged="Y". Note. The IsChanged attribute applies only to rowset-based messages. It does not apply to nonrowset-based messages, including container messages, or part messages. If you are writing subscription PeopleCode you reference the IsChanged value of the field in the message rowset, as always. However, the blanks appear with the attribute IsChanged="Y".