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_Tapukada_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_Tapukada_PRO
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Tapukada_PRO
Time elapsed = 5
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_Tapukada_PRO
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Tapukada_PRO
Time elapsed = 6
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_Tapukada_PRO
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Tapukada_PRO
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 1365880008855
Result = 1365880008855
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_Tapukada_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1658880010032
Result = 1658880010032
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_Tapukada_PRO
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_Tapukada_PRO
Result = SDO_Tapukada_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_Tapukada_PRO
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 18223
Result = 18223
Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Tapukada_PRO
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Tapukada_PRO
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Khairthal-Tijara
Result = Khairthal-Tijara
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Tapukada_PRO
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Tapukada_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m8},{COURT_CATEGOTY})
Calling function sqlget
Result of sqlget = 10593000000007
Result = 10593000000007
Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
Calling function firesql
login_userid=1658880010032
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1658880010032
Time elapsed = 8
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_Tapukada_PRO
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10823000000000
Result = 10823000000000
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=SDO_Tapukada_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_Tapukada_PRO
Time elapsed = 7
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 = 4
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_Tapukada_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_Tapukada_PRO
Time elapsed = 10
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 = 2
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 = 3
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 = 18223
hearing_date = 06/11/2025
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 1
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17694000011045
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
hearing_date = 06/11/2025
courtcode = 18223
Posting record
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=06/11/2025 00:00:00
Param Type = c
courtcode=18223
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 = 3
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 = 2
RecordId = 17694000011046
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 06/11/2025
pre_case_purpose = 1000525
trn_rcms_caseid = 14552000010175
court_code = 18223
case_no = 2023/1337
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000525
next_hear_date = 12/11/2025
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=17694000011046
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = n
pre_case_purpose=1000525
Param Type = c
trn_rcms_caseid=14552000010175
Param Type = c
court_code=18223
Param Type = c
case_no=2023/1337
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=12/11/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 = 4
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 = 17694000011047
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/11/2025
pre_case_purpose = 1000525
trn_rcms_caseid = 14633000010284
court_code = 18223
case_no = 2023/1338
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000525
next_hear_date = 12/11/2025
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=17694000011047
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = n
pre_case_purpose=1000525
Param Type = c
trn_rcms_caseid=14633000010284
Param Type = c
court_code=18223
Param Type = c
case_no=2023/1338
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=12/11/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 = 4
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 = 17694000011048
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 06/11/2025
pre_case_purpose = 1000507
trn_rcms_caseid = 11521000011650
court_code = 18223
case_no = 2023/895
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000507
next_hear_date = 28/01/2026
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=17694000011048
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = n
pre_case_purpose=1000507
Param Type = c
trn_rcms_caseid=11521000011650
Param Type = c
court_code=18223
Param Type = c
case_no=2023/895
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000507
Param Type = c
next_hear_date=28/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17694000011049
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 04/12/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/1046
court_code = 18223
trn_rcms_caseid = 18898000011044
pre_case_purpose = 18678000000000
pre_hear_date = 06/11/2025
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=17694000011049
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=04/12/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/1046
Param Type = c
court_code=18223
Param Type = c
trn_rcms_caseid=18898000011044
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/11/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 = 5
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 17694000011050
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 22/01/2026
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/1182
court_code = 18223
trn_rcms_caseid = 13041000010282
pre_case_purpose = 18678000000000
pre_hear_date = 06/11/2025
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=17694000011050
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/01/2026 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/1182
Param Type = c
court_code=18223
Param Type = c
trn_rcms_caseid=13041000010282
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 2
RecordId = 17694000011051
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
next_hear_date = 04/12/2025
pre_hear_date = 06/11/2025
court_code = 18223
case_no = 2023/1345
trn_rcms_caseid = 17528000010304
adjourn_remark =
adjourn_type = 0
isadjourn = NO
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=17694000011051
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=04/12/2025 00:00:00
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = c
court_code=18223
Param Type = c
case_no=2023/1345
Param Type = c
trn_rcms_caseid=17528000010304
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
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,pre_case_purpose,new_case_purpose,next_hear_date,pre_hear_date,court_code,case_no,trn_rcms_caseid,adjourn_remark,adjourn_type,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,null,:adjourn_type,:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17694000011052
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trn_rcms_caseid = 17750000011187
pre_hear_date = 06/11/2025
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
court_code = 18223
case_no = 2023/1346
adjourn_remark =
next_hear_date = 04/12/2025
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=17694000011052
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=17750000011187
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=18223
Param Type = c
case_no=2023/1346
Param Type = c
next_hear_date=04/12/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
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,trn_rcms_caseid,pre_hear_date,new_case_purpose,pre_case_purpose,court_code,case_no,adjourn_remark,next_hear_date,isadjourn,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:court_code,:case_no,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17694000011053
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
new_case_purpose = 18678000000000
isadjourn = NO
next_hear_date = 12/11/2025
pre_case_purpose = 18678000000000
case_no = 2023/1347
court_code = 18223
pre_hear_date = 06/11/2025
trn_rcms_caseid = 17978000010671
adjourn_remark =
adjourn_type = 0
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=17694000011053
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=12/11/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2023/1347
Param Type = c
court_code=18223
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = c
trn_rcms_caseid=17978000010671
Param Type = c
adjourn_type=0
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,new_case_purpose,isadjourn,next_hear_date,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 3
RecordId = 17694000011054
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
case_no = 2023/1348
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 18162000012462
pre_hear_date = 06/11/2025
adjourn_remark =
court_code = 18223
adjourn_type = 0
next_hear_date = 12/11/2025
isadjourn = NO
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=17694000011054
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/1348
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=18162000012462
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = c
court_code=18223
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=12/11/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17694000011055
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 22/01/2026
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/1349
court_code = 18223
trn_rcms_caseid = 18400000011326
pre_case_purpose = 18678000000000
pre_hear_date = 06/11/2025
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=17694000011055
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/01/2026 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/1349
Param Type = c
court_code=18223
Param Type = c
trn_rcms_caseid=18400000011326
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17694000011056
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 08/01/2026
isadjourn = NO
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 06/11/2025
case_no = 2023/481
court_code = 18223
trn_rcms_caseid = 11132000009303
adjourn_type = 0
adjourn_remark =
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=17694000011056
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/01/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = c
case_no=2023/481
Param Type = c
court_code=18223
Param Type = c
trn_rcms_caseid=11132000009303
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,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_type,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:adjourn_type,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 17694000011057
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_type = 0
case_no = 2023/482
court_code = 18223
isadjourn = NO
next_hear_date = 08/01/2026
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
pre_hear_date = 06/11/2025
adjourn_remark =
trn_rcms_caseid = 11197000009098
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=17694000011057
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/482
Param Type = c
court_code=18223
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=08/01/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = c
trn_rcms_caseid=11197000009098
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,case_no,court_code,isadjourn,next_hear_date,pre_case_purpose,new_case_purpose,pre_hear_date,adjourn_remark,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,:case_no,:court_code,:isadjourn,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'),null,:trn_rcms_caseid,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17694000011058
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
court_code = 18223
isadjourn = NO
next_hear_date = 04/12/2025
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18678000000000
pre_hear_date = 06/11/2025
trn_rcms_caseid = 14001000010670
case_no = 2023/817
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=17694000011058
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=18223
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=04/12/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = c
trn_rcms_caseid=14001000010670
Param Type = c
case_no=2023/817
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,pre_hear_date,trn_rcms_caseid,case_no,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17694000011059
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
court_code = 18223
pre_case_purpose = 18466000000000
case_no = 2023/378
trn_rcms_caseid = 10143000009634
pre_hear_date = 06/11/2025
new_case_purpose = 18466000000000
adjourn_type = 0
adjourn_remark =
next_hear_date = 14/01/2026
isadjourn = NO
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=17694000011059
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=18223
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
case_no=2023/378
Param Type = c
trn_rcms_caseid=10143000009634
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=14/01/2026 00:00:00
Param Type = c
isadjourn=NO
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,court_code,pre_case_purpose,case_no,trn_rcms_caseid,pre_hear_date,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:pre_case_purpose,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17694000011060
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 = 15220000009535
pre_hear_date = 06/11/2025
court_code = 18223
case_no = 2023/508
pre_case_purpose = 11415000000002
isadjourn = NO
adjourn_type = 0
new_case_purpose = 11415000000002
next_hear_date = 04/12/2025
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=17694000011060
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=15220000009535
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = c
court_code=18223
Param Type = c
case_no=2023/508
Param Type = n
pre_case_purpose=11415000000002
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=11415000000002
Param Type = c
next_hear_date=04/12/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 17694000011061
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 10878000008972
court_code = 18223
case_no = 2024/276
pre_hear_date = 06/11/2025
new_case_purpose = 12555000000002
adjourn_type = 0
pre_case_purpose = 12555000000002
next_hear_date = 20/11/2025
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=17694000011061
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:31
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=10878000008972
Param Type = c
court_code=18223
Param Type = c
case_no=2024/276
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
next_hear_date=20/11/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_remark,isadjourn,trn_rcms_caseid,court_code,case_no,pre_hear_date,new_case_purpose,adjourn_type,pre_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,:isadjourn,:trn_rcms_caseid,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:pre_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 = 8
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 = 17694000011062
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 19320000010348
pre_hear_date = 06/11/2025
court_code = 18223
case_no = 2025/540
next_hear_date = 22/01/2026
isadjourn = NO
pre_case_purpose = 1000492
new_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=17694000011062
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:32
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=19320000010348
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = c
court_code=18223
Param Type = c
case_no=2025/540
Param Type = c
next_hear_date=22/01/2026 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=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
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 = 17694000011063
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 19448000010833
pre_hear_date = 06/11/2025
court_code = 18223
case_no = 2025/541
next_hear_date = 22/01/2026
isadjourn = NO
pre_case_purpose = 1000492
new_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=17694000011063
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:32
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=19448000010833
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = c
court_code=18223
Param Type = c
case_no=2025/541
Param Type = c
next_hear_date=22/01/2026 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=18
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 = 4
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 = 17694000011064
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark =
isadjourn = NO
case_no = 2025/710
trn_rcms_caseid = 15318000011981
pre_case_purpose = 1000492
court_code = 18223
next_hear_date = 31/12/2025
new_case_purpose = 1000492
pre_hear_date = 06/11/2025
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=17694000011064
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:32
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:32
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=2025/710
Param Type = c
trn_rcms_caseid=15318000011981
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=18223
Param Type = c
next_hear_date=31/12/2025 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=06/11/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,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 = 4
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 = 17694000011065
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 15379000012713
case_no = 2025/711
court_code = 18223
pre_hear_date = 06/11/2025
next_hear_date = 31/12/2025
new_case_purpose = 1000492
pre_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=17694000011065
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:32
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:32
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=15379000012713
Param Type = c
case_no=2025/711
Param Type = c
court_code=18223
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = c
next_hear_date=31/12/2025 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
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,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17694000011066
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 22/01/2026
trn_rcms_caseid = 16597000010429
case_no = 2025/714
court_code = 18223
new_case_purpose = 1000507
pre_case_purpose = 1000507
pre_hear_date = 06/11/2025
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=17694000011066
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:32
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=22/01/2026 00:00:00
Param Type = c
trn_rcms_caseid=16597000010429
Param Type = c
case_no=2025/714
Param Type = c
court_code=18223
Param Type = c
new_case_purpose=1000507
Param Type = n
pre_case_purpose=1000507
Param Type = c
pre_hear_date=06/11/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,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 = 3
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 17694000011067
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 15/01/2026
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 14027000011136
court_code = 18223
case_no = 2025/455
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 06/11/2025
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=17694000011067
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:32
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=15/01/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=14027000011136
Param Type = c
court_code=18223
Param Type = c
case_no=2025/455
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17694000011068
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 15/01/2026
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18678000000000
case_no = 2025/456
court_code = 18223
trn_rcms_caseid = 14136000011350
pre_case_purpose = 18678000000000
pre_hear_date = 06/11/2025
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=17694000011068
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:32
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=15/01/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
case_no=2025/456
Param Type = c
court_code=18223
Param Type = c
trn_rcms_caseid=14136000011350
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17694000011069
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 20/11/2025
new_case_purpose = 18678000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2025/7
court_code = 18223
trn_rcms_caseid = 18896000009951
pre_case_purpose = 18678000000000
pre_hear_date = 06/11/2025
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=17694000011069
Param Type = n
trn_rcms_mhearingid=17694000011045
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:32
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=20/11/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2025/7
Param Type = c
court_code=18223
Param Type = c
trn_rcms_caseid=18896000009951
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/11/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 = 3971690447930
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14552000010175 idvalue 0
Mapped case_no Row = 1 value = 2023/1337 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 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 = 18223
trn_rcms_caseregid = 14552000010175
case_no = 2023/1337
prev_hearing_date = 06/11/2025
hearing_date = 12/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 = 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 = 17694000011070
MapName trcmf1
SourceId 17694000011046
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 12/11/2025
case_no = 2023/1337
trn_rcms_caseregid = 14552000010175
court_code = 18223
case_purpose = 1000525
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011070
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011046
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:32
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=12/11/2025 00:00:00
Param Type = c
case_no=2023/1337
Param Type = c
trn_rcms_caseregid=14552000010175
Param Type = c
court_code=18223
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14633000010284 idvalue 0
Mapped case_no Row = 1 value = 2023/1338 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 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 = 18223
trn_rcms_caseregid = 14633000010284
case_no = 2023/1338
prev_hearing_date = 06/11/2025
hearing_date = 12/11/2025
prev_case_purposename = ???? ????
prev_case_purpose =
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 = 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 = 17694000011071
MapName trcmf1
SourceId 17694000011047
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 12/11/2025
case_no = 2023/1338
trn_rcms_caseregid = 14633000010284
court_code = 18223
case_purpose = 1000525
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011071
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011047
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:34
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=12/11/2025 00:00:00
Param Type = c
case_no=2023/1338
Param Type = c
trn_rcms_caseregid=14633000010284
Param Type = c
court_code=18223
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11521000011650 idvalue 0
Mapped case_no Row = 1 value = 2023/895 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000507 idvalue 0
Mapped hearing_date Row = 1 value = 28/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18223
trn_rcms_caseregid = 11521000011650
case_no = 2023/895
prev_hearing_date = 06/11/2025
hearing_date = 28/01/2026
prev_case_purposename = ???? ?????
prev_case_purpose =
prev_case_purposename=???? ?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????
Time elapsed = 4
prev_case_purpose after validation = 1000507
case_purpose = 1000507
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 17694000011072
MapName trcmf1
SourceId 17694000011048
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 = 1000507
hearing_date = 28/01/2026
case_no = 2023/895
trn_rcms_caseregid = 11521000011650
court_code = 18223
case_purpose = 1000507
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011072
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011048
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:36
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000507
Param Type = c
hearing_date=28/01/2026 00:00:00
Param Type = c
case_no=2023/895
Param Type = c
trn_rcms_caseregid=11521000011650
Param Type = c
court_code=18223
Param Type = c
case_purpose=1000507
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18898000011044 idvalue 0
Mapped case_no Row = 1 value = 2023/1046 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 04/12/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 = 18223
trn_rcms_caseregid = 18898000011044
case_no = 2023/1046
prev_hearing_date = 06/11/2025
hearing_date = 04/12/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 = 2
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17694000011073
MapName trcmf1
SourceId 17694000011049
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 04/12/2025
case_no = 2023/1046
trn_rcms_caseregid = 18898000011044
court_code = 18223
case_purpose = 18678000000000
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011073
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011049
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:37
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=04/12/2025 00:00:00
Param Type = c
case_no=2023/1046
Param Type = c
trn_rcms_caseregid=18898000011044
Param Type = c
court_code=18223
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13041000010282 idvalue 0
Mapped case_no Row = 1 value = 2023/1182 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18223
trn_rcms_caseregid = 13041000010282
case_no = 2023/1182
prev_hearing_date = 06/11/2025
hearing_date = 22/01/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 17694000011074
MapName trcmf1
SourceId 17694000011050
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/01/2026
case_no = 2023/1182
trn_rcms_caseregid = 13041000010282
court_code = 18223
case_purpose = 18678000000000
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011074
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011050
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:39
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/01/2026 00:00:00
Param Type = c
case_no=2023/1182
Param Type = c
trn_rcms_caseregid=13041000010282
Param Type = c
court_code=18223
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17528000010304 idvalue 0
Mapped case_no Row = 1 value = 2023/1345 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 04/12/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 = 18223
trn_rcms_caseregid = 17528000010304
case_no = 2023/1345
prev_hearing_date = 06/11/2025
hearing_date = 04/12/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 = 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 = 17694000011075
MapName trcmf1
SourceId 17694000011051
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 = 04/12/2025
case_no = 2023/1345
trn_rcms_caseregid = 17528000010304
court_code = 18223
case_purpose = 18678000000000
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011075
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011051
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:40
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=04/12/2025 00:00:00
Param Type = c
case_no=2023/1345
Param Type = c
trn_rcms_caseregid=17528000010304
Param Type = c
court_code=18223
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17750000011187 idvalue 0
Mapped case_no Row = 1 value = 2023/1346 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 04/12/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 = 18223
trn_rcms_caseregid = 17750000011187
case_no = 2023/1346
prev_hearing_date = 06/11/2025
hearing_date = 04/12/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 = 1
RecordId = 17694000011076
MapName trcmf1
SourceId 17694000011052
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 04/12/2025
case_no = 2023/1346
trn_rcms_caseregid = 17750000011187
court_code = 18223
case_purpose = 18678000000000
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011076
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011052
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:42
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=04/12/2025 00:00:00
Param Type = c
case_no=2023/1346
Param Type = c
trn_rcms_caseregid=17750000011187
Param Type = c
court_code=18223
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17978000010671 idvalue 0
Mapped case_no Row = 1 value = 2023/1347 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 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 = 18223
trn_rcms_caseregid = 17978000010671
case_no = 2023/1347
prev_hearing_date = 06/11/2025
hearing_date = 12/11/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 = 17694000011077
MapName trcmf1
SourceId 17694000011053
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 = 12/11/2025
case_no = 2023/1347
trn_rcms_caseregid = 17978000010671
court_code = 18223
case_purpose = 18678000000000
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011077
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011053
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:44
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=12/11/2025 00:00:00
Param Type = c
case_no=2023/1347
Param Type = c
trn_rcms_caseregid=17978000010671
Param Type = c
court_code=18223
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18162000012462 idvalue 0
Mapped case_no Row = 1 value = 2023/1348 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 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 = 18223
trn_rcms_caseregid = 18162000012462
case_no = 2023/1348
prev_hearing_date = 06/11/2025
hearing_date = 12/11/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 = 2
RecordId = 17694000011078
MapName trcmf1
SourceId 17694000011054
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 = 12/11/2025
case_no = 2023/1348
trn_rcms_caseregid = 18162000012462
court_code = 18223
case_purpose = 18678000000000
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011078
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011054
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:45
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=12/11/2025 00:00:00
Param Type = c
case_no=2023/1348
Param Type = c
trn_rcms_caseregid=18162000012462
Param Type = c
court_code=18223
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18400000011326 idvalue 0
Mapped case_no Row = 1 value = 2023/1349 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18223
trn_rcms_caseregid = 18400000011326
case_no = 2023/1349
prev_hearing_date = 06/11/2025
hearing_date = 22/01/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17694000011079
MapName trcmf1
SourceId 17694000011055
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 = 22/01/2026
case_no = 2023/1349
trn_rcms_caseregid = 18400000011326
court_code = 18223
case_purpose = 18678000000000
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011079
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011055
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:47
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/01/2026 00:00:00
Param Type = c
case_no=2023/1349
Param Type = c
trn_rcms_caseregid=18400000011326
Param Type = c
court_code=18223
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11132000009303 idvalue 0
Mapped case_no Row = 1 value = 2023/481 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18223
trn_rcms_caseregid = 11132000009303
case_no = 2023/481
prev_hearing_date = 06/11/2025
hearing_date = 08/01/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17694000011080
MapName trcmf1
SourceId 17694000011056
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/01/2026
case_no = 2023/481
trn_rcms_caseregid = 11132000009303
court_code = 18223
case_purpose = 18678000000000
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011080
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011056
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:49
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/01/2026 00:00:00
Param Type = c
case_no=2023/481
Param Type = c
trn_rcms_caseregid=11132000009303
Param Type = c
court_code=18223
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11197000009098 idvalue 0
Mapped case_no Row = 1 value = 2023/482 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18223
trn_rcms_caseregid = 11197000009098
case_no = 2023/482
prev_hearing_date = 06/11/2025
hearing_date = 08/01/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17694000011081
MapName trcmf1
SourceId 17694000011057
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/01/2026
case_no = 2023/482
trn_rcms_caseregid = 11197000009098
court_code = 18223
case_purpose = 18678000000000
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011081
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011057
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:51
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/01/2026 00:00:00
Param Type = c
case_no=2023/482
Param Type = c
trn_rcms_caseregid=11197000009098
Param Type = c
court_code=18223
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14001000010670 idvalue 0
Mapped case_no Row = 1 value = 2023/817 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 04/12/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 = 18223
trn_rcms_caseregid = 14001000010670
case_no = 2023/817
prev_hearing_date = 06/11/2025
hearing_date = 04/12/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 = 17694000011082
MapName trcmf1
SourceId 17694000011058
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 = 18678000000000
hearing_date = 04/12/2025
case_no = 2023/817
trn_rcms_caseregid = 14001000010670
court_code = 18223
case_purpose = 18678000000000
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011082
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011058
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:52
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=04/12/2025 00:00:00
Param Type = c
case_no=2023/817
Param Type = c
trn_rcms_caseregid=14001000010670
Param Type = c
court_code=18223
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10143000009634 idvalue 0
Mapped case_no Row = 1 value = 2023/378 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 14/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18223
trn_rcms_caseregid = 10143000009634
case_no = 2023/378
prev_hearing_date = 06/11/2025
hearing_date = 14/01/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purposename=??????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ????
Time elapsed = 3
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17694000011083
MapName trcmf1
SourceId 17694000011059
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 14/01/2026
case_no = 2023/378
trn_rcms_caseregid = 10143000009634
court_code = 18223
case_purpose = 18466000000000
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011083
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011059
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:54
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=14/01/2026 00:00:00
Param Type = c
case_no=2023/378
Param Type = c
trn_rcms_caseregid=10143000009634
Param Type = c
court_code=18223
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15220000009535 idvalue 0
Mapped case_no Row = 1 value = 2023/508 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 11415000000002 idvalue 0
Mapped hearing_date Row = 1 value = 04/12/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 = 18223
trn_rcms_caseregid = 15220000009535
case_no = 2023/508
prev_hearing_date = 06/11/2025
hearing_date = 04/12/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 = 11415000000002
case_purpose = 11415000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 17694000011084
MapName trcmf1
SourceId 17694000011060
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 = 11415000000002
hearing_date = 04/12/2025
case_no = 2023/508
trn_rcms_caseregid = 15220000009535
court_code = 18223
case_purpose = 11415000000002
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011084
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011060
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:55
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=11415000000002
Param Type = c
hearing_date=04/12/2025 00:00:00
Param Type = c
case_no=2023/508
Param Type = c
trn_rcms_caseregid=15220000009535
Param Type = c
court_code=18223
Param Type = c
case_purpose=11415000000002
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10878000008972 idvalue 0
Mapped case_no Row = 1 value = 2024/276 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 20/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 = 18223
trn_rcms_caseregid = 10878000008972
case_no = 2024/276
prev_hearing_date = 06/11/2025
hearing_date = 20/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 = 5
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 17694000011085
MapName trcmf1
SourceId 17694000011061
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 20/11/2025
case_no = 2024/276
trn_rcms_caseregid = 10878000008972
court_code = 18223
case_purpose = 12555000000002
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011085
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011061
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:57
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=20/11/2025 00:00:00
Param Type = c
case_no=2024/276
Param Type = c
trn_rcms_caseregid=10878000008972
Param Type = c
court_code=18223
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19320000010348 idvalue 0
Mapped case_no Row = 1 value = 2025/540 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 22/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18223
trn_rcms_caseregid = 19320000010348
case_no = 2025/540
prev_hearing_date = 06/11/2025
hearing_date = 22/01/2026
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purposename=?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????
Time elapsed = 3
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 17694000011086
MapName trcmf1
SourceId 17694000011062
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 22/01/2026
case_no = 2025/540
trn_rcms_caseregid = 19320000010348
court_code = 18223
case_purpose = 1000492
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011086
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011062
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:20:59
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:20: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=1000492
Param Type = c
hearing_date=22/01/2026 00:00:00
Param Type = c
case_no=2025/540
Param Type = c
trn_rcms_caseregid=19320000010348
Param Type = c
court_code=18223
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19448000010833 idvalue 0
Mapped case_no Row = 1 value = 2025/541 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 22/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18223
trn_rcms_caseregid = 19448000010833
case_no = 2025/541
prev_hearing_date = 06/11/2025
hearing_date = 22/01/2026
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 17694000011087
MapName trcmf1
SourceId 17694000011063
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 22/01/2026
case_no = 2025/541
trn_rcms_caseregid = 19448000010833
court_code = 18223
case_purpose = 1000492
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011087
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011063
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:21:01
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:21:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=22/01/2026 00:00:00
Param Type = c
case_no=2025/541
Param Type = c
trn_rcms_caseregid=19448000010833
Param Type = c
court_code=18223
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15318000011981 idvalue 0
Mapped case_no Row = 1 value = 2025/710 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 31/12/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 = 18223
trn_rcms_caseregid = 15318000011981
case_no = 2025/710
prev_hearing_date = 06/11/2025
hearing_date = 31/12/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 = 17694000011088
MapName trcmf1
SourceId 17694000011064
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 31/12/2025
case_no = 2025/710
trn_rcms_caseregid = 15318000011981
court_code = 18223
case_purpose = 1000492
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011088
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011064
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:21:02
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:21: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=1000492
Param Type = c
hearing_date=31/12/2025 00:00:00
Param Type = c
case_no=2025/710
Param Type = c
trn_rcms_caseregid=15318000011981
Param Type = c
court_code=18223
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15379000012713 idvalue 0
Mapped case_no Row = 1 value = 2025/711 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 31/12/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 = 18223
trn_rcms_caseregid = 15379000012713
case_no = 2025/711
prev_hearing_date = 06/11/2025
hearing_date = 31/12/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 = 3
RecordId = 17694000011089
MapName trcmf1
SourceId 17694000011065
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 = 31/12/2025
case_no = 2025/711
trn_rcms_caseregid = 15379000012713
court_code = 18223
case_purpose = 1000492
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011089
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011065
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:21:04
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:21: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=31/12/2025 00:00:00
Param Type = c
case_no=2025/711
Param Type = c
trn_rcms_caseregid=15379000012713
Param Type = c
court_code=18223
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=06/11/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 = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16597000010429 idvalue 0
Mapped case_no Row = 1 value = 2025/714 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000507 idvalue 0
Mapped hearing_date Row = 1 value = 22/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18223
trn_rcms_caseregid = 16597000010429
case_no = 2025/714
prev_hearing_date = 06/11/2025
hearing_date = 22/01/2026
prev_case_purposename = ???? ?????
prev_case_purpose =
prev_case_purposename=???? ?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????
Time elapsed = 4
prev_case_purpose after validation = 1000507
case_purpose = 1000507
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 17694000011090
MapName trcmf1
SourceId 17694000011066
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 = 1000507
hearing_date = 22/01/2026
case_no = 2025/714
trn_rcms_caseregid = 16597000010429
court_code = 18223
case_purpose = 1000507
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011090
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011066
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:21:06
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:21:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000507
Param Type = c
hearing_date=22/01/2026 00:00:00
Param Type = c
case_no=2025/714
Param Type = c
trn_rcms_caseregid=16597000010429
Param Type = c
court_code=18223
Param Type = c
case_purpose=1000507
Param Type = c
prev_hearing_date=06/11/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 22
>>Mapping
Mapped court_code Row = 1 value = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14027000011136 idvalue 0
Mapped case_no Row = 1 value = 2025/455 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 15/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18223
trn_rcms_caseregid = 14027000011136
case_no = 2025/455
prev_hearing_date = 06/11/2025
hearing_date = 15/01/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 6
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 17694000011091
MapName trcmf1
SourceId 17694000011067
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 = 15/01/2026
case_no = 2025/455
trn_rcms_caseregid = 14027000011136
court_code = 18223
case_purpose = 18678000000000
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011091
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011067
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:21:08
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:21: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=18678000000000
Param Type = c
hearing_date=15/01/2026 00:00:00
Param Type = c
case_no=2025/455
Param Type = c
trn_rcms_caseregid=14027000011136
Param Type = c
court_code=18223
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/11/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 23
>>Mapping
Mapped court_code Row = 1 value = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14136000011350 idvalue 0
Mapped case_no Row = 1 value = 2025/456 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 15/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18223
trn_rcms_caseregid = 14136000011350
case_no = 2025/456
prev_hearing_date = 06/11/2025
hearing_date = 15/01/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17694000011092
MapName trcmf1
SourceId 17694000011068
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 = 18678000000000
hearing_date = 15/01/2026
case_no = 2025/456
trn_rcms_caseregid = 14136000011350
court_code = 18223
case_purpose = 18678000000000
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011092
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011068
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:21:09
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:21:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=15/01/2026 00:00:00
Param Type = c
case_no=2025/456
Param Type = c
trn_rcms_caseregid=14136000011350
Param Type = c
court_code=18223
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/11/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 24
>>Mapping
Mapped court_code Row = 1 value = 18223 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18896000009951 idvalue 0
Mapped case_no Row = 1 value = 2025/7 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/11/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 = 20/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 = 18223
trn_rcms_caseregid = 18896000009951
case_no = 2025/7
prev_hearing_date = 06/11/2025
hearing_date = 20/11/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17694000011093
MapName trcmf1
SourceId 17694000011069
Select sysdate as sdt from dual
Time elapsed = 5
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 = 20/11/2025
case_no = 2025/7
trn_rcms_caseregid = 18896000009951
court_code = 18223
case_purpose = 18678000000000
prev_hearing_date = 06/11/2025
Posting record
Param Type = n
trn_rcms_case_histid=17694000011093
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17694000011069
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Tapukada_PRO
Param Type = c
createdon=07/11/2025 15:21:11
Param Type = c
username=SDO_Tapukada_PRO
Param Type = c
modifiedon=07/11/2025 15:21:11
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=20/11/2025 00:00:00
Param Type = c
case_no=2025/7
Param Type = c
trn_rcms_caseregid=18896000009951
Param Type = c
court_code=18223
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/11/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 = 3971690488509
Time elapsed for MD Map = 3971690488510
Time elapsed for Save History = 3971690488510
Time elapsed for Save Attachment = 3971690488510
Time elapsed for After Save WF Exec = 3971690488513
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"17694000011045"}]}
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_Tapukada_PRO
Param Type = c
calledon=07/11/2025 15:20:46
Param Type = c
callfinished=07/11/2025 15:21:28
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=41858
Param Type = n
dbtimetaken=40939
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