My Oracle Support Banner

EMM: Unable to Print Work Orders Using the Maintenance Management > Work Order Management > Print Work Order (Work Order Task Detail Report Options) Page due to Error "A SQL error occurred. Please consult your system log for details." (Doc ID 2483420.1)

Last updated on DECEMBER 01, 2023

Applies to:

PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Unable to print work orders using MM Work Order Management > Print Work Order page. The following SQL error is generated when attempting to save a Run Control on Work Order Task Detail Report Options page: "A SQL error occurred. Please consult your system log for details."


This issue can be verified by performing the following steps:

1) Navigate to Maintenance Management > Work Order Management > Print Work Order.
2) Select Options as shown in attached replication steps.
3) Save.
4) The following SQL error is displayed as a popup:

"A SQL error occurred. Please consult your system log for details."


Detailed DEMO Replication Steps Attached.

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.