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
<transaction username="Adc_ajmer" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>Adc_ajmer</username><password>827ccb0eea8a706c4c34a16891f84e7b</password><seed></seed><s></s><transid>trcmf</transid><recordid>0</recordid><recdata></recdata><data transid="trcmf" recordid="0"><axp_recid1 rowno="001">0</axp_recid1><courtcode rowno="001">10634</courtcode><hearing_date rowno="001">04/12/2025</hearing_date><axp_recid2 rowno="001">0</axp_recid2><court_code rowno="001">10634</court_code><case_no rowno="001">2024/105</case_no><trn_rcms_caseid rowno="001">18843000008786</trn_rcms_caseid><pre_case_purpose_name rowno="001">?????</pre_case_purpose_name><pre_hear_date rowno="001">04/12/2025</pre_hear_date><pre_case_purpose rowno="001">1000492</pre_case_purpose><next_hear_date rowno="001">05/02/2026</next_hear_date><new_case_purpose rowno="001">1000492</new_case_purpose><isadjourn rowno="001">NO</isadjourn><adjourn_type rowno="001">0</adjourn_type><adjourn_remark rowno="001"></adjourn_remark><axp_recid2 rowno="002">0</axp_recid2><court_code rowno="002">10634</court_code><case_no rowno="002">2024/1384</case_no><trn_rcms_caseid rowno="002">12747000008888</trn_rcms_caseid><pre_case_purpose_name rowno="002">?????</pre_case_purpose_name><pre_hear_date rowno="002">04/12/2025</pre_hear_date><pre_case_purpose rowno="002">1000492</pre_case_purpose><next_hear_date rowno="002">05/02/2026</next_hear_date><new_case_purpose rowno="002">1000492</new_case_purpose><isadjourn rowno="002">NO</isadjourn><adjourn_type rowno="002">0</adjourn_type><adjourn_remark rowno="002"></adjourn_remark><axp_recid2 rowno="003">0</axp_recid2><court_code rowno="003">10634</court_code><case_no rowno="003">2024/694</case_no><trn_rcms_caseid rowno="003">13281000007644</trn_rcms_caseid><pre_case_purpose_name rowno="003">?????</pre_case_purpose_name><pre_hear_date rowno="003">04/12/2025</pre_hear_date><pre_case_purpose rowno="003">1000492</pre_case_purpose><next_hear_date rowno="003">05/02/2026</next_hear_date><new_case_purpose rowno="003">1000492</new_case_purpose><isadjourn rowno="003">NO</isadjourn><adjourn_type rowno="003">0</adjourn_type><adjourn_remark rowno="003"></adjourn_remark><axp_recid2 rowno="004">0</axp_recid2><court_code rowno="004">10634</court_code><case_no rowno="004">2024/70</case_no><trn_rcms_caseid rowno="004">15428000007725</trn_rcms_caseid><pre_case_purpose_name rowno="004">?????</pre_case_purpose_name><pre_hear_date rowno="004">04/12/2025</pre_hear_date><pre_case_purpose rowno="004">1000492</pre_case_purpose><next_hear_date rowno="004">22/01/2026</next_hear_date><new_case_purpose rowno="004">1000492</new_case_purpose><isadjourn rowno="004">NO</isadjourn><adjourn_type rowno="004">0</adjourn_type><adjourn_remark rowno="004"></adjourn_remark><axp_recid2 rowno="005">0</axp_recid2><court_code rowno="005">10634</court_code><case_no rowno="005">2024/74</case_no><trn_rcms_caseid rowno="005">15442000008198</trn_rcms_caseid><pre_case_purpose_name rowno="005">?????</pre_case_purpose_name><pre_hear_date rowno="005">04/12/2025</pre_hear_date><pre_case_purpose rowno="005">1000492</pre_case_purpose><next_hear_date rowno="005">05/02/2026</next_hear_date><new_case_purpose rowno="005">1000492</new_case_purpose><isadjourn rowno="005">NO</isadjourn><adjourn_type rowno="005">0</adjourn_type><adjourn_remark rowno="005"></adjourn_remark><axp_recid2 rowno="006">0</axp_recid2><court_code rowno="006">10634</court_code><case_no rowno="006">2024/801</case_no><trn_rcms_caseid rowno="006">12497000010184</trn_rcms_caseid><pre_case_purpose_name rowno="006">?????</pre_case_purpose_name><pre_hear_date rowno="006">04/12/2025</pre_hear_date><pre_case_purpose rowno="006">1000492</pre_case_purpose><next_hear_date rowno="006">05/02/2026</next_hear_date><new_case_purpose rowno="006">1000492</new_case_purpose><isadjourn rowno="006">NO</isadjourn><adjourn_type rowno="006">0</adjourn_type><adjourn_remark rowno="006"></adjourn_remark><axp_recid2 rowno="007">0</axp_recid2><court_code rowno="007">10634</court_code><case_no rowno="007">2024/832</case_no><trn_rcms_caseid rowno="007">17892000009001</trn_rcms_caseid><pre_case_purpose_name rowno="007">?????</pre_case_purpose_name><pre_hear_date rowno="007">04/12/2025</pre_hear_date><pre_case_purpose rowno="007">1000492</pre_case_purpose><next_hear_date rowno="007">22/01/2026</next_hear_date><new_case_purpose rowno="007">1000492</new_case_purpose><isadjourn rowno="007">NO</isadjourn><adjourn_type rowno="007">0</adjourn_type><adjourn_remark rowno="007"></adjourn_remark><axp_recid2 rowno="008">0</axp_recid2><court_code rowno="008">10634</court_code><case_no rowno="008">2024/914</case_no><trn_rcms_caseid rowno="008">10843000008836</trn_rcms_caseid><pre_case_purpose_name rowno="008">?????</pre_case_purpose_name><pre_hear_date rowno="008">04/12/2025</pre_hear_date><pre_case_purpose rowno="008">1000492</pre_case_purpose><next_hear_date rowno="008">05/02/2026</next_hear_date><new_case_purpose rowno="008">1000492</new_case_purpose><isadjourn rowno="008">NO</isadjourn><adjourn_type rowno="008">0</adjourn_type><adjourn_remark rowno="008"></adjourn_remark><axp_recid2 rowno="009">0</axp_recid2><court_code rowno="009">10634</court_code><case_no rowno="009">2024/926</case_no><trn_rcms_caseid rowno="009">10991000009123</trn_rcms_caseid><pre_case_purpose_name rowno="009">?????</pre_case_purpose_name><pre_hear_date rowno="009">04/12/2025</pre_hear_date><pre_case_purpose rowno="009">1000492</pre_case_purpose><next_hear_date rowno="009">22/01/2026</next_hear_date><new_case_purpose rowno="009">1000492</new_case_purpose><isadjourn rowno="009">NO</isadjourn><adjourn_type rowno="009">0</adjourn_type><adjourn_remark rowno="009"></adjourn_remark><axp_recid2 rowno="0010">0</axp_recid2><court_code rowno="0010">10634</court_code><case_no rowno="0010">2024/972</case_no><trn_rcms_caseid rowno="0010">13046000008778</trn_rcms_caseid><pre_case_purpose_name rowno="0010">?????</pre_case_purpose_name><pre_hear_date rowno="0010">04/12/2025</pre_hear_date><pre_case_purpose rowno="0010">1000492</pre_case_purpose><next_hear_date rowno="0010">05/02/2026</next_hear_date><new_case_purpose rowno="0010">1000492</new_case_purpose><isadjourn rowno="0010">NO</isadjourn><adjourn_type rowno="0010">0</adjourn_type><adjourn_remark rowno="0010"></adjourn_remark><axp_recid2 rowno="0011">0</axp_recid2><court_code rowno="0011">10634</court_code><case_no rowno="0011">2025/289</case_no><trn_rcms_caseid rowno="0011">12682000010121</trn_rcms_caseid><pre_case_purpose_name rowno="0011">???</pre_case_purpose_name><pre_hear_date rowno="0011">04/12/2025</pre_hear_date><pre_case_purpose rowno="0011">18473000000000</pre_case_purpose><next_hear_date rowno="0011">11/12/2025</next_hear_date><new_case_purpose rowno="0011">18473000000000</new_case_purpose><isadjourn rowno="0011">NO</isadjourn><adjourn_type rowno="0011">0</adjourn_type><adjourn_remark rowno="0011"></adjourn_remark><axp_recid2 rowno="0012">0</axp_recid2><court_code rowno="0012">10634</court_code><case_no rowno="0012">2025/34</case_no><trn_rcms_caseid rowno="0012">14694000009459</trn_rcms_caseid><pre_case_purpose_name rowno="0012">???</pre_case_purpose_name><pre_hear_date rowno="0012">04/12/2025</pre_hear_date><pre_case_purpose rowno="0012">18473000000000</pre_case_purpose><next_hear_date rowno="0012">26/12/2025</next_hear_date><new_case_purpose rowno="0012">18473000000000</new_case_purpose><isadjourn rowno="0012">NO</isadjourn><adjourn_type rowno="0012">0</adjourn_type><adjourn_remark rowno="0012"></adjourn_remark><axp_recid2 rowno="0013">0</axp_recid2><court_code rowno="0013">10634</court_code><case_no rowno="0013">2025/426</case_no><trn_rcms_caseid rowno="0013">11512000011650</trn_rcms_caseid><pre_case_purpose_name rowno="0013">???</pre_case_purpose_name><pre_hear_date rowno="0013">04/12/2025</pre_hear_date><pre_case_purpose rowno="0013">18473000000000</pre_case_purpose><next_hear_date rowno="0013">26/12/2025</next_hear_date><new_case_purpose rowno="0013">18473000000000</new_case_purpose><isadjourn rowno="0013">NO</isadjourn><adjourn_type rowno="0013">0</adjourn_type><adjourn_remark rowno="0013"></adjourn_remark><axp_recid2 rowno="0014">0</axp_recid2><court_code rowno="0014">10634</court_code><case_no rowno="0014">2025/492</case_no><trn_rcms_caseid rowno="0014">18123000010337</trn_rcms_caseid><pre_case_purpose_name rowno="0014">???</pre_case_purpose_name><pre_hear_date rowno="0014">04/12/2025</pre_hear_date><pre_case_purpose rowno="0014">18473000000000</pre_case_purpose><next_hear_date rowno="0014">26/12/2025</next_hear_date><new_case_purpose rowno="0014">18473000000000</new_case_purpose><isadjourn rowno="0014">NO</isadjourn><adjourn_type rowno="0014">0</adjourn_type><adjourn_remark rowno="0014"></adjourn_remark><axp_recid2 rowno="0015">0</axp_recid2><court_code rowno="0015">10634</court_code><case_no rowno="0015">2025/77</case_no><trn_rcms_caseid rowno="0015">18812000008966</trn_rcms_caseid><pre_case_purpose_name rowno="0015">???</pre_case_purpose_name><pre_hear_date rowno="0015">04/12/2025</pre_hear_date><pre_case_purpose rowno="0015">18473000000000</pre_case_purpose><next_hear_date rowno="0015">26/12/2025</next_hear_date><new_case_purpose rowno="0015">18473000000000</new_case_purpose><isadjourn rowno="0015">NO</isadjourn><adjourn_type rowno="0015">0</adjourn_type><adjourn_remark rowno="0015"></adjourn_remark><axp_recid2 rowno="0016">0</axp_recid2><court_code rowno="0016">10634</court_code><case_no rowno="0016">2025/304</case_no><trn_rcms_caseid rowno="0016">18252000009982</trn_rcms_caseid><pre_case_purpose_name rowno="0016">????</pre_case_purpose_name><pre_hear_date rowno="0016">04/12/2025</pre_hear_date><pre_case_purpose rowno="0016">18678000000000</pre_case_purpose><next_hear_date rowno="0016">15/01/2026</next_hear_date><new_case_purpose rowno="0016">18678000000000</new_case_purpose><isadjourn rowno="0016">NO</isadjourn><adjourn_type rowno="0016">0</adjourn_type><adjourn_remark rowno="0016"></adjourn_remark><axp_recid2 rowno="0017">0</axp_recid2><court_code rowno="0017">10634</court_code><case_no rowno="0017">2025/305</case_no><trn_rcms_caseid rowno="0017">18384000009279</trn_rcms_caseid><pre_case_purpose_name rowno="0017">????</pre_case_purpose_name><pre_hear_date rowno="0017">04/12/2025</pre_hear_date><pre_case_purpose rowno="0017">18678000000000</pre_case_purpose><next_hear_date rowno="0017">15/01/2026</next_hear_date><new_case_purpose rowno="0017">18678000000000</new_case_purpose><isadjourn rowno="0017">NO</isadjourn><adjourn_type rowno="0017">0</adjourn_type><adjourn_remark rowno="0017"></adjourn_remark><axp_recid2 rowno="0018">0</axp_recid2><court_code rowno="0018">10634</court_code><case_no rowno="0018">2025/417</case_no><trn_rcms_caseid rowno="0018">17767000009620</trn_rcms_caseid><pre_case_purpose_name rowno="0018">????</pre_case_purpose_name><pre_hear_date rowno="0018">04/12/2025</pre_hear_date><pre_case_purpose rowno="0018">18678000000000</pre_case_purpose><next_hear_date rowno="0018">15/01/2026</next_hear_date><new_case_purpose rowno="0018">18678000000000</new_case_purpose><isadjourn rowno="0018">NO</isadjourn><adjourn_type rowno="0018">0</adjourn_type><adjourn_remark rowno="0018"></adjourn_remark><axp_recid2 rowno="0019">0</axp_recid2><court_code rowno="0019">10634</court_code><case_no rowno="0019">2025/432</case_no><trn_rcms_caseid rowno="0019">13416000010172</trn_rcms_caseid><pre_case_purpose_name rowno="0019">????</pre_case_purpose_name><pre_hear_date rowno="0019">04/12/2025</pre_hear_date><pre_case_purpose rowno="0019">18678000000000</pre_case_purpose><next_hear_date rowno="0019">28/01/2026</next_hear_date><new_case_purpose rowno="0019">18678000000000</new_case_purpose><isadjourn rowno="0019">NO</isadjourn><adjourn_type rowno="0019">0</adjourn_type><adjourn_remark rowno="0019"></adjourn_remark><axp_recid2 rowno="0020">0</axp_recid2><court_code rowno="0020">10634</court_code><case_no rowno="0020">2025/433</case_no><trn_rcms_caseid rowno="0020">13504000011485</trn_rcms_caseid><pre_case_purpose_name rowno="0020">????</pre_case_purpose_name><pre_hear_date rowno="0020">04/12/2025</pre_hear_date><pre_case_purpose rowno="0020">18678000000000</pre_case_purpose><next_hear_date rowno="0020">28/01/2026</next_hear_date><new_case_purpose rowno="0020">18678000000000</new_case_purpose><isadjourn rowno="0020">NO</isadjourn><adjourn_type rowno="0020">0</adjourn_type><adjourn_remark rowno="0020"></adjourn_remark><axp_recid2 rowno="0021">0</axp_recid2><court_code rowno="0021">10634</court_code><case_no rowno="0021">2025/474</case_no><trn_rcms_caseid rowno="0021">19242000011629</trn_rcms_caseid><pre_case_purpose_name rowno="0021">????</pre_case_purpose_name><pre_hear_date rowno="0021">04/12/2025</pre_hear_date><pre_case_purpose rowno="0021">18678000000000</pre_case_purpose><next_hear_date rowno="0021">17/12/2025</next_hear_date><new_case_purpose rowno="0021">18678000000000</new_case_purpose><isadjourn rowno="0021">NO</isadjourn><adjourn_type rowno="0021">0</adjourn_type><adjourn_remark rowno="0021"></adjourn_remark><axp_recid2 rowno="0022">0</axp_recid2><court_code rowno="0022">10634</court_code><case_no rowno="0022">2025/153</case_no><trn_rcms_caseid rowno="0022">10281000009368</trn_rcms_caseid><pre_case_purpose_name rowno="0022">?????</pre_case_purpose_name><pre_hear_date rowno="0022">04/12/2025</pre_hear_date><pre_case_purpose rowno="0022">1000492</pre_case_purpose><next_hear_date rowno="0022">21/01/2026</next_hear_date><new_case_purpose rowno="0022">1000492</new_case_purpose><isadjourn rowno="0022">NO</isadjourn><adjourn_type rowno="0022">0</adjourn_type><adjourn_remark rowno="0022"></adjourn_remark><axp_recid2 rowno="0023">0</axp_recid2><court_code rowno="0023">10634</court_code><case_no rowno="0023">2025/161</case_no><trn_rcms_caseid rowno="0023">10401000009618</trn_rcms_caseid><pre_case_purpose_name rowno="0023">?????</pre_case_purpose_name><pre_hear_date rowno="0023">04/12/2025</pre_hear_date><pre_case_purpose rowno="0023">1000492</pre_case_purpose><next_hear_date rowno="0023">21/01/2026</next_hear_date><new_case_purpose rowno="0023">1000492</new_case_purpose><isadjourn rowno="0023">NO</isadjourn><adjourn_type rowno="0023">0</adjourn_type><adjourn_remark rowno="0023"></adjourn_remark><axp_recid2 rowno="0024">0</axp_recid2><court_code rowno="0024">10634</court_code><case_no rowno="0024">2025/206</case_no><trn_rcms_caseid rowno="0024">13610000009658</trn_rcms_caseid><pre_case_purpose_name rowno="0024">?????</pre_case_purpose_name><pre_hear_date rowno="0024">04/12/2025</pre_hear_date><pre_case_purpose rowno="0024">1000492</pre_case_purpose><next_hear_date rowno="0024">28/01/2026</next_hear_date><new_case_purpose rowno="0024">1000492</new_case_purpose><isadjourn rowno="0024">NO</isadjourn><adjourn_type rowno="0024">0</adjourn_type><adjourn_remark rowno="0024"></adjourn_remark><axp_recid2 rowno="0025">0</axp_recid2><court_code rowno="0025">10634</court_code><case_no rowno="0025">2025/329</case_no><trn_rcms_caseid rowno="0025">13095000009436</trn_rcms_caseid><pre_case_purpose_name rowno="0025">?????</pre_case_purpose_name><pre_hear_date rowno="0025">04/12/2025</pre_hear_date><pre_case_purpose rowno="0025">1000492</pre_case_purpose><next_hear_date rowno="0025">28/01/2026</next_hear_date><new_case_purpose rowno="0025">1000492</new_case_purpose><isadjourn rowno="0025">NO</isadjourn><adjourn_type rowno="0025">0</adjourn_type><adjourn_remark rowno="0025"></adjourn_remark><axp_recid2 rowno="0026">0</axp_recid2><court_code rowno="0026">10634</court_code><case_no rowno="0026">2025/584</case_no><trn_rcms_caseid rowno="0026">18037000014210</trn_rcms_caseid><pre_case_purpose_name rowno="0026">???? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="0026">04/12/2025</pre_hear_date><pre_case_purpose rowno="0026">12555000000002</pre_case_purpose><next_hear_date rowno="0026">11/12/2025</next_hear_date><new_case_purpose rowno="0026">12555000000002</new_case_purpose><isadjourn rowno="0026">NO</isadjourn><adjourn_type rowno="0026">0</adjourn_type><adjourn_remark rowno="0026"></adjourn_remark></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"Adc_ajmer","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"trcmf","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtcode":"10634","hearing_date":"04/12/2025"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"court_code":"10634","case_no":"2024/105","trn_rcms_caseid":"18843000008786","pre_case_purpose_name":"?????","pre_hear_date":"04/12/2025","pre_case_purpose":"1000492","next_hear_date":"05/02/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"002","text":"0","columns":{"court_code":"10634","case_no":"2024/1384","trn_rcms_caseid":"12747000008888","pre_case_purpose_name":"?????","pre_hear_date":"04/12/2025","pre_case_purpose":"1000492","next_hear_date":"05/02/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"003","text":"0","columns":{"court_code":"10634","case_no":"2024/694","trn_rcms_caseid":"13281000007644","pre_case_purpose_name":"?????","pre_hear_date":"04/12/2025","pre_case_purpose":"1000492","next_hear_date":"05/02/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"004","text":"0","columns":{"court_code":"10634","case_no":"2024/70","trn_rcms_caseid":"15428000007725","pre_case_purpose_name":"?????","pre_hear_date":"04/12/2025","pre_case_purpose":"1000492","next_hear_date":"22/01/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"005","text":"0","columns":{"court_code":"10634","case_no":"2024/74","trn_rcms_caseid":"15442000008198","pre_case_purpose_name":"?????","pre_hear_date":"04/12/2025","pre_case_purpose":"1000492","next_hear_date":"05/02/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"006","text":"0","columns":{"court_code":"10634","case_no":"2024/801","trn_rcms_caseid":"12497000010184","pre_case_purpose_name":"?????","pre_hear_date":"04/12/2025","pre_case_purpose":"1000492","next_hear_date":"05/02/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"007","text":"0","columns":{"court_code":"10634","case_no":"2024/832","trn_rcms_caseid":"17892000009001","pre_case_purpose_name":"?????","pre_hear_date":"04/12/2025","pre_case_purpose":"1000492","next_hear_date":"22/01/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"008","text":"0","columns":{"court_code":"10634","case_no":"2024/914","trn_rcms_caseid":"10843000008836","pre_case_purpose_name":"?????","pre_hear_date":"04/12/2025","pre_case_purpose":"1000492","next_hear_date":"05/02/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"009","text":"0","columns":{"court_code":"10634","case_no":"2024/926","trn_rcms_caseid":"10991000009123","pre_case_purpose_name":"?????","pre_hear_date":"04/12/2025","pre_case_purpose":"1000492","next_hear_date":"22/01/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0010","text":"0","columns":{"court_code":"10634","case_no":"2024/972","trn_rcms_caseid":"13046000008778","pre_case_purpose_name":"?????","pre_hear_date":"04/12/2025","pre_case_purpose":"1000492","next_hear_date":"05/02/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0011","text":"0","columns":{"court_code":"10634","case_no":"2025/289","trn_rcms_caseid":"12682000010121","pre_case_purpose_name":"???","pre_hear_date":"04/12/2025","pre_case_purpose":"18473000000000","next_hear_date":"11/12/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0012","text":"0","columns":{"court_code":"10634","case_no":"2025/34","trn_rcms_caseid":"14694000009459","pre_case_purpose_name":"???","pre_hear_date":"04/12/2025","pre_case_purpose":"18473000000000","next_hear_date":"26/12/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0013","text":"0","columns":{"court_code":"10634","case_no":"2025/426","trn_rcms_caseid":"11512000011650","pre_case_purpose_name":"???","pre_hear_date":"04/12/2025","pre_case_purpose":"18473000000000","next_hear_date":"26/12/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0014","text":"0","columns":{"court_code":"10634","case_no":"2025/492","trn_rcms_caseid":"18123000010337","pre_case_purpose_name":"???","pre_hear_date":"04/12/2025","pre_case_purpose":"18473000000000","next_hear_date":"26/12/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0015","text":"0","columns":{"court_code":"10634","case_no":"2025/77","trn_rcms_caseid":"18812000008966","pre_case_purpose_name":"???","pre_hear_date":"04/12/2025","pre_case_purpose":"18473000000000","next_hear_date":"26/12/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0016","text":"0","columns":{"court_code":"10634","case_no":"2025/304","trn_rcms_caseid":"18252000009982","pre_case_purpose_name":"????","pre_hear_date":"04/12/2025","pre_case_purpose":"18678000000000","next_hear_date":"15/01/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0017","text":"0","columns":{"court_code":"10634","case_no":"2025/305","trn_rcms_caseid":"18384000009279","pre_case_purpose_name":"????","pre_hear_date":"04/12/2025","pre_case_purpose":"18678000000000","next_hear_date":"15/01/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0018","text":"0","columns":{"court_code":"10634","case_no":"2025/417","trn_rcms_caseid":"17767000009620","pre_case_purpose_name":"????","pre_hear_date":"04/12/2025","pre_case_purpose":"18678000000000","next_hear_date":"15/01/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0019","text":"0","columns":{"court_code":"10634","case_no":"2025/432","trn_rcms_caseid":"13416000010172","pre_case_purpose_name":"????","pre_hear_date":"04/12/2025","pre_case_purpose":"18678000000000","next_hear_date":"28/01/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0020","text":"0","columns":{"court_code":"10634","case_no":"2025/433","trn_rcms_caseid":"13504000011485","pre_case_purpose_name":"????","pre_hear_date":"04/12/2025","pre_case_purpose":"18678000000000","next_hear_date":"28/01/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0021","text":"0","columns":{"court_code":"10634","case_no":"2025/474","trn_rcms_caseid":"19242000011629","pre_case_purpose_name":"????","pre_hear_date":"04/12/2025","pre_case_purpose":"18678000000000","next_hear_date":"17/12/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0022","text":"0","columns":{"court_code":"10634","case_no":"2025/153","trn_rcms_caseid":"10281000009368","pre_case_purpose_name":"?????","pre_hear_date":"04/12/2025","pre_case_purpose":"1000492","next_hear_date":"21/01/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0023","text":"0","columns":{"court_code":"10634","case_no":"2025/161","trn_rcms_caseid":"10401000009618","pre_case_purpose_name":"?????","pre_hear_date":"04/12/2025","pre_case_purpose":"1000492","next_hear_date":"21/01/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0024","text":"0","columns":{"court_code":"10634","case_no":"2025/206","trn_rcms_caseid":"13610000009658","pre_case_purpose_name":"?????","pre_hear_date":"04/12/2025","pre_case_purpose":"1000492","next_hear_date":"28/01/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0025","text":"0","columns":{"court_code":"10634","case_no":"2025/329","trn_rcms_caseid":"13095000009436","pre_case_purpose_name":"?????","pre_hear_date":"04/12/2025","pre_case_purpose":"1000492","next_hear_date":"28/01/2026","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0026","text":"0","columns":{"court_code":"10634","case_no":"2025/584","trn_rcms_caseid":"18037000014210","pre_case_purpose_name":"???? ????????? ????","pre_hear_date":"04/12/2025","pre_case_purpose":"12555000000002","next_hear_date":"11/12/2025","new_case_purpose":"12555000000002","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}}]}]}}
Verifying username and password
User Name : Adc_ajmer
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=adc_ajmer
Time elapsed = 19
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 4
Result : 
Verifying completed...
Page Access Category : 
User Name : adc_ajmer
Select sysdate as sdt from dual
Time elapsed = 2
dt=04/12/2025 14:51:12
Select sysdate as sdt from dual
Time elapsed = 2
Select usergroup from AXUSERLEVELGROUPS WHERE (lower(username) =:U) and ((startdate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') >= startdate) or (startdate is null)) and ((enddate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') <= enddate) or (enddate is null))
U=adc_ajmer
dt=04/12/2025 14:51:12
dt=04/12/2025 14:51:12
Time elapsed = 7
User Groups: court_admin,court_reader
select userroles from axusergroups where groupname in ( 'court_admin','court_reader' )
Time elapsed = 4
User Roles : court_admin,court_reader
Loading App/User vars
reading the props xml
Step3
Sql : select props from axprops where lower(name)= :name  order by blobno

