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 gcmsSDO_Tapukada_PRO827ccb0eea8a706c4c34a16891f84e7btrcmf001822327/02/20260182232023/112014071000010640???? ????????? ????27/02/20261255500000000210/07/202612555000000002NO00182232024/59419453000010991????27/02/20261867800000000003/07/202618678000000000NO00182232024/59519493000009630????27/02/20261867800000000003/07/202618678000000000NO00182232025/58714430000011844?????27/02/2026100049203/07/20261000492NO00182232025/58815185000009689?????27/02/2026100049203/07/20261000492NO00182232025/61514367000010430?????27/02/2026100049219/06/20261000492NO00182232025/90315794000011861?????27/02/2026100049230/03/20261000492NO00182232025/93210110000012303?????27/02/2026100049223/03/20261000492NO00182232025/93310308000011376?????27/02/2026100049223/03/20261000492NO00182232025/98213794000011207?????27/02/2026100049215/05/20261000492NO00182232025/13812396000010099????27/02/20261867800000000012/06/202618678000000000NO00182232025/13912738000010162????27/02/20261867800000000012/06/202618678000000000NO00182232025/35913616000011044????27/02/20261867800000000003/07/202618678000000000NO00182232025/36013674000012037????27/02/20261867800000000003/07/202618678000000000NO00182232025/53013873000010518????27/02/20261867800000000019/06/202618678000000000NO00182232025/53113965000010690????27/02/20261867800000000019/06/202618678000000000NO00182232025/54219586000012600????27/02/20261867800000000005/06/202618678000000000NO00182232025/54319707000009610????27/02/20261867800000000005/06/202618678000000000NO00182232025/75513740000011304????27/02/20261867800000000024/04/202618678000000000NO00182232026/2112538000010540?????27/02/2026100049222/05/20261000492NO00182232026/6218682000012322?????27/02/2026100049229/05/20261000492NO0 Executing Savedata webservice ----------------------------- Received JSON : {"savedata":{"axpapp":"gcms","username":"SDO_Tapukada_PRO","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"trcmf","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtcode":"18223","hearing_date":"27/02/2026"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"court_code":"18223","case_no":"2023/1120","trn_rcms_caseid":"14071000010640","pre_case_purpose_name":"???? ????????? ????","pre_hear_date":"27/02/2026","pre_case_purpose":"12555000000002","next_hear_date":"10/07/2026","new_case_purpose":"12555000000002","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"002","text":"0","columns":{"court_code":"18223","case_no":"2024/594","trn_rcms_caseid":"19453000010991","pre_case_purpose_name":"????","pre_hear_date":"27/02/2026","pre_case_purpose":"18678000000000","next_hear_date":"03/07/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"003","text":"0","columns":{"court_code":"18223","case_no":"2024/595","trn_rcms_caseid":"19493000009630","pre_case_purpose_name":"????","pre_hear_date":"27/02/2026","pre_case_purpose":"18678000000000","next_hear_date":"03/07/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"004","text":"0","columns":{"court_code":"18223","case_no":"2025/587","trn_rcms_caseid":"14430000011844","pre_case_purpose_name":"?????","pre_hear_date":"27/02/2026","pre_case_purpose":"1000492","next_hear_date":"03/07/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"005","text":"0","columns":{"court_code":"18223","case_no":"2025/588","trn_rcms_caseid":"15185000009689","pre_case_purpose_name":"?????","pre_hear_date":"27/02/2026","pre_case_purpose":"1000492","next_hear_date":"03/07/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"006","text":"0","columns":{"court_code":"18223","case_no":"2025/615","trn_rcms_caseid":"14367000010430","pre_case_purpose_name":"?????","pre_hear_date":"27/02/2026","pre_case_purpose":"1000492","next_hear_date":"19/06/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"007","text":"0","columns":{"court_code":"18223","case_no":"2025/903","trn_rcms_caseid":"15794000011861","pre_case_purpose_name":"?????","pre_hear_date":"27/02/2026","pre_case_purpose":"1000492","next_hear_date":"30/03/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"008","text":"0","columns":{"court_code":"18223","case_no":"2025/932","trn_rcms_caseid":"10110000012303","pre_case_purpose_name":"?????","pre_hear_date":"27/02/2026","pre_case_purpose":"1000492","next_hear_date":"23/03/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"009","text":"0","columns":{"court_code":"18223","case_no":"2025/933","trn_rcms_caseid":"10308000011376","pre_case_purpose_name":"?????","pre_hear_date":"27/02/2026","pre_case_purpose":"1000492","next_hear_date":"23/03/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0010","text":"0","columns":{"court_code":"18223","case_no":"2025/982","trn_rcms_caseid":"13794000011207","pre_case_purpose_name":"?????","pre_hear_date":"27/02/2026","pre_case_purpose":"1000492","next_hear_date":"15/05/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0011","text":"0","columns":{"court_code":"18223","case_no":"2025/138","trn_rcms_caseid":"12396000010099","pre_case_purpose_name":"????","pre_hear_date":"27/02/2026","pre_case_purpose":"18678000000000","next_hear_date":"12/06/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0012","text":"0","columns":{"court_code":"18223","case_no":"2025/139","trn_rcms_caseid":"12738000010162","pre_case_purpose_name":"????","pre_hear_date":"27/02/2026","pre_case_purpose":"18678000000000","next_hear_date":"12/06/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0013","text":"0","columns":{"court_code":"18223","case_no":"2025/359","trn_rcms_caseid":"13616000011044","pre_case_purpose_name":"????","pre_hear_date":"27/02/2026","pre_case_purpose":"18678000000000","next_hear_date":"03/07/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0014","text":"0","columns":{"court_code":"18223","case_no":"2025/360","trn_rcms_caseid":"13674000012037","pre_case_purpose_name":"????","pre_hear_date":"27/02/2026","pre_case_purpose":"18678000000000","next_hear_date":"03/07/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0015","text":"0","columns":{"court_code":"18223","case_no":"2025/530","trn_rcms_caseid":"13873000010518","pre_case_purpose_name":"????","pre_hear_date":"27/02/2026","pre_case_purpose":"18678000000000","next_hear_date":"19/06/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0016","text":"0","columns":{"court_code":"18223","case_no":"2025/531","trn_rcms_caseid":"13965000010690","pre_case_purpose_name":"????","pre_hear_date":"27/02/2026","pre_case_purpose":"18678000000000","next_hear_date":"19/06/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0017","text":"0","columns":{"court_code":"18223","case_no":"2025/542","trn_rcms_caseid":"19586000012600","pre_case_purpose_name":"????","pre_hear_date":"27/02/2026","pre_case_purpose":"18678000000000","next_hear_date":"05/06/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0018","text":"0","columns":{"court_code":"18223","case_no":"2025/543","trn_rcms_caseid":"19707000009610","pre_case_purpose_name":"????","pre_hear_date":"27/02/2026","pre_case_purpose":"18678000000000","next_hear_date":"05/06/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0019","text":"0","columns":{"court_code":"18223","case_no":"2025/755","trn_rcms_caseid":"13740000011304","pre_case_purpose_name":"????","pre_hear_date":"27/02/2026","pre_case_purpose":"18678000000000","next_hear_date":"24/04/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0020","text":"0","columns":{"court_code":"18223","case_no":"2026/21","trn_rcms_caseid":"12538000010540","pre_case_purpose_name":"?????","pre_hear_date":"27/02/2026","pre_case_purpose":"1000492","next_hear_date":"22/05/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0021","text":"0","columns":{"court_code":"18223","case_no":"2026/62","trn_rcms_caseid":"18682000012322","pre_case_purpose_name":"?????","pre_hear_date":"27/02/2026","pre_case_purpose":"1000492","next_hear_date":"29/05/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}}]}]}} Verifying username and password User Name : SDO_Tapukada_PRO Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app' U=sdo_tapukada_pro Time elapsed = 13 Password checking along with max.no of login specified in app.xml update axusers set logintry = 0 where lower(username) = :U Time elapsed = 4 Result : Verifying completed... Page Access Category : User Name : sdo_tapukada_pro Select sysdate as sdt from dual Time elapsed = 4 dt=09/03/2026 11:15:42 Select sysdate as sdt from dual Time elapsed = 3 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=sdo_tapukada_pro dt=09/03/2026 11:15:42 dt=09/03/2026 11:15:42 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 = 1 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=SDO_Tapukada_PRO select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=SDO_Tapukada_PRO Time elapsed = 4 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=SDO_Tapukada_PRO select a.court_type from v_axcourts a where a.paxusername= :username order by 1 username=SDO_Tapukada_PRO Time elapsed = 4 Result of firesql = Result = Evaluating sqlget({m3},{court_type}) Calling function sqlget Result of sqlget = SDO Result = SDO Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1}) Calling function firesql username=SDO_Tapukada_PRO select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1 username=SDO_Tapukada_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m4},{court_name_mastid}) Calling function sqlget Result of sqlget = 1365880008855 Result = 1365880008855 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=SDO_Tapukada_PRO Time elapsed = 4 Result of firesql = Result = Evaluating sqlget({m4},{axusersid}) Calling function sqlget Result of sqlget = 1658880010032 Result = 1658880010032 Evaluating firesql({m4},{select :username as uname from dual}) Calling function firesql select :username as uname from dual username=SDO_Tapukada_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m4},{uname}) Calling function sqlget Result of sqlget = SDO_Tapukada_PRO Result = SDO_Tapukada_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=SDO_Tapukada_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m4},{COURT_CODE}) Calling function sqlget Result of sqlget = 18223 Result = 18223 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=SDO_Tapukada_PRO SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=SDO_Tapukada_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m7},{DISTNAMEENG}) Calling function sqlget Result of sqlget = Khairthal-Tijara Result = Khairthal-Tijara Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=SDO_Tapukada_PRO SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=SDO_Tapukada_PRO Time elapsed = 3 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=1658880010032 select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid login_userid=1658880010032 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=SDO_Tapukada_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m3},{court_type_mastid}) Calling function sqlget Result of sqlget = 10823000000000 Result = 10823000000000 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=SDO_Tapukada_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=SDO_Tapukada_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=SDO_Tapukada_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=SDO_Tapukada_PRO Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({P1},{ct}) Calling function sqlget Result of sqlget = 2 Result = 2 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 = 5 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 = 3 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 = 2 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 = 18223 hearing_date = 27/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 = 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 = 19721000011428 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 26 hearing_date = 27/02/2026 courtcode = 18223 Posting record Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:42 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:42 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c hearing_date=27/02/2026 00:00:00 Param Type = c courtcode=18223 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 = 14 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 = 19721000011429 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 pre_hear_date = 27/02/2026 pre_case_purpose = 12555000000002 trn_rcms_caseid = 14071000010640 court_code = 18223 case_no = 2023/1120 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 12555000000002 next_hear_date = 10/07/2026 TRN_RCMS_HEARINGrow = 1 Posting record Param Type = n trn_rcms_hearingid=19721000011429 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:42 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:42 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=27/02/2026 00:00:00 Param Type = n pre_case_purpose=12555000000002 Param Type = c trn_rcms_caseid=14071000010640 Param Type = c court_code=18223 Param Type = c case_no=2023/1120 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=12555000000002 Param Type = c next_hear_date=10/07/2026 00:00:00 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,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 2 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 19721000011430 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 pre_hear_date = 27/02/2026 pre_case_purpose = 18678000000000 trn_rcms_caseid = 19453000010991 court_code = 18223 case_no = 2024/594 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 18678000000000 next_hear_date = 03/07/2026 TRN_RCMS_HEARINGrow = 2 Posting record Param Type = n trn_rcms_hearingid=19721000011430 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:42 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:42 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=27/02/2026 00:00:00 Param Type = n pre_case_purpose=18678000000000 Param Type = c trn_rcms_caseid=19453000010991 Param Type = c court_code=18223 Param Type = c case_no=2024/594 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=18678000000000 Param Type = c next_hear_date=03/07/2026 00:00:00 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_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 = 24 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 = 19721000011431 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 3 pre_hear_date = 27/02/2026 pre_case_purpose = 18678000000000 trn_rcms_caseid = 19493000009630 court_code = 18223 case_no = 2024/595 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 18678000000000 next_hear_date = 03/07/2026 TRN_RCMS_HEARINGrow = 3 Posting record Param Type = n trn_rcms_hearingid=19721000011431 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:42 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:42 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=27/02/2026 00:00:00 Param Type = n pre_case_purpose=18678000000000 Param Type = c trn_rcms_caseid=19493000009630 Param Type = c court_code=18223 Param Type = c case_no=2024/595 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=18678000000000 Param Type = c next_hear_date=03/07/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,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 4 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 19721000011432 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 03/07/2026 new_case_purpose = 1000492 isadjourn = NO adjourn_remark = adjourn_type = 0 case_no = 2025/587 court_code = 18223 trn_rcms_caseid = 14430000011844 pre_case_purpose = 1000492 pre_hear_date = 27/02/2026 TRN_RCMS_HEARINGrow = 4 Posting record Param Type = n trn_rcms_hearingid=19721000011432 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=03/07/2026 00:00:00 Param Type = c new_case_purpose=1000492 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c case_no=2025/587 Param Type = c court_code=18223 Param Type = c trn_rcms_caseid=14430000011844 Param Type = n pre_case_purpose=1000492 Param Type = c pre_hear_date=27/02/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,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 5 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 19721000011433 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 1 adjourn_remark = new_case_purpose = 1000492 adjourn_type = 0 next_hear_date = 03/07/2026 isadjourn = NO case_no = 2025/588 court_code = 18223 trn_rcms_caseid = 15185000009689 pre_case_purpose = 1000492 pre_hear_date = 27/02/2026 TRN_RCMS_HEARINGrow = 5 Posting record Param Type = n trn_rcms_hearingid=19721000011433 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c new_case_purpose=1000492 Param Type = c adjourn_type=0 Param Type = c next_hear_date=03/07/2026 00:00:00 Param Type = c isadjourn=NO Param Type = c case_no=2025/588 Param Type = c court_code=18223 Param Type = c trn_rcms_caseid=15185000009689 Param Type = n pre_case_purpose=1000492 Param Type = c pre_hear_date=27/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,adjourn_remark,new_case_purpose,adjourn_type,next_hear_date,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,null,:new_case_purpose,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),: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) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 3 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 = 2 RecordId = 19721000011434 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/06/2026 new_case_purpose = 1000492 adjourn_type = 0 isadjourn = NO pre_case_purpose = 1000492 case_no = 2025/615 trn_rcms_caseid = 14367000010430 pre_hear_date = 27/02/2026 court_code = 18223 adjourn_remark = TRN_RCMS_HEARINGrow = 6 Posting record Param Type = n trn_rcms_hearingid=19721000011434 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=19/06/2026 00:00:00 Param Type = c new_case_purpose=1000492 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n pre_case_purpose=1000492 Param Type = c case_no=2025/615 Param Type = c trn_rcms_caseid=14367000010430 Param Type = c pre_hear_date=27/02/2026 00:00:00 Param Type = c court_code=18223 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,adjourn_type,isadjourn,pre_case_purpose,case_no,trn_rcms_caseid,pre_hear_date,court_code,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,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,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 7 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 19721000011435 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 next_hear_date = 30/03/2026 pre_case_purpose = 1000492 new_case_purpose = 1000492 pre_hear_date = 27/02/2026 court_code = 18223 case_no = 2025/903 trn_rcms_caseid = 15794000011861 adjourn_remark = TRN_RCMS_HEARINGrow = 7 Posting record Param Type = n trn_rcms_hearingid=19721000011435 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 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=30/03/2026 00:00:00 Param Type = n pre_case_purpose=1000492 Param Type = c new_case_purpose=1000492 Param Type = c pre_hear_date=27/02/2026 00:00:00 Param Type = c court_code=18223 Param Type = c case_no=2025/903 Param Type = c trn_rcms_caseid=15794000011861 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,isadjourn,adjourn_type,next_hear_date,pre_case_purpose,new_case_purpose,pre_hear_date,court_code,case_no,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,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,null,: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 8 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 19721000011436 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 pre_hear_date = 27/02/2026 pre_case_purpose = 1000492 trn_rcms_caseid = 10110000012303 court_code = 18223 case_no = 2025/932 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 1000492 next_hear_date = 23/03/2026 TRN_RCMS_HEARINGrow = 8 Posting record Param Type = n trn_rcms_hearingid=19721000011436 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=27/02/2026 00:00:00 Param Type = n pre_case_purpose=1000492 Param Type = c trn_rcms_caseid=10110000012303 Param Type = c court_code=18223 Param Type = c case_no=2025/932 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=1000492 Param Type = c next_hear_date=23/03/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,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 9 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 19721000011437 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 23/03/2026 new_case_purpose = 1000492 isadjourn = NO adjourn_remark = adjourn_type = 0 case_no = 2025/933 court_code = 18223 trn_rcms_caseid = 10308000011376 pre_case_purpose = 1000492 pre_hear_date = 27/02/2026 TRN_RCMS_HEARINGrow = 9 Posting record Param Type = n trn_rcms_hearingid=19721000011437 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=23/03/2026 00:00:00 Param Type = c new_case_purpose=1000492 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c case_no=2025/933 Param Type = c court_code=18223 Param Type = c trn_rcms_caseid=10308000011376 Param Type = n pre_case_purpose=1000492 Param Type = c pre_hear_date=27/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 = 19721000011438 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 case_no = 2025/982 new_case_purpose = 1000492 pre_case_purpose = 1000492 trn_rcms_caseid = 13794000011207 pre_hear_date = 27/02/2026 adjourn_remark = court_code = 18223 adjourn_type = 0 next_hear_date = 15/05/2026 isadjourn = NO TRN_RCMS_HEARINGrow = 10 Posting record Param Type = n trn_rcms_hearingid=19721000011438 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2025/982 Param Type = c new_case_purpose=1000492 Param Type = n pre_case_purpose=1000492 Param Type = c trn_rcms_caseid=13794000011207 Param Type = c pre_hear_date=27/02/2026 00:00:00 Param Type = c court_code=18223 Param Type = c adjourn_type=0 Param Type = c next_hear_date=15/05/2026 00:00:00 Param Type = c isadjourn=NO 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,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,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,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,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 11 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 19721000011439 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 case_no = 2025/138 adjourn_remark = isadjourn = NO next_hear_date = 12/06/2026 court_code = 18223 pre_case_purpose = 18678000000000 new_case_purpose = 18678000000000 pre_hear_date = 27/02/2026 trn_rcms_caseid = 12396000010099 adjourn_type = 0 TRN_RCMS_HEARINGrow = 11 Posting record Param Type = n trn_rcms_hearingid=19721000011439 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2025/138 Param Type = c isadjourn=NO Param Type = c next_hear_date=12/06/2026 00:00:00 Param Type = c court_code=18223 Param Type = n pre_case_purpose=18678000000000 Param Type = c new_case_purpose=18678000000000 Param Type = c pre_hear_date=27/02/2026 00:00:00 Param Type = c trn_rcms_caseid=12396000010099 Param Type = c adjourn_type=0 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,case_no,adjourn_remark,isadjourn,next_hear_date,court_code,pre_case_purpose,new_case_purpose,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,:case_no,null,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:pre_case_purpose,:new_case_purpose,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 = 3 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 = 2 RecordId = 19721000011440 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 3 adjourn_remark = trn_rcms_caseid = 12738000010162 pre_hear_date = 27/02/2026 court_code = 18223 case_no = 2025/139 pre_case_purpose = 18678000000000 isadjourn = NO adjourn_type = 0 new_case_purpose = 18678000000000 next_hear_date = 12/06/2026 TRN_RCMS_HEARINGrow = 12 Posting record Param Type = n trn_rcms_hearingid=19721000011440 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trn_rcms_caseid=12738000010162 Param Type = c pre_hear_date=27/02/2026 00:00:00 Param Type = c court_code=18223 Param Type = c case_no=2025/139 Param Type = n pre_case_purpose=18678000000000 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c new_case_purpose=18678000000000 Param Type = c next_hear_date=12/06/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,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,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,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,: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 13 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 19721000011441 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 3 adjourn_remark = trn_rcms_caseid = 13616000011044 pre_hear_date = 27/02/2026 court_code = 18223 case_no = 2025/359 pre_case_purpose = 18678000000000 isadjourn = NO adjourn_type = 0 new_case_purpose = 18678000000000 next_hear_date = 03/07/2026 TRN_RCMS_HEARINGrow = 13 Posting record Param Type = n trn_rcms_hearingid=19721000011441 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trn_rcms_caseid=13616000011044 Param Type = c pre_hear_date=27/02/2026 00:00:00 Param Type = c court_code=18223 Param Type = c case_no=2025/359 Param Type = n pre_case_purpose=18678000000000 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c new_case_purpose=18678000000000 Param Type = c next_hear_date=03/07/2026 00:00:00 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,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,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,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,: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 14 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 19721000011442 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 adjourn_remark = adjourn_type = 0 pre_case_purpose = 18678000000000 pre_hear_date = 27/02/2026 new_case_purpose = 18678000000000 next_hear_date = 03/07/2026 court_code = 18223 isadjourn = NO trn_rcms_caseid = 13674000012037 case_no = 2025/360 TRN_RCMS_HEARINGrow = 14 Posting record Param Type = n trn_rcms_hearingid=19721000011442 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c adjourn_type=0 Param Type = n pre_case_purpose=18678000000000 Param Type = c pre_hear_date=27/02/2026 00:00:00 Param Type = c new_case_purpose=18678000000000 Param Type = c next_hear_date=03/07/2026 00:00:00 Param Type = c court_code=18223 Param Type = c isadjourn=NO Param Type = c trn_rcms_caseid=13674000012037 Param Type = c case_no=2025/360 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_remark,adjourn_type,pre_case_purpose,pre_hear_date,new_case_purpose,next_hear_date,court_code,isadjourn,trn_rcms_caseid,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,null,:adjourn_type,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:isadjourn,:trn_rcms_caseid,: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 15 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 19721000011443 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 adjourn_type = 0 adjourn_remark = trn_rcms_caseid = 13873000010518 pre_hear_date = 27/02/2026 court_code = 18223 case_no = 2025/530 next_hear_date = 19/06/2026 isadjourn = NO pre_case_purpose = 18678000000000 new_case_purpose = 18678000000000 TRN_RCMS_HEARINGrow = 15 Posting record Param Type = n trn_rcms_hearingid=19721000011443 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c adjourn_type=0 Param Type = c trn_rcms_caseid=13873000010518 Param Type = c pre_hear_date=27/02/2026 00:00:00 Param Type = c court_code=18223 Param Type = c case_no=2025/530 Param Type = c next_hear_date=19/06/2026 00:00:00 Param Type = c isadjourn=NO Param Type = n pre_case_purpose=18678000000000 Param Type = c new_case_purpose=18678000000000 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,adjourn_type,adjourn_remark,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,:adjourn_type,null,: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 16 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 19721000011444 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 adjourn_type = 0 adjourn_remark = isadjourn = NO case_no = 2025/531 trn_rcms_caseid = 13965000010690 pre_case_purpose = 18678000000000 court_code = 18223 next_hear_date = 19/06/2026 new_case_purpose = 18678000000000 pre_hear_date = 27/02/2026 TRN_RCMS_HEARINGrow = 16 Posting record Param Type = n trn_rcms_hearingid=19721000011444 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 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 case_no=2025/531 Param Type = c trn_rcms_caseid=13965000010690 Param Type = n pre_case_purpose=18678000000000 Param Type = c court_code=18223 Param Type = c next_hear_date=19/06/2026 00:00:00 Param Type = c new_case_purpose=18678000000000 Param Type = c pre_hear_date=27/02/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,adjourn_type,adjourn_remark,isadjourn,case_no,trn_rcms_caseid,pre_case_purpose,court_code,next_hear_date,new_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,:case_no,:trn_rcms_caseid,:pre_case_purpose,:court_code,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'),: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 17 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 19721000011445 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 = trn_rcms_caseid = 19586000012600 case_no = 2025/542 court_code = 18223 pre_hear_date = 27/02/2026 next_hear_date = 05/06/2026 new_case_purpose = 18678000000000 pre_case_purpose = 18678000000000 TRN_RCMS_HEARINGrow = 17 Posting record Param Type = n trn_rcms_hearingid=19721000011445 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 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 trn_rcms_caseid=19586000012600 Param Type = c case_no=2025/542 Param Type = c court_code=18223 Param Type = c pre_hear_date=27/02/2026 00:00:00 Param Type = c next_hear_date=05/06/2026 00:00:00 Param Type = c new_case_purpose=18678000000000 Param Type = n pre_case_purpose=18678000000000 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,isadjourn,adjourn_type,adjourn_remark,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,:isadjourn,:adjourn_type,null,: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 = 3 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 = 1 RecordId = 19721000011446 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 = 05/06/2026 trn_rcms_caseid = 19707000009610 case_no = 2025/543 court_code = 18223 new_case_purpose = 18678000000000 pre_case_purpose = 18678000000000 pre_hear_date = 27/02/2026 TRN_RCMS_HEARINGrow = 18 Posting record Param Type = n trn_rcms_hearingid=19721000011446 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 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=05/06/2026 00:00:00 Param Type = c trn_rcms_caseid=19707000009610 Param Type = c case_no=2025/543 Param Type = c court_code=18223 Param Type = c new_case_purpose=18678000000000 Param Type = n pre_case_purpose=18678000000000 Param Type = c pre_hear_date=27/02/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,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 = 4 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 = 1 RecordId = 19721000011447 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 24/04/2026 isadjourn = NO adjourn_remark = adjourn_type = 0 trn_rcms_caseid = 13740000011304 court_code = 18223 case_no = 2025/755 new_case_purpose = 18678000000000 pre_case_purpose = 18678000000000 pre_hear_date = 27/02/2026 TRN_RCMS_HEARINGrow = 19 Posting record Param Type = n trn_rcms_hearingid=19721000011447 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=24/04/2026 00:00:00 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c trn_rcms_caseid=13740000011304 Param Type = c court_code=18223 Param Type = c case_no=2025/755 Param Type = c new_case_purpose=18678000000000 Param Type = n pre_case_purpose=18678000000000 Param Type = c pre_hear_date=27/02/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,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 = 3 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 = 2 RecordId = 19721000011448 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 22/05/2026 isadjourn = NO adjourn_remark = adjourn_type = 0 new_case_purpose = 1000492 case_no = 2026/21 court_code = 18223 trn_rcms_caseid = 12538000010540 pre_case_purpose = 1000492 pre_hear_date = 27/02/2026 TRN_RCMS_HEARINGrow = 20 Posting record Param Type = n trn_rcms_hearingid=19721000011448 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=22/05/2026 00:00:00 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c new_case_purpose=1000492 Param Type = c case_no=2026/21 Param Type = c court_code=18223 Param Type = c trn_rcms_caseid=12538000010540 Param Type = n pre_case_purpose=1000492 Param Type = c pre_hear_date=27/02/2026 00:00:00 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,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 21 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 19721000011449 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 3 next_hear_date = 29/05/2026 new_case_purpose = 1000492 adjourn_remark = adjourn_type = 0 isadjourn = NO case_no = 2026/62 court_code = 18223 trn_rcms_caseid = 18682000012322 pre_case_purpose = 1000492 pre_hear_date = 27/02/2026 TRN_RCMS_HEARINGrow = 21 Posting record Param Type = n trn_rcms_hearingid=19721000011449 Param Type = n trn_rcms_mhearingid=19721000011428 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=29/05/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/62 Param Type = c court_code=18223 Param Type = c trn_rcms_caseid=18682000012322 Param Type = n pre_case_purpose=1000492 Param Type = c pre_hear_date=27/02/2026 00:00:00 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,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 = 3982216541238 >>Executing genmaps >>Posting from trcmf to tchdh from row 1 >>Mapping Mapped court_code Row = 1 value = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 14071000010640 idvalue 0 Mapped case_no Row = 1 value = 2023/1120 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/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 = 10/07/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 = 18223 trn_rcms_caseregid = 14071000010640 case_no = 2023/1120 prev_hearing_date = 27/02/2026 hearing_date = 10/07/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 = 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 = 19721000011450 MapName trcmf1 SourceId 19721000011429 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 1 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 12555000000002 hearing_date = 10/07/2026 case_no = 2023/1120 trn_rcms_caseregid = 14071000010640 court_code = 18223 case_purpose = 12555000000002 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011450 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011429 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:43 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:43 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=10/07/2026 00:00:00 Param Type = c case_no=2023/1120 Param Type = c trn_rcms_caseregid=14071000010640 Param Type = c court_code=18223 Param Type = c case_purpose=12555000000002 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 19453000010991 idvalue 0 Mapped case_no Row = 1 value = 2024/594 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? idvalue 0 Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0 Mapped hearing_date Row = 1 value = 03/07/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 = 18223 trn_rcms_caseregid = 19453000010991 case_no = 2024/594 prev_hearing_date = 27/02/2026 hearing_date = 03/07/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 = 18678000000000 case_purpose = 18678000000000 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 = 19721000011451 MapName trcmf1 SourceId 19721000011430 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 4 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 18678000000000 hearing_date = 03/07/2026 case_no = 2024/594 trn_rcms_caseregid = 19453000010991 court_code = 18223 case_purpose = 18678000000000 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011451 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011430 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:44 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:44 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=18678000000000 Param Type = c hearing_date=03/07/2026 00:00:00 Param Type = c case_no=2024/594 Param Type = c trn_rcms_caseregid=19453000010991 Param Type = c court_code=18223 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 19493000009630 idvalue 0 Mapped case_no Row = 1 value = 2024/595 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? idvalue 0 Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0 Mapped hearing_date Row = 1 value = 03/07/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 = 18223 trn_rcms_caseregid = 19493000009630 case_no = 2024/595 prev_hearing_date = 27/02/2026 hearing_date = 03/07/2026 prev_case_purposename = ???? prev_case_purpose = prev_case_purpose after validation = 18678000000000 case_purpose = 18678000000000 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 = 19721000011452 MapName trcmf1 SourceId 19721000011431 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 = 18678000000000 hearing_date = 03/07/2026 case_no = 2024/595 trn_rcms_caseregid = 19493000009630 court_code = 18223 case_purpose = 18678000000000 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011452 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011431 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:45 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:45 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=18678000000000 Param Type = c hearing_date=03/07/2026 00:00:00 Param Type = c case_no=2024/595 Param Type = c trn_rcms_caseregid=19493000009630 Param Type = c court_code=18223 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 14430000011844 idvalue 0 Mapped case_no Row = 1 value = 2025/587 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/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 = 03/07/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 = 18223 trn_rcms_caseregid = 14430000011844 case_no = 2025/587 prev_hearing_date = 27/02/2026 hearing_date = 03/07/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 = 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 = 2 RecordId = 19721000011453 MapName trcmf1 SourceId 19721000011432 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000492 hearing_date = 03/07/2026 case_no = 2025/587 trn_rcms_caseregid = 14430000011844 court_code = 18223 case_purpose = 1000492 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011453 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011432 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:46 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:46 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=03/07/2026 00:00:00 Param Type = c case_no=2025/587 Param Type = c trn_rcms_caseregid=14430000011844 Param Type = c court_code=18223 Param Type = c case_purpose=1000492 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 15185000009689 idvalue 0 Mapped case_no Row = 1 value = 2025/588 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/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 = 03/07/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 = 18223 trn_rcms_caseregid = 15185000009689 case_no = 2025/588 prev_hearing_date = 27/02/2026 hearing_date = 03/07/2026 prev_case_purposename = ????? prev_case_purpose = 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 = 1 RecordId = 19721000011454 MapName trcmf1 SourceId 19721000011433 Select sysdate as sdt from dual Time elapsed = 3 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 = 1000492 hearing_date = 03/07/2026 case_no = 2025/588 trn_rcms_caseregid = 15185000009689 court_code = 18223 case_purpose = 1000492 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011454 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011433 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:46 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:46 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=03/07/2026 00:00:00 Param Type = c case_no=2025/588 Param Type = c trn_rcms_caseregid=15185000009689 Param Type = c court_code=18223 Param Type = c case_purpose=1000492 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 14367000010430 idvalue 0 Mapped case_no Row = 1 value = 2025/615 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/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 = 19/06/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 = 18223 trn_rcms_caseregid = 14367000010430 case_no = 2025/615 prev_hearing_date = 27/02/2026 hearing_date = 19/06/2026 prev_case_purposename = ????? prev_case_purpose = 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 = 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 = 19721000011455 MapName trcmf1 SourceId 19721000011434 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 = 19/06/2026 case_no = 2025/615 trn_rcms_caseregid = 14367000010430 court_code = 18223 case_purpose = 1000492 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011455 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011434 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:47 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:47 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=19/06/2026 00:00:00 Param Type = c case_no=2025/615 Param Type = c trn_rcms_caseregid=14367000010430 Param Type = c court_code=18223 Param Type = c case_purpose=1000492 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 15794000011861 idvalue 0 Mapped case_no Row = 1 value = 2025/903 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/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 = 30/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 = 18223 trn_rcms_caseregid = 15794000011861 case_no = 2025/903 prev_hearing_date = 27/02/2026 hearing_date = 30/03/2026 prev_case_purposename = ????? prev_case_purpose = 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 = 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 = 19721000011456 MapName trcmf1 SourceId 19721000011435 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 = 30/03/2026 case_no = 2025/903 trn_rcms_caseregid = 15794000011861 court_code = 18223 case_purpose = 1000492 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011456 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011435 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:48 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:48 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=30/03/2026 00:00:00 Param Type = c case_no=2025/903 Param Type = c trn_rcms_caseregid=15794000011861 Param Type = c court_code=18223 Param Type = c case_purpose=1000492 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 10110000012303 idvalue 0 Mapped case_no Row = 1 value = 2025/932 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/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 = 23/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 = 18223 trn_rcms_caseregid = 10110000012303 case_no = 2025/932 prev_hearing_date = 27/02/2026 hearing_date = 23/03/2026 prev_case_purposename = ????? prev_case_purpose = 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 = 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 = 19721000011457 MapName trcmf1 SourceId 19721000011436 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 = 23/03/2026 case_no = 2025/932 trn_rcms_caseregid = 10110000012303 court_code = 18223 case_purpose = 1000492 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011457 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011436 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:48 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:48 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=23/03/2026 00:00:00 Param Type = c case_no=2025/932 Param Type = c trn_rcms_caseregid=10110000012303 Param Type = c court_code=18223 Param Type = c case_purpose=1000492 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 10308000011376 idvalue 0 Mapped case_no Row = 1 value = 2025/933 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/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 = 23/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 = 18223 trn_rcms_caseregid = 10308000011376 case_no = 2025/933 prev_hearing_date = 27/02/2026 hearing_date = 23/03/2026 prev_case_purposename = ????? prev_case_purpose = 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 = 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 = 19721000011458 MapName trcmf1 SourceId 19721000011437 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 = 23/03/2026 case_no = 2025/933 trn_rcms_caseregid = 10308000011376 court_code = 18223 case_purpose = 1000492 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011458 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011437 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:49 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:49 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=23/03/2026 00:00:00 Param Type = c case_no=2025/933 Param Type = c trn_rcms_caseregid=10308000011376 Param Type = c court_code=18223 Param Type = c case_purpose=1000492 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 13794000011207 idvalue 0 Mapped case_no Row = 1 value = 2025/982 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/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 = 15/05/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 = 18223 trn_rcms_caseregid = 13794000011207 case_no = 2025/982 prev_hearing_date = 27/02/2026 hearing_date = 15/05/2026 prev_case_purposename = ????? prev_case_purpose = 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 = 1 RecordId = 19721000011459 MapName trcmf1 SourceId 19721000011438 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 = 15/05/2026 case_no = 2025/982 trn_rcms_caseregid = 13794000011207 court_code = 18223 case_purpose = 1000492 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011459 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011438 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:50 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:50 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=15/05/2026 00:00:00 Param Type = c case_no=2025/982 Param Type = c trn_rcms_caseregid=13794000011207 Param Type = c court_code=18223 Param Type = c case_purpose=1000492 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 12396000010099 idvalue 0 Mapped case_no Row = 1 value = 2025/138 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? idvalue 0 Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0 Mapped hearing_date Row = 1 value = 12/06/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 = 18223 trn_rcms_caseregid = 12396000010099 case_no = 2025/138 prev_hearing_date = 27/02/2026 hearing_date = 12/06/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 = 2 prev_case_purpose after validation = 18678000000000 case_purpose = 18678000000000 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 = 19721000011460 MapName trcmf1 SourceId 19721000011439 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 = 18678000000000 hearing_date = 12/06/2026 case_no = 2025/138 trn_rcms_caseregid = 12396000010099 court_code = 18223 case_purpose = 18678000000000 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011460 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011439 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:50 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:50 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=18678000000000 Param Type = c hearing_date=12/06/2026 00:00:00 Param Type = c case_no=2025/138 Param Type = c trn_rcms_caseregid=12396000010099 Param Type = c court_code=18223 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 12738000010162 idvalue 0 Mapped case_no Row = 1 value = 2025/139 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? idvalue 0 Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0 Mapped hearing_date Row = 1 value = 12/06/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 = 18223 trn_rcms_caseregid = 12738000010162 case_no = 2025/139 prev_hearing_date = 27/02/2026 hearing_date = 12/06/2026 prev_case_purposename = ???? prev_case_purpose = prev_case_purpose after validation = 18678000000000 case_purpose = 18678000000000 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 = 19721000011461 MapName trcmf1 SourceId 19721000011440 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 = 18678000000000 hearing_date = 12/06/2026 case_no = 2025/139 trn_rcms_caseregid = 12738000010162 court_code = 18223 case_purpose = 18678000000000 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011461 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011440 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:51 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:51 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=18678000000000 Param Type = c hearing_date=12/06/2026 00:00:00 Param Type = c case_no=2025/139 Param Type = c trn_rcms_caseregid=12738000010162 Param Type = c court_code=18223 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 13616000011044 idvalue 0 Mapped case_no Row = 1 value = 2025/359 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? idvalue 0 Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0 Mapped hearing_date Row = 1 value = 03/07/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 = 18223 trn_rcms_caseregid = 13616000011044 case_no = 2025/359 prev_hearing_date = 27/02/2026 hearing_date = 03/07/2026 prev_case_purposename = ???? prev_case_purpose = prev_case_purpose after validation = 18678000000000 case_purpose = 18678000000000 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 = 19721000011462 MapName trcmf1 SourceId 19721000011441 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 1 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 18678000000000 hearing_date = 03/07/2026 case_no = 2025/359 trn_rcms_caseregid = 13616000011044 court_code = 18223 case_purpose = 18678000000000 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011462 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011441 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:52 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:52 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=18678000000000 Param Type = c hearing_date=03/07/2026 00:00:00 Param Type = c case_no=2025/359 Param Type = c trn_rcms_caseregid=13616000011044 Param Type = c court_code=18223 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 13674000012037 idvalue 0 Mapped case_no Row = 1 value = 2025/360 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? idvalue 0 Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0 Mapped hearing_date Row = 1 value = 03/07/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 = 18223 trn_rcms_caseregid = 13674000012037 case_no = 2025/360 prev_hearing_date = 27/02/2026 hearing_date = 03/07/2026 prev_case_purposename = ???? prev_case_purpose = prev_case_purpose after validation = 18678000000000 case_purpose = 18678000000000 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 = 19721000011463 MapName trcmf1 SourceId 19721000011442 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 = 18678000000000 hearing_date = 03/07/2026 case_no = 2025/360 trn_rcms_caseregid = 13674000012037 court_code = 18223 case_purpose = 18678000000000 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011463 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011442 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:52 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:52 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=18678000000000 Param Type = c hearing_date=03/07/2026 00:00:00 Param Type = c case_no=2025/360 Param Type = c trn_rcms_caseregid=13674000012037 Param Type = c court_code=18223 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 13873000010518 idvalue 0 Mapped case_no Row = 1 value = 2025/530 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? idvalue 0 Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0 Mapped hearing_date Row = 1 value = 19/06/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 = 18223 trn_rcms_caseregid = 13873000010518 case_no = 2025/530 prev_hearing_date = 27/02/2026 hearing_date = 19/06/2026 prev_case_purposename = ???? prev_case_purpose = prev_case_purpose after validation = 18678000000000 case_purpose = 18678000000000 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 = 19721000011464 MapName trcmf1 SourceId 19721000011443 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 = 18678000000000 hearing_date = 19/06/2026 case_no = 2025/530 trn_rcms_caseregid = 13873000010518 court_code = 18223 case_purpose = 18678000000000 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011464 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011443 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:53 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:53 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=18678000000000 Param Type = c hearing_date=19/06/2026 00:00:00 Param Type = c case_no=2025/530 Param Type = c trn_rcms_caseregid=13873000010518 Param Type = c court_code=18223 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 13965000010690 idvalue 0 Mapped case_no Row = 1 value = 2025/531 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? idvalue 0 Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0 Mapped hearing_date Row = 1 value = 19/06/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 = 18223 trn_rcms_caseregid = 13965000010690 case_no = 2025/531 prev_hearing_date = 27/02/2026 hearing_date = 19/06/2026 prev_case_purposename = ???? prev_case_purpose = prev_case_purpose after validation = 18678000000000 case_purpose = 18678000000000 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 = 19721000011465 MapName trcmf1 SourceId 19721000011444 Select sysdate as sdt from dual Time elapsed = 3 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 = 18678000000000 hearing_date = 19/06/2026 case_no = 2025/531 trn_rcms_caseregid = 13965000010690 court_code = 18223 case_purpose = 18678000000000 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011465 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011444 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:54 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:54 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=18678000000000 Param Type = c hearing_date=19/06/2026 00:00:00 Param Type = c case_no=2025/531 Param Type = c trn_rcms_caseregid=13965000010690 Param Type = c court_code=18223 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 19586000012600 idvalue 0 Mapped case_no Row = 1 value = 2025/542 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? idvalue 0 Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0 Mapped hearing_date Row = 1 value = 05/06/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 = 18223 trn_rcms_caseregid = 19586000012600 case_no = 2025/542 prev_hearing_date = 27/02/2026 hearing_date = 05/06/2026 prev_case_purposename = ???? prev_case_purpose = prev_case_purpose after validation = 18678000000000 case_purpose = 18678000000000 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 = 2 RecordId = 19721000011466 MapName trcmf1 SourceId 19721000011445 Select sysdate as sdt from dual Time elapsed = 3 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 = 18678000000000 hearing_date = 05/06/2026 case_no = 2025/542 trn_rcms_caseregid = 19586000012600 court_code = 18223 case_purpose = 18678000000000 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011466 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011445 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:54 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:54 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=18678000000000 Param Type = c hearing_date=05/06/2026 00:00:00 Param Type = c case_no=2025/542 Param Type = c trn_rcms_caseregid=19586000012600 Param Type = c court_code=18223 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 19707000009610 idvalue 0 Mapped case_no Row = 1 value = 2025/543 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? idvalue 0 Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0 Mapped hearing_date Row = 1 value = 05/06/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 = 18223 trn_rcms_caseregid = 19707000009610 case_no = 2025/543 prev_hearing_date = 27/02/2026 hearing_date = 05/06/2026 prev_case_purposename = ???? prev_case_purpose = prev_case_purpose after validation = 18678000000000 case_purpose = 18678000000000 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 = 19721000011467 MapName trcmf1 SourceId 19721000011446 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 = 18678000000000 hearing_date = 05/06/2026 case_no = 2025/543 trn_rcms_caseregid = 19707000009610 court_code = 18223 case_purpose = 18678000000000 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011467 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011446 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:55 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:55 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=18678000000000 Param Type = c hearing_date=05/06/2026 00:00:00 Param Type = c case_no=2025/543 Param Type = c trn_rcms_caseregid=19707000009610 Param Type = c court_code=18223 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 13740000011304 idvalue 0 Mapped case_no Row = 1 value = 2025/755 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/02/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? idvalue 0 Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0 Mapped hearing_date Row = 1 value = 24/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 = 18223 trn_rcms_caseregid = 13740000011304 case_no = 2025/755 prev_hearing_date = 27/02/2026 hearing_date = 24/04/2026 prev_case_purposename = ???? prev_case_purpose = prev_case_purpose after validation = 18678000000000 case_purpose = 18678000000000 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 = 19721000011468 MapName trcmf1 SourceId 19721000011447 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 = 18678000000000 hearing_date = 24/04/2026 case_no = 2025/755 trn_rcms_caseregid = 13740000011304 court_code = 18223 case_purpose = 18678000000000 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011468 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011447 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:56 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:56 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=18678000000000 Param Type = c hearing_date=24/04/2026 00:00:00 Param Type = c case_no=2025/755 Param Type = c trn_rcms_caseregid=13740000011304 Param Type = c court_code=18223 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 12538000010540 idvalue 0 Mapped case_no Row = 1 value = 2026/21 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/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 = 22/05/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 = 18223 trn_rcms_caseregid = 12538000010540 case_no = 2026/21 prev_hearing_date = 27/02/2026 hearing_date = 22/05/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 = 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 = 19721000011469 MapName trcmf1 SourceId 19721000011448 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 1 trans_type = Feedback Submitted (Custom) adjourn_type = 0 isadjourn = NO decision_date = decision_type = 0 prev_case_purpose = 1000492 hearing_date = 22/05/2026 case_no = 2026/21 trn_rcms_caseregid = 12538000010540 court_code = 18223 case_purpose = 1000492 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011469 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011448 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:56 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:56 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=22/05/2026 00:00:00 Param Type = c case_no=2026/21 Param Type = c trn_rcms_caseregid=12538000010540 Param Type = c court_code=18223 Param Type = c case_purpose=1000492 Param Type = c prev_hearing_date=27/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 = 18223 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 18682000012322 idvalue 0 Mapped case_no Row = 1 value = 2026/62 idvalue 0 Mapped prev_hearing_date Row = 1 value = 27/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 = 29/05/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 = 18223 trn_rcms_caseregid = 18682000012322 case_no = 2026/62 prev_hearing_date = 27/02/2026 hearing_date = 29/05/2026 prev_case_purposename = ????? prev_case_purpose = 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 = 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 = 19721000011470 MapName trcmf1 SourceId 19721000011449 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 = 29/05/2026 case_no = 2026/62 trn_rcms_caseregid = 18682000012322 court_code = 18223 case_purpose = 1000492 prev_hearing_date = 27/02/2026 Posting record Param Type = n trn_rcms_case_histid=19721000011470 Param Type = c mapname=trcmf1 Param Type = n sourceid=19721000011449 Param Type = c cancel=F Param Type = c createdby=SDO_Tapukada_PRO Param Type = c createdon=09/03/2026 11:15:57 Param Type = c username=SDO_Tapukada_PRO Param Type = c modifiedon=09/03/2026 11:15:57 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=29/05/2026 00:00:00 Param Type = c case_no=2026/62 Param Type = c trn_rcms_caseregid=18682000012322 Param Type = c court_code=18223 Param Type = c case_purpose=1000492 Param Type = c prev_hearing_date=27/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 = 3982216555862 Time elapsed for MD Map = 3982216555862 Time elapsed for Save History = 3982216555862 Time elapsed for Save Attachment = 3982216555863 Time elapsed for After Save WF Exec = 3982216555864 Transaction commited Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"19721000011428"}]} 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=SDO_Tapukada_PRO Param Type = c calledon=09/03/2026 11:15:40 Param Type = c callfinished=09/03/2026 11:15:55 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=15666 Param Type = n dbtimetaken=14907 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