My Oracle Support Banner

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
Data Act
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

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