Paramval : app
ParamTYpe : c
Param List : name

select props from axprops where lower(name)= :name  order by blobno

Time elapsed = 2
Step4
axprops\stm size:4235
Step4-123456
<root updatedon="06/08/2025 14:47:20" name="app" caption="app" appverno="10.1.0.0" updusername="" updatedby="admin"><props LocalNum="750"><app color="$00EBF5F4" font="Tahoma,8"/><head font="Tahoma,12,tfff" color="$00DDE8E7"/><gridhead color="$00FFE8E8" font=""/><gridrow oddrowcolor="$00FEFCFA" evenrowcolor="$00FEF3ED"></gridrow><imgsfolder>images\</imgsfolder><container color="$00E8F1F0"/><name fontname="" fontsize="" fontbold="" fontitalic="" fontunderline="" fontcolor="" fontstrikeout="">Generalized Court Management System</name><img></img><envvar><currency>INR</currency><millions>F</millions><siteno></siteno><oraerrfrom>500</oraerrfrom><oraerrto>250000</oraerrto><postauto>F</postauto><finyrst></finyrst><finyred></finyred><cursep></cursep></envvar><currencies><INR></INR></currencies><appvars><m_courtname value="" param="f" hidden="false"><l>firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})</l><l>m_courtname := sqlget({m2},{court_name})</l></m_courtname><m_courttype value="" param="f" hidden="false"><l>firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})</l><l>m_courttype := sqlget({m3},{court_type})</l></m_courttype><m_courtid value="" param="f" hidden="false"><l>firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})</l><l>m_courtid := sqlget({m4},{court_name_mastid})</l></m_courtid><login_userid value="" param="f" hidden="false"><l>firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})</l><l>login_userid := sqlget({m4},{axusersid})</l></login_userid><u_name value="" param="f" hidden="false"><l>firesql({m4},{select :username as uname from dual})</l><l>u_name := sqlget({m4},{uname})</l></u_name><m_courtcode value="" param="f" hidden="false"><l>firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})</l><l>m_courtcode := sqlget({m4},{COURT_CODE})</l></m_courtcode><m_statename value="" param="f" hidden="false"><l>firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})</l><l>m_statename := sqlget({m2},{STATE_NAME})</l></m_statename><m_distname value="" param="f" hidden="false"><l>firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})</l><l>m_distName := sqlget({m7},{DISTNAMEENG})</l></m_distname><m_courtcatid value="" param="f" hidden="false"><l>firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})</l><l>m_courtcatid := sqlget({m8},{COURT_CATEGOTY})</l></m_courtcatid><m_deptid value="" param="f" hidden="false"><l>firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})</l><l>m_deptid := sqlget({m4},{department_mastid})</l></m_deptid><m_courttypeid value="" param="f" hidden="false"><l>firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})</l><l>m_courttypeid := sqlget({m3},{court_type_mastid})</l></m_courttypeid><urole value="" param="f" hidden="false"><l>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 })</l><l>urole := sqlget({m4},{groupname})</l></urole><m_cutoffdt value="" param="f" hidden="false"><l>firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})</l><l>m_cutoffdt := sqlget({a1},{dd})</l></m_cutoffdt><m_offcount value="" param="f" hidden="false"><l>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})</l><l>m_offcount := sqlget({P1},{ct})</l></m_offcount></appvars><readonlyprops readonly_fontcolor="clBlack" readonly_bgcolor="clWindow"/><gfont/><mail><host></host><port></port><userid></userid><password></password></mail><pwdsetting><maxlogintry>0</maxlogintry><pwdexpdays>0</pwdexpdays><pwdalertdays>0</pwdalertdays><pwdminchars>0</pwdminchars><pwdprevnos>0</pwdprevnos><ispwdalphanum>F</ispwdalphanum></pwdsetting></props></root>
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=ADC_ajmer
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=ADC_ajmer
Time elapsed = 3
   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=ADC_ajmer
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=ADC_ajmer
Time elapsed = 3
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type})
   Calling function sqlget
   Result of sqlget = ADC
   Result = ADC
   Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
   Calling function firesql
