Run an SQR From a PeopleSoft Application Engine

Your rating: None Average: 5 (2 votes)

Here is a good sample of how to launch an SQR from within PeopleCode. You can use the peoplecode function called “ScheduleProcess”. Here is the example:

&PROCESS_NAME = "SQRNAME";
&PROCESS_TYPE = "SQR Report"; (or "SQR Process")
&RUN_CNTL_ID = "YOUR_RUN_ID";
&RUN_CONTROL = ScheduleProcess(&PROCESS_TYPE, &PROCESS_NAME, "2", &RUN_CNTL_ID, &PRCS_INST);

If &RC != 0 /*"1" = client "2" = server*/
Winmessage("Error: Error Scheduling SQR Process, RC = " | &RUN_CONTROL);
End-If;

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.
mirhuma's picture
User offline. Last seen 10 years 26 weeks ago. Offline
Joined: 04/09/2008
Posts: 2
PENSION ADJUSTEMENT

Kindly help me with this,we are facing this acute problem where the client wants to print the Pension Adjustement .This value is based on some calculations in the TAX104CN sqr.Can anybody please suggest how do i calculate it or share your experience in case somebody ahs come across PA???

Guest's picture
Guest (not verified)
Re: PENSION ADJUSTEMENT

Hi..
You can store fatched value in variable and after that you can write expression for your pension adjustement.