% 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
Published by Osama Mustafa
Osama considered as one of the leaders in Cloud technology, DevOps and database in the Middle-East. I have more than ten years of experience within the industry. moreover, certfied 4x AWS , 4x Azure and 6x OCI, have also obtained database certifications for multiple providers.
In addition to having experience with Oracle database and Oracle products, such as middle-ware, OID, OAM and OIM, I have gained substantial knowledge with different databases.
Currently, I am architecting and implementing Cloud and DevOps. On top of that, I'm providing solutions for companies that allow them to implement the solutions and to follow the best practices.
View all posts by Osama Mustafa
Technology Geek 
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
LikeLike
It is very necessary to hire payroll service provider.
LikeLike
As a leading outsourcing payroll service provider London, we help you in Opening bank accounts, Employing staff Surrey, International taxation advice & VAT services.
LikeLike
Many small companies prefer to hire payroll service provider to keep all information about its employee and all payroll related management.It is very necessary to hire payroll service provider.
LikeLike
Wonderful, just what a blog it is! Please Visit:Payroll Services In LondonTax Investigations In London
LikeLike
Using payroll software allows the business to compile reports at whatever speed they desire. Purchasing software eliminates the expense of hiring an in-house accountant for payroll processing. small business payroll software
LikeLike
Thanks for posting the useful information to my vision. This is excellent information,.outsource payroll processing services
LikeLike
Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.recruitment process outsourcingbluecollar workers recruitment servicesbackground check service for employersemail writing skills training
LikeLike
This is really amazing blog post. Thanks for sharing keep it up good work.Payroll Outsourcing Services
LikeLike