My Oracle Support Banner

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

Last updated on JULY 06, 2021

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.


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'

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




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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