Oracle PeopleSoft Notes

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

3 way Prompts In this way user can able to run the query either by giving value or giving prompt value or some part of the value. To do so we need to, Create the Expression Create a Prompt Add criteria with Expression and Prompt Change logical mapping Group the criteria Initial Query Create the Expression Create the Expression like below and in the Express Text give only <single quote> <space> <singlequote> Create a Prompt Create a Prompt for the Field where u need a Prompt while running the Query Please note that here the Prompt Table been mentioned with “No Table Edit” as Edit Type Add criteria with ...