Run-Time Error '5': Invalid Procedure Call Or Argument Received When Reopening/Using a Web ADI Integrator Template or Accessing LOVs (Doc ID 2951799.1)

Last updated on FEBRUARY 22, 2025

Applies to:

Symptoms

This error may be seen in various cases.

Case 1:When reopening Web ADI templates which were created with different profile settings, the following error is received and the templates will not open for update.
Case 2: This error can also be seen when attempting to access any List of Values (LOV) or upload functionality in saved OOXML WebADI documents. This is typically seen in non-english templates.
Case 3: Can be seen intermittently when creating OOXML Web Application Desktop Integrator (WebAdI) documents while another non WebAdi document is opened and attempting to select a field or save the template via WebAdi.

In each case this error is seen:

This is not module or template specific, it can occur with any Web ADI Integrator.

STEPS TO REPRODUCE - Case 1:

Using the Journal Wizard as an example:

User1:
1)Sign into Oracle General Ledger with a responsibility such as General Ledger Superuser which has Journal Wizard access and which has the profile set to Yes.
2)Use the menu path Journals -- Launch Journal Wizard.
3)Choose Layout.
4)Choose Create Document.
5)Enter data, and save the document.
6)Close the document.
7)Forward this template to user2 for further processing.

User2:
8)Sign into Oracle General Ledger with a responsibility such as General Ledger Superuser which has Journal Wizard access and which has the profile set to disabled.
9)Use the menu path Journals -- Launch Journal Wizard
10)Choose Layout
11)Choose Create Document
12)Enter data, and save the document.
13)Close the document.
14)Open the template forwarded by User1.
15)Open the template created by User2 and saved in step 12. - The error will then present.

STEPS TO REPRODUCE - Case 2:
 
1. Under WebADI responsibility > Create Document.
2. Select Integrator: General Ledger - Journals.
3. Enter data and upload.
4. Verify the Journal Import run successfully.
5. Save the file and close the document.
6. Reopen the Excel file which was closed as indicated in the above step and click "List of Values" or "Switch Responsibility" or "Upload".
7. See the error on the screen.
8. Even if click "OK" to close the error message window, it occurs again when clicking the "Upload" button again.

STEPS TO REPRODUCE - Case 3:
 
1. Login to WebAdi responsibility.
2. Download a new template.
3. Try to make changes to the template.

Changes

 Case 1: This is an effect of opening and closing templates when the profile BNE: OOXML Enabled is enabled for one template but not for another, and these are opened sequentially.

Cause

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