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

Last updated on MARCH 08, 2017

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

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