The 'Refresh Balances' row exit from the P51F100 (Job Forecast Details) increments "Revised Budget" and "Actual Amounts".
Row Security against MCU (Business Unit) Globally
The Row Security prevents related business function from deleting records from F51F10W/F51F20W (Job Forecast Billing Worktable/Job Forecast Account Info Worktable) without issuing an error. However, there maybe ODBC level errors like "JDB9900411 - Inclusive Row Level Security Violation: USERID attempted a DELETE in table F51F20W". It is important to check all JDE.logs during the implementation phase and analyze it further by capturing jdedebug.log (namely, call object kernel log).
Advanced Forecasting module, uses the below work files (temporary tables).
All data in these tables are to be deleted after a session and each session is controlled through UKID (which is equivalent to job number in other applications which are specific to session or job).
The "Revised Budget" and "Actual Amounts" get update two and three times based on the number of times the 'Refresh Balance' is clicked. When the business function RefreshFullBalances (B51F0006, Refresh Full Balances) failed to delete records from F51F20W due to Row Security against F51F20W.MCU column this issue occurs.
Because it aggregates values through the business view V51F20WJ (Job Forecast Join - F51F20W/F0902) (which primary table is F51F20W with join type Left Outer based on AID (Account ID)) the F51F20W contains un-deleted data, and therefore the issue appears here.
Delete all records from temporary tables (Worktable, workfile). It is safe to delete the information in this file at any time
To eliminate this issue try the following:
Check Bug 25093621 - B51F0006 NOT SHOWING ERROR MESSAGE for the latest tools release or ESU information.