Improve Workflow Notification Response time

Quick Note: 

After user responds to a notification, the control returns after processing the subsequent function activities. In case of any costly activity; user can face delay in response. By setting up following, response processing will be deferred and control will return immediately.

Login from SYSADMIN

Go to “Workflow Administrator”=>” Administrator Workflow”=>”Administration”

Or “System Administrator”=> “Workflow”=>” Administrator Workflow”=>”Administration”

Add Following lines as per screenshot in “Notification Response” and test the AP Invoice Delay issue after approval

 

Function to Get GL Code Segment1 for the Organization ID

FUNCTION get_account_segment1 (p_org_id IN NUMBER) RETURN VARCHAR2  AS
  l_segment1 VARCHAR2 (25);
BEGIN
  SELECT gcc.segment1 INTO l_segment1
    FROM financials_system_params_all fsp,gl_ledgers gsb, gl_code_combinations gcc
   WHERE fsp.org_id = p_org_id
     AND fsp.set_of_books_id = gsb.ledger_id
     AND gsb.chart_of_accounts_id = gcc.chart_of_accounts_id
     AND fsp.accts_pay_code_combination_id = gcc.code_combination_id;
  RETURN (l_segment1);
EXCEPTION WHEN OTHERS THEN RETURN ('00'); 
END;