Avoid renaming columns in VC listings
-
Recommendation: In a VC listing, do not rename the columns. Instead, use the default Oracle name of the underlying data model column for the column names.
-
Rationale: Renaming columns in a VC listing can lead to validation check performance issues, and the inability to modify the validation checks.
-
Additional information: You might need to rename columns if:
-
Column names are not unique.
-
You need to handle self-referencing queries.
In these cases, renaming is allowed.
-
Parent topic: Validation checks