My Oracle Support Banner

"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 JANUARY 21, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.