Performance Issue on "PSP: Reconciliation Between Sublines And Distribution Lines" Where the Report Runs for Many Hours and Does Not Complete
Last updated on DECEMBER 20, 2016
Applies to:Oracle Labor Distribution - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.
On : 12.1 HRMS RUP6 version, Reports
Experiencing a performance issue with the "PSP: Reconciliation between sublines and distribution lines" report in pay periods when Overtime is paid.
The job was submitted on 11/25 and was running till 11/30( 4 days). it was not completed , but got terminated.
it used to take from 10 mins to 25 mins max
The issue can be reproduced at will with the following steps:
Run the "PSP: Reconciliation between sublines and distribution lines" report after Create Distribution Lines process
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms