My Oracle Support Banner

Publishing Fsg Reports Errors With JBO-27122 (Doc ID 973215.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Report Manager - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

In 12.0.6 in development, publishing an FSG in report manager takes a long time, and then fails with the following error:

ERROR:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT 1 DOCUMENT_ID, 'ALL' EXP_VALUE, 'ALL' TIMEFRAME, 'ALL' EXPANDED_VALUE FROM DUAL UNION ALL SELECT DISTINCT D.DOCUMENT_ID, substr(D.EXPANDED_VALUE, instr(D.EXPANDED_VALUE,':')+1,length(D.EXPANDED_VALUE)) EXP_VALUE, D.TIMEFRAME, D.EXPANDED_VALUE FROM FRM_DOCUMENT_DETAILS D WHERE D.DOCUMENT_ID=:1 AND D.TIMEFRAME=:2 at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
.
..
.
Detail:
java.sql.SQLException: Missing IN or OUT parameter at index:: 1

EXPECTED BEHAVIOUR
-------------
The FSG should complete normally

STEPS TO REPRODUCE
-----------
Submit FSG from Report Manager
When it completes, publish it to Excel
After waiting for a long time, the error is generated.

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.