My Oracle Support Banner

Load to CAD Fails with Error: PLS-302: Component 'EXPAND_ROOT_DESIGN_MAIN' Must Be Declared (Doc ID 2718016.1)

Last updated on JULY 21, 2023

Applies to:

Oracle Agile PLM MCAD Connector - Version 3.6 and later
Information in this document applies to any platform.


Getting below error when attempting to perform Load to CAD:

ORA-06550: line 1, column 27:
PLS-00302: component 'EXPAND_ROOT_DESIGN_MAIN' must be declared
ORA-06550: line 1, column 7:PL/SQL: Statement ignored 6
ExceptionID 60086

The issue can be reproduced at will with the following steps:

  1. Log into Web Client as admin user
  2. Open Design object
  3. Do Actions > Load to CAD
  4. agilecad.xml file gets downloaded. Click the file.
  5. Agile Load Preview window shows up.
  6. "Structure Resolution Error" window pops up with the error message.


 Refreshed Agile database schema


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.