Using Journal wizard in Web ADI fails due to compilation error in Excel - User-defined type not defined

(Doc ID 1053358.1)

Last updated on MAY 01, 2018

Applies to:

Oracle General Ledger - Version 12.0.4 to 12.2 [Release 12.0 to 12.2]
Oracle Applications Desktop Integrator - Version 12 to 9.2.4.10.27 [Release 12 to 9]
Information in this document applies to any platform.

Symptoms

In 12.0.4 in production, when web ADI budget journal integrator is launched, Excel opens, but the following visual basic error is displayed

Compilation error: User-defined type is not defined

In the web ADI document, the following error is displayed:
Insufficient memory for this operation
Error: -2147024882


STEPS TO REPRODUCE
----------
Desktop Integration : Create Document : Journals integrator : budget single.

BUSINESS IMPACT
---------
Unable to use web ADI to create budget journals.

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