Unable To Close Month End Periods Due To Accounting Errors (Doc ID 2243572.1)

Last updated on MARCH 23, 2023

Applies to:

Symptoms

Customer reversed 16k labor transactions via an Excel WebAdi using an existing working transaction source.

1. Previous periods had been open at the time of the exercise for another separate issue.

2. All entries had negative hour quantities entered to reverse, some had a further positive entry to re-import on a different hourly rate.

The transactions source (Straight Time Type):

Raw Cost GL Accounted = No.

Allow Reversals = No

Allow Adjustments = Yes

3. Some of the complete reversals (no further positive entry) have failed Generate Cost Accounting Events:

The output of (PAGCAE) PRC: Generate Cost Accounting Events shows the below error and warning:

1. See the following error:

Auto Accounting could not create flexfield.

479 ROWS to process
-(AA FAILED) Updating expenditure items:
-Number to be processed 100
...Updating rejection reason in cost distribution lines
Current system time is 03-MAR-2017 13:53:11
100 UPDATED rows
updating the status to A for commitments
Current system time is 03-MAR-2017 13:53:11
0 rows updated
-Completed rejecting failed expenditure items
----------------------------------------------------

2. See the following warning:

Current system time is 03-MAR-2017 13:53:10
Firing rule '<your auto accounting rule name>' ...
Expenditure Item ID='0000'
PA_AA_NO_ROWS|RULE|<your auto accounting rule name>
Warning in Auto Accounting for line '0000'
Expenditure Item ID='0000'

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Submit PRC: Generate Cost Accounting Events.

Changes

Cause

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