My Oracle Support Banner

Service Request Log And Notes Print Friendly Format Page Exception Error JBO-27122 (Doc ID 1331696.1)

Last updated on MAY 19, 2020

Applies to:

Oracle Teleservice - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In the Service Request form Workbench Tab, after clicking on the 'Log and Notes' button for an existing SR, an error occurs when trying to use the Print Friendly Format functionality.
Similar errors occur with the option Tools > Print Request.

Error:

You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

The exception details shows the following exception:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: select ....
[...]


Steps:

(R) Customer Support
(N) Service Requests > Create Service Requests

   - Enter SR information
   - Click on the Log & Notes button
   - Create a entry
   - Save
   - Click on the Print Friendly Format button and the reported error occurs.

(R) Service
(N) Service Requests > Find/Create Service Requests

   - Query SR
   - Click on Tools > Print Request (or Tools2 > Print Request)

      Error Page
      Exception Details.
        oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
        Statement:
             select inc.incident_id IncidentId ,inc.incident_number IncidentNumber, inc.incident_type_id
             [...]       

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.