ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
gcmsSDO_Karoli_PRO827ccb0eea8a706c4c34a16891f84e7b![]()
INRF500250000Ffiresql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtname := sqlget({m2},{court_name})firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})m_courttype := sqlget({m3},{court_type})firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})m_courtid := sqlget({m4},{court_name_mastid})firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})login_userid := sqlget({m4},{axusersid})firesql({m4},{select :username as uname from dual})u_name := sqlget({m4},{uname})firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtcode := sqlget({m4},{COURT_CODE})firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})m_statename := sqlget({m2},{STATE_NAME})firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_distName := sqlget({m7},{DISTNAMEENG})firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_courtcatid := sqlget({m8},{COURT_CATEGOTY})firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})m_deptid := sqlget({m4},{department_mastid})firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})m_courttypeid := sqlget({m3},{court_type_mastid})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 })urole := sqlget({m4},{groupname})firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})m_cutoffdt := sqlget({a1},{dd})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})m_offcount := sqlget({P1},{ct})00000F
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
username=SDO_Karoli_PRO
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Karoli_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ????? ???????, ?????,???? -?????
Result = ????? ???????, ?????,???? -?????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=SDO_Karoli_PRO
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Karoli_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = SDO
Result = SDO
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=SDO_Karoli_PRO
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Karoli_PRO
Time elapsed = 2
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 12118000000092
Result = 12118000000092
Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=SDO_Karoli_PRO
Time elapsed = 2
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1485440008440
Result = 1485440008440
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_Karoli_PRO
Time elapsed = 2
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_Karoli_PRO
Result = SDO_Karoli_PRO
Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Karoli_PRO
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10105
Result = 10105
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 = 4
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Karoli_PRO
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Karoli_PRO
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Karauli
Result = Karauli
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Karoli_PRO
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Karoli_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m8},{COURT_CATEGOTY})
Calling function sqlget
Result of sqlget = 10593000000007
Result = 10593000000007
Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
Calling function firesql
login_userid=1485440008440
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1485440008440
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=SDO_Karoli_PRO
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10823000000000
Result = 10823000000000
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=SDO_Karoli_PRO
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=SDO_Karoli_PRO
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_admin
Result = court_admin
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 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=SDO_Karoli_PRO
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=SDO_Karoli_PRO
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 13
Result = 13
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_admin') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 2
select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 3
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_admin,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 2
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : trcmf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 2
Step4
tstructs\stm size:2075
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Evaluating date()
Result =
Evaluating iif((next_hear_date>Validating trcmf
>>Frame No 1
courtcode = 10105
hearing_date = 09/04/2026
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 1
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011723
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
hearing_date = 09/04/2026
courtcode = 10105
Posting record
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:41
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=09/04/2026 00:00:00
Param Type = c
courtcode=10105
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 = 5
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 = 1
RecordId = 13278000011724
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
new_case_purpose = 18473000000000
adjourn_remark =
pre_hear_date = 09/04/2026
case_no = 1998/00002
court_code = 10105
pre_case_purpose = 18473000000000
isadjourn = NO
next_hear_date = 10/04/2026
adjourn_type = 0
trn_rcms_caseid = 41813
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=13278000011724
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:41
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18473000000000
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = c
case_no=1998/00002
Param Type = c
court_code=10105
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=10/04/2026 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=41813
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,new_case_purpose,adjourn_remark,pre_hear_date,case_no,court_code,pre_case_purpose,isadjourn,next_hear_date,adjourn_type,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:pre_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:trn_rcms_caseid,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011725
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
court_code = 10105
case_no = 2009/00015
isadjourn = NO
next_hear_date = 13/04/2026
adjourn_remark =
adjourn_type = 0
pre_hear_date = 09/04/2026
trn_rcms_caseid = 41588
new_case_purpose = 18467000000000
pre_case_purpose = 18467000000000
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=13278000011725
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:41
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10105
Param Type = c
case_no=2009/00015
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=13/04/2026 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = c
trn_rcms_caseid=41588
Param Type = c
new_case_purpose=18467000000000
Param Type = n
pre_case_purpose=18467000000000
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,court_code,case_no,isadjourn,next_hear_date,adjourn_remark,adjourn_type,pre_hear_date,trn_rcms_caseid,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,:court_code,:case_no,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011726
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 09/04/2026
pre_case_purpose = 18467000000000
trn_rcms_caseid = 41646
court_code = 10105
case_no = 2012/00043
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18467000000000
next_hear_date = 04/05/2026
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=13278000011726
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:41
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = n
pre_case_purpose=18467000000000
Param Type = c
trn_rcms_caseid=41646
Param Type = c
court_code=10105
Param Type = c
case_no=2012/00043
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18467000000000
Param Type = c
next_hear_date=04/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011727
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 09/04/2026
pre_case_purpose = 19542000000536
trn_rcms_caseid = 41579
court_code = 10105
case_no = 2014/00040
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 19904000000383
next_hear_date = 10/04/2026
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=13278000011727
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:41
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
trn_rcms_caseid=41579
Param Type = c
court_code=10105
Param Type = c
case_no=2014/00040
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=19904000000383
Param Type = c
next_hear_date=10/04/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011728
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 28/04/2026
new_case_purpose = 18469000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2014/00064
court_code = 10105
trn_rcms_caseid = 41710
pre_case_purpose = 18469000000000
pre_hear_date = 09/04/2026
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=13278000011728
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:41
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/04/2026 00:00:00
Param Type = c
new_case_purpose=18469000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2014/00064
Param Type = c
court_code=10105
Param Type = c
trn_rcms_caseid=41710
Param Type = n
pre_case_purpose=18469000000000
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011729
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 10/04/2026
new_case_purpose = 12555000000002
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2016/00090
court_code = 10105
trn_rcms_caseid = 12562000000293
pre_case_purpose = 12555000000002
pre_hear_date = 09/04/2026
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=13278000011729
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:41
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=10/04/2026 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2016/00090
Param Type = c
court_code=10105
Param Type = c
trn_rcms_caseid=12562000000293
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011730
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 28/04/2026
new_case_purpose = 12555000000002
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2016/00148
court_code = 10105
trn_rcms_caseid = 10698000000672
pre_case_purpose = 12555000000002
pre_hear_date = 09/04/2026
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=13278000011730
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:41
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/04/2026 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2016/00148
Param Type = c
court_code=10105
Param Type = c
trn_rcms_caseid=10698000000672
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011731
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_case_purpose = 18468000000000
new_case_purpose = 18468000000000
next_hear_date = 20/04/2026
pre_hear_date = 09/04/2026
court_code = 10105
case_no = 2016/00021
trn_rcms_caseid = 11848000000162
adjourn_remark =
adjourn_type = 0
isadjourn = NO
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=13278000011731
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:41
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18468000000000
Param Type = c
new_case_purpose=18468000000000
Param Type = c
next_hear_date=20/04/2026 00:00:00
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = c
court_code=10105
Param Type = c
case_no=2016/00021
Param Type = c
trn_rcms_caseid=11848000000162
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
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_case_purpose,new_case_purpose,next_hear_date,pre_hear_date,court_code,case_no,trn_rcms_caseid,adjourn_remark,adjourn_type,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,null,:adjourn_type,:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011732
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trn_rcms_caseid = 13934000005915
new_case_purpose = 18678000000000
next_hear_date = 28/04/2026
pre_case_purpose = 18619000000000
court_code = 10105
case_no = 2020/00060
pre_hear_date = 09/04/2026
adjourn_type = 0
isadjourn = NO
adjourn_remark =
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=13278000011732
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:41
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=13934000005915
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=28/04/2026 00:00:00
Param Type = n
pre_case_purpose=18619000000000
Param Type = c
court_code=10105
Param Type = c
case_no=2020/00060
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
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,trn_rcms_caseid,new_case_purpose,next_hear_date,pre_case_purpose,court_code,case_no,pre_hear_date,adjourn_type,isadjourn,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13278000011733
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 24/04/2026
isadjourn = NO
new_case_purpose = 18466000000000
pre_hear_date = 09/04/2026
pre_case_purpose = 18466000000000
trn_rcms_caseid = 14507000003264
court_code = 10105
adjourn_remark =
case_no = 2020/00043
adjourn_type = 0
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=13278000011733
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:41
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/04/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18466000000000
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
trn_rcms_caseid=14507000003264
Param Type = c
court_code=10105
Param Type = c
case_no=2020/00043
Param Type = c
adjourn_type=0
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,next_hear_date,isadjourn,new_case_purpose,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,adjourn_remark,case_no,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,null,:case_no,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13278000011734
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 09/04/2026
pre_case_purpose = 18467000000000
trn_rcms_caseid = 10080000004687
court_code = 10105
case_no = 2021/7
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18467000000000
next_hear_date = 16/04/2026
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=13278000011734
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:41
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = n
pre_case_purpose=18467000000000
Param Type = c
trn_rcms_caseid=10080000004687
Param Type = c
court_code=10105
Param Type = c
case_no=2021/7
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18467000000000
Param Type = c
next_hear_date=16/04/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13278000011735
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 09/04/2026
pre_case_purpose = 18678000000000
trn_rcms_caseid = 10346000007571
court_code = 10105
case_no = 2022/103
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 23/04/2026
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=13278000011735
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:41
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=10346000007571
Param Type = c
court_code=10105
Param Type = c
case_no=2022/103
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=23/04/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011736
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 1
court_code = 10105
case_no = 2022/104
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 23/04/2026
new_case_purpose = 1000497
pre_case_purpose = 18678000000000
trn_rcms_caseid = 10416000006964
pre_hear_date = 09/04/2026
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=13278000011736
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10105
Param Type = c
case_no=2022/104
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=23/04/2026 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=10416000006964
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,case_no,isadjourn,adjourn_remark,adjourn_type,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:case_no,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011737
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 3
pre_case_purpose = 12555000000002
trn_rcms_caseid = 19451000007814
court_code = 10105
pre_hear_date = 09/04/2026
new_case_purpose = 12555000000002
adjourn_type = 0
adjourn_remark =
next_hear_date = 23/04/2026
isadjourn = NO
case_no = 2023/33
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=13278000011737
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
trn_rcms_caseid=19451000007814
Param Type = c
court_code=10105
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=23/04/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2023/33
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,pre_case_purpose,trn_rcms_caseid,court_code,pre_hear_date,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,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,:pre_case_purpose,:trn_rcms_caseid,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,: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 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011738
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 1
new_case_purpose = 12555000000002
next_hear_date = 23/04/2026
adjourn_type = 0
isadjourn = NO
adjourn_remark =
trn_rcms_caseid = 19564000007875
court_code = 10105
pre_hear_date = 09/04/2026
case_no = 2023/34
pre_case_purpose = 12555000000002
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=13278000011738
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=12555000000002
Param Type = c
next_hear_date=23/04/2026 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=19564000007875
Param Type = c
court_code=10105
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = c
case_no=2023/34
Param Type = n
pre_case_purpose=12555000000002
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,new_case_purpose,next_hear_date,adjourn_type,isadjourn,adjourn_remark,trn_rcms_caseid,court_code,pre_hear_date,case_no,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,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:trn_rcms_caseid,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:pre_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 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13278000011739
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 09/04/2026
pre_case_purpose = 18469000000000
trn_rcms_caseid = 18848000007687
court_code = 10105
case_no = 2023/42
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18469000000000
next_hear_date = 16/04/2026
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=13278000011739
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = n
pre_case_purpose=18469000000000
Param Type = c
trn_rcms_caseid=18848000007687
Param Type = c
court_code=10105
Param Type = c
case_no=2023/42
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18469000000000
Param Type = c
next_hear_date=16/04/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13278000011740
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark =
trn_rcms_caseid = 11348000009250
adjourn_type = 0
court_code = 10105
case_no = 2025/3
pre_hear_date = 09/04/2026
new_case_purpose = 19904000000383
next_hear_date = 20/04/2026
pre_case_purpose = 18473000000000
isadjourn = NO
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=13278000011740
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=11348000009250
Param Type = c
adjourn_type=0
Param Type = c
court_code=10105
Param Type = c
case_no=2025/3
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = c
new_case_purpose=19904000000383
Param Type = c
next_hear_date=20/04/2026 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
isadjourn=NO
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,adjourn_remark,trn_rcms_caseid,adjourn_type,court_code,case_no,pre_hear_date,new_case_purpose,next_hear_date,pre_case_purpose,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,:adjourn_type,:court_code,:case_no,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'),:pre_case_purpose,:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011741
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
trn_rcms_caseid = 10657000011174
pre_hear_date = 09/04/2026
court_code = 10105
case_no = 2025/118
pre_case_purpose = 1000497
isadjourn = NO
adjourn_type = 0
new_case_purpose = 1000497
next_hear_date = 16/04/2026
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=13278000011741
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=10657000011174
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = c
court_code=10105
Param Type = c
case_no=2025/118
Param Type = n
pre_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=16/04/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011742
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 16083000009930
pre_hear_date = 09/04/2026
court_code = 10105
case_no = 2025/132
next_hear_date = 16/04/2026
isadjourn = NO
pre_case_purpose = 1000497
new_case_purpose = 1000497
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=13278000011742
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=16083000009930
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = c
court_code=10105
Param Type = c
case_no=2025/132
Param Type = c
next_hear_date=16/04/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=1000497
Param Type = c
new_case_purpose=1000497
Param Type = n
trn_rcms_hearingrow=19
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 = 3
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13278000011743
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 18476000011749
case_no = 2025/217
new_case_purpose = 18678000000000
pre_hear_date = 09/04/2026
next_hear_date = 16/04/2026
isadjourn = NO
court_code = 10105
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=13278000011743
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18476000011749
Param Type = c
case_no=2025/217
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = c
next_hear_date=16/04/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
court_code=10105
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,new_case_purpose,pre_hear_date,next_hear_date,isadjourn,court_code,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,:trn_rcms_caseid,:case_no,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:court_code,:pre_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 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13278000011744
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 =
isadjourn = NO
trn_rcms_caseid = 18562000012764
case_no = 2025/218
court_code = 10105
pre_hear_date = 09/04/2026
next_hear_date = 13/04/2026
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=13278000011744
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
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=18562000012764
Param Type = c
case_no=2025/218
Param Type = c
court_code=10105
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = c
next_hear_date=13/04/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011745
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 12954000010438
case_no = 2025/38
court_code = 10105
pre_hear_date = 09/04/2026
next_hear_date = 28/04/2026
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=13278000011745
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=12954000010438
Param Type = c
case_no=2025/38
Param Type = c
court_code=10105
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = c
next_hear_date=28/04/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13278000011746
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 17/04/2026
case_no = 2025/193
court_code = 10105
trn_rcms_caseid = 19535000010874
new_case_purpose = 18468000000000
pre_case_purpose = 18468000000000
pre_hear_date = 09/04/2026
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=13278000011746
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
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=17/04/2026 00:00:00
Param Type = c
case_no=2025/193
Param Type = c
court_code=10105
Param Type = c
trn_rcms_caseid=19535000010874
Param Type = c
new_case_purpose=18468000000000
Param Type = n
pre_case_purpose=18468000000000
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,case_no,court_code,trn_rcms_caseid,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'),:case_no,:court_code,:trn_rcms_caseid,: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 = 5
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13278000011747
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 16/04/2026
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 13441000011532
case_no = 2026/27
court_code = 10105
new_case_purpose = 1000497
pre_case_purpose = 1000497
pre_hear_date = 09/04/2026
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=13278000011747
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/04/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13441000011532
Param Type = c
case_no=2026/27
Param Type = c
court_code=10105
Param Type = c
new_case_purpose=1000497
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,: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 = 2
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011748
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 27/04/2026
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18678000000000
case_no = 2026/11
court_code = 10105
trn_rcms_caseid = 17832000011699
pre_case_purpose = 18678000000000
pre_hear_date = 09/04/2026
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=13278000011748
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=27/04/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
case_no=2026/11
Param Type = c
court_code=10105
Param Type = c
trn_rcms_caseid=17832000011699
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 2
Adding new record to store data from Frame 2, Row 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011749
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 1
next_hear_date = 13/04/2026
new_case_purpose = 18678000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2026/19
court_code = 10105
trn_rcms_caseid = 18261000012151
pre_case_purpose = 18678000000000
pre_hear_date = 09/04/2026
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=13278000011749
Param Type = n
trn_rcms_mhearingid=13278000011723
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=13/04/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2026/19
Param Type = c
court_code=10105
Param Type = c
trn_rcms_caseid=18261000012151
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=09/04/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_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 = 3984985480784
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 41813 idvalue 0
Mapped case_no Row = 1 value = 1998/00002 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 10/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 41813
case_no = 1998/00002
prev_hearing_date = 09/04/2026
hearing_date = 10/04/2026
prev_case_purposename = ???
prev_case_purpose =
prev_case_purposename=???
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???
Time elapsed = 3
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13278000011750
MapName trcmf1
SourceId 13278000011724
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 10/04/2026
case_no = 1998/00002
trn_rcms_caseregid = 41813
court_code = 10105
case_purpose = 18473000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011750
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011724
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:42
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=10/04/2026 00:00:00
Param Type = c
case_no=1998/00002
Param Type = c
trn_rcms_caseregid=41813
Param Type = c
court_code=10105
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 2
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 41588 idvalue 0
Mapped case_no Row = 1 value = 2009/00015 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18467000000000 idvalue 0
Mapped hearing_date Row = 1 value = 13/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 41588
case_no = 2009/00015
prev_hearing_date = 09/04/2026
hearing_date = 13/04/2026
prev_case_purposename = ??????? ???? ????
prev_case_purpose =
prev_case_purposename=??????? ???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ???? ????
Time elapsed = 2
prev_case_purpose after validation = 18467000000000
case_purpose = 18467000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011751
MapName trcmf1
SourceId 13278000011725
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 = 18467000000000
hearing_date = 13/04/2026
case_no = 2009/00015
trn_rcms_caseregid = 41588
court_code = 10105
case_purpose = 18467000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011751
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011725
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:43
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18467000000000
Param Type = c
hearing_date=13/04/2026 00:00:00
Param Type = c
case_no=2009/00015
Param Type = c
trn_rcms_caseregid=41588
Param Type = c
court_code=10105
Param Type = c
case_purpose=18467000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 3
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 41646 idvalue 0
Mapped case_no Row = 1 value = 2012/00043 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18467000000000 idvalue 0
Mapped hearing_date Row = 1 value = 04/05/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 41646
case_no = 2012/00043
prev_hearing_date = 09/04/2026
hearing_date = 04/05/2026
prev_case_purposename = ??????? ???? ????
prev_case_purpose =
prev_case_purpose after validation = 18467000000000
case_purpose = 18467000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011752
MapName trcmf1
SourceId 13278000011726
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 1
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18467000000000
hearing_date = 04/05/2026
case_no = 2012/00043
trn_rcms_caseregid = 41646
court_code = 10105
case_purpose = 18467000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011752
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011726
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:44
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18467000000000
Param Type = c
hearing_date=04/05/2026 00:00:00
Param Type = c
case_no=2012/00043
Param Type = c
trn_rcms_caseregid=41646
Param Type = c
court_code=10105
Param Type = c
case_purpose=18467000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 4
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 41579 idvalue 0
Mapped case_no Row = 1 value = 2014/00040 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19904000000383 idvalue 0
Mapped hearing_date Row = 1 value = 10/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 41579
case_no = 2014/00040
prev_hearing_date = 09/04/2026
hearing_date = 10/04/2026
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purposename=??? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??? ????????? ????
Time elapsed = 2
prev_case_purpose after validation = 19542000000536
case_purpose = 19904000000383
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011753
MapName trcmf1
SourceId 13278000011727
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 10/04/2026
case_no = 2014/00040
trn_rcms_caseregid = 41579
court_code = 10105
case_purpose = 19904000000383
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011753
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011727
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:44
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=10/04/2026 00:00:00
Param Type = c
case_no=2014/00040
Param Type = c
trn_rcms_caseregid=41579
Param Type = c
court_code=10105
Param Type = c
case_purpose=19904000000383
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 5
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 41710 idvalue 0
Mapped case_no Row = 1 value = 2014/00064 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18469000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 41710
case_no = 2014/00064
prev_hearing_date = 09/04/2026
hearing_date = 28/04/2026
prev_case_purposename = ??????? ????????? ????
prev_case_purpose =
prev_case_purposename=??????? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ????????? ????
Time elapsed = 2
prev_case_purpose after validation = 18469000000000
case_purpose = 18469000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011754
MapName trcmf1
SourceId 13278000011728
Select sysdate as sdt from dual
Time elapsed = 1
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 = 18469000000000
hearing_date = 28/04/2026
case_no = 2014/00064
trn_rcms_caseregid = 41710
court_code = 10105
case_purpose = 18469000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011754
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011728
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:45
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18469000000000
Param Type = c
hearing_date=28/04/2026 00:00:00
Param Type = c
case_no=2014/00064
Param Type = c
trn_rcms_caseregid=41710
Param Type = c
court_code=10105
Param Type = c
case_purpose=18469000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 6
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12562000000293 idvalue 0
Mapped case_no Row = 1 value = 2016/00090 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 10/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 12562000000293
case_no = 2016/00090
prev_hearing_date = 09/04/2026
hearing_date = 10/04/2026
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purposename=???? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????????? ????
Time elapsed = 3
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 1
RecordId = 13278000011755
MapName trcmf1
SourceId 13278000011729
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 10/04/2026
case_no = 2016/00090
trn_rcms_caseregid = 12562000000293
court_code = 10105
case_purpose = 12555000000002
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011755
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011729
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:46
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=10/04/2026 00:00:00
Param Type = c
case_no=2016/00090
Param Type = c
trn_rcms_caseregid=12562000000293
Param Type = c
court_code=10105
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 7
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10698000000672 idvalue 0
Mapped case_no Row = 1 value = 2016/00148 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 28/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 10698000000672
case_no = 2016/00148
prev_hearing_date = 09/04/2026
hearing_date = 28/04/2026
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011756
MapName trcmf1
SourceId 13278000011730
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 28/04/2026
case_no = 2016/00148
trn_rcms_caseregid = 10698000000672
court_code = 10105
case_purpose = 12555000000002
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011756
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011730
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:46
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=28/04/2026 00:00:00
Param Type = c
case_no=2016/00148
Param Type = c
trn_rcms_caseregid=10698000000672
Param Type = c
court_code=10105
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 8
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11848000000162 idvalue 0
Mapped case_no Row = 1 value = 2016/00021 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 18468000000000 idvalue 0
Mapped hearing_date Row = 1 value = 20/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 11848000000162
case_no = 2016/00021
prev_hearing_date = 09/04/2026
hearing_date = 20/04/2026
prev_case_purposename = ??????? ?????????
prev_case_purpose =
prev_case_purposename=??????? ?????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ?????????
Time elapsed = 2
prev_case_purpose after validation = 18468000000000
case_purpose = 18468000000000
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 = 211
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 = 2
RecordId = 13278000011757
MapName trcmf1
SourceId 13278000011731
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 = 18468000000000
hearing_date = 20/04/2026
case_no = 2016/00021
trn_rcms_caseregid = 11848000000162
court_code = 10105
case_purpose = 18468000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011757
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011731
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:47
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18468000000000
Param Type = c
hearing_date=20/04/2026 00:00:00
Param Type = c
case_no=2016/00021
Param Type = c
trn_rcms_caseregid=11848000000162
Param Type = c
court_code=10105
Param Type = c
case_purpose=18468000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 9
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13934000005915 idvalue 0
Mapped case_no Row = 1 value = 2020/00060 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 13934000005915
case_no = 2020/00060
prev_hearing_date = 09/04/2026
hearing_date = 28/04/2026
prev_case_purposename = ??????? ?????
prev_case_purpose =
prev_case_purposename=??????? ?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ?????
Time elapsed = 3
prev_case_purpose after validation = 18619000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011758
MapName trcmf1
SourceId 13278000011732
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 = 18619000000000
hearing_date = 28/04/2026
case_no = 2020/00060
trn_rcms_caseregid = 13934000005915
court_code = 10105
case_purpose = 18678000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011758
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011732
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:48
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18619000000000
Param Type = c
hearing_date=28/04/2026 00:00:00
Param Type = c
case_no=2020/00060
Param Type = c
trn_rcms_caseregid=13934000005915
Param Type = c
court_code=10105
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 10
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14507000003264 idvalue 0
Mapped case_no Row = 1 value = 2020/00043 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 24/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 14507000003264
case_no = 2020/00043
prev_hearing_date = 09/04/2026
hearing_date = 24/04/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purposename=??????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ????
Time elapsed = 4
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
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 = 13278000011759
MapName trcmf1
SourceId 13278000011733
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 = 18466000000000
hearing_date = 24/04/2026
case_no = 2020/00043
trn_rcms_caseregid = 14507000003264
court_code = 10105
case_purpose = 18466000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011759
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011733
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:48
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=24/04/2026 00:00:00
Param Type = c
case_no=2020/00043
Param Type = c
trn_rcms_caseregid=14507000003264
Param Type = c
court_code=10105
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 11
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10080000004687 idvalue 0
Mapped case_no Row = 1 value = 2021/7 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18467000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 10080000004687
case_no = 2021/7
prev_hearing_date = 09/04/2026
hearing_date = 16/04/2026
prev_case_purposename = ??????? ???? ????
prev_case_purpose =
prev_case_purposename=??????? ???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ???? ????
Time elapsed = 3
prev_case_purpose after validation = 18467000000000
case_purpose = 18467000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13278000011760
MapName trcmf1
SourceId 13278000011734
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 1
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18467000000000
hearing_date = 16/04/2026
case_no = 2021/7
trn_rcms_caseregid = 10080000004687
court_code = 10105
case_purpose = 18467000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011760
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011734
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:49
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18467000000000
Param Type = c
hearing_date=16/04/2026 00:00:00
Param Type = c
case_no=2021/7
Param Type = c
trn_rcms_caseregid=10080000004687
Param Type = c
court_code=10105
Param Type = c
case_purpose=18467000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 12
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10346000007571 idvalue 0
Mapped case_no Row = 1 value = 2022/103 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 23/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 10346000007571
case_no = 2022/103
prev_hearing_date = 09/04/2026
hearing_date = 23/04/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 3
prev_case_purpose after validation = 18678000000000
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011761
MapName trcmf1
SourceId 13278000011735
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 = 23/04/2026
case_no = 2022/103
trn_rcms_caseregid = 10346000007571
court_code = 10105
case_purpose = 1000497
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011761
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011735
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:50
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=23/04/2026 00:00:00
Param Type = c
case_no=2022/103
Param Type = c
trn_rcms_caseregid=10346000007571
Param Type = c
court_code=10105
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 13
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10416000006964 idvalue 0
Mapped case_no Row = 1 value = 2022/104 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 23/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 10416000006964
case_no = 2022/104
prev_hearing_date = 09/04/2026
hearing_date = 23/04/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 1
RecordId = 13278000011762
MapName trcmf1
SourceId 13278000011736
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 = 23/04/2026
case_no = 2022/104
trn_rcms_caseregid = 10416000006964
court_code = 10105
case_purpose = 1000497
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011762
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011736
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:50
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=23/04/2026 00:00:00
Param Type = c
case_no=2022/104
Param Type = c
trn_rcms_caseregid=10416000006964
Param Type = c
court_code=10105
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 14
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19451000007814 idvalue 0
Mapped case_no Row = 1 value = 2023/33 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 23/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 19451000007814
case_no = 2023/33
prev_hearing_date = 09/04/2026
hearing_date = 23/04/2026
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purposename=???? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????????? ????
Time elapsed = 3
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011763
MapName trcmf1
SourceId 13278000011737
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 23/04/2026
case_no = 2023/33
trn_rcms_caseregid = 19451000007814
court_code = 10105
case_purpose = 12555000000002
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011763
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011737
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:51
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=23/04/2026 00:00:00
Param Type = c
case_no=2023/33
Param Type = c
trn_rcms_caseregid=19451000007814
Param Type = c
court_code=10105
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 15
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19564000007875 idvalue 0
Mapped case_no Row = 1 value = 2023/34 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 23/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 19564000007875
case_no = 2023/34
prev_hearing_date = 09/04/2026
hearing_date = 23/04/2026
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011764
MapName trcmf1
SourceId 13278000011738
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 23/04/2026
case_no = 2023/34
trn_rcms_caseregid = 19564000007875
court_code = 10105
case_purpose = 12555000000002
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011764
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011738
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:52
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=23/04/2026 00:00:00
Param Type = c
case_no=2023/34
Param Type = c
trn_rcms_caseregid=19564000007875
Param Type = c
court_code=10105
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 16
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18848000007687 idvalue 0
Mapped case_no Row = 1 value = 2023/42 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18469000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 18848000007687
case_no = 2023/42
prev_hearing_date = 09/04/2026
hearing_date = 16/04/2026
prev_case_purposename = ??????? ????????? ????
prev_case_purpose =
prev_case_purposename=??????? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ????????? ????
Time elapsed = 4
prev_case_purpose after validation = 18469000000000
case_purpose = 18469000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 14
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13278000011765
MapName trcmf1
SourceId 13278000011739
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 = 18469000000000
hearing_date = 16/04/2026
case_no = 2023/42
trn_rcms_caseregid = 18848000007687
court_code = 10105
case_purpose = 18469000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011765
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011739
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:52
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18469000000000
Param Type = c
hearing_date=16/04/2026 00:00:00
Param Type = c
case_no=2023/42
Param Type = c
trn_rcms_caseregid=18848000007687
Param Type = c
court_code=10105
Param Type = c
case_purpose=18469000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 17
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11348000009250 idvalue 0
Mapped case_no Row = 1 value = 2025/3 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 19904000000383 idvalue 0
Mapped hearing_date Row = 1 value = 20/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 11348000009250
case_no = 2025/3
prev_hearing_date = 09/04/2026
hearing_date = 20/04/2026
prev_case_purposename = ???
prev_case_purpose =
prev_case_purposename=???
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???
Time elapsed = 3
prev_case_purpose after validation = 18473000000000
case_purpose = 19904000000383
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011766
MapName trcmf1
SourceId 13278000011740
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 20/04/2026
case_no = 2025/3
trn_rcms_caseregid = 11348000009250
court_code = 10105
case_purpose = 19904000000383
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011766
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011740
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:53
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=20/04/2026 00:00:00
Param Type = c
case_no=2025/3
Param Type = c
trn_rcms_caseregid=11348000009250
Param Type = c
court_code=10105
Param Type = c
case_purpose=19904000000383
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 18
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10657000011174 idvalue 0
Mapped case_no Row = 1 value = 2025/118 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 16/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 10657000011174
case_no = 2025/118
prev_hearing_date = 09/04/2026
hearing_date = 16/04/2026
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purposename=???? ?????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????????
Time elapsed = 3
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011767
MapName trcmf1
SourceId 13278000011741
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 16/04/2026
case_no = 2025/118
trn_rcms_caseregid = 10657000011174
court_code = 10105
case_purpose = 1000497
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011767
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011741
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:54
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=16/04/2026 00:00:00
Param Type = c
case_no=2025/118
Param Type = c
trn_rcms_caseregid=10657000011174
Param Type = c
court_code=10105
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 19
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16083000009930 idvalue 0
Mapped case_no Row = 1 value = 2025/132 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 16/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 16083000009930
case_no = 2025/132
prev_hearing_date = 09/04/2026
hearing_date = 16/04/2026
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011768
MapName trcmf1
SourceId 13278000011742
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 = 1000497
hearing_date = 16/04/2026
case_no = 2025/132
trn_rcms_caseregid = 16083000009930
court_code = 10105
case_purpose = 1000497
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011768
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011742
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:54
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=16/04/2026 00:00:00
Param Type = c
case_no=2025/132
Param Type = c
trn_rcms_caseregid=16083000009930
Param Type = c
court_code=10105
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 20
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18476000011749 idvalue 0
Mapped case_no Row = 1 value = 2025/217 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 18476000011749
case_no = 2025/217
prev_hearing_date = 09/04/2026
hearing_date = 16/04/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 2
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011769
MapName trcmf1
SourceId 13278000011743
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 = 16/04/2026
case_no = 2025/217
trn_rcms_caseregid = 18476000011749
court_code = 10105
case_purpose = 18678000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011769
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011743
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:55
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=16/04/2026 00:00:00
Param Type = c
case_no=2025/217
Param Type = c
trn_rcms_caseregid=18476000011749
Param Type = c
court_code=10105
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 21
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18562000012764 idvalue 0
Mapped case_no Row = 1 value = 2025/218 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 13/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 18562000012764
case_no = 2025/218
prev_hearing_date = 09/04/2026
hearing_date = 13/04/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011770
MapName trcmf1
SourceId 13278000011744
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 = 13/04/2026
case_no = 2025/218
trn_rcms_caseregid = 18562000012764
court_code = 10105
case_purpose = 18678000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011770
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011744
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:55
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=13/04/2026 00:00:00
Param Type = c
case_no=2025/218
Param Type = c
trn_rcms_caseregid=18562000012764
Param Type = c
court_code=10105
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 22
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12954000010438 idvalue 0
Mapped case_no Row = 1 value = 2025/38 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 12954000010438
case_no = 2025/38
prev_hearing_date = 09/04/2026
hearing_date = 28/04/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 2
RecordId = 13278000011771
MapName trcmf1
SourceId 13278000011745
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 = 28/04/2026
case_no = 2025/38
trn_rcms_caseregid = 12954000010438
court_code = 10105
case_purpose = 18678000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011771
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011745
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:56
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=28/04/2026 00:00:00
Param Type = c
case_no=2025/38
Param Type = c
trn_rcms_caseregid=12954000010438
Param Type = c
court_code=10105
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 23
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19535000010874 idvalue 0
Mapped case_no Row = 1 value = 2025/193 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 18468000000000 idvalue 0
Mapped hearing_date Row = 1 value = 17/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 19535000010874
case_no = 2025/193
prev_hearing_date = 09/04/2026
hearing_date = 17/04/2026
prev_case_purposename = ??????? ?????????
prev_case_purpose =
prev_case_purposename=??????? ?????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ?????????
Time elapsed = 4
prev_case_purpose after validation = 18468000000000
case_purpose = 18468000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13278000011772
MapName trcmf1
SourceId 13278000011746
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 = 18468000000000
hearing_date = 17/04/2026
case_no = 2025/193
trn_rcms_caseregid = 19535000010874
court_code = 10105
case_purpose = 18468000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011772
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011746
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:57
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18468000000000
Param Type = c
hearing_date=17/04/2026 00:00:00
Param Type = c
case_no=2025/193
Param Type = c
trn_rcms_caseregid=19535000010874
Param Type = c
court_code=10105
Param Type = c
case_purpose=18468000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 24
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13441000011532 idvalue 0
Mapped case_no Row = 1 value = 2026/27 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 16/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 13441000011532
case_no = 2026/27
prev_hearing_date = 09/04/2026
hearing_date = 16/04/2026
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purposename=???? ?????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????????
Time elapsed = 2
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13278000011773
MapName trcmf1
SourceId 13278000011747
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 16/04/2026
case_no = 2026/27
trn_rcms_caseregid = 13441000011532
court_code = 10105
case_purpose = 1000497
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011773
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011747
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:57
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=16/04/2026 00:00:00
Param Type = c
case_no=2026/27
Param Type = c
trn_rcms_caseregid=13441000011532
Param Type = c
court_code=10105
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 25
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17832000011699 idvalue 0
Mapped case_no Row = 1 value = 2026/11 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 27/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 17832000011699
case_no = 2026/11
prev_hearing_date = 09/04/2026
hearing_date = 27/04/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 2
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13278000011774
MapName trcmf1
SourceId 13278000011748
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/04/2026
case_no = 2026/11
trn_rcms_caseregid = 17832000011699
court_code = 10105
case_purpose = 18678000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011774
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011748
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:58
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:58
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/04/2026 00:00:00
Param Type = c
case_no=2026/11
Param Type = c
trn_rcms_caseregid=17832000011699
Param Type = c
court_code=10105
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 26
>>Mapping
Mapped court_code Row = 1 value = 10105 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18261000012151 idvalue 0
Mapped case_no Row = 1 value = 2026/19 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/04/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 13/04/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10105
trn_rcms_caseregid = 18261000012151
case_no = 2026/19
prev_hearing_date = 09/04/2026
hearing_date = 13/04/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 13278000011775
MapName trcmf1
SourceId 13278000011749
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 13/04/2026
case_no = 2026/19
trn_rcms_caseregid = 18261000012151
court_code = 10105
case_purpose = 18678000000000
prev_hearing_date = 09/04/2026
Posting record
Param Type = n
trn_rcms_case_histid=13278000011775
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13278000011749
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Karoli_PRO
Param Type = c
createdon=10/04/2026 12:24:58
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
modifiedon=10/04/2026 12:24:58
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=13/04/2026 00:00:00
Param Type = c
case_no=2026/19
Param Type = c
trn_rcms_caseregid=18261000012151
Param Type = c
court_code=10105
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=09/04/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
Time elapsed for Gen Map = 3984985497932
Time elapsed for MD Map = 3984985497932
Time elapsed for Save History = 3984985497933
Time elapsed for Save Attachment = 3984985497933
Time elapsed for After Save WF Exec = 3984985497938
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"13278000011723"}]}
Savedata webservice completed
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=SDO_Karoli_PRO
Param Type = c
calledon=10/04/2026 12:24:39
Param Type = c
callfinished=10/04/2026 12:24:57
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=18241
Param Type = n
dbtimetaken=17354
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