ASB XE3/32/64 DLL running [Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][] DB Manager created gcmsACEM_dosa827ccb0eea8a706c4c34a16891f84e7brctcr001054610037014921000000046105461211800000002410037196720000080552023/1410546-10037#2023/1408/08/20250F014921000000046105461211800000002410037197140000067122023/1510546-10037#2023/1508/08/20250F014921000000046105461211800000002410037101140000093292023/10110546-10037#2023/10108/08/20250F014921000000046105461211800000002410037101660000076432023/10210546-10037#2023/10208/08/20250F014921000000046105461211800000002410037166140000068282022/23410546-10037#2022/23408/08/20250F014921000000046105461211800000002410037166230000079652022/23510546-10037#2022/23508/08/20250F014921000000046105461211800000002410037175750000068872022/10910546-10037#2022/10908/08/20250F014921000000046105461211800000002410037176410000061702022/11010546-10037#2022/11008/08/20250F014921000000046105461211800000002410037177930000065612021/3110546-10037#2021/3108/08/20250F014921000000046105461211800000002410037125080000040042020/0006210546-10037#2020/0006208/08/20250F014921000000046105461211800000002410037125550000037552020/0006310546-10037#2020/0006308/08/20250F014921000000046105461211800000002410037122700000031782019/0014710546-10037#2019/0014708/08/20250F014921000000046105461211800000002410037123450000028632019/0014810546-10037#2019/0014808/08/20250F014921000000046105461211800000002410037110430000017092018/0024210546-10037#2018/0024208/08/20250F014921000000046105461211800000002410037152540000014992018/0005910546-10037#2018/0005908/08/20250F Executing Savedata webservice ----------------------------- Received JSON : {"savedata":{"axpapp":"gcms","username":"ACEM_dosa","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"rctcr","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"court_code":"10546","trans_ccode":"10037"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19672000008055","case_no":"2023/14","requestno":"10546-10037#2023/14","decision_date":"08/08/2025","status":"0","transContFld":"F"}},{"rowno":"002","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"19714000006712","case_no":"2023/15","requestno":"10546-10037#2023/15","decision_date":"08/08/2025","status":"0","transContFld":"F"}},{"rowno":"003","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"10114000009329","case_no":"2023/101","requestno":"10546-10037#2023/101","decision_date":"08/08/2025","status":"0","transContFld":"F"}},{"rowno":"004","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"10166000007643","case_no":"2023/102","requestno":"10546-10037#2023/102","decision_date":"08/08/2025","status":"0","transContFld":"F"}},{"rowno":"005","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"16614000006828","case_no":"2022/234","requestno":"10546-10037#2022/234","decision_date":"08/08/2025","status":"0","transContFld":"F"}},{"rowno":"006","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"16623000007965","case_no":"2022/235","requestno":"10546-10037#2022/235","decision_date":"08/08/2025","status":"0","transContFld":"F"}},{"rowno":"007","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"17575000006887","case_no":"2022/109","requestno":"10546-10037#2022/109","decision_date":"08/08/2025","status":"0","transContFld":"F"}},{"rowno":"008","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"17641000006170","case_no":"2022/110","requestno":"10546-10037#2022/110","decision_date":"08/08/2025","status":"0","transContFld":"F"}},{"rowno":"009","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"17793000006561","case_no":"2021/31","requestno":"10546-10037#2021/31","decision_date":"08/08/2025","status":"0","transContFld":"F"}},{"rowno":"0010","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12508000004004","case_no":"2020/00062","requestno":"10546-10037#2020/00062","decision_date":"08/08/2025","status":"0","transContFld":"F"}},{"rowno":"0011","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12555000003755","case_no":"2020/00063","requestno":"10546-10037#2020/00063","decision_date":"08/08/2025","status":"0","transContFld":"F"}},{"rowno":"0012","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12270000003178","case_no":"2019/00147","requestno":"10546-10037#2019/00147","decision_date":"08/08/2025","status":"0","transContFld":"F"}},{"rowno":"0013","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"12345000002863","case_no":"2019/00148","requestno":"10546-10037#2019/00148","decision_date":"08/08/2025","status":"0","transContFld":"F"}},{"rowno":"0014","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"11043000001709","case_no":"2018/00242","requestno":"10546-10037#2018/00242","decision_date":"08/08/2025","status":"0","transContFld":"F"}},{"rowno":"0015","text":"0","columns":{"fromcourt":"14921000000046","fromccode":"10546","transcourt":"12118000000024","transccode":"10037","trn_rcms_caseregid":"15254000001499","case_no":"2018/00059","requestno":"10546-10037#2018/00059","decision_date":"08/08/2025","status":"0","transContFld":"F"}}]}]}} Verifying username and password User Name : ACEM_dosa Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app' U=acem_dosa Time elapsed = 15 Password checking along with max.no of login specified in app.xml update axusers set logintry = 0 where lower(username) = :U Time elapsed = 0 Result : Verifying completed... Page Access Category : User Name : acem_dosa Select sysdate as sdt from dual Time elapsed = 16 dt=20/08/2025 16:57:07 Select sysdate as sdt from dual Time elapsed = 0 Select usergroup from AXUSERLEVELGROUPS WHERE (lower(username) =:U) and ((startdate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') >= startdate) or (startdate is null)) and ((enddate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') <= enddate) or (enddate is null)) U=acem_dosa dt=20/08/2025 16:57:07 dt=20/08/2025 16:57:07 Time elapsed = 15 User Groups: court_reader select userroles from axusergroups where groupname in ( 'court_reader' ) Time elapsed = 0 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 = 0 Step4 axprops\stm size:4235 Step4-123456 images\Generalized Court Management SystemINRF500250000F00000F Step4-4 Step5 Step6 Step9 fetched the props xml 10010000-1000000 2 Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1}) Calling function firesql username=ACEM_dosa select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=ACEM_dosa Time elapsed = 16 Result of firesql = Result = Evaluating sqlget({m2},{court_name}) Calling function sqlget Result of sqlget = ????? ???????,???? Result = ????? ???????,???? Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1}) Calling function firesql username=ACEM_dosa select a.court_type from v_axcourts a where a.paxusername= :username order by 1 username=ACEM_dosa Time elapsed = 0 Result of firesql = Result = Evaluating sqlget({m3},{court_type}) Calling function sqlget Result of sqlget = ACEM Result = ACEM Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1}) Calling function firesql username=ACEM_dosa select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1 username=ACEM_dosa Time elapsed = 0 Result of firesql = Result = Evaluating sqlget({m4},{court_name_mastid}) Calling function sqlget Result of sqlget = 14921000000046 Result = 14921000000046 Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username}) Calling function firesql select a1.axusersid from axusers a1 where a1.username=:username username=ACEM_dosa Time elapsed = 0 Result of firesql = Result = Evaluating sqlget({m4},{axusersid}) Calling function sqlget Result of sqlget = 4242 Result = 4242 Evaluating firesql({m4},{select :username as uname from dual}) Calling function firesql select :username as uname from dual username=ACEM_dosa Time elapsed = 16 Result of firesql = Result = Evaluating sqlget({m4},{uname}) Calling function sqlget Result of sqlget = ACEM_dosa Result = ACEM_dosa Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1}) Calling function firesql select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=ACEM_dosa Time elapsed = 16 Result of firesql = Result = Evaluating sqlget({m4},{COURT_CODE}) Calling function sqlget Result of sqlget = 10546 Result = 10546 Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'}) Calling function firesql select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ' Time elapsed = 0 Result of firesql = Result = Evaluating sqlget({m2},{STATE_NAME}) Calling function sqlget Result of sqlget = ???????? Result = ???????? Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=ACEM_dosa SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=ACEM_dosa Time elapsed = 15 Result of firesql = Result = Evaluating sqlget({m7},{DISTNAMEENG}) Calling function sqlget Result of sqlget = Dausa Result = Dausa Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=ACEM_dosa SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=ACEM_dosa Time elapsed = 0 Result of firesql = Result = Evaluating sqlget({m8},{COURT_CATEGOTY}) Calling function sqlget Result of sqlget = 10593000000007 Result = 10593000000007 Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid}) Calling function firesql login_userid=4242 select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid login_userid=4242 Time elapsed = 15 Result of firesql = Result = Evaluating sqlget({m4},{department_mastid}) Calling function sqlget Result of sqlget = 1579880000000 Result = 1579880000000 Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1}) Calling function firesql select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1 username=ACEM_dosa Time elapsed = 16 Result of firesql = Result = Evaluating sqlget({m3},{court_type_mastid}) Calling function sqlget Result of sqlget = 10257000000001 Result = 10257000000001 Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username }) Calling function firesql username=ACEM_dosa select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username username=ACEM_dosa Time elapsed = 16 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 = 0 Result of firesql = Result = Evaluating sqlget({a1},{dd}) Calling function sqlget Result of sqlget = 30/01/2021 Result = 30/01/2021 Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0}) Calling function firesql username=ACEM_dosa SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0 username=ACEM_dosa Time elapsed = 15 Result of firesql = Result = Evaluating sqlget({P1},{ct}) Calling function sqlget Result of sqlget = 17 Result = 17 3 completed LoadAppVars Password validation done successfully select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='rctcr' and stype = 't' ) Time elapsed = 16 select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='rctcr' and stype = 't' Time elapsed = 0 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 = 0 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 = 0 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 = 0 select * from trn_rcms_transreq where trn_rcms_transreqid=0 Time elapsed = 16 select * from Axusers where 1=2 Time elapsed = 0 select distinct(fldname) from AxTempUserFields Time elapsed = 16 select * from AxAttachWorkflow where lower(transid) = 'rctcr' Time elapsed = 0 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 = 0 Step4 tstructs\stm size:6667 Step4-0 Step4-1 Step4-2 Step4-3 Step4-4 Step5 Step6 Step9 select lpad(' ', 250, ' ') LVAL from dual Time elapsed = 0 Post on approve = False select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout) tid=tscd adxinout=o Time elapsed = 0 select * from trn_rcms_decision where trn_rcms_decisionid=0 Time elapsed = 0 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 = 0 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 = 0 select * from trn_rcms_hearing where trn_rcms_hearingid=0 Time elapsed = 0 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 = 0 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 = 0 select * from trn_rcms_case_hist where trn_rcms_case_histid=0 Time elapsed = 15 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 = 0 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 = 0 select * from trn_rcms_case_hist where trn_rcms_case_histid=0 Time elapsed = 16 select distinct(schemaname) from axschema where lower(transid)='tscrg' Time elapsed = 0 select trn_rcms_caseregid from trn_rcms_casereg where trn_rcms_caseregid=0 Time elapsed = 0 select case_decision_date from trn_rcms_casereg where trn_rcms_caseregid=0 Time elapsed = 0 select distinct(schemaname) from axschema where lower(transid)='tscrg' Time elapsed = 16 select decision_type from trn_rcms_casereg where trn_rcms_caseregid=0 Time elapsed = 0 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 = 20/08/2025 currdate after validation = 20/08/2025 court_code = 10546 trans_ccode = 10037 case_purpose = SELECT b.CASE_PURPOSE_MASTID, b.CASE_PURPOSE_NAME, b.case_purpose_code FROM case_purpose_mast b WHERE CASE_PURPOSE_MASTID = 1025550004746 Time elapsed = 0 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 = 0 dec_type after validation = ????????? Id = 11782000000706 time zone difference = 0 >>Writing to tables rctcr Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rctcr' Time elapsed = 0 Saving to table TRN_RCMS_TRANSREQ select * from TRN_RCMS_TRANSREQ where TRN_RCMS_TRANSREQid=0 Time elapsed = 0 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 0 RecordId = 13699000009468 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 0 Select sysdate as sdt from dual Time elapsed = 31 trans_ccode = 10037 court_code = 10546 Posting record Param Type = n trn_rcms_transreqid=13699000009468 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=ACEM_dosa Param Type = c createdon=20/08/2025 16:57:07 Param Type = c username=ACEM_dosa Param Type = c modifiedon=20/08/2025 16:57:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c trans_ccode=10037 Param Type = c court_code=10546 insert into TRN_RCMS_TRANSREQ (trn_rcms_transreqid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_ccode,court_code) values (:trn_rcms_transreqid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_ccode,:court_code) Saving to table TRN_RCMS_TRANSREQDTL select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 0 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 = 0 RecordId = 13699000009469 Select sysdate as sdt from dual Time elapsed = 15 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2023/14 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2023/14 trn_rcms_caseregid = 19672000008055 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 1 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009469 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2023/14 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2023/14 Param Type = n trn_rcms_caseregid=19672000008055 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=1 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 0 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 = 0 RecordId = 13699000009470 Select sysdate as sdt from dual Time elapsed = 0 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2023/15 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2023/15 trn_rcms_caseregid = 19714000006712 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 2 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009470 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2023/15 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2023/15 Param Type = n trn_rcms_caseregid=19714000006712 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=2 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 0 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 = 16 RecordId = 13699000009471 Select sysdate as sdt from dual Time elapsed = 0 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2023/101 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2023/101 trn_rcms_caseregid = 10114000009329 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 3 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009471 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2023/101 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2023/101 Param Type = n trn_rcms_caseregid=10114000009329 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=3 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 0 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 = 0 RecordId = 13699000009472 Select sysdate as sdt from dual Time elapsed = 15 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2023/102 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2023/102 trn_rcms_caseregid = 10166000007643 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 4 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009472 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2023/102 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2023/102 Param Type = n trn_rcms_caseregid=10166000007643 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=4 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 0 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 = 0 RecordId = 13699000009473 Select sysdate as sdt from dual Time elapsed = 0 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2022/234 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2022/234 trn_rcms_caseregid = 16614000006828 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 5 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009473 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2022/234 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2022/234 Param Type = n trn_rcms_caseregid=16614000006828 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=5 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 0 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 = 15 RecordId = 13699000009474 Select sysdate as sdt from dual Time elapsed = 0 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2022/235 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2022/235 trn_rcms_caseregid = 16623000007965 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 6 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009474 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2022/235 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2022/235 Param Type = n trn_rcms_caseregid=16623000007965 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=6 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,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 = 0 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 = 0 RecordId = 13699000009475 Select sysdate as sdt from dual Time elapsed = 0 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2022/109 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2022/109 trn_rcms_caseregid = 17575000006887 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 7 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009475 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2022/109 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2022/109 Param Type = n trn_rcms_caseregid=17575000006887 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=7 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,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 = 0 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 = 16 RecordId = 13699000009476 Select sysdate as sdt from dual Time elapsed = 0 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2022/110 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2022/110 trn_rcms_caseregid = 17641000006170 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 8 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009476 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2022/110 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2022/110 Param Type = n trn_rcms_caseregid=17641000006170 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=8 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,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 = 0 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 = 0 RecordId = 13699000009477 Select sysdate as sdt from dual Time elapsed = 0 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2021/31 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2021/31 trn_rcms_caseregid = 17793000006561 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 9 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009477 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2021/31 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2021/31 Param Type = n trn_rcms_caseregid=17793000006561 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=9 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,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 = 0 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 = 0 RecordId = 13699000009478 Select sysdate as sdt from dual Time elapsed = 16 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2020/00062 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2020/00062 trn_rcms_caseregid = 12508000004004 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 10 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009478 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2020/00062 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2020/00062 Param Type = n trn_rcms_caseregid=12508000004004 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=10 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,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 = 0 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 = 0 RecordId = 13699000009479 Select sysdate as sdt from dual Time elapsed = 0 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2020/00063 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2020/00063 trn_rcms_caseregid = 12555000003755 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 11 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009479 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2020/00063 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2020/00063 Param Type = n trn_rcms_caseregid=12555000003755 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=11 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 0 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 = 0 RecordId = 13699000009480 Select sysdate as sdt from dual Time elapsed = 0 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2019/00147 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2019/00147 trn_rcms_caseregid = 12270000003178 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 12 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009480 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2019/00147 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2019/00147 Param Type = n trn_rcms_caseregid=12270000003178 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=12 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 0 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 = 16 RecordId = 13699000009481 Select sysdate as sdt from dual Time elapsed = 0 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2019/00148 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2019/00148 trn_rcms_caseregid = 12345000002863 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 13 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009481 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2019/00148 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2019/00148 Param Type = n trn_rcms_caseregid=12345000002863 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=13 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0 Time elapsed = 0 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 = 0 RecordId = 13699000009482 Select sysdate as sdt from dual Time elapsed = 0 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2018/00242 fromcourt = 14921000000046 fromccode = 10546 transcourt = 12118000000024 case_no = 2018/00242 trn_rcms_caseregid = 11043000001709 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 14 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009482 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2018/00242 Param Type = n fromcourt=14921000000046 Param Type = c fromccode=10546 Param Type = n transcourt=12118000000024 Param Type = c case_no=2018/00242 Param Type = n trn_rcms_caseregid=11043000001709 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=14 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,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 = 16 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 = 0 RecordId = 13699000009483 Select sysdate as sdt from dual Time elapsed = 0 decision_date = 08/08/2025 status = 0 transContFld = F requestno = 10546-10037#2018/00059 transcourt = 12118000000024 fromccode = 10546 fromcourt = 14921000000046 case_no = 2018/00059 trn_rcms_caseregid = 15254000001499 transccode = 10037 TRN_RCMS_TRANSREQDTLrow = 15 Posting record Param Type = n trn_rcms_transreqdtlid=13699000009483 Param Type = n trn_rcms_transreqid=13699000009468 Param Type = c decision_date=08/08/2025 00:00:00 Param Type = n status=0 Param Type = c transcontfld=F Param Type = c requestno=10546-10037#2018/00059 Param Type = n transcourt=12118000000024 Param Type = c fromccode=10546 Param Type = n fromcourt=14921000000046 Param Type = c case_no=2018/00059 Param Type = n trn_rcms_caseregid=15254000001499 Param Type = c transccode=10037 Param Type = n trn_rcms_transreqdtlrow=15 insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow) Time elapsed for insert/update = 3964870631526 >>Executing genmaps >>Posting from rctcr to tscd from row 1 >>Posting from rctcr to tscd from row 2 >>Posting from rctcr to tscd from row 3 >>Posting from rctcr to tscd from row 4 >>Posting from rctcr to tscd from row 5 >>Posting from rctcr to tscd from row 6 >>Posting from rctcr to tscd from row 7 >>Posting from rctcr to tscd from row 8 >>Posting from rctcr to tscd from row 9 >>Posting from rctcr to tscd from row 10 >>Posting from rctcr to tscd from row 11 >>Posting from rctcr to tscd from row 12 >>Posting from rctcr to tscd from row 13 >>Posting from rctcr to tscd from row 14 >>Posting from rctcr to tscd from row 15 Time elapsed for Gen Map = 3964870631526 Time elapsed for MD Map = 3964870631526 Time elapsed for Save History = 3964870631526 Time elapsed for Save Attachment = 3964870631526 Time elapsed for After Save WF Exec = 3964870631526 Transaction commited Result : {"message":[{"msg":"Request for Case Transfer Saved","recordid":"13699000009468"}]} Savedata webservice completed Freeing DbCall Resources Freeing Store data Freeing DD Map Freeing Provide Link Freeing Validate Freeing Parser Freeing Poststr Freeing Maxrows Freeing Fnames Freeing NewMaxRows Freeing tlines Freeing workquery Freeing Struct Freeing EventList Freeing Tree Obj Freeing Workflow Obj Freeing DbCall Completed Freeing Action Obj Resources Closing connection # 1#Saving to log Param Type = c username=ACEM_dosa Param Type = c calledon=20/08/2025 16:57:10 Param Type = c callfinished=20/08/2025 16:57:11 Param Type = c structname=rctcr Param Type = n recordid=0 Param Type = c servicename=Saving data Param Type = c serviceresult=success Param Type = n timetaken=1375 Param Type = n dbtimetaken=736 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