Why DMW Has UI Restriction Of 20 Characters On Data Model Schema Name? (Doc ID 2281609.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.6 and later
Information in this document applies to any platform.

Goal

Why DMW UI has a restriction on Data Model Schema Name? Data Model BA Schema name is restricted to 20 characters in UI.


 Is there any specific reason for it, given that Oracle allows schema name up to 30 bytes/chars?

The _DEV, _QC or _PROD is suffixed depending on the life cycle. But even then the total length comes to 20+5 (for _PROD) = 25 chars.

What is the reason behind this restriction on DMW UI Data Model Schema Name?

Steps to reproduce
-------------------------

1. Create a DMW Data Model
2. Check Business Area option - to create an associated BA for this Data model
3. Try to enter a BA schema name longer than 20 chars and it will not be permitted.
 

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