username=ADC_ajmer
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=ADC_ajmer
Time elapsed = 2
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{court_name_mastid})
   Calling function sqlget
   Result of sqlget = 17410000000001
   Result = 17410000000001
   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=ADC_ajmer
Time elapsed = 2
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{axusersid})
   Calling function sqlget
   Result of sqlget = 4314
   Result = 4314
   Evaluating firesql({m4},{select :username as uname from dual})
   Calling function firesql
select :username as uname from dual
username=ADC_ajmer
Time elapsed = 3
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{uname})
   Calling function sqlget
   Result of sqlget = ADC_ajmer
   Result = ADC_ajmer
   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=ADC_ajmer
Time elapsed = 3
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{COURT_CODE})
   Calling function sqlget
   Result of sqlget = 10634
   Result = 10634
   Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
   Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 3
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{STATE_NAME})
   Calling function sqlget
   Result of sqlget = ????????
   Result = ????????
   Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=ADC_ajmer
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ADC_ajmer
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m7},{DISTNAMEENG})
   Calling function sqlget
   Result of sqlget = Ajmer
   Result = Ajmer
   Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=ADC_ajmer
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ADC_ajmer
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=4314
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=4314
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=ADC_ajmer
Time elapsed = 3
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type_mastid})
   Calling function sqlget
   Result of sqlget = 17410000000000
   Result = 17410000000000
   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=ADC_ajmer
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=ADC_ajmer
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{groupname})
   Calling function sqlget
   Result of sqlget = court_reader
   Result = court_reader
   Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
   Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 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=ADC_ajmer
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=ADC_ajmer
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({P1},{ct})
   Calling function sqlget
   Result of sqlget = 6
   Result = 6
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','court_reader') and lower(sname)='trcmf' and stype = 't' )

