Friday, June 29, 2012

Speeding up Oracle Applications/Payroll processing

% sqlplus apps/apps

To retrieve the current value of 'THREADS' parameter:

SQL> select parameter_value
from pay_action_parameters
where parameter_name = 'THREADS';

To set the value for the number of payroll threads:

SQL> update pay_action_parameters
set parameter_value = <number_of_threads>
where parameter_name = 'THREADS';
SQL> commit;
if you don't have thread value use the below sql :
SQL> insert into PAY_ACTION_PARAMETERS values ('THREADS', 'XXXX');

thank you
Osama mustafa 


  1. Oracle application plays a vital role in the organization whether big or small to get rid of the work burden from the head of HR. Many small companies prefer to hire payroll service provider to keep all information about its employee and all payroll related management.

    Jimmie Menon

  2. It is very necessary to hire payroll service provider.

  3. As a leading outsourcing payroll service provider London, we help you in Opening bank accounts, Employing staff Surrey, International taxation advice & VAT services.