You can store attribute column information in the Define Federal System Parameters window for the following features:
Trading partner of the GTAS customer, supplier, journal, and miscellaneous receipts
Public law code
220-9 Adjustment Status
FMS 224 reporting if using Oracle Projects
Journal authority type
Journal reduction type
These parameters remain constant across ledgers and organizations.
The GTAS 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, journal line or miscellaneous receipts. The value in the Trading Partner Descriptive Flexfield is reported on the GTAS file to further categorize the general ledger account balances designated as F for Federal, N for Non Federal, E for Non Federal exception, G for general fund or Z for Non-Reciprocating Federal Activity .
The GTAS process derives the attribute column stored in the Define Federal System Parameters window 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 GTAS 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 GTAS 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 GTAS 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 GTAS 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 GTAS 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, GTAS Attributes tab.
| Field Name | Description |
|---|---|
| GTAS Customer Trading Partner | GTAS customer attribute
Note: Select the same attribute used in the Trading Partner Descriptive Flexfield for Customer Information. |
| Customer Trading Partner | FACTS I customer attribute will be retired upon implementation of GTAS. Used for migration purposes only.
Note: Select the same attribute used in the Trading Partner Descriptive Flexfield for Customer Information. |
| Vendor Trading Partner | GTAS vendor attribute
Note: Select the same attribute used in the Trading Partner Descriptive Flexfield for Vendors. |
| Journal Trading Partner | GTAS journal attribute
Note: Select the same attribute used in the Trading Partner Descriptive Flexfield for Enter Journals: Lines. |
| Miscellaneous Receipts Trading Partner | GTAS journal attribute
Note: Select the same attribute used in the Trading Partner Descriptive Flexfield for Enter Receivables Miscellaneous Receipts Transactions . |
| Public Law Code | Public law code informational attribute
Note: Select the same attribute used in the Public Law Code Descriptive Flexfield for Enter Journals: Lines. The attribute, if used, is for informational purposes only. |
| Journal Authority Type | GTAS journal attribute
Note: Select the same attribute used in the Journal Authority Type Flexfield for Enter Journals: Lines. |
| Journal Reduction Type | GTAS journal attribute
Note: Select the same attribute used in the Journal Reduction Type Flexfield for Enter Journals: Lines. |
The following table describes the fields on the Define Federal System Parameters window, Reporting Attributes tab.
| Field Name | Description |
|---|---|
| Receivable Activity Adjustment Status | Informational attribute
Note: Select the same attribute used in the Adjustment Status Descriptive Flexfield for Adjustment Information. |
| FMS 224 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 FMS 224 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 |