Time elapsed = 2
select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 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 = 3
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<currdate) | (next_hear_date<pre_hear_date) ,{Hearing date should be greater or equal to current date/previous hearing date.},{T})
   Result = 
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=trcmf
adxinout=o
Time elapsed = 3
select * from trn_rcms_mhearing where trn_rcms_mhearingid=0
Time elapsed = 2
select * from Axusers where 1=2
Time elapsed = 7
select distinct(fldname) from AxTempUserFields
Time elapsed = 3
select * from AxAttachWorkflow where lower(transid) = 'trcmf'
Time elapsed = 2
Step3
Sql : select props from tstructs where lower(name)= :name  order by blobno

Paramval : tchdh
ParamTYpe : c
Param List : name

select props from tstructs where lower(name)= :name  order by blobno

Time elapsed = 2
Step4
tstructs\stm size:1907
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tchdh
adxinout=o
Time elapsed = 3
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 3
Loading genmaps
Creating Action object
Submitting data to dbcall
Submiting & Registering data 
Registering Global variables data 
Registering Global variables data over
Setting values over
DB Call Validate and save

>>Validating trcmf

>>Frame No 1
courtcode = 10634
hearing_date = 04/12/2025
time zone difference  = 0

>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'

Time elapsed = 1
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where  TRN_RCMS_MHEARINGid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 16940000012149
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 2
hearing_date = 04/12/2025
courtcode = 10634
Posting record
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=04/12/2025 00:00:00
Param Type = c
courtcode=10634
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)

