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_Baap827ccb0eea8a706c4c34a16891f84e7b![]()
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_Baap
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Baap
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ????? ???????,???,?????
Result = ????? ???????,???,?????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=SDO_Baap
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Baap
Time elapsed = 5
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_Baap
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Baap
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 13816000000026
Result = 13816000000026
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_Baap
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 4135
Result = 4135
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_Baap
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_Baap
Result = SDO_Baap
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_Baap
Time elapsed = 2
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10479
Result = 10479
Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Baap
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Baap
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Phalodi
Result = Phalodi
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Baap
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Baap
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m8},{COURT_CATEGOTY})
Calling function sqlget
Result of sqlget = 10593000000007
Result = 10593000000007
Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
Calling function firesql
login_userid=4135
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=4135
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=SDO_Baap
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10823000000000
Result = 10823000000000
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=SDO_Baap
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_Baap
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_admin
Result = court_admin
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 2
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=SDO_Baap
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_Baap
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 5
Result = 5
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_admin') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 1
select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 4
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 = 10479
hearing_date = 19/05/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 = 2
RecordId = 14502000012884
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
hearing_date = 19/05/2026
courtcode = 10479
Posting record
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=19/05/2026 00:00:00
Param Type = c
courtcode=10479
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 = 2
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 = 14502000012885
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
case_no = 2022/415
trn_rcms_caseid = 16291000009014
pre_hear_date = 19/05/2026
court_code = 10479
isadjourn = NO
adjourn_type = 0
adjourn_remark =
pre_case_purpose = 18473000000000
new_case_purpose = 18473000000000
next_hear_date = 22/06/2026
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=14502000012885
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2022/415
Param Type = c
trn_rcms_caseid=16291000009014
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = c
court_code=10479
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_rcms_caseid,pre_hear_date,court_code,isadjourn,adjourn_type,adjourn_remark,pre_case_purpose,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,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:isadjourn,:adjourn_type,null,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012886
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 22/06/2026
isadjourn = NO
new_case_purpose = 1000525
pre_case_purpose = 1000525
pre_hear_date = 19/05/2026
case_no = 2022/281
court_code = 10479
trn_rcms_caseid = 15540000008071
adjourn_type = 0
adjourn_remark =
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=14502000012886
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000525
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = c
case_no=2022/281
Param Type = c
court_code=10479
Param Type = c
trn_rcms_caseid=15540000008071
Param Type = c
adjourn_type=0
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,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_type,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:adjourn_type,null,: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 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14502000012887
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 19/05/2026
pre_case_purpose = 1000497
trn_rcms_caseid = 19964000008900
court_code = 10479
case_no = 2022/343
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 22/06/2026
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=14502000012887
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=19964000008900
Param Type = c
court_code=10479
Param Type = c
case_no=2022/343
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=22/06/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 = 4
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012888
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 22/06/2026
new_case_purpose = 1000497
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2022/450
court_code = 10479
trn_rcms_caseid = 13793000009329
pre_case_purpose = 1000497
pre_hear_date = 19/05/2026
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=14502000012888
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/450
Param Type = c
court_code=10479
Param Type = c
trn_rcms_caseid=13793000009329
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012889
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 22/06/2026
new_case_purpose = 1000525
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/128
court_code = 10479
trn_rcms_caseid = 18781000011200
pre_case_purpose = 1000525
pre_hear_date = 19/05/2026
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=14502000012889
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/128
Param Type = c
court_code=10479
Param Type = c
trn_rcms_caseid=18781000011200
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=19/05/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 = 14502000012890
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
next_hear_date = 22/06/2026
new_case_purpose = 1000497
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/227
court_code = 10479
trn_rcms_caseid = 15104000007560
pre_case_purpose = 1000497
pre_hear_date = 19/05/2026
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=14502000012890
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/227
Param Type = c
court_code=10479
Param Type = c
trn_rcms_caseid=15104000007560
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012891
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 19/05/2026
pre_case_purpose = 1000497
trn_rcms_caseid = 15472000007597
court_code = 10479
case_no = 2023/38
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 22/06/2026
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=14502000012891
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=15472000007597
Param Type = c
court_code=10479
Param Type = c
case_no=2023/38
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=22/06/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,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012892
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 22/06/2026
case_no = 2023/51
court_code = 10479
trn_rcms_caseid = 13349000008722
pre_case_purpose = 1000497
pre_hear_date = 19/05/2026
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=14502000012892
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
case_no=2023/51
Param Type = c
court_code=10479
Param Type = c
trn_rcms_caseid=13349000008722
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 14502000012893
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 22/06/2026
new_case_purpose = 18678000000000
adjourn_type = 0
isadjourn = NO
pre_case_purpose = 18678000000000
case_no = 2023/224
court_code = 10479
pre_hear_date = 19/05/2026
trn_rcms_caseid = 12839000009337
adjourn_remark =
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=14502000012893
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2023/224
Param Type = c
court_code=10479
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = c
trn_rcms_caseid=12839000009337
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_type,isadjourn,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:isadjourn,:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 1
RecordId = 14502000012894
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_type = 0
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
isadjourn = NO
next_hear_date = 22/06/2026
case_no = 2023/225
court_code = 10479
trn_rcms_caseid = 11061000008212
adjourn_remark =
pre_hear_date = 19/05/2026
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=14502000012894
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
case_no=2023/225
Param Type = c
court_code=10479
Param Type = c
trn_rcms_caseid=11061000008212
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,pre_case_purpose,new_case_purpose,isadjourn,next_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_remark,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,:pre_case_purpose,:new_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 14502000012895
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
court_code = 10479
adjourn_type = 0
isadjourn = NO
case_no = 2024/389
adjourn_remark =
next_hear_date = 22/06/2026
pre_case_purpose = 1000525
pre_hear_date = 19/05/2026
new_case_purpose = 1000525
trn_rcms_caseid = 12696000010449
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=14502000012895
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10479
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/389
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = c
trn_rcms_caseid=12696000010449
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,court_code,adjourn_type,isadjourn,case_no,adjourn_remark,next_hear_date,pre_case_purpose,pre_hear_date,new_case_purpose,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,:court_code,:adjourn_type,:isadjourn,:case_no,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,: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 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012896
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 19/05/2026
pre_case_purpose = 1000497
court_code = 10479
case_no = 2024/316
trn_rcms_caseid = 15256000010999
new_case_purpose = 1000497
adjourn_type = 0
adjourn_remark =
next_hear_date = 22/06/2026
isadjourn = NO
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=14502000012896
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
court_code=10479
Param Type = c
case_no=2024/316
Param Type = c
trn_rcms_caseid=15256000010999
Param Type = c
new_case_purpose=1000497
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
isadjourn=NO
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,court_code,case_no,trn_rcms_caseid,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,:case_no,:trn_rcms_caseid,:new_case_purpose,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 14502000012897
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 1
case_no = 2024/364
new_case_purpose = 1000497
pre_case_purpose = 1000497
trn_rcms_caseid = 18635000009878
pre_hear_date = 19/05/2026
adjourn_remark =
court_code = 10479
adjourn_type = 0
next_hear_date = 22/06/2026
isadjourn = NO
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=14502000012897
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2024/364
Param Type = c
new_case_purpose=1000497
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=18635000009878
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = c
court_code=10479
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
isadjourn=NO
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,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012898
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 22/06/2026
new_case_purpose = 12555000000002
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/275
court_code = 10479
trn_rcms_caseid = 16138000008368
pre_case_purpose = 12555000000002
pre_hear_date = 19/05/2026
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=14502000012898
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/06/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=2024/275
Param Type = c
court_code=10479
Param Type = c
trn_rcms_caseid=16138000008368
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=14
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012899
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 19/05/2026
pre_case_purpose = 12555000000002
trn_rcms_caseid = 12798000010267
court_code = 10479
case_no = 2024/446
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 22/06/2026
new_case_purpose = 12555000000002
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=14502000012899
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
trn_rcms_caseid=12798000010267
Param Type = c
court_code=10479
Param Type = c
case_no=2024/446
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
new_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,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_remark,adjourn_type,next_hear_date,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012900
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trn_rcms_caseid = 16265000009558
pre_hear_date = 19/05/2026
court_code = 10479
case_no = 2024/501
next_hear_date = 22/06/2026
isadjourn = NO
adjourn_type = 0
pre_case_purpose = 12555000000002
adjourn_remark =
new_case_purpose = 12555000000002
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=14502000012900
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=16265000009558
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = c
court_code=10479
Param Type = c
case_no=2024/501
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
new_case_purpose=12555000000002
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,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,adjourn_type,pre_case_purpose,adjourn_remark,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,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,:adjourn_type,:pre_case_purpose,null,: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 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012901
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
pre_hear_date = 19/05/2026
trn_rcms_caseid = 15055000010603
isadjourn = NO
pre_case_purpose = 12555000000002
adjourn_type = 0
court_code = 10479
case_no = 2024/559
adjourn_remark =
next_hear_date = 22/06/2026
new_case_purpose = 12555000000002
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=14502000012901
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = c
trn_rcms_caseid=15055000010603
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
adjourn_type=0
Param Type = c
court_code=10479
Param Type = c
case_no=2024/559
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
new_case_purpose=12555000000002
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,pre_hear_date,trn_rcms_caseid,isadjourn,pre_case_purpose,adjourn_type,court_code,case_no,adjourn_remark,next_hear_date,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:isadjourn,:pre_case_purpose,:adjourn_type,:court_code,:case_no,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012902
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 2
court_code = 10479
adjourn_type = 0
isadjourn = NO
new_case_purpose = 12555000000002
next_hear_date = 22/06/2026
trn_rcms_caseid = 15156000009289
pre_case_purpose = 12555000000002
case_no = 2024/561
pre_hear_date = 19/05/2026
adjourn_remark =
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=14502000012902
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10479
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=12555000000002
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
trn_rcms_caseid=15156000009289
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
case_no=2024/561
Param Type = c
pre_hear_date=19/05/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,court_code,adjourn_type,isadjourn,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_case_purpose,case_no,pre_hear_date,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,:court_code,:adjourn_type,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:pre_case_purpose,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),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 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012903
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 19/05/2026
pre_case_purpose = 1000507
trn_rcms_caseid = 12876000008541
court_code = 10479
case_no = 2024/392
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000507
next_hear_date = 22/06/2026
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=14502000012903
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
pre_case_purpose=1000507
Param Type = c
trn_rcms_caseid=12876000008541
Param Type = c
court_code=10479
Param Type = c
case_no=2024/392
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000507
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_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 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012904
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 22/06/2026
new_case_purpose = 1000507
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/576
court_code = 10479
trn_rcms_caseid = 14434000010538
pre_case_purpose = 1000507
pre_hear_date = 19/05/2026
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=14502000012904
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
new_case_purpose=1000507
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/576
Param Type = c
court_code=10479
Param Type = c
trn_rcms_caseid=14434000010538
Param Type = n
pre_case_purpose=1000507
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012905
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
new_case_purpose = 18678000000000
next_hear_date = 22/06/2026
trn_rcms_caseid = 15709000009323
pre_hear_date = 19/05/2026
pre_case_purpose = 18678000000000
case_no = 2024/474
court_code = 10479
adjourn_remark =
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=14502000012905
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
trn_rcms_caseid=15709000009323
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2024/474
Param Type = c
court_code=10479
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
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,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,court_code,adjourn_remark,isadjourn,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,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,null,:isadjourn,: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 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012906
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 19/05/2026
pre_case_purpose = 1000492
trn_rcms_caseid = 14370000009796
court_code = 10479
case_no = 2025/204
isadjourn = NO
adjourn_type = 0
next_hear_date = 22/06/2026
adjourn_remark =
new_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=14502000012906
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=14370000009796
Param Type = c
court_code=10479
Param Type = c
case_no=2025/204
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
new_case_purpose=1000492
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,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_type,next_hear_date,adjourn_remark,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,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012907
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_case_purpose = 1000492
court_code = 10479
pre_hear_date = 19/05/2026
case_no = 2025/213
trn_rcms_caseid = 17095000010813
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 22/06/2026
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=14502000012907
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=10479
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = c
case_no=2025/213
Param Type = c
trn_rcms_caseid=17095000010813
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=22/06/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,pre_case_purpose,court_code,pre_hear_date,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012908
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark =
new_case_purpose = 18473000000000
adjourn_type = 0
isadjourn = NO
next_hear_date = 22/06/2026
pre_case_purpose = 18473000000000
case_no = 2025/322
court_code = 10479
pre_hear_date = 19/05/2026
trn_rcms_caseid = 15110000010112
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=14502000012908
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18473000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
case_no=2025/322
Param Type = c
court_code=10479
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = c
trn_rcms_caseid=15110000010112
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,adjourn_remark,new_case_purpose,adjourn_type,isadjourn,next_hear_date,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:new_case_purpose,:adjourn_type,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,: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 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012909
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 1
adjourn_remark =
trn_rcms_caseid = 15177000009468
pre_hear_date = 19/05/2026
court_code = 10479
case_no = 2025/324
pre_case_purpose = 18473000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18473000000000
next_hear_date = 22/06/2026
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=14502000012909
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=15177000009468
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = c
court_code=10479
Param Type = c
case_no=2025/324
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=22/06/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,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 = 4
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 = 14502000012910
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 11066000010565
case_no = 2025/327
pre_hear_date = 19/05/2026
next_hear_date = 22/06/2026
new_case_purpose = 18678000000000
isadjourn = NO
court_code = 10479
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=14502000012910
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=11066000010565
Param Type = c
case_no=2025/327
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
court_code=10479
Param Type = n
pre_case_purpose=18678000000000
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,adjourn_remark,adjourn_type,trn_rcms_caseid,case_no,pre_hear_date,next_hear_date,new_case_purpose,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,null,:adjourn_type,:trn_rcms_caseid,:case_no,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,:isadjourn,:court_code,: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 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012911
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 = 15479000009785
pre_hear_date = 19/05/2026
court_code = 10479
case_no = 2025/409
next_hear_date = 22/06/2026
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=14502000012911
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=15479000009785
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = c
court_code=10479
Param Type = c
case_no=2025/409
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=27
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 28 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012912
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_type = 0
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 10781000010248
pre_hear_date = 19/05/2026
pre_case_purpose = 18678000000000
case_no = 2025/442
next_hear_date = 22/06/2026
new_case_purpose = 18678000000000
court_code = 10479
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=14502000012912
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
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=10781000010248
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2025/442
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
court_code=10479
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,next_hear_date,new_case_purpose,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:court_code,: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 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012913
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 15507000010399
case_no = 2025/453
court_code = 10479
pre_hear_date = 19/05/2026
next_hear_date = 22/06/2026
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=14502000012913
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
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=15507000010399
Param Type = c
case_no=2025/453
Param Type = c
court_code=10479
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=29
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 = 4
Adding new record to store data from Frame 2, Row 30 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14502000012914
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 22/06/2026
case_no = 2025/321
court_code = 10479
trn_rcms_caseid = 15063000011071
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
pre_hear_date = 19/05/2026
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=14502000012914
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
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=22/06/2026 00:00:00
Param Type = c
case_no=2025/321
Param Type = c
court_code=10479
Param Type = c
trn_rcms_caseid=15063000011071
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3
Adding new record to store data from Frame 2, Row 31 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012915
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 22/06/2026
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 15160000010282
case_no = 2025/323
court_code = 10479
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
pre_hear_date = 19/05/2026
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=14502000012915
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=15160000010282
Param Type = c
case_no=2025/323
Param Type = c
court_code=10479
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=31
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 4
Adding new record to store data from Frame 2, Row 32 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012916
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 22/06/2026
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18466000000000
case_no = 2025/508
court_code = 10479
trn_rcms_caseid = 17527000010272
pre_case_purpose = 18466000000000
pre_hear_date = 19/05/2026
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=14502000012916
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18466000000000
Param Type = c
case_no=2025/508
Param Type = c
court_code=10479
Param Type = c
trn_rcms_caseid=17527000010272
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=32
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 33 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012917
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 22/06/2026
new_case_purpose = 18466000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2025/509
court_code = 10479
trn_rcms_caseid = 17720000010263
pre_case_purpose = 18466000000000
pre_hear_date = 19/05/2026
TRN_RCMS_HEARINGrow = 33
Posting record
Param Type = n
trn_rcms_hearingid=14502000012917
Param Type = n
trn_rcms_mhearingid=14502000012884
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/06/2026 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2025/509
Param Type = c
court_code=10479
Param Type = c
trn_rcms_caseid=17720000010263
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=19/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=33
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3988437747334
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16291000009014 idvalue 0
Mapped case_no Row = 1 value = 2022/415 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 16291000009014
case_no = 2022/415
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???
prev_case_purpose =
prev_case_purposename=???
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???
Time elapsed = 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 = 14502000012918
MapName trcmf1
SourceId 14502000012885
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 = 18473000000000
hearing_date = 22/06/2026
case_no = 2022/415
trn_rcms_caseregid = 16291000009014
court_code = 10479
case_purpose = 18473000000000
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012918
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012885
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:27
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2022/415
Param Type = c
trn_rcms_caseregid=16291000009014
Param Type = c
court_code=10479
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15540000008071 idvalue 0
Mapped case_no Row = 1 value = 2022/281 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 15540000008071
case_no = 2022/281
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purposename=???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????
Time elapsed = 3
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14502000012919
MapName trcmf1
SourceId 14502000012886
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 = 1000525
hearing_date = 22/06/2026
case_no = 2022/281
trn_rcms_caseregid = 15540000008071
court_code = 10479
case_purpose = 1000525
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012919
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012886
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:29
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2022/281
Param Type = c
trn_rcms_caseregid=15540000008071
Param Type = c
court_code=10479
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19964000008900 idvalue 0
Mapped case_no Row = 1 value = 2022/343 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 19964000008900
case_no = 2022/343
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purposename=???? ?????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????????
Time elapsed = 2
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012920
MapName trcmf1
SourceId 14502000012887
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 22/06/2026
case_no = 2022/343
trn_rcms_caseregid = 19964000008900
court_code = 10479
case_purpose = 1000497
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012920
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012887
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:30
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2022/343
Param Type = c
trn_rcms_caseregid=19964000008900
Param Type = c
court_code=10479
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13793000009329 idvalue 0
Mapped case_no Row = 1 value = 2022/450 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 13793000009329
case_no = 2022/450
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012921
MapName trcmf1
SourceId 14502000012888
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 = 22/06/2026
case_no = 2022/450
trn_rcms_caseregid = 13793000009329
court_code = 10479
case_purpose = 1000497
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012921
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012888
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:31
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2022/450
Param Type = c
trn_rcms_caseregid=13793000009329
Param Type = c
court_code=10479
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18781000011200 idvalue 0
Mapped case_no Row = 1 value = 2023/128 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 18781000011200
case_no = 2023/128
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purposename=???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????
Time elapsed = 3
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012922
MapName trcmf1
SourceId 14502000012889
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 = 1000525
hearing_date = 22/06/2026
case_no = 2023/128
trn_rcms_caseregid = 18781000011200
court_code = 10479
case_purpose = 1000525
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012922
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012889
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:32
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2023/128
Param Type = c
trn_rcms_caseregid=18781000011200
Param Type = c
court_code=10479
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15104000007560 idvalue 0
Mapped case_no Row = 1 value = 2023/227 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 15104000007560
case_no = 2023/227
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purposename=???? ?????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????????
Time elapsed = 2
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012923
MapName trcmf1
SourceId 14502000012890
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 22/06/2026
case_no = 2023/227
trn_rcms_caseregid = 15104000007560
court_code = 10479
case_purpose = 1000497
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012923
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012890
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:33
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2023/227
Param Type = c
trn_rcms_caseregid=15104000007560
Param Type = c
court_code=10479
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15472000007597 idvalue 0
Mapped case_no Row = 1 value = 2023/38 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 15472000007597
case_no = 2023/38
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 14502000012924
MapName trcmf1
SourceId 14502000012891
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 22/06/2026
case_no = 2023/38
trn_rcms_caseregid = 15472000007597
court_code = 10479
case_purpose = 1000497
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012924
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012891
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:33
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2023/38
Param Type = c
trn_rcms_caseregid=15472000007597
Param Type = c
court_code=10479
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13349000008722 idvalue 0
Mapped case_no Row = 1 value = 2023/51 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 13349000008722
case_no = 2023/51
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012925
MapName trcmf1
SourceId 14502000012892
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 22/06/2026
case_no = 2023/51
trn_rcms_caseregid = 13349000008722
court_code = 10479
case_purpose = 1000497
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012925
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012892
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:34
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2023/51
Param Type = c
trn_rcms_caseregid=13349000008722
Param Type = c
court_code=10479
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12839000009337 idvalue 0
Mapped case_no Row = 1 value = 2023/224 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 12839000009337
case_no = 2023/224
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 3
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 14502000012926
MapName trcmf1
SourceId 14502000012893
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 = 22/06/2026
case_no = 2023/224
trn_rcms_caseregid = 12839000009337
court_code = 10479
case_purpose = 18678000000000
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012926
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012893
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:35
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2023/224
Param Type = c
trn_rcms_caseregid=12839000009337
Param Type = c
court_code=10479
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11061000008212 idvalue 0
Mapped case_no Row = 1 value = 2023/225 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 11061000008212
case_no = 2023/225
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012927
MapName trcmf1
SourceId 14502000012894
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 = 22/06/2026
case_no = 2023/225
trn_rcms_caseregid = 11061000008212
court_code = 10479
case_purpose = 18678000000000
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012927
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012894
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:36
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2023/225
Param Type = c
trn_rcms_caseregid=11061000008212
Param Type = c
court_code=10479
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12696000010449 idvalue 0
Mapped case_no Row = 1 value = 2024/389 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 12696000010449
case_no = 2024/389
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purposename=???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????
Time elapsed = 3
prev_case_purpose after validation = 1000525
case_purpose = 1000525
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 = 14502000012928
MapName trcmf1
SourceId 14502000012895
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 = 1000525
hearing_date = 22/06/2026
case_no = 2024/389
trn_rcms_caseregid = 12696000010449
court_code = 10479
case_purpose = 1000525
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012928
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012895
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:37
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:37
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=1000525
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2024/389
Param Type = c
trn_rcms_caseregid=12696000010449
Param Type = c
court_code=10479
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15256000010999 idvalue 0
Mapped case_no Row = 1 value = 2024/316 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 15256000010999
case_no = 2024/316
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purposename=???? ?????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????????
Time elapsed = 4
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012929
MapName trcmf1
SourceId 14502000012896
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 = 22/06/2026
case_no = 2024/316
trn_rcms_caseregid = 15256000010999
court_code = 10479
case_purpose = 1000497
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012929
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012896
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:37
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:37
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=22/06/2026 00:00:00
Param Type = c
case_no=2024/316
Param Type = c
trn_rcms_caseregid=15256000010999
Param Type = c
court_code=10479
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18635000009878 idvalue 0
Mapped case_no Row = 1 value = 2024/364 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 18635000009878
case_no = 2024/364
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012930
MapName trcmf1
SourceId 14502000012897
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 22/06/2026
case_no = 2024/364
trn_rcms_caseregid = 18635000009878
court_code = 10479
case_purpose = 1000497
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012930
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012897
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:38
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2024/364
Param Type = c
trn_rcms_caseregid=18635000009878
Param Type = c
court_code=10479
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16138000008368 idvalue 0
Mapped case_no Row = 1 value = 2024/275 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 16138000008368
case_no = 2024/275
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purposename=???? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????????? ????
Time elapsed = 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 = 3
RecordId = 14502000012931
MapName trcmf1
SourceId 14502000012898
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 = 12555000000002
hearing_date = 22/06/2026
case_no = 2024/275
trn_rcms_caseregid = 16138000008368
court_code = 10479
case_purpose = 12555000000002
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012931
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012898
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:39
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2024/275
Param Type = c
trn_rcms_caseregid=16138000008368
Param Type = c
court_code=10479
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12798000010267 idvalue 0
Mapped case_no Row = 1 value = 2024/446 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 12798000010267
case_no = 2024/446
prev_hearing_date = 19/05/2026
hearing_date = 22/06/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 = 2
RecordId = 14502000012932
MapName trcmf1
SourceId 14502000012899
Select sysdate as sdt from dual
Time elapsed = 3
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 = 22/06/2026
case_no = 2024/446
trn_rcms_caseregid = 12798000010267
court_code = 10479
case_purpose = 12555000000002
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012932
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012899
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:40
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:40
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=22/06/2026 00:00:00
Param Type = c
case_no=2024/446
Param Type = c
trn_rcms_caseregid=12798000010267
Param Type = c
court_code=10479
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16265000009558 idvalue 0
Mapped case_no Row = 1 value = 2024/501 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 16265000009558
case_no = 2024/501
prev_hearing_date = 19/05/2026
hearing_date = 22/06/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 = 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 = 14502000012933
MapName trcmf1
SourceId 14502000012900
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 = 22/06/2026
case_no = 2024/501
trn_rcms_caseregid = 16265000009558
court_code = 10479
case_purpose = 12555000000002
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012933
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012900
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:41
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:41
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=22/06/2026 00:00:00
Param Type = c
case_no=2024/501
Param Type = c
trn_rcms_caseregid=16265000009558
Param Type = c
court_code=10479
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15055000010603 idvalue 0
Mapped case_no Row = 1 value = 2024/559 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 15055000010603
case_no = 2024/559
prev_hearing_date = 19/05/2026
hearing_date = 22/06/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 = 13
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 = 14502000012934
MapName trcmf1
SourceId 14502000012901
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 = 22/06/2026
case_no = 2024/559
trn_rcms_caseregid = 15055000010603
court_code = 10479
case_purpose = 12555000000002
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012934
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012901
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:42
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22: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=12555000000002
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2024/559
Param Type = c
trn_rcms_caseregid=15055000010603
Param Type = c
court_code=10479
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15156000009289 idvalue 0
Mapped case_no Row = 1 value = 2024/561 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 15156000009289
case_no = 2024/561
prev_hearing_date = 19/05/2026
hearing_date = 22/06/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 = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012935
MapName trcmf1
SourceId 14502000012902
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 13
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 22/06/2026
case_no = 2024/561
trn_rcms_caseregid = 15156000009289
court_code = 10479
case_purpose = 12555000000002
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012935
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012902
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:42
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22: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=12555000000002
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2024/561
Param Type = c
trn_rcms_caseregid=15156000009289
Param Type = c
court_code=10479
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12876000008541 idvalue 0
Mapped case_no Row = 1 value = 2024/392 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000507 idvalue 0
Mapped hearing_date Row = 1 value = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 12876000008541
case_no = 2024/392
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???? ?????
prev_case_purpose =
prev_case_purposename=???? ?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????
Time elapsed = 4
prev_case_purpose after validation = 1000507
case_purpose = 1000507
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 = 0
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 = 14502000012936
MapName trcmf1
SourceId 14502000012903
Select sysdate as sdt from dual
Time elapsed = 5
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 = 1000507
hearing_date = 22/06/2026
case_no = 2024/392
trn_rcms_caseregid = 12876000008541
court_code = 10479
case_purpose = 1000507
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012936
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012903
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:43
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22: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=1000507
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2024/392
Param Type = c
trn_rcms_caseregid=12876000008541
Param Type = c
court_code=10479
Param Type = c
case_purpose=1000507
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14434000010538 idvalue 0
Mapped case_no Row = 1 value = 2024/576 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000507 idvalue 0
Mapped hearing_date Row = 1 value = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 14434000010538
case_no = 2024/576
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???? ?????
prev_case_purpose =
prev_case_purpose after validation = 1000507
case_purpose = 1000507
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 = 14502000012937
MapName trcmf1
SourceId 14502000012904
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 = 1000507
hearing_date = 22/06/2026
case_no = 2024/576
trn_rcms_caseregid = 14434000010538
court_code = 10479
case_purpose = 1000507
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012937
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012904
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:44
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22: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=1000507
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2024/576
Param Type = c
trn_rcms_caseregid=14434000010538
Param Type = c
court_code=10479
Param Type = c
case_purpose=1000507
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15709000009323 idvalue 0
Mapped case_no Row = 1 value = 2024/474 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 15709000009323
case_no = 2024/474
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 3
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 14502000012938
MapName trcmf1
SourceId 14502000012905
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/06/2026
case_no = 2024/474
trn_rcms_caseregid = 15709000009323
court_code = 10479
case_purpose = 18678000000000
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012938
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012905
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:45
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2024/474
Param Type = c
trn_rcms_caseregid=15709000009323
Param Type = c
court_code=10479
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14370000009796 idvalue 0
Mapped case_no Row = 1 value = 2025/204 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 14370000009796
case_no = 2025/204
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purposename=?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????
Time elapsed = 3
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012939
MapName trcmf1
SourceId 14502000012906
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 22/06/2026
case_no = 2025/204
trn_rcms_caseregid = 14370000009796
court_code = 10479
case_purpose = 1000492
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012939
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012906
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:46
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2025/204
Param Type = c
trn_rcms_caseregid=14370000009796
Param Type = c
court_code=10479
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17095000010813 idvalue 0
Mapped case_no Row = 1 value = 2025/213 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 17095000010813
case_no = 2025/213
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 14502000012940
MapName trcmf1
SourceId 14502000012907
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 = 1000492
hearing_date = 22/06/2026
case_no = 2025/213
trn_rcms_caseregid = 17095000010813
court_code = 10479
case_purpose = 1000492
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012940
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012907
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:47
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2025/213
Param Type = c
trn_rcms_caseregid=17095000010813
Param Type = c
court_code=10479
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15110000010112 idvalue 0
Mapped case_no Row = 1 value = 2025/322 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 15110000010112
case_no = 2025/322
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???
prev_case_purpose =
prev_case_purposename=???
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???
Time elapsed = 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 = 1
RecordId = 14502000012941
MapName trcmf1
SourceId 14502000012908
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 = 22/06/2026
case_no = 2025/322
trn_rcms_caseregid = 15110000010112
court_code = 10479
case_purpose = 18473000000000
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012941
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012908
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:48
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22: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=18473000000000
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2025/322
Param Type = c
trn_rcms_caseregid=15110000010112
Param Type = c
court_code=10479
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15177000009468 idvalue 0
Mapped case_no Row = 1 value = 2025/324 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 15177000009468
case_no = 2025/324
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012942
MapName trcmf1
SourceId 14502000012909
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 = 18473000000000
hearing_date = 22/06/2026
case_no = 2025/324
trn_rcms_caseregid = 15177000009468
court_code = 10479
case_purpose = 18473000000000
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012942
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012909
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:48
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22: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=18473000000000
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2025/324
Param Type = c
trn_rcms_caseregid=15177000009468
Param Type = c
court_code=10479
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=19/05/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 = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11066000010565 idvalue 0
Mapped case_no Row = 1 value = 2025/327 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 11066000010565
case_no = 2025/327
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 4
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 = 2
RecordId = 14502000012943
MapName trcmf1
SourceId 14502000012910
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 = 22/06/2026
case_no = 2025/327
trn_rcms_caseregid = 11066000010565
court_code = 10479
case_purpose = 18678000000000
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012943
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012910
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:49
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22: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=18678000000000
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2025/327
Param Type = c
trn_rcms_caseregid=11066000010565
Param Type = c
court_code=10479
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/05/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 27
>>Mapping
Mapped court_code Row = 1 value = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15479000009785 idvalue 0
Mapped case_no Row = 1 value = 2025/409 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 15479000009785
case_no = 2025/409
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012944
MapName trcmf1
SourceId 14502000012911
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 = 22/06/2026
case_no = 2025/409
trn_rcms_caseregid = 15479000009785
court_code = 10479
case_purpose = 18678000000000
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012944
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012911
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:50
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22: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=22/06/2026 00:00:00
Param Type = c
case_no=2025/409
Param Type = c
trn_rcms_caseregid=15479000009785
Param Type = c
court_code=10479
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/05/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 28
>>Mapping
Mapped court_code Row = 1 value = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10781000010248 idvalue 0
Mapped case_no Row = 1 value = 2025/442 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 10781000010248
case_no = 2025/442
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012945
MapName trcmf1
SourceId 14502000012912
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 = 22/06/2026
case_no = 2025/442
trn_rcms_caseregid = 10781000010248
court_code = 10479
case_purpose = 18678000000000
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012945
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012912
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:51
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2025/442
Param Type = c
trn_rcms_caseregid=10781000010248
Param Type = c
court_code=10479
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/05/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 29
>>Mapping
Mapped court_code Row = 1 value = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15507000010399 idvalue 0
Mapped case_no Row = 1 value = 2025/453 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 15507000010399
case_no = 2025/453
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14502000012946
MapName trcmf1
SourceId 14502000012913
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 = 22/06/2026
case_no = 2025/453
trn_rcms_caseregid = 15507000010399
court_code = 10479
case_purpose = 18678000000000
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012946
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012913
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:52
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2025/453
Param Type = c
trn_rcms_caseregid=15507000010399
Param Type = c
court_code=10479
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/05/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 30
>>Mapping
Mapped court_code Row = 1 value = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15063000011071 idvalue 0
Mapped case_no Row = 1 value = 2025/321 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 15063000011071
case_no = 2025/321
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purposename=??????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ????
Time elapsed = 5
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 = 14502000012947
MapName trcmf1
SourceId 14502000012914
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 = 18466000000000
hearing_date = 22/06/2026
case_no = 2025/321
trn_rcms_caseregid = 15063000011071
court_code = 10479
case_purpose = 18466000000000
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012947
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012914
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:53
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22: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=18466000000000
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2025/321
Param Type = c
trn_rcms_caseregid=15063000011071
Param Type = c
court_code=10479
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=19/05/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 31
>>Mapping
Mapped court_code Row = 1 value = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15160000010282 idvalue 0
Mapped case_no Row = 1 value = 2025/323 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 15160000010282
case_no = 2025/323
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
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 = 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 = 14502000012948
MapName trcmf1
SourceId 14502000012915
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 22/06/2026
case_no = 2025/323
trn_rcms_caseregid = 15160000010282
court_code = 10479
case_purpose = 18466000000000
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012948
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012915
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:54
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22: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=18466000000000
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2025/323
Param Type = c
trn_rcms_caseregid=15160000010282
Param Type = c
court_code=10479
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=19/05/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 32
>>Mapping
Mapped court_code Row = 1 value = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17527000010272 idvalue 0
Mapped case_no Row = 1 value = 2025/508 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 17527000010272
case_no = 2025/508
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
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 = 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 = 14502000012949
MapName trcmf1
SourceId 14502000012916
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 = 18466000000000
hearing_date = 22/06/2026
case_no = 2025/508
trn_rcms_caseregid = 17527000010272
court_code = 10479
case_purpose = 18466000000000
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012949
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012916
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:54
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22: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=18466000000000
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2025/508
Param Type = c
trn_rcms_caseregid=17527000010272
Param Type = c
court_code=10479
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=19/05/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 33
>>Mapping
Mapped court_code Row = 1 value = 10479 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17720000010263 idvalue 0
Mapped case_no Row = 1 value = 2025/509 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/05/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 = 22/06/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10479
trn_rcms_caseregid = 17720000010263
case_no = 2025/509
prev_hearing_date = 19/05/2026
hearing_date = 22/06/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
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 = 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 = 14502000012950
MapName trcmf1
SourceId 14502000012917
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 22/06/2026
case_no = 2025/509
trn_rcms_caseregid = 17720000010263
court_code = 10479
case_purpose = 18466000000000
prev_hearing_date = 19/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=14502000012950
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14502000012917
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Baap
Param Type = c
createdon=20/05/2026 11:22:55
Param Type = c
username=SDO_Baap
Param Type = c
modifiedon=20/05/2026 11:22: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=18466000000000
Param Type = c
hearing_date=22/06/2026 00:00:00
Param Type = c
case_no=2025/509
Param Type = c
trn_rcms_caseregid=17720000010263
Param Type = c
court_code=10479
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=19/05/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 = 3988437776134
Time elapsed for MD Map = 3988437776135
Time elapsed for Save History = 3988437776135
Time elapsed for Save Attachment = 3988437776135
Time elapsed for After Save WF Exec = 3988437776138
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"14502000012884"}]}
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_Baap
Param Type = c
calledon=20/05/2026 11:22:26
Param Type = c
callfinished=20/05/2026 11:22:56
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=30045
Param Type = n
dbtimetaken=29063
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