Oracle PeopleSoft Notes

ADS aka Application Data Sets What is ADS?      As the name clearly indicates, ADS is the collection of technology used to migrate application or configuration data between PeopleSoft Applications. Which has three main areas that you needs to understand before actually using it. ADS Definitions - The data set itself that defines the shape of the data that you are planning to export and import between applications. ADS Projects - An IDE project created using ADS definitions with/without criteria for filtering that contains the data Data Migration Workbench - DMW in short, it's an IDE itself to help consultants and business to create, compare and copy projects (export and import)      This gives business users a flexibility to define their data which needs to be managed (or moved) either during upgrades or implementation. Since the IDE is v...

Introduction From my first day in IT (as a learner on PeopleSoft) in 2009 to the present day, I have looked for an opportunity to learn or achieve something new every day. It might be a simple concept, a feature, an application functionality or the task that was assigned. Over time, while working for multiple clients and on various business cases, one thing became clear: every requirement or business case needs something that was already developed or available. It would be harder to find someone who doesn't agree with this fact. I'll explain it with a simple example: let's say you need to build a setup page (this can be anything), which will definitely need audit information like who created it, who updated it, and when it actually happened, etc. Some of us might have cared less about those areas as they may not be the core of the business case you are working on or a required feature, but I would say it is still a part of the development cycle. Brief These reusable log...

Unlock Your PeopleSoft Magic: Creating Objects with Pure PeopleCode! ✨   Hey there, future PeopleSoft experts! 🚀 Have you ever been in Application Designer and thought, "What if I could create a Query or build a Tree dynamically, right from within the application itself?" 🤔 It sounds almost magical, right? You might be wondering if it's even possible. Well, I'm here to tell you that you absolutely can! 😊 The secret lies in the powerful, and sometimes overlooked, PeopleCode API Classes. (You can find them in your system: PeopleTools > Development Tools > PeopleCode API Reference ). Let's break down why this is a game-changer for you as a developer. Why Bother with API Classes? The Power of Controlled Creation  Imagine this scenario: You want to give your users the ability to create certain definitions—like specific queries or tree nodes—but you need to keep firm control over how and what they create. 🛡️ For e...

HCM Text Catalog We all have definitely used Message Catalog and Strings Table for storing setup information and text definitions for notifications, master data. But, do you know there is a better alternative which not only supports in these scenarios but much more like Translation, Key based Setup, in-built HTML support and Test Utility to inquire the Catalog itself. With simple views and existing tables, we can able to create very sophisticated setup to maintain your data and which can be quickly filtered and used with delivered Application Package methods. To configure and use Text Catalog you would have to go through following steps (note, some are optional) Navigation: Set Up HCM > Common Definitions > Text Catalog and Notepad Configure the Text Catalog Maintain the Text Catalog View/Edit the text in HTML Setup Text Substitution Use View All Keys Page (to Review) Setup Translation fo...

     Before we deep dive in to PeopleSoft delivered Web-Services, let's talk about the basics of PeopleSoft Web Service. What is it.? " It provides a way other (3rd party) applications communicate with PeopleSoft Application, using Integration Broker ".      Why Web-Service and why not other methods of integrations? like file-based if you ask, then my response would be simple. It is built on-top of existing PeopleTools Technology and provides controls for the owner system (PeopleSoft) to have necessary security (Authentication and Authorization) for data communication and standards (like SOAP and RESTful APIs) to support almost all the integrating applications. In the recent Tools version you can even create Open API consumer services.      Now, since the basics are clear, lets focus on web services that are provided by Oracle PeopleSoft out-of-the-box in the application. These services are common for any application you own, be it a HCM...

As the name suggests the composite query can simply combine the existing queries and can add filters, aggregates, sorts the data for presenting. All you just have to do is,  Create PS Queries Combine two or more of them Join them based on relationship Apply additional filters/prompts needed Provide Group By or Order By clauses View and schedule to get the results You might ask why would we create composite query when we already have so many PS Queries and Connected Queries which we can use to get the data we want, right?. To you the answer would be you can RE-USE the existing queries and add controls on top of it. Consider an example of having separate queries for fetching Employee Details, Salary Information and Login Details, to fetch the high paid employees login details you don't have to create a new query. Simple combine these three and create it as a composite query. Or you have Customer Information and Aging Report and wanted to get the summary report to give a follow-up cal...

     After a decade of time, I'm back to blogging, And it's time to give back the community that helped me grow in my career and skills with some of works.      As a first step, let me present my efforts on the vision to create a common upload utility I wanted since I started as a developer. Many customers have their own modules (bolt-on or customized) developed on their application and using delivered systems only when necessary.      And once in a while they load bulk data in those modules from 3rd party, or processed with offline tools (like Excel). With this base all those customers can benefit by simply having a CI - Component Interface for the same. The process is simple as follows, You create and perfect your CI based on the data you want to load Build your own upload templates with defaults, formats, etc.,  Complete the setup to create the File Layout (CSV or Fixed format) Which can provide you the sample file in FIXED as well as...