Saving to table TRN_RCMS_HEARING
select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 16940000012150
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
new_case_purpose = 1000492
adjourn_remark = 
pre_hear_date = 04/12/2025
case_no = 2024/105
court_code = 10634
pre_case_purpose = 1000492
isadjourn = NO
next_hear_date = 05/02/2026
adjourn_type = 0
trn_rcms_caseid = 18843000008786
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=16940000012150
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = c
case_no=2024/105
Param Type = c
court_code=10634
Param Type = n
pre_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=05/02/2026 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18843000008786
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,new_case_purpose,adjourn_remark,pre_hear_date,case_no,court_code,pre_case_purpose,isadjourn,next_hear_date,adjourn_type,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:pre_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:trn_rcms_caseid,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012151
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
court_code = 10634
case_no = 2024/1384
isadjourn = NO
next_hear_date = 05/02/2026
adjourn_remark = 
adjourn_type = 0
pre_hear_date = 04/12/2025
trn_rcms_caseid = 12747000008888
new_case_purpose = 1000492
pre_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=16940000012151
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10634
Param Type = c
case_no=2024/1384
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=05/02/2026 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = c
trn_rcms_caseid=12747000008888
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
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,court_code,case_no,isadjourn,next_hear_date,adjourn_remark,adjourn_type,pre_hear_date,trn_rcms_caseid,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,:court_code,:case_no,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 16940000012152
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 04/12/2025
pre_case_purpose = 1000492
trn_rcms_caseid = 13281000007644
court_code = 10634
case_no = 2024/694
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 05/02/2026
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=16940000012152
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=13281000007644
Param Type = c
court_code=10634
Param Type = c
case_no=2024/694
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=05/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 = 2
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 16940000012153
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 04/12/2025
pre_case_purpose = 1000492
trn_rcms_caseid = 15428000007725
court_code = 10634
case_no = 2024/70
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 22/01/2026
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=16940000012153
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=15428000007725
Param Type = c
court_code=10634
Param Type = c
case_no=2024/70
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=22/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,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 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012154
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 05/02/2026
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2024/74
court_code = 10634
trn_rcms_caseid = 15442000008198
pre_case_purpose = 1000492
pre_hear_date = 04/12/2025
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=16940000012154
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/02/2026 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/74
Param Type = c
court_code=10634
Param Type = c
trn_rcms_caseid=15442000008198
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 2
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 = 1
RecordId = 16940000012155
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 05/02/2026
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2024/801
court_code = 10634
trn_rcms_caseid = 12497000010184
pre_case_purpose = 1000492
pre_hear_date = 04/12/2025
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=16940000012155
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/02/2026 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/801
Param Type = c
court_code=10634
Param Type = c
trn_rcms_caseid=12497000010184
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012156
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 22/01/2026
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2024/832
court_code = 10634
trn_rcms_caseid = 17892000009001
pre_case_purpose = 1000492
pre_hear_date = 04/12/2025
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=16940000012156
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/01/2026 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/832
Param Type = c
court_code=10634
Param Type = c
trn_rcms_caseid=17892000009001
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 2
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 = 16940000012157
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_case_purpose = 1000492
new_case_purpose = 1000492
next_hear_date = 05/02/2026
pre_hear_date = 04/12/2025
court_code = 10634
case_no = 2024/914
trn_rcms_caseid = 10843000008836
adjourn_remark = 
adjourn_type = 0
isadjourn = NO
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=16940000012157
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=05/02/2026 00:00:00
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = c
court_code=10634
Param Type = c
case_no=2024/914
Param Type = c
trn_rcms_caseid=10843000008836
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,new_case_purpose,next_hear_date,pre_hear_date,court_code,case_no,trn_rcms_caseid,adjourn_remark,adjourn_type,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,null,:adjourn_type,:isadjourn,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012158
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trn_rcms_caseid = 10991000009123
new_case_purpose = 1000492
next_hear_date = 22/01/2026
pre_case_purpose = 1000492
court_code = 10634
case_no = 2024/926
pre_hear_date = 04/12/2025
adjourn_type = 0
isadjourn = NO
adjourn_remark = 
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=16940000012158
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=10991000009123
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=22/01/2026 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=10634
Param Type = c
case_no=2024/926
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,new_case_purpose,next_hear_date,pre_case_purpose,court_code,case_no,pre_hear_date,adjourn_type,isadjourn,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,:trn_rcms_caseid,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,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 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012159
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
next_hear_date = 05/02/2026
isadjourn = NO
new_case_purpose = 1000492
pre_hear_date = 04/12/2025
pre_case_purpose = 1000492
trn_rcms_caseid = 13046000008778
court_code = 10634
adjourn_remark = 
case_no = 2024/972
adjourn_type = 0
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=16940000012159
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/02/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=13046000008778
Param Type = c
court_code=10634
Param Type = c
case_no=2024/972
Param Type = c
adjourn_type=0
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,isadjourn,new_case_purpose,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,adjourn_remark,case_no,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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,null,:case_no,: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 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012160
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 04/12/2025
pre_case_purpose = 18473000000000
trn_rcms_caseid = 12682000010121
court_code = 10634
case_no = 2025/289
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 11/12/2025
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=16940000012160
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=12682000010121
Param Type = c
court_code=10634
Param Type = c
case_no=2025/289
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=11/12/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012161
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 04/12/2025
pre_case_purpose = 18473000000000
trn_rcms_caseid = 14694000009459
court_code = 10634
case_no = 2025/34
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 26/12/2025
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=16940000012161
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=14694000009459
Param Type = c
court_code=10634
Param Type = c
case_no=2025/34
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=26/12/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 16940000012162
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 7
court_code = 10634
case_no = 2025/426
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
next_hear_date = 26/12/2025
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
trn_rcms_caseid = 11512000011650
pre_hear_date = 04/12/2025
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=16940000012162
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10634
Param Type = c
case_no=2025/426
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=26/12/2025 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=11512000011650
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,case_no,isadjourn,adjourn_remark,adjourn_type,next_hear_date,new_case_purpose,pre_case_purpose,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,:court_code,:case_no,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,: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 = 2
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012163
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_case_purpose = 18473000000000
trn_rcms_caseid = 18123000010337
court_code = 10634
pre_hear_date = 04/12/2025
new_case_purpose = 18473000000000
adjourn_type = 0
adjourn_remark = 
next_hear_date = 26/12/2025
isadjourn = NO
case_no = 2025/492
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=16940000012163
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=18123000010337
Param Type = c
court_code=10634
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=26/12/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2025/492
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_case_purpose,trn_rcms_caseid,court_code,pre_hear_date,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:trn_rcms_caseid,:court_code,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,:case_no,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 16940000012164
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
new_case_purpose = 18473000000000
next_hear_date = 26/12/2025
adjourn_type = 0
isadjourn = NO
adjourn_remark = 
trn_rcms_caseid = 18812000008966
court_code = 10634
pre_hear_date = 04/12/2025
case_no = 2025/77
pre_case_purpose = 18473000000000
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=16940000012164
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=26/12/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=18812000008966
Param Type = c
court_code=10634
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = c
case_no=2025/77
Param Type = n
pre_case_purpose=18473000000000
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,new_case_purpose,next_hear_date,adjourn_type,isadjourn,adjourn_remark,trn_rcms_caseid,court_code,pre_hear_date,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,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:trn_rcms_caseid,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),: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 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 16940000012165
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 04/12/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 18252000009982
court_code = 10634
case_no = 2025/304
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 15/01/2026
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=16940000012165
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=18252000009982
Param Type = c
court_code=10634
Param Type = c
case_no=2025/304
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=15/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,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 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012166
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark = 
trn_rcms_caseid = 18384000009279
adjourn_type = 0
court_code = 10634
case_no = 2025/305
pre_hear_date = 04/12/2025
new_case_purpose = 18678000000000
next_hear_date = 15/01/2026
pre_case_purpose = 18678000000000
isadjourn = NO
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=16940000012166
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=18384000009279
Param Type = c
adjourn_type=0
Param Type = c
court_code=10634
Param Type = c
case_no=2025/305
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=15/01/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,adjourn_type,court_code,case_no,pre_hear_date,new_case_purpose,next_hear_date,pre_case_purpose,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,null,:trn_rcms_caseid,:adjourn_type,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,: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 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012167
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark = 
trn_rcms_caseid = 17767000009620
pre_hear_date = 04/12/2025
court_code = 10634
case_no = 2025/417
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 15/01/2026
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=16940000012167
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=17767000009620
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = c
court_code=10634
Param Type = c
case_no=2025/417
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=15/01/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012168
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 13416000010172
pre_hear_date = 04/12/2025
court_code = 10634
case_no = 2025/432
next_hear_date = 28/01/2026
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=16940000012168
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13416000010172
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = c
court_code=10634
Param Type = c
case_no=2025/432
Param Type = c
next_hear_date=28/01/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=19
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 = 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 = 16940000012169
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 13504000011485
case_no = 2025/433
new_case_purpose = 18678000000000
pre_hear_date = 04/12/2025
next_hear_date = 28/01/2026
isadjourn = NO
court_code = 10634
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=16940000012169
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13504000011485
Param Type = c
case_no=2025/433
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = c
next_hear_date=28/01/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
court_code=10634
Param Type = n
pre_case_purpose=18678000000000
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,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,new_case_purpose,pre_hear_date,next_hear_date,isadjourn,court_code,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,:trn_rcms_caseid,:case_no,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 16
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012170
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
trn_rcms_caseid = 19242000011629
case_no = 2025/474
court_code = 10634
pre_hear_date = 04/12/2025
next_hear_date = 17/12/2025
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=16940000012170
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:12
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=19242000011629
Param Type = c
case_no=2025/474
Param Type = c
court_code=10634
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = c
next_hear_date=17/12/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
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,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 = 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 = 16940000012171
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
isadjourn = NO
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 10281000009368
case_no = 2025/153
court_code = 10634
pre_hear_date = 04/12/2025
next_hear_date = 21/01/2026
new_case_purpose = 1000492
pre_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=16940000012171
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:13
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=10281000009368
Param Type = c
case_no=2025/153
Param Type = c
court_code=10634
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = c
next_hear_date=21/01/2026 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
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,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 1
RecordId = 16940000012172
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 = 21/01/2026
case_no = 2025/161
court_code = 10634
trn_rcms_caseid = 10401000009618
new_case_purpose = 1000492
pre_case_purpose = 1000492
pre_hear_date = 04/12/2025
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=16940000012172
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:13
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:13
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=21/01/2026 00:00:00
Param Type = c
case_no=2025/161
Param Type = c
court_code=10634
Param Type = c
trn_rcms_caseid=10401000009618
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,case_no,court_code,trn_rcms_caseid,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'),:case_no,:court_code,:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 16940000012173
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 28/01/2026
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 13610000009658
case_no = 2025/206
court_code = 10634
new_case_purpose = 1000492
pre_case_purpose = 1000492
pre_hear_date = 04/12/2025
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=16940000012173
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:13
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/01/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13610000009658
Param Type = c
case_no=2025/206
Param Type = c
court_code=10634
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=04/12/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012174
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 28/01/2026
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 1000492
case_no = 2025/329
court_code = 10634
trn_rcms_caseid = 13095000009436
pre_case_purpose = 1000492
pre_hear_date = 04/12/2025
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=16940000012174
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:13
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/01/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000492
Param Type = c
case_no=2025/329
Param Type = c
court_code=10634
Param Type = c
trn_rcms_caseid=13095000009436
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=04/12/2025 00:00:00
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,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012175
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 11/12/2025
new_case_purpose = 12555000000002
adjourn_remark = 
adjourn_type = 0
isadjourn = NO
case_no = 2025/584
court_code = 10634
trn_rcms_caseid = 18037000014210
pre_case_purpose = 12555000000002
pre_hear_date = 04/12/2025
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=16940000012175
Param Type = n
trn_rcms_mhearingid=16940000012149
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:13
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/12/2025 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2025/584
Param Type = c
court_code=10634
Param Type = c
trn_rcms_caseid=18037000014210
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
pre_hear_date=04/12/2025 00:00:00
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,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 = 3974021471650

