PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Payroll is getting hung ... HCM 9.1

edited May 9, 2012 10:18PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered
Hi,

We have upgraded HRMS 8.8 SP1 to HCM 9.1 FP1.

Platform : Redhat Linux 5 64 bit

Database : upgraded from 9.2.0.6 to 11.2.0.1

Issue : Payroll process is not consistent.

1)    Payroll is running in small chunk

2)    In bigger chunk sometimes its running sometimes not.

3)    Most of the time when its not running, I have seen 4 tables are going under transactional (exclusive row lock) & not getting released. Subsequent payroll is also getting hung. Unless I will restart the database, it will not work

4)    We have run the payroll for full population on SIT, it went fine. Parameter wise there is no difference between SIT & UAT

If I check select * from dba_dml_locks; --- no locks found

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