Difference Between SQR and SQC in PeopleSoft
0
SQR is Structured Query Report and SQC is Structured Query Compiler
Author Archives: Nayan
Generate Multiple Report with Unique Name in PeopleSoft SQR
From last couple of days i was working on SQR Master Details report and also contains requirements to create a more than one report simultaneously based on the common data.After searching on Peoplebook as well Hyperion SQR Manual i found … Continue Reading
How to Get Process Name by Process Instance Using PeopleSoft SQR
When i was working on reportlog.sqc Projects then i have found really interesting tips that is Getting Process Name by process instance. So lets tell the procedure.We all know the all process related information PeopleSoft Stored on PSPRCSRQST table. You … Continue Reading
(SQR 2002) DO arguments do not match procedure’s – How to Correct
When Run the PeopleSoft SQR Programme via Command Line (SQRW Utility) or PIA Process Scheduler you may face the error like that, Error on line 88: (SQR 2002) DO arguments do not match procedure’s. It is SQR Procedure Argument Mismatch … Continue Reading
PeopleSoft Meta Data SQL Query Collection
Here is Collection of PeopleSoft Meta Data SQL Query Getting Most Effective Dated Row in JOB Table with Active Employees With Correlated Subquery SELECT J.EMPLID, J.EMPL_RCD, J.EFFDT, J.EFFSEQ FROM PS_JOB J WHERE J.HR_STATUS = ‘A’ AND ( J.EFFDT = ( … Continue Reading