When using SDE.ST_TRANSFORM on multi polygons that has self interaction
ORA-20603: Spatial References are not compatible.
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 720
ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 2704
The problem is on 10.2.2 it works well on 10.4, any idea what to do on 10.2.2?
This may be a known issue with 10.2.2 that was corrected in a later release.
BUG-000086328: Performing a transformation on a feature class in an Oracle database using the ST_Transform is producing a transform error: ORA-20603: Spatial References are not compatible.
http://downloads.esri.com/support/downloads/other_/104-IssuesAddressedList.pdf - List of 10.4 fixes
http://support.esri.com/download/2266 - List of 10.2.1 UTUP4 fixes
I would reach out to technical support and have them investigate in more detail to verify that you are encountering the same issue.