My Oracle Support Banner

SQL Error Occurred on Item Substitute Analytics Tile (Doc ID 2634233.1)

Last updated on FEBRUARY 03, 2020

Applies to:

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

Symptoms

Click on the 'Item Substitute Analytics' Tile in DEMO environment and the next error message appears:

Fluid HomePage > Procurement Operations > Item Substitute Analytics tile

Error message:


"SQL Error Occurred".
"A fatal PeopleCode SQL error occurred. Please consult your system log for details."
"Unexpected data type code: None.
SCM_REPORT_FL.Filter.Alerts.OnExecute Name:PopulateGridFL PCPC:1943 Statement:38
Called from:IN_SUBSTITUTION_FL.GBL.PreBuild Statement:2

The evaluator encountered an unexpected data type code."

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.