Federal File creation process not considering adjustments as ending balances. Save Ending Balances Is Missing Adjustment Entries.
(Doc ID 2392391.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle U.S. Federal Financials - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Federal File Creation
Save Ending Balance
Adjustment entries generated by the new procedure POPULATE_PRC_ALLOC_ADJ and stored in FV_DACT_ACTIVITY_ADJ_AMOUNT are never included in the balances stored in FV_DACT_ENDING_BALANCES that are populated when the Federal File Creation is run with Save Ending Balances set to Yes.
The insert in FV_DATAACT_PKG.DACT_SAVE_ENDING_BALANCES procedure, the filter only includes balance_type = P or L.
It appears to be missing balance_type = 'A'.
The issue is that the Current Period Ending (CPE) balances in the 2018 DACT files are incorrect, and they are failing broker validation when the files are uploaded, because the DACT balances do not equal GTAS/SF-133. The current 2018 balances are only incorrect because the 2017 ending balances (which are used as 2018 beginning balance) are incorrect. So we need to correct the 2017 ending balances, or the 2018 balances will continue to be wrong.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document