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 gcmssurajmal827ccb0eea8a706c4c34a16891f84e7btrcmf001041118/10/20230104112022/23811731000007302????18/10/20231867800000000020/11/202318678000000000NO00104112022/24512308000007151????18/10/20231867800000000025/10/202318678000000000NO00104112022/24612358000007819????18/10/20231867800000000027/12/202318678000000000NO00104112022/26013549000007272????18/10/20231867800000000027/12/202318678000000000NO00104112022/26314092000007240????18/10/20231867800000000027/12/202318678000000000NO00104112022/29910633000007022????18/10/20231867800000000027/12/202318678000000000NO00104112022/31018255000007119????18/10/20231867800000000027/12/202318678000000000NO00104112022/31810685000006366????18/10/20231867800000000027/12/202318678000000000NO00104112022/41412638000007169????18/10/20231867800000000027/12/202318678000000000NO00104112022/45415182000007284????18/10/20231867800000000027/12/202318678000000000NO00104112023/12017160000007288????18/10/20231867800000000027/12/202318678000000000NO00104112023/13219718000008900????18/10/20231867800000000019/10/202318678000000000NO00104112023/15017669000009323????18/10/20231867800000000025/10/202318678000000000NO00104112023/16014315000007983????18/10/20231867800000000022/11/202318678000000000NO00104112015/0002715376000000583???? ????? ????18/10/20231147200000000327/12/202311472000000003NO00104112015/0003511053000000746???? ????? ????18/10/20231147200000000318/12/202311472000000003NO00104112017/0016116188000001342???? ????? ????18/10/20231147200000000330/10/202311472000000003NO00104112020/0113712100000004955???? ????? ????18/10/20231147200000000326/12/202311472000000003NO0 Executing Savedata webservice ----------------------------- Received JSON : {"savedata":{"axpapp":"gcms","username":"surajmal","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"trcmf","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtcode":"10411","hearing_date":"18/10/2023"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"court_code":"10411","case_no":"2022/238","trn_rcms_caseid":"11731000007302","pre_case_purpose_name":"????","pre_hear_date":"18/10/2023","pre_case_purpose":"18678000000000","next_hear_date":"20/11/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"002","text":"0","columns":{"court_code":"10411","case_no":"2022/245","trn_rcms_caseid":"12308000007151","pre_case_purpose_name":"????","pre_hear_date":"18/10/2023","pre_case_purpose":"18678000000000","next_hear_date":"25/10/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"003","text":"0","columns":{"court_code":"10411","case_no":"2022/246","trn_rcms_caseid":"12358000007819","pre_case_purpose_name":"????","pre_hear_date":"18/10/2023","pre_case_purpose":"18678000000000","next_hear_date":"27/12/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"004","text":"0","columns":{"court_code":"10411","case_no":"2022/260","trn_rcms_caseid":"13549000007272","pre_case_purpose_name":"????","pre_hear_date":"18/10/2023","pre_case_purpose":"18678000000000","next_hear_date":"27/12/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"005","text":"0","columns":{"court_code":"10411","case_no":"2022/263","trn_rcms_caseid":"14092000007240","pre_case_purpose_name":"????","pre_hear_date":"18/10/2023","pre_case_purpose":"18678000000000","next_hear_date":"27/12/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"006","text":"0","columns":{"court_code":"10411","case_no":"2022/299","trn_rcms_caseid":"10633000007022","pre_case_purpose_name":"????","pre_hear_date":"18/10/2023","pre_case_purpose":"18678000000000","next_hear_date":"27/12/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"007","text":"0","columns":{"court_code":"10411","case_no":"2022/310","trn_rcms_caseid":"18255000007119","pre_case_purpose_name":"????","pre_hear_date":"18/10/2023","pre_case_purpose":"18678000000000","next_hear_date":"27/12/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"008","text":"0","columns":{"court_code":"10411","case_no":"2022/318","trn_rcms_caseid":"10685000006366","pre_case_purpose_name":"????","pre_hear_date":"18/10/2023","pre_case_purpose":"18678000000000","next_hear_date":"27/12/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"009","text":"0","columns":{"court_code":"10411","case_no":"2022/414","trn_rcms_caseid":"12638000007169","pre_case_purpose_name":"????","pre_hear_date":"18/10/2023","pre_case_purpose":"18678000000000","next_hear_date":"27/12/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0010","text":"0","columns":{"court_code":"10411","case_no":"2022/454","trn_rcms_caseid":"15182000007284","pre_case_purpose_name":"????","pre_hear_date":"18/10/2023","pre_case_purpose":"18678000000000","next_hear_date":"27/12/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0011","text":"0","columns":{"court_code":"10411","case_no":"2023/120","trn_rcms_caseid":"17160000007288","pre_case_purpose_name":"????","pre_hear_date":"18/10/2023","pre_case_purpose":"18678000000000","next_hear_date":"27/12/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0012","text":"0","columns":{"court_code":"10411","case_no":"2023/132","trn_rcms_caseid":"19718000008900","pre_case_purpose_name":"????","pre_hear_date":"18/10/2023","pre_case_purpose":"18678000000000","next_hear_date":"19/10/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0013","text":"0","columns":{"court_code":"10411","case_no":"2023/150","trn_rcms_caseid":"17669000009323","pre_case_purpose_name":"????","pre_hear_date":"18/10/2023","pre_case_purpose":"18678000000000","next_hear_date":"25/10/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0014","text":"0","columns":{"court_code":"10411","case_no":"2023/160","trn_rcms_caseid":"14315000007983","pre_case_purpose_name":"????","pre_hear_date":"18/10/2023","pre_case_purpose":"18678000000000","next_hear_date":"22/11/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0015","text":"0","columns":{"court_code":"10411","case_no":"2015/00027","trn_rcms_caseid":"15376000000583","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"18/10/2023","pre_case_purpose":"11472000000003","next_hear_date":"27/12/2023","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0016","text":"0","columns":{"court_code":"10411","case_no":"2015/00035","trn_rcms_caseid":"11053000000746","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"18/10/2023","pre_case_purpose":"11472000000003","next_hear_date":"18/12/2023","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0017","text":"0","columns":{"court_code":"10411","case_no":"2017/00161","trn_rcms_caseid":"16188000001342","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"18/10/2023","pre_case_purpose":"11472000000003","next_hear_date":"30/10/2023","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0018","text":"0","columns":{"court_code":"10411","case_no":"2020/01137","trn_rcms_caseid":"12100000004955","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"18/10/2023","pre_case_purpose":"11472000000003","next_hear_date":"26/12/2023","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}}]}]}} Verifying username and password User Name : surajmal Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app' U=surajmal Time elapsed = 15 Password checking along with max.no of login specified in app.xml update axusers set logintry = 0 where lower(username) = :U Time elapsed = 6 Result : Verifying completed... Page Access Category : User Name : surajmal Select sysdate as sdt from dual Time elapsed = 4 dt=19/10/2023 10:58:35 Select sysdate as sdt from dual Time elapsed = 4 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=surajmal dt=19/10/2023 10:58:35 dt=19/10/2023 10:58:35 Time elapsed = 9 User Groups: court_reader select userroles from axusergroups where groupname in ( 'court_reader' ) Time elapsed = 6 User Roles : court_reader 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 = 3 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=surajmal select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=surajmal Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m2},{court_name}) Calling function sqlget Result of sqlget = DC, ????? Result = DC, ????? Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1}) Calling function firesql username=surajmal select a.court_type from v_axcourts a where a.paxusername= :username order by 1 username=surajmal Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m3},{court_type}) Calling function sqlget Result of sqlget = DC Result = DC Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1}) Calling function firesql username=surajmal select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1 username=surajmal Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m4},{court_name_mastid}) Calling function sqlget Result of sqlget = 13289000000046 Result = 13289000000046 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=surajmal Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m4},{axusersid}) Calling function sqlget Result of sqlget = 15447000002748 Result = 15447000002748 Evaluating firesql({m4},{select :username as uname from dual}) Calling function firesql select :username as uname from dual username=surajmal Time elapsed = 4 Result of firesql = Result = Evaluating sqlget({m4},{uname}) Calling function sqlget Result of sqlget = surajmal Result = surajmal 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=surajmal Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m4},{COURT_CODE}) Calling function sqlget Result of sqlget = 10411 Result = 10411 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 = 3 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=surajmal SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=surajmal Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m7},{DISTNAMEENG}) Calling function sqlget Result of sqlget = Ajmer Result = Ajmer Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=surajmal SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=surajmal Time elapsed = 5 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=15447000002748 select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid login_userid=15447000002748 Time elapsed = 5 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=surajmal Time elapsed = 4 Result of firesql = Result = Evaluating sqlget({m3},{court_type_mastid}) Calling function sqlget Result of sqlget = 10206000000013 Result = 10206000000013 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=surajmal 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=surajmal Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m4},{groupname}) Calling function sqlget Result of sqlget = court_reader Result = court_reader 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 = 3 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=surajmal 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=surajmal Time elapsed = 9 Result of firesql = Result = Evaluating sqlget({P1},{ct}) Calling function sqlget Result of sqlget = 6 Result = 6 3 completed LoadAppVars Password validation done successfully select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='trcmf' and stype = 't' ) Time elapsed = 4 select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't' Time elapsed = 6 Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno Paramval : court_reader,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 = 4 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 = 4 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 = 10411 hearing_date = 18/10/2023 time zone difference = 0 >>Writing to tables trcmf Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf' Time elapsed = 3 Saving to table TRN_RCMS_MHEARING select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 15711000008396 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 hearing_date = 18/10/2023 courtcode = 10411 Posting record Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:36 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:36 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c hearing_date=18/10/2023 00:00:00 Param Type = c courtcode=10411 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 = 4 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 = 3 RecordId = 15711000008397 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 5 pre_case_purpose = 18678000000000 trn_rcms_caseid = 11731000007302 court_code = 10411 pre_hear_date = 18/10/2023 new_case_purpose = 18678000000000 next_hear_date = 20/11/2023 case_no = 2022/238 isadjourn = NO adjourn_remark = adjourn_type = 0 TRN_RCMS_HEARINGrow = 1 Posting record Param Type = n trn_rcms_hearingid=15711000008397 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:36 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:36 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = n pre_case_purpose=18678000000000 Param Type = c trn_rcms_caseid=11731000007302 Param Type = c court_code=10411 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = c new_case_purpose=18678000000000 Param Type = c next_hear_date=20/11/2023 00:00:00 Param Type = c case_no=2022/238 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 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_case_purpose,trn_rcms_caseid,court_code,pre_hear_date,new_case_purpose,next_hear_date,case_no,isadjourn,adjourn_remark,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,:pre_case_purpose,:trn_rcms_caseid,:court_code,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'),:case_no,:isadjourn,null,:adjourn_type,: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 2 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 15711000008398 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 4 pre_hear_date = 18/10/2023 pre_case_purpose = 18678000000000 trn_rcms_caseid = 12308000007151 court_code = 10411 case_no = 2022/245 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 18678000000000 next_hear_date = 25/10/2023 TRN_RCMS_HEARINGrow = 2 Posting record Param Type = n trn_rcms_hearingid=15711000008398 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:36 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:36 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = n pre_case_purpose=18678000000000 Param Type = c trn_rcms_caseid=12308000007151 Param Type = c court_code=10411 Param Type = c case_no=2022/245 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=18678000000000 Param Type = c next_hear_date=25/10/2023 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 = 4 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 = 3 RecordId = 15711000008399 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 4 next_hear_date = 27/12/2023 new_case_purpose = 18678000000000 isadjourn = NO adjourn_remark = adjourn_type = 0 case_no = 2022/246 court_code = 10411 trn_rcms_caseid = 12358000007819 pre_case_purpose = 18678000000000 pre_hear_date = 18/10/2023 TRN_RCMS_HEARINGrow = 3 Posting record Param Type = n trn_rcms_hearingid=15711000008399 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:36 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:36 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=27/12/2023 00:00:00 Param Type = c new_case_purpose=18678000000000 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c case_no=2022/246 Param Type = c court_code=10411 Param Type = c trn_rcms_caseid=12358000007819 Param Type = n pre_case_purpose=18678000000000 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = n trn_rcms_hearingrow=3 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 4 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 = 2 RecordId = 15711000008400 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 isadjourn = NO adjourn_type = 0 next_hear_date = 27/12/2023 pre_case_purpose = 18678000000000 new_case_purpose = 18678000000000 case_no = 2022/260 court_code = 10411 trn_rcms_caseid = 13549000007272 adjourn_remark = pre_hear_date = 18/10/2023 TRN_RCMS_HEARINGrow = 4 Posting record Param Type = n trn_rcms_hearingid=15711000008400 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:36 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:36 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=27/12/2023 00:00:00 Param Type = n pre_case_purpose=18678000000000 Param Type = c new_case_purpose=18678000000000 Param Type = c case_no=2022/260 Param Type = c court_code=10411 Param Type = c trn_rcms_caseid=13549000007272 Param Type = c pre_hear_date=18/10/2023 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,isadjourn,adjourn_type,next_hear_date,pre_case_purpose,new_case_purpose,case_no,court_code,trn_rcms_caseid,adjourn_remark,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,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,null,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 = 5 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 = 4 RecordId = 15711000008401 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 4 next_hear_date = 27/12/2023 new_case_purpose = 18678000000000 adjourn_type = 0 isadjourn = NO pre_case_purpose = 18678000000000 case_no = 2022/263 court_code = 10411 pre_hear_date = 18/10/2023 trn_rcms_caseid = 14092000007240 adjourn_remark = TRN_RCMS_HEARINGrow = 5 Posting record Param Type = n trn_rcms_hearingid=15711000008401 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:36 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:36 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=27/12/2023 00:00:00 Param Type = c new_case_purpose=18678000000000 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = n pre_case_purpose=18678000000000 Param Type = c case_no=2022/263 Param Type = c court_code=10411 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = c trn_rcms_caseid=14092000007240 Param Type = n trn_rcms_hearingrow=5 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_type,isadjourn,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:isadjourn,:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 6 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 = 3 RecordId = 15711000008402 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 6 Select sysdate as sdt from dual Time elapsed = 3 new_case_purpose = 18678000000000 next_hear_date = 27/12/2023 trn_rcms_caseid = 10633000007022 pre_hear_date = 18/10/2023 pre_case_purpose = 18678000000000 adjourn_type = 0 adjourn_remark = isadjourn = NO court_code = 10411 case_no = 2022/299 TRN_RCMS_HEARINGrow = 6 Posting record Param Type = n trn_rcms_hearingid=15711000008402 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:36 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:36 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c new_case_purpose=18678000000000 Param Type = c next_hear_date=27/12/2023 00:00:00 Param Type = c trn_rcms_caseid=10633000007022 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = n pre_case_purpose=18678000000000 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c court_code=10411 Param Type = c case_no=2022/299 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,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_hear_date,pre_case_purpose,adjourn_type,adjourn_remark,isadjourn,court_code,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:adjourn_type,null,:isadjourn,:court_code,:case_no,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 4 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 = 3 RecordId = 15711000008403 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 pre_hear_date = 18/10/2023 pre_case_purpose = 18678000000000 trn_rcms_caseid = 18255000007119 court_code = 10411 case_no = 2022/310 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 18678000000000 next_hear_date = 27/12/2023 TRN_RCMS_HEARINGrow = 7 Posting record Param Type = n trn_rcms_hearingid=15711000008403 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:36 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:36 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = n pre_case_purpose=18678000000000 Param Type = c trn_rcms_caseid=18255000007119 Param Type = c court_code=10411 Param Type = c case_no=2022/310 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=18678000000000 Param Type = c next_hear_date=27/12/2023 00:00:00 Param Type = n trn_rcms_hearingrow=7 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 8 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 15711000008404 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 pre_hear_date = 18/10/2023 pre_case_purpose = 18678000000000 trn_rcms_caseid = 10685000006366 court_code = 10411 case_no = 2022/318 adjourn_type = 0 adjourn_remark = isadjourn = NO new_case_purpose = 18678000000000 next_hear_date = 27/12/2023 TRN_RCMS_HEARINGrow = 8 Posting record Param Type = n trn_rcms_hearingid=15711000008404 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:36 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:36 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = n pre_case_purpose=18678000000000 Param Type = c trn_rcms_caseid=10685000006366 Param Type = c court_code=10411 Param Type = c case_no=2022/318 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c new_case_purpose=18678000000000 Param Type = c next_hear_date=27/12/2023 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 = 6 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 = 6 RecordId = 15711000008405 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 7 Select sysdate as sdt from dual Time elapsed = 5 adjourn_remark = new_case_purpose = 18678000000000 pre_case_purpose = 18678000000000 isadjourn = NO next_hear_date = 27/12/2023 case_no = 2022/414 court_code = 10411 pre_hear_date = 18/10/2023 trn_rcms_caseid = 12638000007169 adjourn_type = 0 TRN_RCMS_HEARINGrow = 9 Posting record Param Type = n trn_rcms_hearingid=15711000008405 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:36 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:36 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c new_case_purpose=18678000000000 Param Type = n pre_case_purpose=18678000000000 Param Type = c isadjourn=NO Param Type = c next_hear_date=27/12/2023 00:00:00 Param Type = c case_no=2022/414 Param Type = c court_code=10411 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = c trn_rcms_caseid=12638000007169 Param Type = c adjourn_type=0 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,adjourn_remark,new_case_purpose,pre_case_purpose,isadjourn,next_hear_date,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:new_case_purpose,:pre_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:adjourn_type,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 4 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 = 3 RecordId = 15711000008406 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 7 Select sysdate as sdt from dual Time elapsed = 4 trn_rcms_caseid = 15182000007284 case_no = 2022/454 pre_case_purpose = 18678000000000 pre_hear_date = 18/10/2023 next_hear_date = 27/12/2023 adjourn_type = 0 isadjourn = NO adjourn_remark = court_code = 10411 new_case_purpose = 18678000000000 TRN_RCMS_HEARINGrow = 10 Posting record Param Type = n trn_rcms_hearingid=15711000008406 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:36 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:37 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trn_rcms_caseid=15182000007284 Param Type = c case_no=2022/454 Param Type = n pre_case_purpose=18678000000000 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = c next_hear_date=27/12/2023 00:00:00 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c court_code=10411 Param Type = c new_case_purpose=18678000000000 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,trn_rcms_caseid,case_no,pre_case_purpose,pre_hear_date,next_hear_date,adjourn_type,isadjourn,adjourn_remark,court_code,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,:case_no,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:court_code,:new_case_purpose,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 4 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 = 3 RecordId = 15711000008407 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 adjourn_remark = adjourn_type = 0 trn_rcms_caseid = 17160000007288 pre_hear_date = 18/10/2023 court_code = 10411 case_no = 2023/120 next_hear_date = 27/12/2023 isadjourn = NO pre_case_purpose = 18678000000000 new_case_purpose = 18678000000000 TRN_RCMS_HEARINGrow = 11 Posting record Param Type = n trn_rcms_hearingid=15711000008407 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:37 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:37 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c adjourn_type=0 Param Type = c trn_rcms_caseid=17160000007288 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = c court_code=10411 Param Type = c case_no=2023/120 Param Type = c next_hear_date=27/12/2023 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=11 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 7 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 = 4 RecordId = 15711000008408 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 = pre_hear_date = 18/10/2023 trn_rcms_caseid = 19718000008900 new_case_purpose = 18678000000000 pre_case_purpose = 18678000000000 next_hear_date = 19/10/2023 isadjourn = NO case_no = 2023/132 court_code = 10411 TRN_RCMS_HEARINGrow = 12 Posting record Param Type = n trn_rcms_hearingid=15711000008408 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:37 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:37 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c adjourn_type=0 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = c trn_rcms_caseid=19718000008900 Param Type = c new_case_purpose=18678000000000 Param Type = n pre_case_purpose=18678000000000 Param Type = c next_hear_date=19/10/2023 00:00:00 Param Type = c isadjourn=NO Param Type = c case_no=2023/132 Param Type = c court_code=10411 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_type,adjourn_remark,pre_hear_date,trn_rcms_caseid,new_case_purpose,pre_case_purpose,next_hear_date,isadjourn,case_no,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:court_code,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 15 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 = 3 RecordId = 15711000008409 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 16 Select sysdate as sdt from dual Time elapsed = 3 adjourn_type = 0 adjourn_remark = isadjourn = NO trn_rcms_caseid = 17669000009323 case_no = 2023/150 court_code = 10411 pre_hear_date = 18/10/2023 next_hear_date = 25/10/2023 new_case_purpose = 18678000000000 pre_case_purpose = 18678000000000 TRN_RCMS_HEARINGrow = 13 Posting record Param Type = n trn_rcms_hearingid=15711000008409 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:37 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:37 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c trn_rcms_caseid=17669000009323 Param Type = c case_no=2023/150 Param Type = c court_code=10411 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = c next_hear_date=25/10/2023 00:00:00 Param Type = c new_case_purpose=18678000000000 Param Type = n pre_case_purpose=18678000000000 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_type,adjourn_remark,isadjourn,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 5 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 = 15711000008410 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 isadjourn = NO adjourn_type = 0 adjourn_remark = case_no = 2023/160 court_code = 10411 pre_hear_date = 18/10/2023 trn_rcms_caseid = 14315000007983 next_hear_date = 22/11/2023 new_case_purpose = 18678000000000 pre_case_purpose = 18678000000000 TRN_RCMS_HEARINGrow = 14 Posting record Param Type = n trn_rcms_hearingid=15711000008410 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:37 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:37 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c case_no=2023/160 Param Type = c court_code=10411 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = c trn_rcms_caseid=14315000007983 Param Type = c next_hear_date=22/11/2023 00:00:00 Param Type = c new_case_purpose=18678000000000 Param Type = n pre_case_purpose=18678000000000 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,isadjourn,adjourn_type,adjourn_remark,case_no,court_code,pre_hear_date,trn_rcms_caseid,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow) select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0 Time elapsed = 5 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 = 4 RecordId = 15711000008411 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 isadjourn = NO adjourn_remark = adjourn_type = 0 next_hear_date = 27/12/2023 trn_rcms_caseid = 15376000000583 case_no = 2015/00027 court_code = 10411 new_case_purpose = 11472000000003 pre_case_purpose = 11472000000003 pre_hear_date = 18/10/2023 TRN_RCMS_HEARINGrow = 15 Posting record Param Type = n trn_rcms_hearingid=15711000008411 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:37 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:37 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=27/12/2023 00:00:00 Param Type = c trn_rcms_caseid=15376000000583 Param Type = c case_no=2015/00027 Param Type = c court_code=10411 Param Type = c new_case_purpose=11472000000003 Param Type = n pre_case_purpose=11472000000003 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = n trn_rcms_hearingrow=15 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 6 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 = 3 RecordId = 15711000008412 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 5 next_hear_date = 18/12/2023 isadjourn = NO adjourn_remark = adjourn_type = 0 trn_rcms_caseid = 11053000000746 court_code = 10411 case_no = 2015/00035 new_case_purpose = 11472000000003 pre_case_purpose = 11472000000003 pre_hear_date = 18/10/2023 TRN_RCMS_HEARINGrow = 16 Posting record Param Type = n trn_rcms_hearingid=15711000008412 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:37 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:37 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=18/12/2023 00:00:00 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c trn_rcms_caseid=11053000000746 Param Type = c court_code=10411 Param Type = c case_no=2015/00035 Param Type = c new_case_purpose=11472000000003 Param Type = n pre_case_purpose=11472000000003 Param Type = c pre_hear_date=18/10/2023 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,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 = 4 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 = 3 RecordId = 15711000008413 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 4 next_hear_date = 30/10/2023 isadjourn = NO adjourn_remark = adjourn_type = 0 new_case_purpose = 11472000000003 case_no = 2017/00161 court_code = 10411 trn_rcms_caseid = 16188000001342 pre_case_purpose = 11472000000003 pre_hear_date = 18/10/2023 TRN_RCMS_HEARINGrow = 17 Posting record Param Type = n trn_rcms_hearingid=15711000008413 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:37 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:37 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=30/10/2023 00:00:00 Param Type = c isadjourn=NO Param Type = c adjourn_type=0 Param Type = c new_case_purpose=11472000000003 Param Type = c case_no=2017/00161 Param Type = c court_code=10411 Param Type = c trn_rcms_caseid=16188000001342 Param Type = n pre_case_purpose=11472000000003 Param Type = c pre_hear_date=18/10/2023 00:00:00 Param Type = n trn_rcms_hearingrow=17 insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 = 4 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 = 3 RecordId = 15711000008414 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 15 Select sysdate as sdt from dual Time elapsed = 4 next_hear_date = 26/12/2023 new_case_purpose = 11472000000003 adjourn_remark = adjourn_type = 0 isadjourn = NO case_no = 2020/01137 court_code = 10411 trn_rcms_caseid = 12100000004955 pre_case_purpose = 11472000000003 pre_hear_date = 18/10/2023 TRN_RCMS_HEARINGrow = 18 Posting record Param Type = n trn_rcms_hearingid=15711000008414 Param Type = n trn_rcms_mhearingid=15711000008396 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:37 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:37 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=26/12/2023 00:00:00 Param Type = c new_case_purpose=11472000000003 Param Type = c adjourn_type=0 Param Type = c isadjourn=NO Param Type = c case_no=2020/01137 Param Type = c court_code=10411 Param Type = c trn_rcms_caseid=12100000004955 Param Type = n pre_case_purpose=11472000000003 Param Type = c pre_hear_date=18/10/2023 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,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 = 3906874665521 >>Executing genmaps >>Posting from trcmf to tchdh from row 1 >>Mapping Mapped court_code Row = 1 value = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 11731000007302 idvalue 0 Mapped case_no Row = 1 value = 2022/238 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 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 = 20/11/2023 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 = 10411 trn_rcms_caseregid = 11731000007302 case_no = 2022/238 prev_hearing_date = 18/10/2023 hearing_date = 20/11/2023 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 = 6 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 = 3 RecordId = 15711000008415 MapName trcmf1 SourceId 15711000008397 Select sysdate as sdt from dual Time elapsed = 4 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 = 20/11/2023 case_no = 2022/238 trn_rcms_caseregid = 11731000007302 court_code = 10411 case_purpose = 18678000000000 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008415 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008397 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:38 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:38 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=20/11/2023 00:00:00 Param Type = c case_no=2022/238 Param Type = c trn_rcms_caseregid=11731000007302 Param Type = c court_code=10411 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 12308000007151 idvalue 0 Mapped case_no Row = 1 value = 2022/245 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 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 = 25/10/2023 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 = 10411 trn_rcms_caseregid = 12308000007151 case_no = 2022/245 prev_hearing_date = 18/10/2023 hearing_date = 25/10/2023 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 = 3 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 5 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 15711000008416 MapName trcmf1 SourceId 15711000008398 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 = 18678000000000 hearing_date = 25/10/2023 case_no = 2022/245 trn_rcms_caseregid = 12308000007151 court_code = 10411 case_purpose = 18678000000000 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008416 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008398 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:38 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:38 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=25/10/2023 00:00:00 Param Type = c case_no=2022/245 Param Type = c trn_rcms_caseregid=12308000007151 Param Type = c court_code=10411 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 12358000007819 idvalue 0 Mapped case_no Row = 1 value = 2022/246 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 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 = 27/12/2023 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 = 10411 trn_rcms_caseregid = 12358000007819 case_no = 2022/246 prev_hearing_date = 18/10/2023 hearing_date = 27/12/2023 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 = 3 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 5 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 = 4 RecordId = 15711000008417 MapName trcmf1 SourceId 15711000008399 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 = 18678000000000 hearing_date = 27/12/2023 case_no = 2022/246 trn_rcms_caseregid = 12358000007819 court_code = 10411 case_purpose = 18678000000000 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008417 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008399 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:38 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:38 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=27/12/2023 00:00:00 Param Type = c case_no=2022/246 Param Type = c trn_rcms_caseregid=12358000007819 Param Type = c court_code=10411 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 13549000007272 idvalue 0 Mapped case_no Row = 1 value = 2022/260 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 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 = 27/12/2023 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 = 10411 trn_rcms_caseregid = 13549000007272 case_no = 2022/260 prev_hearing_date = 18/10/2023 hearing_date = 27/12/2023 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 = 3 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 = 3 RecordId = 15711000008418 MapName trcmf1 SourceId 15711000008400 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 = 27/12/2023 case_no = 2022/260 trn_rcms_caseregid = 13549000007272 court_code = 10411 case_purpose = 18678000000000 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008418 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008400 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:38 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:38 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=27/12/2023 00:00:00 Param Type = c case_no=2022/260 Param Type = c trn_rcms_caseregid=13549000007272 Param Type = c court_code=10411 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 14092000007240 idvalue 0 Mapped case_no Row = 1 value = 2022/263 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 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 = 27/12/2023 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 = 10411 trn_rcms_caseregid = 14092000007240 case_no = 2022/263 prev_hearing_date = 18/10/2023 hearing_date = 27/12/2023 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 = 3 RecordId = 15711000008419 MapName trcmf1 SourceId 15711000008401 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 = 27/12/2023 case_no = 2022/263 trn_rcms_caseregid = 14092000007240 court_code = 10411 case_purpose = 18678000000000 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008419 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008401 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:38 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:38 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=27/12/2023 00:00:00 Param Type = c case_no=2022/263 Param Type = c trn_rcms_caseregid=14092000007240 Param Type = c court_code=10411 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 10633000007022 idvalue 0 Mapped case_no Row = 1 value = 2022/299 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 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 = 27/12/2023 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 = 10411 trn_rcms_caseregid = 10633000007022 case_no = 2022/299 prev_hearing_date = 18/10/2023 hearing_date = 27/12/2023 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 = 3 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 15711000008420 MapName trcmf1 SourceId 15711000008402 Select sysdate as sdt from dual Time elapsed = 4 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 = 27/12/2023 case_no = 2022/299 trn_rcms_caseregid = 10633000007022 court_code = 10411 case_purpose = 18678000000000 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008420 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008402 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:38 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:38 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=27/12/2023 00:00:00 Param Type = c case_no=2022/299 Param Type = c trn_rcms_caseregid=10633000007022 Param Type = c court_code=10411 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 18255000007119 idvalue 0 Mapped case_no Row = 1 value = 2022/310 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 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 = 27/12/2023 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 = 10411 trn_rcms_caseregid = 18255000007119 case_no = 2022/310 prev_hearing_date = 18/10/2023 hearing_date = 27/12/2023 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 = 3 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 = 3 RecordId = 15711000008421 MapName trcmf1 SourceId 15711000008403 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 = 18678000000000 hearing_date = 27/12/2023 case_no = 2022/310 trn_rcms_caseregid = 18255000007119 court_code = 10411 case_purpose = 18678000000000 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008421 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008403 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:38 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:38 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=27/12/2023 00:00:00 Param Type = c case_no=2022/310 Param Type = c trn_rcms_caseregid=18255000007119 Param Type = c court_code=10411 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 10685000006366 idvalue 0 Mapped case_no Row = 1 value = 2022/318 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 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 = 27/12/2023 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 = 10411 trn_rcms_caseregid = 10685000006366 case_no = 2022/318 prev_hearing_date = 18/10/2023 hearing_date = 27/12/2023 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 = 3 RecordId = 15711000008422 MapName trcmf1 SourceId 15711000008404 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 = 27/12/2023 case_no = 2022/318 trn_rcms_caseregid = 10685000006366 court_code = 10411 case_purpose = 18678000000000 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008422 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008404 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:38 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:38 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=27/12/2023 00:00:00 Param Type = c case_no=2022/318 Param Type = c trn_rcms_caseregid=10685000006366 Param Type = c court_code=10411 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 12638000007169 idvalue 0 Mapped case_no Row = 1 value = 2022/414 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 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 = 27/12/2023 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 = 10411 trn_rcms_caseregid = 12638000007169 case_no = 2022/414 prev_hearing_date = 18/10/2023 hearing_date = 27/12/2023 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 = 3 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 = 3 RecordId = 15711000008423 MapName trcmf1 SourceId 15711000008405 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 = 27/12/2023 case_no = 2022/414 trn_rcms_caseregid = 12638000007169 court_code = 10411 case_purpose = 18678000000000 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008423 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008405 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:38 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:38 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=27/12/2023 00:00:00 Param Type = c case_no=2022/414 Param Type = c trn_rcms_caseregid=12638000007169 Param Type = c court_code=10411 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 15182000007284 idvalue 0 Mapped case_no Row = 1 value = 2022/454 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 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 = 27/12/2023 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 = 10411 trn_rcms_caseregid = 15182000007284 case_no = 2022/454 prev_hearing_date = 18/10/2023 hearing_date = 27/12/2023 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 = 15711000008424 MapName trcmf1 SourceId 15711000008406 Select sysdate as sdt from dual Time elapsed = 2 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 = 27/12/2023 case_no = 2022/454 trn_rcms_caseregid = 15182000007284 court_code = 10411 case_purpose = 18678000000000 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008424 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008406 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:39 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:39 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=27/12/2023 00:00:00 Param Type = c case_no=2022/454 Param Type = c trn_rcms_caseregid=15182000007284 Param Type = c court_code=10411 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 17160000007288 idvalue 0 Mapped case_no Row = 1 value = 2023/120 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 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 = 27/12/2023 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 = 10411 trn_rcms_caseregid = 17160000007288 case_no = 2023/120 prev_hearing_date = 18/10/2023 hearing_date = 27/12/2023 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 = 15711000008425 MapName trcmf1 SourceId 15711000008407 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 = 27/12/2023 case_no = 2023/120 trn_rcms_caseregid = 17160000007288 court_code = 10411 case_purpose = 18678000000000 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008425 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008407 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:39 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:39 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=27/12/2023 00:00:00 Param Type = c case_no=2023/120 Param Type = c trn_rcms_caseregid=17160000007288 Param Type = c court_code=10411 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 19718000008900 idvalue 0 Mapped case_no Row = 1 value = 2023/132 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 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/10/2023 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 = 10411 trn_rcms_caseregid = 19718000008900 case_no = 2023/132 prev_hearing_date = 18/10/2023 hearing_date = 19/10/2023 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 = 15711000008426 MapName trcmf1 SourceId 15711000008408 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 = 19/10/2023 case_no = 2023/132 trn_rcms_caseregid = 19718000008900 court_code = 10411 case_purpose = 18678000000000 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008426 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008408 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:39 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:39 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/10/2023 00:00:00 Param Type = c case_no=2023/132 Param Type = c trn_rcms_caseregid=19718000008900 Param Type = c court_code=10411 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 17669000009323 idvalue 0 Mapped case_no Row = 1 value = 2023/150 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 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 = 25/10/2023 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 = 10411 trn_rcms_caseregid = 17669000009323 case_no = 2023/150 prev_hearing_date = 18/10/2023 hearing_date = 25/10/2023 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 = 6 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 15711000008427 MapName trcmf1 SourceId 15711000008409 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 = 25/10/2023 case_no = 2023/150 trn_rcms_caseregid = 17669000009323 court_code = 10411 case_purpose = 18678000000000 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008427 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008409 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:39 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:39 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=25/10/2023 00:00:00 Param Type = c case_no=2023/150 Param Type = c trn_rcms_caseregid=17669000009323 Param Type = c court_code=10411 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 14315000007983 idvalue 0 Mapped case_no Row = 1 value = 2023/160 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 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 = 22/11/2023 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 = 10411 trn_rcms_caseregid = 14315000007983 case_no = 2023/160 prev_hearing_date = 18/10/2023 hearing_date = 22/11/2023 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 = 3 Saving to table TRN_RCMS_CASE_HIST select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0 Time elapsed = 9 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 15711000008428 MapName trcmf1 SourceId 15711000008410 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 = 22/11/2023 case_no = 2023/160 trn_rcms_caseregid = 14315000007983 court_code = 10411 case_purpose = 18678000000000 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008428 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008410 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:39 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:39 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=22/11/2023 00:00:00 Param Type = c case_no=2023/160 Param Type = c trn_rcms_caseregid=14315000007983 Param Type = c court_code=10411 Param Type = c case_purpose=18678000000000 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 15376000000583 idvalue 0 Mapped case_no Row = 1 value = 2015/00027 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0 Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0 Mapped hearing_date Row = 1 value = 27/12/2023 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 = 10411 trn_rcms_caseregid = 15376000000583 case_no = 2015/00027 prev_hearing_date = 18/10/2023 hearing_date = 27/12/2023 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 = 6 prev_case_purpose after validation = 11472000000003 case_purpose = 11472000000003 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 = 5 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 15711000008429 MapName trcmf1 SourceId 15711000008411 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 = 11472000000003 hearing_date = 27/12/2023 case_no = 2015/00027 trn_rcms_caseregid = 15376000000583 court_code = 10411 case_purpose = 11472000000003 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008429 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008411 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:39 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:39 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=11472000000003 Param Type = c hearing_date=27/12/2023 00:00:00 Param Type = c case_no=2015/00027 Param Type = c trn_rcms_caseregid=15376000000583 Param Type = c court_code=10411 Param Type = c case_purpose=11472000000003 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 11053000000746 idvalue 0 Mapped case_no Row = 1 value = 2015/00035 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0 Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0 Mapped hearing_date Row = 1 value = 18/12/2023 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 = 10411 trn_rcms_caseregid = 11053000000746 case_no = 2015/00035 prev_hearing_date = 18/10/2023 hearing_date = 18/12/2023 prev_case_purposename = ???? ????? ???? prev_case_purpose = prev_case_purpose after validation = 11472000000003 case_purpose = 11472000000003 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 = 4 RecordId = 15711000008430 MapName trcmf1 SourceId 15711000008412 Select sysdate as sdt from dual Time elapsed = 4 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 = 11472000000003 hearing_date = 18/12/2023 case_no = 2015/00035 trn_rcms_caseregid = 11053000000746 court_code = 10411 case_purpose = 11472000000003 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008430 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008412 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:39 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:39 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=11472000000003 Param Type = c hearing_date=18/12/2023 00:00:00 Param Type = c case_no=2015/00035 Param Type = c trn_rcms_caseregid=11053000000746 Param Type = c court_code=10411 Param Type = c case_purpose=11472000000003 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 16188000001342 idvalue 0 Mapped case_no Row = 1 value = 2017/00161 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0 Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0 Mapped hearing_date Row = 1 value = 30/10/2023 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 = 10411 trn_rcms_caseregid = 16188000001342 case_no = 2017/00161 prev_hearing_date = 18/10/2023 hearing_date = 30/10/2023 prev_case_purposename = ???? ????? ???? prev_case_purpose = prev_case_purpose after validation = 11472000000003 case_purpose = 11472000000003 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 = 3 RecordId = 15711000008431 MapName trcmf1 SourceId 15711000008413 Select sysdate as sdt from dual Time elapsed = 4 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 = 11472000000003 hearing_date = 30/10/2023 case_no = 2017/00161 trn_rcms_caseregid = 16188000001342 court_code = 10411 case_purpose = 11472000000003 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008431 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008413 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:39 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:39 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=11472000000003 Param Type = c hearing_date=30/10/2023 00:00:00 Param Type = c case_no=2017/00161 Param Type = c trn_rcms_caseregid=16188000001342 Param Type = c court_code=10411 Param Type = c case_purpose=11472000000003 Param Type = c prev_hearing_date=18/10/2023 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 = 10411 idvalue 0 Mapped trn_rcms_caseregid Row = 1 value = 12100000004955 idvalue 0 Mapped case_no Row = 1 value = 2020/01137 idvalue 0 Mapped prev_hearing_date Row = 1 value = 18/10/2023 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0 Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0 Mapped hearing_date Row = 1 value = 26/12/2023 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 = 10411 trn_rcms_caseregid = 12100000004955 case_no = 2020/01137 prev_hearing_date = 18/10/2023 hearing_date = 26/12/2023 prev_case_purposename = ???? ????? ???? prev_case_purpose = prev_case_purpose after validation = 11472000000003 case_purpose = 11472000000003 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 = 15711000008432 MapName trcmf1 SourceId 15711000008414 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 = 11472000000003 hearing_date = 26/12/2023 case_no = 2020/01137 trn_rcms_caseregid = 12100000004955 court_code = 10411 case_purpose = 11472000000003 prev_hearing_date = 18/10/2023 Posting record Param Type = n trn_rcms_case_histid=15711000008432 Param Type = c mapname=trcmf1 Param Type = n sourceid=15711000008414 Param Type = c cancel=F Param Type = c createdby=surajmal Param Type = c createdon=19/10/2023 10:58:39 Param Type = c username=surajmal Param Type = c modifiedon=19/10/2023 10:58:39 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=11472000000003 Param Type = c hearing_date=26/12/2023 00:00:00 Param Type = c case_no=2020/01137 Param Type = c trn_rcms_caseregid=12100000004955 Param Type = c court_code=10411 Param Type = c case_purpose=11472000000003 Param Type = c prev_hearing_date=18/10/2023 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 = 3906874667441 Time elapsed for MD Map = 3906874667442 Time elapsed for Save History = 3906874667442 Time elapsed for Save Attachment = 3906874667443 Time elapsed for After Save WF Exec = 3906874667444 Transaction commited Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"15711000008396"}]} 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=surajmal Param Type = c calledon=19/10/2023 10:57:43 Param Type = c callfinished=19/10/2023 10:57:47 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=4300 Param Type = n dbtimetaken=2550 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