Hi Experts,
We are using Oracle Forms & Reports 6i and in planning to upgrade it to 11g R2, DB 10g R2 and in planning to upgrade it to 11g R2 or 12C.
Before to that we are facing a strange problem for which I couldn't find any answer online. The Problem is We are using Forms & Reports 6i as Front end for a Payroll Process Software (Custom Software). When we are processing through Forms, some of the procedures will execute and start the process in server end.
Now the problem is, process for the category which contains less employees is completing successfully as expected and will give a popup like processed successfully. But for the category which contains more employees, the process is starting and not giving a process completion popup. instead its giving - "Error while processing ORA-03113: end-of-file on communication channel" as in attached snap shot.
Here the process is completing at the server end but the same is not returning to forms. due to which the data is getting processed perfectly and all the values are matching with manual files. But the process is not updating the completion confirmation into the DB tables which has to be done after returning to the Forms.
Program is like : When end user process the Payroll, process will do some initialization and will call procedure, once the procedure completed process will get back to Oracle Forms (calling place) and do some more operations and then confirm the popup completion.
I searched everywhere and googled it and got no solution.
Thanks in advance.