Dear Tomas, I really appreciate you valuable update, it helped me to follow the right path.After implementing the Transaction_SYS.Deferred_Call based on your advice, the database task is executed succssfully, but when i check the background job deails , I’m getting another issue as explained below:Seems to me arguments which i’m passing are not accepted.declareattr_ varchar2(2000);v_id_ number;BEGINclient_sys.clear_attr(attr_);client_sys.add_to_attr('company_id_', 'RCA' ,attr_);client_sys.add_to_attr('payroll_id_', '2021-8' ,attr_);client_sys.add_to_attr('regulation_id_', '%',attr_);client_sys.add_to_attr('emp_id_','%',attr_);client_sys.add_to_attr('wage_code_id_', '%' ,attr_);client_sys.add_to_attr('absence_code_','%',attr_);transaction_sys.deferred_call( id_=> v_id_,procedure_name_ => 'Hrp_Pay_List_API.C_Execute_Absence_Data',argument_type_db_=>'ATTRIBUTE',arguments_=> attr_,description_=>'Hrp_Pay_List_API.C_Execute_Absence_Data');COMMIT;END;Custom Menu PL/SQL CodeTh
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.