I wasn't sure if this question should be posted here or in the "Geodatabase Questions" section but the issue isn't really (imo) a database issue, but with how ArcGIS Pro displays the view.
So the problem is that the view(s) in question have duplicate OBJECTIDs, which is intended. I am getting the attribute tables of these views to load by generating a column of UIDs by using:
cast(rownum as number(38)) as MYUID
This is done in the first column in my views, which each looking something like:
create or replace view MYVIEW(MYUID, COL1, COL2,...)
as
select(cast(rownum as number(38)) as MYUID, VAR1, VAR2,...)
...;
The UIDs are always the first column, and I've tried using various alias for the UID column (such as OBJECTID, ROWNUMID, etc.), but it's a hit or miss whether or not ArcGIS Pro will auto-select it for use as the "default" UID field. If it does, the attribute table loads, if it doesn't, it fails to load and then I need to go in and manually set the UID field to it. This is fine, but creates extra work every time the view is loaded into a new project.
Is there a way to somehow get ArcGIS Pro to auto-select that first column as UID every time so whenever someone creates a new project using that view they won't get the error and then have to manually go set UID?
