Thank-you for your response.
Our point geometry is already populated in the ORDINATES array because we use orientation.
1 - Do we need to convert the GEOMETRY to the SDO_POINT columns?
If so, does ESRI have a tool that will do this for us? Or should we use Oracle to move the coordinates?
2 - Is it possible to populate the SDE metadata to recognize my table as a point feature store as a oriented point feature (ORDINATES array)?