E1: 51: P51F100 - Refresh Balances Does Not Update Actual Cost At LOD 8 Rollup Level

(Doc ID 2320346.1)

Last updated on OCTOBER 23, 2017

Applies to:

JD Edwards EnterpriseOne Advanced Job Forecasting - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

The Refresh Balances program is not updating the LOD 8 Rollup Totals in the F51F110 table. Because the Forecasted Amounts / Units are not stored, all reports need to calculate the Forecasted Amount and Units rather than pull them from a stored field. Since the Forecasted Amounts are stored at LOD 8 all of the time, this means that reports run after the Refresh Balances program is run are not including the Actual Amount in any of the Calculations for MOC W, Y or 2. As a result reports are incorrect by huge numbers.
When the Refresh Balances program is run the “To Date Amount” (51FAA01) needs to be updated at the Rollup Level (LOD 8) as a part of the Refresh Balances process.

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