You can store attribute column information in the Define Federal System Parameters window for the following features:
FACTS I trading partner of the customer, supplier, and journal lines
FACTS II public law code, advance type, transfer department ID, and transfer main account for journal lines
220-9 Adjustment Status
FMS 224 reporting if using Oracle Projects
FACTS Transaction Register transaction date for requisitions, purchase orders, and receiving transactions
These parameters remain constant across ledgers and organizations.
The FACTS I process derives the attribute column stored in the Define Federal System Parameters window to determine the Trading Partner Descriptive Flexfield attribute for the customer, supplier, or journal line. The value in the Trading Partner Descriptive Flexfield is reported on the FACTS I file to further categorize the general ledger account balances designated as F for Federal.
The FACTS II process derives the attribute column stored in the Define Federal System Parameters window to determine the public law code, advance type, transfer department ID, and transfer main account descriptive flexfield attributes for the journal line. The value in these descriptive flexfield attributes are reported on the FACTS II file to further categorize the general ledger account balances.
The Receivables Activity Worksheet process derives the attribute column stored in the Define Federal System Parameters window to determine the Adjustment Status Descriptive Flexfield attribute. You can use the value in the Adjustment Status Descriptive Flexfield for reporting in the Adjustments section.
The FMS 224 report process derives the attribute column stored in the Define Federal System Parameters window to determine the Accomplished Date of payment on expenditure items in Oracle Projects. The value in the Expenditure Item descriptive flexfield is used for reporting the Accomplished date on the FMS 224.
The FACTS Transaction Register process derives the attribute column stored in the Define Federal System Parameters window to determine the transaction date for requisitions, purchase orders, and receiving transactions in Oracle Purchasing.
The Customer Trading Partner Descriptive Flexfield must be defined for Customer Information in Oracle Receivables.
To define the Customer Trading Partner Descriptive Flexfield for customer information, see Define Descriptive Flexfields in Receivables.
The Vendor Trading Partner Descriptive Flexfield must be defined for suppliers in Oracle Purchasing.
To define the Vendor Trading Partner Descriptive Flexfield for suppliers, see Define Descriptive Flexfield in Purchasing.
The trading partner, public law code, advance type, transfer department ID, and transfer main account descriptive flexfields must be defined for Enter Journals: Lines in Oracle General Ledger if the user wants to enter these values for manual journal entries to be used for FACTS I and FACTS II reporting.
To define the Enter Journals: Lines Descriptive Flexfield, see Define Descriptive Flexfield in General Ledger.
The Adjustment Status Descriptive Flexfield must be defined for Adjustment Information in Receivables.
To define the Adjustment Status Descriptive Flexfield for Adjustment Information, see Define Descriptive Flexfields in Receivables.
The Expenditure Items Descriptive Flexfield must be defined for the Accomplished Date in Oracle Projects if using Projects and if users want the Projects Accomplished Date to be used in the FMS 224 report process. If this field is not populated, the FMS 224 report process uses the GL Posting date as the Accomplished Date.
To define the Expenditure Item Descriptive Flexfield for the Accomplished Date, see Define Descriptive Flexfield in Projects.
The Transaction Date for requisitions descriptive flexfield must be defined for Requisition Headers in Oracle Purchasing if the user wants the Transaction Date to be used in the FACTS Transaction Register. If this field is not populated, the Transaction Register uses the Creation Date as the Transaction Date.
To define the Transaction Date for requisitions descriptive flexfield, see Define Descriptive Flexfield in Purchasing.
The Transaction Date for purchase orders descriptive flexfield must be defined for PO Headers in Oracle Purchasing if the user wants the Transaction Date to be used in the FACTS Transaction Register. If this field is not populated, the Transaction Register uses the Creation Date as the Transaction Date.
To define the Transaction Date for purchase orders descriptive flexfield, see Define Descriptive Flexfield in Purchasing.
The Transaction Date for receiving transactions descriptive flexfield must be defined for Receiving Transactions in Oracle Purchasing if the user wants the Transaction Date to be used in the FACTS Transaction Register. If this field is not populated, the Transaction Register uses the Receipt Date as the Transaction Date.
To define the Transaction Date for receiving transactions descriptive flexfield, see Define Descriptive Flexfield in Purchasing.
To define federal system parameters navigate to the Define Federal System Parameters window.
The following table describes the fields on the Define Federal System Parameters window, FACTS Attributes tab.
| Field Name | Description |
|---|---|
| Customer Trading Partner | FACTS I customer attribute
Note: Select the same attribute used in the Trading Partner Descriptive Flexfield for Customer Information. |
| Vendor Trading Partner | FACTS I vendor attribute
Note: Select the same attribute used in the Trading Partner Descriptive Flexfield for Vendors. |
| Journal Trading Partner | FACTS I journal attribute
Note: Select the same attribute used in the Trading Partner Descriptive Flexfield for Enter Journals: Lines. |
| Public Law Code | FACTS II public law code attribute
Note: Select the same attribute used in the Public Law Code Descriptive Flexfield for Enter Journals: Lines. |
| Public Law Code Receipts | Allow users to enter a public law code for miscellaneous receipts.
Note: Select the same attribute used in the descriptive flexfield for Receivables: Accounting Distribution Information. |
| Advance Type | FACTS II advance type attribute
Note: Select the same attribute used in the Advance Type Descriptive Flexfield for Enter Journals: Lines. |
| Transfer - Department ID | FACTS II transfer department ID attribute; required when there is a value for Transfer - Main Account
Note: Select the same attribute used in the Transfer - Department ID Descriptive Flexfield for Enter Journals: Lines. |
| Transfer - Main Account | FACTS II transfer main account attribute; required when there is a value for Transfer - Department ID
Note: Select the same attribute used in the Transfer - Main Account Descriptive Flexfield for Enter Journals: Lines. |
The following table describes the fields on the Define Federal System Parameters window, Reporting Attributes tab.
| Field Name | Description |
|---|---|
| Adjustment Status | 220-9 report attribute
Note: Select the same attribute used in the Adjustment Status Descriptive Flexfield for Adjustment Information. |
| Receivables Reclassification | Allow users to enter a Receipt Document Number that is being reclassified.
Note: Select the same attribute used in the descriptive flexfield for Receivables: Accounting Distribution Information. |
| Project Accounting Accomplished Date | Date disbursement paid by Department of Treasury
Note: Select the same attribute used for the Expenditure Item Descriptive Flexfield in Projects for Accomplished Date. |
The following table describes the fields on the Define Federal System Parameters window, Transaction Date Attributes tab.
| Field Name | Description |
|---|---|
| Requisition | Requisition date attribute |
| Purchase Order | Purchase order date attribute |
| Receiving Transaction | Receiving transaction date attribute |