Posts

Showing posts from July, 2015

Exporting Record data using File Layout Object & Application Engine (Sample Outbound AE Program)

(Sample Outbound AE Program) 1) Create File Layout based on the Record being exported 2) Selecting the desired format; XML, Fixed or CSV. 3)  Create Application Engine Program with one PeopleCode step   4) Single Record import PeopleCode.   Replace FileLayout , Record., GetRow with Desired FLO and Record rem ***************************************************************** rem * Method:               WriteRowSet - CSV File                                  * rem * Description:       Single Record                                                    * rem ***************************************************************** Local File &FILE1; Local Record &REC1; Local SQL &SQL1; Local Rowset &RS1; &FILE1 = GetFile("C:\temp\simple.csv", "w", "a", %FilePath_Absolute); &FILE1.SetFileLayout(FileLayout.CURRENCY_FL); &REC1 = CreateRecord(Record.CURRENCY_CD_TBL); &RS1 = CreateRowset(Record.CURRENCY_CD_TBL); &a

Web Services Security be Used For a Synchronous Service Operation From PeopleSoft to 3rd Party

Image
To send a synchronous service operation from PeopleSoft to 3rd party using Web Services (WS) Security with encryption and a digital signature. Username Token can be a userid with/without password. Userid can be external userid, which is defined on the Node Definition. It can be plain / clear-text meaning without being digitally signed and/or encrypted.   In PT 8.48-8.49, Web Services (WS) Security works with   request   service operations only. Types of service operation                       WS Security              Asynchronous one-way inbound Request Asynchronous one-way outbound Request Synchronous outbound Request only. The response returned cannot have WSS applied Synchronous Inbound Request only. The response sent cannot have WSS applied Asynchronous- request/response WSS is not applied at all. WSS can not be applied to response

You are not authorized to update the definition XYZ (12,1)

This error is due to Definition Security not being defined correctly. To resolve this error you will need to do the following steps: 1) Find the primary permission list of the user having the error by running the following SQL in your SQL tool. select OPRCLASS from PSOPRDEFN WHERE OPRID = 'whatever user is having the issue' 2) Log into AppDesigner.  Navigate to "Go -> Definition Security".  In "Definition Security" window, navigate to "File -> Open -> Permission List".  Click on the OPRID's primary permission list that we found from above SQL.  Highlight the "All Definitions" on right columns and click on "left arrow".  Navigate to "File -> Save". 3) Clear client cache and try to run the DataMover script again.

How to migrate nVision scopes from one environment to another?

nVision scopes are stored in the table PS_NVS_SCOPE in database. Please copy the PS_NVS_SCOPE table records from the old enviroment to the new environment. Application Designer or Data Mover are the best methods to copy records from one environment to another.

Bootstrap vs User Mode

If you use the access ID that you specified during the database configuration to log on, you log on to Data Mover in “bootstrap mode.” When you start Data Mover in bootstrap mode, the word “BootStrap” appears in the Data Mover status bar. If you use a valid PeopleSoft Operator ID, such as PS for Human Capital Management or VP1 for Financials/Supply Chain Management, you log on in “user mode.” In this mode, no designation appears in the Data Mover status bar.

Could not Create Shared Cache Error

When attempting to access Data Mover to run a script, an error was generated: Could not Create Shared Cache A cache directory, C:\PS\CACHE\ by default, is needed and should have Write Permission for PeopleTools. Action:  Create the cache directory and grant Write Permission for the user that runs Data Mover.

Datamover Script: Export and Import PeopleSoft Data

Image
There are quite a few techniques available in PeopleSoft to export and import the table from the database, one of which is Datamover. Data Mover Export set log C:\EXPORT.log;                                                  — Place where log file is maintained set output C:\JOBtabledmp.dat;                             — This is the place where the exported data is stored. export JOB;                                                —  Table that needs to be exported. Data Mover Import set log C:\IMPORT.log;                                              — Place where log file is maintained set input C:\JOBtabledmp.dat;                             — This is the place where the exported data is retrieved. import JOB;                                             —  Table that needs to be imported from the .dat file. Note: PeopleSoft DataMover stores the exported file in as encrypted binary file and it cannot be reused in any other way, you can only use Dat amover to export

Peoplesoft Application Engine: Application Library

Image
 Most Application Engine programs are defined to be executable. An executable program has a main entry point in its definition: the Section MAIN. This defines the entry point so whatever method we choose to invoke the program, such as command line or Process Scheduler, can initiate the program. However, in some cases, we may want a program to only contain a collection, or "library," of common routines (in the form of "callable" Sections) that we do not want to run as a standalone program. When sections are defined as "Public," other programs can call the Sections, or routines, that exist in the "library" at runtime. Because this type of Program is not designed to run as a stand-alone program, it does not require the MAIN Section, or initial entry point. Setting the Application Library option renames or removes any existing MAIN Section. Note: Application Libraries are the appropriate spot to store a collection of shared Application Engine pro

Best For Career- Peoplesoft/Workdays or any other ERP

Image
I know lot of articles, discussion around Pros and Cons of Cloud and Legacy - features, functionalities, upgrade cost, UI, etc - Nevertheless, this all from the vendors perspective for the clients who would be using these applications. As per my understanding for all business, Scenarios cannot be same, every business is unique, and so would be the solution. There would be not any ideal solution, it all depends on what's the business of the client and lot other things to be considered for selecting the right application. As a Technical Consultant it will be always confusing to choose the right product for the right Carrier. Even I used ask myself these questions and other people also, I do have these much years of experience in Peoplesoft, is it good to move to Workday or Sucessfactors?  Learning is good; it's an never ending/on- going process, but one cannot learn each and everything. Try to understand basic functionalities of the Business Process which is going to be same

Can Microsoft Office Communicator be Enabled for Chat in Peoplesoft?

Image
No.  Microsoft Office Communicator with Multichannel Framework up to current PeopleTools, ie. PT8.53 is not supported. In PT8.51, in MCF you can enable instant messaging for : GTALK SAMETIME XMPP YAHOO In PT8.52, PT8.53 and PT8.54, you can enable instant messaging for : GTALK SAMETIME XMPP YAHOO MSN