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_Reengas_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_Reengas_PRO
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Reengas_PRO
Time elapsed = 7
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_Reengas_PRO
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Reengas_PRO
Time elapsed = 4
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_Reengas_PRO
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Reengas_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 1044010007947
Result = 1044010007947
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_Reengas_PRO
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1912550010368
Result = 1912550010368
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_Reengas_PRO
Time elapsed = 2
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_Reengas_PRO
Result = SDO_Reengas_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_Reengas_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 18162
Result = 18162
Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Reengas_PRO
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Reengas_PRO
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Sikar
Result = Sikar
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Reengas_PRO
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Reengas_PRO
Time elapsed = 4
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=1912550010368
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1912550010368
Time elapsed = 6
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_Reengas_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10823000000000
Result = 10823000000000
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=SDO_Reengas_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_Reengas_PRO
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_admin
Result = court_admin
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=SDO_Reengas_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_Reengas_PRO
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 2
Result = 2
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 = 3
select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 5
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 = 4
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : trcmf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 4
Step4
tstructs\stm size:2075
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Evaluating date()
Result =
Evaluating iif((next_hear_date>Validating trcmf
>>Frame No 1
courtcode = 18162
hearing_date = 06/10/2025
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 2
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010161
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
hearing_date = 06/10/2025
courtcode = 18162
Posting record
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:55
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=06/10/2025 00:00:00
Param Type = c
courtcode=18162
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)
Saving to table TRN_RCMS_HEARING
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13263000010162
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 06/10/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 14816000008460
court_code = 18162
case_no = 2023/1024
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 27/10/2025
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=13263000010162
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:55
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=14816000008460
Param Type = c
court_code=18162
Param Type = c
case_no=2023/1024
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=27/10/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_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 = 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 = 2
RecordId = 13263000010163
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 06/10/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 14891000008958
court_code = 18162
case_no = 2023/1025
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 27/10/2025
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=13263000010163
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=14891000008958
Param Type = c
court_code=18162
Param Type = c
case_no=2023/1025
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=27/10/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,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010164
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 06/10/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 11289000008620
court_code = 18162
case_no = 2023/1571
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 27/10/2025
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=13263000010164
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=11289000008620
Param Type = c
court_code=18162
Param Type = c
case_no=2023/1571
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=27/10/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 = 3
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010165
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 27/10/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/675
court_code = 18162
trn_rcms_caseid = 11447000009135
pre_case_purpose = 18678000000000
pre_hear_date = 06/10/2025
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=13263000010165
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=27/10/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=2023/675
Param Type = c
court_code=18162
Param Type = c
trn_rcms_caseid=11447000009135
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/10/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 = 4
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010166
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark =
new_case_purpose = 1000492
adjourn_type = 0
next_hear_date = 27/10/2025
isadjourn = NO
case_no = 2023/1570
court_code = 18162
trn_rcms_caseid = 11002000009522
pre_case_purpose = 1000492
pre_hear_date = 06/10/2025
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=13263000010166
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000492
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=27/10/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2023/1570
Param Type = c
court_code=18162
Param Type = c
trn_rcms_caseid=11002000009522
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=06/10/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,adjourn_remark,new_case_purpose,adjourn_type,next_hear_date,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,null,:new_case_purpose,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),: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)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13263000010167
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 15/10/2025
new_case_purpose = 1000492
adjourn_type = 0
isadjourn = NO
pre_case_purpose = 1000492
case_no = 2023/2044
trn_rcms_caseid = 12718000010130
pre_hear_date = 06/10/2025
court_code = 18162
adjourn_remark =
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=13263000010167
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=15/10/2025 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=1000492
Param Type = c
case_no=2023/2044
Param Type = c
trn_rcms_caseid=12718000010130
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = c
court_code=18162
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,adjourn_type,isadjourn,pre_case_purpose,case_no,trn_rcms_caseid,pre_hear_date,court_code,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:isadjourn,:pre_case_purpose,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010168
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
isadjourn = NO
adjourn_type = 0
next_hear_date = 10/11/2025
pre_case_purpose = 1000492
new_case_purpose = 1000492
pre_hear_date = 06/10/2025
court_code = 18162
case_no = 2023/216
trn_rcms_caseid = 12318000009984
adjourn_remark =
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=13263000010168
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=10/11/2025 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = c
court_code=18162
Param Type = c
case_no=2023/216
Param Type = c
trn_rcms_caseid=12318000009984
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,isadjourn,adjourn_type,next_hear_date,pre_case_purpose,new_case_purpose,pre_hear_date,court_code,case_no,trn_rcms_caseid,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13263000010169
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 06/10/2025
pre_case_purpose = 18473000000000
trn_rcms_caseid = 11648000007872
court_code = 18162
case_no = 2023/676
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 27/10/2025
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=13263000010169
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=11648000007872
Param Type = c
court_code=18162
Param Type = c
case_no=2023/676
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=27/10/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,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 = 5
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010170
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 10/11/2025
new_case_purpose = 1000525
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/831
court_code = 18162
trn_rcms_caseid = 13032000010316
pre_case_purpose = 1000525
pre_hear_date = 06/10/2025
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=13263000010170
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=10/11/2025 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/831
Param Type = c
court_code=18162
Param Type = c
trn_rcms_caseid=13032000010316
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=06/10/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,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 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13263000010171
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2023/664
new_case_purpose = 12555000000002
pre_case_purpose = 12555000000002
trn_rcms_caseid = 14286000009618
pre_hear_date = 06/10/2025
adjourn_remark =
court_code = 18162
adjourn_type = 0
next_hear_date = 27/10/2025
isadjourn = NO
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=13263000010171
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/664
Param Type = c
new_case_purpose=12555000000002
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
trn_rcms_caseid=14286000009618
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = c
court_code=18162
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=27/10/2025 00:00:00
Param Type = c
isadjourn=NO
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,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 = 4
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010172
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2023/830
adjourn_remark =
isadjourn = NO
next_hear_date = 10/11/2025
court_code = 18162
pre_case_purpose = 12555000000002
new_case_purpose = 12555000000002
pre_hear_date = 06/10/2025
trn_rcms_caseid = 12884000008776
adjourn_type = 0
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=13263000010172
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/830
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=10/11/2025 00:00:00
Param Type = c
court_code=18162
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
new_case_purpose=12555000000002
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = c
trn_rcms_caseid=12884000008776
Param Type = c
adjourn_type=0
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,case_no,adjourn_remark,isadjourn,next_hear_date,court_code,pre_case_purpose,new_case_purpose,pre_hear_date,trn_rcms_caseid,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,null,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:pre_case_purpose,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010173
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark =
trn_rcms_caseid = 12842000010825
pre_hear_date = 06/10/2025
court_code = 18162
case_no = 2024/269
pre_case_purpose = 1000492
isadjourn = NO
adjourn_type = 0
new_case_purpose = 1000492
next_hear_date = 15/10/2025
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=13263000010173
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=12842000010825
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = c
court_code=18162
Param Type = c
case_no=2024/269
Param Type = n
pre_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=15/10/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010174
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark =
trn_rcms_caseid = 10310000009962
pre_hear_date = 06/10/2025
court_code = 18162
case_no = 2024/396
pre_case_purpose = 1000492
isadjourn = NO
adjourn_type = 0
new_case_purpose = 1000492
next_hear_date = 17/10/2025
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=13263000010174
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=10310000009962
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = c
court_code=18162
Param Type = c
case_no=2024/396
Param Type = n
pre_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=17/10/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,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 = 3
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13263000010175
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
adjourn_type = 0
pre_case_purpose = 1000492
pre_hear_date = 06/10/2025
new_case_purpose = 1000492
next_hear_date = 27/10/2025
court_code = 18162
isadjourn = NO
trn_rcms_caseid = 13562000009221
case_no = 2024/453
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=13263000010175
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=27/10/2025 00:00:00
Param Type = c
court_code=18162
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=13562000009221
Param Type = c
case_no=2024/453
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,adjourn_remark,adjourn_type,pre_case_purpose,pre_hear_date,new_case_purpose,next_hear_date,court_code,isadjourn,trn_rcms_caseid,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:isadjourn,:trn_rcms_caseid,:case_no,: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 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13263000010176
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 13605000009446
pre_hear_date = 06/10/2025
court_code = 18162
case_no = 2024/454
next_hear_date = 27/10/2025
isadjourn = NO
pre_case_purpose = 1000492
new_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=13263000010176
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13605000009446
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = c
court_code=18162
Param Type = c
case_no=2024/454
Param Type = c
next_hear_date=27/10/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
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,adjourn_type,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13263000010177
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark =
isadjourn = NO
case_no = 2024/502
trn_rcms_caseid = 10174000009271
pre_case_purpose = 1000492
court_code = 18162
next_hear_date = 16/10/2025
new_case_purpose = 1000492
pre_hear_date = 06/10/2025
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=13263000010177
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/502
Param Type = c
trn_rcms_caseid=10174000009271
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=18162
Param Type = c
next_hear_date=16/10/2025 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=06/10/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,adjourn_type,adjourn_remark,isadjourn,case_no,trn_rcms_caseid,pre_case_purpose,court_code,next_hear_date,new_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,:case_no,:trn_rcms_caseid,:pre_case_purpose,:court_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010178
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 17081000009323
case_no = 2024/510
court_code = 18162
pre_hear_date = 06/10/2025
next_hear_date = 17/11/2025
new_case_purpose = 1000492
pre_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=13263000010178
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=17081000009323
Param Type = c
case_no=2024/510
Param Type = c
court_code=18162
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = c
next_hear_date=17/11/2025 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
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,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010179
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 15/10/2025
trn_rcms_caseid = 15718000010781
case_no = 2025/248
court_code = 18162
new_case_purpose = 1000492
pre_case_purpose = 1000492
pre_hear_date = 06/10/2025
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=13263000010179
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=15/10/2025 00:00:00
Param Type = c
trn_rcms_caseid=15718000010781
Param Type = c
case_no=2025/248
Param Type = c
court_code=18162
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 20
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 = 2
RecordId = 13263000010180
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 27/10/2025
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 18823000010360
court_code = 18162
case_no = 2025/254
new_case_purpose = 1000492
pre_case_purpose = 1000492
pre_hear_date = 06/10/2025
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=13263000010180
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=27/10/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18823000010360
Param Type = c
court_code=18162
Param Type = c
case_no=2025/254
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13263000010181
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 27/10/2025
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 1000492
case_no = 2025/255
court_code = 18162
trn_rcms_caseid = 18868000010717
pre_case_purpose = 1000492
pre_hear_date = 06/10/2025
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=13263000010181
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=27/10/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000492
Param Type = c
case_no=2025/255
Param Type = c
court_code=18162
Param Type = c
trn_rcms_caseid=18868000010717
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=06/10/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 = 5
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 = 3
RecordId = 13263000010182
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 12/11/2025
new_case_purpose = 1000492
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2025/706
court_code = 18162
trn_rcms_caseid = 11354000012105
pre_case_purpose = 1000492
pre_hear_date = 06/10/2025
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=13263000010182
Param Type = n
trn_rcms_mhearingid=13263000010161
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=12/11/2025 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2025/706
Param Type = c
court_code=18162
Param Type = c
trn_rcms_caseid=11354000012105
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=06/10/2025 00:00:00
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,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 = 3969698048987
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14816000008460 idvalue 0
Mapped case_no Row = 1 value = 2023/1024 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 27/10/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 = 18162
trn_rcms_caseregid = 14816000008460
case_no = 2023/1024
prev_hearing_date = 06/10/2025
hearing_date = 27/10/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 = 3
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010183
MapName trcmf1
SourceId 13263000010162
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 27/10/2025
case_no = 2023/1024
trn_rcms_caseregid = 14816000008460
court_code = 18162
case_purpose = 18678000000000
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010183
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010162
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:56
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53: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=27/10/2025 00:00:00
Param Type = c
case_no=2023/1024
Param Type = c
trn_rcms_caseregid=14816000008460
Param Type = c
court_code=18162
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14891000008958 idvalue 0
Mapped case_no Row = 1 value = 2023/1025 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 27/10/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 = 18162
trn_rcms_caseregid = 14891000008958
case_no = 2023/1025
prev_hearing_date = 06/10/2025
hearing_date = 27/10/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 = 3
RecordId = 13263000010184
MapName trcmf1
SourceId 13263000010163
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 27/10/2025
case_no = 2023/1025
trn_rcms_caseregid = 14891000008958
court_code = 18162
case_purpose = 18678000000000
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010184
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010163
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:53:59
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:53:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=27/10/2025 00:00:00
Param Type = c
case_no=2023/1025
Param Type = c
trn_rcms_caseregid=14891000008958
Param Type = c
court_code=18162
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11289000008620 idvalue 0
Mapped case_no Row = 1 value = 2023/1571 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 27/10/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 = 18162
trn_rcms_caseregid = 11289000008620
case_no = 2023/1571
prev_hearing_date = 06/10/2025
hearing_date = 27/10/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 = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13263000010185
MapName trcmf1
SourceId 13263000010164
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 = 27/10/2025
case_no = 2023/1571
trn_rcms_caseregid = 11289000008620
court_code = 18162
case_purpose = 18678000000000
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010185
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010164
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:00
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54: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=27/10/2025 00:00:00
Param Type = c
case_no=2023/1571
Param Type = c
trn_rcms_caseregid=11289000008620
Param Type = c
court_code=18162
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11447000009135 idvalue 0
Mapped case_no Row = 1 value = 2023/675 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 27/10/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 = 18162
trn_rcms_caseregid = 11447000009135
case_no = 2023/675
prev_hearing_date = 06/10/2025
hearing_date = 27/10/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 = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010186
MapName trcmf1
SourceId 13263000010165
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 27/10/2025
case_no = 2023/675
trn_rcms_caseregid = 11447000009135
court_code = 18162
case_purpose = 18678000000000
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010186
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010165
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:02
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=27/10/2025 00:00:00
Param Type = c
case_no=2023/675
Param Type = c
trn_rcms_caseregid=11447000009135
Param Type = c
court_code=18162
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11002000009522 idvalue 0
Mapped case_no Row = 1 value = 2023/1570 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 27/10/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 = 18162
trn_rcms_caseregid = 11002000009522
case_no = 2023/1570
prev_hearing_date = 06/10/2025
hearing_date = 27/10/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 = 4
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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010187
MapName trcmf1
SourceId 13263000010166
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 27/10/2025
case_no = 2023/1570
trn_rcms_caseregid = 11002000009522
court_code = 18162
case_purpose = 1000492
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010187
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010166
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:04
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54:04
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=27/10/2025 00:00:00
Param Type = c
case_no=2023/1570
Param Type = c
trn_rcms_caseregid=11002000009522
Param Type = c
court_code=18162
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12718000010130 idvalue 0
Mapped case_no Row = 1 value = 2023/2044 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 15/10/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 = 18162
trn_rcms_caseregid = 12718000010130
case_no = 2023/2044
prev_hearing_date = 06/10/2025
hearing_date = 15/10/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010188
MapName trcmf1
SourceId 13263000010167
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 15/10/2025
case_no = 2023/2044
trn_rcms_caseregid = 12718000010130
court_code = 18162
case_purpose = 1000492
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010188
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010167
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:05
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54: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=1000492
Param Type = c
hearing_date=15/10/2025 00:00:00
Param Type = c
case_no=2023/2044
Param Type = c
trn_rcms_caseregid=12718000010130
Param Type = c
court_code=18162
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12318000009984 idvalue 0
Mapped case_no Row = 1 value = 2023/216 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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/11/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 = 18162
trn_rcms_caseregid = 12318000009984
case_no = 2023/216
prev_hearing_date = 06/10/2025
hearing_date = 10/11/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 3
RecordId = 13263000010189
MapName trcmf1
SourceId 13263000010168
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 = 1000492
hearing_date = 10/11/2025
case_no = 2023/216
trn_rcms_caseregid = 12318000009984
court_code = 18162
case_purpose = 1000492
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010189
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010168
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:07
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54:07
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/11/2025 00:00:00
Param Type = c
case_no=2023/216
Param Type = c
trn_rcms_caseregid=12318000009984
Param Type = c
court_code=18162
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11648000007872 idvalue 0
Mapped case_no Row = 1 value = 2023/676 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 27/10/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 = 18162
trn_rcms_caseregid = 11648000007872
case_no = 2023/676
prev_hearing_date = 06/10/2025
hearing_date = 27/10/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 = 3
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010190
MapName trcmf1
SourceId 13263000010169
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 27/10/2025
case_no = 2023/676
trn_rcms_caseregid = 11648000007872
court_code = 18162
case_purpose = 18473000000000
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010190
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010169
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:08
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=27/10/2025 00:00:00
Param Type = c
case_no=2023/676
Param Type = c
trn_rcms_caseregid=11648000007872
Param Type = c
court_code=18162
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13032000010316 idvalue 0
Mapped case_no Row = 1 value = 2023/831 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 10/11/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 = 18162
trn_rcms_caseregid = 13032000010316
case_no = 2023/831
prev_hearing_date = 06/10/2025
hearing_date = 10/11/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 = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13263000010191
MapName trcmf1
SourceId 13263000010170
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 = 1000525
hearing_date = 10/11/2025
case_no = 2023/831
trn_rcms_caseregid = 13032000010316
court_code = 18162
case_purpose = 1000525
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010191
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010170
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:10
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54: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=1000525
Param Type = c
hearing_date=10/11/2025 00:00:00
Param Type = c
case_no=2023/831
Param Type = c
trn_rcms_caseregid=13032000010316
Param Type = c
court_code=18162
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14286000009618 idvalue 0
Mapped case_no Row = 1 value = 2023/664 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 27/10/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 = 18162
trn_rcms_caseregid = 14286000009618
case_no = 2023/664
prev_hearing_date = 06/10/2025
hearing_date = 27/10/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 = 4
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13263000010192
MapName trcmf1
SourceId 13263000010171
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 = 12555000000002
hearing_date = 27/10/2025
case_no = 2023/664
trn_rcms_caseregid = 14286000009618
court_code = 18162
case_purpose = 12555000000002
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010192
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010171
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:12
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54: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=12555000000002
Param Type = c
hearing_date=27/10/2025 00:00:00
Param Type = c
case_no=2023/664
Param Type = c
trn_rcms_caseregid=14286000009618
Param Type = c
court_code=18162
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12884000008776 idvalue 0
Mapped case_no Row = 1 value = 2023/830 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 10/11/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 = 18162
trn_rcms_caseregid = 12884000008776
case_no = 2023/830
prev_hearing_date = 06/10/2025
hearing_date = 10/11/2025
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010193
MapName trcmf1
SourceId 13263000010172
Select sysdate as sdt from dual
Time elapsed = 3
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 = 12555000000002
hearing_date = 10/11/2025
case_no = 2023/830
trn_rcms_caseregid = 12884000008776
court_code = 18162
case_purpose = 12555000000002
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010193
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010172
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:13
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=10/11/2025 00:00:00
Param Type = c
case_no=2023/830
Param Type = c
trn_rcms_caseregid=12884000008776
Param Type = c
court_code=18162
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12842000010825 idvalue 0
Mapped case_no Row = 1 value = 2024/269 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 15/10/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 = 18162
trn_rcms_caseregid = 12842000010825
case_no = 2024/269
prev_hearing_date = 06/10/2025
hearing_date = 15/10/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 = 5
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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13263000010194
MapName trcmf1
SourceId 13263000010173
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 = 1000492
hearing_date = 15/10/2025
case_no = 2024/269
trn_rcms_caseregid = 12842000010825
court_code = 18162
case_purpose = 1000492
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010194
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010173
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:15
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54: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=1000492
Param Type = c
hearing_date=15/10/2025 00:00:00
Param Type = c
case_no=2024/269
Param Type = c
trn_rcms_caseregid=12842000010825
Param Type = c
court_code=18162
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10310000009962 idvalue 0
Mapped case_no Row = 1 value = 2024/396 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 17/10/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 = 18162
trn_rcms_caseregid = 10310000009962
case_no = 2024/396
prev_hearing_date = 06/10/2025
hearing_date = 17/10/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010195
MapName trcmf1
SourceId 13263000010174
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 17/10/2025
case_no = 2024/396
trn_rcms_caseregid = 10310000009962
court_code = 18162
case_purpose = 1000492
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010195
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010174
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:16
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54:16
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=17/10/2025 00:00:00
Param Type = c
case_no=2024/396
Param Type = c
trn_rcms_caseregid=10310000009962
Param Type = c
court_code=18162
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13562000009221 idvalue 0
Mapped case_no Row = 1 value = 2024/453 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 27/10/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 = 18162
trn_rcms_caseregid = 13562000009221
case_no = 2024/453
prev_hearing_date = 06/10/2025
hearing_date = 27/10/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010196
MapName trcmf1
SourceId 13263000010175
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 27/10/2025
case_no = 2024/453
trn_rcms_caseregid = 13562000009221
court_code = 18162
case_purpose = 1000492
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010196
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010175
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:18
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54:18
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=27/10/2025 00:00:00
Param Type = c
case_no=2024/453
Param Type = c
trn_rcms_caseregid=13562000009221
Param Type = c
court_code=18162
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13605000009446 idvalue 0
Mapped case_no Row = 1 value = 2024/454 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 27/10/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 = 18162
trn_rcms_caseregid = 13605000009446
case_no = 2024/454
prev_hearing_date = 06/10/2025
hearing_date = 27/10/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 25
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 = 13263000010197
MapName trcmf1
SourceId 13263000010176
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 27/10/2025
case_no = 2024/454
trn_rcms_caseregid = 13605000009446
court_code = 18162
case_purpose = 1000492
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010197
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010176
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:19
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54: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=1000492
Param Type = c
hearing_date=27/10/2025 00:00:00
Param Type = c
case_no=2024/454
Param Type = c
trn_rcms_caseregid=13605000009446
Param Type = c
court_code=18162
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10174000009271 idvalue 0
Mapped case_no Row = 1 value = 2024/502 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 16/10/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 = 18162
trn_rcms_caseregid = 10174000009271
case_no = 2024/502
prev_hearing_date = 06/10/2025
hearing_date = 16/10/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010198
MapName trcmf1
SourceId 13263000010177
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 16/10/2025
case_no = 2024/502
trn_rcms_caseregid = 10174000009271
court_code = 18162
case_purpose = 1000492
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010198
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010177
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:21
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54: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=1000492
Param Type = c
hearing_date=16/10/2025 00:00:00
Param Type = c
case_no=2024/502
Param Type = c
trn_rcms_caseregid=10174000009271
Param Type = c
court_code=18162
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17081000009323 idvalue 0
Mapped case_no Row = 1 value = 2024/510 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 17/11/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 = 18162
trn_rcms_caseregid = 17081000009323
case_no = 2024/510
prev_hearing_date = 06/10/2025
hearing_date = 17/11/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010199
MapName trcmf1
SourceId 13263000010178
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 17/11/2025
case_no = 2024/510
trn_rcms_caseregid = 17081000009323
court_code = 18162
case_purpose = 1000492
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010199
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010178
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:23
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54: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=1000492
Param Type = c
hearing_date=17/11/2025 00:00:00
Param Type = c
case_no=2024/510
Param Type = c
trn_rcms_caseregid=17081000009323
Param Type = c
court_code=18162
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15718000010781 idvalue 0
Mapped case_no Row = 1 value = 2025/248 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 15/10/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 = 18162
trn_rcms_caseregid = 15718000010781
case_no = 2025/248
prev_hearing_date = 06/10/2025
hearing_date = 15/10/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010200
MapName trcmf1
SourceId 13263000010179
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 15/10/2025
case_no = 2025/248
trn_rcms_caseregid = 15718000010781
court_code = 18162
case_purpose = 1000492
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010200
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010179
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:24
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54:24
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=15/10/2025 00:00:00
Param Type = c
case_no=2025/248
Param Type = c
trn_rcms_caseregid=15718000010781
Param Type = c
court_code=18162
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18823000010360 idvalue 0
Mapped case_no Row = 1 value = 2025/254 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 27/10/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 = 18162
trn_rcms_caseregid = 18823000010360
case_no = 2025/254
prev_hearing_date = 06/10/2025
hearing_date = 27/10/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 13263000010201
MapName trcmf1
SourceId 13263000010180
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 27/10/2025
case_no = 2025/254
trn_rcms_caseregid = 18823000010360
court_code = 18162
case_purpose = 1000492
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010201
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010180
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:26
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54:26
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=27/10/2025 00:00:00
Param Type = c
case_no=2025/254
Param Type = c
trn_rcms_caseregid=18823000010360
Param Type = c
court_code=18162
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18868000010717 idvalue 0
Mapped case_no Row = 1 value = 2025/255 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 27/10/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 = 18162
trn_rcms_caseregid = 18868000010717
case_no = 2025/255
prev_hearing_date = 06/10/2025
hearing_date = 27/10/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 11
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13263000010202
MapName trcmf1
SourceId 13263000010181
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 27/10/2025
case_no = 2025/255
trn_rcms_caseregid = 18868000010717
court_code = 18162
case_purpose = 1000492
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010202
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010181
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:27
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54: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=1000492
Param Type = c
hearing_date=27/10/2025 00:00:00
Param Type = c
case_no=2025/255
Param Type = c
trn_rcms_caseregid=18868000010717
Param Type = c
court_code=18162
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/10/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 = 18162 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11354000012105 idvalue 0
Mapped case_no Row = 1 value = 2025/706 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/10/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 = 12/11/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 = 18162
trn_rcms_caseregid = 11354000012105
case_no = 2025/706
prev_hearing_date = 06/10/2025
hearing_date = 12/11/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13263000010203
MapName trcmf1
SourceId 13263000010182
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 = 1000492
hearing_date = 12/11/2025
case_no = 2025/706
trn_rcms_caseregid = 11354000012105
court_code = 18162
case_purpose = 1000492
prev_hearing_date = 06/10/2025
Posting record
Param Type = n
trn_rcms_case_histid=13263000010203
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13263000010182
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Reengas_PRO
Param Type = c
createdon=15/10/2025 13:54:29
Param Type = c
username=SDO_Reengas_PRO
Param Type = c
modifiedon=15/10/2025 13:54: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=1000492
Param Type = c
hearing_date=12/11/2025 00:00:00
Param Type = c
case_no=2025/706
Param Type = c
trn_rcms_caseregid=11354000012105
Param Type = c
court_code=18162
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/10/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 = 3969698083512
Time elapsed for MD Map = 3969698083512
Time elapsed for Save History = 3969698083513
Time elapsed for Save Attachment = 3969698083513
Time elapsed for After Save WF Exec = 3969698083517
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"13263000010161"}]}
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_Reengas_PRO
Param Type = c
calledon=15/10/2025 13:54:07
Param Type = c
callfinished=15/10/2025 13:54:43
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=35752
Param Type = n
dbtimetaken=34979
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