My Oracle Support Banner

EMM: SQL Error Occurred In Technician Workbench Search Page (Doc ID 2447242.1)

Last updated on DECEMBER 13, 2019

Applies to:

PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, PI # 25.Work Order

We are getting Error when we are trying to search from " Technician Workbench"



ERROR
-----------------------
"A fatal PeopleCode SQL error occurred. Please consult your system log for details.

SQL Error in Compile. (2,277) WM_WORKBENCHES.TechWorkbench.Utilities.OnExecute Name:PopulateTechWB PCPC:575 Statement:6
Called from:WM_WORKBENCHES.Controllers.TechWorkbenchHandler.OnExecute Name:PopulateWBTable Statement:109

During the execution of SQL, an error occurred in the Compile phase of SQL execution. The preceding message should have identified the details of the SQL being executed."





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Maintenance Management --> Maintenance Management Center --> Workbenches --> Technician Workbench
Search.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot search in this page.

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.