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 gcmsACEM_dosa827ccb0eea8a706c4c34a16891f84e7brctcr001054610037014921000000046105461211800000002410037101330000077822023/5610546-10037#2023/5618/08/20250F014921000000046105461211800000002410037140040000073202023/4610546-10037#2023/4618/08/20250F014921000000046105461211800000002410037140150000077722023/4710546-10037#2023/4718/08/20250F014921000000046105461211800000002410037120910000058722022/7310546-10037#2022/7318/08/20250F014921000000046105461211800000002410037121100000079052022/7410546-10037#2022/7418/08/20250F014921000000046105461211800000002410037129460000047882020/0010710546-10037#2020/0010718/08/20250F014921000000046105461211800000002410037130740000054032020/0010810546-10037#2020/0010818/08/20250F014921000000046105461211800000002410037156680000015012018/0006710546-10037#2018/0006718/08/20250F014921000000046105461211800000002410037160850000014352018/0007010546-10037#2018/0007018/08/20250F014921000000046105461211800000002410037106040000008142015/0068610546-10037#2015/0068618/08/20250F014921000000046105461211800000002410037192610000117722025/8210546-10037#2025/8218/08/20250F014921000000046105461211800000002410037193000000109602025/8310546-10037#2025/8318/08/20250F014921000000046105461211800000002410037185530000091052025/7110546-10037#2025/7118/08/20250F014921000000046105461211800000002410037185970000116162025/7210546-10037#2025/7218/08/20250F014921000000046105461211800000002410037196820000107812025/6110546-10037#2025/6118/08/20250F014921000000046105461211800000002410037197320000106512025/6210546-10037#2025/6218/08/20250F014921000000046105461211800000002410037193350000100482025/5910546-10037#2025/5918/08/20250F014921000000046105461211800000002410037194180000106682025/6010546-10037#2025/6018/08/20250F014921000000046105461211800000002410037192580000081852023/9510546-10037#2023/9518/08/20250F014921000000046105461211800000002410037192760000080632023/9610546-10037#2023/9618/08/20250F014921000000046105461211800000002410037191380000077112023/9310546-10037#2023/9318/08/20250F014921000000046105461211800000002410037191950000087822023/9410546-10037#2023/9418/08/20250F014921000000046105461211800000002410037192910000077822023/1010546-10037#2023/1018/08/20250F014921000000046105461211800000002410037193400000066772023/1110546-10037#2023/1118/08/20250F014921000000046105461211800000002410037172090000074032022/2110546-10037#2022/2118/08/20250F014921000000046105461211800000002410037172170000074412022/2210546-10037#2022/2218/08/20250F014921000000046105461211800000002410037123840000020322018/0058410546-10037#2018/0058418/08/20250F014921000000046105461211800000002410037124160000023042018/0058510546-10037#2018/0058518/08/20250F014921000000046105461211800000002410037123220000027122018/0058210546-10037#2018/0058218/08/20250F014921000000046105461211800000002410037123360000028332018/0058310546-10037#2018/0058318/08/20250F014921000000046105461211800000002410037148970000021352018/0052710546-10037#2018/0052718/08/20250F014921000000046105461211800000002410037149320000019002018/0052810546-10037#2018/0052818/08/20250F014921000000046105461211800000002410037193380000017082018/0050910546-10037#2018/0050918/08/20250F014921000000046105461211800000002410037193670000021352018/0051010546-10037#2018/0051018/08/20250F0149210000000461054612118000000024100373216132009/0001610546-10037#2009/0001618/08/20250F014921000000046105461211800000002410037108280000004842016/0009810546-10037#2016/0009818/08/20250F014921000000046105461211800000002410037131820000000692015/0041910546-10037#2015/0041918/08/20250F0149210000000461054612118000000024100373213312013/0000610546-10037#2013/0000618/08/20250F014921000000046105461211800000002410037179300000095882024/6810546-10037#2024/6818/08/20250F014921000000046105461211800000002410037179790000092542024/6910546-10037#2024/6918/08/20250F014921000000046105461211800000002410037120890000064602022/3410546-10037#2022/3418/08/20250F014921000000046105461211800000002410037121090000060142022/3510546-10037#2022/3518/08/20250F014921000000046105461211800000002410037163990000080712022/22810546-10037#2022/22818/08/20250F014921000000046105461211800000002410037164020000065922022/22910546-10037#2022/22918/08/20250F014921000000046105461211800000002410037130290000067522022/10410546-10037#2022/10418/08/20250F014921000000046105461211800000002410037130500000071842022/10510546-10037#2022/10518/08/20250F014921000000046105461211800000002410037132870000070402021/15210546-10037#2021/15218/08/20250F014921000000046105461211800000002410037129040000020892018/0032210546-10037#2018/0032218/08/20250F014921000000046105461211800000002410037100220000019992017/0018410546-10037#2017/0018418/08/20250F014921000000046105461211800000002410037129260000031532012/0006510546-10037#2012/0006518/08/20250F014921000000046105461211800000002410037190550000108152025/5710546-10037#2025/5718/08/20250F014921000000046105461211800000002410037191620000096052025/5810546-10037#2025/5818/08/20250F014921000000046105461211800000002410037193480000012082018/0008710546-10037#2018/0008718/08/20250F Executing Savedata webservice ----------------------------- Received JSON : {"savedata":{"axpapp":"gcms","username":"ACEM_dosa","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"rctcr","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"court_code":"10546","trans_ccode":"10037"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"10133000007782","case_no":"2023/56","requestno":"10546-10037#2023/56","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"002","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"14004000007320","case_no":"2023/46","requestno":"10546-10037#2023/46","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"003","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"14015000007772","case_no":"2023/47","requestno":"10546-10037#2023/47","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"004","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12091000005872","case_no":"2022/73","requestno":"10546-10037#2022/73","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"005","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12110000007905","case_no":"2022/74","requestno":"10546-10037#2022/74","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"006","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12946000004788","case_no":"2020/00107","requestno":"10546-10037#2020/00107","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"007","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"13074000005403","case_no":"2020/00108","requestno":"10546-10037#2020/00108","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"008","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"15668000001501","case_no":"2018/00067","requestno":"10546-10037#2018/00067","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"009","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"16085000001435","case_no":"2018/00070","requestno":"10546-10037#2018/00070","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0010","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"10604000000814","case_no":"2015/00686","requestno":"10546-10037#2015/00686","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0011","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19261000011772","case_no":"2025/82","requestno":"10546-10037#2025/82","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0012","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19300000010960","case_no":"2025/83","requestno":"10546-10037#2025/83","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0013","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"18553000009105","case_no":"2025/71","requestno":"10546-10037#2025/71","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0014","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"18597000011616","case_no":"2025/72","requestno":"10546-10037#2025/72","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0015","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19682000010781","case_no":"2025/61","requestno":"10546-10037#2025/61","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0016","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19732000010651","case_no":"2025/62","requestno":"10546-10037#2025/62","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0017","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19335000010048","case_no":"2025/59","requestno":"10546-10037#2025/59","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0018","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19418000010668","case_no":"2025/60","requestno":"10546-10037#2025/60","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0019","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19258000008185","case_no":"2023/95","requestno":"10546-10037#2023/95","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0020","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19276000008063","case_no":"2023/96","requestno":"10546-10037#2023/96","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0021","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19138000007711","case_no":"2023/93","requestno":"10546-10037#2023/93","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0022","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19195000008782","case_no":"2023/94","requestno":"10546-10037#2023/94","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0023","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19291000007782","case_no":"2023/10","requestno":"10546-10037#2023/10","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0024","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19340000006677","case_no":"2023/11","requestno":"10546-10037#2023/11","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0025","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"17209000007403","case_no":"2022/21","requestno":"10546-10037#2022/21","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0026","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"17217000007441","case_no":"2022/22","requestno":"10546-10037#2022/22","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0027","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12384000002032","case_no":"2018/00584","requestno":"10546-10037#2018/00584","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0028","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12416000002304","case_no":"2018/00585","requestno":"10546-10037#2018/00585","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0029","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12322000002712","case_no":"2018/00582","requestno":"10546-10037#2018/00582","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0030","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12336000002833","case_no":"2018/00583","requestno":"10546-10037#2018/00583","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0031","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"14897000002135","case_no":"2018/00527","requestno":"10546-10037#2018/00527","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0032","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"14932000001900","case_no":"2018/00528","requestno":"10546-10037#2018/00528","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0033","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19338000001708","case_no":"2018/00509","requestno":"10546-10037#2018/00509","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0034","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19367000002135","case_no":"2018/00510","requestno":"10546-10037#2018/00510","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0035","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"321613","case_no":"2009/00016","requestno":"10546-10037#2009/00016","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0036","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"10828000000484","case_no":"2016/00098","requestno":"10546-10037#2016/00098","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0037","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"13182000000069","case_no":"2015/00419","requestno":"10546-10037#2015/00419","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0038","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"321331","case_no":"2013/00006","requestno":"10546-10037#2013/00006","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0039","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"17930000009588","case_no":"2024/68","requestno":"10546-10037#2024/68","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0040","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"17979000009254","case_no":"2024/69","requestno":"10546-10037#2024/69","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0041","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12089000006460","case_no":"2022/34","requestno":"10546-10037#2022/34","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0042","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12109000006014","case_no":"2022/35","requestno":"10546-10037#2022/35","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0043","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"16399000008071","case_no":"2022/228","requestno":"10546-10037#2022/228","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0044","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"16402000006592","case_no":"2022/229","requestno":"10546-10037#2022/229","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0045","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"13029000006752","case_no":"2022/104","requestno":"10546-10037#2022/104","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0046","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"13050000007184","case_no":"2022/105","requestno":"10546-10037#2022/105","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0047","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"13287000007040","case_no":"2021/152","requestno":"10546-10037#2021/152","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0048","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12904000002089","case_no":"2018/00322","requestno":"10546-10037#2018/00322","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0049","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"10022000001999","case_no":"2017/00184","requestno":"10546-10037#2017/00184","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0050","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12926000003153","case_no":"2012/00065","requestno":"10546-10037#2012/00065","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0051","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19055000010815","case_no":"2025/57","requestno":"10546-10037#2025/57","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0052","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19162000009605","case_no":"2025/58","requestno":"10546-10037#2025/58","decision_date":"18/08/2025","status":"0","transContFld":"F"}},{"rowno":"0053","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19348000001208","case_no":"2018/00087","requestno":"10546-10037#2018/00087","decision_date":"18/08/2025","status":"0","transContFld":"F"}}]}]}} Verifying username and password User Name : ACEM_dosa Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app' U=acem_dosa Time elapsed = 37 Password checking along with max.no of login specified in app.xml update axusers set logintry = 0 where lower(username) = :U Time elapsed = 3 Result : Verifying completed... Page Access Category : User Name : acem_dosa Select sysdate as sdt from dual Time elapsed = 2 dt=12/12/2025 11:44:53 Select sysdate as sdt from dual Time elapsed = 14 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=acem_dosa dt=12/12/2025 11:44:53 dt=12/12/2025 11:44:53 Time elapsed = 6 User Groups: court_reader select userroles from axusergroups where groupname in ( 'court_reader' ) Time elapsed = 2 User Roles : 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 = 1 Step4 axprops\stm size:4235 Step4-123456 images\Generalized Court Management SystemINRF500250000F00000F 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=ACEM_dosa select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=ACEM_dosa 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=ACEM_dosa select a.court_type from v_axcourts a where a.paxusername= :username order by 1 username=ACEM_dosa Time elapsed = 22 Result of firesql = Result = Evaluating sqlget({m3},{court_type}) Calling function sqlget Result of sqlget = ACEM Result = ACEM Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1}) Calling function firesql username=ACEM_dosa select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1 username=ACEM_dosa Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m4},{court_name_mastid}) Calling function sqlget Result of sqlget = 14921000000046 Result = 14921000000046 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=ACEM_dosa Time elapsed = 13 Result of firesql = Result = Evaluating sqlget({m4},{axusersid}) Calling function sqlget Result of sqlget = 4242 Result = 4242 Evaluating firesql({m4},{select :username as uname from dual}) Calling function firesql select :username as uname from dual username=ACEM_dosa Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m4},{uname}) Calling function sqlget Result of sqlget = ACEM_dosa Result = ACEM_dosa 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=ACEM_dosa Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m4},{COURT_CODE}) Calling function sqlget Result of sqlget = 10546 Result = 10546 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=ACEM_dosa SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=ACEM_dosa Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m7},{DISTNAMEENG}) Calling function sqlget Result of sqlget = Dausa Result = Dausa Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=ACEM_dosa SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=ACEM_dosa Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m8},{COURT_CATEGOTY}) Calling function sqlget Result of sqlget = 10593000000007 Result = 10593000000007 Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid}) Calling function firesql login_userid=4242 select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid login_userid=4242 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=ACEM_dosa Time elapsed = 4 Result of firesql = Result = Evaluating sqlget({m3},{court_type_mastid}) Calling function sqlget Result of sqlget = 10257000000001 Result = 10257000000001 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=ACEM_dosa 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=ACEM_dosa Time elapsed = 3 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=ACEM_dosa 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=ACEM_dosa Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({P1},{ct}) Calling function sqlget Result of sqlget = 17 Result = 17 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_reader') and lower(sname)='rctcr' and stype = 't' ) Time elapsed = 14 select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='rctcr' and stype = 't' Time elapsed = 4 Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno Paramval : court_reader,rctcr,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 : rctcr ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 3 Step4 tstructs\stm size:2355 Step4-0 Step4-1 Step4-2 Step4-3 Step4-4 Step5 Step6 Step9 Evaluating date() Result = Evaluating 0 Result = select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout) tid=rctcr adxinout=o Time elapsed = 14 select * from trn_rcms_transreq where trn_rcms_transreqid=0 Time elapsed = 4 select * from Axusers where 1=2 Time elapsed = 5 select distinct(fldname) from AxTempUserFields Time elapsed = 3 select * from AxAttachWorkflow where lower(transid) = 'rctcr' Time elapsed = 3 Step3 Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : tscd ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 3 Step4 tstructs\stm size:6667 Step4-0 Step4-1 Step4-2 Step4-3 Step4-4 Step5 Step6 Step9 select lpad(' ', 250, ' ') LVAL from dual Time elapsed = 4 Post on approve = False select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout) tid=tscd adxinout=o Time elapsed = 3 select * from trn_rcms_decision where trn_rcms_decisionid=0 Time elapsed = 15 Evaluating date() Result = Evaluating m_courtname Result = Evaluating {AND a1.court_code=:m_courtcode } Result = Evaluating iif(hearing_date>currdate,{Hearing Date Can not be greater Than Today },{T}) Result = Evaluating iif(decision_date>currdate,{Decision Date Can not be greater Than Today },{T}) Result = Evaluating 0 Result = Evaluating {F} Result = Evaluating {F} Result = Evaluating {F} Result = Evaluating court_code+case_no Result = Evaluating username Result = Evaluating {cd.pdf} Result = Evaluating iif(recordid>0,{Decision Updated},{Decision Submitted}) Result = Evaluating iif(recordid>0,{F},{T}) Result = Loading genmaps Step3 Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : tsrcf ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 3 Step4 tstructs\stm size:4166 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=tsrcf adxinout=o Time elapsed = 3 select * from trn_rcms_hearing where trn_rcms_hearingid=0 Time elapsed = 2 Evaluating date() Result = Evaluating { AND a1.court_code = :m_courtcode } Result = Evaluating m_courtname Result = Evaluating case_purpose_name Result = Evaluating {NO} Result = Evaluating {Feedback Submitted} Result = 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 = 3 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 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 = 1 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 = 2 select distinct(schemaname) from axschema where lower(transid)='tscrg' Time elapsed = 2 select trn_rcms_caseregid from trn_rcms_casereg where trn_rcms_caseregid=0 Time elapsed = 2 select case_decision_date from trn_rcms_casereg where trn_rcms_caseregid=0 Time elapsed = 2 select distinct(schemaname) from axschema where lower(transid)='tscrg' Time elapsed = 2 select decision_type from trn_rcms_casereg where trn_rcms_caseregid=0 Time elapsed = 1 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 rctcr >>Frame No 1 currdate = Evaluating - date() Result of date = 12/12/2025 currdate after validation = 12/12/2025 court_code = 10546 trans_ccode = 10037 case_purpose = SELECT b.CASE_PURPOSE_MASTID, b.CASE_PURPOSE_NAME, b.case_purpose_code FROM case_purpose_mast b WHERE CASE_PURPOSE_MASTID = 1025550004746 Time elapsed = 13 case_purpose after validation = ????????? Id = 1025550004746 dec_type = SELECT DECISION_MASTID, DECISION_NAME FROM decision_mast A WHERE court_code = '10006' AND a.DECISION_MASTID = 11782000000706 ORDER BY DECISION_NAME Time elapsed = 14 dec_type after validation = ????????? Id = 11782000000706 time zone difference = 0 >>Writing to tables rctcr Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rctcr' Time elapsed = 2 Saving to table TRN_RCMS_TRANSREQ select * from TRN_RCMS_TRANSREQ where TRN_RCMS_TRANSREQid=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 = 17500000011961 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 1 trans_ccode = 10037 court_code = 10546 Posting record Param Type = n trn_rcms_transreqid=17500000011961 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=ACEM_dosa Param Type = c createdon=12/12/2025 11:44:53 Param Type = c username=ACEM_dosa Param Type = c modifiedon=12/12/2025 11:44:53 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_ccode=10037 Param Type = c court_code=10546 insert into TRN_RCMS_TRANSREQ (trn_rcms_transreqid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_ccode,court_code) values (:trn_rcms_transreqid,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,:trans_ccode,:court_code) Saving to table TRN_RCMS_TRANSREQDTL select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 17500000011962 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2023/56 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2023/56 trn_rcms_caseregid = 10133000007782 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 1 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011962 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2023/56 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2023/56 Param Type = n trn_rcms_caseregid=10133000007782 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=1 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 2 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17500000011963 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2023/46 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2023/46 trn_rcms_caseregid = 14004000007320 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 2 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011963 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2023/46 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2023/46 Param Type = n trn_rcms_caseregid=14004000007320 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=2 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 3 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 17500000011964 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2023/47 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2023/47 trn_rcms_caseregid = 14015000007772 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 3 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011964 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2023/47 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2023/47 Param Type = n trn_rcms_caseregid=14015000007772 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=3 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=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 = 17500000011965 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2022/73 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2022/73 trn_rcms_caseregid = 12091000005872 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 4 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011965 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2022/73 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2022/73 Param Type = n trn_rcms_caseregid=12091000005872 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=4 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=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 = 17500000011966 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2022/74 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2022/74 trn_rcms_caseregid = 12110000007905 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 5 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011966 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2022/74 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2022/74 Param Type = n trn_rcms_caseregid=12110000007905 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=5 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 1 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 = 17500000011967 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2020/00107 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2020/00107 trn_rcms_caseregid = 12946000004788 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 6 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011967 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2020/00107 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2020/00107 Param Type = n trn_rcms_caseregid=12946000004788 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=6 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 7 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000011968 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2020/00108 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2020/00108 trn_rcms_caseregid = 13074000005403 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 7 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011968 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2020/00108 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2020/00108 Param Type = n trn_rcms_caseregid=13074000005403 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=7 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=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 = 17500000011969 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2018/00067 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2018/00067 trn_rcms_caseregid = 15668000001501 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 8 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011969 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2018/00067 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2018/00067 Param Type = n trn_rcms_caseregid=15668000001501 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=8 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 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 = 17500000011970 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2018/00070 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2018/00070 trn_rcms_caseregid = 16085000001435 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 9 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011970 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2018/00070 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2018/00070 Param Type = n trn_rcms_caseregid=16085000001435 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=9 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 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 = 1 RecordId = 17500000011971 Select sysdate as sdt from dual Time elapsed = 1 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2015/00686 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2015/00686 trn_rcms_caseregid = 10604000000814 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 10 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011971 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2015/00686 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2015/00686 Param Type = n trn_rcms_caseregid=10604000000814 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=10 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 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 = 1 RecordId = 17500000011972 Select sysdate as sdt from dual Time elapsed = 1 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2025/82 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2025/82 trn_rcms_caseregid = 19261000011772 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 11 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011972 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2025/82 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2025/82 Param Type = n trn_rcms_caseregid=19261000011772 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=11 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 12 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000011973 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2025/83 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2025/83 trn_rcms_caseregid = 19300000010960 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 12 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011973 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2025/83 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2025/83 Param Type = n trn_rcms_caseregid=19300000010960 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=12 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 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 = 17500000011974 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2025/71 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2025/71 trn_rcms_caseregid = 18553000009105 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 13 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011974 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2025/71 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2025/71 Param Type = n trn_rcms_caseregid=18553000009105 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=13 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=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 = 1 RecordId = 17500000011975 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2025/72 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2025/72 trn_rcms_caseregid = 18597000011616 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 14 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011975 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2025/72 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2025/72 Param Type = n trn_rcms_caseregid=18597000011616 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=14 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=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 = 17500000011976 Select sysdate as sdt from dual Time elapsed = 1 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2025/61 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2025/61 trn_rcms_caseregid = 19682000010781 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 15 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011976 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2025/61 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2025/61 Param Type = n trn_rcms_caseregid=19682000010781 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=15 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 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 = 17500000011977 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2025/62 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2025/62 trn_rcms_caseregid = 19732000010651 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 16 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011977 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2025/62 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2025/62 Param Type = n trn_rcms_caseregid=19732000010651 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=16 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=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 = 1 RecordId = 17500000011978 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2025/59 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2025/59 trn_rcms_caseregid = 19335000010048 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 17 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011978 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2025/59 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2025/59 Param Type = n trn_rcms_caseregid=19335000010048 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=17 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 18 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 17500000011979 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2025/60 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2025/60 trn_rcms_caseregid = 19418000010668 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 18 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011979 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2025/60 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2025/60 Param Type = n trn_rcms_caseregid=19418000010668 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=18 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 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 = 17500000011980 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2023/95 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2023/95 trn_rcms_caseregid = 19258000008185 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 19 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011980 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2023/95 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2023/95 Param Type = n trn_rcms_caseregid=19258000008185 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=19 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 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 = 1 RecordId = 17500000011981 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2023/96 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2023/96 trn_rcms_caseregid = 19276000008063 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 20 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011981 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2023/96 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2023/96 Param Type = n trn_rcms_caseregid=19276000008063 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=20 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 21 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 17500000011982 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2023/93 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2023/93 trn_rcms_caseregid = 19138000007711 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 21 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011982 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2023/93 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2023/93 Param Type = n trn_rcms_caseregid=19138000007711 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=21 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 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 = 17500000011983 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2023/94 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2023/94 trn_rcms_caseregid = 19195000008782 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 22 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011983 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2023/94 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2023/94 Param Type = n trn_rcms_caseregid=19195000008782 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=22 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=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 = 17500000011984 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2023/10 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2023/10 trn_rcms_caseregid = 19291000007782 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 23 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011984 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2023/10 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2023/10 Param Type = n trn_rcms_caseregid=19291000007782 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=23 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 24 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 17500000011985 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2023/11 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2023/11 trn_rcms_caseregid = 19340000006677 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 24 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011985 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2023/11 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2023/11 Param Type = n trn_rcms_caseregid=19340000006677 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=24 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 25 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000011986 Select sysdate as sdt from dual Time elapsed = 1 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2022/21 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2022/21 trn_rcms_caseregid = 17209000007403 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 25 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011986 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2022/21 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2022/21 Param Type = n trn_rcms_caseregid=17209000007403 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=25 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 26 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000011987 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2022/22 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2022/22 trn_rcms_caseregid = 17217000007441 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 26 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011987 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2022/22 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2022/22 Param Type = n trn_rcms_caseregid=17217000007441 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=26 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 27 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000011988 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2018/00584 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2018/00584 trn_rcms_caseregid = 12384000002032 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 27 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011988 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2018/00584 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2018/00584 Param Type = n trn_rcms_caseregid=12384000002032 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=27 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 28 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000011989 Select sysdate as sdt from dual Time elapsed = 1 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2018/00585 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2018/00585 trn_rcms_caseregid = 12416000002304 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 28 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011989 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2018/00585 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2018/00585 Param Type = n trn_rcms_caseregid=12416000002304 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=28 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 29 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 17500000011990 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2018/00582 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2018/00582 trn_rcms_caseregid = 12322000002712 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 29 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011990 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2018/00582 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2018/00582 Param Type = n trn_rcms_caseregid=12322000002712 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=29 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 30 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000011991 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2018/00583 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2018/00583 trn_rcms_caseregid = 12336000002833 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 30 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011991 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2018/00583 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2018/00583 Param Type = n trn_rcms_caseregid=12336000002833 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=30 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 31 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000011992 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2018/00527 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2018/00527 trn_rcms_caseregid = 14897000002135 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 31 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011992 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2018/00527 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2018/00527 Param Type = n trn_rcms_caseregid=14897000002135 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=31 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 32 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000011993 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2018/00528 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2018/00528 trn_rcms_caseregid = 14932000001900 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 32 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011993 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2018/00528 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2018/00528 Param Type = n trn_rcms_caseregid=14932000001900 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=32 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 13 Adding new record to store data from Frame 2, Row 33 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 17500000011994 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2018/00509 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2018/00509 trn_rcms_caseregid = 19338000001708 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 33 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011994 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2018/00509 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2018/00509 Param Type = n trn_rcms_caseregid=19338000001708 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=33 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 34 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000011995 Select sysdate as sdt from dual Time elapsed = 1 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2018/00510 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2018/00510 trn_rcms_caseregid = 19367000002135 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 34 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011995 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2018/00510 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2018/00510 Param Type = n trn_rcms_caseregid=19367000002135 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=34 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 35 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000011996 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2009/00016 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2009/00016 trn_rcms_caseregid = 321613 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 35 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011996 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2009/00016 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2009/00016 Param Type = n trn_rcms_caseregid=321613 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=35 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 36 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000011997 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2016/00098 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2016/00098 trn_rcms_caseregid = 10828000000484 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 36 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011997 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2016/00098 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2016/00098 Param Type = n trn_rcms_caseregid=10828000000484 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=36 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 14 Adding new record to store data from Frame 2, Row 37 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 17500000011998 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2015/00419 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2015/00419 trn_rcms_caseregid = 13182000000069 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 37 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011998 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2015/00419 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2015/00419 Param Type = n trn_rcms_caseregid=13182000000069 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=37 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 38 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000011999 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2013/00006 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2013/00006 trn_rcms_caseregid = 321331 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 38 Posting record Param Type = n trn_rcms_transreqdtlid=17500000011999 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2013/00006 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2013/00006 Param Type = n trn_rcms_caseregid=321331 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=38 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 39 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 17500000012000 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2024/68 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2024/68 trn_rcms_caseregid = 17930000009588 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 39 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012000 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2024/68 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2024/68 Param Type = n trn_rcms_caseregid=17930000009588 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=39 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 40 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000012001 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2024/69 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2024/69 trn_rcms_caseregid = 17979000009254 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 40 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012001 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2024/69 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2024/69 Param Type = n trn_rcms_caseregid=17979000009254 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=40 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 41 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 17500000012002 Select sysdate as sdt from dual Time elapsed = 13 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2022/34 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2022/34 trn_rcms_caseregid = 12089000006460 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 41 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012002 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2022/34 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2022/34 Param Type = n trn_rcms_caseregid=12089000006460 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=41 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 42 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 17500000012003 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2022/35 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2022/35 trn_rcms_caseregid = 12109000006014 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 42 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012003 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2022/35 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2022/35 Param Type = n trn_rcms_caseregid=12109000006014 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=42 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 43 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 17500000012004 Select sysdate as sdt from dual Time elapsed = 13 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2022/228 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2022/228 trn_rcms_caseregid = 16399000008071 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 43 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012004 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2022/228 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2022/228 Param Type = n trn_rcms_caseregid=16399000008071 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=43 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 44 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000012005 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2022/229 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2022/229 trn_rcms_caseregid = 16402000006592 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 44 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012005 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2022/229 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2022/229 Param Type = n trn_rcms_caseregid=16402000006592 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=44 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 45 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000012006 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2022/104 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2022/104 trn_rcms_caseregid = 13029000006752 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 45 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012006 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2022/104 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2022/104 Param Type = n trn_rcms_caseregid=13029000006752 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=45 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 46 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000012007 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2022/105 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2022/105 trn_rcms_caseregid = 13050000007184 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 46 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012007 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2022/105 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2022/105 Param Type = n trn_rcms_caseregid=13050000007184 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=46 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 47 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 17500000012008 Select sysdate as sdt from dual Time elapsed = 14 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2021/152 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2021/152 trn_rcms_caseregid = 13287000007040 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 47 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012008 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2021/152 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2021/152 Param Type = n trn_rcms_caseregid=13287000007040 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=47 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 48 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000012009 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2018/00322 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2018/00322 trn_rcms_caseregid = 12904000002089 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 48 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012009 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2018/00322 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2018/00322 Param Type = n trn_rcms_caseregid=12904000002089 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=48 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 49 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 17500000012010 Select sysdate as sdt from dual Time elapsed = 10 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2017/00184 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2017/00184 trn_rcms_caseregid = 10022000001999 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 49 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012010 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2017/00184 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2017/00184 Param Type = n trn_rcms_caseregid=10022000001999 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=49 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 50 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000012011 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2012/00065 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2012/00065 trn_rcms_caseregid = 12926000003153 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 50 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012011 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2012/00065 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2012/00065 Param Type = n trn_rcms_caseregid=12926000003153 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=50 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 14 Adding new record to store data from Frame 2, Row 51 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17500000012012 Select sysdate as sdt from dual Time elapsed = 16 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2025/57 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2025/57 trn_rcms_caseregid = 19055000010815 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 51 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012012 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2025/57 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2025/57 Param Type = n trn_rcms_caseregid=19055000010815 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=51 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 2 Adding new record to store data from Frame 2, Row 52 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 1 RecordId = 17500000012013 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2025/58 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2025/58 trn_rcms_caseregid = 19162000009605 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 52 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012013 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2025/58 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2025/58 Param Type = n trn_rcms_caseregid=19162000009605 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=52 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 211 Adding new record to store data from Frame 2, Row 53 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17500000012014 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 18/08/2025 status = 0 transContFld = F requestno = 10546-10037#2018/00087 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2018/00087 trn_rcms_caseregid = 19348000001208 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 53 Posting record Param Type = n trn_rcms_transreqdtlid=17500000012014 Param Type = n trn_rcms_transreqid=17500000011961 Param Type = c decision_date=18/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2018/00087 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2018/00087 Param Type = n trn_rcms_caseregid=19348000001208 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=53 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) Time elapsed for insert/update = 3974701493431 >>Executing genmaps >>Posting from rctcr to tscd from row 1 >>Posting from rctcr to tscd from row 2 >>Posting from rctcr to tscd from row 3 >>Posting from rctcr to tscd from row 4 >>Posting from rctcr to tscd from row 5 >>Posting from rctcr to tscd from row 6 >>Posting from rctcr to tscd from row 7 >>Posting from rctcr to tscd from row 8 >>Posting from rctcr to tscd from row 9 >>Posting from rctcr to tscd from row 10 >>Posting from rctcr to tscd from row 11 >>Posting from rctcr to tscd from row 12 >>Posting from rctcr to tscd from row 13 >>Posting from rctcr to tscd from row 14 >>Posting from rctcr to tscd from row 15 >>Posting from rctcr to tscd from row 16 >>Posting from rctcr to tscd from row 17 >>Posting from rctcr to tscd from row 18 >>Posting from rctcr to tscd from row 19 >>Posting from rctcr to tscd from row 20 >>Posting from rctcr to tscd from row 21 >>Posting from rctcr to tscd from row 22 >>Posting from rctcr to tscd from row 23 >>Posting from rctcr to tscd from row 24 >>Posting from rctcr to tscd from row 25 >>Posting from rctcr to tscd from row 26 >>Posting from rctcr to tscd from row 27 >>Posting from rctcr to tscd from row 28 >>Posting from rctcr to tscd from row 29 >>Posting from rctcr to tscd from row 30 >>Posting from rctcr to tscd from row 31 >>Posting from rctcr to tscd from row 32 >>Posting from rctcr to tscd from row 33 >>Posting from rctcr to tscd from row 34 >>Posting from rctcr to tscd from row 35 >>Posting from rctcr to tscd from row 36 >>Posting from rctcr to tscd from row 37 >>Posting from rctcr to tscd from row 38 >>Posting from rctcr to tscd from row 39 >>Posting from rctcr to tscd from row 40 >>Posting from rctcr to tscd from row 41 >>Posting from rctcr to tscd from row 42 >>Posting from rctcr to tscd from row 43 >>Posting from rctcr to tscd from row 44 >>Posting from rctcr to tscd from row 45 >>Posting from rctcr to tscd from row 46 >>Posting from rctcr to tscd from row 47 >>Posting from rctcr to tscd from row 48 >>Posting from rctcr to tscd from row 49 >>Posting from rctcr to tscd from row 50 >>Posting from rctcr to tscd from row 51 >>Posting from rctcr to tscd from row 52 >>Posting from rctcr to tscd from row 53 Time elapsed for Gen Map = 3974701493460 Time elapsed for MD Map = 3974701493460 Time elapsed for Save History = 3974701493460 Time elapsed for Save Attachment = 3974701493460 Time elapsed for After Save WF Exec = 3974701493465 Transaction commited Result : {"message":[{"msg":"Request for Case Transfer Saved","recordid":"17500000011961"}]} 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=ACEM_dosa Param Type = c calledon=12/12/2025 11:44:51 Param Type = c callfinished=12/12/2025 11:44:53 Param Type = c structname=rctcr Param Type = n recordid=0 Param Type = c servicename=Saving data Param Type = c serviceresult=success Param Type = n timetaken=2517 Param Type = n dbtimetaken=1449 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