My Oracle Support Banner

Federal Financials FACTS II Edit Changes for the Retirement of Edit 14 and the addition of Edits 15, 16 & 17 and Non Federal Exception Limitation Edit (Doc ID 1299711.1)

Last updated on DECEMBER 05, 2019

Applies to:

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

Details

Introduction

The Federal Agencies' Centralized Trial-Balance System (FACTS II) is a computer program that allows agencies to submit one set of accounting data. In its efforts to improve data received through FACTS II, Treasury has added edits and validations to FACTS II to enforce tighter accounting and data control. The following changes have been incorporated into FACTS II by Treasury:

  1. Edit 14: This edit has been removed. 
  2. Edit 15: The amount recorded in USSGL account 4157 cannot exceed the amount in USSGL account 4397 "E".
  3. Edit 16: The amount recorded in USSGL account 4158 cannot exceed the amount in USSGL account 4398 "E".
  4. Edit 17: USSGL Accounts 4134, 4144 only apply to TAFSs where USSGL account 4871 or 4971 reported
  5. The transaction partner domain value "E", Non Federal Exception, is limited to specific TAFS.
    This enhancement incorporates these changes into Federal Financials FACTS II processes.

Define Treasury Account Symbols (Modified)

The following has been added to the header portion of the form: 

Define US SGL Accounts (Modified)

The Reclassification Edit tab has been removed from the form as the edit has been retired by Treasury.

Federal Financial Options (Modified)
The following have been removed from the form:

FACTS II Edit Check Process (Modified)

Reclassification Edit Check 14 has been removed

Edit Check 15 has been added
The FACTS II Edit Check logic has been added to verify that the amount recorded in USSGL account 4157 cannot exceed the amount in USSGL 4397 account.

Edit Check 16 has been added
The FACTS II Edit Check logic has been added to verify that the amount recorded in USSGL account 4158 cannot exceed the amount in USSGL 4398 account.

Edit Check 17 has been added
USSGL accounts 4134 and/or 4144 only apply to TAFSs where USSGL accounts 4871 and/or 4971 are reported. In addition, the sum of the amount(s) in USSGL account 4134/4144 cannot exceed the sum of the amount(s) in USSGL account 4871/4971. The amount in 4134/4144 cannot equal zero.

The FACTS II Edit Check logic has been added to verify that the ending balance of USSGL Accounts 4134 plus 4144 must be less than or equal to the Ending balance of USSGL Accounts 4871 plus 4971.

Edit Check for non Federal exception limitation has been added
FACTS II Edit Check logic has been added to validate that the Transaction Partner attributes on the FACTS Attributes form have a value of "E" or "F" for USSGL accounts 4221, 4251, 4230, or 4233. Logic has also been added to ensure that Transaction Partner attributes value "E" for USSGL accounts 4221, 4251, 4230, 4233 or 4212 are associated with a TAFS designated as Non Federal Exception Allowed per the Define Treasury Account Symbol form.

FACTS II Edit Check Reporting (Modified)

Reclassification edit 14 has been removed from the FACTS II Edit Check Detail Report

Edit Check 15 has been added

Edit Check 15 displays as follows:

Check 15 - Account 4157 cannot exceed the amount in USSGL 4397
Status: Passed

Account Number                Ending Balance 

4397                                                50.00 
4157                                                10.00 
                                                       _____
Difference (Should be >= zero)        40.00

Edit Check 16 has been added

Edit Check 16 displays as follows:

Check 16 - Account 4158 cannot exceed the amount in USSGL 4398
Status: Passed

Account Number                 Ending Balance

4158                                                 80.00
4398                                                 50.00 
                                                         _____
Difference (Should be >= zero)          30.00

Edit Check 17 has been added

Edit Check 17 displays as follows:

Check 17 - Account 4134 and/or 4144 cannot exceed the amount in USSGL 4871/4971 account
Status: Passed

Account Number                 Ending Balance

4871                                                 25.00
4971                                                 30.00 
                                                         _____
Total                                                 55.00

4134                                                 20.00
4144                                                 15.00 
                                                         _____
Total                                                 35.00 
                                                         _____
Difference (Should be >= zero)         20.00

Edit Check for non Federal exception limitation has been added

Non Federal exception limitation displays only if the edit fails as follows:

Non Federal exception limitation validations edit
Status: Failed

Account         Transaction                                         Non Fed
Number         Partner              AID           MAIN      Exp TAFS    Ending Balance

4221              E                      12              2000        Not Allowed          2,500.00
4230             X                      12               3000       Allowed                     500.00
4251             X                      12               4000       Not Allowed              300.00

 

NOTE: Edit checks 15, 16, 17 and Non Federal Exception limitation are considered hard edits.  If any of these edits fail, the FACTS II bulk file will not be generated.

Actions

 

Contacts

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
Details
Actions
Contacts
References

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