Ask Question
Help Others
Home › Blogs › Lepa's blog

Run an SQR From a PeopleSoft Application Engine

Thu, 12/13/2007 - 8:58pm — Lepa
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;

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
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.
Thu, 04/17/2008 - 4:29am
#1
mirhuma's picture
mirhuma
User offline. Last seen 10 years 35 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???

Top
Tue, 11/16/2010 - 5:22am
#2
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.

Top