My Oracle Support Banner

oracle.jbo.SQLStmtException: JBO-27122 Error While Trying To "Export" In Service Request Reports (Doc ID 1417283.1)

Last updated on FEBRUARY 28, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, Charges UI, APIs, and schema

When attempting to click 'Export' button which  is enabled by run report in Service Request Gererate Report the following error occurs.

Error

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122


Steps to Reproduce

The issue can be reproduced at will with the following steps:
1. Query any Service Request in Oracle TeleService,
2. Select action 'Generate' report.
3. Click on 'Run' to generate the report. 'Export' button is enabled by run.
4. Click on 'Export' to get data in xls format.

It errors with oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122

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.