During Labor Distribution Summarize and Transfer, Earned Date In Old Period Despite Effective Date In Current Period

(Doc ID 1946327.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Labor Distribution - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Other

When Payroll process old terminated employees, the "Earned Date" is set well into the past. This means that we must import old Payroll periods again to bring in the extra elements.
When Importing, Labor Distribution seems to be checking the GL Period against the earned date rather than the effective date.

We are forced to open up very old periods just to get the import to work properly but then Labor Distribution gives it a current GL Period based on Effective Date anyway. Therefore opening he period is pointless and just generates exceptions.

Import needs to consider the effective date rather than earned date in order to avoid the period exceptions. Is will not be possible to open up previous periods especially when that period falls inside a previous financial year which is fully closed and rolled over.

The issue can be reproduced at will with the following steps:
1. Create a regular payroll
2. Import into Labor Distribution
3. Run S&T and post to GL
4. Close the GL period in question
5. Go back and complete a termination Pay run in Payroll with a "Paid Date" in the current GL\Payroll period but a "Date Earned" back in the previous Payroll period from step 1 which should be in the old GL Period as well
6. Import Payroll into Labor Distribution again.
7. S&T will fail due to the GL Period being closed
8. Open the GL Period
9. Re-run the summarize and transfer.
10. The item which previously errored now has had it's effective_date updated to a date in the current period rather than posting to the previous GL Period


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