Unable to Access EditCategoryHierarchy/Hierarchy Preview Sheet Run-time error '438' (Doc ID 2185934.1)

Last updated on MARCH 10, 2017

Applies to:

Oracle Fusion Self Service Procurement Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Self Service Procurement - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

Unable to access EditCategoryHierarchy/Hierarchy Preview Sheet


Error:

Run-time error '438'
Object doesn't support this property or method
is displayed.
Debug errors in Sheets (3). TreeView1.Nodes.Clear


Steps:

The issue can be reproduced at will with the following steps:
1. Go to Manage Catalogs Catalog Hierarchy > Actions > Edit in Spreadsheet > Category Hierarchy
EditCategoryHierarchy.xlsm is displayed and it has 3 sheets:
  Instructions
  Category Hierarchy
  Hierarchy Preview
2. Select Category Hierarchy
Category Hierarchy information is displayed successfully
3. Select Hierarchy Preview
An error is returned:
Run-time error '438'
Object doesn't support this property or method



Changes

 

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