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_dosa_r827ccb0eea8a706c4c34a16891f84e7brctcr00103661818801283600000011910366153266000830618188158120000076262023/6710366-18188#2023/6708/11/20230T01283600000011910366153266000830618188166370000085072023/1210366-18188#2023/1208/11/20230T01283600000011910366153266000830618188165360000069402023/1110366-18188#2023/1108/11/20230T01283600000011910366153266000830618188108500000071162022/31910366-18188#2022/31908/11/20230T01283600000011910366153266000830618188166360000077662022/31410366-18188#2022/31408/11/20230T01283600000011910366153266000830618188165890000071912022/31310366-18188#2022/31308/11/20230T01283600000011910366153266000830618188183730000068492022/13210366-18188#2022/13208/11/20230T01283600000011910366153266000830618188180210000063902022/13110366-18188#2022/13108/11/20230T01283600000011910366153266000830618188190790000035372019/0030510366-18188#2019/0030508/11/20230T01283600000011910366153266000830618188149500000059362021/13010366-18188#2021/13008/11/20230T01283600000011910366153266000830618188168420000058912021/12710366-18188#2021/12708/11/20230T01283600000011910366153266000830618188168230000059582021/12610366-18188#2021/12608/11/20230T01283600000011910366153266000830618188167880000051582021/12510366-18188#2021/12508/11/20230T01283600000011910366153266000830618188167640000054352021/12410366-18188#2021/12408/11/20230T01283600000011910366153266000830618188171050000067902021/12810366-18188#2021/12808/11/20230T01283600000011910366153266000830618188135050000063662021/14610366-18188#2021/14608/11/20230T01283600000011910366153266000830618188157980000047612021/310366-18188#2021/308/11/20230T01283600000011910366153266000830618188185080000053242020/0014610366-18188#2020/0014608/11/20230T01283600000011910366153266000830618188164790000040282020/0003610366-18188#2020/0003608/11/20230T01283600000011910366153266000830618188127730000023702019/0017110366-18188#2019/0017108/11/20230T01283600000011910366153266000830618188193370000027962019/0014010366-18188#2019/0014008/11/20230T01283600000011910366153266000830618188192310000024252019/0013910366-18188#2019/0013908/11/20230T01283600000011910366153266000830618188189940000024162019/0013810366-18188#2019/0013808/11/20230T01283600000011910366153266000830618188117310000024922018/0029510366-18188#2018/0029508/11/20230T01283600000011910366153266000830618188115810000026452018/0029410366-18188#2018/0029408/11/20230T01283600000011910366153266000830618188111490000016432018/0020010366-18188#2018/0020008/11/20230T01283600000011910366153266000830618188113430000022702018/0016510366-18188#2018/0016508/11/20230T01283600000011910366153266000830618188112970000018352018/0016410366-18188#2018/0016408/11/20230T01283600000011910366153266000830618188112620000020212018/0016310366-18188#2018/0016308/11/20230T01283600000011910366153266000830618188112170000021072018/0016210366-18188#2018/0016208/11/20230T01283600000011910366153266000830618188114120000015312017/0072510366-18188#2017/0072508/11/20230T01283600000011910366153266000830618188107800000013132017/0072110366-18188#2017/0072108/11/20230T01283600000011910366153266000830618188154810000012582017/0054710366-18188#2017/0054708/11/20230T01283600000011910366153266000830618188198390000008592017/0054310366-18188#2017/0054308/11/20230T01283600000011910366153266000830618188108170000002682016/0022210366-18188#2016/0022208/11/20230T01283600000011910366153266000830618188107670000002512016/0022010366-18188#2016/0022008/11/20230T01283600000011910366153266000830618188179650000001852016/0006810366-18188#2016/0006808/11/20230T01283600000011910366153266000830618188178770000001932016/0006710366-18188#2016/0006708/11/20230T01283600000011910366153266000830618188187660000010082016/0036510366-18188#2016/0036508/11/20230T01283600000011910366153266000830618188173450000001462015/0024410366-18188#2015/0024408/11/20230T01283600000011910366153266000830618188181970000003512015/0044710366-18188#2015/0044708/11/20230T01283600000011910366153266000830618188130290000002672014/0008810366-18188#2014/0008808/11/20230T01283600000011910366153266000830618188178430000001952014/0006610366-18188#2014/0006608/11/20230T01283600000011910366153266000830618188172670000003322013/0005910366-18188#2013/0005908/11/20230T01283600000011910366153266000830618188132350000003002013/0004410366-18188#2013/0004408/11/20230T01283600000011910366153266000830618188194800000006072011/0001110366-18188#2011/0001108/11/20230T01283600000011910366153266000830618188140620000002482010/0000610366-18188#2010/0000608/11/20230T01283600000011910366153266000830618188143230000001322010/0000710366-18188#2010/0000708/11/20230T01283600000011910366153266000830618188196610000001052010/0000510366-18188#2010/0000508/11/20230T01283600000011910366153266000830618188164720000002452007/0000510366-18188#2007/0000508/11/20230T01283600000011910366153266000830618188112750000004142005/0000410366-18188#2005/0000408/11/20230T01283600000011910366153266000830618188110530000003322002/0000410366-18188#2002/0000408/11/20230T01283600000011910366153266000830618188104630000004062002/0000210366-18188#2002/0000208/11/20230T01283600000011910366153266000830618188105750000003312002/0000310366-18188#2002/0000308/11/20230T01283600000011910366153266000830618188100390000002032002/0000110366-18188#2002/0000108/11/20230T Executing Savedata webservice ----------------------------- Received JSON : {"savedata":{"axpapp":"gcms","username":"ADM_dosa_r","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"rctcr","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"court_code":"10366","trans_ccode":"18188"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"15812000007626","case_no":"2023/67","requestno":"10366-18188#2023/67","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"002","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16637000008507","case_no":"2023/12","requestno":"10366-18188#2023/12","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"003","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16536000006940","case_no":"2023/11","requestno":"10366-18188#2023/11","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"004","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"10850000007116","case_no":"2022/319","requestno":"10366-18188#2022/319","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"005","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16636000007766","case_no":"2022/314","requestno":"10366-18188#2022/314","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"006","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16589000007191","case_no":"2022/313","requestno":"10366-18188#2022/313","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"007","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"18373000006849","case_no":"2022/132","requestno":"10366-18188#2022/132","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"008","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"18021000006390","case_no":"2022/131","requestno":"10366-18188#2022/131","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"009","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"19079000003537","case_no":"2019/00305","requestno":"10366-18188#2019/00305","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0010","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"14950000005936","case_no":"2021/130","requestno":"10366-18188#2021/130","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0011","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16842000005891","case_no":"2021/127","requestno":"10366-18188#2021/127","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0012","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16823000005958","case_no":"2021/126","requestno":"10366-18188#2021/126","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0013","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16788000005158","case_no":"2021/125","requestno":"10366-18188#2021/125","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0014","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16764000005435","case_no":"2021/124","requestno":"10366-18188#2021/124","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0015","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"17105000006790","case_no":"2021/128","requestno":"10366-18188#2021/128","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0016","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"13505000006366","case_no":"2021/146","requestno":"10366-18188#2021/146","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0017","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"15798000004761","case_no":"2021/3","requestno":"10366-18188#2021/3","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0018","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"18508000005324","case_no":"2020/00146","requestno":"10366-18188#2020/00146","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0019","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16479000004028","case_no":"2020/00036","requestno":"10366-18188#2020/00036","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0020","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"12773000002370","case_no":"2019/00171","requestno":"10366-18188#2019/00171","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0021","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"19337000002796","case_no":"2019/00140","requestno":"10366-18188#2019/00140","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0022","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"19231000002425","case_no":"2019/00139","requestno":"10366-18188#2019/00139","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0023","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"18994000002416","case_no":"2019/00138","requestno":"10366-18188#2019/00138","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0024","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11731000002492","case_no":"2018/00295","requestno":"10366-18188#2018/00295","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0025","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11581000002645","case_no":"2018/00294","requestno":"10366-18188#2018/00294","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0026","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11149000001643","case_no":"2018/00200","requestno":"10366-18188#2018/00200","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0027","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11343000002270","case_no":"2018/00165","requestno":"10366-18188#2018/00165","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0028","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11297000001835","case_no":"2018/00164","requestno":"10366-18188#2018/00164","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0029","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11262000002021","case_no":"2018/00163","requestno":"10366-18188#2018/00163","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0030","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11217000002107","case_no":"2018/00162","requestno":"10366-18188#2018/00162","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0031","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11412000001531","case_no":"2017/00725","requestno":"10366-18188#2017/00725","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0032","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"10780000001313","case_no":"2017/00721","requestno":"10366-18188#2017/00721","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0033","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"15481000001258","case_no":"2017/00547","requestno":"10366-18188#2017/00547","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0034","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"19839000000859","case_no":"2017/00543","requestno":"10366-18188#2017/00543","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0035","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"10817000000268","case_no":"2016/00222","requestno":"10366-18188#2016/00222","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0036","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"10767000000251","case_no":"2016/00220","requestno":"10366-18188#2016/00220","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0037","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"17965000000185","case_no":"2016/00068","requestno":"10366-18188#2016/00068","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0038","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"17877000000193","case_no":"2016/00067","requestno":"10366-18188#2016/00067","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0039","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"18766000001008","case_no":"2016/00365","requestno":"10366-18188#2016/00365","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0040","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"17345000000146","case_no":"2015/00244","requestno":"10366-18188#2015/00244","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0041","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"18197000000351","case_no":"2015/00447","requestno":"10366-18188#2015/00447","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0042","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"13029000000267","case_no":"2014/00088","requestno":"10366-18188#2014/00088","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0043","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"17843000000195","case_no":"2014/00066","requestno":"10366-18188#2014/00066","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0044","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"17267000000332","case_no":"2013/00059","requestno":"10366-18188#2013/00059","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0045","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"13235000000300","case_no":"2013/00044","requestno":"10366-18188#2013/00044","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0046","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"19480000000607","case_no":"2011/00011","requestno":"10366-18188#2011/00011","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0047","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"14062000000248","case_no":"2010/00006","requestno":"10366-18188#2010/00006","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0048","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"14323000000132","case_no":"2010/00007","requestno":"10366-18188#2010/00007","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0049","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"19661000000105","case_no":"2010/00005","requestno":"10366-18188#2010/00005","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0050","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16472000000245","case_no":"2007/00005","requestno":"10366-18188#2007/00005","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0051","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11275000000414","case_no":"2005/00004","requestno":"10366-18188#2005/00004","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0052","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11053000000332","case_no":"2002/00004","requestno":"10366-18188#2002/00004","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0053","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"10463000000406","case_no":"2002/00002","requestno":"10366-18188#2002/00002","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0054","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"10575000000331","case_no":"2002/00003","requestno":"10366-18188#2002/00003","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0055","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"10039000000203","case_no":"2002/00001","requestno":"10366-18188#2002/00001","decision_date":"08/11/2023","status":"0","transContFld":"T"}}]}]}} Verifying username and password User Name : ADM_dosa_r Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app' U=adm_dosa_r Time elapsed = 27 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_dosa_r Select sysdate as sdt from dual Time elapsed = 5 dt=09/02/2024 22:48:50 Select sysdate as sdt from dual Time elapsed = 5 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_dosa_r dt=09/02/2024 22:48:50 dt=09/02/2024 22:48:50 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 = 3 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_dosa_r select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=ADM_dosa_r Time elapsed = 7 Result of firesql = Result = Evaluating sqlget({m2},{court_name}) Calling function sqlget Result of sqlget = ???????? ???? ???????,???? Result = ???????? ???? ???????,???? Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1}) Calling function firesql username=ADM_dosa_r select a.court_type from v_axcourts a where a.paxusername= :username order by 1 username=ADM_dosa_r Time elapsed = 17 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_dosa_r select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1 username=ADM_dosa_r Time elapsed = 7 Result of firesql = Result = Evaluating sqlget({m4},{court_name_mastid}) Calling function sqlget Result of sqlget = 12836000000119 Result = 12836000000119 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_dosa_r Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m4},{axusersid}) Calling function sqlget Result of sqlget = 3683 Result = 3683 Evaluating firesql({m4},{select :username as uname from dual}) Calling function firesql select :username as uname from dual username=ADM_dosa_r Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m4},{uname}) Calling function sqlget Result of sqlget = ADM_dosa_r Result = ADM_dosa_r 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_dosa_r Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m4},{COURT_CODE}) Calling function sqlget Result of sqlget = 10366 Result = 10366 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 = 5 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_dosa_r SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=ADM_dosa_r Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m7},{DISTNAMEENG}) Calling function sqlget Result of sqlget = Dausa Result = Dausa Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=ADM_dosa_r SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=ADM_dosa_r 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=3683 select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid login_userid=3683 Time elapsed = 11 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_dosa_r 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_dosa_r 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_dosa_r Time elapsed = 6 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_dosa_r 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_dosa_r Time elapsed = 8 Result of firesql = Result = Evaluating sqlget({P1},{ct}) Calling function sqlget Result of sqlget = 7 Result = 7 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 = 3 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 = 4 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 = 5 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 = 17 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 = 5 select * from AxAttachWorkflow where lower(transid) = 'rctcr' Time elapsed = 6 Step3 Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : tscd ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 3 Step4 tstructs\stm size: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 = 4 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 = 9 select * from trn_rcms_hearing where trn_rcms_hearingid=0 Time elapsed = 6 Evaluating date() Result = Evaluating { AND a1.court_code = :m_courtcode } Result = Evaluating m_courtname Result = Evaluating case_purpose_name Result = Evaluating {NO} Result = Evaluating {Feedback Submitted} Result = Step3 Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : tchdh ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 3 Step4 tstructs\stm size:1907 Step4-0 Step4-1 Step4-2 Step4-3 Step4-4 Step5 Step6 Step9 Post on approve = False select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout) tid=tchdh adxinout=o Time elapsed = 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 = 3 Step4 tstructs\stm size:1907 Step4-0 Step4-1 Step4-2 Step4-3 Step4-4 Step5 Step6 Step9 Post on approve = False select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout) tid=tchdh adxinout=o Time elapsed = 7 select * from trn_rcms_case_hist where trn_rcms_case_histid=0 Time elapsed = 14 select distinct(schemaname) from axschema where lower(transid)='tscrg' Time elapsed = 16 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 = 4 select distinct(schemaname) from axschema where lower(transid)='tscrg' Time elapsed = 4 select decision_type from trn_rcms_casereg where trn_rcms_caseregid=0 Time elapsed = 5 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 = 09/02/2024 currdate after validation = 09/02/2024 court_code = 10366 trans_ccode = 18188 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 = 4 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 = 5 RecordId = 12017000009134 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 4 trans_ccode = 18188 court_code = 10366 Posting record Param Type = n trn_rcms_transreqid=12017000009134 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=ADM_dosa_r Param Type = c createdon=09/02/2024 22:48:51 Param Type = c username=ADM_dosa_r Param Type = c modifiedon=09/02/2024 22:48:51 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_ccode=18188 Param Type = c court_code=10366 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 = 3 RecordId = 12017000009135 Select sysdate as sdt from dual Time elapsed = 16 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2023/67 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2023/67 trn_rcms_caseregid = 15812000007626 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 1 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009135 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2023/67 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2023/67 Param Type = n trn_rcms_caseregid=15812000007626 Param Type = c transccode=18188 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 = 4 RecordId = 12017000009136 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2023/12 fromcourt = 12836000000119 fromccode = 10366 transcourt = 1532660008306 case_no = 2023/12 trn_rcms_caseregid = 16637000008507 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 2 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009136 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2023/12 Param Type = n fromcourt=12836000000119 Param Type = c fromccode=10366 Param Type = n transcourt=1532660008306 Param Type = c case_no=2023/12 Param Type = n trn_rcms_caseregid=16637000008507 Param Type = c transccode=18188 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 = 4 Adding new record to store data from Frame 2, Row 3 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 12017000009137 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2023/11 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2023/11 trn_rcms_caseregid = 16536000006940 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 3 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009137 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2023/11 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2023/11 Param Type = n trn_rcms_caseregid=16536000006940 Param Type = c transccode=18188 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 = 12017000009138 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2022/319 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2022/319 trn_rcms_caseregid = 10850000007116 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 4 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009138 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2022/319 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2022/319 Param Type = n trn_rcms_caseregid=10850000007116 Param Type = c transccode=18188 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 = 2 RecordId = 12017000009139 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2022/314 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2022/314 trn_rcms_caseregid = 16636000007766 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 5 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009139 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2022/314 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2022/314 Param Type = n trn_rcms_caseregid=16636000007766 Param Type = c transccode=18188 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 = 12017000009140 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2022/313 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2022/313 trn_rcms_caseregid = 16589000007191 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 6 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009140 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2022/313 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2022/313 Param Type = n trn_rcms_caseregid=16589000007191 Param Type = c transccode=18188 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 = 3 Adding new record to store data from Frame 2, Row 7 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 12017000009141 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2022/132 fromcourt = 12836000000119 fromccode = 10366 transcourt = 1532660008306 case_no = 2022/132 trn_rcms_caseregid = 18373000006849 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 7 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009141 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2022/132 Param Type = n fromcourt=12836000000119 Param Type = c fromccode=10366 Param Type = n transcourt=1532660008306 Param Type = c case_no=2022/132 Param Type = n trn_rcms_caseregid=18373000006849 Param Type = c transccode=18188 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 = 4 Adding new record to store data from Frame 2, Row 8 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12017000009142 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2022/131 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2022/131 trn_rcms_caseregid = 18021000006390 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 8 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009142 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2022/131 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2022/131 Param Type = n trn_rcms_caseregid=18021000006390 Param Type = c transccode=18188 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 = 12017000009143 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2019/00305 fromcourt = 12836000000119 fromccode = 10366 transcourt = 1532660008306 case_no = 2019/00305 trn_rcms_caseregid = 19079000003537 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 9 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009143 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2019/00305 Param Type = n fromcourt=12836000000119 Param Type = c fromccode=10366 Param Type = n transcourt=1532660008306 Param Type = c case_no=2019/00305 Param Type = n trn_rcms_caseregid=19079000003537 Param Type = c transccode=18188 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 = 4 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 = 12017000009144 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2021/130 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2021/130 trn_rcms_caseregid = 14950000005936 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 10 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009144 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2021/130 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2021/130 Param Type = n trn_rcms_caseregid=14950000005936 Param Type = c transccode=18188 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 = 4 Adding new record to store data from Frame 2, Row 11 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12017000009145 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2021/127 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2021/127 trn_rcms_caseregid = 16842000005891 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 11 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009145 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2021/127 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2021/127 Param Type = n trn_rcms_caseregid=16842000005891 Param Type = c transccode=18188 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 = 4 RecordId = 12017000009146 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2021/126 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2021/126 trn_rcms_caseregid = 16823000005958 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 12 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009146 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2021/126 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2021/126 Param Type = n trn_rcms_caseregid=16823000005958 Param Type = c transccode=18188 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 = 4 Adding new record to store data from Frame 2, Row 13 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12017000009147 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2021/125 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2021/125 trn_rcms_caseregid = 16788000005158 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 13 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009147 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2021/125 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2021/125 Param Type = n trn_rcms_caseregid=16788000005158 Param Type = c transccode=18188 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 = 6 Adding new record to store data from Frame 2, Row 14 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 6 RecordId = 12017000009148 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2021/124 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2021/124 trn_rcms_caseregid = 16764000005435 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 14 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009148 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2021/124 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2021/124 Param Type = n trn_rcms_caseregid=16764000005435 Param Type = c transccode=18188 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 = 6 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 = 12017000009149 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2021/128 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2021/128 trn_rcms_caseregid = 17105000006790 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 15 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009149 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2021/128 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2021/128 Param Type = n trn_rcms_caseregid=17105000006790 Param Type = c transccode=18188 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 = 6 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 = 5 RecordId = 12017000009150 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2021/146 fromcourt = 12836000000119 fromccode = 10366 transcourt = 1532660008306 case_no = 2021/146 trn_rcms_caseregid = 13505000006366 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 16 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009150 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2021/146 Param Type = n fromcourt=12836000000119 Param Type = c fromccode=10366 Param Type = n transcourt=1532660008306 Param Type = c case_no=2021/146 Param Type = n trn_rcms_caseregid=13505000006366 Param Type = c transccode=18188 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 = 12017000009151 Select sysdate as sdt from dual Time elapsed = 6 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2021/3 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2021/3 trn_rcms_caseregid = 15798000004761 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 17 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009151 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2021/3 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2021/3 Param Type = n trn_rcms_caseregid=15798000004761 Param Type = c transccode=18188 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 = 6 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 = 5 RecordId = 12017000009152 Select sysdate as sdt from dual Time elapsed = 6 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2020/00146 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2020/00146 trn_rcms_caseregid = 18508000005324 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 18 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009152 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2020/00146 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2020/00146 Param Type = n trn_rcms_caseregid=18508000005324 Param Type = c transccode=18188 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 = 4 Adding new record to store data from Frame 2, Row 19 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12017000009153 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2020/00036 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2020/00036 trn_rcms_caseregid = 16479000004028 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 19 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009153 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2020/00036 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2020/00036 Param Type = n trn_rcms_caseregid=16479000004028 Param Type = c transccode=18188 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 = 5 Adding new record to store data from Frame 2, Row 20 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12017000009154 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2019/00171 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2019/00171 trn_rcms_caseregid = 12773000002370 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 20 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009154 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2019/00171 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2019/00171 Param Type = n trn_rcms_caseregid=12773000002370 Param Type = c transccode=18188 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 = 7 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 = 5 RecordId = 12017000009155 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2019/00140 fromcourt = 12836000000119 fromccode = 10366 transcourt = 1532660008306 case_no = 2019/00140 trn_rcms_caseregid = 19337000002796 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 21 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009155 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2019/00140 Param Type = n fromcourt=12836000000119 Param Type = c fromccode=10366 Param Type = n transcourt=1532660008306 Param Type = c case_no=2019/00140 Param Type = n trn_rcms_caseregid=19337000002796 Param Type = c transccode=18188 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 = 4 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 = 2 RecordId = 12017000009156 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2019/00139 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2019/00139 trn_rcms_caseregid = 19231000002425 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 22 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009156 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2019/00139 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2019/00139 Param Type = n trn_rcms_caseregid=19231000002425 Param Type = c transccode=18188 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 = 5 Adding new record to store data from Frame 2, Row 23 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 12017000009157 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2019/00138 fromcourt = 12836000000119 fromccode = 10366 transcourt = 1532660008306 case_no = 2019/00138 trn_rcms_caseregid = 18994000002416 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 23 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009157 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2019/00138 Param Type = n fromcourt=12836000000119 Param Type = c fromccode=10366 Param Type = n transcourt=1532660008306 Param Type = c case_no=2019/00138 Param Type = n trn_rcms_caseregid=18994000002416 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=23 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 = 7 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 = 4 RecordId = 12017000009158 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2018/00295 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2018/00295 trn_rcms_caseregid = 11731000002492 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 24 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009158 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2018/00295 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2018/00295 Param Type = n trn_rcms_caseregid=11731000002492 Param Type = c transccode=18188 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 = 6 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 = 4 RecordId = 12017000009159 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2018/00294 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2018/00294 trn_rcms_caseregid = 11581000002645 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 25 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009159 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2018/00294 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2018/00294 Param Type = n trn_rcms_caseregid=11581000002645 Param Type = c transccode=18188 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 = 4 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 = 12017000009160 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2018/00200 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2018/00200 trn_rcms_caseregid = 11149000001643 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 26 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009160 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2018/00200 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2018/00200 Param Type = n trn_rcms_caseregid=11149000001643 Param Type = c transccode=18188 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 = 2 RecordId = 12017000009161 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2018/00165 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2018/00165 trn_rcms_caseregid = 11343000002270 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 27 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009161 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2018/00165 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2018/00165 Param Type = n trn_rcms_caseregid=11343000002270 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=27 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 28 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 6 RecordId = 12017000009162 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2018/00164 fromcourt = 12836000000119 fromccode = 10366 transcourt = 1532660008306 case_no = 2018/00164 trn_rcms_caseregid = 11297000001835 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 28 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009162 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2018/00164 Param Type = n fromcourt=12836000000119 Param Type = c fromccode=10366 Param Type = n transcourt=1532660008306 Param Type = c case_no=2018/00164 Param Type = n trn_rcms_caseregid=11297000001835 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=28 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 29 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 12017000009163 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2018/00163 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2018/00163 trn_rcms_caseregid = 11262000002021 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 29 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009163 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2018/00163 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2018/00163 Param Type = n trn_rcms_caseregid=11262000002021 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=29 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 30 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 5 RecordId = 12017000009164 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2018/00162 fromcourt = 12836000000119 fromccode = 10366 transcourt = 1532660008306 case_no = 2018/00162 trn_rcms_caseregid = 11217000002107 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 30 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009164 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2018/00162 Param Type = n fromcourt=12836000000119 Param Type = c fromccode=10366 Param Type = n transcourt=1532660008306 Param Type = c case_no=2018/00162 Param Type = n trn_rcms_caseregid=11217000002107 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=30 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 31 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 12017000009165 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2017/00725 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2017/00725 trn_rcms_caseregid = 11412000001531 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 31 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009165 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2017/00725 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2017/00725 Param Type = n trn_rcms_caseregid=11412000001531 Param Type = c transccode=18188 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 = 3 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 = 3 RecordId = 12017000009166 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2017/00721 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2017/00721 trn_rcms_caseregid = 10780000001313 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 32 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009166 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2017/00721 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2017/00721 Param Type = n trn_rcms_caseregid=10780000001313 Param Type = c transccode=18188 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 = 3 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 = 3 RecordId = 12017000009167 Select sysdate as sdt from dual Time elapsed = 6 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2017/00547 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2017/00547 trn_rcms_caseregid = 15481000001258 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 33 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009167 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2017/00547 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2017/00547 Param Type = n trn_rcms_caseregid=15481000001258 Param Type = c transccode=18188 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 = 5 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 = 4 RecordId = 12017000009168 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2017/00543 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2017/00543 trn_rcms_caseregid = 19839000000859 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 34 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009168 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2017/00543 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2017/00543 Param Type = n trn_rcms_caseregid=19839000000859 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=34 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 35 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 5 RecordId = 12017000009169 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2016/00222 fromcourt = 12836000000119 fromccode = 10366 transcourt = 1532660008306 case_no = 2016/00222 trn_rcms_caseregid = 10817000000268 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 35 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009169 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2016/00222 Param Type = n fromcourt=12836000000119 Param Type = c fromccode=10366 Param Type = n transcourt=1532660008306 Param Type = c case_no=2016/00222 Param Type = n trn_rcms_caseregid=10817000000268 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=35 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 36 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12017000009170 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2016/00220 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2016/00220 trn_rcms_caseregid = 10767000000251 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 36 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009170 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2016/00220 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2016/00220 Param Type = n trn_rcms_caseregid=10767000000251 Param Type = c transccode=18188 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 = 4 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 = 4 RecordId = 12017000009171 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2016/00068 fromcourt = 12836000000119 fromccode = 10366 transcourt = 1532660008306 case_no = 2016/00068 trn_rcms_caseregid = 17965000000185 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 37 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009171 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2016/00068 Param Type = n fromcourt=12836000000119 Param Type = c fromccode=10366 Param Type = n transcourt=1532660008306 Param Type = c case_no=2016/00068 Param Type = n trn_rcms_caseregid=17965000000185 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=37 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 38 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 5 RecordId = 12017000009172 Select sysdate as sdt from dual Time elapsed = 6 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2016/00067 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2016/00067 trn_rcms_caseregid = 17877000000193 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 38 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009172 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2016/00067 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2016/00067 Param Type = n trn_rcms_caseregid=17877000000193 Param Type = c transccode=18188 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 = 4 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 = 4 RecordId = 12017000009173 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2016/00365 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2016/00365 trn_rcms_caseregid = 18766000001008 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 39 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009173 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2016/00365 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2016/00365 Param Type = n trn_rcms_caseregid=18766000001008 Param Type = c transccode=18188 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 = 3 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 = 4 RecordId = 12017000009174 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2015/00244 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2015/00244 trn_rcms_caseregid = 17345000000146 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 40 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009174 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2015/00244 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2015/00244 Param Type = n trn_rcms_caseregid=17345000000146 Param Type = c transccode=18188 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 = 4 RecordId = 12017000009175 Select sysdate as sdt from dual Time elapsed = 5 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2015/00447 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2015/00447 trn_rcms_caseregid = 18197000000351 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 41 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009175 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2015/00447 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2015/00447 Param Type = n trn_rcms_caseregid=18197000000351 Param Type = c transccode=18188 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 = 12017000009176 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2014/00088 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2014/00088 trn_rcms_caseregid = 13029000000267 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 42 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009176 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2014/00088 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2014/00088 Param Type = n trn_rcms_caseregid=13029000000267 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=42 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 43 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 12017000009177 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2014/00066 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2014/00066 trn_rcms_caseregid = 17843000000195 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 43 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009177 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2014/00066 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2014/00066 Param Type = n trn_rcms_caseregid=17843000000195 Param Type = c transccode=18188 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 = 2 RecordId = 12017000009178 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2013/00059 fromcourt = 12836000000119 fromccode = 10366 transcourt = 1532660008306 case_no = 2013/00059 trn_rcms_caseregid = 17267000000332 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 44 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009178 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2013/00059 Param Type = n fromcourt=12836000000119 Param Type = c fromccode=10366 Param Type = n transcourt=1532660008306 Param Type = c case_no=2013/00059 Param Type = n trn_rcms_caseregid=17267000000332 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=44 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 45 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12017000009179 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2013/00044 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2013/00044 trn_rcms_caseregid = 13235000000300 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 45 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009179 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2013/00044 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2013/00044 Param Type = n trn_rcms_caseregid=13235000000300 Param Type = c transccode=18188 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 = 4 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 = 12017000009180 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2011/00011 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2011/00011 trn_rcms_caseregid = 19480000000607 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 46 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009180 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2011/00011 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2011/00011 Param Type = n trn_rcms_caseregid=19480000000607 Param Type = c transccode=18188 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 = 12017000009181 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2010/00006 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2010/00006 trn_rcms_caseregid = 14062000000248 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 47 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009181 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2010/00006 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2010/00006 Param Type = n trn_rcms_caseregid=14062000000248 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=47 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 48 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 5 RecordId = 12017000009182 Select sysdate as sdt from dual Time elapsed = 7 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2010/00007 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2010/00007 trn_rcms_caseregid = 14323000000132 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 48 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009182 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2010/00007 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2010/00007 Param Type = n trn_rcms_caseregid=14323000000132 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=48 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 49 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 5 RecordId = 12017000009183 Select sysdate as sdt from dual Time elapsed = 6 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2010/00005 fromcourt = 12836000000119 fromccode = 10366 transcourt = 1532660008306 case_no = 2010/00005 trn_rcms_caseregid = 19661000000105 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 49 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009183 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2010/00005 Param Type = n fromcourt=12836000000119 Param Type = c fromccode=10366 Param Type = n transcourt=1532660008306 Param Type = c case_no=2010/00005 Param Type = n trn_rcms_caseregid=19661000000105 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=49 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 50 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12017000009184 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2007/00005 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2007/00005 trn_rcms_caseregid = 16472000000245 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 50 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009184 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2007/00005 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2007/00005 Param Type = n trn_rcms_caseregid=16472000000245 Param Type = c transccode=18188 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 = 5 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 = 4 RecordId = 12017000009185 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2005/00004 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2005/00004 trn_rcms_caseregid = 11275000000414 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 51 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009185 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2005/00004 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2005/00004 Param Type = n trn_rcms_caseregid=11275000000414 Param Type = c transccode=18188 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 = 4 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 = 4 RecordId = 12017000009186 Select sysdate as sdt from dual Time elapsed = 6 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2002/00004 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2002/00004 trn_rcms_caseregid = 11053000000332 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 52 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009186 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2002/00004 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2002/00004 Param Type = n trn_rcms_caseregid=11053000000332 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=52 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 53 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 12017000009187 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2002/00002 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2002/00002 trn_rcms_caseregid = 10463000000406 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 53 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009187 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2002/00002 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2002/00002 Param Type = n trn_rcms_caseregid=10463000000406 Param Type = c transccode=18188 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) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 13 Adding new record to store data from Frame 2, Row 54 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 12017000009188 Select sysdate as sdt from dual Time elapsed = 4 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2002/00003 fromcourt = 12836000000119 fromccode = 10366 transcourt = 1532660008306 case_no = 2002/00003 trn_rcms_caseregid = 10575000000331 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 54 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009188 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2002/00003 Param Type = n fromcourt=12836000000119 Param Type = c fromccode=10366 Param Type = n transcourt=1532660008306 Param Type = c case_no=2002/00003 Param Type = n trn_rcms_caseregid=10575000000331 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=54 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 55 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12017000009189 Select sysdate as sdt from dual Time elapsed = 3 decision_date = 08/11/2023 status = 0 transContFld = T requestno = 10366-18188#2002/00001 transcourt = 1532660008306 fromccode = 10366 fromcourt = 12836000000119 case_no = 2002/00001 trn_rcms_caseregid = 10039000000203 transccode = 18188 TRN_RCMS_TRANSREQDTLrow = 55 Posting record Param Type = n trn_rcms_transreqdtlid=12017000009189 Param Type = n trn_rcms_transreqid=12017000009134 Param Type = c decision_date=08/11/2023 00:00:00 Param Type = n status=0 Param Type = c transcontfld=T Param Type = c requestno=10366-18188#2002/00001 Param Type = n transcourt=1532660008306 Param Type = c fromccode=10366 Param Type = n fromcourt=12836000000119 Param Type = c case_no=2002/00001 Param Type = n trn_rcms_caseregid=10039000000203 Param Type = c transccode=18188 Param Type = n trn_rcms_transreqdtlrow=55 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 = 3916680511938 >>Executing genmaps >>Posting from rctcr to tscd from row 1 >>Mapping Mapped court_code Row = 1 value = 10366 idvalue 0 Mapped case_no Row = 1 value = 2023/67 idvalue 0 Mapped new_case_purpose Row = 1 value = ????????? idvalue 1025550004746 Mapped decision_type Row = 1 value = ????????? idvalue 11782000000706 Mapped decision_date Row = 1 value = 08/11/2023 idvalue 0 Mapped hearing_date Row = 1 value = 08/11/2023 idvalue 0 Mapped pagesource Row = 1 value = TRANSPAGE idvalue 0 >>Validating tscd >>Frame No 1 currdate = Evaluating - date() Result of date = 09/02/2024 currdate after validation = 09/02/2024 court_name = username=ADM_dosa_r select court_name_mastid,court_name,court_code from v_axcourts where paxusername=:username username=ADM_dosa_r Time elapsed = 6 Evaluating - m_courtname m_courtname = ???????? ???? ???????,???? court_name after validation = ???????? ???? ???????,???? Id = 12836000000119 court_code = 10366 Finding linkfield in fieldenter function Linkfield found and assigning Query from link field in fieldenter function Query assigned in fieldenter function viewfilter = Evaluating - {AND a1.court_code=:m_courtcode } viewfilter after validation = AND a1.court_code=:m_courtcode case_no = 2023/67 casedetails = court_code=10366 case_no=2023/67 recordid=0 SELECT A1.COURT_CODE, A1.TRN_RCMS_CASEREGID, A1.INSTITUTION_DATE, A1.CASE_NO, A1.MCASE_NO, A1.LAST_HEARING_DATE AS hearing_date, B2.DISTRICT_NAME, B3.CASE_TYPE, B1.CASE_PURPOSE_NAME, A1.CASE_PURPOSE_NAME AS CPID, B4.ACT_NAME, A1.SECTION_NAME, A1.PRIMARY_APPELLANT AS APPELLANT_NAME, A1.PRIMARY_RESPONDENT AS RESPONDENT_NAME FROM trn_rcms_casereg a1, case_purpose_mast b1, district_mast b2, case_type_mast b3, rule_act_mast b4 WHERE A1.CASE_PURPOSE_NAME = B1.CASE_PURPOSE_MASTID AND A1.DISTRICT_NAME = B2.DISTRICT_MASTID AND A1.ACT_NAME = B4.RULE_ACT_MASTID AND A1.CASE_TYPE = B3.CASE_TYPE_MASTID AND A1.COURT_CODE = :court_code AND a1.CASE_NO = :case_no AND (CASE WHEN :recordid > 0 THEN 1 WHEN :recordid = 0 AND b1.CASE_PURPOSE_MASTID <> 1364660005542 AND b1.CASE_PURPOSE_GROUP <> 18438000000000 AND NOT EXISTS (SELECT 1 FROM TRN_RCMS_DECISION WHERE TRN_RCMS_CASEID = a1.TRN_RCMS_CASEREGID) THEN 1 ELSE 0 END) = 1 court_code=10366 case_no=2023/67 recordid=0 recordid=0 Time elapsed = 17 trn_rcms_caseid = Finding linkfield in fieldenter function Linkfield found and assigning Query from link field in fieldenter function Query assigned in fieldenter function S=0 Select trn_rcms_caseid from trn_rcms_decision where trn_rcms_caseid = :S S=0 Time elapsed = 442 Duplicate values are not allowed in Case No. Error : Select sysdate as sdt from dual Time elapsed = 5 insert into axerrorlog values('ADM_dosa_r',to_date('09/02/2024 22:48:56','dd/mm/yyyy hh24:mi:ss'),'rctcr','SaveData','') Time elapsed = 14 Constraint Name = 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_dosa_r Param Type = c calledon=09/02/2024 22:48:26 Param Type = c callfinished=09/02/2024 22:48:32 Param Type = c structname=rctcr Param Type = n recordid=0 Param Type = c servicename=Saving data Param Type = c serviceresult=Duplicate values are not allowed in Case No. Param Type = n timetaken=5730 Param Type = n dbtimetaken=3431 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