My Oracle Support Banner

An Error "A fatal PeopleCode SQL error occurred. Please consult your system log for details." Occurs When Searching for an Item on a Requisition Page in an MSS Environment (Doc ID 3016151.1)

Last updated on APRIL 11, 2024

Applies to:

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

Symptoms

An error occurs when searching for an item on a request page in an MSS environment.

The issue can be reproduced at will with the following steps:

Note : The SEQNO of Record PS_PV_MOB_REC_SRCH is 32767 

1. Navigate : eProcurement > Create Requisition
2. Search “printer”
Issue : Receive Error
A fatal PeopleCode SQL error occurred.  Please consult your system log for details.

SQL error in Exec.
PV_MOB_HDR_WRK.PV_SEARCH_PB.FieldChange Name:AddtoRecentlyOrdered PCPC:54463 Statement:743
Called from:PV_MOB_HDR_WRK.PV_SEARCH_PB.FieldChange Statement:1096
During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.

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.