My Oracle Support Banner

FVFCCHKB FACTS II Edit Check Fails. Not Able To Produce FACTS II Bulk File Due To OMB/ Treasury Changes (Doc ID 1482615.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle U.S. Federal Financials - Version to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


Due to Changes within the Office of Management and Budget Circular A-11 FACTS II Reporting went from four times a year to seven. FACTS II Edit Checks are failing and thus not able to produce FACTS II Bulk File due to the code within the FV_FACTS_EDIT CHECK procedure perform_edit_checks. The code states that if P_facts_run_quarter = 4 then Edits 4,5,6,7 are applicable. Due to this change though these edits should only apply to the last actual period of the fiscal year not the entire quarter. Currently we have 21 agencies that will unable to produce a bulk file for July 2012 or August 2012 Reporting and will be a continuing problem next year for the same months. Due to GTAS implementation delayed we are at a work stoppage to produce bulk files. Edit 18 also needs to be evaluated due to the GTAS Delay currently Edit 18 states that p_rep_fiscal_yr = 2012 then edit 18 is applicable it should be p_rep_fiscal_yr >= 2012 as we will need this next year. This will also be an issue for all R12 Oracle Enviroments as well

- Steps to Reproduce -
If you submit FACTS II in Production for any Set of Books Edits 4,5,6,7 have the capability to Fail due to the Edit Checks Code stating fourth quarter since these are year end closing period edits should only apply to the last Actual Period of the Year not the entire quarter


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.