"Run-time error '91': Object variable or With block variable not set" Error When Importing And Uploading Items In PIM Using Excel WebADI (Doc ID 1906892.1)

Last updated on NOVEMBER 04, 2023

Applies to:

Symptoms

When attempting to import and upload items in PIM,
the following error occurs.

ERROR
-----------------------
Run-time error '91':
Object variable or With block variable not set


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Using the functionality Batch Import > “Import from Excel”
1) Select Object > Item and click on continue
2) Select ICC and system default format for importing the data
3) Click on Import in above screen and choose Excel 2007
4) Download the Excel sheet on desktop
5) Enable Editing
System shows Run time Error

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.