myPeopleSoft

PeopleSoft Community Network

Paycheck Printing – Dynamic Signature Using Word 2007 Oracle BI Plugin - Posted by PeopleSoft.in

Pay003.sqr Modifications

Pay003.sqr creates an XML file which is processed by App engine to Fill up values in to Specific RTF template and Produce paychecks. Pay003.sqr should be customised to retrieve / set Signature URL as per business logic and should be assigned to a variable say SIGNATURE_URL.

Pay003.sqr should process this Variable as XML tag, Following Code will Process this as an XML Tag,

$signature_url = ‘c:\temp\signature.gif’

let $xmltag = ‘SIGNATURE_URL’

let $xmlcontent = $Signature_URL

do Process-SSP-XML-Tag-Content

Remember this code should be added Under Procedure Get-Paychecks so every Paycheck have an XML Tag,

<SIGNATURE_URL>c:\temp\signature.gif</SIGNATURE_URL>

Now Pay003.sqr is ready to send a URL of signature to Template. No Schema Modification is required for this XML tag in Peoplesoft 9.1 as schema is created runtime automatically.

RTF Template Modification: After Modification of Pay003 all you have to do is Update RTF template for Required Report Definitions.

Read further: http://nanduworld.blogspot.com/2013/11/paycheck-printing-dynamic-si...

0 members like this