Delivered Queries Used In Delivered Pivot Grids Fail In MS SQL Server (Doc ID 2276411.1)

Last updated on JUNE 13, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Delivered Queries used in Delivered Pivot Grids fail in MS SQL Server

The queries that give this error and are configured in Supplier 360 are:
PO_SPEND_TOPCAT_PVG
PO_SPND_NOCNTRCT_TOPCAT_PVG
PO_SPND_NOCNTRCT_TOPITM_PVG

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms