Recosted Labor Interfaced to GL is Causing GL Accounts To Be Out Of Balance (Doc ID 2608621.1)

Last updated on NOVEMBER 17, 2022

Applies to:

Symptoms

A large number of expenditures were reset to uncosted when a burden schedule for the previous fiscal year was compiled.

Labor Distribution and Burden processes were run, and all records processed as expected.

Generate Cost Accounting Events was run and cost accounting completed successfully.

When the PRC: Create Accounting process was run, journal lines were uploaded and posted to GL, but after reconciling the GL with the total costs recalculated the GL account was out of balance.

Reviewing the cost distribution lines show the expected adjustment lines and the statuses show that all cost distribution lines had accounting created.

As an example employee: and employee's labor has 5 cost distribution lines 1, 2, 3, 4 and 5.

Lines 2 & 3 are status = G, which means they don’t need to be accounted.

Lines 1, 4, and 5 are status = Accepted, which means accounting entries were created and are transferred to GL.
Line 1 is the original transaction from SEP-2018 no issues with that
Lines 4 & 5 were created as a result of the recompile.
Lines 4 & 5 also net to zero, so there is not supposed to be any impact to the GL as a result of this.
Both lines have the same accounting EVENT ID.

However only line 5 has accounting details in xla headers, lines, and links tables and was actually transferred to GL from subledger accounting.

Line 4 did not have the xla details created, and was missing in the view accounting screen.

To find where this difference was coming from it was necessary to go to GL where the incorrect balance was shown, and drill down from GL into Projects to see the related expenditure items.

Once they were identified and View Accounting was used to see the actual GL entries, was the missing cost distribution line seen.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.