You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Create Paychecks/Advice in PDF Form

6 replies [Last post]
bsky1210's picture
User offline. Last seen 9 years 46 weeks ago. Offline
Joined: 12/05/2010
Posts: 1

Hi All,

We are running on Oracle 10g with HCM 9.0 and PeopleTools 8.49. I have a prod request to modify Self Service Advice PDF form to add additional data to the PeopleSoft delivered Self Service Advice PDF form. I have done the following steps but I still couldn't get data populated to the Self Servcie Advice form correctly :
1. Modified delivered template PYUSADVB.rtf to add additional data elements.
2. Modified DDP003.sqr to write additional data elements in XML format with data.
3. Uploaded updated template PYUSADVB.rtf to Report Name SSPUSADV with a new effective.
4. Run Create Advice PDF Forms -- PS Job PYDDAUSA

The DDP003.sqr has extracted addtional data correctly but when I view the SS Advice PDF form , the new fields are showed in the Self Servcie Advice form with incorrrect data. Here is the navigation: Payroll for NA > Payroll Processing > Produce Payroll > Review Self Service Paycheck

I just wonder if I miss any steps. If so, please let me know steps by steps so that I can incorporate new steps in my project.

Thank you.

noahjamison's picture
User offline. Last seen 9 years 45 weeks ago. Offline
Joined: 12/14/2010
Posts: 1
Re: Create Paychecks/Advice in PDF Form

As far as I can see you have everything pretty dialed. I use a similar program and it work great for me.

HarlandGomez's picture
User offline. Last seen 9 years 42 weeks ago. Offline
Joined: 12/09/2010
Posts: 1
Re: Create Paychecks/Advice in PDF Form

I haven't done that particular program but I'm pretty sure that the one you have outline are mostly on it. I encounter that kind of program but i seldom hands on.

Guest's picture
Guest (not verified)
Re: Create Paychecks/Advice in PDF Form

I am trying to implement this PDF Paycheck funtionality in our OS390 environment but getting issues in terms of dynamic XML files creation, pay003 runs fine in PSNT server but we need to schedule this in OS390 & the same is throwing error

(SQR 2905) CANNOT OPEN FILE 'DD:PAY003US' AS 10.
(0): EDC5037I THE SPECIFIED DDNAME WAS NOT FOUND.
0SQR FOR PEOPLESOFT: PROGRAM ABORTING.

Any advice ??

learnps's picture
User offline. Last seen 9 years 44 weeks ago. Offline
Joined: 04/09/2009
Posts: 3
Re: Create Paychecks/Advice in PDF Form

make sure you modify this two SQR's also:
pysspxml.sqc
pyxmltag.sqc

HTH

Guest's picture
Guest (not verified)
Re: Create Paychecks/Advice in PDF Form

Hi HTH

Do you have an idea as to how to handle dynamic XML file creation part of pay003.sqr in OS390 server ???

Thanks
Vivek

Guest's picture
Guest
Re: Create Paychecks/Advice in PDF Form

HI Vivek,

Did you get any solution for your problem ?? Even we have same issue.

Problem: Do you have an idea as to how to handle dynamic XML file creation part of pay003.sqr in OS390 server ???

Thanks
Bhaskar Deverasetty