E-SQR: SQR SPF Output File Corrupted When Program Uses BARCODE After Upgrade to PT 8.58 (Doc ID 2923624.1)

Last updated on FEBRUARY 09, 2024

Applies to:

Symptoms

After upgrade from PeopleTools 8.53 to PeopleTools 8.58.18, SQR is no longer working to print SPF output using the specific "-PRINTER:WP" flag with barcodes. This was working in the prior 8.53 release. If the barcode commands are commented out, the program prints the SPF output successfully. However, PDF and other output formats, like postscript LIS output, generate successfully producing barcodes. This issue is specific to SPF output format only, and only an issue for programs that are producing barcodes in the output. When not using the "-PRINTER:WP" flag the SPF output is generated, but when opened is corrupted.

 
The issue can be reproduced with the following steps:
1. Copy "barcode.sqr" sample SQR from '<PS_HOME>\bin\sqr\<DBMS>\SAMPLEW' to
the '<PS_HOME>\sqr' directory.
2. Edit "barcode.sqr" to add path to where it resides as follows and save...
Change line: "Open 'barcode.sqr' As 1 For-Reading Record=200"
to: "Open '<PS_HOME>\sqr\barcode.sqr' As 1 For-Reading Record=200"
3. Create SQR Report process definition called 'BARCODE' and associate it to
the 'PRCSMULTI' component with 'TLSALL' process group, and save the
definition.
4. Navigate 'PeopleTools > Process Scheduler > System Process Requests' and
create a new run control.
5. Submit new BARCODE SQR report to WEB/SPF output.
6. Open resulting SPF output file in SQR Viewer and observe SPF file
corrupted

 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.