Hi All,
We have custom Procedure in Custom Package [C_Payroll_PKG.C_Run_payroll ], this procedure i need to give our users to execute it. Basically this procedure takes more than 3 hrs to run, therefore i created database take to call this procedure. Now i want the user to run this database task via custom menu. I created the cusom menu with the following:
Action Type: PL/SQL Block
PL/SQL Block:
declare
v_job_no number;
begin
ifsapp.dbms_job.submit (v_job_no , ‘C_Payroll_PKG.C_Run_Payroll’,sysdate);
end;
when i press Test button to check it, i got the following Error:
FNDSQLFORBIDDEN: Forbidden PLSQL code rejected: “DBMS_JOB” ..
If its not possible to run db job from custom menu and advice aproach you are suggesting??
Regards,
Nasser Al-Shabibi