Report Manager 11i - R12 : After Applying JAN 2016 CPU Patch Excel Format Outputs Are Generated With Blank Or No Data

(Doc ID 2115436.1)

Last updated on OCTOBER 11, 2017

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 E-Business Suite 12.1.3 version, Core Functionality

Trying to generate Monthly Income statements fails and when selecting to generate Excel output, get a blank template. Also Excel macros never start up.

This worked prior to installing the JAN 2016 CPU patches. 

After applying patch 19559960 and adding the function FRM_REP_MANAGE_WORKBENCH to GL responsibility, observing 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 22133429 (R11.5.10.2) / Applied JAN 2016 CPU Patch 22133441 (R12.1.3)

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