Peoplesoft Sqr Functions
I'm creating a custom SQR Report using PT version 8.16. I'm trying to get
messages to show up in the message log in the Process Monitor after I have
Process Scheduler run my SQR. I'm using the following lines of code at the
end of my program:
Running SQR in PeopleSoft Applications We can run SQR programs from the SQR Dialog Box, or from the operating system Command Line. PeopleSoft-delivered reports are usually executed from an online page and run with the help of the PeopleSoft Process Scheduler. Jan 19, 2005 String Manipulation in SQR I have retrieved the column variable VOUCHERID from database and I need to check the voucher ids that start with an alphabet so that I can add the amounts of all the vouchers which start with a particular letter like.
let $prcs_run_status = #prcs_run_status_successful
let $prcs_message_parm1 = 'Ryans message'
do Update-Prcs-Run-Status
Where does the text in variable '$prcs_message_parm1' go? I just end up
with a blank line in my message log in process monitor when I do this. Any
ideas?
Also, are the functions and variables that PeopleSoft has created to do such
things documented anywhere? Or is the only way to figure out this stuff to
dig through all their fairly uncommented SQC files and figure out what to
do?
Thanks,
Ryan
I have to get a date that is 6 months from the system date in Oracle.
And I have to get it by running an open-query from SQL. DATEADD(MONTH,-6, GETDATE()) function serves the purpose in SQL.
Does the function DATEADD(MONTH,-6, GETDATE()) in SQL have an equivalent function in Oracle?
3 Answers
Method1:ADD_MONTHS
ADD_MONTHS(SYSDATE, -6)
Peoplesoft Sqr Case Statement
Method 2:Interval
SYSDATE - interval '6' month
Note: if you want to do the operations from start of the current month always, TRUNC(SYSDATE,'MONTH') would give that. And it expects a Date datatype as input.
Not my answer :
I wasn't too happy with the answers above and some additional searching yielded this :
Peoplesoft Sqr Functions Worksheet
which I found very helpful. From http://sqlbisam.blogspot.com/2014/01/add-date-interval-to-date-or-dateadd.html
