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');
SQL>commit;


thank you
Osama mustafa 

9 thoughts on “Speeding up Oracle Applications/Payroll processing

  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.RegardJimmie Menon

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.