Search This Blog

krishnamraju

SQL query to get all the child records for a parent record:

Get link
Facebook
X
Pinterest
Email
Other Apps

- October 16, 2017

SELECT RECNAME FROM PSRECDEFN
CONNECT BY PRIOR RECNAME=PARENTRECNAME
START WITH PARENTRECNAME = 'PS_JOB';

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

BI Publisher : Sum Function in xml publisher rtf template

- December 21, 2018

We can use the below syntax to get the sum of the particular filed in rtf template: <?sum(name_off_field)?>

BI Publisher:Inserting the current date and current time in BI Publisher Report

- December 14, 2018

Using below 1 and 2 we can display the current date and time on the bi report. 1) <?xdoxslt:current_date($_XDOLOCALE, $_XDOTIMEZONE)?> 2) <?xdoxslt:current_time($_XDOLOCALE, $_XDOTIMEZONE)?> 3) <?xdoxslt:sysdate(‘DD-MON-YYYY HH24:MI’)?>

Dynamic Views In Peoplesoft

- December 31, 2014

Understanding Dynamic Prompts in PeopleSoft Every so often during the interviews, we encounter this question a lot and without a proper understanding we end up improvising the explanation. The question is - What do you know about dynamic prompts and how we can create them? Well, let’s get to the point and try understanding the concept with examples. Prompts enable user to select a value from the list of predefined control values for a field in a page during transactions. For Example, when we create a new department, to select the company we click on the prompt for company field and select one of the listed values. In this case, the list of companies displayed in the prompt is static and is directly pulled from the record COMPANY_TBL. Below is the record field properties of COMPANY field in the record DEPT_TBL, In this case, there is no control over what are all the values will be prompted to the user, whatever is available in t...