Submitted ER is not going for approval

Hi All,

When ERs are submitted they are not going into workflow, we are monitoring everyday and fixing the flags accordingly for EX_SHEET_HR and EX_SHEET_LINE. We are on Rel 9.2 Image 16 and Tools 8.54; If anybody noticed the same pattern please let us know as none of them tied to a project or project manager. Just to clarify it is not happening to all the ERs, only few a week.

Thanks and please see some of the SQLs.

SELECT SHEET_ID,SHEET_STATUS FROM

PS_EX_SHEET_HDR

WHERE  SHEET_STATUS ='SUB'

AND SHEET_ID NOT IN ( SELECT SHEET_ID   FROM PS_EX_SHEET_AW )