ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
gcmsSDO_Taleda_PRO827ccb0eea8a706c4c34a16891f84e7b![]()
INRF500250000Ffiresql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtname := sqlget({m2},{court_name})firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})m_courttype := sqlget({m3},{court_type})firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})m_courtid := sqlget({m4},{court_name_mastid})firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})login_userid := sqlget({m4},{axusersid})firesql({m4},{select :username as uname from dual})u_name := sqlget({m4},{uname})firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtcode := sqlget({m4},{COURT_CODE})firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})m_statename := sqlget({m2},{STATE_NAME})firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_distName := sqlget({m7},{DISTNAMEENG})firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_courtcatid := sqlget({m8},{COURT_CATEGOTY})firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})m_deptid := sqlget({m4},{department_mastid})firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})m_courttypeid := sqlget({m3},{court_type_mastid})firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })urole := sqlget({m4},{groupname})firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})m_cutoffdt := sqlget({a1},{dd})firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})m_offcount := sqlget({P1},{ct})00000F
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
username=SDO_Taleda_PRO
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Taleda_PRO
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ????? ???????, ???????,???? -?????
Result = ????? ???????, ???????,???? -?????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=SDO_Taleda_PRO
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Taleda_PRO
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = SDO
Result = SDO
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=SDO_Taleda_PRO
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Taleda_PRO
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 12122000000062
Result = 12122000000062
Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=SDO_Taleda_PRO
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1088990009009
Result = 1088990009009
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_Taleda_PRO
Time elapsed = 12
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_Taleda_PRO
Result = SDO_Taleda_PRO
Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Taleda_PRO
Time elapsed = 18
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10185
Result = 10185
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 = 16
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Taleda_PRO
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Taleda_PRO
Time elapsed = 16
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Bundi
Result = Bundi
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Taleda_PRO
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Taleda_PRO
Time elapsed = 18
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=1088990009009
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1088990009009
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=SDO_Taleda_PRO
Time elapsed = 31
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10823000000000
Result = 10823000000000
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=SDO_Taleda_PRO
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=SDO_Taleda_PRO
Time elapsed = 17
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_admin
Result = court_admin
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 16
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=SDO_Taleda_PRO
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=SDO_Taleda_PRO
Time elapsed = 20
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 15
Result = 15
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_admin') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 6
select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 13
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_admin,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 6
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 = 9
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 = 10185
hearing_date = 24/06/2025
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 3
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 14850000010093
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 8
hearing_date = 24/06/2025
courtcode = 10185
Posting record
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:39:20
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:39:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=24/06/2025 00:00:00
Param Type = c
courtcode=10185
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 = 12
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 = 4
RecordId = 14850000010094
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 7
pre_case_purpose = 18678000000000
case_no = 2024/207
court_code = 10185
pre_hear_date = 24/06/2025
trn_rcms_caseid = 18116000010020
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 30/07/2025
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=14850000010094
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:39:20
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:39:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2024/207
Param Type = c
court_code=10185
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
trn_rcms_caseid=18116000010020
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=30/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
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 = 6
RecordId = 14850000010095
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 10/07/2025
case_no = 2024/221
court_code = 10185
trn_rcms_caseid = 17377000009948
pre_case_purpose = 18678000000000
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=14850000010095
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:12
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=10/07/2025 00:00:00
Param Type = c
case_no=2024/221
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=17377000009948
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/06/2025 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,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 16
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 = 4
RecordId = 14850000010096
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 9
pre_hear_date = 24/06/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16204000009207
court_code = 10185
case_no = 2024/235
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 01/07/2025
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=14850000010096
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:12
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16204000009207
Param Type = c
court_code=10185
Param Type = c
case_no=2024/235
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=01/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 9
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 = 10
RecordId = 14850000010097
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 10
next_hear_date = 01/07/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/238
court_code = 10185
trn_rcms_caseid = 19684000008922
pre_case_purpose = 18678000000000
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=14850000010097
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:12
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=01/07/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/238
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=19684000008922
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 13
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010098
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 8
next_hear_date = 10/07/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/250
court_code = 10185
trn_rcms_caseid = 12974000009039
pre_case_purpose = 18678000000000
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=14850000010098
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:12
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=10/07/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/250
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=12974000009039
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 8
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 = 5
RecordId = 14850000010099
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 01/07/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/253
court_code = 10185
trn_rcms_caseid = 13770000010081
pre_case_purpose = 18678000000000
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=14850000010099
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:12
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=01/07/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/253
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=13770000010081
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 5
RecordId = 14850000010100
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 01/07/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/259
court_code = 10185
trn_rcms_caseid = 13678000008905
pre_case_purpose = 18678000000000
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=14850000010100
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:12
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=01/07/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/259
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=13678000008905
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 8
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 = 6
RecordId = 14850000010101
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 01/07/2025
new_case_purpose = 18678000000000
adjourn_type = 0
isadjourn = NO
adjourn_remark =
case_no = 2024/260
court_code = 10185
trn_rcms_caseid = 13749000008906
pre_case_purpose = 18678000000000
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=14850000010101
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:12
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=01/07/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/260
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=13749000008906
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/06/2025 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,next_hear_date,new_case_purpose,adjourn_type,isadjourn,adjourn_remark,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,:adjourn_type,:isadjourn,null,: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 = 17
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 = 8
RecordId = 14850000010102
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 24/06/2025
trn_rcms_caseid = 14545000009056
court_code = 10185
case_no = 2024/55
isadjourn = NO
adjourn_type = 0
adjourn_remark =
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
next_hear_date = 29/07/2025
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=14850000010102
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
trn_rcms_caseid=14545000009056
Param Type = c
court_code=10185
Param Type = c
case_no=2024/55
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=29/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_type,adjourn_remark,pre_case_purpose,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:court_code,:case_no,:isadjourn,:adjourn_type,null,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 4
RecordId = 14850000010103
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 22/07/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/56
court_code = 10185
trn_rcms_caseid = 14653000006828
pre_case_purpose = 18678000000000
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=14850000010103
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/56
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=14653000006828
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 8
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 = 5
RecordId = 14850000010104
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 6
new_case_purpose = 18678000000000
adjourn_remark =
next_hear_date = 10/07/2025
adjourn_type = 0
isadjourn = NO
pre_case_purpose = 18678000000000
case_no = 2024/63
court_code = 10185
trn_rcms_caseid = 16102000008691
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=14850000010104
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=10/07/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2024/63
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=16102000008691
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,adjourn_remark,next_hear_date,adjourn_type,isadjourn,pre_case_purpose,case_no,court_code,trn_rcms_caseid,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,:pre_case_purpose,:case_no,:court_code,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 12
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 = 5
RecordId = 14850000010105
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 30/07/2025
isadjourn = NO
new_case_purpose = 18678000000000
case_no = 2024/68
pre_case_purpose = 18678000000000
adjourn_remark =
pre_hear_date = 24/06/2025
trn_rcms_caseid = 17939000009228
adjourn_type = 0
court_code = 10185
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=14850000010105
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=30/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
case_no=2024/68
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
trn_rcms_caseid=17939000009228
Param Type = c
adjourn_type=0
Param Type = c
court_code=10185
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,next_hear_date,isadjourn,new_case_purpose,case_no,pre_case_purpose,adjourn_remark,pre_hear_date,trn_rcms_caseid,adjourn_type,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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:case_no,:pre_case_purpose,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:adjourn_type,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14850000010106
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 30/07/2025
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
adjourn_type = 0
case_no = 2024/71
court_code = 10185
trn_rcms_caseid = 18830000008352
adjourn_remark =
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=14850000010106
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=30/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/71
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=18830000008352
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,adjourn_type,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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:adjourn_type,: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 = 7
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 = 5
RecordId = 14850000010107
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 24/06/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 17578000010885
court_code = 10185
case_no = 2025/105
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 01/07/2025
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=14850000010107
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=17578000010885
Param Type = c
court_code=10185
Param Type = c
case_no=2025/105
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=01/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=14
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 7
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14850000010108
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 7
pre_hear_date = 24/06/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 18049000010674
court_code = 10185
case_no = 2025/108
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 01/07/2025
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=14850000010108
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=18049000010674
Param Type = c
court_code=10185
Param Type = c
case_no=2025/108
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=01/07/2025 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,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 = 7
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 = 5
RecordId = 14850000010109
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 01/07/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2025/110
court_code = 10185
trn_rcms_caseid = 18302000010163
pre_case_purpose = 18678000000000
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=14850000010109
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=01/07/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2025/110
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=18302000010163
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/06/2025 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,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 = 7
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 = 5
RecordId = 14850000010110
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 9
next_hear_date = 01/07/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2025/116
court_code = 10185
trn_rcms_caseid = 14432000010971
pre_case_purpose = 18678000000000
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=14850000010110
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=01/07/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2025/116
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=14432000010971
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/06/2025 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,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 = 12
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 = 13
RecordId = 14850000010111
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 7
trn_rcms_caseid = 14619000009600
pre_hear_date = 24/06/2025
case_no = 2025/119
adjourn_remark =
court_code = 10185
pre_case_purpose = 18678000000000
next_hear_date = 01/07/2025
isadjourn = NO
new_case_purpose = 18678000000000
adjourn_type = 0
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=14850000010111
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=14619000009600
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
case_no=2025/119
Param Type = c
court_code=10185
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
next_hear_date=01/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
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,trn_rcms_caseid,pre_hear_date,case_no,adjourn_remark,court_code,pre_case_purpose,next_hear_date,isadjourn,new_case_purpose,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,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,null,:court_code,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 10
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14850000010112
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
court_code = 10185
case_no = 2025/120
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 17275000011685
pre_hear_date = 24/06/2025
adjourn_remark =
next_hear_date = 10/07/2025
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=14850000010112
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10185
Param Type = c
case_no=2025/120
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=17275000011685
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
next_hear_date=10/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,next_hear_date,isadjourn,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 8
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010113
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 9
new_case_purpose = 18678000000000
isadjourn = NO
next_hear_date = 01/07/2025
pre_case_purpose = 18678000000000
case_no = 2025/122
court_code = 10185
pre_hear_date = 24/06/2025
trn_rcms_caseid = 17451000010517
adjourn_remark =
adjourn_type = 0
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=14850000010113
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=01/07/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2025/122
Param Type = c
court_code=10185
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
trn_rcms_caseid=17451000010517
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,isadjourn,next_hear_date,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,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,:new_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 8
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 14850000010114
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 8
case_no = 2025/27
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 17661000010005
pre_hear_date = 24/06/2025
adjourn_remark =
court_code = 10185
adjourn_type = 0
next_hear_date = 10/07/2025
isadjourn = NO
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=14850000010114
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2025/27
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=17661000010005
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
court_code=10185
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=10/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14850000010115
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 08/07/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2025/28
court_code = 10185
trn_rcms_caseid = 17747000011562
pre_case_purpose = 18678000000000
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=14850000010115
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/07/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2025/28
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=17747000011562
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 7
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14850000010116
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 08/07/2025
isadjourn = NO
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 24/06/2025
case_no = 2025/3
court_code = 10185
trn_rcms_caseid = 10507000010788
adjourn_type = 0
adjourn_remark =
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=14850000010116
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:13
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
case_no=2025/3
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=10507000010788
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_type,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:adjourn_type,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010117
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 10
pre_hear_date = 24/06/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 15113000009967
court_code = 10185
case_no = 2025/72
isadjourn = NO
adjourn_type = 0
next_hear_date = 01/07/2025
adjourn_remark =
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=14850000010117
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:14
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=15113000009967
Param Type = c
court_code=10185
Param Type = c
case_no=2025/72
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=01/07/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_type,next_hear_date,adjourn_remark,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 14850000010118
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
court_code = 10185
isadjourn = NO
next_hear_date = 22/07/2025
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18678000000000
pre_hear_date = 24/06/2025
trn_rcms_caseid = 15320000009666
case_no = 2025/73
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=14850000010118
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:14
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10185
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
trn_rcms_caseid=15320000009666
Param Type = c
case_no=2025/73
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,pre_hear_date,trn_rcms_caseid,case_no,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 8
Adding new record to store data from Frame 2, Row 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14850000010119
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 9
court_code = 10185
pre_case_purpose = 18619000000000
case_no = 2020/00171
trn_rcms_caseid = 19350000005432
pre_hear_date = 24/06/2025
new_case_purpose = 18619000000000
adjourn_type = 0
adjourn_remark =
next_hear_date = 01/07/2025
isadjourn = NO
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=14850000010119
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:14
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10185
Param Type = n
pre_case_purpose=18619000000000
Param Type = c
case_no=2020/00171
Param Type = c
trn_rcms_caseid=19350000005432
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
new_case_purpose=18619000000000
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=01/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,pre_case_purpose,case_no,trn_rcms_caseid,pre_hear_date,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:pre_case_purpose,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14850000010120
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
trn_rcms_caseid = 10405000007263
pre_hear_date = 24/06/2025
court_code = 10185
case_no = 2021/213
pre_case_purpose = 18619000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18619000000000
next_hear_date = 10/07/2025
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=14850000010120
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:14
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=10405000007263
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
court_code=10185
Param Type = c
case_no=2021/213
Param Type = n
pre_case_purpose=18619000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18619000000000
Param Type = c
next_hear_date=10/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=27
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 28 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14850000010121
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 18525000000261
pre_case_purpose = 18468000000000
pre_hear_date = 24/06/2025
case_no = 2016/00107
new_case_purpose = 18468000000000
adjourn_type = 0
court_code = 10185
next_hear_date = 01/07/2025
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=14850000010121
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:14
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=18525000000261
Param Type = n
pre_case_purpose=18468000000000
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
case_no=2016/00107
Param Type = c
new_case_purpose=18468000000000
Param Type = c
adjourn_type=0
Param Type = c
court_code=10185
Param Type = c
next_hear_date=01/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,isadjourn,trn_rcms_caseid,pre_case_purpose,pre_hear_date,case_no,new_case_purpose,adjourn_type,court_code,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:isadjourn,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:new_case_purpose,:adjourn_type,:court_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14850000010122
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 18471000000495
pre_hear_date = 24/06/2025
court_code = 10185
case_no = 2016/00087
next_hear_date = 01/07/2025
isadjourn = NO
pre_case_purpose = 18466000000000
new_case_purpose = 18466000000000
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=14850000010122
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:14
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18471000000495
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
court_code=10185
Param Type = c
case_no=2016/00087
Param Type = c
next_hear_date=01/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
new_case_purpose=18466000000000
Param Type = n
trn_rcms_hearingrow=29
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 13
Adding new record to store data from Frame 2, Row 30 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14850000010123
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
adjourn_type = 0
adjourn_remark =
pre_hear_date = 24/06/2025
trn_rcms_caseid = 12850000005542
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
next_hear_date = 22/07/2025
isadjourn = NO
case_no = 2020/00168
court_code = 10185
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=14850000010123
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:14
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
trn_rcms_caseid=12850000005542
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2020/00168
Param Type = c
court_code=10185
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 5
Adding new record to store data from Frame 2, Row 31 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14850000010124
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 0
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 16164000009083
case_no = 2024/111
court_code = 10185
pre_hear_date = 24/06/2025
next_hear_date = 10/07/2025
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=14850000010124
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:14
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:14
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=16164000009083
Param Type = c
case_no=2024/111
Param Type = c
court_code=10185
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
next_hear_date=10/07/2025 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = n
trn_rcms_hearingrow=31
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 6
Adding new record to store data from Frame 2, Row 32 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14850000010125
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 15
isadjourn = NO
adjourn_type = 0
adjourn_remark =
case_no = 2024/112
court_code = 10185
pre_hear_date = 24/06/2025
trn_rcms_caseid = 12439000009708
next_hear_date = 10/07/2025
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=14850000010125
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:14
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:14
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=2024/112
Param Type = c
court_code=10185
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = c
trn_rcms_caseid=12439000009708
Param Type = c
next_hear_date=10/07/2025 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = n
trn_rcms_hearingrow=32
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 6
Adding new record to store data from Frame 2, Row 33 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010126
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 10/07/2025
trn_rcms_caseid = 13656000008960
case_no = 2025/34
court_code = 10185
new_case_purpose = 1000492
pre_case_purpose = 1000492
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 33
Posting record
Param Type = n
trn_rcms_hearingid=14850000010126
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:14
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:14
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=10/07/2025 00:00:00
Param Type = c
trn_rcms_caseid=13656000008960
Param Type = c
case_no=2025/34
Param Type = c
court_code=10185
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=33
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 7
Adding new record to store data from Frame 2, Row 34 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010127
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 22/07/2025
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 18100000004734
court_code = 10185
case_no = 2008/00483
new_case_purpose = 18470000000000
pre_case_purpose = 18470000000000
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 34
Posting record
Param Type = n
trn_rcms_hearingid=14850000010127
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:14
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18100000004734
Param Type = c
court_code=10185
Param Type = c
case_no=2008/00483
Param Type = c
new_case_purpose=18470000000000
Param Type = n
pre_case_purpose=18470000000000
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=34
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 = 5
Adding new record to store data from Frame 2, Row 35 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010128
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 22/07/2025
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18470000000000
case_no = 2015/00475
court_code = 10185
trn_rcms_caseid = 11500000004483
pre_case_purpose = 18470000000000
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 35
Posting record
Param Type = n
trn_rcms_hearingid=14850000010128
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:14
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18470000000000
Param Type = c
case_no=2015/00475
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=11500000004483
Param Type = n
pre_case_purpose=18470000000000
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=35
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 = 6
Adding new record to store data from Frame 2, Row 36 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 14850000010129
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 22/07/2025
new_case_purpose = 18470000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2024/60
court_code = 10185
trn_rcms_caseid = 16077000008055
pre_case_purpose = 18470000000000
pre_hear_date = 24/06/2025
TRN_RCMS_HEARINGrow = 36
Posting record
Param Type = n
trn_rcms_hearingid=14850000010129
Param Type = n
trn_rcms_mhearingid=14850000010093
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:14
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = c
new_case_purpose=18470000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/60
Param Type = c
court_code=10185
Param Type = c
trn_rcms_caseid=16077000008055
Param Type = n
pre_case_purpose=18470000000000
Param Type = c
pre_hear_date=24/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=36
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 = 3960009677974
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18116000010020 idvalue 0
Mapped case_no Row = 1 value = 2024/207 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 30/07/2025 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 = 10185
trn_rcms_caseregid = 18116000010020
case_no = 2024/207
prev_hearing_date = 24/06/2025
hearing_date = 30/07/2025
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 = 7
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010130
MapName trcmf1
SourceId 14850000010094
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 13
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 30/07/2025
case_no = 2024/207
trn_rcms_caseregid = 18116000010020
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010130
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010094
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:14
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:14
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=30/07/2025 00:00:00
Param Type = c
case_no=2024/207
Param Type = c
trn_rcms_caseregid=18116000010020
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17377000009948 idvalue 0
Mapped case_no Row = 1 value = 2024/221 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 10/07/2025 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 = 10185
trn_rcms_caseregid = 17377000009948
case_no = 2024/221
prev_hearing_date = 24/06/2025
hearing_date = 10/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010131
MapName trcmf1
SourceId 14850000010095
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 10/07/2025
case_no = 2024/221
trn_rcms_caseregid = 17377000009948
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010131
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010095
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:19
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:19
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=10/07/2025 00:00:00
Param Type = c
case_no=2024/221
Param Type = c
trn_rcms_caseregid=17377000009948
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16204000009207 idvalue 0
Mapped case_no Row = 1 value = 2024/235 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 01/07/2025 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 = 10185
trn_rcms_caseregid = 16204000009207
case_no = 2024/235
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14850000010132
MapName trcmf1
SourceId 14850000010096
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/07/2025
case_no = 2024/235
trn_rcms_caseregid = 16204000009207
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010132
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010096
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:23
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:23
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=01/07/2025 00:00:00
Param Type = c
case_no=2024/235
Param Type = c
trn_rcms_caseregid=16204000009207
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19684000008922 idvalue 0
Mapped case_no Row = 1 value = 2024/238 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 01/07/2025 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 = 10185
trn_rcms_caseregid = 19684000008922
case_no = 2024/238
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
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 = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010133
MapName trcmf1
SourceId 14850000010097
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/07/2025
case_no = 2024/238
trn_rcms_caseregid = 19684000008922
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010133
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010097
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:27
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=01/07/2025 00:00:00
Param Type = c
case_no=2024/238
Param Type = c
trn_rcms_caseregid=19684000008922
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12974000009039 idvalue 0
Mapped case_no Row = 1 value = 2024/250 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 10/07/2025 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 = 10185
trn_rcms_caseregid = 12974000009039
case_no = 2024/250
prev_hearing_date = 24/06/2025
hearing_date = 10/07/2025
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 = 13
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 = 17
RecordId = 14850000010134
MapName trcmf1
SourceId 14850000010098
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 10/07/2025
case_no = 2024/250
trn_rcms_caseregid = 12974000009039
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010134
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010098
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:31
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=10/07/2025 00:00:00
Param Type = c
case_no=2024/250
Param Type = c
trn_rcms_caseregid=12974000009039
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13770000010081 idvalue 0
Mapped case_no Row = 1 value = 2024/253 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 01/07/2025 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 = 10185
trn_rcms_caseregid = 13770000010081
case_no = 2024/253
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
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 = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010135
MapName trcmf1
SourceId 14850000010099
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/07/2025
case_no = 2024/253
trn_rcms_caseregid = 13770000010081
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010135
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010099
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:35
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=01/07/2025 00:00:00
Param Type = c
case_no=2024/253
Param Type = c
trn_rcms_caseregid=13770000010081
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13678000008905 idvalue 0
Mapped case_no Row = 1 value = 2024/259 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 01/07/2025 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 = 10185
trn_rcms_caseregid = 13678000008905
case_no = 2024/259
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
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 = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010136
MapName trcmf1
SourceId 14850000010100
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/07/2025
case_no = 2024/259
trn_rcms_caseregid = 13678000008905
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010136
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010100
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:39
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=01/07/2025 00:00:00
Param Type = c
case_no=2024/259
Param Type = c
trn_rcms_caseregid=13678000008905
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13749000008906 idvalue 0
Mapped case_no Row = 1 value = 2024/260 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 01/07/2025 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 = 10185
trn_rcms_caseregid = 13749000008906
case_no = 2024/260
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010137
MapName trcmf1
SourceId 14850000010101
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/07/2025
case_no = 2024/260
trn_rcms_caseregid = 13749000008906
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010137
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010101
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:43
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=01/07/2025 00:00:00
Param Type = c
case_no=2024/260
Param Type = c
trn_rcms_caseregid=13749000008906
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14545000009056 idvalue 0
Mapped case_no Row = 1 value = 2024/55 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 29/07/2025 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 = 10185
trn_rcms_caseregid = 14545000009056
case_no = 2024/55
prev_hearing_date = 24/06/2025
hearing_date = 29/07/2025
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 = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 15
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010138
MapName trcmf1
SourceId 14850000010102
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 29/07/2025
case_no = 2024/55
trn_rcms_caseregid = 14545000009056
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010138
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010102
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:47
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=29/07/2025 00:00:00
Param Type = c
case_no=2024/55
Param Type = c
trn_rcms_caseregid=14545000009056
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14653000006828 idvalue 0
Mapped case_no Row = 1 value = 2024/56 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 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 = 10185
trn_rcms_caseregid = 14653000006828
case_no = 2024/56
prev_hearing_date = 24/06/2025
hearing_date = 22/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14850000010139
MapName trcmf1
SourceId 14850000010103
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/07/2025
case_no = 2024/56
trn_rcms_caseregid = 14653000006828
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010139
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010103
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:52
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2024/56
Param Type = c
trn_rcms_caseregid=14653000006828
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16102000008691 idvalue 0
Mapped case_no Row = 1 value = 2024/63 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 10/07/2025 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 = 10185
trn_rcms_caseregid = 16102000008691
case_no = 2024/63
prev_hearing_date = 24/06/2025
hearing_date = 10/07/2025
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 = 12
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 42
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 = 8
RecordId = 14850000010140
MapName trcmf1
SourceId 14850000010104
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 10/07/2025
case_no = 2024/63
trn_rcms_caseregid = 16102000008691
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010140
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010104
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:41:56
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:41:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=10/07/2025 00:00:00
Param Type = c
case_no=2024/63
Param Type = c
trn_rcms_caseregid=16102000008691
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17939000009228 idvalue 0
Mapped case_no Row = 1 value = 2024/68 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 30/07/2025 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 = 10185
trn_rcms_caseregid = 17939000009228
case_no = 2024/68
prev_hearing_date = 24/06/2025
hearing_date = 30/07/2025
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 = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010141
MapName trcmf1
SourceId 14850000010105
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 30/07/2025
case_no = 2024/68
trn_rcms_caseregid = 17939000009228
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010141
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010105
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:00
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42: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=18678000000000
Param Type = c
hearing_date=30/07/2025 00:00:00
Param Type = c
case_no=2024/68
Param Type = c
trn_rcms_caseregid=17939000009228
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18830000008352 idvalue 0
Mapped case_no Row = 1 value = 2024/71 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 30/07/2025 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 = 10185
trn_rcms_caseregid = 18830000008352
case_no = 2024/71
prev_hearing_date = 24/06/2025
hearing_date = 30/07/2025
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 = 10
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010142
MapName trcmf1
SourceId 14850000010106
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 30/07/2025
case_no = 2024/71
trn_rcms_caseregid = 18830000008352
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010142
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010106
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:05
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42: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=18678000000000
Param Type = c
hearing_date=30/07/2025 00:00:00
Param Type = c
case_no=2024/71
Param Type = c
trn_rcms_caseregid=18830000008352
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17578000010885 idvalue 0
Mapped case_no Row = 1 value = 2025/105 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 01/07/2025 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 = 10185
trn_rcms_caseregid = 17578000010885
case_no = 2025/105
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
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 = 8
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 = 14850000010143
MapName trcmf1
SourceId 14850000010107
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/07/2025
case_no = 2025/105
trn_rcms_caseregid = 17578000010885
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010143
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010107
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:09
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42:09
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=01/07/2025 00:00:00
Param Type = c
case_no=2025/105
Param Type = c
trn_rcms_caseregid=17578000010885
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18049000010674 idvalue 0
Mapped case_no Row = 1 value = 2025/108 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 01/07/2025 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 = 10185
trn_rcms_caseregid = 18049000010674
case_no = 2025/108
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
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 = 12
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 = 7
RecordId = 14850000010144
MapName trcmf1
SourceId 14850000010108
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/07/2025
case_no = 2025/108
trn_rcms_caseregid = 18049000010674
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010144
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010108
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:12
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42:12
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=01/07/2025 00:00:00
Param Type = c
case_no=2025/108
Param Type = c
trn_rcms_caseregid=18049000010674
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18302000010163 idvalue 0
Mapped case_no Row = 1 value = 2025/110 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 01/07/2025 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 = 10185
trn_rcms_caseregid = 18302000010163
case_no = 2025/110
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
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 = 8
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 = 14850000010145
MapName trcmf1
SourceId 14850000010109
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 10
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/07/2025
case_no = 2025/110
trn_rcms_caseregid = 18302000010163
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010145
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010109
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:17
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42:17
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=01/07/2025 00:00:00
Param Type = c
case_no=2025/110
Param Type = c
trn_rcms_caseregid=18302000010163
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14432000010971 idvalue 0
Mapped case_no Row = 1 value = 2025/116 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 01/07/2025 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 = 10185
trn_rcms_caseregid = 14432000010971
case_no = 2025/116
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 14850000010146
MapName trcmf1
SourceId 14850000010110
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/07/2025
case_no = 2025/116
trn_rcms_caseregid = 14432000010971
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010146
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010110
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:21
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42:21
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=01/07/2025 00:00:00
Param Type = c
case_no=2025/116
Param Type = c
trn_rcms_caseregid=14432000010971
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14619000009600 idvalue 0
Mapped case_no Row = 1 value = 2025/119 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 01/07/2025 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 = 10185
trn_rcms_caseregid = 14619000009600
case_no = 2025/119
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010147
MapName trcmf1
SourceId 14850000010111
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/07/2025
case_no = 2025/119
trn_rcms_caseregid = 14619000009600
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010147
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010111
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:25
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42:25
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=01/07/2025 00:00:00
Param Type = c
case_no=2025/119
Param Type = c
trn_rcms_caseregid=14619000009600
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 19
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17275000011685 idvalue 0
Mapped case_no Row = 1 value = 2025/120 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 10/07/2025 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 = 10185
trn_rcms_caseregid = 17275000011685
case_no = 2025/120
prev_hearing_date = 24/06/2025
hearing_date = 10/07/2025
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 = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010148
MapName trcmf1
SourceId 14850000010112
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 10/07/2025
case_no = 2025/120
trn_rcms_caseregid = 17275000011685
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010148
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010112
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:29
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=10/07/2025 00:00:00
Param Type = c
case_no=2025/120
Param Type = c
trn_rcms_caseregid=17275000011685
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 20
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17451000010517 idvalue 0
Mapped case_no Row = 1 value = 2025/122 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 01/07/2025 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 = 10185
trn_rcms_caseregid = 17451000010517
case_no = 2025/122
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
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 = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010149
MapName trcmf1
SourceId 14850000010113
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/07/2025
case_no = 2025/122
trn_rcms_caseregid = 17451000010517
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010149
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010113
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:32
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=01/07/2025 00:00:00
Param Type = c
case_no=2025/122
Param Type = c
trn_rcms_caseregid=17451000010517
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 21
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17661000010005 idvalue 0
Mapped case_no Row = 1 value = 2025/27 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 10/07/2025 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 = 10185
trn_rcms_caseregid = 17661000010005
case_no = 2025/27
prev_hearing_date = 24/06/2025
hearing_date = 10/07/2025
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 = 8
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 = 6
RecordId = 14850000010150
MapName trcmf1
SourceId 14850000010114
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 10/07/2025
case_no = 2025/27
trn_rcms_caseregid = 17661000010005
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010150
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010114
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:36
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=10/07/2025 00:00:00
Param Type = c
case_no=2025/27
Param Type = c
trn_rcms_caseregid=17661000010005
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 22
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17747000011562 idvalue 0
Mapped case_no Row = 1 value = 2025/28 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 08/07/2025 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 = 10185
trn_rcms_caseregid = 17747000011562
case_no = 2025/28
prev_hearing_date = 24/06/2025
hearing_date = 08/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010151
MapName trcmf1
SourceId 14850000010115
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/07/2025
case_no = 2025/28
trn_rcms_caseregid = 17747000011562
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010151
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010115
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:40
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/07/2025 00:00:00
Param Type = c
case_no=2025/28
Param Type = c
trn_rcms_caseregid=17747000011562
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 23
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10507000010788 idvalue 0
Mapped case_no Row = 1 value = 2025/3 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 08/07/2025 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 = 10185
trn_rcms_caseregid = 10507000010788
case_no = 2025/3
prev_hearing_date = 24/06/2025
hearing_date = 08/07/2025
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 = 8
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 = 6
RecordId = 14850000010152
MapName trcmf1
SourceId 14850000010116
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/07/2025
case_no = 2025/3
trn_rcms_caseregid = 10507000010788
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010152
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010116
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:44
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/07/2025 00:00:00
Param Type = c
case_no=2025/3
Param Type = c
trn_rcms_caseregid=10507000010788
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 24
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15113000009967 idvalue 0
Mapped case_no Row = 1 value = 2025/72 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 01/07/2025 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 = 10185
trn_rcms_caseregid = 15113000009967
case_no = 2025/72
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
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 = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010153
MapName trcmf1
SourceId 14850000010117
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/07/2025
case_no = 2025/72
trn_rcms_caseregid = 15113000009967
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010153
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010117
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:48
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=01/07/2025 00:00:00
Param Type = c
case_no=2025/72
Param Type = c
trn_rcms_caseregid=15113000009967
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 25
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15320000009666 idvalue 0
Mapped case_no Row = 1 value = 2025/73 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 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 = 10185
trn_rcms_caseregid = 15320000009666
case_no = 2025/73
prev_hearing_date = 24/06/2025
hearing_date = 22/07/2025
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010154
MapName trcmf1
SourceId 14850000010118
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/07/2025
case_no = 2025/73
trn_rcms_caseregid = 15320000009666
court_code = 10185
case_purpose = 18678000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010154
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010118
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:52
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2025/73
Param Type = c
trn_rcms_caseregid=15320000009666
Param Type = c
court_code=10185
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 26
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19350000005432 idvalue 0
Mapped case_no Row = 1 value = 2020/00171 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 01/07/2025 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 = 10185
trn_rcms_caseregid = 19350000005432
case_no = 2020/00171
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
prev_case_purposename = ??????? ?????
prev_case_purpose =
prev_case_purposename=??????? ?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ?????
Time elapsed = 6
prev_case_purpose after validation = 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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 12
RecordId = 14850000010155
MapName trcmf1
SourceId 14850000010119
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 10
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18619000000000
hearing_date = 01/07/2025
case_no = 2020/00171
trn_rcms_caseregid = 19350000005432
court_code = 10185
case_purpose = 18619000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010155
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010119
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:42:57
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:42: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=18619000000000
Param Type = c
hearing_date=01/07/2025 00:00:00
Param Type = c
case_no=2020/00171
Param Type = c
trn_rcms_caseregid=19350000005432
Param Type = c
court_code=10185
Param Type = c
case_purpose=18619000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 27
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10405000007263 idvalue 0
Mapped case_no Row = 1 value = 2021/213 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 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 = 10/07/2025 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 = 10185
trn_rcms_caseregid = 10405000007263
case_no = 2021/213
prev_hearing_date = 24/06/2025
hearing_date = 10/07/2025
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 = 7
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
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 = 9
RecordId = 14850000010156
MapName trcmf1
SourceId 14850000010120
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18619000000000
hearing_date = 10/07/2025
case_no = 2021/213
trn_rcms_caseregid = 10405000007263
court_code = 10185
case_purpose = 18619000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010156
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010120
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:43:01
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:43: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=18619000000000
Param Type = c
hearing_date=10/07/2025 00:00:00
Param Type = c
case_no=2021/213
Param Type = c
trn_rcms_caseregid=10405000007263
Param Type = c
court_code=10185
Param Type = c
case_purpose=18619000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 28
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18525000000261 idvalue 0
Mapped case_no Row = 1 value = 2016/00107 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 18468000000000 idvalue 0
Mapped hearing_date Row = 1 value = 01/07/2025 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 = 10185
trn_rcms_caseregid = 18525000000261
case_no = 2016/00107
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
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 = 53
prev_case_purpose after validation = 18468000000000
case_purpose = 18468000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010157
MapName trcmf1
SourceId 14850000010121
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18468000000000
hearing_date = 01/07/2025
case_no = 2016/00107
trn_rcms_caseregid = 18525000000261
court_code = 10185
case_purpose = 18468000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010157
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010121
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:43:05
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:43: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=18468000000000
Param Type = c
hearing_date=01/07/2025 00:00:00
Param Type = c
case_no=2016/00107
Param Type = c
trn_rcms_caseregid=18525000000261
Param Type = c
court_code=10185
Param Type = c
case_purpose=18468000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 29
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18471000000495 idvalue 0
Mapped case_no Row = 1 value = 2016/00087 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 01/07/2025 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 = 10185
trn_rcms_caseregid = 18471000000495
case_no = 2016/00087
prev_hearing_date = 24/06/2025
hearing_date = 01/07/2025
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 = 18
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 9
RecordId = 14850000010158
MapName trcmf1
SourceId 14850000010122
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 10
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 01/07/2025
case_no = 2016/00087
trn_rcms_caseregid = 18471000000495
court_code = 10185
case_purpose = 18466000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010158
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010122
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:43:10
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:43:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=01/07/2025 00:00:00
Param Type = c
case_no=2016/00087
Param Type = c
trn_rcms_caseregid=18471000000495
Param Type = c
court_code=10185
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 30
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12850000005542 idvalue 0
Mapped case_no Row = 1 value = 2020/00168 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 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 = 10185
trn_rcms_caseregid = 12850000005542
case_no = 2020/00168
prev_hearing_date = 24/06/2025
hearing_date = 22/07/2025
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 20
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 = 5
RecordId = 14850000010159
MapName trcmf1
SourceId 14850000010123
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 22/07/2025
case_no = 2020/00168
trn_rcms_caseregid = 12850000005542
court_code = 10185
case_purpose = 18466000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010159
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010123
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:43:15
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:43:15
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2020/00168
Param Type = c
trn_rcms_caseregid=12850000005542
Param Type = c
court_code=10185
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 31
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16164000009083 idvalue 0
Mapped case_no Row = 1 value = 2024/111 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 10/07/2025 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 = 10185
trn_rcms_caseregid = 16164000009083
case_no = 2024/111
prev_hearing_date = 24/06/2025
hearing_date = 10/07/2025
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010160
MapName trcmf1
SourceId 14850000010124
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 10/07/2025
case_no = 2024/111
trn_rcms_caseregid = 16164000009083
court_code = 10185
case_purpose = 18466000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010160
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010124
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:43:19
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:43:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=10/07/2025 00:00:00
Param Type = c
case_no=2024/111
Param Type = c
trn_rcms_caseregid=16164000009083
Param Type = c
court_code=10185
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 32
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12439000009708 idvalue 0
Mapped case_no Row = 1 value = 2024/112 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 10/07/2025 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 = 10185
trn_rcms_caseregid = 12439000009708
case_no = 2024/112
prev_hearing_date = 24/06/2025
hearing_date = 10/07/2025
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 14850000010161
MapName trcmf1
SourceId 14850000010125
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 10/07/2025
case_no = 2024/112
trn_rcms_caseregid = 12439000009708
court_code = 10185
case_purpose = 18466000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010161
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010125
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:43:23
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:43:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=10/07/2025 00:00:00
Param Type = c
case_no=2024/112
Param Type = c
trn_rcms_caseregid=12439000009708
Param Type = c
court_code=10185
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=24/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 33
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13656000008960 idvalue 0
Mapped case_no Row = 1 value = 2025/34 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/07/2025 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 = 10185
trn_rcms_caseregid = 13656000008960
case_no = 2025/34
prev_hearing_date = 24/06/2025
hearing_date = 10/07/2025
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 = 7
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
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 = 6
RecordId = 14850000010162
MapName trcmf1
SourceId 14850000010126
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 10/07/2025
case_no = 2025/34
trn_rcms_caseregid = 13656000008960
court_code = 10185
case_purpose = 1000492
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010162
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010126
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:43:28
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:43:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=10/07/2025 00:00:00
Param Type = c
case_no=2025/34
Param Type = c
trn_rcms_caseregid=13656000008960
Param Type = c
court_code=10185
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=24/06/2025 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 34
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18100000004734 idvalue 0
Mapped case_no Row = 1 value = 2008/00483 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ?????? ???????? idvalue 0
Mapped case_purpose Row = 1 value = 18470000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 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 = 10185
trn_rcms_caseregid = 18100000004734
case_no = 2008/00483
prev_hearing_date = 24/06/2025
hearing_date = 22/07/2025
prev_case_purposename = ??????? ?????? ????????
prev_case_purpose =
prev_case_purposename=??????? ?????? ????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ?????? ????????
Time elapsed = 6
prev_case_purpose after validation = 18470000000000
case_purpose = 18470000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14850000010163
MapName trcmf1
SourceId 14850000010127
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18470000000000
hearing_date = 22/07/2025
case_no = 2008/00483
trn_rcms_caseregid = 18100000004734
court_code = 10185
case_purpose = 18470000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010163
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010127
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:43:32
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:43:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18470000000000
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2008/00483
Param Type = c
trn_rcms_caseregid=18100000004734
Param Type = c
court_code=10185
Param Type = c
case_purpose=18470000000000
Param Type = c
prev_hearing_date=24/06/2025 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 35
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11500000004483 idvalue 0
Mapped case_no Row = 1 value = 2015/00475 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ?????? ???????? idvalue 0
Mapped case_purpose Row = 1 value = 18470000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 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 = 10185
trn_rcms_caseregid = 11500000004483
case_no = 2015/00475
prev_hearing_date = 24/06/2025
hearing_date = 22/07/2025
prev_case_purposename = ??????? ?????? ????????
prev_case_purpose =
prev_case_purpose after validation = 18470000000000
case_purpose = 18470000000000
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
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 = 6
RecordId = 14850000010164
MapName trcmf1
SourceId 14850000010128
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18470000000000
hearing_date = 22/07/2025
case_no = 2015/00475
trn_rcms_caseregid = 11500000004483
court_code = 10185
case_purpose = 18470000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010164
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010128
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:43:36
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:43:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18470000000000
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2015/00475
Param Type = c
trn_rcms_caseregid=11500000004483
Param Type = c
court_code=10185
Param Type = c
case_purpose=18470000000000
Param Type = c
prev_hearing_date=24/06/2025 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 36
>>Mapping
Mapped court_code Row = 1 value = 10185 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16077000008055 idvalue 0
Mapped case_no Row = 1 value = 2024/60 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ?????? ???????? idvalue 0
Mapped case_purpose Row = 1 value = 18470000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 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 = 10185
trn_rcms_caseregid = 16077000008055
case_no = 2024/60
prev_hearing_date = 24/06/2025
hearing_date = 22/07/2025
prev_case_purposename = ??????? ?????? ????????
prev_case_purpose =
prev_case_purpose after validation = 18470000000000
case_purpose = 18470000000000
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 = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14850000010165
MapName trcmf1
SourceId 14850000010129
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18470000000000
hearing_date = 22/07/2025
case_no = 2024/60
trn_rcms_caseregid = 16077000008055
court_code = 10185
case_purpose = 18470000000000
prev_hearing_date = 24/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=14850000010165
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14850000010129
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Taleda_PRO
Param Type = c
createdon=25/06/2025 10:43:40
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
modifiedon=25/06/2025 10:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18470000000000
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2024/60
Param Type = c
trn_rcms_caseregid=16077000008055
Param Type = c
court_code=10185
Param Type = c
case_purpose=18470000000000
Param Type = c
prev_hearing_date=24/06/2025 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 = 3960009827908
Time elapsed for MD Map = 3960009827909
Time elapsed for Save History = 3960009827910
Time elapsed for Save Attachment = 3960009827910
Time elapsed for After Save WF Exec = 3960009827920
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"14850000010093"}]}
Savedata webservice completed
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=SDO_Taleda_PRO
Param Type = c
calledon=25/06/2025 10:39:23
Param Type = c
callfinished=25/06/2025 10:43:47
Param Type = c
structname=trcmf
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=success
Param Type = n
timetaken=264707
Param Type = n
dbtimetaken=262611
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