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 FEBRUARY 03, 2019

Applies to:

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


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

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

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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