"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 AUGUST 20, 2016

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

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

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