Featured

Using Terraform Cloud for Azure

https://github.com/oraclecloud/tfazurelab

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 →