Error In Fresh Requestjava.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected Error In Extention Requestjava.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected

Total Claim Reported
From null-null-null:12:00 AM To null-null-null:11:59 PM
Cashless Claim Register	0
Reimbursement Claim Register	0
Total Claim Register	0

Error In Main Queryjava.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected SELECT MT.BRANCHHEAD_NAME BRANCH,INITCAP(l.SIGNINID) USERNAME,S.USERID,COUNT(CRD.CLAIM_NO) CLAIM FROM CASHLESS_REQUEST_DETAILS crd,CLAIM_STAGES CS,SIGNINUSER S,LOGINDETAIL L,MASTER_TPA_BRANCH MT WHERE CRD.CLAIM_NO=cs.CLAIM_NO AND S.USERID=CS.ACTION_BY AND S.LOGINDETAILID=L.LOGINDETAILID AND L.BRANCH_ID=MT.BRANCH_ID AND crd.status IN (6,7) AND cs.STAGE_CODE IN (23,24,25,11,1414,30,1420,1421,75) AND L.BRANCH_ID='null' AND CS.ACTION_DATE BETWEEN TO_DATE('null-null-null:12:00 AM','DD-Mon-YYYY:HH:MI AM') AND TO_DATE('null-null-null:11:59 PM','DD-Mon-YYYY:HH:MI PM') GROUP BY MT.BRANCHHEAD_NAME,l.SIGNINID,S.USERID

Claim Report For Management
Raksha Branch	User Name	Claim Query By Doctor	Claim Passed By Doctor	Claim NonPay By Doctor	Claim Query By Auditor	Claim Passed By Auditor	Claim NonPay By Auditor	QC Done By Auditor	QC Query By Auditor	Total Claim

Error In Time Wise Requestjava.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected

Report For Time Interval
Raksha Branch	User Name	08:30 AM-10:30 AM	10:31 AM-12:30 PM	12:31 PM-02:30 PM	02:31 PM-04:30 PM	04:31 PM-06:30 PM	06:31 PM-08:30 PM	Total