>>Executing genmaps

>>Posting from trcmf to tchdh from row 1

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18843000008786 idvalue 0
Mapped case_no Row = 1 value = 2024/105 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10634
trn_rcms_caseregid = 18843000008786
case_no = 2024/105
prev_hearing_date = 04/12/2025
hearing_date = 05/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 = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012176
MapName trcmf1
SourceId 16940000012150
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 = 1000492
hearing_date = 05/02/2026
case_no = 2024/105
trn_rcms_caseregid = 18843000008786
court_code = 10634
case_purpose = 1000492
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012176
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012150
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:13
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/02/2026 00:00:00
Param Type = c
case_no=2024/105
Param Type = c
trn_rcms_caseregid=18843000008786
Param Type = c
court_code=10634
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 2

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12747000008888 idvalue 0
Mapped case_no Row = 1 value = 2024/1384 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10634
trn_rcms_caseregid = 12747000008888
case_no = 2024/1384
prev_hearing_date = 04/12/2025
hearing_date = 05/02/2026
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16940000012177
MapName trcmf1
SourceId 16940000012151
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 = 1000492
hearing_date = 05/02/2026
case_no = 2024/1384
trn_rcms_caseregid = 12747000008888
court_code = 10634
case_purpose = 1000492
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012177
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012151
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:14
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/02/2026 00:00:00
Param Type = c
case_no=2024/1384
Param Type = c
trn_rcms_caseregid=12747000008888
Param Type = c
court_code=10634
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 3

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13281000007644 idvalue 0
Mapped case_no Row = 1 value = 2024/694 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10634
trn_rcms_caseregid = 13281000007644
case_no = 2024/694
prev_hearing_date = 04/12/2025
hearing_date = 05/02/2026
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16940000012178
MapName trcmf1
SourceId 16940000012152
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/02/2026
case_no = 2024/694
trn_rcms_caseregid = 13281000007644
court_code = 10634
case_purpose = 1000492
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012178
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012152
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:15
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:15
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/02/2026 00:00:00
Param Type = c
case_no=2024/694
Param Type = c
trn_rcms_caseregid=13281000007644
Param Type = c
court_code=10634
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 4

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15428000007725 idvalue 0
Mapped case_no Row = 1 value = 2024/70 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 22/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10634
trn_rcms_caseregid = 15428000007725
case_no = 2024/70
prev_hearing_date = 04/12/2025
hearing_date = 22/01/2026
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16940000012179
MapName trcmf1
SourceId 16940000012153
Select sysdate as sdt from dual
Time elapsed = 1
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 = 1000492
hearing_date = 22/01/2026
case_no = 2024/70
trn_rcms_caseregid = 15428000007725
court_code = 10634
case_purpose = 1000492
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012179
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012153
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:15
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:15
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=22/01/2026 00:00:00
Param Type = c
case_no=2024/70
Param Type = c
trn_rcms_caseregid=15428000007725
Param Type = c
court_code=10634
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 5

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15442000008198 idvalue 0
Mapped case_no Row = 1 value = 2024/74 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10634
trn_rcms_caseregid = 15442000008198
case_no = 2024/74
prev_hearing_date = 04/12/2025
hearing_date = 05/02/2026
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012180
MapName trcmf1
SourceId 16940000012154
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/02/2026
case_no = 2024/74
trn_rcms_caseregid = 15442000008198
court_code = 10634
case_purpose = 1000492
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012180
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012154
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:16
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:16
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/02/2026 00:00:00
Param Type = c
case_no=2024/74
Param Type = c
trn_rcms_caseregid=15442000008198
Param Type = c
court_code=10634
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 6

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12497000010184 idvalue 0
Mapped case_no Row = 1 value = 2024/801 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10634
trn_rcms_caseregid = 12497000010184
case_no = 2024/801
prev_hearing_date = 04/12/2025
hearing_date = 05/02/2026
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 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 = 16940000012181
MapName trcmf1
SourceId 16940000012155
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/02/2026
case_no = 2024/801
trn_rcms_caseregid = 12497000010184
court_code = 10634
case_purpose = 1000492
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012181
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012155
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:17
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/02/2026 00:00:00
Param Type = c
case_no=2024/801
Param Type = c
trn_rcms_caseregid=12497000010184
Param Type = c
court_code=10634
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 7

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17892000009001 idvalue 0
Mapped case_no Row = 1 value = 2024/832 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 22/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10634
trn_rcms_caseregid = 17892000009001
case_no = 2024/832
prev_hearing_date = 04/12/2025
hearing_date = 22/01/2026
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16940000012182
MapName trcmf1
SourceId 16940000012156
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 22/01/2026
case_no = 2024/832
trn_rcms_caseregid = 17892000009001
court_code = 10634
case_purpose = 1000492
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012182
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012156
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:17
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=22/01/2026 00:00:00
Param Type = c
case_no=2024/832
Param Type = c
trn_rcms_caseregid=17892000009001
Param Type = c
court_code=10634
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 8

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10843000008836 idvalue 0
Mapped case_no Row = 1 value = 2024/914 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10634
trn_rcms_caseregid = 10843000008836
case_no = 2024/914
prev_hearing_date = 04/12/2025
hearing_date = 05/02/2026
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16940000012183
MapName trcmf1
SourceId 16940000012157
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/02/2026
case_no = 2024/914
trn_rcms_caseregid = 10843000008836
court_code = 10634
case_purpose = 1000492
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012183
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012157
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:18
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/02/2026 00:00:00
Param Type = c
case_no=2024/914
Param Type = c
trn_rcms_caseregid=10843000008836
Param Type = c
court_code=10634
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 9

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10991000009123 idvalue 0
Mapped case_no Row = 1 value = 2024/926 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 22/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10634
trn_rcms_caseregid = 10991000009123
case_no = 2024/926
prev_hearing_date = 04/12/2025
hearing_date = 22/01/2026
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16940000012184
MapName trcmf1
SourceId 16940000012158
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 22/01/2026
case_no = 2024/926
trn_rcms_caseregid = 10991000009123
court_code = 10634
case_purpose = 1000492
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012184
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012158
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:19
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=22/01/2026 00:00:00
Param Type = c
case_no=2024/926
Param Type = c
trn_rcms_caseregid=10991000009123
Param Type = c
court_code=10634
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 10

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13046000008778 idvalue 0
Mapped case_no Row = 1 value = 2024/972 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10634
trn_rcms_caseregid = 13046000008778
case_no = 2024/972
prev_hearing_date = 04/12/2025
hearing_date = 05/02/2026
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 0
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 = 16940000012185
MapName trcmf1
SourceId 16940000012159
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/02/2026
case_no = 2024/972
trn_rcms_caseregid = 13046000008778
court_code = 10634
case_purpose = 1000492
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012185
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012159
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:20
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/02/2026 00:00:00
Param Type = c
case_no=2024/972
Param Type = c
trn_rcms_caseregid=13046000008778
Param Type = c
court_code=10634
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 11

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12682000010121 idvalue 0
Mapped case_no Row = 1 value = 2025/289 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/12/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10634
trn_rcms_caseregid = 12682000010121
case_no = 2025/289
prev_hearing_date = 04/12/2025
hearing_date = 11/12/2025
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purposename=???
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=???
Time elapsed = 3
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012186
MapName trcmf1
SourceId 16940000012160
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 = 18473000000000
hearing_date = 11/12/2025
case_no = 2025/289
trn_rcms_caseregid = 12682000010121
court_code = 10634
case_purpose = 18473000000000
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012186
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012160
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:20
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:20
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=11/12/2025 00:00:00
Param Type = c
case_no=2025/289
Param Type = c
trn_rcms_caseregid=12682000010121
Param Type = c
court_code=10634
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 12

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14694000009459 idvalue 0
Mapped case_no Row = 1 value = 2025/34 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 26/12/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10634
trn_rcms_caseregid = 14694000009459
case_no = 2025/34
prev_hearing_date = 04/12/2025
hearing_date = 26/12/2025
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 16940000012187
MapName trcmf1
SourceId 16940000012161
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 = 18473000000000
hearing_date = 26/12/2025
case_no = 2025/34
trn_rcms_caseregid = 14694000009459
court_code = 10634
case_purpose = 18473000000000
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012187
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012161
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:21
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=26/12/2025 00:00:00
Param Type = c
case_no=2025/34
Param Type = c
trn_rcms_caseregid=14694000009459
Param Type = c
court_code=10634
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 13

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11512000011650 idvalue 0
Mapped case_no Row = 1 value = 2025/426 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 26/12/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10634
trn_rcms_caseregid = 11512000011650
case_no = 2025/426
prev_hearing_date = 04/12/2025
hearing_date = 26/12/2025
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012188
MapName trcmf1
SourceId 16940000012162
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 26/12/2025
case_no = 2025/426
trn_rcms_caseregid = 11512000011650
court_code = 10634
case_purpose = 18473000000000
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012188
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012162
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:22
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:22
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=26/12/2025 00:00:00
Param Type = c
case_no=2025/426
Param Type = c
trn_rcms_caseregid=11512000011650
Param Type = c
court_code=10634
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 14

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18123000010337 idvalue 0
Mapped case_no Row = 1 value = 2025/492 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 26/12/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10634
trn_rcms_caseregid = 18123000010337
case_no = 2025/492
prev_hearing_date = 04/12/2025
hearing_date = 26/12/2025
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012189
MapName trcmf1
SourceId 16940000012163
Select sysdate as sdt from dual
Time elapsed = 3
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 = 18473000000000
hearing_date = 26/12/2025
case_no = 2025/492
trn_rcms_caseregid = 18123000010337
court_code = 10634
case_purpose = 18473000000000
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012189
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012163
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:23
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=26/12/2025 00:00:00
Param Type = c
case_no=2025/492
Param Type = c
trn_rcms_caseregid=18123000010337
Param Type = c
court_code=10634
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 15

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18812000008966 idvalue 0
Mapped case_no Row = 1 value = 2025/77 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 26/12/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10634
trn_rcms_caseregid = 18812000008966
case_no = 2025/77
prev_hearing_date = 04/12/2025
hearing_date = 26/12/2025
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012190
MapName trcmf1
SourceId 16940000012164
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 26/12/2025
case_no = 2025/77
trn_rcms_caseregid = 18812000008966
court_code = 10634
case_purpose = 18473000000000
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012190
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012164
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:23
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=26/12/2025 00:00:00
Param Type = c
case_no=2025/77
Param Type = c
trn_rcms_caseregid=18812000008966
Param Type = c
court_code=10634
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 16

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18252000009982 idvalue 0
Mapped case_no Row = 1 value = 2025/304 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10634
trn_rcms_caseregid = 18252000009982
case_no = 2025/304
prev_hearing_date = 04/12/2025
hearing_date = 15/01/2026
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=????
Time elapsed = 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 = 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 = 16940000012191
MapName trcmf1
SourceId 16940000012165
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 15/01/2026
case_no = 2025/304
trn_rcms_caseregid = 18252000009982
court_code = 10634
case_purpose = 18678000000000
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012191
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012165
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:24
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=15/01/2026 00:00:00
Param Type = c
case_no=2025/304
Param Type = c
trn_rcms_caseregid=18252000009982
Param Type = c
court_code=10634
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 17

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18384000009279 idvalue 0
Mapped case_no Row = 1 value = 2025/305 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10634
trn_rcms_caseregid = 18384000009279
case_no = 2025/305
prev_hearing_date = 04/12/2025
hearing_date = 15/01/2026
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 0
RecordId = 16940000012192
MapName trcmf1
SourceId 16940000012166
Select sysdate as sdt from dual
Time elapsed = 3
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 = 15/01/2026
case_no = 2025/305
trn_rcms_caseregid = 18384000009279
court_code = 10634
case_purpose = 18678000000000
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012192
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012166
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:25
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=15/01/2026 00:00:00
Param Type = c
case_no=2025/305
Param Type = c
trn_rcms_caseregid=18384000009279
Param Type = c
court_code=10634
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 18

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17767000009620 idvalue 0
Mapped case_no Row = 1 value = 2025/417 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/01/2026 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10634
trn_rcms_caseregid = 17767000009620
case_no = 2025/417
prev_hearing_date = 04/12/2025
hearing_date = 15/01/2026
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012193
MapName trcmf1
SourceId 16940000012167
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 = 15/01/2026
case_no = 2025/417
trn_rcms_caseregid = 17767000009620
court_code = 10634
case_purpose = 18678000000000
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012193
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012167
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:26
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=15/01/2026 00:00:00
Param Type = c
case_no=2025/417
Param Type = c
trn_rcms_caseregid=17767000009620
Param Type = c
court_code=10634
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 19

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13416000010172 idvalue 0
Mapped case_no Row = 1 value = 2025/432 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10634
trn_rcms_caseregid = 13416000010172
case_no = 2025/432
prev_hearing_date = 04/12/2025
hearing_date = 28/01/2026
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012194
MapName trcmf1
SourceId 16940000012168
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 = 28/01/2026
case_no = 2025/432
trn_rcms_caseregid = 13416000010172
court_code = 10634
case_purpose = 18678000000000
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012194
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012168
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:26
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=28/01/2026 00:00:00
Param Type = c
case_no=2025/432
Param Type = c
trn_rcms_caseregid=13416000010172
Param Type = c
court_code=10634
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 20

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13504000011485 idvalue 0
Mapped case_no Row = 1 value = 2025/433 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10634
trn_rcms_caseregid = 13504000011485
case_no = 2025/433
prev_hearing_date = 04/12/2025
hearing_date = 28/01/2026
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 16940000012195
MapName trcmf1
SourceId 16940000012169
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 28/01/2026
case_no = 2025/433
trn_rcms_caseregid = 13504000011485
court_code = 10634
case_purpose = 18678000000000
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012195
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012169
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:27
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=28/01/2026 00:00:00
Param Type = c
case_no=2025/433
Param Type = c
trn_rcms_caseregid=13504000011485
Param Type = c
court_code=10634
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 21

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19242000011629 idvalue 0
Mapped case_no Row = 1 value = 2025/474 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 17/12/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10634
trn_rcms_caseregid = 19242000011629
case_no = 2025/474
prev_hearing_date = 04/12/2025
hearing_date = 17/12/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 16940000012196
MapName trcmf1
SourceId 16940000012170
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 = 17/12/2025
case_no = 2025/474
trn_rcms_caseregid = 19242000011629
court_code = 10634
case_purpose = 18678000000000
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012196
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012170
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:28
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=17/12/2025 00:00:00
Param Type = c
case_no=2025/474
Param Type = c
trn_rcms_caseregid=19242000011629
Param Type = c
court_code=10634
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 22

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10281000009368 idvalue 0
Mapped case_no Row = 1 value = 2025/153 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 21/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 = 10634
trn_rcms_caseregid = 10281000009368
case_no = 2025/153
prev_hearing_date = 04/12/2025
hearing_date = 21/01/2026
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purposename=?????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=?????
Time elapsed = 2
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 16940000012197
MapName trcmf1
SourceId 16940000012171
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 21/01/2026
case_no = 2025/153
trn_rcms_caseregid = 10281000009368
court_code = 10634
case_purpose = 1000492
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012197
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012171
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:29
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=21/01/2026 00:00:00
Param Type = c
case_no=2025/153
Param Type = c
trn_rcms_caseregid=10281000009368
Param Type = c
court_code=10634
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 23

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10401000009618 idvalue 0
Mapped case_no Row = 1 value = 2025/161 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 21/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 = 10634
trn_rcms_caseregid = 10401000009618
case_no = 2025/161
prev_hearing_date = 04/12/2025
hearing_date = 21/01/2026
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 1
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 = 16940000012198
MapName trcmf1
SourceId 16940000012172
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 21/01/2026
case_no = 2025/161
trn_rcms_caseregid = 10401000009618
court_code = 10634
case_purpose = 1000492
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012198
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012172
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:29
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=21/01/2026 00:00:00
Param Type = c
case_no=2025/161
Param Type = c
trn_rcms_caseregid=10401000009618
Param Type = c
court_code=10634
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 24

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13610000009658 idvalue 0
Mapped case_no Row = 1 value = 2025/206 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10634
trn_rcms_caseregid = 13610000009658
case_no = 2025/206
prev_hearing_date = 04/12/2025
hearing_date = 28/01/2026
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 16940000012199
MapName trcmf1
SourceId 16940000012173
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 = 1000492
hearing_date = 28/01/2026
case_no = 2025/206
trn_rcms_caseregid = 13610000009658
court_code = 10634
case_purpose = 1000492
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012199
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012173
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:30
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/01/2026 00:00:00
Param Type = c
case_no=2025/206
Param Type = c
trn_rcms_caseregid=13610000009658
Param Type = c
court_code=10634
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 25

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13095000009436 idvalue 0
Mapped case_no Row = 1 value = 2025/329 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10634
trn_rcms_caseregid = 13095000009436
case_no = 2025/329
prev_hearing_date = 04/12/2025
hearing_date = 28/01/2026
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 0
RecordId = 16940000012200
MapName trcmf1
SourceId 16940000012174
Select sysdate as sdt from dual
Time elapsed = 1
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 = 1000492
hearing_date = 28/01/2026
case_no = 2025/329
trn_rcms_caseregid = 13095000009436
court_code = 10634
case_purpose = 1000492
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012200
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012174
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:31
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/01/2026 00:00:00
Param Type = c
case_no=2025/329
Param Type = c
trn_rcms_caseregid=13095000009436
Param Type = c
court_code=10634
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 26

