My Oracle Support Banner

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.


In 12.0.6 in development, publishing an FSG in report manager takes a long time, and then fails with the following 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(
java.sql.SQLException: Missing IN or OUT parameter at index:: 1

The FSG should complete normally

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


To view full details, 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 a vibrant support community of peers and Oracle experts.