Trading Partners (customer agencies) are limited to the valid Treasury Account Symbol (TAS) / Business Event Type Codes (BETC) combinations which exist in the Treasury Shared Accounting module. A validation is performed for cash transactions to ensure that the Trading Partners TAS/BETC combination is an established combination. A Trading Partners TAS/BETC mapping is provide in Oracle financials to ensure only valid Trading Partners TAS/BETC combinations are used for transaction processing involving customer agencies
Navigate to the Define Trading Partner TAS window.
In the header block, there must be a unique combination of values in the following fields:
Agency Identifer
Main Account Code
Federal Account Symbol Title
In the Treasury Account Symbol (TAS) tab of the detail block, there must be a unique combination of values in the following fields:
Sub-Level Prefix Code
Allocation Transfer Agency Identifier
Authority Duration Code
Beginning Period of Availability
Ending Period of Availability
Availability Type Code
Sub-Account Code
Treasury Account Symbol
In the Attributes tab of the detail block, Contains the following fields:
Enable Checkbox
Start Date
End Date
Auto Create Checkbox
If there is not a unique combination of the above fields, this is considered a duplicate record. This is considered to be the Component GWA TAS to be used by Treasury systems in the future and compliant with GGAC requirements.
The values in this window are applicable across all ledgers. There is no ledger or operating unit restriction on the data entered in this window. Duplicate mapping of BETCs within a Trading Partner TAS record is not allowed.
The following table describes selected fields on the Define Trading Partner TAS/BETC Mapping window.
| Field Name | Description |
|---|---|
| Agency Identifier | The value for the field must be 3 characters. Only number values can be entered and leading zeros can be used. |
| Main Account | The value for the field must be 4 characters. Only number values can be entered and leading zeros can be used. |
| Sub-Level Prefix Code | Only number values can be entered and leading zeros can be used. This field is disabled and must be null if there is a value in the Sub Class field. |
| Allocation Transfer Agency Identifier | The value for the field must be 3 characters. Only number values can be entered and leading zeros can be used. |
| Beginning Period of Availability | Enter a 4-digit number for the year. |
| Ending Period of Availability | Enter a 4-digit number for the year. This field is required if Beginning Period of Availability is entered. The Ending Period of Availability must be equal to or greater than the Beginning Period of Availability. |
| Availability Type Code | The list of values for this field are X-no-year account, F-clearing/suspense account, A-Treasury central summary general ledger account, and M-merged surplus account. |
| Sub Account Code | The value for the field must be three characters. Only number values can be entered and leading zeros can be used. |
| Treasury Account Symbol | The value is derived similar to the Treasury Account Symbol on the Define Treasury Account Symbol window. This field can be overwritten by the user. For more information, see Trading Partner Treasury Account Symbol Default Value Derivation. |
| Enable Checkbox | The checkbox is used to enable/disable the TP TAS. |
| Start Date | Date the TP TAS will be available for use. |
| End Date | Date the TP TAS will be available no longer be available for use. |
| Auto Create | If this check box is selected, the TAS and related BETCs for expiring single year and multiyear funds will be created for the new fiscal year (FY) when the Create Annual Treasury Account Symbols process is run. |
| TAS/BETC Mapping Button | Redirects the user to the TAS/BETC Mapping window. |
The value for Treasury Account Symbol element is derived from the individual TAS component elements as described below. If a TAS component does not have a value, it is ignored in the derivation of the Treasury Account Symbol.
| Data Element Description | Derived From | Format | # of Spaces | Additional Information |
|---|---|---|---|---|
| Sub-Level Prefix Code (SP) | Sub-Level Prefix Code | (##) | 4 | Parenthesis are added around the Sub-Level Prefix Code. Example: If Sub-Level Prefix Code value is 01, this would be formatted as (01). |
| Allocation Transfer Agency Identifier (ATA) | Allocation Transfer Agency Identifier | ###- | 4 | A hyphen is displayed after the Allocation Transfer Agency ID. |
| Agency Identifier (AID) | Agency Identifier | ### | 3 | - |
| Fiscal Year (FY) | Beginning and Ending Period of Availability, Availability Type Code | X XX XX/XX |
1,2, or 5 | The Fiscal Year is derived as follows: If Beginning Period of Availability, Ending Period of Availability, and Availability Type Code are blank; the Fiscal Year is not used. If not null, use the Availability Type value. If the Beginning Period of Availability and Ending Period of Availability are not null and have the same value, use the last two 2 digits of the Ending Period of Availability. For example, if Beginning and Ending Period of Availability are both 2006, the Fiscal Year would be formatted as 06. If the Beginning Period of Availability and Ending Period of Availability are not the same value, use the last two digits of the Beginning Period of Availability, a “/”, and the last 2 digits of the Ending Period of Availability. For example, if the Beginning Period of Availability is 2007 and the Ending Period of Availability is 2011, the Fiscal Year would be formatted as 07/11 |
| Main Account Code (MAIN) | Main Account Code | #### | 4 | - |
| Sub-Account Code (SUB) | Sub-Account Code | .#, .##, or .### | 2,3 or 4 | A period is added prior to the Sub-Account Code. Leading zeros are not included. If the Sub-Account Code is 123, this would be formatted as .123. If the Sub-Account Code is 02, this would be formatted as .2. |
| SLPC | ATAI | AI | BPA | EPA | ATC | MAC | SAC | TAS |
|---|---|---|---|---|---|---|---|---|
| 01 | 011 | 020 | X | 0003 | 000 | (01)011-020X0003 | ||
| 012 | 017 | X | 1105 | 000 | 0122-017X1105 | |||
| 017 | 069 | 2009 | 2013 | 1205 | 005 | 017-06909/131205.5 | ||
| 22 | 060 | 2005 | 2005 | 0111 | 000 | (22)060050111 | ||
| 000 | 2001 | 2001 | 0476 | 000 | 000010476 | |||
| 000 | 2003 | 2007 | 0127 | 000 | 00003/070127 | |||
| 455 | X | 4110 | 000 | 455X4110 | ||||
| 020 | X | 4521 | 894 | 020X4521.894 | ||||
| 012 | 012 | 2006 | 2006 | 0600 | 036 | 012-012060600.36 | ||
| 010 | 0830 | 000 | 0100830 |
The following attributes are available at the Supplier Site (Manage Sites) and Customer Accounts level:
Context Value: Optional, if used the value is US Federal Attributes.
Limit TP TAS to Agency ID: Optional if the Federal or Non-Federal Code for the Supplier / Customer Account is “G” or “F”, otherwise prohibited. Valid values are blank, Yes, and No.
Default Trading Partner TAS: Optional if the Federal or Non-Federal Code for the Supplier / Customer Account is “G” or “F, otherwise prohibited and blank.
Define the “FV: Limit TP TAS to Agency ID” System Profile option to the desired setting (“Yes” or “No”)
Ensure all needed Trading Partner TAS' are properly defined and enabled on the Trading Partner TAS form. Define start and end dates, as necessary.
Define the desired values for the following Federal attributes on Supplier Sites and Customer Accounts:
Limit TP TAS to Agency ID
Default Trading Partner TAS
A concurrent request is available to update single-year and multi-year Default TP Treasury Account Symbols defined for Customer Accounts and Supplier Sites. The concurrent request name is “Party Trading Partner TAS Update”.
Concurrent Request Parameters includes the following:
Ledger: Same as current Rollover Treasury Account Symbols concurrent request
Copy Fiscal Year: As current Rollover Treasury Account Symbols concurrent reques
• Trading Partner TAS Type: Valid values are:
Customer Accounts: Select only Customer Account with a Default Trading Partner TAS.
Supplier Sites: Select only Supplier Sites with a Default Trading Partner TAS.
Customer Accounts and Supplier Sites: Select both Customer Accounts and Supplier Sites with a Default Trading Partner TAS.
The process produces the following reports:
Customer Account Default Trading Partner TAS Update report: This report displays data for Customer Account Default Trading Partner TASs rolled over.
Customer Account Update Trading Partner TAS Not Found report: This report displays Customer Accounts with a Default Trading Partner TAS where the Ending Period of Availability matches the Copy Fiscal Year parameter but the rollover TAS could not be found on the TP TAS table.
Supplier Site Default Trading Partner TAS Update report: This report displays the Supplier Site Default Trading Partner TASs rolled over.
Supplier Site Update Trading Partner TAS Not Found report: This report displays Supplier Sites with a Default Trading Partner TAS where the Ending Period of Availability matches Copy Fiscal Year parameter but the rollover TAS could not be found on the TP TAS table.
For rollover of Trading Partner TASs, the process includes updating the “To” date in the rolled over TP TAS based on the last day of the fiscal year for the Ending Period of Availability plus 5 years. This applies to TP TASs with an Ending Period of Availability, otherwise, leave the “To” date blank. The TASs to be rolled over are only Customer Account and Supplier Site Default TP TAS.
Related Topics