>>Mapping
Mapped court_code Row = 1 value = 10634 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18037000014210 idvalue 0
Mapped case_no Row = 1 value = 2025/584 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 11/12/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10634
trn_rcms_caseregid = 18037000014210
case_no = 2025/584
prev_hearing_date = 04/12/2025
hearing_date = 11/12/2025
prev_case_purposename = ???? ????????? ????
prev_case_purpose = 
prev_case_purposename=???? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=???? ????????? ????
Time elapsed = 3
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16940000012201
MapName trcmf1
SourceId 16940000012175
Select sysdate as sdt from dual
Time elapsed = 3
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 = 12555000000002
hearing_date = 11/12/2025
case_no = 2025/584
trn_rcms_caseregid = 18037000014210
court_code = 10634
case_purpose = 12555000000002
prev_hearing_date = 04/12/2025
Posting record
Param Type = n
trn_rcms_case_histid=16940000012201
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16940000012175
Param Type = c
cancel=F
Param Type = c
createdby=ADC_ajmer
Param Type = c
createdon=04/12/2025 14:51:32
Param Type = c
username=ADC_ajmer
Param Type = c
modifiedon=04/12/2025 14:51:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=11/12/2025 00:00:00
Param Type = c
case_no=2025/584
Param Type = c
trn_rcms_caseregid=18037000014210
Param Type = c
court_code=10634
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=04/12/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))

Time elapsed for Gen Map = 3974021491417
Time elapsed for MD Map = 3974021491418
Time elapsed for Save History = 3974021491418
Time elapsed for Save Attachment = 3974021491418
Time elapsed for After Save WF Exec = 3974021491419
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"16940000012149"}]}
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=ADC_ajmer
Param Type = c
calledon=04/12/2025 14:51:10
Param Type = c
callfinished=04/12/2025 14:51:31
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=20833
Param Type = n
dbtimetaken=20029
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