Oracle PeopleSoft Notes

 Feed Publishing Framework Introduction to the Feed      According to the latest ( Wiki ), a web feed (or news feed) is a data format used for providing users with frequently updated content. Content distributors syndicate a web feed, thereby allowing users to subscribe a channel to it by adding the feed resource address to a news aggregator client (also called a feed reader or a news reader).      This helps user to know changing content without needing to go some other site or do anything. PeopleSoft's Feed Publishing Framework It's one of the module in Oracle PeopleTools . This can provide,  Unified Interfaces for Content Owners - Create, Configure and maintain various types Interfaces for End-Users - Discover feed definitions and related feeds API's for Application Developers - Creating new types and integration with existing features Multi-Lang...

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

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

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

Like you I was also searching this solution, finally we have a compact function introduced in Oracle 11g Function   :    listagg() Syntax      :     For a specified measure,  LISTAGG   orders data within each group specified in the   ORDER   BY   clause and then concatenates the values of the measure column. As a single-set aggregate function,  LISTAGG  operates on all rows and returns a single output row. As a group-set aggregate, the function operates on and returns an output row for each group defined by the  GROUP   BY  clause. As an analytic function,  LISTAGG  partitions the query result set into groups based on one or more expression in the  query_partition_clause . The arguments to the function are subject to the following rules: The  measure_expr  can be any expression. Null values in the measure column are ignored. The  delimiter_expr ...