Patch 12596497 : form CSXSRISR.fmx error

Patch 12596497 : form CSXSRISR.fmx error

The following Oracle Forms objects did not generate successfully:

cs    forms/E    CSXSRISR.fmx

adworker log

FRM-30064: Unable to parse statement select * from (SELECT resource_name supplier_name,'RS_SUPPLIER_CONTACT' RESOURCE_TYPE, res.RESOURCE_ID RESOURCE_ID , res.RESOURCE_NUMBER RESOURCE_NUMBER,
source_phone phone,
cs_std.cs_get_resource_phone_email(res.source_id,    'W1') owner_work,
     cs_std.cs_get_resource_phone_email(res.source_id,    'E') email
FROM CS_JTF_RS_RESOURCE_EXTNS_SEC res,  JTF_RS_GROUP_MEMBERS grp
WHERE res.resource_id = grp.resource_id
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(res.START_DATE_ACTIVE),TRUNC(SYSDATE))