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

Last updated on MARCH 20, 2017

Applies to:

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

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 'LCC_CC_Lab_Misc_Clearing' ...
Expenditure Item ID='0000'
PA_AA_NO_ROWS|RULE|LCC_CC_Lab_Misc_Clearing
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.

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