Blank Excel Trying to Generate FSG Statement In Report Manager After JAN 2016 CPU Patch (Doc ID 2115436.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Report Manager - Version 11.5.10.2 to 12.2.5 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Core Functionality

Cannot generate Income Statement out of Report Manager

Trying to generate January Income statements using an FSG through Report Manager, and when selecting to generate Excel output, get a blank screen. Excel is never started up.

This worked prior to installing the JAN 2016 CPU patches. Tried applying patch 19559960 and added the function FRM_REP_MANAGE_WORKBENCH to our GL responsibility. Seeing the following error in the bne.log:

ERROR
-----------------------

2/15/16 8:58 AM AJPRequestHandler-HTTPThreadGroup-24 WARNING BneOracleWebAppsContext.getTimeZone CLIENT_TIMEZONE_ID has not been set
2/15/16 8:58 AM AJPRequestHandler-HTTPThreadGroup-24 WARNING BneSitePropertyManager.setValuesFromBneProperties - loading values from properties file
2/15/16 8:58 AM AJPRequestHandler-HTTPThreadGroup-24 WARNING BneSitePropertyManager.setValuesFromBneProperties - end
2/15/16 8:58 AM AJPRequestHandler-HTTPThreadGroup-24 ERROR BneBajaServlet:doRequest() - Throwable: java.lang.NoSuchMethodError: oracle.apps.frm.xdo.bne.utilities.FrmUtilsModule.correctSheetName(Ljava/lang/String;)Ljava/lang/String;
2/15/16 8:58 AM AJPRequestHandler-HTTPThreadGroup-24 ERROR BneBajaServlet:doRequest() - Throwable: java.lang.NoSuchMethodError: oracle.apps.frm.xdo.bne.utilities.FrmUtilsModule.correctSheetName(Ljava/lang/String;)Ljava/lang/String;
at oracle.apps.frm.xdo.bne.utilities.FrmSheet1VBA.createLoadSheet(FrmSheet1VBA.java:617)
at oracle.apps.frm.xdo.bne.utilities.FrmSheet1VBA.appendRequiredVBACode(FrmSheet1VBA.java:128)
at oracle.apps.frm.xdo.bne.utilities.FrmSheetVBA.generateSheetVBA(FrmSheetVBA.java:66)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
This worked prior to installing the JAN 2016 CPU patches.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
We cannot publish our financial statements.

Changes

Applied JAN 2016 CPU Patch 22133441 (R12.1.3)

Applied JAN 2016 CPU Patch 22133429 (R11.5.10.2)

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