The "Instead of" triggers created on Multi - version views for Updating, Inserting and Deleting records have an issue with the date field.
An update or insert command executed using the views throws the below error,
ORA-01835: day of week conflicts with Julian date
ORA-06512: at "ADMIN.V2356_UPDATE", line 1
ORA-04088: error during execution of trigger 'ADMIN.V2356_UPDATE'
ORA-02063: preceding 3 lines from ARCGIS
The date format used in these triggers doesn't comply with the format defined in the feature class.
The trigger uses the format: 9999/12/31 23:59:59 6:365','YYYY/MM/DD HH24:MI:SS D:DDD as against the format defined for the feature class 31/12/9999 23:59:59','DD/MM/YYYY HH24:MI:SS
Is this a know issue/bug? The only way I could fix this was by replacing the date format in all the triggers.
Database used: Oracle 11g
Geodatabase version: 10.2.1