Hi,
I've created Geoserver Layers using Oracle Geometry Views. The geometry column in the table has been indexed and inserted an entry into USER_SDO_GEOM_METADATA for 27700 SRID reference. while saving the geometry 27700 is added into the geometry details. see the matching coordinates on the screenshot below.

But when I open geoserver layers I'm getting the error says "window SRID does not match layer SRID".

<?xml version="1.0" ?>
<ServiceExceptionReport
version="1.2.0"
xmlns="http://www.opengis.net/ogc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.opengis.net/ogc http://schemas.opengis.net/wfs/1.0.0/OGC-exception...">
<ServiceException>
java.lang.RuntimeException: java.io.IOException
java.io.IOExceptionORA-29902: error in executing ODCIIndexStart() routine
ORA-13208: internal error while evaluating [window SRID does not match layer SRID] operator
ORA-06512: at &quot;MDSYS.SDO_INDEX_METHOD_10I&quot;, line 585
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13208: internal error while evaluating [window SRID does not match layer SRID] operator
ORA-06512: at &quot;MDSYS.SDO_INDEX_METHOD_10I&quot;, line 585
</ServiceException></ServiceExceptionReport>

Can someone please help me this issue?

• https://files.engineering.com/getfile.aspx?folder=4c6d4cc4-f9eb-45f2-9a18-9