Interrupting the DIF Create Document prcess by clicking on Excel 2013/2016 window gives VBA Compile Error (Doc ID 2540339.1)

Last updated on DECEMBER 05, 2019

Applies to:

Symptoms

During Create Document in WebADI, after clicking on Create Document button, the VBA code will be executed.During this creation process, when try to click or double-click on the Excel window to activate it, the following VBA compile error will be shown.

Note: Excel2010 does not allow to activate the workbooks, so this issue only occurs with Excel 2013 and Excel 2016.

ERROR
-----------------------
Microsoft Visual Basic for Applications

　Compile Error:
User-defined type not defined

In the VB code screen, it stopped at below line: 
Dim BNEERROR As New BNEERROR


STEPS
-----------------------
1. Set following profile values to No for the testing user.
BNE: Enable OOXML Standard        No
BNE: Enable Digital Signature        No

2. Login to EBS with the testing user and select Desktop Integration responsibility.

3. Select the Create Document menu.

4. Choose any integrator that downloads data,, set Viewer to either Excel 2013/2016 and click Create Document button.

5. During creation process, VBA will create a new workbook. Try to click on the new workbook to activate it.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.