ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
gcmsDM_Jalor_R827ccb0eea8a706c4c34a16891f84e7b![]()
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=DM_jalor_r
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=DM_jalor_r
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=DM_jalor_r
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=DM_jalor_r
Time elapsed = 2
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = DM
Result = DM
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=DM_jalor_r
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=DM_jalor_r
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 12836000000139
Result = 12836000000139
Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=DM_jalor_r
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 3607
Result = 3607
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=DM_jalor_r
Time elapsed = 2
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = DM_jalor_r
Result = DM_jalor_r
Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=DM_jalor_r
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10386
Result = 10386
Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 2
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=DM_jalor_r
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=DM_jalor_r
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Jalore
Result = Jalore
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=DM_jalor_r
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=DM_jalor_r
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m8},{COURT_CATEGOTY})
Calling function sqlget
Result of sqlget = 10593000000007
Result = 10593000000007
Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
Calling function firesql
login_userid=3607
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=3607
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=DM_jalor_r
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10206000000014
Result = 10206000000014
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=DM_jalor_r
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=DM_jalor_r
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_reader
Result = court_reader
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=DM_jalor_r
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=DM_jalor_r
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 13
Result = 13
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 1
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 3
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_reader,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 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 = 10386
hearing_date = 20/01/2026
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 2
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 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 = 16488000012326
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
hearing_date = 20/01/2026
courtcode = 10386
Posting record
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:55
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=20/01/2026 00:00:00
Param Type = c
courtcode=10386
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 = 16488000012327
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
pre_case_purpose = 1000497
trn_rcms_caseid = 10848000009345
court_code = 10386
pre_hear_date = 20/01/2026
new_case_purpose = 1000497
next_hear_date = 17/02/2026
case_no = 2023/136
isadjourn = NO
adjourn_remark =
adjourn_type = 0
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=16488000012327
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:55
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=10848000009345
Param Type = c
court_code=10386
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = c
case_no=2023/136
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,trn_rcms_caseid,court_code,pre_hear_date,new_case_purpose,next_hear_date,case_no,isadjourn,adjourn_remark,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:trn_rcms_caseid,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:isadjourn,null,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 16488000012328
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 20/01/2026
pre_case_purpose = 1000497
trn_rcms_caseid = 11012000006896
court_code = 10386
case_no = 2023/137
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 17/02/2026
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=16488000012328
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:55
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=11012000006896
Param Type = c
court_code=10386
Param Type = c
case_no=2023/137
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 16488000012329
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 17/02/2026
new_case_purpose = 18473000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2025/131
court_code = 10386
trn_rcms_caseid = 16060000009229
pre_case_purpose = 18473000000000
pre_hear_date = 20/01/2026
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=16488000012329
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:55
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2025/131
Param Type = c
court_code=10386
Param Type = c
trn_rcms_caseid=16060000009229
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 16488000012330
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
isadjourn = NO
adjourn_type = 0
next_hear_date = 17/02/2026
pre_case_purpose = 18473000000000
new_case_purpose = 18473000000000
case_no = 2025/141
court_code = 10386
trn_rcms_caseid = 16969000008851
adjourn_remark =
pre_hear_date = 20/01/2026
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=16488000012330
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:55
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
new_case_purpose=18473000000000
Param Type = c
case_no=2025/141
Param Type = c
court_code=10386
Param Type = c
trn_rcms_caseid=16969000008851
Param Type = c
pre_hear_date=20/01/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,isadjourn,adjourn_type,next_hear_date,pre_case_purpose,new_case_purpose,case_no,court_code,trn_rcms_caseid,adjourn_remark,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 16488000012331
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 17/02/2026
new_case_purpose = 18473000000000
adjourn_type = 0
isadjourn = NO
pre_case_purpose = 18473000000000
case_no = 2025/66
court_code = 10386
pre_hear_date = 20/01/2026
trn_rcms_caseid = 13221000009876
adjourn_remark =
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=16488000012331
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:55
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
case_no=2025/66
Param Type = c
court_code=10386
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = c
trn_rcms_caseid=13221000009876
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_type,isadjourn,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:isadjourn,:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 16488000012332
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
new_case_purpose = 18473000000000
next_hear_date = 17/02/2026
trn_rcms_caseid = 13725000011266
pre_hear_date = 20/01/2026
pre_case_purpose = 18473000000000
adjourn_type = 0
adjourn_remark =
isadjourn = NO
court_code = 10386
case_no = 2025/72
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=16488000012332
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:55
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = c
trn_rcms_caseid=13725000011266
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
court_code=10386
Param Type = c
case_no=2025/72
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_hear_date,pre_case_purpose,adjourn_type,adjourn_remark,isadjourn,court_code,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:adjourn_type,null,:isadjourn,:court_code,:case_no,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 16488000012333
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 20/01/2026
pre_case_purpose = 18473000000000
trn_rcms_caseid = 13882000010060
court_code = 10386
case_no = 2025/74
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 17/02/2026
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=16488000012333
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:55
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=13882000010060
Param Type = c
court_code=10386
Param Type = c
case_no=2025/74
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 2
RecordId = 16488000012334
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 20/01/2026
pre_case_purpose = 18473000000000
trn_rcms_caseid = 14023000009522
court_code = 10386
case_no = 2025/76
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 17/02/2026
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=16488000012334
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:55
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=14023000009522
Param Type = c
court_code=10386
Param Type = c
case_no=2025/76
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 16488000012335
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark =
new_case_purpose = 1000497
pre_case_purpose = 1000497
isadjourn = NO
next_hear_date = 17/02/2026
case_no = 2025/145
court_code = 10386
pre_hear_date = 20/01/2026
trn_rcms_caseid = 17187000010960
adjourn_type = 0
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=16488000012335
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:55
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000497
Param Type = n
pre_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = c
case_no=2025/145
Param Type = c
court_code=10386
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = c
trn_rcms_caseid=17187000010960
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,new_case_purpose,pre_case_purpose,isadjourn,next_hear_date,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:new_case_purpose,:pre_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 16488000012336
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trn_rcms_caseid = 17805000010539
case_no = 2025/48
pre_case_purpose = 18678000000000
pre_hear_date = 20/01/2026
next_hear_date = 17/02/2026
adjourn_type = 0
isadjourn = NO
adjourn_remark =
court_code = 10386
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=16488000012336
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:55
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=17805000010539
Param Type = c
case_no=2025/48
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
court_code=10386
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,case_no,pre_case_purpose,pre_hear_date,next_hear_date,adjourn_type,isadjourn,adjourn_remark,court_code,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,:case_no,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:court_code,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 16488000012337
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 13099000009590
pre_hear_date = 20/01/2026
court_code = 10386
case_no = 2025/65
next_hear_date = 17/02/2026
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=16488000012337
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:56
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13099000009590
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = c
court_code=10386
Param Type = c
case_no=2025/65
Param Type = c
next_hear_date=17/02/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=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 16488000012338
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_type = 0
adjourn_remark =
pre_hear_date = 20/01/2026
trn_rcms_caseid = 13594000009272
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
next_hear_date = 17/02/2026
isadjourn = NO
case_no = 2025/71
court_code = 10386
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=16488000012338
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:56
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = c
trn_rcms_caseid=13594000009272
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2025/71
Param Type = c
court_code=10386
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,pre_hear_date,trn_rcms_caseid,new_case_purpose,pre_case_purpose,next_hear_date,isadjourn,case_no,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 16488000012339
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_type = 0
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 13801000009623
case_no = 2025/73
court_code = 10386
pre_hear_date = 20/01/2026
next_hear_date = 17/02/2026
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=16488000012339
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:56
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:56
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=13801000009623
Param Type = c
case_no=2025/73
Param Type = c
court_code=10386
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 16488000012340
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 =
case_no = 2025/75
court_code = 10386
pre_hear_date = 20/01/2026
trn_rcms_caseid = 13975000009741
next_hear_date = 17/02/2026
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=16488000012340
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:56
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2025/75
Param Type = c
court_code=10386
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = c
trn_rcms_caseid=13975000009741
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=14
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,case_no,court_code,pre_hear_date,trn_rcms_caseid,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 16488000012341
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 17/02/2026
trn_rcms_caseid = 17043000010850
case_no = 2025/142
court_code = 10386
new_case_purpose = 18619000000000
pre_case_purpose = 18619000000000
pre_hear_date = 20/01/2026
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=16488000012341
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:56
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = c
trn_rcms_caseid=17043000010850
Param Type = c
case_no=2025/142
Param Type = c
court_code=10386
Param Type = c
new_case_purpose=18619000000000
Param Type = n
pre_case_purpose=18619000000000
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 16488000012342
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 17/02/2026
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 17043000010850
court_code = 10386
case_no = 2025/142
new_case_purpose = 18619000000000
pre_case_purpose = 18619000000000
pre_hear_date = 20/01/2026
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=16488000012342
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:56
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=17043000010850
Param Type = c
court_code=10386
Param Type = c
case_no=2025/142
Param Type = c
new_case_purpose=18619000000000
Param Type = n
pre_case_purpose=18619000000000
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,court_code,case_no,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:court_code,:case_no,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 16488000012343
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 17/02/2026
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 11417000000000
case_no = 2025/147
court_code = 10386
trn_rcms_caseid = 17336000010164
pre_case_purpose = 11417000000000
pre_hear_date = 20/01/2026
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=16488000012343
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:56
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=11417000000000
Param Type = c
case_no=2025/147
Param Type = c
court_code=10386
Param Type = c
trn_rcms_caseid=17336000010164
Param Type = n
pre_case_purpose=11417000000000
Param Type = c
pre_hear_date=20/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 16488000012344
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 17/02/2026
new_case_purpose = 11417000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2025/147
court_code = 10386
trn_rcms_caseid = 17336000010164
pre_case_purpose = 11417000000000
pre_hear_date = 20/01/2026
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=16488000012344
Param Type = n
trn_rcms_mhearingid=16488000012326
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:56
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=17/02/2026 00:00:00
Param Type = c
new_case_purpose=11417000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2025/147
Param Type = c
court_code=10386
Param Type = c
trn_rcms_caseid=17336000010164
Param Type = n
pre_case_purpose=11417000000000
Param Type = c
pre_hear_date=20/01/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,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 = 3980428088915
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10848000009345 idvalue 0
Mapped case_no Row = 1 value = 2023/136 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/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 = 17/02/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 = 10386
trn_rcms_caseregid = 10848000009345
case_no = 2023/136
prev_hearing_date = 20/01/2026
hearing_date = 17/02/2026
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purposename=???? ?????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????????
Time elapsed = 3
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16488000012345
MapName trcmf1
SourceId 16488000012327
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 = 17/02/2026
case_no = 2023/136
trn_rcms_caseregid = 10848000009345
court_code = 10386
case_purpose = 1000497
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012345
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012327
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:56
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=17/02/2026 00:00:00
Param Type = c
case_no=2023/136
Param Type = c
trn_rcms_caseregid=10848000009345
Param Type = c
court_code=10386
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11012000006896 idvalue 0
Mapped case_no Row = 1 value = 2023/137 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/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 = 17/02/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 = 10386
trn_rcms_caseregid = 11012000006896
case_no = 2023/137
prev_hearing_date = 20/01/2026
hearing_date = 17/02/2026
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 16488000012346
MapName trcmf1
SourceId 16488000012328
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 17/02/2026
case_no = 2023/137
trn_rcms_caseregid = 11012000006896
court_code = 10386
case_purpose = 1000497
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012346
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012328
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:57
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=17/02/2026 00:00:00
Param Type = c
case_no=2023/137
Param Type = c
trn_rcms_caseregid=11012000006896
Param Type = c
court_code=10386
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16060000009229 idvalue 0
Mapped case_no Row = 1 value = 2025/131 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/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 = 17/02/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 = 10386
trn_rcms_caseregid = 16060000009229
case_no = 2025/131
prev_hearing_date = 20/01/2026
hearing_date = 17/02/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 = 16488000012347
MapName trcmf1
SourceId 16488000012329
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 = 17/02/2026
case_no = 2025/131
trn_rcms_caseregid = 16060000009229
court_code = 10386
case_purpose = 18473000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012347
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012329
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:58
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=17/02/2026 00:00:00
Param Type = c
case_no=2025/131
Param Type = c
trn_rcms_caseregid=16060000009229
Param Type = c
court_code=10386
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16969000008851 idvalue 0
Mapped case_no Row = 1 value = 2025/141 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/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 = 17/02/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 = 10386
trn_rcms_caseregid = 16969000008851
case_no = 2025/141
prev_hearing_date = 20/01/2026
hearing_date = 17/02/2026
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 16488000012348
MapName trcmf1
SourceId 16488000012330
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 = 17/02/2026
case_no = 2025/141
trn_rcms_caseregid = 16969000008851
court_code = 10386
case_purpose = 18473000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012348
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012330
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:58
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=17/02/2026 00:00:00
Param Type = c
case_no=2025/141
Param Type = c
trn_rcms_caseregid=16969000008851
Param Type = c
court_code=10386
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13221000009876 idvalue 0
Mapped case_no Row = 1 value = 2025/66 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/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 = 17/02/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 = 10386
trn_rcms_caseregid = 13221000009876
case_no = 2025/66
prev_hearing_date = 20/01/2026
hearing_date = 17/02/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 = 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 = 16488000012349
MapName trcmf1
SourceId 16488000012331
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 = 18473000000000
hearing_date = 17/02/2026
case_no = 2025/66
trn_rcms_caseregid = 13221000009876
court_code = 10386
case_purpose = 18473000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012349
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012331
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:59
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:59
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=17/02/2026 00:00:00
Param Type = c
case_no=2025/66
Param Type = c
trn_rcms_caseregid=13221000009876
Param Type = c
court_code=10386
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13725000011266 idvalue 0
Mapped case_no Row = 1 value = 2025/72 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/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 = 17/02/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 = 10386
trn_rcms_caseregid = 13725000011266
case_no = 2025/72
prev_hearing_date = 20/01/2026
hearing_date = 17/02/2026
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 16488000012350
MapName trcmf1
SourceId 16488000012332
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 = 17/02/2026
case_no = 2025/72
trn_rcms_caseregid = 13725000011266
court_code = 10386
case_purpose = 18473000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012350
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012332
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:58:59
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:58:59
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=17/02/2026 00:00:00
Param Type = c
case_no=2025/72
Param Type = c
trn_rcms_caseregid=13725000011266
Param Type = c
court_code=10386
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13882000010060 idvalue 0
Mapped case_no Row = 1 value = 2025/74 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/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 = 17/02/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 = 10386
trn_rcms_caseregid = 13882000010060
case_no = 2025/74
prev_hearing_date = 20/01/2026
hearing_date = 17/02/2026
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 16488000012351
MapName trcmf1
SourceId 16488000012333
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 17/02/2026
case_no = 2025/74
trn_rcms_caseregid = 13882000010060
court_code = 10386
case_purpose = 18473000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012351
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012333
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:59:00
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:59:00
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=17/02/2026 00:00:00
Param Type = c
case_no=2025/74
Param Type = c
trn_rcms_caseregid=13882000010060
Param Type = c
court_code=10386
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14023000009522 idvalue 0
Mapped case_no Row = 1 value = 2025/76 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/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 = 17/02/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 = 10386
trn_rcms_caseregid = 14023000009522
case_no = 2025/76
prev_hearing_date = 20/01/2026
hearing_date = 17/02/2026
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16488000012352
MapName trcmf1
SourceId 16488000012334
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 = 17/02/2026
case_no = 2025/76
trn_rcms_caseregid = 14023000009522
court_code = 10386
case_purpose = 18473000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012352
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012334
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:59:00
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:59:00
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=17/02/2026 00:00:00
Param Type = c
case_no=2025/76
Param Type = c
trn_rcms_caseregid=14023000009522
Param Type = c
court_code=10386
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17187000010960 idvalue 0
Mapped case_no Row = 1 value = 2025/145 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/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 = 17/02/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 = 10386
trn_rcms_caseregid = 17187000010960
case_no = 2025/145
prev_hearing_date = 20/01/2026
hearing_date = 17/02/2026
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purposename=???? ?????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????????
Time elapsed = 3
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 16488000012353
MapName trcmf1
SourceId 16488000012335
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 17/02/2026
case_no = 2025/145
trn_rcms_caseregid = 17187000010960
court_code = 10386
case_purpose = 1000497
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012353
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012335
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:59:01
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:59:01
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=17/02/2026 00:00:00
Param Type = c
case_no=2025/145
Param Type = c
trn_rcms_caseregid=17187000010960
Param Type = c
court_code=10386
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17805000010539 idvalue 0
Mapped case_no Row = 1 value = 2025/48 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/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 = 17/02/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 = 10386
trn_rcms_caseregid = 17805000010539
case_no = 2025/48
prev_hearing_date = 20/01/2026
hearing_date = 17/02/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 = 16488000012354
MapName trcmf1
SourceId 16488000012336
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 = 17/02/2026
case_no = 2025/48
trn_rcms_caseregid = 17805000010539
court_code = 10386
case_purpose = 18678000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012354
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012336
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:59:02
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:59:02
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=17/02/2026 00:00:00
Param Type = c
case_no=2025/48
Param Type = c
trn_rcms_caseregid=17805000010539
Param Type = c
court_code=10386
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13099000009590 idvalue 0
Mapped case_no Row = 1 value = 2025/65 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/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 = 17/02/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 = 10386
trn_rcms_caseregid = 13099000009590
case_no = 2025/65
prev_hearing_date = 20/01/2026
hearing_date = 17/02/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 16488000012355
MapName trcmf1
SourceId 16488000012337
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 = 17/02/2026
case_no = 2025/65
trn_rcms_caseregid = 13099000009590
court_code = 10386
case_purpose = 18678000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012355
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012337
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:59:02
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:59:02
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=17/02/2026 00:00:00
Param Type = c
case_no=2025/65
Param Type = c
trn_rcms_caseregid=13099000009590
Param Type = c
court_code=10386
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13594000009272 idvalue 0
Mapped case_no Row = 1 value = 2025/71 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/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 = 17/02/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 = 10386
trn_rcms_caseregid = 13594000009272
case_no = 2025/71
prev_hearing_date = 20/01/2026
hearing_date = 17/02/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 = 16488000012356
MapName trcmf1
SourceId 16488000012338
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 = 17/02/2026
case_no = 2025/71
trn_rcms_caseregid = 13594000009272
court_code = 10386
case_purpose = 18678000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012356
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012338
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:59:03
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:59:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=17/02/2026 00:00:00
Param Type = c
case_no=2025/71
Param Type = c
trn_rcms_caseregid=13594000009272
Param Type = c
court_code=10386
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13801000009623 idvalue 0
Mapped case_no Row = 1 value = 2025/73 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/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 = 17/02/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 = 10386
trn_rcms_caseregid = 13801000009623
case_no = 2025/73
prev_hearing_date = 20/01/2026
hearing_date = 17/02/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 = 16488000012357
MapName trcmf1
SourceId 16488000012339
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 = 17/02/2026
case_no = 2025/73
trn_rcms_caseregid = 13801000009623
court_code = 10386
case_purpose = 18678000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012357
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012339
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:59:03
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:59:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=17/02/2026 00:00:00
Param Type = c
case_no=2025/73
Param Type = c
trn_rcms_caseregid=13801000009623
Param Type = c
court_code=10386
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13975000009741 idvalue 0
Mapped case_no Row = 1 value = 2025/75 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/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 = 17/02/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 = 10386
trn_rcms_caseregid = 13975000009741
case_no = 2025/75
prev_hearing_date = 20/01/2026
hearing_date = 17/02/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 16488000012358
MapName trcmf1
SourceId 16488000012340
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 = 17/02/2026
case_no = 2025/75
trn_rcms_caseregid = 13975000009741
court_code = 10386
case_purpose = 18678000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012358
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012340
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:59:04
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:59:04
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=17/02/2026 00:00:00
Param Type = c
case_no=2025/75
Param Type = c
trn_rcms_caseregid=13975000009741
Param Type = c
court_code=10386
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17043000010850 idvalue 0
Mapped case_no Row = 1 value = 2025/142 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????? idvalue 0
Mapped case_purpose Row = 1 value = 18619000000000 idvalue 0
Mapped hearing_date Row = 1 value = 17/02/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 = 10386
trn_rcms_caseregid = 17043000010850
case_no = 2025/142
prev_hearing_date = 20/01/2026
hearing_date = 17/02/2026
prev_case_purposename = ??????? ?????
prev_case_purpose =
prev_case_purposename=??????? ?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ?????
Time elapsed = 3
prev_case_purpose after validation = 18619000000000
case_purpose = 18619000000000
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 = 16488000012359
MapName trcmf1
SourceId 16488000012341
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 = 18619000000000
hearing_date = 17/02/2026
case_no = 2025/142
trn_rcms_caseregid = 17043000010850
court_code = 10386
case_purpose = 18619000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012359
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012341
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:59:05
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:59:05
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18619000000000
Param Type = c
hearing_date=17/02/2026 00:00:00
Param Type = c
case_no=2025/142
Param Type = c
trn_rcms_caseregid=17043000010850
Param Type = c
court_code=10386
Param Type = c
case_purpose=18619000000000
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17043000010850 idvalue 0
Mapped case_no Row = 1 value = 2025/142 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????? idvalue 0
Mapped case_purpose Row = 1 value = 18619000000000 idvalue 0
Mapped hearing_date Row = 1 value = 17/02/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 = 10386
trn_rcms_caseregid = 17043000010850
case_no = 2025/142
prev_hearing_date = 20/01/2026
hearing_date = 17/02/2026
prev_case_purposename = ??????? ?????
prev_case_purpose =
prev_case_purpose after validation = 18619000000000
case_purpose = 18619000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 16488000012360
MapName trcmf1
SourceId 16488000012342
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 = 18619000000000
hearing_date = 17/02/2026
case_no = 2025/142
trn_rcms_caseregid = 17043000010850
court_code = 10386
case_purpose = 18619000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012360
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012342
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:59:05
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:59:05
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18619000000000
Param Type = c
hearing_date=17/02/2026 00:00:00
Param Type = c
case_no=2025/142
Param Type = c
trn_rcms_caseregid=17043000010850
Param Type = c
court_code=10386
Param Type = c
case_purpose=18619000000000
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17336000010164 idvalue 0
Mapped case_no Row = 1 value = 2025/147 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 11417000000000 idvalue 0
Mapped hearing_date Row = 1 value = 17/02/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 = 10386
trn_rcms_caseregid = 17336000010164
case_no = 2025/147
prev_hearing_date = 20/01/2026
hearing_date = 17/02/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 = 11417000000000
case_purpose = 11417000000000
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 = 16488000012361
MapName trcmf1
SourceId 16488000012343
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 = 11417000000000
hearing_date = 17/02/2026
case_no = 2025/147
trn_rcms_caseregid = 17336000010164
court_code = 10386
case_purpose = 11417000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012361
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012343
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:59:06
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:59:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=11417000000000
Param Type = c
hearing_date=17/02/2026 00:00:00
Param Type = c
case_no=2025/147
Param Type = c
trn_rcms_caseregid=17336000010164
Param Type = c
court_code=10386
Param Type = c
case_purpose=11417000000000
Param Type = c
prev_hearing_date=20/01/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 = 10386 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17336000010164 idvalue 0
Mapped case_no Row = 1 value = 2025/147 idvalue 0
Mapped prev_hearing_date Row = 1 value = 20/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 11417000000000 idvalue 0
Mapped hearing_date Row = 1 value = 17/02/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 = 10386
trn_rcms_caseregid = 17336000010164
case_no = 2025/147
prev_hearing_date = 20/01/2026
hearing_date = 17/02/2026
prev_case_purposename = ??????? ???????
prev_case_purpose =
prev_case_purpose after validation = 11417000000000
case_purpose = 11417000000000
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 = 16488000012362
MapName trcmf1
SourceId 16488000012344
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 = 11417000000000
hearing_date = 17/02/2026
case_no = 2025/147
trn_rcms_caseregid = 17336000010164
court_code = 10386
case_purpose = 11417000000000
prev_hearing_date = 20/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=16488000012362
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16488000012344
Param Type = c
cancel=F
Param Type = c
createdby=DM_jalor_r
Param Type = c
createdon=16/02/2026 18:59:06
Param Type = c
username=DM_jalor_r
Param Type = c
modifiedon=16/02/2026 18:59:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=11417000000000
Param Type = c
hearing_date=17/02/2026 00:00:00
Param Type = c
case_no=2025/147
Param Type = c
trn_rcms_caseregid=17336000010164
Param Type = c
court_code=10386
Param Type = c
case_purpose=11417000000000
Param Type = c
prev_hearing_date=20/01/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 = 3980428100033
Time elapsed for MD Map = 3980428100033
Time elapsed for Save History = 3980428100034
Time elapsed for Save Attachment = 3980428100034
Time elapsed for After Save WF Exec = 3980428100037
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"16488000012326"}]}
Savedata webservice completed
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=DM_jalor_r
Param Type = c
calledon=16/02/2026 18:28:08
Param Type = c
callfinished=16/02/2026 18:28:20
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=11984
Param Type = n
dbtimetaken=11347
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