Human Capital Management - EBS (MOSC)

MOSC Banner

how to force HR Security List maintenance to run in several parallel threads

edited Jun 27, 2017 2:51AM in Human Capital Management - EBS (MOSC) 2 commentsAnswered

Hello gurus,

after migration to 12c database HR Security List maintenance execution time was drammatically increased up to twice and even triple..

We have found related notes: 222420.1, 394083.1, 226987.1(HRMS_and_BEN_11i_and_R12_Tuning_and_Health_Check.pdf) which states that due to MSL_PERSON_LIST is PYUGEN process,  it can be managed by threads parameter of the PAY_ACTION_PARAMETERS, E18727_01/doc.121/e13509/T2096T2098.htm

We have tested the PAY_ACTION_PARAMETERS THREADS related to PERSLM + MSL_PERSON_LIST processes on the TEST environment.

New PAY_ACTION_PARAMETER_GROUP was created, Threads parameter was setting to 5, New CONCURRENT_QUEUE manager was created, PERSLM and MSL_PERSON_LIST concurrents were replaced under the new manager, excluded from others..

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center