ASB XE3/32/64 DLL running [Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][] DB Manager created gcmsDM_Sirohi_PRO827ccb0eea8a706c4c34a16891f84e7btrcmf001040826/02/20260104082021/27118707000005842???26/02/20261847300000000023/04/202618473000000000NO00104082021/27218717000006149???26/02/20261847300000000023/04/202618473000000000NO00104082021/27318727000006370???26/02/20261847300000000023/04/202618473000000000NO00104082022/5210837000006102???? ????????? ????26/02/20261255500000000223/04/202612555000000002NO00104082022/5310874000006216???? ????????? ????26/02/20261255500000000223/04/202612555000000002NO00104082023/10110336000007910???26/02/20261847300000000019/03/202618473000000000NO00104082023/1116137000007565???26/02/20261847300000000019/03/202618473000000000NO00104082024/3912999000008381???26/02/20261847300000000019/03/202618473000000000NO00104082025/13111347000010187???? ?????????26/02/2026100049702/04/20261000497NO00104082025/13211358000011229???? ?????????26/02/2026100049702/04/20261000497NO00104082025/13311375000009797???? ?????????26/02/2026100049702/04/20261000497NO00104082025/13411386000011091???? ?????????26/02/2026100049702/04/20261000497NO00104082025/13511393000009925???? ?????????26/02/2026100049702/04/20261000497NO00104082025/13611402000011426???? ?????????26/02/2026100049702/04/20261000497NO00104082025/13711419000010586???? ?????????26/02/2026100049702/04/20261000497NO00104082025/13811433000010412???? ?????????26/02/2026100049702/04/20261000497NO00104082025/13911441000010285???? ?????????26/02/2026100049702/04/20261000497NO00104082025/27315494000011531???? ?????????26/02/2026100049702/04/20261000497NO00104082025/27415629000010911???? ?????????26/02/2026100049702/04/20261000497NO00104082025/27515725000010908???? ?????????26/02/2026100049702/04/20261000497NO00104082025/27615795000012169???? ?????????26/02/2026100049702/04/20261000497NO00104082025/27715867000010975???? ?????????26/02/2026100049702/04/20261000497NO00104082025/27815947000009082???? ?????????26/02/2026100049702/04/20261000497NO00104082025/27916017000012016???? ?????????26/02/2026100049702/04/20261000497NO00104082025/28016081000010788???? ?????????26/02/2026100049702/04/20261000497NO00104082025/28116161000010505???? ?????????26/02/2026100049702/04/20261000497NO00104082025/28216253000011856???? ?????????26/02/2026100049702/04/20261000497NO00104082025/28316320000011490???? ?????????26/02/2026100049702/04/20261000497NO00104082025/28416408000012201???? ?????????26/02/2026100049702/04/20261000497NO00104082025/28516634000010473???? ?????????26/02/2026100049702/04/20261000497NO00104082025/28616752000010990???? ?????????26/02/2026100049702/04/20261000497NO00104082025/28716844000010926???? ?????????26/02/2026100049702/04/20261000497NO00104082025/28816941000011597???? ?????????26/02/2026100049702/04/20261000497NO00104082025/28917111000010940???? ?????????26/02/2026100049702/04/20261000497NO00104082025/29017209000013175???? ?????????26/02/2026100049702/04/20261000497NO00104082025/29117277000011347???? ?????????26/02/2026100049702/04/20261000497NO00104082025/29217382000011807???? ?????????26/02/2026100049702/04/20261000497NO00104082025/29317459000011194???? ?????????26/02/2026100049702/04/20261000497NO00104082026/4618837000010220?????26/02/2026100049202/04/20261000492NO0 Executing Savedata webservice ----------------------------- Received JSON : {"savedata":{"axpapp":"gcms","username":"DM_Sirohi_PRO","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"trcmf","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtcode":"10408","hearing_date":"26/02/2026"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"court_code":"10408","case_no":"2021/271","trn_rcms_caseid":"18707000005842","pre_case_purpose_name":"???","pre_hear_date":"26/02/2026","pre_case_purpose":"18473000000000","next_hear_date":"23/04/2026","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"002","text":"0","columns":{"court_code":"10408","case_no":"2021/272","trn_rcms_caseid":"18717000006149","pre_case_purpose_name":"???","pre_hear_date":"26/02/2026","pre_case_purpose":"18473000000000","next_hear_date":"23/04/2026","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"003","text":"0","columns":{"court_code":"10408","case_no":"2021/273","trn_rcms_caseid":"18727000006370","pre_case_purpose_name":"???","pre_hear_date":"26/02/2026","pre_case_purpose":"18473000000000","next_hear_date":"23/04/2026","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"004","text":"0","columns":{"court_code":"10408","case_no":"2022/52","trn_rcms_caseid":"10837000006102","pre_case_purpose_name":"???? ????????? ????","pre_hear_date":"26/02/2026","pre_case_purpose":"12555000000002","next_hear_date":"23/04/2026","new_case_purpose":"12555000000002","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"005","text":"0","columns":{"court_code":"10408","case_no":"2022/53","trn_rcms_caseid":"10874000006216","pre_case_purpose_name":"???? ????????? ????","pre_hear_date":"26/02/2026","pre_case_purpose":"12555000000002","next_hear_date":"23/04/2026","new_case_purpose":"12555000000002","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"006","text":"0","columns":{"court_code":"10408","case_no":"2023/101","trn_rcms_caseid":"10336000007910","pre_case_purpose_name":"???","pre_hear_date":"26/02/2026","pre_case_purpose":"18473000000000","next_hear_date":"19/03/2026","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"007","text":"0","columns":{"court_code":"10408","case_no":"2023/11","trn_rcms_caseid":"16137000007565","pre_case_purpose_name":"???","pre_hear_date":"26/02/2026","pre_case_purpose":"18473000000000","next_hear_date":"19/03/2026","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"008","text":"0","columns":{"court_code":"10408","case_no":"2024/39","trn_rcms_caseid":"12999000008381","pre_case_purpose_name":"???","pre_hear_date":"26/02/2026","pre_case_purpose":"18473000000000","next_hear_date":"19/03/2026","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"009","text":"0","columns":{"court_code":"10408","case_no":"2025/131","trn_rcms_caseid":"11347000010187","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0010","text":"0","columns":{"court_code":"10408","case_no":"2025/132","trn_rcms_caseid":"11358000011229","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0011","text":"0","columns":{"court_code":"10408","case_no":"2025/133","trn_rcms_caseid":"11375000009797","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0012","text":"0","columns":{"court_code":"10408","case_no":"2025/134","trn_rcms_caseid":"11386000011091","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0013","text":"0","columns":{"court_code":"10408","case_no":"2025/135","trn_rcms_caseid":"11393000009925","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0014","text":"0","columns":{"court_code":"10408","case_no":"2025/136","trn_rcms_caseid":"11402000011426","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0015","text":"0","columns":{"court_code":"10408","case_no":"2025/137","trn_rcms_caseid":"11419000010586","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0016","text":"0","columns":{"court_code":"10408","case_no":"2025/138","trn_rcms_caseid":"11433000010412","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0017","text":"0","columns":{"court_code":"10408","case_no":"2025/139","trn_rcms_caseid":"11441000010285","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0018","text":"0","columns":{"court_code":"10408","case_no":"2025/273","trn_rcms_caseid":"15494000011531","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0019","text":"0","columns":{"court_code":"10408","case_no":"2025/274","trn_rcms_caseid":"15629000010911","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0020","text":"0","columns":{"court_code":"10408","case_no":"2025/275","trn_rcms_caseid":"15725000010908","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0021","text":"0","columns":{"court_code":"10408","case_no":"2025/276","trn_rcms_caseid":"15795000012169","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0022","text":"0","columns":{"court_code":"10408","case_no":"2025/277","trn_rcms_caseid":"15867000010975","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0023","text":"0","columns":{"court_code":"10408","case_no":"2025/278","trn_rcms_caseid":"15947000009082","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0024","text":"0","columns":{"court_code":"10408","case_no":"2025/279","trn_rcms_caseid":"16017000012016","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0025","text":"0","columns":{"court_code":"10408","case_no":"2025/280","trn_rcms_caseid":"16081000010788","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0026","text":"0","columns":{"court_code":"10408","case_no":"2025/281","trn_rcms_caseid":"16161000010505","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0027","text":"0","columns":{"court_code":"10408","case_no":"2025/282","trn_rcms_caseid":"16253000011856","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0028","text":"0","columns":{"court_code":"10408","case_no":"2025/283","trn_rcms_caseid":"16320000011490","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0029","text":"0","columns":{"court_code":"10408","case_no":"2025/284","trn_rcms_caseid":"16408000012201","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0030","text":"0","columns":{"court_code":"10408","case_no":"2025/285","trn_rcms_caseid":"16634000010473","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0031","text":"0","columns":{"court_code":"10408","case_no":"2025/286","trn_rcms_caseid":"16752000010990","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0032","text":"0","columns":{"court_code":"10408","case_no":"2025/287","trn_rcms_caseid":"16844000010926","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0033","text":"0","columns":{"court_code":"10408","case_no":"2025/288","trn_rcms_caseid":"16941000011597","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0034","text":"0","columns":{"court_code":"10408","case_no":"2025/289","trn_rcms_caseid":"17111000010940","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0035","text":"0","columns":{"court_code":"10408","case_no":"2025/290","trn_rcms_caseid":"17209000013175","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0036","text":"0","columns":{"court_code":"10408","case_no":"2025/291","trn_rcms_caseid":"17277000011347","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0037","text":"0","columns":{"court_code":"10408","case_no":"2025/292","trn_rcms_caseid":"17382000011807","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0038","text":"0","columns":{"court_code":"10408","case_no":"2025/293","trn_rcms_caseid":"17459000011194","pre_case_purpose_name":"???? ?????????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000497","next_hear_date":"02/04/2026","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0039","text":"0","columns":{"court_code":"10408","case_no":"2026/46","trn_rcms_caseid":"18837000010220","pre_case_purpose_name":"?????","pre_hear_date":"26/02/2026","pre_case_purpose":"1000492","next_hear_date":"02/04/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}}]}]}} Verifying username and password User Name : DM_Sirohi_PRO Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app' U=dm_sirohi_pro Time elapsed = 17 Password checking along with max.no of login specified in app.xml update axusers set logintry = 0 where lower(username) = :U Time elapsed = 5 Result : Verifying completed... Page Access Category : User Name : dm_sirohi_pro Select sysdate as sdt from dual Time elapsed = 3 dt=26/02/2026 18:16:02 Select sysdate as sdt from dual Time elapsed = 2 Select usergroup from AXUSERLEVELGROUPS WHERE (lower(username) =:U) and ((startdate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') >= startdate) or (startdate is null)) and ((enddate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') <= enddate) or (enddate is null)) U=dm_sirohi_pro dt=26/02/2026 18:16:02 dt=26/02/2026 18:16:02 Time elapsed = 6 User Groups: court_admin select userroles from axusergroups where groupname in ( 'court_admin' ) Time elapsed = 2 User Roles : court_admin Loading App/User vars reading the props xml Step3 Sql : select props from axprops where lower(name)= :name order by blobno Paramval : app ParamTYpe : c Param List : name select props from axprops where lower(name)= :name order by blobno Time elapsed = 2 Step4 axprops\stm size:4235 Step4-123456 images\Generalized Court Management SystemINRF500250000F00000F Step4-4 Step5 Step6 Step9 fetched the props xml 10010000-1000000 2 Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1}) Calling function firesql username=DM_Sirohi_PRO select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=DM_Sirohi_PRO Time elapsed = 2 Result of firesql = Result = Evaluating sqlget({m2},{court_name}) Calling function sqlget Result of sqlget = ???? ???????,?????? Result = ???? ???????,?????? Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1}) Calling function firesql username=DM_Sirohi_PRO select a.court_type from v_axcourts a where a.paxusername= :username order by 1 username=DM_Sirohi_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m3},{court_type}) Calling function sqlget Result of sqlget = DM Result = DM Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1}) Calling function firesql username=DM_Sirohi_PRO select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1 username=DM_Sirohi_PRO Time elapsed = 2 Result of firesql = Result = Evaluating sqlget({m4},{court_name_mastid}) Calling function sqlget Result of sqlget = 12836000000161 Result = 12836000000161 Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username}) Calling function firesql select a1.axusersid from axusers a1 where a1.username=:username username=DM_Sirohi_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m4},{axusersid}) Calling function sqlget Result of sqlget = 1893880009086 Result = 1893880009086 Evaluating firesql({m4},{select :username as uname from dual}) Calling function firesql select :username as uname from dual username=DM_Sirohi_PRO Time elapsed = 2 Result of firesql = Result = Evaluating sqlget({m4},{uname}) Calling function sqlget Result of sqlget = DM_Sirohi_PRO Result = DM_Sirohi_PRO Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1}) Calling function firesql select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=DM_Sirohi_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m4},{COURT_CODE}) Calling function sqlget Result of sqlget = 10408 Result = 10408 Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'}) Calling function firesql select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ' Time elapsed = 2 Result of firesql = Result = Evaluating sqlget({m2},{STATE_NAME}) Calling function sqlget Result of sqlget = ???????? Result = ???????? Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=DM_Sirohi_PRO SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=DM_Sirohi_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m7},{DISTNAMEENG}) Calling function sqlget Result of sqlget = Sirohi Result = Sirohi Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=DM_Sirohi_PRO SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=DM_Sirohi_PRO Time elapsed = 2 Result of firesql = Result = Evaluating sqlget({m8},{COURT_CATEGOTY}) Calling function sqlget Result of sqlget = 10593000000007 Result = 10593000000007 Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid}) Calling function firesql login_userid=1893880009086 select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid login_userid=1893880009086 Time elapsed = 4 Result of firesql = Result = Evaluating sqlget({m4},{department_mastid}) Calling function sqlget Result of sqlget = 1579880000000 Result = 1579880000000 Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1}) Calling function firesql select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1 username=DM_Sirohi_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m3},{court_type_mastid}) Calling function sqlget Result of sqlget = 10206000000014 Result = 10206000000014 Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username }) Calling function firesql username=DM_Sirohi_PRO select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username username=DM_Sirohi_PRO Time elapsed = 4 Result of firesql = Result = Evaluating sqlget({m4},{groupname}) Calling function sqlget Result of sqlget = court_admin Result = court_admin Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual}) Calling function firesql select to_date('30/01/2021','DD/MM/RRRR') dd from dual Time elapsed = 2 Result of firesql = Result = Evaluating sqlget({a1},{dd}) Calling function sqlget Result of sqlget = 30/01/2021 Result = 30/01/2021 Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0}) Calling function firesql username=DM_Sirohi_PRO SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0 username=DM_Sirohi_PRO Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({P1},{ct}) Calling function sqlget Result of sqlget = 6 Result = 6 3 completed LoadAppVars Password validation done successfully select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_admin') and lower(sname)='trcmf' and stype = 't' ) Time elapsed = 1 select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='trcmf' and stype = 't' Time elapsed = 3 Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno Paramval : court_admin,trcmf,t ParamTYpe : ccc Param List : rname sname stype select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno Time elapsed = 1 Reading data from stream Executing GetTransControlString Executing GetTransControl Creating DbCall Structure xml not received from client Step3 Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : trcmf ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 3 Step4 tstructs\stm size:2075 Step4-0 Step4-1 Step4-2 Step4-3 Step4-4 Step5 Step6 Step9 Evaluating date() Result = Evaluating iif((next_hear_date>Validating trcmf >>Frame No 1 courtcode = 10408 hearing_date = 26/02/2026 time zone difference = 0 >>Writing to tables trcmf Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf' Time elapsed = 2 Saving to table TRN_RCMS_MHEARING select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16673000012298 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 hearing_date = 26/02/2026 courtcode = 10408 Posting record Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:02 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:02 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c hearing_date=26/02/2026 00:00:00 Param Type = c courtcode=10408 insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode) Saving to table TRN_RCMS_HEARING select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012299 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 1 case_no = 2021/271 isadjourn = NO adjourn_type = 0 trn_rcms_caseid = 18707000005842 adjourn_remark = pre_case_purpose = 18473000000000 court_code = 10408 pre_hear_date = 26/02/2026 next_hear_date = 23/04/2026 new_case_purpose = 18473000000000 TRN_RCMS_HEARINGrow = 1 Posting record Param Type = n trn_rcms_hearingid=16673000012299 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:02 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:02 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2021/271 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c trn_rcms_caseid=18707000005842 Param Type = n pre_case_purpose=18473000000000 Param Type = c court_code=10408 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = c next_hear_date=23/04/2026 00:00:00 Param Type = c new_case_purpose=18473000000000 Param Type = n trn_rcms_hearingrow=1 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,isadjourn,adjourn_type,trn_rcms_caseid,adjourn_remark,pre_case_purpose,court_code,pre_hear_date,next_hear_date,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:isadjourn,:adjourn_type,:trn_rcms_caseid,null,:pre_case_purpose,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 2 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012300 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 pre_case_purpose = 18473000000000 new_case_purpose = 18473000000000 pre_hear_date = 26/02/2026 court_code = 10408 case_no = 2021/272 trn_rcms_caseid = 18717000006149 adjourn_type = 0 adjourn_remark = next_hear_date = 23/04/2026 isadjourn = NO TRN_RCMS_HEARINGrow = 2 Posting record Param Type = n trn_rcms_hearingid=16673000012300 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:02 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:02 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = n pre_case_purpose=18473000000000 Param Type = c new_case_purpose=18473000000000 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = c court_code=10408 Param Type = c case_no=2021/272 Param Type = c trn_rcms_caseid=18717000006149 Param Type = c adjourn_type=0 Param Type = c next_hear_date=23/04/2026 00:00:00 Param Type = c isadjourn=NO Param Type = n trn_rcms_hearingrow=2 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,new_case_purpose,pre_hear_date,court_code,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 3 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012301 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 1 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 23/04/2026 new_case_purpose = 18473000000000 isadjourn = NO adjourn_remark = adjourn_type = 0 case_no = 2021/273 court_code = 10408 trn_rcms_caseid = 18727000006370 pre_case_purpose = 18473000000000 pre_hear_date = 26/02/2026 TRN_RCMS_HEARINGrow = 3 Posting record Param Type = n trn_rcms_hearingid=16673000012301 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:02 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:02 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=23/04/2026 00:00:00 Param Type = c new_case_purpose=18473000000000 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c case_no=2021/273 Param Type = c court_code=10408 Param Type = c trn_rcms_caseid=18727000006370 Param Type = n pre_case_purpose=18473000000000 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n trn_rcms_hearingrow=3 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 4 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012302 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 pre_hear_date = 26/02/2026 pre_case_purpose = 12555000000002 trn_rcms_caseid = 10837000006102 court_code = 10408 case_no = 2022/52 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 12555000000002 next_hear_date = 23/04/2026 TRN_RCMS_HEARINGrow = 4 Posting record Param Type = n trn_rcms_hearingid=16673000012302 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:02 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:02 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n pre_case_purpose=12555000000002 Param Type = c trn_rcms_caseid=10837000006102 Param Type = c court_code=10408 Param Type = c case_no=2022/52 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=12555000000002 Param Type = c next_hear_date=23/04/2026 00:00:00 Param Type = n trn_rcms_hearingrow=4 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 5 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012303 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 1 next_hear_date = 23/04/2026 new_case_purpose = 12555000000002 isadjourn = NO adjourn_remark = adjourn_type = 0 case_no = 2022/53 court_code = 10408 trn_rcms_caseid = 10874000006216 pre_case_purpose = 12555000000002 pre_hear_date = 26/02/2026 TRN_RCMS_HEARINGrow = 5 Posting record Param Type = n trn_rcms_hearingid=16673000012303 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=23/04/2026 00:00:00 Param Type = c new_case_purpose=12555000000002 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c case_no=2022/53 Param Type = c court_code=10408 Param Type = c trn_rcms_caseid=10874000006216 Param Type = n pre_case_purpose=12555000000002 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n trn_rcms_hearingrow=5 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 6 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012304 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 1 Select sysdate as sdt from dual Time elapsed = 1 next_hear_date = 19/03/2026 new_case_purpose = 18473000000000 isadjourn = NO adjourn_remark = adjourn_type = 0 case_no = 2023/101 court_code = 10408 trn_rcms_caseid = 10336000007910 pre_case_purpose = 18473000000000 pre_hear_date = 26/02/2026 TRN_RCMS_HEARINGrow = 6 Posting record Param Type = n trn_rcms_hearingid=16673000012304 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=19/03/2026 00:00:00 Param Type = c new_case_purpose=18473000000000 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c case_no=2023/101 Param Type = c court_code=10408 Param Type = c trn_rcms_caseid=10336000007910 Param Type = n pre_case_purpose=18473000000000 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n trn_rcms_hearingrow=6 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 7 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012305 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 19/03/2026 new_case_purpose = 18473000000000 isadjourn = NO adjourn_remark = adjourn_type = 0 case_no = 2023/11 court_code = 10408 trn_rcms_caseid = 16137000007565 pre_case_purpose = 18473000000000 pre_hear_date = 26/02/2026 TRN_RCMS_HEARINGrow = 7 Posting record Param Type = n trn_rcms_hearingid=16673000012305 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=19/03/2026 00:00:00 Param Type = c new_case_purpose=18473000000000 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c case_no=2023/11 Param Type = c court_code=10408 Param Type = c trn_rcms_caseid=16137000007565 Param Type = n pre_case_purpose=18473000000000 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n trn_rcms_hearingrow=7 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 8 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012306 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 19/03/2026 new_case_purpose = 18473000000000 isadjourn = NO adjourn_remark = adjourn_type = 0 case_no = 2024/39 court_code = 10408 trn_rcms_caseid = 12999000008381 pre_case_purpose = 18473000000000 pre_hear_date = 26/02/2026 TRN_RCMS_HEARINGrow = 8 Posting record Param Type = n trn_rcms_hearingid=16673000012306 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=19/03/2026 00:00:00 Param Type = c new_case_purpose=18473000000000 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c case_no=2024/39 Param Type = c court_code=10408 Param Type = c trn_rcms_caseid=12999000008381 Param Type = n pre_case_purpose=18473000000000 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n trn_rcms_hearingrow=8 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 9 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012307 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 1 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 02/04/2026 new_case_purpose = 1000497 isadjourn = NO adjourn_remark = adjourn_type = 0 case_no = 2025/131 court_code = 10408 trn_rcms_caseid = 11347000010187 pre_case_purpose = 1000497 pre_hear_date = 26/02/2026 TRN_RCMS_HEARINGrow = 9 Posting record Param Type = n trn_rcms_hearingid=16673000012307 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c new_case_purpose=1000497 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c case_no=2025/131 Param Type = c court_code=10408 Param Type = c trn_rcms_caseid=11347000010187 Param Type = n pre_case_purpose=1000497 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n trn_rcms_hearingrow=9 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 10 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012308 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 1 Select sysdate as sdt from dual Time elapsed = 2 pre_hear_date = 26/02/2026 pre_case_purpose = 1000497 court_code = 10408 case_no = 2025/132 trn_rcms_caseid = 11358000011229 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 1000497 next_hear_date = 02/04/2026 TRN_RCMS_HEARINGrow = 10 Posting record Param Type = n trn_rcms_hearingid=16673000012308 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n pre_case_purpose=1000497 Param Type = c court_code=10408 Param Type = c case_no=2025/132 Param Type = c trn_rcms_caseid=11358000011229 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=1000497 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = n trn_rcms_hearingrow=10 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,court_code,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,:case_no,:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 11 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012309 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 02/04/2026 new_case_purpose = 1000497 isadjourn = NO adjourn_remark = adjourn_type = 0 case_no = 2025/133 trn_rcms_caseid = 11375000009797 court_code = 10408 pre_case_purpose = 1000497 pre_hear_date = 26/02/2026 TRN_RCMS_HEARINGrow = 11 Posting record Param Type = n trn_rcms_hearingid=16673000012309 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c new_case_purpose=1000497 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c case_no=2025/133 Param Type = c trn_rcms_caseid=11375000009797 Param Type = c court_code=10408 Param Type = n pre_case_purpose=1000497 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n trn_rcms_hearingrow=11 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,trn_rcms_caseid,court_code,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:trn_rcms_caseid,:court_code,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 12 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012310 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 court_code = 10408 case_no = 2025/134 pre_case_purpose = 1000497 new_case_purpose = 1000497 next_hear_date = 02/04/2026 adjourn_remark = adjourn_type = 0 isadjourn = NO trn_rcms_caseid = 11386000011091 pre_hear_date = 26/02/2026 TRN_RCMS_HEARINGrow = 12 Posting record Param Type = n trn_rcms_hearingid=16673000012310 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c court_code=10408 Param Type = c case_no=2025/134 Param Type = n pre_case_purpose=1000497 Param Type = c new_case_purpose=1000497 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c trn_rcms_caseid=11386000011091 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n trn_rcms_hearingrow=12 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,case_no,pre_case_purpose,new_case_purpose,next_hear_date,adjourn_remark,adjourn_type,isadjourn,trn_rcms_caseid,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:case_no,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:isadjourn,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 13 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012311 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trn_rcms_caseid = 11393000009925 court_code = 10408 adjourn_remark = adjourn_type = 0 isadjourn = NO next_hear_date = 02/04/2026 new_case_purpose = 1000497 pre_hear_date = 26/02/2026 pre_case_purpose = 1000497 case_no = 2025/135 TRN_RCMS_HEARINGrow = 13 Posting record Param Type = n trn_rcms_hearingid=16673000012311 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trn_rcms_caseid=11393000009925 Param Type = c court_code=10408 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c new_case_purpose=1000497 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n pre_case_purpose=1000497 Param Type = c case_no=2025/135 Param Type = n trn_rcms_hearingrow=13 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,court_code,adjourn_remark,adjourn_type,isadjourn,next_hear_date,new_case_purpose,pre_hear_date,pre_case_purpose,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,:court_code,null,:adjourn_type,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 14 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012312 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 13 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 1000497 next_hear_date = 02/04/2026 case_no = 2025/136 court_code = 10408 trn_rcms_caseid = 11402000011426 pre_case_purpose = 1000497 pre_hear_date = 26/02/2026 TRN_RCMS_HEARINGrow = 14 Posting record Param Type = n trn_rcms_hearingid=16673000012312 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=1000497 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c case_no=2025/136 Param Type = c court_code=10408 Param Type = c trn_rcms_caseid=11402000011426 Param Type = n pre_case_purpose=1000497 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n trn_rcms_hearingrow=14 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 15 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012313 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 pre_hear_date = 26/02/2026 pre_case_purpose = 1000497 trn_rcms_caseid = 11419000010586 court_code = 10408 case_no = 2025/137 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 1000497 next_hear_date = 02/04/2026 TRN_RCMS_HEARINGrow = 15 Posting record Param Type = n trn_rcms_hearingid=16673000012313 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n pre_case_purpose=1000497 Param Type = c trn_rcms_caseid=11419000010586 Param Type = c court_code=10408 Param Type = c case_no=2025/137 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=1000497 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = n trn_rcms_hearingrow=15 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 16 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012314 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 pre_hear_date = 26/02/2026 pre_case_purpose = 1000497 trn_rcms_caseid = 11433000010412 court_code = 10408 case_no = 2025/138 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 1000497 next_hear_date = 02/04/2026 TRN_RCMS_HEARINGrow = 16 Posting record Param Type = n trn_rcms_hearingid=16673000012314 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n pre_case_purpose=1000497 Param Type = c trn_rcms_caseid=11433000010412 Param Type = c court_code=10408 Param Type = c case_no=2025/138 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=1000497 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = n trn_rcms_hearingrow=16 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 17 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012315 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 02/04/2026 new_case_purpose = 1000497 isadjourn = NO adjourn_remark = adjourn_type = 0 case_no = 2025/139 court_code = 10408 trn_rcms_caseid = 11441000010285 pre_case_purpose = 1000497 pre_hear_date = 26/02/2026 TRN_RCMS_HEARINGrow = 17 Posting record Param Type = n trn_rcms_hearingid=16673000012315 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c new_case_purpose=1000497 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c case_no=2025/139 Param Type = c court_code=10408 Param Type = c trn_rcms_caseid=11441000010285 Param Type = n pre_case_purpose=1000497 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n trn_rcms_hearingrow=17 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 18 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012316 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 1 Select sysdate as sdt from dual Time elapsed = 2 pre_hear_date = 26/02/2026 pre_case_purpose = 1000497 trn_rcms_caseid = 15494000011531 court_code = 10408 case_no = 2025/273 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 1000497 next_hear_date = 02/04/2026 TRN_RCMS_HEARINGrow = 18 Posting record Param Type = n trn_rcms_hearingid=16673000012316 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n pre_case_purpose=1000497 Param Type = c trn_rcms_caseid=15494000011531 Param Type = c court_code=10408 Param Type = c case_no=2025/273 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=1000497 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = n trn_rcms_hearingrow=18 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 19 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012317 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 pre_case_purpose = 1000497 court_code = 10408 pre_hear_date = 26/02/2026 case_no = 2025/274 trn_rcms_caseid = 15629000010911 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 1000497 next_hear_date = 02/04/2026 TRN_RCMS_HEARINGrow = 19 Posting record Param Type = n trn_rcms_hearingid=16673000012317 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = n pre_case_purpose=1000497 Param Type = c court_code=10408 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = c case_no=2025/274 Param Type = c trn_rcms_caseid=15629000010911 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=1000497 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = n trn_rcms_hearingrow=19 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,court_code,pre_hear_date,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 20 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012318 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 adjourn_remark = adjourn_type = 0 pre_case_purpose = 1000497 isadjourn = NO next_hear_date = 02/04/2026 new_case_purpose = 1000497 pre_hear_date = 26/02/2026 court_code = 10408 case_no = 2025/275 trn_rcms_caseid = 15725000010908 TRN_RCMS_HEARINGrow = 20 Posting record Param Type = n trn_rcms_hearingid=16673000012318 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c adjourn_type=0 Param Type = n pre_case_purpose=1000497 Param Type = c isadjourn=NO Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c new_case_purpose=1000497 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = c court_code=10408 Param Type = c case_no=2025/275 Param Type = c trn_rcms_caseid=15725000010908 Param Type = n trn_rcms_hearingrow=20 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,pre_case_purpose,isadjourn,next_hear_date,new_case_purpose,pre_hear_date,court_code,case_no,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:pre_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 21 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012319 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 1 next_hear_date = 02/04/2026 new_case_purpose = 1000497 pre_case_purpose = 1000497 case_no = 2025/276 trn_rcms_caseid = 15795000012169 pre_hear_date = 26/02/2026 court_code = 10408 adjourn_remark = adjourn_type = 0 isadjourn = NO TRN_RCMS_HEARINGrow = 21 Posting record Param Type = n trn_rcms_hearingid=16673000012319 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c new_case_purpose=1000497 Param Type = n pre_case_purpose=1000497 Param Type = c case_no=2025/276 Param Type = c trn_rcms_caseid=15795000012169 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = c court_code=10408 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n trn_rcms_hearingrow=21 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,pre_case_purpose,case_no,trn_rcms_caseid,pre_hear_date,court_code,adjourn_remark,adjourn_type,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,null,:adjourn_type,:isadjourn,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 22 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012320 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 1 trn_rcms_caseid = 15867000010975 new_case_purpose = 1000497 next_hear_date = 02/04/2026 pre_case_purpose = 1000497 court_code = 10408 case_no = 2025/277 pre_hear_date = 26/02/2026 adjourn_type = 0 isadjourn = NO adjourn_remark = TRN_RCMS_HEARINGrow = 22 Posting record Param Type = n trn_rcms_hearingid=16673000012320 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trn_rcms_caseid=15867000010975 Param Type = c new_case_purpose=1000497 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = n pre_case_purpose=1000497 Param Type = c court_code=10408 Param Type = c case_no=2025/277 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n trn_rcms_hearingrow=22 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,new_case_purpose,next_hear_date,pre_case_purpose,court_code,case_no,pre_hear_date,adjourn_type,isadjourn,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 23 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012321 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 1 next_hear_date = 02/04/2026 isadjourn = NO new_case_purpose = 1000497 pre_hear_date = 26/02/2026 pre_case_purpose = 1000497 trn_rcms_caseid = 15947000009082 court_code = 10408 adjourn_remark = case_no = 2025/278 adjourn_type = 0 TRN_RCMS_HEARINGrow = 23 Posting record Param Type = n trn_rcms_hearingid=16673000012321 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c isadjourn=NO Param Type = c new_case_purpose=1000497 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n pre_case_purpose=1000497 Param Type = c trn_rcms_caseid=15947000009082 Param Type = c court_code=10408 Param Type = c case_no=2025/278 Param Type = c adjourn_type=0 Param Type = n trn_rcms_hearingrow=23 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,new_case_purpose,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,adjourn_remark,case_no,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,null,:case_no,:adjourn_type,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 24 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012322 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 pre_hear_date = 26/02/2026 pre_case_purpose = 1000497 trn_rcms_caseid = 16017000012016 court_code = 10408 case_no = 2025/279 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 1000497 next_hear_date = 02/04/2026 TRN_RCMS_HEARINGrow = 24 Posting record Param Type = n trn_rcms_hearingid=16673000012322 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n pre_case_purpose=1000497 Param Type = c trn_rcms_caseid=16017000012016 Param Type = c court_code=10408 Param Type = c case_no=2025/279 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=1000497 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = n trn_rcms_hearingrow=24 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 25 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16673000012323 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 pre_hear_date = 26/02/2026 pre_case_purpose = 1000497 trn_rcms_caseid = 16081000010788 court_code = 10408 case_no = 2025/280 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 1000497 next_hear_date = 02/04/2026 TRN_RCMS_HEARINGrow = 25 Posting record Param Type = n trn_rcms_hearingid=16673000012323 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n pre_case_purpose=1000497 Param Type = c trn_rcms_caseid=16081000010788 Param Type = c court_code=10408 Param Type = c case_no=2025/280 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=1000497 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = n trn_rcms_hearingrow=25 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 26 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012324 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 02/04/2026 new_case_purpose = 1000497 adjourn_type = 0 isadjourn = NO pre_case_purpose = 1000497 case_no = 2025/281 court_code = 10408 pre_hear_date = 26/02/2026 trn_rcms_caseid = 16161000010505 adjourn_remark = TRN_RCMS_HEARINGrow = 26 Posting record Param Type = n trn_rcms_hearingid=16673000012324 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c new_case_purpose=1000497 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n pre_case_purpose=1000497 Param Type = c case_no=2025/281 Param Type = c court_code=10408 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = c trn_rcms_caseid=16161000010505 Param Type = n trn_rcms_hearingrow=26 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_type,isadjourn,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:isadjourn,:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 27 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012325 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 1 new_case_purpose = 1000497 next_hear_date = 02/04/2026 trn_rcms_caseid = 16253000011856 pre_hear_date = 26/02/2026 pre_case_purpose = 1000497 adjourn_type = 0 adjourn_remark = isadjourn = NO court_code = 10408 case_no = 2025/282 TRN_RCMS_HEARINGrow = 27 Posting record Param Type = n trn_rcms_hearingid=16673000012325 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c new_case_purpose=1000497 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c trn_rcms_caseid=16253000011856 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n pre_case_purpose=1000497 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c court_code=10408 Param Type = c case_no=2025/282 Param Type = n trn_rcms_hearingrow=27 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_hear_date,pre_case_purpose,adjourn_type,adjourn_remark,isadjourn,court_code,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:adjourn_type,null,:isadjourn,:court_code,:case_no,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 28 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012326 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 pre_hear_date = 26/02/2026 pre_case_purpose = 1000497 trn_rcms_caseid = 16320000011490 court_code = 10408 case_no = 2025/283 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 1000497 next_hear_date = 02/04/2026 TRN_RCMS_HEARINGrow = 28 Posting record Param Type = n trn_rcms_hearingid=16673000012326 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n pre_case_purpose=1000497 Param Type = c trn_rcms_caseid=16320000011490 Param Type = c court_code=10408 Param Type = c case_no=2025/283 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=1000497 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = n trn_rcms_hearingrow=28 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 29 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012327 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 1 pre_hear_date = 26/02/2026 pre_case_purpose = 1000497 trn_rcms_caseid = 16408000012201 court_code = 10408 case_no = 2025/284 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 1000497 next_hear_date = 02/04/2026 TRN_RCMS_HEARINGrow = 29 Posting record Param Type = n trn_rcms_hearingid=16673000012327 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n pre_case_purpose=1000497 Param Type = c trn_rcms_caseid=16408000012201 Param Type = c court_code=10408 Param Type = c case_no=2025/284 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=1000497 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = n trn_rcms_hearingrow=29 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 30 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012328 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 adjourn_remark = new_case_purpose = 1000497 pre_case_purpose = 1000497 isadjourn = NO next_hear_date = 02/04/2026 case_no = 2025/285 court_code = 10408 pre_hear_date = 26/02/2026 trn_rcms_caseid = 16634000010473 adjourn_type = 0 TRN_RCMS_HEARINGrow = 30 Posting record Param Type = n trn_rcms_hearingid=16673000012328 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c new_case_purpose=1000497 Param Type = n pre_case_purpose=1000497 Param Type = c isadjourn=NO Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c case_no=2025/285 Param Type = c court_code=10408 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = c trn_rcms_caseid=16634000010473 Param Type = c adjourn_type=0 Param Type = n trn_rcms_hearingrow=30 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,new_case_purpose,pre_case_purpose,isadjourn,next_hear_date,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:new_case_purpose,:pre_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:adjourn_type,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 11 Adding new record to store data from Frame 2, Row 31 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012329 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 1 Select sysdate as sdt from dual Time elapsed = 2 trn_rcms_caseid = 16752000010990 case_no = 2025/286 pre_case_purpose = 1000497 pre_hear_date = 26/02/2026 next_hear_date = 02/04/2026 adjourn_type = 0 isadjourn = NO adjourn_remark = court_code = 10408 new_case_purpose = 1000497 TRN_RCMS_HEARINGrow = 31 Posting record Param Type = n trn_rcms_hearingid=16673000012329 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trn_rcms_caseid=16752000010990 Param Type = c case_no=2025/286 Param Type = n pre_case_purpose=1000497 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c court_code=10408 Param Type = c new_case_purpose=1000497 Param Type = n trn_rcms_hearingrow=31 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,case_no,pre_case_purpose,pre_hear_date,next_hear_date,adjourn_type,isadjourn,adjourn_remark,court_code,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,:case_no,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:court_code,:new_case_purpose,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 32 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012330 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 1 Select sysdate as sdt from dual Time elapsed = 1 adjourn_remark = adjourn_type = 0 trn_rcms_caseid = 16844000010926 pre_hear_date = 26/02/2026 court_code = 10408 case_no = 2025/287 next_hear_date = 02/04/2026 isadjourn = NO pre_case_purpose = 1000497 new_case_purpose = 1000497 TRN_RCMS_HEARINGrow = 32 Posting record Param Type = n trn_rcms_hearingid=16673000012330 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c adjourn_type=0 Param Type = c trn_rcms_caseid=16844000010926 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = c court_code=10408 Param Type = c case_no=2025/287 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c isadjourn=NO Param Type = n pre_case_purpose=1000497 Param Type = c new_case_purpose=1000497 Param Type = n trn_rcms_hearingrow=32 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 33 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012331 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 adjourn_type = 0 adjourn_remark = pre_hear_date = 26/02/2026 trn_rcms_caseid = 16941000011597 new_case_purpose = 1000497 pre_case_purpose = 1000497 next_hear_date = 02/04/2026 isadjourn = NO case_no = 2025/288 court_code = 10408 TRN_RCMS_HEARINGrow = 33 Posting record Param Type = n trn_rcms_hearingid=16673000012331 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c adjourn_type=0 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = c trn_rcms_caseid=16941000011597 Param Type = c new_case_purpose=1000497 Param Type = n pre_case_purpose=1000497 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c isadjourn=NO Param Type = c case_no=2025/288 Param Type = c court_code=10408 Param Type = n trn_rcms_hearingrow=33 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,pre_hear_date,trn_rcms_caseid,new_case_purpose,pre_case_purpose,next_hear_date,isadjourn,case_no,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:court_code,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 34 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012332 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 adjourn_type = 0 adjourn_remark = isadjourn = NO trn_rcms_caseid = 17111000010940 case_no = 2025/289 court_code = 10408 pre_hear_date = 26/02/2026 next_hear_date = 02/04/2026 new_case_purpose = 1000497 pre_case_purpose = 1000497 TRN_RCMS_HEARINGrow = 34 Posting record Param Type = n trn_rcms_hearingid=16673000012332 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c trn_rcms_caseid=17111000010940 Param Type = c case_no=2025/289 Param Type = c court_code=10408 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c new_case_purpose=1000497 Param Type = n pre_case_purpose=1000497 Param Type = n trn_rcms_hearingrow=34 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 35 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012333 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 isadjourn = NO adjourn_type = 0 adjourn_remark = case_no = 2025/290 court_code = 10408 pre_hear_date = 26/02/2026 trn_rcms_caseid = 17209000013175 next_hear_date = 02/04/2026 new_case_purpose = 1000497 pre_case_purpose = 1000497 TRN_RCMS_HEARINGrow = 35 Posting record Param Type = n trn_rcms_hearingid=16673000012333 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c case_no=2025/290 Param Type = c court_code=10408 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = c trn_rcms_caseid=17209000013175 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c new_case_purpose=1000497 Param Type = n pre_case_purpose=1000497 Param Type = n trn_rcms_hearingrow=35 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,case_no,court_code,pre_hear_date,trn_rcms_caseid,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 36 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012334 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 isadjourn = NO adjourn_remark = adjourn_type = 0 next_hear_date = 02/04/2026 trn_rcms_caseid = 17277000011347 case_no = 2025/291 court_code = 10408 new_case_purpose = 1000497 pre_case_purpose = 1000497 pre_hear_date = 26/02/2026 TRN_RCMS_HEARINGrow = 36 Posting record Param Type = n trn_rcms_hearingid=16673000012334 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c trn_rcms_caseid=17277000011347 Param Type = c case_no=2025/291 Param Type = c court_code=10408 Param Type = c new_case_purpose=1000497 Param Type = n pre_case_purpose=1000497 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n trn_rcms_hearingrow=36 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 37 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012335 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 02/04/2026 isadjourn = NO adjourn_remark = adjourn_type = 0 trn_rcms_caseid = 17382000011807 court_code = 10408 case_no = 2025/292 new_case_purpose = 1000497 pre_case_purpose = 1000497 pre_hear_date = 26/02/2026 TRN_RCMS_HEARINGrow = 37 Posting record Param Type = n trn_rcms_hearingid=16673000012335 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c trn_rcms_caseid=17382000011807 Param Type = c court_code=10408 Param Type = c case_no=2025/292 Param Type = c new_case_purpose=1000497 Param Type = n pre_case_purpose=1000497 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n trn_rcms_hearingrow=37 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,court_code,case_no,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:court_code,:case_no,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 38 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012336 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 02/04/2026 isadjourn = NO adjourn_remark = adjourn_type = 0 new_case_purpose = 1000497 case_no = 2025/293 court_code = 10408 trn_rcms_caseid = 17459000011194 pre_case_purpose = 1000497 pre_hear_date = 26/02/2026 TRN_RCMS_HEARINGrow = 38 Posting record Param Type = n trn_rcms_hearingid=16673000012336 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c new_case_purpose=1000497 Param Type = c case_no=2025/293 Param Type = c court_code=10408 Param Type = c trn_rcms_caseid=17459000011194 Param Type = n pre_case_purpose=1000497 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n trn_rcms_hearingrow=38 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 39 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012337 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 02/04/2026 new_case_purpose = 1000492 adjourn_remark = adjourn_type = 0 isadjourn = NO case_no = 2026/46 court_code = 10408 trn_rcms_caseid = 18837000010220 pre_case_purpose = 1000492 pre_hear_date = 26/02/2026 TRN_RCMS_HEARINGrow = 39 Posting record Param Type = n trn_rcms_hearingid=16673000012337 Param Type = n trn_rcms_mhearingid=16673000012298 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=02/04/2026 00:00:00 Param Type = c new_case_purpose=1000492 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c case_no=2026/46 Param Type = c court_code=10408 Param Type = c trn_rcms_caseid=18837000010220 Param Type = n pre_case_purpose=1000492 Param Type = c pre_hear_date=26/02/2026 00:00:00 Param Type = n trn_rcms_hearingrow=39 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_remark,adjourn_type,isadjourn,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,null,:adjourn_type,:isadjourn,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) Time elapsed for insert/update = 3981291361211 >>Executing genmaps >>Posting from trcmf to tchdh from row 1 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 18707000005842 idvalue 0 Mapped case_no Row = 1 value = 2021/271 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ??? idvalue 0 Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0 Mapped hearing_date Row = 1 value = 23/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 18707000005842 case_no = 2021/271 prev_hearing_date = 26/02/2026 hearing_date = 23/04/2026 prev_case_purposename = ??? prev_case_purpose = prev_case_purposename=??? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=??? Time elapsed = 3 prev_case_purpose after validation = 18473000000000 case_purpose = 18473000000000 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 2 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012338 MapName trcmf1 SourceId 16673000012299 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 18473000000000 hearing_date = 23/04/2026 case_no = 2021/271 trn_rcms_caseregid = 18707000005842 court_code = 10408 case_purpose = 18473000000000 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012338 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012299 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:03 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=18473000000000 Param Type = c hearing_date=23/04/2026 00:00:00 Param Type = c case_no=2021/271 Param Type = c trn_rcms_caseregid=18707000005842 Param Type = c court_code=10408 Param Type = c case_purpose=18473000000000 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 2 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 18717000006149 idvalue 0 Mapped case_no Row = 1 value = 2021/272 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ??? idvalue 0 Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0 Mapped hearing_date Row = 1 value = 23/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 18717000006149 case_no = 2021/272 prev_hearing_date = 26/02/2026 hearing_date = 23/04/2026 prev_case_purposename = ??? prev_case_purpose = prev_case_purpose after validation = 18473000000000 case_purpose = 18473000000000 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012339 MapName trcmf1 SourceId 16673000012300 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 18473000000000 hearing_date = 23/04/2026 case_no = 2021/272 trn_rcms_caseregid = 18717000006149 court_code = 10408 case_purpose = 18473000000000 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012339 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012300 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:05 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:05 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=18473000000000 Param Type = c hearing_date=23/04/2026 00:00:00 Param Type = c case_no=2021/272 Param Type = c trn_rcms_caseregid=18717000006149 Param Type = c court_code=10408 Param Type = c case_purpose=18473000000000 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 3 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 18727000006370 idvalue 0 Mapped case_no Row = 1 value = 2021/273 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ??? idvalue 0 Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0 Mapped hearing_date Row = 1 value = 23/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 18727000006370 case_no = 2021/273 prev_hearing_date = 26/02/2026 hearing_date = 23/04/2026 prev_case_purposename = ??? prev_case_purpose = prev_case_purpose after validation = 18473000000000 case_purpose = 18473000000000 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 2 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012340 MapName trcmf1 SourceId 16673000012301 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 18473000000000 hearing_date = 23/04/2026 case_no = 2021/273 trn_rcms_caseregid = 18727000006370 court_code = 10408 case_purpose = 18473000000000 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012340 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012301 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:06 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:06 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=18473000000000 Param Type = c hearing_date=23/04/2026 00:00:00 Param Type = c case_no=2021/273 Param Type = c trn_rcms_caseregid=18727000006370 Param Type = c court_code=10408 Param Type = c case_purpose=18473000000000 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 4 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 10837000006102 idvalue 0 Mapped case_no Row = 1 value = 2022/52 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0 Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0 Mapped hearing_date Row = 1 value = 23/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 10837000006102 case_no = 2022/52 prev_hearing_date = 26/02/2026 hearing_date = 23/04/2026 prev_case_purposename = ???? ????????? ???? prev_case_purpose = prev_case_purposename=???? ????????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=???? ????????? ???? Time elapsed = 3 prev_case_purpose after validation = 12555000000002 case_purpose = 12555000000002 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 2 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012341 MapName trcmf1 SourceId 16673000012302 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 12555000000002 hearing_date = 23/04/2026 case_no = 2022/52 trn_rcms_caseregid = 10837000006102 court_code = 10408 case_purpose = 12555000000002 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012341 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012302 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:07 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=12555000000002 Param Type = c hearing_date=23/04/2026 00:00:00 Param Type = c case_no=2022/52 Param Type = c trn_rcms_caseregid=10837000006102 Param Type = c court_code=10408 Param Type = c case_purpose=12555000000002 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 5 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 10874000006216 idvalue 0 Mapped case_no Row = 1 value = 2022/53 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0 Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0 Mapped hearing_date Row = 1 value = 23/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 10874000006216 case_no = 2022/53 prev_hearing_date = 26/02/2026 hearing_date = 23/04/2026 prev_case_purposename = ???? ????????? ???? prev_case_purpose = prev_case_purpose after validation = 12555000000002 case_purpose = 12555000000002 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012342 MapName trcmf1 SourceId 16673000012303 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 3 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 12555000000002 hearing_date = 23/04/2026 case_no = 2022/53 trn_rcms_caseregid = 10874000006216 court_code = 10408 case_purpose = 12555000000002 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012342 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012303 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:07 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=12555000000002 Param Type = c hearing_date=23/04/2026 00:00:00 Param Type = c case_no=2022/53 Param Type = c trn_rcms_caseregid=10874000006216 Param Type = c court_code=10408 Param Type = c case_purpose=12555000000002 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 6 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 10336000007910 idvalue 0 Mapped case_no Row = 1 value = 2023/101 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ??? idvalue 0 Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0 Mapped hearing_date Row = 1 value = 19/03/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 10336000007910 case_no = 2023/101 prev_hearing_date = 26/02/2026 hearing_date = 19/03/2026 prev_case_purposename = ??? prev_case_purpose = prev_case_purposename=??? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=??? Time elapsed = 3 prev_case_purpose after validation = 18473000000000 case_purpose = 18473000000000 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 14 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012343 MapName trcmf1 SourceId 16673000012304 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 18473000000000 hearing_date = 19/03/2026 case_no = 2023/101 trn_rcms_caseregid = 10336000007910 court_code = 10408 case_purpose = 18473000000000 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012343 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012304 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:08 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:08 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=18473000000000 Param Type = c hearing_date=19/03/2026 00:00:00 Param Type = c case_no=2023/101 Param Type = c trn_rcms_caseregid=10336000007910 Param Type = c court_code=10408 Param Type = c case_purpose=18473000000000 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 7 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 16137000007565 idvalue 0 Mapped case_no Row = 1 value = 2023/11 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ??? idvalue 0 Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0 Mapped hearing_date Row = 1 value = 19/03/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 16137000007565 case_no = 2023/11 prev_hearing_date = 26/02/2026 hearing_date = 19/03/2026 prev_case_purposename = ??? prev_case_purpose = prev_case_purpose after validation = 18473000000000 case_purpose = 18473000000000 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 2 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012344 MapName trcmf1 SourceId 16673000012305 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 18473000000000 hearing_date = 19/03/2026 case_no = 2023/11 trn_rcms_caseregid = 16137000007565 court_code = 10408 case_purpose = 18473000000000 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012344 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012305 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:09 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:09 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=18473000000000 Param Type = c hearing_date=19/03/2026 00:00:00 Param Type = c case_no=2023/11 Param Type = c trn_rcms_caseregid=16137000007565 Param Type = c court_code=10408 Param Type = c case_purpose=18473000000000 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 8 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 12999000008381 idvalue 0 Mapped case_no Row = 1 value = 2024/39 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ??? idvalue 0 Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0 Mapped hearing_date Row = 1 value = 19/03/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 12999000008381 case_no = 2024/39 prev_hearing_date = 26/02/2026 hearing_date = 19/03/2026 prev_case_purposename = ??? prev_case_purpose = prev_case_purpose after validation = 18473000000000 case_purpose = 18473000000000 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 13 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 14 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012345 MapName trcmf1 SourceId 16673000012306 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 18473000000000 hearing_date = 19/03/2026 case_no = 2024/39 trn_rcms_caseregid = 12999000008381 court_code = 10408 case_purpose = 18473000000000 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012345 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012306 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:10 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:10 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=18473000000000 Param Type = c hearing_date=19/03/2026 00:00:00 Param Type = c case_no=2024/39 Param Type = c trn_rcms_caseregid=12999000008381 Param Type = c court_code=10408 Param Type = c case_purpose=18473000000000 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 9 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 11347000010187 idvalue 0 Mapped case_no Row = 1 value = 2025/131 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 11347000010187 case_no = 2025/131 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purposename=???? ????????? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=???? ????????? Time elapsed = 4 prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012346 MapName trcmf1 SourceId 16673000012307 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/131 trn_rcms_caseregid = 11347000010187 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012346 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012307 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:11 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:11 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/131 Param Type = c trn_rcms_caseregid=11347000010187 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 10 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 11358000011229 idvalue 0 Mapped case_no Row = 1 value = 2025/132 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 11358000011229 case_no = 2025/132 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 2 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012347 MapName trcmf1 SourceId 16673000012308 Select sysdate as sdt from dual Time elapsed = 14 Select sysdate as sdt from dual Time elapsed = 3 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/132 trn_rcms_caseregid = 11358000011229 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012347 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012308 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:11 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:11 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/132 Param Type = c trn_rcms_caseregid=11358000011229 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 11 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 11375000009797 idvalue 0 Mapped case_no Row = 1 value = 2025/133 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 11375000009797 case_no = 2025/133 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012348 MapName trcmf1 SourceId 16673000012309 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 3 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/133 trn_rcms_caseregid = 11375000009797 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012348 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012309 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:12 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:12 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/133 Param Type = c trn_rcms_caseregid=11375000009797 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 12 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 11386000011091 idvalue 0 Mapped case_no Row = 1 value = 2025/134 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 11386000011091 case_no = 2025/134 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012349 MapName trcmf1 SourceId 16673000012310 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/134 trn_rcms_caseregid = 11386000011091 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012349 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012310 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:13 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:13 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/134 Param Type = c trn_rcms_caseregid=11386000011091 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 13 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 11393000009925 idvalue 0 Mapped case_no Row = 1 value = 2025/135 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 11393000009925 case_no = 2025/135 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012350 MapName trcmf1 SourceId 16673000012311 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/135 trn_rcms_caseregid = 11393000009925 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012350 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012311 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:14 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:14 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/135 Param Type = c trn_rcms_caseregid=11393000009925 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 14 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 11402000011426 idvalue 0 Mapped case_no Row = 1 value = 2025/136 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 11402000011426 case_no = 2025/136 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012351 MapName trcmf1 SourceId 16673000012312 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/136 trn_rcms_caseregid = 11402000011426 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012351 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012312 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:15 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:15 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/136 Param Type = c trn_rcms_caseregid=11402000011426 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 15 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 11419000010586 idvalue 0 Mapped case_no Row = 1 value = 2025/137 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 11419000010586 case_no = 2025/137 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 2 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012352 MapName trcmf1 SourceId 16673000012313 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/137 trn_rcms_caseregid = 11419000010586 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012352 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012313 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:15 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:15 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/137 Param Type = c trn_rcms_caseregid=11419000010586 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 16 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 11433000010412 idvalue 0 Mapped case_no Row = 1 value = 2025/138 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 11433000010412 case_no = 2025/138 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012353 MapName trcmf1 SourceId 16673000012314 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/138 trn_rcms_caseregid = 11433000010412 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012353 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012314 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:16 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:16 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/138 Param Type = c trn_rcms_caseregid=11433000010412 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 17 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 11441000010285 idvalue 0 Mapped case_no Row = 1 value = 2025/139 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 11441000010285 case_no = 2025/139 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 14 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012354 MapName trcmf1 SourceId 16673000012315 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/139 trn_rcms_caseregid = 11441000010285 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012354 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012315 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:17 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/139 Param Type = c trn_rcms_caseregid=11441000010285 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 18 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 15494000011531 idvalue 0 Mapped case_no Row = 1 value = 2025/273 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 15494000011531 case_no = 2025/273 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012355 MapName trcmf1 SourceId 16673000012316 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/273 trn_rcms_caseregid = 15494000011531 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012355 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012316 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:18 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/273 Param Type = c trn_rcms_caseregid=15494000011531 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 19 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 15629000010911 idvalue 0 Mapped case_no Row = 1 value = 2025/274 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 15629000010911 case_no = 2025/274 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012356 MapName trcmf1 SourceId 16673000012317 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/274 trn_rcms_caseregid = 15629000010911 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012356 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012317 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:18 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/274 Param Type = c trn_rcms_caseregid=15629000010911 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 20 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 15725000010908 idvalue 0 Mapped case_no Row = 1 value = 2025/275 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 15725000010908 case_no = 2025/275 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 2 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012357 MapName trcmf1 SourceId 16673000012318 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/275 trn_rcms_caseregid = 15725000010908 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012357 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012318 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:19 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:19 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/275 Param Type = c trn_rcms_caseregid=15725000010908 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 21 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 15795000012169 idvalue 0 Mapped case_no Row = 1 value = 2025/276 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 15795000012169 case_no = 2025/276 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012358 MapName trcmf1 SourceId 16673000012319 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/276 trn_rcms_caseregid = 15795000012169 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012358 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012319 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:20 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:20 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/276 Param Type = c trn_rcms_caseregid=15795000012169 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 22 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 15867000010975 idvalue 0 Mapped case_no Row = 1 value = 2025/277 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 15867000010975 case_no = 2025/277 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 6 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012359 MapName trcmf1 SourceId 16673000012320 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/277 trn_rcms_caseregid = 15867000010975 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012359 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012320 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:21 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:21 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/277 Param Type = c trn_rcms_caseregid=15867000010975 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 23 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 15947000009082 idvalue 0 Mapped case_no Row = 1 value = 2025/278 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 15947000009082 case_no = 2025/278 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012360 MapName trcmf1 SourceId 16673000012321 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/278 trn_rcms_caseregid = 15947000009082 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012360 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012321 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:22 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:22 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/278 Param Type = c trn_rcms_caseregid=15947000009082 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 24 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 16017000012016 idvalue 0 Mapped case_no Row = 1 value = 2025/279 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 16017000012016 case_no = 2025/279 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012361 MapName trcmf1 SourceId 16673000012322 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/279 trn_rcms_caseregid = 16017000012016 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012361 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012322 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:22 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:22 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/279 Param Type = c trn_rcms_caseregid=16017000012016 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 25 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 16081000010788 idvalue 0 Mapped case_no Row = 1 value = 2025/280 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 16081000010788 case_no = 2025/280 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 2 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012362 MapName trcmf1 SourceId 16673000012323 Select sysdate as sdt from dual Time elapsed = 1 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/280 trn_rcms_caseregid = 16081000010788 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012362 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012323 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:23 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:23 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/280 Param Type = c trn_rcms_caseregid=16081000010788 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 26 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 16161000010505 idvalue 0 Mapped case_no Row = 1 value = 2025/281 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 16161000010505 case_no = 2025/281 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012363 MapName trcmf1 SourceId 16673000012324 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/281 trn_rcms_caseregid = 16161000010505 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012363 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012324 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:24 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:24 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/281 Param Type = c trn_rcms_caseregid=16161000010505 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 27 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 16253000011856 idvalue 0 Mapped case_no Row = 1 value = 2025/282 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 16253000011856 case_no = 2025/282 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012364 MapName trcmf1 SourceId 16673000012325 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 3 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/282 trn_rcms_caseregid = 16253000011856 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012364 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012325 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:25 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:25 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/282 Param Type = c trn_rcms_caseregid=16253000011856 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 28 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 16320000011490 idvalue 0 Mapped case_no Row = 1 value = 2025/283 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 16320000011490 case_no = 2025/283 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012365 MapName trcmf1 SourceId 16673000012326 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/283 trn_rcms_caseregid = 16320000011490 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012365 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012326 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:26 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:26 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/283 Param Type = c trn_rcms_caseregid=16320000011490 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 29 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 16408000012201 idvalue 0 Mapped case_no Row = 1 value = 2025/284 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 16408000012201 case_no = 2025/284 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012366 MapName trcmf1 SourceId 16673000012327 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 3 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/284 trn_rcms_caseregid = 16408000012201 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012366 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012327 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:26 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:26 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/284 Param Type = c trn_rcms_caseregid=16408000012201 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 30 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 16634000010473 idvalue 0 Mapped case_no Row = 1 value = 2025/285 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 16634000010473 case_no = 2025/285 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012367 MapName trcmf1 SourceId 16673000012328 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/285 trn_rcms_caseregid = 16634000010473 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012367 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012328 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:27 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:27 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/285 Param Type = c trn_rcms_caseregid=16634000010473 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 31 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 16752000010990 idvalue 0 Mapped case_no Row = 1 value = 2025/286 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 16752000010990 case_no = 2025/286 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 2 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012368 MapName trcmf1 SourceId 16673000012329 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/286 trn_rcms_caseregid = 16752000010990 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012368 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012329 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:28 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:28 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/286 Param Type = c trn_rcms_caseregid=16752000010990 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 32 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 16844000010926 idvalue 0 Mapped case_no Row = 1 value = 2025/287 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 16844000010926 case_no = 2025/287 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012369 MapName trcmf1 SourceId 16673000012330 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/287 trn_rcms_caseregid = 16844000010926 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012369 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012330 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:29 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:29 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/287 Param Type = c trn_rcms_caseregid=16844000010926 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 33 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 16941000011597 idvalue 0 Mapped case_no Row = 1 value = 2025/288 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 16941000011597 case_no = 2025/288 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012370 MapName trcmf1 SourceId 16673000012331 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/288 trn_rcms_caseregid = 16941000011597 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012370 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012331 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:30 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:30 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/288 Param Type = c trn_rcms_caseregid=16941000011597 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 34 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 17111000010940 idvalue 0 Mapped case_no Row = 1 value = 2025/289 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 17111000010940 case_no = 2025/289 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 4 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 2 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012371 MapName trcmf1 SourceId 16673000012332 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/289 trn_rcms_caseregid = 17111000010940 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012371 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012332 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:31 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:31 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/289 Param Type = c trn_rcms_caseregid=17111000010940 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 35 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 17209000013175 idvalue 0 Mapped case_no Row = 1 value = 2025/290 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 17209000013175 case_no = 2025/290 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012372 MapName trcmf1 SourceId 16673000012333 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/290 trn_rcms_caseregid = 17209000013175 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012372 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012333 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:31 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:31 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/290 Param Type = c trn_rcms_caseregid=17209000013175 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 36 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 17277000011347 idvalue 0 Mapped case_no Row = 1 value = 2025/291 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 17277000011347 case_no = 2025/291 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 2 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 2 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 16673000012373 MapName trcmf1 SourceId 16673000012334 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/291 trn_rcms_caseregid = 17277000011347 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012373 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012334 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:32 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:32 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/291 Param Type = c trn_rcms_caseregid=17277000011347 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 37 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 17382000011807 idvalue 0 Mapped case_no Row = 1 value = 2025/292 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 17382000011807 case_no = 2025/292 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012374 MapName trcmf1 SourceId 16673000012335 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 3 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/292 trn_rcms_caseregid = 17382000011807 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012374 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012335 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:33 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:33 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/292 Param Type = c trn_rcms_caseregid=17382000011807 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 38 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 17459000011194 idvalue 0 Mapped case_no Row = 1 value = 2025/293 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0 Mapped case_purpose Row = 1 value = 1000497 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 17459000011194 case_no = 2025/293 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ???? ????????? prev_case_purpose = prev_case_purpose after validation = 1000497 case_purpose = 1000497 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16673000012375 MapName trcmf1 SourceId 16673000012336 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000497 hearing_date = 02/04/2026 case_no = 2025/293 trn_rcms_caseregid = 17459000011194 court_code = 10408 case_purpose = 1000497 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012375 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012336 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:34 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:34 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000497 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2025/293 Param Type = c trn_rcms_caseregid=17459000011194 Param Type = c court_code=10408 Param Type = c case_purpose=1000497 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from trcmf to tchdh from row 39 >>Mapping Mapped court_code Row = 1 value = 10408 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 18837000010220 idvalue 0 Mapped case_no Row = 1 value = 2026/46 idvalue 0 Mapped prev_hearing_date Row = 1 value = 26/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ????? idvalue 0 Mapped case_purpose Row = 1 value = 1000492 idvalue 0 Mapped hearing_date Row = 1 value = 02/04/2026 idvalue 0 Mapped isadjourn Row = 1 value = NO idvalue 0 Mapped adjourn_type Row = 1 value = 0 idvalue 0 Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0 >>Validating tchdh >>Frame No 1 court_code = 10408 trn_rcms_caseregid = 18837000010220 case_no = 2026/46 prev_hearing_date = 26/02/2026 hearing_date = 02/04/2026 prev_case_purposename = ????? prev_case_purpose = prev_case_purposename=????? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=????? Time elapsed = 3 prev_case_purpose after validation = 1000492 case_purpose = 1000492 trans_type = Feedback Submitted (Custom) clcheck = isadjourn = NO adjourn_type = 0 decision_type = decision_date = >>Writing to tables tchdh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh' Time elapsed = 1 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16673000012376 MapName trcmf1 SourceId 16673000012337 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000492 hearing_date = 02/04/2026 case_no = 2026/46 trn_rcms_caseregid = 18837000010220 court_code = 10408 case_purpose = 1000492 prev_hearing_date = 26/02/2026 Posting record Param Type = n trn_rcms_case_histid=16673000012376 Param Type = c mapname=trcmf1 Param Type = n sourceid=16673000012337 Param Type = c cancel=F Param Type = c createdby=DM_Sirohi_PRO Param Type = c createdon=26/02/2026 18:16:35 Param Type = c username=DM_Sirohi_PRO Param Type = c modifiedon=26/02/2026 18:16:35 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_type=Feedback Submitted (Custom) Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n decision_type=0 Param Type = c prev_case_purpose=1000492 Param Type = c hearing_date=02/04/2026 00:00:00 Param Type = c case_no=2026/46 Param Type = c trn_rcms_caseregid=18837000010220 Param Type = c court_code=10408 Param Type = c case_purpose=1000492 Param Type = c prev_hearing_date=26/02/2026 00:00:00 insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) Time elapsed for Gen Map = 3981291393151 Time elapsed for MD Map = 3981291393151 Time elapsed for Save History = 3981291393151 Time elapsed for Save Attachment = 3981291393152 Time elapsed for After Save WF Exec = 3981291393166 Transaction commited Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"16673000012298"}]} Savedata webservice completed Freeing DbCall Resources Freeing Store data Freeing DD Map Freeing Provide Link Freeing Validate Freeing Parser Freeing Poststr Freeing Maxrows Freeing Fnames Freeing NewMaxRows Freeing tlines Freeing workquery Freeing Struct Freeing EventList Freeing Tree Obj Freeing Workflow Obj Freeing DbCall Completed Freeing Action Obj Resources Closing connection # 1#Saving to log Param Type = c username=DM_Sirohi_PRO Param Type = c calledon=26/02/2026 18:15:59 Param Type = c callfinished=26/02/2026 18:16:33 Param Type = c structname=trcmf Param Type = n recordid=0 Param Type = c servicename=Saving data Param Type = c serviceresult=success Param Type = n timetaken=33260 Param Type = n dbtimetaken=31878 insert into axmwslog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken) values (null,:username,to_date(:calledon,'dd/mm/yyyy hh24:mi:ss'),to_date(:callfinished,'dd/mm/yyyy hh24:mi:ss'),:structname,:recordid,:servicename,:serviceresult,:timetaken,:dbtimetaken) Freeing AxProvider Resources Freeing DbManager Resources