Tag: speedup payroll

Speeding up Oracle Applications/Payroll processing

Posted on by Osama Mustafa in Application 
% 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');
SQL>commit; 


thank you
Osama mustafa