12.2 E-Business Suite Web Applications Desktop Integrator Fails to Open Excel When Creating a WebADI Transaction Import Document and Downloading To The User Desktop (Doc ID 2165810.1)

Last updated on MAY 22, 2024

Applies to:

Symptoms

E-Business Suite 12.2 Web Applications Desktop Integrator, WebADI issues

User receive an error while downloading and creating a WebADI document.

After the document is downloaded and created, the document and Excel closes without error.

The issue can be reproduced via the steps provided below:

1. Menu
Responsibility: Accounting
Navigation: > Oracle Web-ADI
> Create Document

2. Select Integrator Logged in As User
Integrator: Projects - Transaction Import

3. Select Viewer
Viewer: Excel
[ ] Reporting

4. Select Layout
Layout: Transaction Import

5. Document Creation Review
Integrator: Projects - Transaction Import
Viewer: Excel 2007
Reporting: No
Layout: Transaction Import
Content: None
[Create Document]

6. Information
A file will be downloaded to your desktop.

When prompted, choose to open the file and to enable macros. If no prompt appears, ensure your browser security settings allow files to be downloaded.

Do you want to open or save WebADI.xls (372 KB) from oracle-ebs-test.domain? [Open]

7. Excel Web-ADI (1) [Read Only] [Compatibility Model] - Microsoft Excel

! Security Warning Macros have been disabled. [Enable Content]

8. Excel Layout for "Transaction Import" spreadsheet opens

9. After Clicking on Close, the WebADI Excel file gets closed.

Changes

WebADI patches were recently installed.

Cause

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