SQL Error Is Thrown On Review Disputes Page In Procurement Cards (Doc ID 1671708.1)

Last updated on JANUARY 20, 2016

Applies to:

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

Symptoms

Reveiw disputes page is throwing a sql error when chartfield status is set to "Recycled " and search button is pressed.

Steps to reproduce the issue:


1.Load data through Pcard stage and load process.
2.Drill down to Purchasing -- > Procurement Cards -- > Reconcile --> Review Disputes
3. Set the chartField Status to "Recycled"
4. Press Search button and it throws the error attached.

Error message:

Error in PeopleCode ScrollSelect processing. (2,213) CC_DISPUTE.GBL.PostBuild
Name:LoadDisputeData PCPC:2123 Statement:32
Called from:CC_DISPUTE.GBL.PostBuild Satement:34



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