Why DMW Has UI Restriction Of 20 Characters On Data Model Schema Name?
Last updated on MAY 29, 2018
Applies to:Oracle Health Sciences Data Management Workbench - Version 2.4.6 and later
Information in this document applies to any platform.
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.
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