Project Cost Sheet Displaying Incorrect Amount in a Column Where Formula Equals 'Sum of All Rows' (Doc ID 2854066.1)

Last updated on MARCH 21, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
A Project Cost Sheet is displaying an incorrect amount in a column that uses a Commit-type Business Process (Approved) as the Data Source.

Example:

Line 75 | Cost Code: 12-00000-000 | Equipment and Furniture
  -> Approved Commitments: $632,353.75
  -> When adding up the line items with a manually, the total is actually: $635,028.14

EXPECTED BEHAVIOR
-----------------------
The 'Approved Commitments' formula is = Sum of All Rows. All rows should be added together correctly.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Login as a user with access to the Project Cost Sheet.
2. Navigate to the impacted Project/Shell.
3. Open the Cost Sheet.
4. Observe the total amount in the column.
5. Add up the values in the Column manually and compare the amounts.

Cause

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