10.8.1 and Oracle version

[KetanDoshi]

Support is telling me ArcMap 10.8.1 is not supported on oracle version above 19.3.

Oracle database requirements for ArcGIS 10.8.x and ArcGIS Pro 2.5, 2.6, and 2.7—System Requirements ...

We are on oracle 19.9 and have issues with Triggers on Parcel Fabric.

We don't have any issues with non parcel fabric triggers or editing fabric.

Has anyone faced any issues with ArcMap 10.8.1, parcel fabric  and oracle version above 19.3 ?

Thanks

[RobertBorchert]

Have you installed

Oracle 11203 64 bit client

[KetanDoshi]

I think for ArcMap we need 32 bit client and that is installed.

[RobertBorchert]

From the requirements link you posted in the original post it says 64 bit

[KetanDoshi]

I don't think client is an issue as everything except and issue with  fabric trigger on our delta table which started raising error after migrating to oracle 19c, is working fine.

Editors are able to edit fabric, reconcile/post and we are also able to create new versions as usual in our automated fashion every night and edits are pushed to base table.

Everything worked fine in our Oracle 12c environment and everything remains the same its only we migrated our oracle database to 19c

Trigger Error is related to SRID - Invalid SRID in the SDO_Geometry object

I would like to know if anyone had any issues on fabric after migrating to oracle 19c

[KetanDoshi · Accepted solution]

It turns out to be an Oracle issue.

SDO_GEOM.SDO_AREA function raised an exception on Fabric feature classes.

Same function worked fine on Non-Fabric feature classes.

All cumulative patches were applied to our 19.9 version as suggested by Oracle documentation during installation, on the top of that Oracle gave us a merge patch (snap shot attached) to be applied on 19.9 and everything is back to normal.