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 gcmsADM_jpr4827ccb0eea8a706c4c34a16891f84e7brctcr00104461818601380600000000010446179201000824218186120200000025352018/0048510446-18186#2018/0048507/08/20230F01380600000000010446179201000824218186149700000021902018/0085010446-18186#2018/0085007/08/20230F01380600000000010446179201000824218186162730000028472018/0018710446-18186#2018/0018707/08/20230F01380600000000010446179201000824218186134540000024162018/0080810446-18186#2018/0080807/08/20230F01380600000000010446179201000824218186154290000024602018/0056310446-18186#2018/0056307/08/20230F01380600000000010446179201000824218186147060000030232018/0065210446-18186#2018/0065207/08/20230F01380600000000010446179201000824218186125740000021892018/0011610446-18186#2018/0011607/08/20230F01380600000000010446179201000824218186113740000026342018/0078910446-18186#2018/0078907/08/20230F01380600000000010446179201000824218186181990000024322018/0019110446-18186#2018/0019107/08/20230F01380600000000010446179201000824218186135150000024952018/0080910446-18186#2018/0080907/08/20230F01380600000000010446179201000824218186123590000074862022/9110446-18186#2022/9107/08/20230F01380600000000010446179201000824218186137410000069562022/7210446-18186#2022/7207/08/20230F01380600000000010446179201000824218186126950000081272022/9310446-18186#2022/9307/08/20230F01380600000000010446179201000824218186141020000028302018/0021910446-18186#2018/0021907/08/20230F01380600000000010446179201000824218186161060000023382018/0085910446-18186#2018/0085907/08/20230F01380600000000010446179201000824218186155070000020892018/0085410446-18186#2018/0085407/08/20230F01380600000000010446179201000824218186116280000021932018/0090310446-18186#2018/0090307/08/20230F01380600000000010446179201000824218186168720000074412023/2410446-18186#2023/2407/08/20230F01380600000000010446179201000824218186130130000049932019/0014910446-18186#2019/0014907/08/20230F01380600000000010446179201000824218186145230000028312018/0102110446-18186#2018/0102107/08/20230F01380600000000010446179201000824218186148780000020472018/0065510446-18186#2018/0065507/08/20230F01380600000000010446179201000824218186111300000025692018/0078610446-18186#2018/0078607/08/20230F01380600000000010446179201000824218186104140000025662018/0040410446-18186#2018/0040407/08/20230F01380600000000010446179201000824218186191340000024772018/0029710446-18186#2018/0029707/08/20230F01380600000000010446179201000824218186109040000023382018/0046410446-18186#2018/0046407/08/20230F01380600000000010446179201000824218186104370000031582018/0040510446-18186#2018/0040507/08/20230F01380600000000010446179201000824218186136110000068912022/7610446-18186#2022/7607/08/20230F01380600000000010446179201000824218186165830000011052009/0002210446-18186#2009/0002207/08/20230F01380600000000010446179201000824218186190030000014802017/0004710446-18186#2017/0004707/08/20230F01380600000000010446179201000824218186137610000032062018/0063710446-18186#2018/0063707/08/20230F01380600000000010446179201000824218186199540000025762019/0012410446-18186#2019/0012407/08/20230F01380600000000010446179201000824218186106230000027032018/0061910446-18186#2018/0061907/08/20230F01380600000000010446179201000824218186106020000023912018/0041010446-18186#2018/0041007/08/20230F01380600000000010446179201000824218186102680000033912018/0089910446-18186#2018/0089907/08/20230F01380600000000010446179201000824218186162360000022592018/0026110446-18186#2018/0026107/08/20230F01380600000000010446179201000824218186160970000077212022/11210446-18186#2022/11207/08/20230F01380600000000010446179201000824218186165920000029132018/0086510446-18186#2018/0086507/08/20230F01380600000000010446179201000824218186128770000020882018/0049410446-18186#2018/0049407/08/20230F01380600000000010446179201000824218186105160000024262018/0093310446-18186#2018/0093307/08/20230F01380600000000010446179201000824218186119560000031712018/0059010446-18186#2018/0059007/08/20230F01380600000000010446179201000824218186118050000024792018/0010510446-18186#2018/0010507/08/20230F01380600000000010446179201000824218186167610000079192023/2310446-18186#2023/2307/08/20230F01380600000000010446179201000824218186168160000026312018/0057010446-18186#2018/0057007/08/20230F01380600000000010446179201000824218186134200000025982018/0024910446-18186#2018/0024907/08/20230F01380600000000010446179201000824218186101720000019252018/0043310446-18186#2018/0043307/08/20230F01380600000000010446179201000824218186105080000025772018/0044310446-18186#2018/0044307/08/20230F01380600000000010446179201000824218186127830000027072018/0059910446-18186#2018/0059907/08/20230F01380600000000010446179201000824218186149670000023762018/0025910446-18186#2018/0025907/08/20230F01380600000000010446179201000824218186125120000056782021/1710446-18186#2021/1707/08/20230F01380600000000010446179201000824218186180410000030022018/0077710446-18186#2018/0077707/08/20230F01380600000000010446179201000824218186168530000065272021/5010446-18186#2021/5007/08/20230F01380600000000010446179201000824218186183400000030782018/0052710446-18186#2018/0052707/08/20230F01380600000000010446179201000824218186119380000025782018/0054910446-18186#2018/0054907/08/20230F Executing Savedata webservice ----------------------------- Received JSON : {"savedata":{"axpapp":"gcms","username":"ADM_jpr4","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"rctcr","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"court_code":"10446","trans_ccode":"18186"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"12020000002535","case_no":"2018/00485","requestno":"10446-18186#2018/00485","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"002","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"14970000002190","case_no":"2018/00850","requestno":"10446-18186#2018/00850","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"003","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"16273000002847","case_no":"2018/00187","requestno":"10446-18186#2018/00187","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"004","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"13454000002416","case_no":"2018/00808","requestno":"10446-18186#2018/00808","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"005","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"15429000002460","case_no":"2018/00563","requestno":"10446-18186#2018/00563","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"006","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"14706000003023","case_no":"2018/00652","requestno":"10446-18186#2018/00652","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"007","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"12574000002189","case_no":"2018/00116","requestno":"10446-18186#2018/00116","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"008","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"11374000002634","case_no":"2018/00789","requestno":"10446-18186#2018/00789","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"009","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"18199000002432","case_no":"2018/00191","requestno":"10446-18186#2018/00191","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0010","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"13515000002495","case_no":"2018/00809","requestno":"10446-18186#2018/00809","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0011","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"12359000007486","case_no":"2022/91","requestno":"10446-18186#2022/91","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0012","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"13741000006956","case_no":"2022/72","requestno":"10446-18186#2022/72","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0013","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"12695000008127","case_no":"2022/93","requestno":"10446-18186#2022/93","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0014","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"14102000002830","case_no":"2018/00219","requestno":"10446-18186#2018/00219","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0015","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"16106000002338","case_no":"2018/00859","requestno":"10446-18186#2018/00859","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0016","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"15507000002089","case_no":"2018/00854","requestno":"10446-18186#2018/00854","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0017","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"11628000002193","case_no":"2018/00903","requestno":"10446-18186#2018/00903","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0018","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"16872000007441","case_no":"2023/24","requestno":"10446-18186#2023/24","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0019","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"13013000004993","case_no":"2019/00149","requestno":"10446-18186#2019/00149","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0020","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"14523000002831","case_no":"2018/01021","requestno":"10446-18186#2018/01021","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0021","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"14878000002047","case_no":"2018/00655","requestno":"10446-18186#2018/00655","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0022","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"11130000002569","case_no":"2018/00786","requestno":"10446-18186#2018/00786","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0023","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"10414000002566","case_no":"2018/00404","requestno":"10446-18186#2018/00404","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0024","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"19134000002477","case_no":"2018/00297","requestno":"10446-18186#2018/00297","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0025","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"10904000002338","case_no":"2018/00464","requestno":"10446-18186#2018/00464","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0026","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"10437000003158","case_no":"2018/00405","requestno":"10446-18186#2018/00405","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0027","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"13611000006891","case_no":"2022/76","requestno":"10446-18186#2022/76","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0028","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"16583000001105","case_no":"2009/00022","requestno":"10446-18186#2009/00022","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0029","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"19003000001480","case_no":"2017/00047","requestno":"10446-18186#2017/00047","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0030","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"13761000003206","case_no":"2018/00637","requestno":"10446-18186#2018/00637","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0031","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"19954000002576","case_no":"2019/00124","requestno":"10446-18186#2019/00124","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0032","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"10623000002703","case_no":"2018/00619","requestno":"10446-18186#2018/00619","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0033","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"10602000002391","case_no":"2018/00410","requestno":"10446-18186#2018/00410","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0034","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"10268000003391","case_no":"2018/00899","requestno":"10446-18186#2018/00899","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0035","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"16236000002259","case_no":"2018/00261","requestno":"10446-18186#2018/00261","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0036","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"16097000007721","case_no":"2022/112","requestno":"10446-18186#2022/112","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0037","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"16592000002913","case_no":"2018/00865","requestno":"10446-18186#2018/00865","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0038","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"12877000002088","case_no":"2018/00494","requestno":"10446-18186#2018/00494","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0039","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"10516000002426","case_no":"2018/00933","requestno":"10446-18186#2018/00933","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0040","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"11956000003171","case_no":"2018/00590","requestno":"10446-18186#2018/00590","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0041","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"11805000002479","case_no":"2018/00105","requestno":"10446-18186#2018/00105","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0042","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"16761000007919","case_no":"2023/23","requestno":"10446-18186#2023/23","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0043","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"16816000002631","case_no":"2018/00570","requestno":"10446-18186#2018/00570","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0044","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"13420000002598","case_no":"2018/00249","requestno":"10446-18186#2018/00249","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0045","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"10172000001925","case_no":"2018/00433","requestno":"10446-18186#2018/00433","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0046","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"10508000002577","case_no":"2018/00443","requestno":"10446-18186#2018/00443","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0047","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"12783000002707","case_no":"2018/00599","requestno":"10446-18186#2018/00599","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0048","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"14967000002376","case_no":"2018/00259","requestno":"10446-18186#2018/00259","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0049","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"12512000005678","case_no":"2021/17","requestno":"10446-18186#2021/17","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0050","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"18041000003002","case_no":"2018/00777","requestno":"10446-18186#2018/00777","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0051","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"16853000006527","case_no":"2021/50","requestno":"10446-18186#2021/50","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0052","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"18340000003078","case_no":"2018/00527","requestno":"10446-18186#2018/00527","decision_date":"07/08/2023","status":"0","transContFld":"F"}},{"rowno":"0053","text":"0","columns":{"fromcourt":"13806000000000","fromccode":"10446","transcourt":"1792010008242","transccode":"18186","trn_rcms_caseregid":"11938000002578","case_no":"2018/00549","requestno":"10446-18186#2018/00549","decision_date":"07/08/2023","status":"0","transContFld":"F"}}]}]}} Verifying username and password User Name : ADM_jpr4 Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app' U=adm_jpr4 Time elapsed = 16 Password checking along with max.no of login specified in app.xml update axusers set logintry = 0 where lower(username) = :U Time elapsed = 6 Result : Verifying completed... Page Access Category : User Name : adm_jpr4 Select sysdate as sdt from dual Time elapsed = 3 dt=11/12/2023 15:18:10 Select sysdate as sdt from dual Time elapsed = 4 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=adm_jpr4 dt=11/12/2023 15:18:10 dt=11/12/2023 15:18:10 Time elapsed = 11 User Groups: court_reader select userroles from axusergroups where groupname in ( 'court_reader' ) Time elapsed = 4 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 = 6 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=ADM_jpr4 select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=ADM_jpr4 Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m2},{court_name}) Calling function sqlget Result of sqlget = ADM, ?????(??????) Result = ADM, ?????(??????) Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1}) Calling function firesql username=ADM_jpr4 select a.court_type from v_axcourts a where a.paxusername= :username order by 1 username=ADM_jpr4 Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m3},{court_type}) Calling function sqlget Result of sqlget = ADM Result = ADM Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1}) Calling function firesql username=ADM_jpr4 select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1 username=ADM_jpr4 Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m4},{court_name_mastid}) Calling function sqlget Result of sqlget = 13806000000000 Result = 13806000000000 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=ADM_jpr4 Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m4},{axusersid}) Calling function sqlget Result of sqlget = 17664000000151 Result = 17664000000151 Evaluating firesql({m4},{select :username as uname from dual}) Calling function firesql select :username as uname from dual username=ADM_jpr4 Time elapsed = 7 Result of firesql = Result = Evaluating sqlget({m4},{uname}) Calling function sqlget Result of sqlget = ADM_jpr4 Result = ADM_jpr4 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=ADM_jpr4 Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m4},{COURT_CODE}) Calling function sqlget Result of sqlget = 10446 Result = 10446 Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'}) Calling function firesql select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ' Time elapsed = 4 Result of firesql = Result = Evaluating sqlget({m2},{STATE_NAME}) Calling function sqlget Result of sqlget = ???????? Result = ???????? Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=ADM_jpr4 SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=ADM_jpr4 Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m7},{DISTNAMEENG}) Calling function sqlget Result of sqlget = Jaipur Result = Jaipur Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=ADM_jpr4 SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=ADM_jpr4 Time elapsed = 5 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=17664000000151 select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid login_userid=17664000000151 Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m4},{department_mastid}) Calling function sqlget Result of sqlget = 1579880000000 Result = 1579880000000 Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1}) Calling function firesql select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1 username=ADM_jpr4 Time elapsed = 7 Result of firesql = Result = Evaluating sqlget({m3},{court_type_mastid}) Calling function sqlget Result of sqlget = 10824000000000 Result = 10824000000000 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=ADM_jpr4 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=ADM_jpr4 Time elapsed = 7 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 = 4 Result of firesql = Result = Evaluating sqlget({a1},{dd}) Calling function sqlget Result of sqlget = 30/01/2021 Result = 30/01/2021 Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0}) Calling function firesql username=ADM_jpr4 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=ADM_jpr4 Time elapsed = 10 Result of firesql = Result = Evaluating sqlget({P1},{ct}) Calling function sqlget Result of sqlget = 3 Result = 3 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 = 4 select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='rctcr' and stype = 't' Time elapsed = 6 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 = 3 Reading data from stream Executing GetTransControlString Executing GetTransControl Creating DbCall Structure xml not received from client Step3 Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : rctcr ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 6 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 = 5 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 = 4 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 = 4 Step4 tstructs\stm size:6669 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 = 7 select * from trn_rcms_decision where trn_rcms_decisionid=0 Time elapsed = 5 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 = 6 select * from trn_rcms_hearing where trn_rcms_hearingid=0 Time elapsed = 502 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 = 4 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 = 6 select * from trn_rcms_case_hist where trn_rcms_case_histid=0 Time elapsed = 5 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 = 5 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 = 5 select * from trn_rcms_case_hist where trn_rcms_case_histid=0 Time elapsed = 5 select distinct(schemaname) from axschema where lower(transid)='tscrg' Time elapsed = 5 select trn_rcms_caseregid from trn_rcms_casereg where trn_rcms_caseregid=0 Time elapsed = 5 select case_decision_date from trn_rcms_casereg where trn_rcms_caseregid=0 Time elapsed = 5 select distinct(schemaname) from axschema where lower(transid)='tscrg' Time elapsed = 5 select decision_type from trn_rcms_casereg where trn_rcms_caseregid=0 Time elapsed = 4 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 = 11/12/2023 currdate after validation = 11/12/2023 court_code = 10446 trans_ccode = 18186 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 = 5 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 = 5 dec_type after validation = ????????? Id = 11782000000706 time zone difference = 0 >>Writing to tables rctcr Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rctcr' Time elapsed = 3 Saving to table TRN_RCMS_TRANSREQ select * from TRN_RCMS_TRANSREQ where TRN_RCMS_TRANSREQid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16654000008647 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 4 trans_ccode = 18186 court_code = 10446 Posting record Param Type = n trn_rcms_transreqid=16654000008647 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=ADM_jpr4 Param Type = c createdon=11/12/2023 15:18:12 Param Type = c username=ADM_jpr4 Param Type = c modifiedon=11/12/2023 15:18:12 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_ccode=18186 Param Type = c court_code=10446 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 = 4 Adding new record to store data from Frame 2, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 16654000008648 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00485 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00485 trn_rcms_caseregid = 12020000002535 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 1 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008648 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00485 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00485 Param Type = n trn_rcms_caseregid=12020000002535 Param Type = c transccode=18186 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 = 3 Adding new record to store data from Frame 2, Row 2 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16654000008649 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00850 fromcourt = 13806000000000 fromccode = 10446 transcourt = 1792010008242 case_no = 2018/00850 trn_rcms_caseregid = 14970000002190 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 2 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008649 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00850 Param Type = n fromcourt=13806000000000 Param Type = c fromccode=10446 Param Type = n transcourt=1792010008242 Param Type = c case_no=2018/00850 Param Type = n trn_rcms_caseregid=14970000002190 Param Type = c transccode=18186 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 = 3 RecordId = 16654000008650 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00187 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00187 trn_rcms_caseregid = 16273000002847 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 3 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008650 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00187 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00187 Param Type = n trn_rcms_caseregid=16273000002847 Param Type = c transccode=18186 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 = 3 Adding new record to store data from Frame 2, Row 4 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 16654000008651 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00808 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00808 trn_rcms_caseregid = 13454000002416 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 4 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008651 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00808 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00808 Param Type = n trn_rcms_caseregid=13454000002416 Param Type = c transccode=18186 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 = 4 Adding new record to store data from Frame 2, Row 5 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16654000008652 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00563 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00563 trn_rcms_caseregid = 15429000002460 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 5 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008652 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00563 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00563 Param Type = n trn_rcms_caseregid=15429000002460 Param Type = c transccode=18186 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 = 3 Adding new record to store data from Frame 2, Row 6 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 16654000008653 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00652 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00652 trn_rcms_caseregid = 14706000003023 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 6 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008653 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00652 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00652 Param Type = n trn_rcms_caseregid=14706000003023 Param Type = c transccode=18186 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 = 4 Adding new record to store data from Frame 2, Row 7 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16654000008654 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00116 fromcourt = 13806000000000 fromccode = 10446 transcourt = 1792010008242 case_no = 2018/00116 trn_rcms_caseregid = 12574000002189 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 7 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008654 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00116 Param Type = n fromcourt=13806000000000 Param Type = c fromccode=10446 Param Type = n transcourt=1792010008242 Param Type = c case_no=2018/00116 Param Type = n trn_rcms_caseregid=12574000002189 Param Type = c transccode=18186 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 = 3 Adding new record to store data from Frame 2, Row 8 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 16654000008655 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00789 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00789 trn_rcms_caseregid = 11374000002634 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 8 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008655 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00789 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00789 Param Type = n trn_rcms_caseregid=11374000002634 Param Type = c transccode=18186 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 = 4 Adding new record to store data from Frame 2, Row 9 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16654000008656 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00191 fromcourt = 13806000000000 fromccode = 10446 transcourt = 1792010008242 case_no = 2018/00191 trn_rcms_caseregid = 18199000002432 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 9 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008656 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00191 Param Type = n fromcourt=13806000000000 Param Type = c fromccode=10446 Param Type = n transcourt=1792010008242 Param Type = c case_no=2018/00191 Param Type = n trn_rcms_caseregid=18199000002432 Param Type = c transccode=18186 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 = 3 Adding new record to store data from Frame 2, Row 10 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 16654000008657 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00809 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00809 trn_rcms_caseregid = 13515000002495 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 10 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008657 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00809 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00809 Param Type = n trn_rcms_caseregid=13515000002495 Param Type = c transccode=18186 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 = 3 Adding new record to store data from Frame 2, Row 11 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16654000008658 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2022/91 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2022/91 trn_rcms_caseregid = 12359000007486 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 11 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008658 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2022/91 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2022/91 Param Type = n trn_rcms_caseregid=12359000007486 Param Type = c transccode=18186 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 = 4 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 = 3 RecordId = 16654000008659 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2022/72 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2022/72 trn_rcms_caseregid = 13741000006956 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 12 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008659 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2022/72 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2022/72 Param Type = n trn_rcms_caseregid=13741000006956 Param Type = c transccode=18186 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 = 5 Adding new record to store data from Frame 2, Row 13 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16654000008660 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2022/93 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2022/93 trn_rcms_caseregid = 12695000008127 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 13 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008660 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2022/93 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2022/93 Param Type = n trn_rcms_caseregid=12695000008127 Param Type = c transccode=18186 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 = 4 Adding new record to store data from Frame 2, Row 14 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16654000008661 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00219 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00219 trn_rcms_caseregid = 14102000002830 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 14 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008661 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00219 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00219 Param Type = n trn_rcms_caseregid=14102000002830 Param Type = c transccode=18186 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 = 4 Adding new record to store data from Frame 2, Row 15 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 16654000008662 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00859 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00859 trn_rcms_caseregid = 16106000002338 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 15 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008662 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00859 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00859 Param Type = n trn_rcms_caseregid=16106000002338 Param Type = c transccode=18186 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 = 4 Adding new record to store data from Frame 2, Row 16 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16654000008663 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00854 fromcourt = 13806000000000 fromccode = 10446 transcourt = 1792010008242 case_no = 2018/00854 trn_rcms_caseregid = 15507000002089 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 16 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008663 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00854 Param Type = n fromcourt=13806000000000 Param Type = c fromccode=10446 Param Type = n transcourt=1792010008242 Param Type = c case_no=2018/00854 Param Type = n trn_rcms_caseregid=15507000002089 Param Type = c transccode=18186 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 = 4 Adding new record to store data from Frame 2, Row 17 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16654000008664 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00903 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00903 trn_rcms_caseregid = 11628000002193 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 17 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008664 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00903 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00903 Param Type = n trn_rcms_caseregid=11628000002193 Param Type = c transccode=18186 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 = 4 Adding new record to store data from Frame 2, Row 18 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16654000008665 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2023/24 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2023/24 trn_rcms_caseregid = 16872000007441 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 18 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008665 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2023/24 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2023/24 Param Type = n trn_rcms_caseregid=16872000007441 Param Type = c transccode=18186 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 = 3 Adding new record to store data from Frame 2, Row 19 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16654000008666 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2019/00149 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2019/00149 trn_rcms_caseregid = 13013000004993 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 19 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008666 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2019/00149 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2019/00149 Param Type = n trn_rcms_caseregid=13013000004993 Param Type = c transccode=18186 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 = 4 Adding new record to store data from Frame 2, Row 20 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 16654000008667 Select sysdate as sdt from dual Time elapsed = 2 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/01021 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/01021 trn_rcms_caseregid = 14523000002831 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 20 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008667 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/01021 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/01021 Param Type = n trn_rcms_caseregid=14523000002831 Param Type = c transccode=18186 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 = 6 Adding new record to store data from Frame 2, Row 21 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16654000008668 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00655 fromcourt = 13806000000000 fromccode = 10446 transcourt = 1792010008242 case_no = 2018/00655 trn_rcms_caseregid = 14878000002047 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 21 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008668 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00655 Param Type = n fromcourt=13806000000000 Param Type = c fromccode=10446 Param Type = n transcourt=1792010008242 Param Type = c case_no=2018/00655 Param Type = n trn_rcms_caseregid=14878000002047 Param Type = c transccode=18186 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 = 5 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 = 3 RecordId = 16654000008669 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00786 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00786 trn_rcms_caseregid = 11130000002569 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 22 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008669 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00786 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00786 Param Type = n trn_rcms_caseregid=11130000002569 Param Type = c transccode=18186 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 = 3 Adding new record to store data from Frame 2, Row 23 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 16654000008670 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00404 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00404 trn_rcms_caseregid = 10414000002566 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 23 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008670 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00404 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00404 Param Type = n trn_rcms_caseregid=10414000002566 Param Type = c transccode=18186 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 = 3 RecordId = 16654000008671 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00297 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00297 trn_rcms_caseregid = 19134000002477 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 24 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008671 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00297 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00297 Param Type = n trn_rcms_caseregid=19134000002477 Param Type = c transccode=18186 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 = 3 RecordId = 16654000008672 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00464 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00464 trn_rcms_caseregid = 10904000002338 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 25 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008672 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00464 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00464 Param Type = n trn_rcms_caseregid=10904000002338 Param Type = c transccode=18186 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 = 5 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 = 4 RecordId = 16654000008673 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00405 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00405 trn_rcms_caseregid = 10437000003158 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 26 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008673 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00405 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00405 Param Type = n trn_rcms_caseregid=10437000003158 Param Type = c transccode=18186 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 = 4 Adding new record to store data from Frame 2, Row 27 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16654000008674 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2022/76 fromcourt = 13806000000000 fromccode = 10446 transcourt = 1792010008242 case_no = 2022/76 trn_rcms_caseregid = 13611000006891 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 27 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008674 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2022/76 Param Type = n fromcourt=13806000000000 Param Type = c fromccode=10446 Param Type = n transcourt=1792010008242 Param Type = c case_no=2022/76 Param Type = n trn_rcms_caseregid=13611000006891 Param Type = c transccode=18186 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 = 4 Adding new record to store data from Frame 2, Row 28 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 16654000008675 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2009/00022 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2009/00022 trn_rcms_caseregid = 16583000001105 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 28 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008675 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2009/00022 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2009/00022 Param Type = n trn_rcms_caseregid=16583000001105 Param Type = c transccode=18186 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 = 5 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 = 4 RecordId = 16654000008676 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2017/00047 fromcourt = 13806000000000 fromccode = 10446 transcourt = 1792010008242 case_no = 2017/00047 trn_rcms_caseregid = 19003000001480 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 29 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008676 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2017/00047 Param Type = n fromcourt=13806000000000 Param Type = c fromccode=10446 Param Type = n transcourt=1792010008242 Param Type = c case_no=2017/00047 Param Type = n trn_rcms_caseregid=19003000001480 Param Type = c transccode=18186 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 = 5 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 = 3 RecordId = 16654000008677 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00637 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00637 trn_rcms_caseregid = 13761000003206 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 30 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008677 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00637 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00637 Param Type = n trn_rcms_caseregid=13761000003206 Param Type = c transccode=18186 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 = 4 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 = 3 RecordId = 16654000008678 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2019/00124 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2019/00124 trn_rcms_caseregid = 19954000002576 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 31 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008678 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2019/00124 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2019/00124 Param Type = n trn_rcms_caseregid=19954000002576 Param Type = c transccode=18186 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 = 4 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 = 4 RecordId = 16654000008679 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00619 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00619 trn_rcms_caseregid = 10623000002703 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 32 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008679 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00619 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00619 Param Type = n trn_rcms_caseregid=10623000002703 Param Type = c transccode=18186 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 = 4 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 = 4 RecordId = 16654000008680 Select sysdate as sdt from dual Time elapsed = 6 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00410 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00410 trn_rcms_caseregid = 10602000002391 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 33 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008680 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00410 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00410 Param Type = n trn_rcms_caseregid=10602000002391 Param Type = c transccode=18186 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 = 4 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 = 3 RecordId = 16654000008681 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00899 fromcourt = 13806000000000 fromccode = 10446 transcourt = 1792010008242 case_no = 2018/00899 trn_rcms_caseregid = 10268000003391 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 34 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008681 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00899 Param Type = n fromcourt=13806000000000 Param Type = c fromccode=10446 Param Type = n transcourt=1792010008242 Param Type = c case_no=2018/00899 Param Type = n trn_rcms_caseregid=10268000003391 Param Type = c transccode=18186 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 = 5 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 = 4 RecordId = 16654000008682 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00261 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00261 trn_rcms_caseregid = 16236000002259 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 35 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008682 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00261 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00261 Param Type = n trn_rcms_caseregid=16236000002259 Param Type = c transccode=18186 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 = 5 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 = 5 RecordId = 16654000008683 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2022/112 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2022/112 trn_rcms_caseregid = 16097000007721 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 36 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008683 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2022/112 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2022/112 Param Type = n trn_rcms_caseregid=16097000007721 Param Type = c transccode=18186 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 = 3 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 = 3 RecordId = 16654000008684 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00865 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00865 trn_rcms_caseregid = 16592000002913 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 37 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008684 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00865 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00865 Param Type = n trn_rcms_caseregid=16592000002913 Param Type = c transccode=18186 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 = 4 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 = 3 RecordId = 16654000008685 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00494 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00494 trn_rcms_caseregid = 12877000002088 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 38 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008685 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00494 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00494 Param Type = n trn_rcms_caseregid=12877000002088 Param Type = c transccode=18186 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 = 5 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 = 3 RecordId = 16654000008686 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00933 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00933 trn_rcms_caseregid = 10516000002426 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 39 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008686 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00933 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00933 Param Type = n trn_rcms_caseregid=10516000002426 Param Type = c transccode=18186 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 = 4 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 = 3 RecordId = 16654000008687 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00590 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00590 trn_rcms_caseregid = 11956000003171 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 40 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008687 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00590 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00590 Param Type = n trn_rcms_caseregid=11956000003171 Param Type = c transccode=18186 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 = 4 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 = 3 RecordId = 16654000008688 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00105 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00105 trn_rcms_caseregid = 11805000002479 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 41 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008688 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00105 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00105 Param Type = n trn_rcms_caseregid=11805000002479 Param Type = c transccode=18186 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 = 4 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 = 3 RecordId = 16654000008689 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2023/23 fromcourt = 13806000000000 fromccode = 10446 transcourt = 1792010008242 case_no = 2023/23 trn_rcms_caseregid = 16761000007919 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 42 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008689 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2023/23 Param Type = n fromcourt=13806000000000 Param Type = c fromccode=10446 Param Type = n transcourt=1792010008242 Param Type = c case_no=2023/23 Param Type = n trn_rcms_caseregid=16761000007919 Param Type = c transccode=18186 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 = 4 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 = 3 RecordId = 16654000008690 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00570 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00570 trn_rcms_caseregid = 16816000002631 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 43 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008690 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00570 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00570 Param Type = n trn_rcms_caseregid=16816000002631 Param Type = c transccode=18186 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 = 4 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 = 3 RecordId = 16654000008691 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00249 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00249 trn_rcms_caseregid = 13420000002598 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 44 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008691 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00249 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00249 Param Type = n trn_rcms_caseregid=13420000002598 Param Type = c transccode=18186 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 = 4 RecordId = 16654000008692 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00433 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00433 trn_rcms_caseregid = 10172000001925 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 45 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008692 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00433 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00433 Param Type = n trn_rcms_caseregid=10172000001925 Param Type = c transccode=18186 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 = 3 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 = 3 RecordId = 16654000008693 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00443 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00443 trn_rcms_caseregid = 10508000002577 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 46 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008693 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00443 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00443 Param Type = n trn_rcms_caseregid=10508000002577 Param Type = c transccode=18186 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 = 4 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 = 3 RecordId = 16654000008694 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00599 fromcourt = 13806000000000 fromccode = 10446 transcourt = 1792010008242 case_no = 2018/00599 trn_rcms_caseregid = 12783000002707 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 47 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008694 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00599 Param Type = n fromcourt=13806000000000 Param Type = c fromccode=10446 Param Type = n transcourt=1792010008242 Param Type = c case_no=2018/00599 Param Type = n trn_rcms_caseregid=12783000002707 Param Type = c transccode=18186 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 = 9 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 = 4 RecordId = 16654000008695 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00259 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00259 trn_rcms_caseregid = 14967000002376 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 48 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008695 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00259 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00259 Param Type = n trn_rcms_caseregid=14967000002376 Param Type = c transccode=18186 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 = 5 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 = 4 RecordId = 16654000008696 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2021/17 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2021/17 trn_rcms_caseregid = 12512000005678 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 49 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008696 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2021/17 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2021/17 Param Type = n trn_rcms_caseregid=12512000005678 Param Type = c transccode=18186 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 = 4 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 = 4 RecordId = 16654000008697 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00777 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00777 trn_rcms_caseregid = 18041000003002 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 50 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008697 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00777 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00777 Param Type = n trn_rcms_caseregid=18041000003002 Param Type = c transccode=18186 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 = 3 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 = 16654000008698 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2021/50 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2021/50 trn_rcms_caseregid = 16853000006527 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 51 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008698 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2021/50 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2021/50 Param Type = n trn_rcms_caseregid=16853000006527 Param Type = c transccode=18186 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 = 5 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 = 5 RecordId = 16654000008699 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00527 fromcourt = 13806000000000 fromccode = 10446 transcourt = 1792010008242 case_no = 2018/00527 trn_rcms_caseregid = 18340000003078 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 52 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008699 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00527 Param Type = n fromcourt=13806000000000 Param Type = c fromccode=10446 Param Type = n transcourt=1792010008242 Param Type = c case_no=2018/00527 Param Type = n trn_rcms_caseregid=18340000003078 Param Type = c transccode=18186 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 = 14 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 = 16654000008700 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 07/08/2023 status = 0 transContFld = F requestno = 10446-18186#2018/00549 transcourt = 1792010008242 fromccode = 10446 fromcourt = 13806000000000 case_no = 2018/00549 trn_rcms_caseregid = 11938000002578 transccode = 18186 TRN_RCMS_TRANSREQDTLrow = 53 Posting record Param Type = n trn_rcms_transreqdtlid=16654000008700 Param Type = n trn_rcms_transreqid=16654000008647 Param Type = c decision_date=07/08/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10446-18186#2018/00549 Param Type = n transcourt=1792010008242 Param Type = c fromccode=10446 Param Type = n fromcourt=13806000000000 Param Type = c case_no=2018/00549 Param Type = n trn_rcms_caseregid=11938000002578 Param Type = c transccode=18186 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 = 3911469453157 >>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 = 3911469453217 Time elapsed for MD Map = 3911469453218 Time elapsed for Save History = 3911469453219 Time elapsed for Save Attachment = 3911469453220 Time elapsed for After Save WF Exec = 3911469453227 Transaction commited Result : {"message":[{"msg":"Request for Case Transfer Saved","recordid":"16654000008647"}]} 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=ADM_jpr4 Param Type = c calledon=11/12/2023 15:17:28 Param Type = c callfinished=11/12/2023 15:17:33 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=4967 Param Type = n dbtimetaken=3106 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