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_Chattargarh_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_Chattargarh_PRO
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Chattargarh_PRO
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ????? ???????,????????,???????
Result = ????? ???????,????????,???????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=SDO_Chattargarh_PRO
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Chattargarh_PRO
Time elapsed = 2
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_Chattargarh_PRO
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Chattargarh_PRO
Time elapsed = 2
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 12118000000069
Result = 12118000000069
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_Chattargarh_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1806660009230
Result = 1806660009230
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_Chattargarh_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_Chattargarh_PRO
Result = SDO_Chattargarh_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_Chattargarh_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10082
Result = 10082
Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 2
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Chattargarh_PRO
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Chattargarh_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Bikaner
Result = Bikaner
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Chattargarh_PRO
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Chattargarh_PRO
Time elapsed = 2
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=1806660009230
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1806660009230
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=SDO_Chattargarh_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10823000000000
Result = 10823000000000
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=SDO_Chattargarh_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_Chattargarh_PRO
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_admin
Result = court_admin
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 2
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=SDO_Chattargarh_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_Chattargarh_PRO
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 11
Result = 11
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_admin') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 3
select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 3
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_admin,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 2
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : trcmf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 2
Step4
tstructs\stm size:2075
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Evaluating date()
Result =
Evaluating iif((next_hear_date>Validating trcmf
>>Frame No 1
courtcode = 10082
hearing_date = 19/01/2026
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 1
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 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 = 12556000012674
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
hearing_date = 19/01/2026
courtcode = 10082
Posting record
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:39
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=19/01/2026 00:00:00
Param Type = c
courtcode=10082
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 = 1
RecordId = 12556000012675
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_case_purpose = 1000525
case_no = 2017/00084
court_code = 10082
pre_hear_date = 19/01/2026
trn_rcms_caseid = 15282000001628
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000525
next_hear_date = 16/02/2026
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=12556000012675
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:39
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000525
Param Type = c
case_no=2017/00084
Param Type = c
court_code=10082
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
trn_rcms_caseid=15282000001628
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012676
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 16/02/2026
case_no = 2021/37
court_code = 10082
trn_rcms_caseid = 14254000005743
pre_case_purpose = 18678000000000
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=12556000012676
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:39
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
case_no=2021/37
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=14254000005743
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12556000012677
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 19/01/2026
pre_case_purpose = 1000525
trn_rcms_caseid = 14271000005891
court_code = 10082
case_no = 2021/38
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000525
next_hear_date = 16/02/2026
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=12556000012677
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:39
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
pre_case_purpose=1000525
Param Type = c
trn_rcms_caseid=14271000005891
Param Type = c
court_code=10082
Param Type = c
case_no=2021/38
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=16/02/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 = 3
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012678
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 16/02/2026
new_case_purpose = 18466000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2021/59
court_code = 10082
trn_rcms_caseid = 17894000007014
pre_case_purpose = 18466000000000
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=12556000012678
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:39
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/59
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=17894000007014
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012679
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 16/02/2026
new_case_purpose = 1000525
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2022/60
court_code = 10082
trn_rcms_caseid = 14491000006717
pre_case_purpose = 1000525
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=12556000012679
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:39
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/60
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=14491000006717
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12556000012680
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 16/02/2026
new_case_purpose = 1000490
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2022/125
court_code = 10082
trn_rcms_caseid = 18257000007670
pre_case_purpose = 1000490
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=12556000012680
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:39
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
new_case_purpose=1000490
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/125
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=18257000007670
Param Type = n
pre_case_purpose=1000490
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12556000012681
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 16/02/2026
new_case_purpose = 18466000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/101
court_code = 10082
trn_rcms_caseid = 13594000007529
pre_case_purpose = 18466000000000
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=12556000012681
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/101
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=13594000007529
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012682
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 16/02/2026
new_case_purpose = 18466000000000
adjourn_type = 0
isadjourn = NO
adjourn_remark =
case_no = 2023/88
court_code = 10082
trn_rcms_caseid = 13440000008449
pre_case_purpose = 18466000000000
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=12556000012682
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2023/88
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=13440000008449
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_type,isadjourn,adjourn_remark,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:isadjourn,null,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012683
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 19/01/2026
trn_rcms_caseid = 15212000008629
court_code = 10082
case_no = 2023/76
isadjourn = NO
adjourn_type = 0
adjourn_remark =
pre_case_purpose = 18473000000000
new_case_purpose = 18473000000000
next_hear_date = 16/02/2026
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=12556000012683
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
trn_rcms_caseid=15212000008629
Param Type = c
court_code=10082
Param Type = c
case_no=2023/76
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_type,adjourn_remark,pre_case_purpose,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:court_code,:case_no,:isadjourn,:adjourn_type,null,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 12556000012684
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 16/02/2026
new_case_purpose = 1000525
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/180
court_code = 10082
trn_rcms_caseid = 18076000008822
pre_case_purpose = 1000525
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=12556000012684
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/180
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=18076000008822
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12556000012685
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
new_case_purpose = 1000525
adjourn_remark =
next_hear_date = 16/02/2026
adjourn_type = 0
isadjourn = NO
pre_case_purpose = 1000525
case_no = 2024/181
court_code = 10082
trn_rcms_caseid = 18129000009608
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=12556000012685
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=1000525
Param Type = c
case_no=2024/181
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=18129000009608
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,adjourn_remark,next_hear_date,adjourn_type,isadjourn,pre_case_purpose,case_no,court_code,trn_rcms_caseid,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,:pre_case_purpose,:case_no,:court_code,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012686
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 16/02/2026
isadjourn = NO
new_case_purpose = 18466000000000
case_no = 2024/123
pre_case_purpose = 18466000000000
adjourn_remark =
pre_hear_date = 19/01/2026
trn_rcms_caseid = 12811000009358
adjourn_type = 0
court_code = 10082
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=12556000012686
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18466000000000
Param Type = c
case_no=2024/123
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
trn_rcms_caseid=12811000009358
Param Type = c
adjourn_type=0
Param Type = c
court_code=10082
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,new_case_purpose,case_no,pre_case_purpose,adjourn_remark,pre_hear_date,trn_rcms_caseid,adjourn_type,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:case_no,:pre_case_purpose,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:adjourn_type,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12556000012687
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 16/02/2026
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
adjourn_type = 0
case_no = 2025/136
court_code = 10082
trn_rcms_caseid = 13952000009570
adjourn_remark =
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=12556000012687
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
case_no=2025/136
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=13952000009570
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,adjourn_type,case_no,court_code,trn_rcms_caseid,adjourn_remark,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012688
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 19/01/2026
pre_case_purpose = 18678000000000
trn_rcms_caseid = 15526000010320
court_code = 10082
case_no = 2025/169
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 16/02/2026
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=12556000012688
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=15526000010320
Param Type = c
court_code=10082
Param Type = c
case_no=2025/169
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=14
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012689
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 19/01/2026
pre_case_purpose = 18678000000000
trn_rcms_caseid = 15552000011126
court_code = 10082
case_no = 2025/170
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 16/02/2026
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=12556000012689
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=15552000011126
Param Type = c
court_code=10082
Param Type = c
case_no=2025/170
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12556000012690
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 16/02/2026
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2025/18
court_code = 10082
trn_rcms_caseid = 14873000009155
pre_case_purpose = 18678000000000
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=12556000012690
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/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=2025/18
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=14873000009155
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12556000012691
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 16/02/2026
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2025/180
court_code = 10082
trn_rcms_caseid = 17181000010163
pre_case_purpose = 18678000000000
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=12556000012691
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/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=2025/180
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=17181000010163
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12556000012692
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trn_rcms_caseid = 15553000010718
pre_hear_date = 19/01/2026
case_no = 2025/202
adjourn_remark =
court_code = 10082
pre_case_purpose = 18678000000000
next_hear_date = 02/02/2026
isadjourn = NO
new_case_purpose = 18678000000000
adjourn_type = 0
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=12556000012692
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=15553000010718
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
case_no=2025/202
Param Type = c
court_code=10082
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
next_hear_date=02/02/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,pre_hear_date,case_no,adjourn_remark,court_code,pre_case_purpose,next_hear_date,isadjourn,new_case_purpose,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,null,:court_code,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 12556000012693
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
court_code = 10082
case_no = 2025/305
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16766000011040
pre_hear_date = 19/01/2026
adjourn_remark =
next_hear_date = 30/01/2026
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=12556000012693
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10082
Param Type = c
case_no=2025/305
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16766000011040
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
next_hear_date=30/01/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,next_hear_date,isadjourn,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12556000012694
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
new_case_purpose = 18678000000000
isadjourn = NO
next_hear_date = 16/02/2026
pre_case_purpose = 18678000000000
case_no = 2025/311
court_code = 10082
pre_hear_date = 19/01/2026
trn_rcms_caseid = 16718000011056
adjourn_remark =
adjourn_type = 0
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=12556000012694
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
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=16/02/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2025/311
Param Type = c
court_code=10082
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
trn_rcms_caseid=16718000011056
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,isadjourn,next_hear_date,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012695
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
case_no = 2025/312
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16751000011206
pre_hear_date = 19/01/2026
adjourn_remark =
court_code = 10082
adjourn_type = 0
next_hear_date = 16/02/2026
isadjourn = NO
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=12556000012695
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2025/312
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16751000011206
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
court_code=10082
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 12556000012696
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 16/02/2026
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2025/98
court_code = 10082
trn_rcms_caseid = 11598000011727
pre_case_purpose = 18678000000000
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=12556000012696
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/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=2025/98
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=11598000011727
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
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 = 12556000012697
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 16/02/2026
isadjourn = NO
new_case_purpose = 1000525
pre_case_purpose = 1000525
pre_hear_date = 19/01/2026
case_no = 2025/115
court_code = 10082
trn_rcms_caseid = 16037000009765
adjourn_type = 0
adjourn_remark =
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=12556000012697
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000525
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
case_no=2025/115
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=16037000009765
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_type,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:adjourn_type,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 1
RecordId = 12556000012698
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 19/01/2026
pre_case_purpose = 1000525
trn_rcms_caseid = 17207000010922
court_code = 10082
case_no = 2025/120
isadjourn = NO
adjourn_type = 0
next_hear_date = 30/01/2026
adjourn_remark =
new_case_purpose = 1000525
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=12556000012698
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
pre_case_purpose=1000525
Param Type = c
trn_rcms_caseid=17207000010922
Param Type = c
court_code=10082
Param Type = c
case_no=2025/120
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=30/01/2026 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_type,next_hear_date,adjourn_remark,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012699
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
court_code = 10082
isadjourn = NO
next_hear_date = 16/02/2026
adjourn_remark =
adjourn_type = 0
new_case_purpose = 1000525
pre_hear_date = 19/01/2026
trn_rcms_caseid = 13911000010224
case_no = 2025/135
pre_case_purpose = 1000525
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=12556000012699
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10082
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000525
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
trn_rcms_caseid=13911000010224
Param Type = c
case_no=2025/135
Param Type = n
pre_case_purpose=1000525
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,pre_hear_date,trn_rcms_caseid,case_no,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012700
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
court_code = 10082
pre_case_purpose = 1000525
case_no = 2025/165
trn_rcms_caseid = 19842000010823
pre_hear_date = 19/01/2026
new_case_purpose = 1000525
adjourn_type = 0
adjourn_remark =
next_hear_date = 16/02/2026
isadjourn = NO
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=12556000012700
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10082
Param Type = n
pre_case_purpose=1000525
Param Type = c
case_no=2025/165
Param Type = c
trn_rcms_caseid=19842000010823
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,pre_case_purpose,case_no,trn_rcms_caseid,pre_hear_date,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:pre_case_purpose,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012701
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark =
trn_rcms_caseid = 12085000011459
pre_hear_date = 19/01/2026
court_code = 10082
case_no = 2025/273
pre_case_purpose = 1000525
isadjourn = NO
adjourn_type = 0
new_case_purpose = 1000525
next_hear_date = 16/02/2026
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=12556000012701
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=12085000011459
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
court_code=10082
Param Type = c
case_no=2025/273
Param Type = n
pre_case_purpose=1000525
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=27
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 28 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12556000012702
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 13712000011184
pre_case_purpose = 1000525
pre_hear_date = 19/01/2026
case_no = 2025/274
new_case_purpose = 1000525
adjourn_type = 0
court_code = 10082
next_hear_date = 16/02/2026
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=12556000012702
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=13712000011184
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
case_no=2025/274
Param Type = c
new_case_purpose=1000525
Param Type = c
adjourn_type=0
Param Type = c
court_code=10082
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,isadjourn,trn_rcms_caseid,pre_case_purpose,pre_hear_date,case_no,new_case_purpose,adjourn_type,court_code,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:isadjourn,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:new_case_purpose,:adjourn_type,:court_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012703
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 12543000011696
pre_hear_date = 19/01/2026
court_code = 10082
case_no = 2025/48
next_hear_date = 16/02/2026
isadjourn = NO
pre_case_purpose = 1000525
new_case_purpose = 1000525
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=12556000012703
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=12543000011696
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
court_code=10082
Param Type = c
case_no=2025/48
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=1000525
Param Type = c
new_case_purpose=1000525
Param Type = n
trn_rcms_hearingrow=29
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 30 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012704
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_type = 0
adjourn_remark =
pre_hear_date = 19/01/2026
trn_rcms_caseid = 15956000009372
new_case_purpose = 1000490
pre_case_purpose = 1000490
next_hear_date = 16/02/2026
isadjourn = NO
case_no = 2025/16
court_code = 10082
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=12556000012704
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
trn_rcms_caseid=15956000009372
Param Type = c
new_case_purpose=1000490
Param Type = n
pre_case_purpose=1000490
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2025/16
Param Type = c
court_code=10082
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,pre_hear_date,trn_rcms_caseid,new_case_purpose,pre_case_purpose,next_hear_date,isadjourn,case_no,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 31 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012705
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_type = 0
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 11563000011081
case_no = 2025/71
court_code = 10082
pre_hear_date = 19/01/2026
next_hear_date = 28/01/2026
new_case_purpose = 1000490
pre_case_purpose = 1000490
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=12556000012705
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=11563000011081
Param Type = c
case_no=2025/71
Param Type = c
court_code=10082
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
next_hear_date=28/01/2026 00:00:00
Param Type = c
new_case_purpose=1000490
Param Type = n
pre_case_purpose=1000490
Param Type = n
trn_rcms_hearingrow=31
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 32 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012706
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
isadjourn = NO
adjourn_type = 0
adjourn_remark =
case_no = 2025/138
court_code = 10082
pre_hear_date = 19/01/2026
trn_rcms_caseid = 14154000010602
next_hear_date = 25/02/2026
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=12556000012706
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2025/138
Param Type = c
court_code=10082
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = c
trn_rcms_caseid=14154000010602
Param Type = c
next_hear_date=25/02/2026 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = n
trn_rcms_hearingrow=32
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,case_no,court_code,pre_hear_date,trn_rcms_caseid,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 33 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012707
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 16/02/2026
trn_rcms_caseid = 14281000011789
case_no = 2025/140
court_code = 10082
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 33
Posting record
Param Type = n
trn_rcms_hearingid=12556000012707
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
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=16/02/2026 00:00:00
Param Type = c
trn_rcms_caseid=14281000011789
Param Type = c
case_no=2025/140
Param Type = c
court_code=10082
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=33
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 2
Adding new record to store data from Frame 2, Row 34 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12556000012708
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
next_hear_date = 16/02/2026
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 14764000009127
court_code = 10082
case_no = 2025/17
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 34
Posting record
Param Type = n
trn_rcms_hearingid=12556000012708
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=14764000009127
Param Type = c
court_code=10082
Param Type = c
case_no=2025/17
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=34
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,court_code,case_no,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:court_code,:case_no,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 35 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012709
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
next_hear_date = 16/02/2026
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18466000000000
case_no = 2025/63
court_code = 10082
trn_rcms_caseid = 12750000010375
pre_case_purpose = 18466000000000
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 35
Posting record
Param Type = n
trn_rcms_hearingid=12556000012709
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:40
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18466000000000
Param Type = c
case_no=2025/63
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=12750000010375
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=35
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 36 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012710
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
next_hear_date = 16/02/2026
new_case_purpose = 18466000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2025/83
court_code = 10082
trn_rcms_caseid = 13370000009892
pre_case_purpose = 18466000000000
pre_hear_date = 19/01/2026
TRN_RCMS_HEARINGrow = 36
Posting record
Param Type = n
trn_rcms_hearingid=12556000012710
Param Type = n
trn_rcms_mhearingid=12556000012674
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:41
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/02/2026 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2025/83
Param Type = c
court_code=10082
Param Type = c
trn_rcms_caseid=13370000009892
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=19/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=36
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_remark,adjourn_type,isadjourn,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,null,:adjourn_type,:isadjourn,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
Time elapsed for insert/update = 3978416620748
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15282000001628 idvalue 0
Mapped case_no Row = 1 value = 2017/00084 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 15282000001628
case_no = 2017/00084
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purposename=???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????
Time elapsed = 2
prev_case_purpose after validation = 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 = 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 = 12556000012711
MapName trcmf1
SourceId 12556000012675
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 16/02/2026
case_no = 2017/00084
trn_rcms_caseregid = 15282000001628
court_code = 10082
case_purpose = 1000525
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012711
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012675
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:41
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2017/00084
Param Type = c
trn_rcms_caseregid=15282000001628
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 2
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14254000005743 idvalue 0
Mapped case_no Row = 1 value = 2021/37 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 14254000005743
case_no = 2021/37
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 3
prev_case_purpose after validation = 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 = 12556000012712
MapName trcmf1
SourceId 12556000012676
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 16/02/2026
case_no = 2021/37
trn_rcms_caseregid = 14254000005743
court_code = 10082
case_purpose = 18678000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012712
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012676
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:42
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=16/02/2026 00:00:00
Param Type = c
case_no=2021/37
Param Type = c
trn_rcms_caseregid=14254000005743
Param Type = c
court_code=10082
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 3
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14271000005891 idvalue 0
Mapped case_no Row = 1 value = 2021/38 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 14271000005891
case_no = 2021/38
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purposename=???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????
Time elapsed = 3
prev_case_purpose after validation = 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 = 12556000012713
MapName trcmf1
SourceId 12556000012677
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 16/02/2026
case_no = 2021/38
trn_rcms_caseregid = 14271000005891
court_code = 10082
case_purpose = 1000525
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012713
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012677
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:42
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=1000525
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2021/38
Param Type = c
trn_rcms_caseregid=14271000005891
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 4
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17894000007014 idvalue 0
Mapped case_no Row = 1 value = 2021/59 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 17894000007014
case_no = 2021/59
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purposename=??????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ????
Time elapsed = 3
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012714
MapName trcmf1
SourceId 12556000012678
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 = 18466000000000
hearing_date = 16/02/2026
case_no = 2021/59
trn_rcms_caseregid = 17894000007014
court_code = 10082
case_purpose = 18466000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012714
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012678
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:43
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2021/59
Param Type = c
trn_rcms_caseregid=17894000007014
Param Type = c
court_code=10082
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 5
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14491000006717 idvalue 0
Mapped case_no Row = 1 value = 2022/60 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 14491000006717
case_no = 2022/60
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purposename=???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????
Time elapsed = 2
prev_case_purpose after validation = 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 = 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 = 12556000012715
MapName trcmf1
SourceId 12556000012679
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 16/02/2026
case_no = 2022/60
trn_rcms_caseregid = 14491000006717
court_code = 10082
case_purpose = 1000525
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012715
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012679
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:44
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=1000525
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2022/60
Param Type = c
trn_rcms_caseregid=14491000006717
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 6
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18257000007670 idvalue 0
Mapped case_no Row = 1 value = 2022/125 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? / ??????? idvalue 0
Mapped case_purpose Row = 1 value = 1000490 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 18257000007670
case_no = 2022/125
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ???????? / ???????
prev_case_purpose =
prev_case_purposename=???????? / ???????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???????? / ???????
Time elapsed = 3
prev_case_purpose after validation = 1000490
case_purpose = 1000490
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012716
MapName trcmf1
SourceId 12556000012680
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000490
hearing_date = 16/02/2026
case_no = 2022/125
trn_rcms_caseregid = 18257000007670
court_code = 10082
case_purpose = 1000490
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012716
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012680
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:44
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=1000490
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2022/125
Param Type = c
trn_rcms_caseregid=18257000007670
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000490
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 7
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13594000007529 idvalue 0
Mapped case_no Row = 1 value = 2023/101 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 13594000007529
case_no = 2023/101
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purposename=??????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ????
Time elapsed = 2
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012717
MapName trcmf1
SourceId 12556000012681
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 = 18466000000000
hearing_date = 16/02/2026
case_no = 2023/101
trn_rcms_caseregid = 13594000007529
court_code = 10082
case_purpose = 18466000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012717
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012681
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:45
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=18466000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2023/101
Param Type = c
trn_rcms_caseregid=13594000007529
Param Type = c
court_code=10082
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 8
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13440000008449 idvalue 0
Mapped case_no Row = 1 value = 2023/88 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 13440000008449
case_no = 2023/88
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012718
MapName trcmf1
SourceId 12556000012682
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 = 18466000000000
hearing_date = 16/02/2026
case_no = 2023/88
trn_rcms_caseregid = 13440000008449
court_code = 10082
case_purpose = 18466000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012718
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012682
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:45
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=18466000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2023/88
Param Type = c
trn_rcms_caseregid=13440000008449
Param Type = c
court_code=10082
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 9
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15212000008629 idvalue 0
Mapped case_no Row = 1 value = 2023/76 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 15212000008629
case_no = 2023/76
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ???
prev_case_purpose =
prev_case_purposename=???
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???
Time elapsed = 2
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012719
MapName trcmf1
SourceId 12556000012683
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 16/02/2026
case_no = 2023/76
trn_rcms_caseregid = 15212000008629
court_code = 10082
case_purpose = 18473000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012719
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012683
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:46
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2023/76
Param Type = c
trn_rcms_caseregid=15212000008629
Param Type = c
court_code=10082
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 10
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18076000008822 idvalue 0
Mapped case_no Row = 1 value = 2024/180 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 18076000008822
case_no = 2024/180
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purposename=???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????
Time elapsed = 3
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12556000012720
MapName trcmf1
SourceId 12556000012684
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 16/02/2026
case_no = 2024/180
trn_rcms_caseregid = 18076000008822
court_code = 10082
case_purpose = 1000525
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012720
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012684
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:47
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=1000525
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2024/180
Param Type = c
trn_rcms_caseregid=18076000008822
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 11
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18129000009608 idvalue 0
Mapped case_no Row = 1 value = 2024/181 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 18129000009608
case_no = 2024/181
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
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 = 1
RecordId = 12556000012721
MapName trcmf1
SourceId 12556000012685
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 16/02/2026
case_no = 2024/181
trn_rcms_caseregid = 18129000009608
court_code = 10082
case_purpose = 1000525
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012721
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012685
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:47
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=1000525
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2024/181
Param Type = c
trn_rcms_caseregid=18129000009608
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 12
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12811000009358 idvalue 0
Mapped case_no Row = 1 value = 2024/123 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 12811000009358
case_no = 2024/123
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purposename=??????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ????
Time elapsed = 4
prev_case_purpose after validation = 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 = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012722
MapName trcmf1
SourceId 12556000012686
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 = 18466000000000
hearing_date = 16/02/2026
case_no = 2024/123
trn_rcms_caseregid = 12811000009358
court_code = 10082
case_purpose = 18466000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012722
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012686
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:48
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2024/123
Param Type = c
trn_rcms_caseregid=12811000009358
Param Type = c
court_code=10082
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 13
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13952000009570 idvalue 0
Mapped case_no Row = 1 value = 2025/136 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 13952000009570
case_no = 2025/136
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 3
prev_case_purpose after validation = 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 = 12556000012723
MapName trcmf1
SourceId 12556000012687
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 16/02/2026
case_no = 2025/136
trn_rcms_caseregid = 13952000009570
court_code = 10082
case_purpose = 18678000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012723
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012687
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:48
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/136
Param Type = c
trn_rcms_caseregid=13952000009570
Param Type = c
court_code=10082
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 14
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15526000010320 idvalue 0
Mapped case_no Row = 1 value = 2025/169 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 15526000010320
case_no = 2025/169
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 12556000012724
MapName trcmf1
SourceId 12556000012688
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 16/02/2026
case_no = 2025/169
trn_rcms_caseregid = 15526000010320
court_code = 10082
case_purpose = 18678000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012724
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012688
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:49
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=16/02/2026 00:00:00
Param Type = c
case_no=2025/169
Param Type = c
trn_rcms_caseregid=15526000010320
Param Type = c
court_code=10082
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 15
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15552000011126 idvalue 0
Mapped case_no Row = 1 value = 2025/170 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 15552000011126
case_no = 2025/170
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012725
MapName trcmf1
SourceId 12556000012689
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 16/02/2026
case_no = 2025/170
trn_rcms_caseregid = 15552000011126
court_code = 10082
case_purpose = 18678000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012725
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012689
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:50
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/170
Param Type = c
trn_rcms_caseregid=15552000011126
Param Type = c
court_code=10082
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 16
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14873000009155 idvalue 0
Mapped case_no Row = 1 value = 2025/18 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 14873000009155
case_no = 2025/18
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 12556000012726
MapName trcmf1
SourceId 12556000012690
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 16/02/2026
case_no = 2025/18
trn_rcms_caseregid = 14873000009155
court_code = 10082
case_purpose = 18678000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012726
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012690
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:50
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/18
Param Type = c
trn_rcms_caseregid=14873000009155
Param Type = c
court_code=10082
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 17
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17181000010163 idvalue 0
Mapped case_no Row = 1 value = 2025/180 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 17181000010163
case_no = 2025/180
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012727
MapName trcmf1
SourceId 12556000012691
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 16/02/2026
case_no = 2025/180
trn_rcms_caseregid = 17181000010163
court_code = 10082
case_purpose = 18678000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012727
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012691
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:51
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=16/02/2026 00:00:00
Param Type = c
case_no=2025/180
Param Type = c
trn_rcms_caseregid=17181000010163
Param Type = c
court_code=10082
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 18
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15553000010718 idvalue 0
Mapped case_no Row = 1 value = 2025/202 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 02/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 15553000010718
case_no = 2025/202
prev_hearing_date = 19/01/2026
hearing_date = 02/02/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12556000012728
MapName trcmf1
SourceId 12556000012692
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 = 02/02/2026
case_no = 2025/202
trn_rcms_caseregid = 15553000010718
court_code = 10082
case_purpose = 18678000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012728
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012692
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:52
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=02/02/2026 00:00:00
Param Type = c
case_no=2025/202
Param Type = c
trn_rcms_caseregid=15553000010718
Param Type = c
court_code=10082
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 19
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16766000011040 idvalue 0
Mapped case_no Row = 1 value = 2025/305 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/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 = 10082
trn_rcms_caseregid = 16766000011040
case_no = 2025/305
prev_hearing_date = 19/01/2026
hearing_date = 30/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 = 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 = 12556000012729
MapName trcmf1
SourceId 12556000012693
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 30/01/2026
case_no = 2025/305
trn_rcms_caseregid = 16766000011040
court_code = 10082
case_purpose = 18678000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012729
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012693
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:52
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=30/01/2026 00:00:00
Param Type = c
case_no=2025/305
Param Type = c
trn_rcms_caseregid=16766000011040
Param Type = c
court_code=10082
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 20
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16718000011056 idvalue 0
Mapped case_no Row = 1 value = 2025/311 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 16718000011056
case_no = 2025/311
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012730
MapName trcmf1
SourceId 12556000012694
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 = 16/02/2026
case_no = 2025/311
trn_rcms_caseregid = 16718000011056
court_code = 10082
case_purpose = 18678000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012730
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012694
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:53
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/311
Param Type = c
trn_rcms_caseregid=16718000011056
Param Type = c
court_code=10082
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 21
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16751000011206 idvalue 0
Mapped case_no Row = 1 value = 2025/312 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 16751000011206
case_no = 2025/312
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012731
MapName trcmf1
SourceId 12556000012695
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 = 16/02/2026
case_no = 2025/312
trn_rcms_caseregid = 16751000011206
court_code = 10082
case_purpose = 18678000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012731
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012695
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:53
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/312
Param Type = c
trn_rcms_caseregid=16751000011206
Param Type = c
court_code=10082
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 22
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11598000011727 idvalue 0
Mapped case_no Row = 1 value = 2025/98 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 11598000011727
case_no = 2025/98
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012732
MapName trcmf1
SourceId 12556000012696
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 16/02/2026
case_no = 2025/98
trn_rcms_caseregid = 11598000011727
court_code = 10082
case_purpose = 18678000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012732
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012696
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:54
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=18678000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/98
Param Type = c
trn_rcms_caseregid=11598000011727
Param Type = c
court_code=10082
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 23
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16037000009765 idvalue 0
Mapped case_no Row = 1 value = 2025/115 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 16037000009765
case_no = 2025/115
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purposename=???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????
Time elapsed = 5
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12556000012733
MapName trcmf1
SourceId 12556000012697
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 16/02/2026
case_no = 2025/115
trn_rcms_caseregid = 16037000009765
court_code = 10082
case_purpose = 1000525
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012733
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012697
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:55
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=1000525
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/115
Param Type = c
trn_rcms_caseregid=16037000009765
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 24
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17207000010922 idvalue 0
Mapped case_no Row = 1 value = 2025/120 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 30/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 = 10082
trn_rcms_caseregid = 17207000010922
case_no = 2025/120
prev_hearing_date = 19/01/2026
hearing_date = 30/01/2026
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 = 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 = 12556000012734
MapName trcmf1
SourceId 12556000012698
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 = 1000525
hearing_date = 30/01/2026
case_no = 2025/120
trn_rcms_caseregid = 17207000010922
court_code = 10082
case_purpose = 1000525
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012734
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012698
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:55
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=1000525
Param Type = c
hearing_date=30/01/2026 00:00:00
Param Type = c
case_no=2025/120
Param Type = c
trn_rcms_caseregid=17207000010922
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 25
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13911000010224 idvalue 0
Mapped case_no Row = 1 value = 2025/135 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 13911000010224
case_no = 2025/135
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
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 = 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 = 12556000012735
MapName trcmf1
SourceId 12556000012699
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 16/02/2026
case_no = 2025/135
trn_rcms_caseregid = 13911000010224
court_code = 10082
case_purpose = 1000525
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012735
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012699
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:56
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/135
Param Type = c
trn_rcms_caseregid=13911000010224
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 26
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19842000010823 idvalue 0
Mapped case_no Row = 1 value = 2025/165 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 19842000010823
case_no = 2025/165
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
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 = 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 = 12556000012736
MapName trcmf1
SourceId 12556000012700
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 = 16/02/2026
case_no = 2025/165
trn_rcms_caseregid = 19842000010823
court_code = 10082
case_purpose = 1000525
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012736
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012700
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:56
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/165
Param Type = c
trn_rcms_caseregid=19842000010823
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 27
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12085000011459 idvalue 0
Mapped case_no Row = 1 value = 2025/273 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 12085000011459
case_no = 2025/273
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
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 = 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 = 12556000012737
MapName trcmf1
SourceId 12556000012701
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 16/02/2026
case_no = 2025/273
trn_rcms_caseregid = 12085000011459
court_code = 10082
case_purpose = 1000525
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012737
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012701
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:57
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=1000525
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/273
Param Type = c
trn_rcms_caseregid=12085000011459
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 28
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13712000011184 idvalue 0
Mapped case_no Row = 1 value = 2025/274 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 13712000011184
case_no = 2025/274
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
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 = 1
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 = 1
RecordId = 12556000012738
MapName trcmf1
SourceId 12556000012702
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 16/02/2026
case_no = 2025/274
trn_rcms_caseregid = 13712000011184
court_code = 10082
case_purpose = 1000525
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012738
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012702
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:58
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/274
Param Type = c
trn_rcms_caseregid=13712000011184
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 29
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12543000011696 idvalue 0
Mapped case_no Row = 1 value = 2025/48 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 12543000011696
case_no = 2025/48
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
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 = 1
RecordId = 12556000012739
MapName trcmf1
SourceId 12556000012703
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 16/02/2026
case_no = 2025/48
trn_rcms_caseregid = 12543000011696
court_code = 10082
case_purpose = 1000525
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012739
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012703
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:58
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/48
Param Type = c
trn_rcms_caseregid=12543000011696
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 30
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15956000009372 idvalue 0
Mapped case_no Row = 1 value = 2025/16 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? / ??????? idvalue 0
Mapped case_purpose Row = 1 value = 1000490 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 15956000009372
case_no = 2025/16
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ???????? / ???????
prev_case_purpose =
prev_case_purposename=???????? / ???????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???????? / ???????
Time elapsed = 3
prev_case_purpose after validation = 1000490
case_purpose = 1000490
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012740
MapName trcmf1
SourceId 12556000012704
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 = 1000490
hearing_date = 16/02/2026
case_no = 2025/16
trn_rcms_caseregid = 15956000009372
court_code = 10082
case_purpose = 1000490
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012740
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012704
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:43:59
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:43: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=1000490
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/16
Param Type = c
trn_rcms_caseregid=15956000009372
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000490
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 31
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11563000011081 idvalue 0
Mapped case_no Row = 1 value = 2025/71 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? / ??????? idvalue 0
Mapped case_purpose Row = 1 value = 1000490 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 = 10082
trn_rcms_caseregid = 11563000011081
case_no = 2025/71
prev_hearing_date = 19/01/2026
hearing_date = 28/01/2026
prev_case_purposename = ???????? / ???????
prev_case_purpose =
prev_case_purpose after validation = 1000490
case_purpose = 1000490
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 = 12556000012741
MapName trcmf1
SourceId 12556000012705
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 = 1000490
hearing_date = 28/01/2026
case_no = 2025/71
trn_rcms_caseregid = 11563000011081
court_code = 10082
case_purpose = 1000490
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012741
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012705
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:44:00
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:44:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000490
Param Type = c
hearing_date=28/01/2026 00:00:00
Param Type = c
case_no=2025/71
Param Type = c
trn_rcms_caseregid=11563000011081
Param Type = c
court_code=10082
Param Type = c
case_purpose=1000490
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 32
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14154000010602 idvalue 0
Mapped case_no Row = 1 value = 2025/138 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 25/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 14154000010602
case_no = 2025/138
prev_hearing_date = 19/01/2026
hearing_date = 25/02/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purposename=??????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ????
Time elapsed = 3
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12556000012742
MapName trcmf1
SourceId 12556000012706
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 = 18466000000000
hearing_date = 25/02/2026
case_no = 2025/138
trn_rcms_caseregid = 14154000010602
court_code = 10082
case_purpose = 18466000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012742
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012706
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:44:00
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:44:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=25/02/2026 00:00:00
Param Type = c
case_no=2025/138
Param Type = c
trn_rcms_caseregid=14154000010602
Param Type = c
court_code=10082
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 33
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14281000011789 idvalue 0
Mapped case_no Row = 1 value = 2025/140 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 14281000011789
case_no = 2025/140
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12556000012743
MapName trcmf1
SourceId 12556000012707
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 = 18466000000000
hearing_date = 16/02/2026
case_no = 2025/140
trn_rcms_caseregid = 14281000011789
court_code = 10082
case_purpose = 18466000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012743
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012707
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:44:01
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:44: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=18466000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/140
Param Type = c
trn_rcms_caseregid=14281000011789
Param Type = c
court_code=10082
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 34
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14764000009127 idvalue 0
Mapped case_no Row = 1 value = 2025/17 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 14764000009127
case_no = 2025/17
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12556000012744
MapName trcmf1
SourceId 12556000012708
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 = 18466000000000
hearing_date = 16/02/2026
case_no = 2025/17
trn_rcms_caseregid = 14764000009127
court_code = 10082
case_purpose = 18466000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012744
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012708
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:44:01
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:44: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=18466000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/17
Param Type = c
trn_rcms_caseregid=14764000009127
Param Type = c
court_code=10082
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 35
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12750000010375 idvalue 0
Mapped case_no Row = 1 value = 2025/63 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 12750000010375
case_no = 2025/63
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12556000012745
MapName trcmf1
SourceId 12556000012709
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 = 18466000000000
hearing_date = 16/02/2026
case_no = 2025/63
trn_rcms_caseregid = 12750000010375
court_code = 10082
case_purpose = 18466000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012745
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012709
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:44:02
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:44: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=18466000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/63
Param Type = c
trn_rcms_caseregid=12750000010375
Param Type = c
court_code=10082
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 36
>>Mapping
Mapped court_code Row = 1 value = 10082 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13370000009892 idvalue 0
Mapped case_no Row = 1 value = 2025/83 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/01/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/02/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10082
trn_rcms_caseregid = 13370000009892
case_no = 2025/83
prev_hearing_date = 19/01/2026
hearing_date = 16/02/2026
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12556000012746
MapName trcmf1
SourceId 12556000012710
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 = 18466000000000
hearing_date = 16/02/2026
case_no = 2025/83
trn_rcms_caseregid = 13370000009892
court_code = 10082
case_purpose = 18466000000000
prev_hearing_date = 19/01/2026
Posting record
Param Type = n
trn_rcms_case_histid=12556000012746
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12556000012710
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chattargarh_PRO
Param Type = c
createdon=24/01/2026 11:44:03
Param Type = c
username=SDO_Chattargarh_PRO
Param Type = c
modifiedon=24/01/2026 11:44:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=16/02/2026 00:00:00
Param Type = c
case_no=2025/83
Param Type = c
trn_rcms_caseregid=13370000009892
Param Type = c
court_code=10082
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=19/01/2026 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
Time elapsed for Gen Map = 3978416643304
Time elapsed for MD Map = 3978416643304
Time elapsed for Save History = 3978416643304
Time elapsed for Save Attachment = 3978416643305
Time elapsed for After Save WF Exec = 3978416643308
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"12556000012674"}]}
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_Chattargarh_PRO
Param Type = c
calledon=24/01/2026 11:43:39
Param Type = c
callfinished=24/01/2026 11:44:03
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=24076
Param Type = n
dbtimetaken=23106
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