How to Increase the Length of the Design Number Attribute To Accommodate a CAD File Name (Doc ID 1452051.1)

Last updated on JULY 24, 2015

Applies to:

Oracle Agile PLM Framework - Version 9.3.0.0 and later
Information in this document applies to any platform.
Although the Agile PLM database schema allow to store up to 150 characters for the File Folder number, the Java Client user interface does not allow you to increase the number length beyond 50 characters.

Goal

When using Engineering Collaboration (EC) to manage CAD data in Agile PLM, one can map the CAD file name to the Design number instead of using an Autonumber scheme as configured out of the box. If the file names used in the CAD environment exceed 50 characters, then the Agile PLM database schema needs to be altered from the backend to increase the maximum system length of the Design number attribute (read only attribute), and the EC client configuration needs to be altered accordingly.

Solution

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