My Oracle Support Banner

Preview button Errors: Error generating report output (235,3101)(235,2309) for a Delivered BI Publisher Report PO_DISPATCH (Doc ID 2644491.1)

Last updated on JULY 29, 2024

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Preview button feature is returning an error for a delivered BI Publisher Report - PO_DISPATCH
 
Steps to Reproduce the Issue:
1. Reporting Tools > BI Publisher > Report Definition
2. Search by = PO_DISPATCH
3. Template tab > Preview

Error:
Error generating report output: During calling method PTFOProcessor.generateOutput, The XDO engine throws an exception: java.lang.NullPointerException. (235,3101)(235,2309)
Error occurred during the process of generating the output file from template file, XML data file, and translation XLIFF file.

While opening subtemplates POHEADER or POLINE errors

File object associated with template defintiion is not found in the database, therefore the report and/or template definition is not valid.  Please check consistency of objects.
Error in PeopleCode ScrollSelect processing. (2,213) PSXPSUBTMPL_WRK.FUNCLIB.FieldFormula  Name:LoadSubTmplFileDefn  PCPC:763  Statement:10
Called from:PSXPSUBTMPL_WRK.FUNCLIB.FieldFormula  Name:LoadSubTmplDefn  Statement:40
Called from:PSXPSUBTMPL_WRK.FUNCLIB.FieldFormula  Name:SelectSubTmplDefn  Statement:128
Called from:PSXPSUBTMPLDEFN.GBL.PostBuild  Statement:32
A SQL error occurred during processing of the PeopleCode ScrollSelect (or ScrollSelectNew, RowScrollSelect, RowScrollSelectNew) built-in function.
This error may have been described by a preceding message.
Examine the error messages and the PeopleCode program containing the ScrollSelect call to determine the cause of the error.  

PO Dispatch Template errors

Error in PeopleCode ScrollSelect processing. (2,213) PSXPRPTDEFN_WRK.FUNCLIB.FieldFormula  Name:LoadSubTmplFileDefn  PCPC:43531  Statement:686
Called from:PSXPRPTDEFN_WRK.FUNCLIB.FieldFormula  Name:LoadSubTmplDefn  Statement:756
Called from:PSXPRPTDEFN_WRK.FUNCLIB.FieldFormula  Name:SelectSubTmplDefn  Statement:895
Called from:PSXPRPTDEFN.GBL.PostBuild  Statement:36
A SQL error occurred during processing of the PeopleCode ScrollSelect (or ScrollSelectNew, RowScrollSelect, RowScrollSelectNew) built-in function.
This error may have been described by a preceding message.
Examine the error messages and the PeopleCode program containing the ScrollSelect call to determine the cause of the error.  

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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