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

Last updated on FEBRUARY 15, 2017

Applies to:

Oracle Teleservice - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Sep-2015***

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
             [...]       

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