My Oracle Support Banner

Receiving PT_PACKAGE.PT_PGInformation.OnExecute Name:ExecuteChart Error on Classic Supplier 360 Page in DB2 (Doc ID 2539027.1)

Last updated on NOVEMBER 27, 2019

Applies to:

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

Symptoms

ISSUE
---------------
Customer is getting an error when trying to use pivotgrid PO_SPEND_TOPCAT_GN_PVG on the classic supplier 360 page. The error happens when using the Top 10 Category Spend metric
PT_PACKAGE.PT_PGInformation.OnExecute Name:ExecuteChart. Customer states that the reason this is happening is because the code that is being run has an invalid statement. If they try to run the Query PO_SPEND_TOPCAT_GN_PVG they get a different error


ERROR
---------------
Error received from Suppliers -> Suppliers 360: PT_PACKAGE.PT_PGInformation.OnExecute Name:ExecuteChart.

Error received from Reporting Tools > Query > Query Manager: A SQL error occurred. Please consult your system log for details.
Error in running query because of SQL error, Code 8601, Message = [IBM][CLI DRIVER]{DB2] SQL0112N The operand of the column function "" includes a column function, a scalar fullselect, or a subquery. SQLSTATE=42607 (SQLSTATE 42607) -112 (50,380)


STEPS
---------------
Either go to Suppliers -> Suppliers 360 and use the Top 10 Category Spend metric
-- OR --
Go to Reporting Tools > Query > Query Manager and pull up the query PO_SPEND_TOPCAT_GN_PVG, choose a date range and run the report

 

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
References


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