There are four steps to synchronizing the commitment ledger, commitment details, and purchase order files. These steps are JDE-recommended steps and stay within the confines of standard JDE functionality. They are as follows:
- R43199P – Purge Commitment Audit Trail (F43199). This removes records from the audit file based on data selection.
- R00993 – Rebuild Commitment Audit Trail (F43199). This rebuilds the audit file based on the actual balances of purchase orders and subcontracts in the F4311.
- R00932 – Repost Committed Costs (updates F0902 w/ new F43199). This updates the Commitment Ledger (PA) in the financial balances file (F0902). This does NOT update any budget or actual financial data, only the commitment balances, which are updated directly by F43199 activity.
- R098210 – Annual Close for PA ledger ONLY (rolls balances forward in F0902). The PA records are updated for the appropriate years, but the balances for each of those years may not be accurate anymore. Rolling (closing) the year will properly update the Balances Forward for each of the years.
These steps above should be run WITH GREAT CARE as they are purging data and mass-updating files. It is strongly recommended that a single account, as it appears on the Commitment Integrity report, should be run through all four of these steps. It is also recommended to run the R40910 report after each step to see the results after each of the four actions above, again, just for the account being updated.
Although there is an "Update" option, Oracle notes that this should NOT be run in this final mode as a F43199 and F0902 PA record will be forced into the tables to correct the commitment integrity. Verify first that the integrity is valid and can be fixed by running the purge, rebuild and repost process below. Once these steps are run, what’s left on the integrity report are true integrity issues that need further research and may be the right option for the final mode run.
MOS Doc ID # 657403.1 is a great reference document from Oracle.
Do you have other "Getting Back to the Basics " ideas for Ask Denovo? Let us know!