Performance Issue on "PSP: Reconciliation Between Sublines And Distribution Lines" Where the Report Runs for Many Hours and Does Not Complete (Doc ID 1953814.1)

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.

Symptoms

On : 12.1 HRMS RUP6 version, Reports

ACTUAL BEHAVIOR

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.

EXPECTED BEHAVIOR

 it used to take from 10 mins to 25 mins max


STEPS

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



Cause

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