My Oracle Support Banner

GTAS Phase I, II, III, and IV (Part 2) (Doc ID 1530734.1)

Last updated on OCTOBER 08, 2020

Applies to:

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

Details

 This document is a continuation of Document ID:1530723.1,  GTAS Phase I, II, III, and IV (Part 1), and contains details for the GTAS components not included in the first document.

NOTE: In the images/examples above or below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

GTAS Attributes Table Setup Process

The GTAS Attributes Table Setup concurrent process populates the GTAS Attributes window with USSGL Accounts, Balance Types, and Attribute values for GTAS reporting from a file with GTAS seed data.   The GTAS seed data used to populate the GTAS Attributes window contains GTAS Attribute data consistent with the Bulk File GTAS Attributes Table spreadsheet on Treasury’s GTAS web-site. 

This concurrent process includes following parameters:

Parameter

Required

Purpose

 

 

 

Ledger

No

The Ledger for which records are created.  If no ledger is selected all ledgers will apply. 

Delete Existing Data?

 

Yes

Yes – Delete existing records in the GTAS Attributes table prior to repopulating all USSGL Account

No – Do not delete existing records in the GTAS Attributes table and only update the GTAS Attributes table with new USSGL Accounts 

 

GTAS Federal Accounts Creation Process

The GTAS Federal Account Creation Process creates records for GL accounts that require GTAS attributes that cannot be derived directly from the Accounting Flexfield.  This process performs similar functionality for GTAS that the FACTS I Federal Accounts Creation Process performed for FACTS I. 

This concurrent process includes following parameters: 

Parameter

Required

Purpose

 

 

 

Ledger

Yes

The Ledger for which records are created. 

Fiscal Year

Yes

The Fiscal Year for which records are created. 

The GTAS Federal Account Creation process selects all GL accounts from the GTAS Attributes form that meet one or more of the following criteria: 

For the GTAS Attribute rows selected, rows are created in the GTAS Federal Accounts table for each child account whose parent account matches the USSGL Account defined in the GTAS Attributes table that meets the above criteria.  These rows are populated with the following attributes:

Attribute

How Populated

USSGL Account

Populated from the Account Number on the GTAS Attribute form if the GTAS Account Number is a parent Natural Account 

Account Number

Populated with the child Account Number. 

Ledger 

Populated with concurrent process Ledger parameter value. 

Fiscal Year

Populated with the concurrent process Fiscal Year parameter value. 

Federal or Non-Federal Code Flag

If the Federal or Non-Federal Code on the GTAS Attribute form includes at least one value: populated with “Y”; otherwise, blank.

Trading Partner Flag

Populate with “Y” if the Trading Partner checkbox on the GTAS Attributes form is check, otherwise, blank. 

Authority Type Code Flag 

If Authority Type Code for the Account Number on the GTAS Attribute form includes at least one value, populate with “Y”; otherwise, blank.

Budgetary Impact Indicator Flag

If the Budgetary Impact Indicator on the GTAS Attribute form includes at least one value, populate with “Y”; otherwise blank.

 The table created for this process is used by the GTAS Activity Balance Creation process. 

 This process generates a report of all record created by this process with the following report layout:

GTAS Federal Account Creation Process Report

 

Ledger     : XXXXXXXXXXXXX

Fiscal Year: XXXX                                  

 

USSGL  Account Number                                Fed Non-Fed  Trading Ptnr  Auth Type  Budget Impact

-------- ------------------------------------------- -------------- --------------- -----------  ---------------- 

XXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX         X                  X                X              X        

 

GTAS Activity Balance Creation Process 

The GTAS Activity Balance Creation Process creates GTAS activity balances with GTAS attribute data that cannot be derived directly from segments on the Accounting Flexfield.  This process performs similar functionality for GTAS as the FACTS I Journal Creation Process performed for FACTS I. 

This concurrent process includes the following parameters:  

Parameter

Required

Description

 

 

 

Ledger

Yes

The Ledger for which GTAS Activity Balances are created/updated 

To Period

Yes

The Period through which GTAS Activity Balances are created/updated 

Re-create Activity Balances

Yes

Used to determine if Activity Balance are re-created or updated.

 Valid values:

  • Y – yes, the process deletes existing GTAS Activity Balances for the Fiscal Year and recreates these balances through the To Period
  • N - no, the process creates/updates GTAS Activity Balances for journals not already reflected in the GTAS Activity Balances through the To Period

 The GTAS Activity Balance Creation process selects GL Journals Lines for processing that meet the following criteria:  

The GTAS Activity Balance Table includes the attributes listed below.  Each GTAS Activity Balance Table row has a unique combination of all of these attributes except the last attribute (i.e., Dollar Amount).    

 Selected Attributes are derived based on the Journal Source and Category as illustrated in the table below:

                                               Attribute Derivation Table 

Journal Source

Journal Category

Authority Type Code

Trading Partner Type
C – Customer,

S – Supplier

B-Budgetary,      M-Manual and      O - all Other Journals

Trading Partner

Agency Identifier

Trading Partner

Main Account

All Journal sources other than the following:

Federal Transactions,

Receivables,

Payables,

Cost Management

Any

N/A

M or O

Populate from Characters 1-3 of the Journal Trading Partner DFF

Populate from Characters 4-7 of the Journal Trading Partner DFF

Federal Transactions

 

Look for the name equal to the name of first level on Budget Levels form

 

Populate from Transaction Type from Transaction Type Line, if present; otherwise from Transaction Type Header

B

If Federal or Non-Federal Code is “G”, populate with “099”.

 

Else

 

Populate with Transaction Trading Partner

Agency Identifier if present

If Federal or Non-Federal Code is “G”, populate with “0000”.

 

 

Else

 

Populate with Transaction Trading Partner

Main Account  if present

Federal Transactions

 

Budget Reprogram

Populate from Transaction Type from Transaction Type Line, if present; otherwise from Transaction Type Header

B

If Federal or Non-Federal Code is “G”, populate with “099”.

 

Else

 

Populate with Transaction Trading Partner

Agency Identifier if present

If Federal or Non-Federal Code is “G”, populate with “0000”.

 

 

Else

 

Populate with Transaction Trading Partner

Main Account  if present

Federal Transactions

Treasury Confirmation

N/A

S

Populate the Trading Partner Agency Identifier from AP Supplier

Populate the Trading Partner Main Account from the AP Invoice Distribution Line

Receivables

 

Sales Invoice

N/A

C

Populate the Trading Partner Agency Identifier from AR Transaction Customer  

 

Receivables

 

Receipts

N/A

C

Populate the Trading Partner Agency Identifier from the related AR Transaction Customer   

 

Payables

 

Purchase Invoices

N/A

S

Populate the Trading Partner Agency Identifier from AP Supplier

 

Payables

 

Payments

N/A

S

Populate the Trading Agency Identifier from the related AP Supplier

 

Payables

 

Treasury Confirm

N/A

S

Populate the Trading Agency Identifier from the related AP Supplier

 

Cost Management

Receiving

N/A

S

Populate the Trading Agency Identifier from the related PO Supplier

 

  

Exceptions/Possible Errors

Exception

Type:
E=Error W=Warning

Message

 

 

 

A single Authority Type Code cannot be derived 

E

Single Authority Type cannot be Derived from the GL Account

The Budget Transaction Sub Type Authority Type Code does not Match the GTAS Authority Type Code GL Attribute

E

Budget Transaction Sub Type Authority Type Code Does not Match GTAS Authority Type Code GL Attribute 

The Budget Transaction Type Authority Type Code does not Match the GTAS Authority Type Code GL Attribute 

E

Budget Transaction Type Authority Type Code Does not Match GTAS Authority Type Code GL Attribute

The Customer or Supplier Trading Partner is not compatible with the GTAS Federal or Non-Federal GL Attribute 

E

Trading Partner not Compatible with the GTAS Federal or Non-Federal Code GL Attribute

The Customer or Supplier has a Federal Trading Partner but does not have a valid Agency Identifier 

E

Federal Trading Partner must have an Agency ID between 000-999 

The Customer or Supplier has a Non-Federal Trading Partner but has a Trading Partner Agency ID

E

A Non-Federal Trading Partner should not have a Trading Partner Agency ID 

The Transaction has budgetary impact but GL Attributes does not permit budgetary impacts or the Transaction does not have budgetary impact but GL Attribute requires budgetary impact. 

E

GTAS Budgetary Impact Indicator GL Attribute requires Budgetary Impact

 

 The GTAS Activity Balance Exception Report layout is provided below:

 

GTAS Activity Balance Creation Exception Report

 

Ledger Name     : XXXXXXXXXXXXXXXXXXXX                                     99-XXX-9999 99:99

Reporting Period: XXXXXXXXXXXXXXXXXXXX                                     Page 999999 of 999999

 

Journal Source   : XXXXXXXXXXXXXXXXXXXX

Journal Category: XXXXXXXXXXXXXXXXXXXX

Exception           : XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 

Document Number

USSGL Account

GL Account Number

AID

MAIN

Trading Partner

Budget Transaction Type

Amount

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

XXXXXX

XXXXXXXXXX

999

9999

XXXXXXXXXXXXXXXXXXXX

XXXXXXXXXXXXXXXXXXXX

-999,999,999,999,999

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

XXXXXX

XXXXXXXXXX

999

9999

XXXXXXXXXXXXXXXXXXXX

XXXXXXXXXXXXXXXXXXXX

-999,999,999,999,999

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

XXXXXX

XXXXXXXXXX

999

9999

XXXXXXXXXXXXXXXXXXXX

XXXXXXXXXXXXXXXXXXXX

-999,999,999,999,999

 

Journal Source   : XXXXXXXXXXXXXXXXXXXX

Journal Category: XXXXXXXXXXXXXXXXXXXX

Exception          : XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 

Document Number

USSGL Account

GL Account Number

AID

MAIN

Trading Partner

Budget Transaction Type

Amount

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

XXXXXX

XXXXXXXXXX

999

9999

XXXXXXXXXXXXXXXXXXXX

XXXXXXXXXXXXXXXXXXXX

-999,999,999,999,999

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

XXXXXX

XXXXXXXXXX

999

9999

XXXXXXXXXXXXXXXXXXXX

XXXXXXXXXXXXXXXXXXXX

-999,999,999,999,999

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

XXXXXX

XXXXXXXXXX

999

9999

XXXXXXXXXXXXXXXXXXXX

XXXXXXXXXXXXXXXXXXXX

-999,999,999,999,999

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

XXXXXX

XXXXXXXXXX

999

9999

XXXXXXXXXXXXXXXXXXXX

XXXXXXXXXXXXXXXXXXXX

-999,999,999,999,999

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

XXXXXX

XXXXXXXXXX

999

9999

XXXXXXXXXXXXXXXXXXXX

XXXXXXXXXXXXXXXXXXXX

-999,999,999,999,999

 

GTAS Interface Process

The primary purpose of the GTAS Interface Process is to create a GTAS Interface file for Treasury.  Specifically, this process:

This concurrent process includes the following parameters:

Parameter

Required

Default

Purpose

Ledger 

Yes

 

Select Ledger 

To Period

Yes

None

Select Period for which balances will be generated

Agency ID Low 

No

None

Select low value for Agency ID range

Agency ID High

No, when low range value is not entered.

 Required if low range is entered and must be greater than or equal to the low range 

None

Select high value for Agency ID range

Main Account Low 

No

 

Select Low value for Main Account range

Main Account High

No, when low range value is not entered. 

Required if low range is entered and must be greater than or equal to the low range 

 

Select high value for Main Account range

Save Ending Balances

Yes

No

Used to save ending balances in the GTAS Ending Balances table.  Should be set to “Y” when running GTAS process after year-end closing so that ending balances are save so they can be used as beginning balances for GTAS for the next fiscal year. 

Generate Reports

Yes

Yes

Use to determine if reports should be generated.  Should be set to “Y” to generate Adjusted Trail Balance Report. 

 This process performs similar functionality for GTAS as the FACTS I Interface Process performed for FACTS I.

Create GTAS Extract Table

A GTAS Extract Table is created using GTAS Interface Process parameters as follows:

Balance Type

 

Beginning Balances

GTAS Ending Balance Data from prior Fiscal Year based on the To Period parameter

Ending Balances

GTAS Ending Balance Data from the prior Fiscal Year plus GTAS Activity Balances up through the To Period parameter specified.

 The GTAS Extract Table is created using data in the following tables as input:

  • The GL Balances Table
  • The GTAS Activity Balance Table
  • The GTAS Ending Balances Table (prior year ending balance data)

The GTAS Extract Table includes data in the table below.  Note that all data needed for the GTAS Bulk File and GTAS Trail Balance are provided in this table with the exception of GTAS Attributes that can be derived from segment of the CCID.  

Field Name

Source Table (Beginning Balances)

Source Table (Ending Balances)

How Populated

CCID

GTAS Ending  Balances Table (prior year data)

GL Balances Table

  • Populate using the CCID

Fund

GTAS Ending Detail Balances Table (prior year data)

GL Balances Table

  • Populate using the balancing segment of the CCID

Natural Account

GTAS Ending  Detail Balances Table (prior year data)

GL Balances Table

  • Populate from the Natural Account segment of the CCID

Debit Credit Indicator

GTAS Ending  Detail Balances Table (prior year data)

 

GL Balances Table

  • Populate based on the balance of amount: D - Debit for a positive amount or C - Credit Balance for a negative amount.

Begin End Indicator

GTAS Attributes Table

GTAS Attributes Table

  • Look up the Begin End Indicator GTAS attribute for the GL Account,
  • Populate Begin End Indicator GTAS attribute value 

Note:  If the value = S (Both), create 2 extract records, one with B and one with E.

Authority Type Code

GTAS Ending  Detail Balances Table (prior year data)

GTAS Activity Balance Table

  • Populate with the Authority Type Code

Federal or Non-Federal Code

GTAS Ending  Detail Balances Table (prior year data)

GTAS Activity Balance Table

  • Populate with the Federal or Non-Federal Code

Trading Partner Agency Identifier

GTAS Ending  Detail Balances Table (prior year data)

GTAS Activity Balance Table

  • Populate with Trading Partner Agency Identifier

Trading Partner Main Account Code

 

GTAS Ending  Detail Balances Table (prior year data)

GTAS Activity Balance Table

  • Populate with Trading Partner Main Account

Budgetary Impact Indicator

GTAS Ending  Detail Balances Table (prior year data)

GTAS Activity Balance Table

  • Populate with Budgetary Impact Indicator

Dollar Amount

GL Balance Table (prior year data)  / GTAS Ending Detail Balances Table (prior year data)

GL Balance Table /

GTAS Activity Balance Table

  • Dollar Amount summarize using the above columns
    • o If Begin End Indicator = B, GL Balances
    • o IF Begin End Indictor = E, GTAS Ending Balances Table (prior year data)

GTAS Interface Validations Exception Reports

TThe GTAS Interface process performs the validations described below

Validation

Description

Multiple US SGL Account Parents Defined 

The account has multiple US SGL parents defined in General Ledger and is not reported in GTAS.

Apportionment Category Code not valid for GL Account

The Apportionment Category Code derived based on the Fund is not valid for the GL Account based on the Apportionment Category Code GTAS Attribute valid values.

Program Reporting Category Code is Required 

The Program Report Category Code is required based on the Program Report Category Code GTAS Attribute configuration for the GL Account but not configured on the Reporting Codes form. 

Apportionment Category B Code is Required  

The Apportionment Category B Program Code is required based on the Apportionment Category B Program Code GTAS Attribute configuration for the GL Account but is not configured on the Reporting Codes form.

Custodial or Noncustodial Code not valid for GL Account

The Custodial or Noncustodial Code derived based on the Fund is not valid for the GL Account based on the Custodial or Noncustodial Code GTAS Attribute valid values. 

Program Cost Indicator is Required 

The Program Cost Indicator is required based on the Program Cost Indicator GTAS Attribute configuration for the GL Account but is not configured on the Reporting Codes form. 

Budgetary Impact Indicator not valid for GL Account

The derived Budgetary Impact is not valid for the GL Account based on the Budgetary Impact Indicator GTAS Attribute valid values.

The GTAS Interface Validation Exception Report layout is provided below:

 

GTAS Interface Validation Exception Report

 

                   Ledger: XXXXXXXXXXXXXXXXXXXXXX                                                                  99-XXX-9999 99:99:99

       Reporting Period: XXXXXXXXXXXXXXXXXXXX                                                                          Page: 9999 / 9999

          Agency ID Low: 999

         Agency ID High: 999

       Main Account Low: 9999

      Main Account High: 9999     

GTAS GL Account: XXXXXXXXXX    

XXXXXXXXXXXXXXXXXXXXXXXXXXXXX 

TAS Components

Treasury Account Symbol

FUND

ATA

AID

BPOA

EPOA

AV

MAIN

SUB

999

999

9999

9999

X

9999

999

XXXXXXXXXXXXXXXXXXX

XXXXXXXXXXXXXXXXXXXX

999

999

9999

9999

X

9999

999

XXXXXXXXXXXXXXXXXXX

XXXXXXXXXXXXXXXXXXXX

999

999

9999

9999

X

9999

999

XXXXXXXXXXXXXXXXXXX

XXXXXXXXXXXXXXXXXXXX

999

999

9999

9999

X

9999

999

XXXXXXXXXXXXXXXXXXX

XXXXXXXXXXXXXXXXXXXX

 

Accounts Not Eligible for GTAS Report

The GTAS Bulk File Creation process determines General Ledger accounts that have balances that are not eligible for GTAS (e.g. agency specific memorandum accounts) reporting.  Accounts that meet one or more of the following criteria are listed: 

  • The account does  not have a parent account defined on the US SGL Table
  • The account does have a parent on the US SGL Table but it is disabled.
  • The account or the parent of the account is not defined on the GTAS Attributes form. 

Output provided for accounts that meet the at least one of the above criteria is as follows: 

The following GL accounts do not have valid USSGL Accounts: 

GL Account Number           

------------------

XXXXXXXXXX            

XXXXXXXXXX

XXXXXXXXXX

XXXXXXXXXX

XXXXXXXXXX

 

GTAS Bulk File Interface Report

 The GTAS Bulk File Interface Report provides the US SGL Account Balances and Attributes that are captured in the GTAS Bulk File.  The report will display the following data: 

Header Data

Detail Data: 

Column Title

Description

When Populated

Source

ATA

Allocation Transfer Agency Identifier

Always

Derived from TAS

AID

Agency Identifier

Always

Derived from TAS

BPOA

Beginning Period of Availability

Always

Derived from TAS

EPOA

Ending Period of Availability

Always

Derived from TAS

A

Availability Type Code

Always

Derived from TAS

MAIN

Main Account Code

Always

Derived from TAS

SUB

Sub-Account Code

Always

Derived from TAS

Acct No

Natural Account Segment

Always

From GTAS Extract Table

Amount

Amount

Always

From GTAS Extract Table

DR/CR

Debit / Credit  (D or C)

Always

From GTAS Extract Table

B/E

Beginning / Ending Balance

Based Begin End Indicator GTAS Attribute value for the GL Account: Beginning, Ending, or Both (beginning and ending) 

From GTAS Extract Table

ATC

Authority Type Code

If the Authority Type Code GTAS Attribute value for the GL Account is not null 

From GTAS Extract Table

DRC

Direct or Reimbursable Code

If the Direct or Reimbursable Code GTAS Attribute checkbox for the GL Account is checked. 

Derived from the Fund

ACC

Apportionment Category Code

If the Apportionment Category Code GTAS attribute value for the GL Account is not null. 

Derived from the Fund

ACB

Apportionment Category B Code

If the Apportionment Category Code derived for the Fund is “B” and the Apportionment Category Code GTAS Attribute checkbox is checked. 

Derived from the Reporting Codes based on configuration

PRC

Program Reporting Category Code

If the Program Report Category Code GTAS Attribute checkbox is checked and the Apportionment Category Code value derived from the Fund is “A” or “B” 

Derived from the Reporting Codes based on configuration.

FNF

Federal or Non-Federal Code

Always

From GTAS Extract Table

TPA

Trading Partner Agency Identifier

Always

From GTAS Extract Table

TPM

Trading Partner Main Account

Always

From GTAS Extract Table

NBC

New or Bal Code

If the New or Bal Code GTAS Attribute value for the GL Account is checked and  the Financing Code for the Fund does not = D or G 

If the Budget Fiscal Year is less than the Fiscal Year parameter, populate with BAL, otherwise populate with NEW. 

CSC

Current or Subsequent Code

If the Availability Time GTAS Attribute value for the GL Account is not null 

Derived from the Current or Subsequent Code GTAS Attribute

BEA

BEA Category Code

If the BEA Category Code GTAS Attribute value for the GL Account is checked 

  • If the BEA Category Code Account Type GTAS Attribute value = “Budget Authority”,
    • Lookup the Budget Authority BEA Category Code Fund Attribute on the Fund Attributes form.
    • Populate with the value of the Budget Authority BEA Category Code Fund Attribute.
    • If the BEA Category Code Account Type GTAS Attribute value = “Outlays”,
    • Lookup the Outlays BEA Category Code Fund Attribute on the Fund Attributes form.
    • Populate with the value of the Outlays BEA Category Code Fund Attribute.

BSC

Borrowing Source Code

If the Borrowing Source Code GTAS attribute value for the GL Account is checked. 

Derived from the Fund

ENC

Exchange or Non-exchange Code

If the Exchange or Non-exchange GTAS Attribute value for the GL Account is not null 

Derived from the Exchange or Non-exchange GTAS Attribute

CNC

Custodial or Noncustodial Code

If the Custodial or Noncustodial Code GTAS attribute value for the GL Account is not null 

Derived from the Fund

BII

Budget Impact Indicator

If the Budgetary Impact Indicator GTAS attribute value for the GL Account is not null

From GTAS Extract Table

PYA

Prior Year Adjustment Code

If the Prior Year Adjustment Code GTAS attribute value for the GL Account is not null 

Derived from the Prior Year Adjustment Code GTAS Attribute

CCY

Credit Cohort Year

If the Financing Code for the Fund = D or G and the USSGL account is budgetary 

From CCID (Credit Cohort Year Segment)

PCI

Program Cost Indicator

If the Program Cost Indicator GTAS Attribute checkbox for the GL is checked.

Derived from the Reporting Codes table based on configuration. 

  The GTAS Adjusted Trail Balance Report layout is provided below:

 

 

 

GTAS Bulk File Interface Report

Ledger:

XXXXXXXXXXXXXXXXXXXX

 

Report Date:

99/99/9999 99:99

 

Period:

XXXXXXXXXXXXXXXXXXXX

 

Page::

99999

 

Agency ID Low:

XXXXXXXXXXXXXXXXXXXX

 

 

 

 

Agency ID High:

XXXXXXXXXXXXXXXXXXXX

 

 

 

 

Main Account Low:

XXXXXXXXXXXXXXXXXXXX

 

 

 

 

Main Account High:

XXXXXXXXXXXXXXXXXXXX

 

 

 

 

 

 

TAS Components

 

ATA

AID

BPOA

EPOA

A

MAIN

SUB

 

999

999

9999

9999

X

9999

999

 

USSGL

Amount

D/C

B/E

ATC

DRC

ACC

ACB

PRC

FNF

TPA

TPM

NBC

CSC

BEA

BSC

ENC

CNC

BII

PYA

CCY

PCI

XXXXXX

9,999,999,999,999,990

X

X

X

X

X

XX

XX

X

999

9999

XXX

X

999

9999

X

XXX

X

X

9999

X

XXXXXX

9,999,999,999,999,990

X

X

X

X

X

XX

XX

X

999

9999

XXX

X

999

9999

X

XXX

X

X

9999

X

XXXXXX

9,999,999,999,999,990

X

X

X

X

X

XX

XX

X

999

9999

XXX

X

999

9999

X

XXX

X

X

9999

X

XXXXXX

9,999,999,999,999,990

X

X

X

X

X

XX

XX

X

999

9999

XXX

X

999

9999

X

XXX

X

X

9999

X

XXXXXX

9,999,999,999,999,990

X

X

X

X

X

XX

XX

X

999

9999

XXX

X

999

9999

X

XXX

X

X

9999

X

XXXXXX

9,999,999,999,999,990

X

X

X

X

X

XX

XX

X

999

9999

XXX

X

999

9999

X

XXX

X

X

9999

X

XXXXXX

9,999,999,999,999,990

X

X

X

X

X

XX

XX

X

999

9999

XXX

X

999

9999

X

XXX

X

X

9999

X

XXXXXX

9,999,999,999,999,990

X

X

X

X

X

XX

XX

X

999

9999

XXX

X

999

9999

X

XXX

X

X

9999

X

XXXXXX

9,999,999,999,999,990

X

X

X

X

X

XX

XX

X

999

9999

XXX

X

999

9999

X

XXX

X

X

9999

X

XXXXXX

9,999,999,999,999,990

X

X

X

X

X

XX

XX

X

999

9999

XXX

X

999

9999

X

XXX

X

X

9999

X

XXXXXX

9,999,999,999,999,990

X

X

X

X

X

XX

XX

X

999

9999

XXX

X

999

9999

X

XXX

X

X

9999

X

XXXXXX

9,999,999,999,999,990

X

X

X

X

X

XX

XX

X

999

9999

XXX

X

999

9999

X

XXX

X

X

9999

X

XXXXXX

9,999,999,999,999,990

X

X

X

X

X

XX

XX

X

999

9999

XXX

X

999

9999

X

XXX

X

X

9999

X

XXXXXX

9,999,999,999,999,990

X

X

X

X

X

XX

XX

X

999

9999

XXX

X

999

9999

X

XXX

X

X

9999

X


 

Acronyms

A

Availability Type Code

ACB

Apportionment Category B Program Code

ACC

Apportionment Category Code

AID

Agency Identifier

ATA

Allocation Transfer Agency Identifier

ATC

Authority Type Code

BEA

BEA Category Code

BII

Budget Impact Indicator

BPOA

Beginning Period of Availability

BSC

Borrowing Source Code

B/E

Begin End Indicator

CNC

Custodial or Noncustodial Code

CSC

Current or Subsequent Code

CCY

Credit Cohort Year

DRC

Direct or Reimbursable Code

D/C

Debit Credit Indicator

ENC

Exchange or Non-exchange Code

EPOA

Ending Period of Availability

FNF

Federal or Non-Federal Code

MAIN

Main Account Code

NBC

New or Bal Code

PCI

Program Cost Indicator

PRC

Program Reporting Category Code

PYA

Prior Year Adjustment Code

TAS

Treasury Account Symbol

TPA

Trading Partner Agency Identifier

TPM

Trading Partner Main Account

SUB

Sub-Account Code

USSGL

U.S. Standard General Ledger

 

GTAS Bulk File  

The GTAS bulk file is populated using data on the GTAS Extract Table and data derived from element on this table as follows.

 

Field Name

Length

Start Column

End
Column

Type

When Populated

How Populated

FISCAL YEAR

4

1

4

X

Always

  • Populate using the Federal Fiscal Year based on the GTAS submission Period

REPORTING PERIOD

2

5

6

X

Always

  • Populate with the Federal Fiscal Month based on the GTAS submission Period

ALLOCATION TRANSFER AGENCY IDENTIFIER

 

3

7

9

X

Always

  • Lookup the TAS for the Fund
  • Populate using the Allocation Transfer Agency Identifier component of the TAS

AGENCY IDENTIFIER

3

10

12

X

Always

  • Lookup the TAS for the Fund
  • Populate using the Agency Identifier component of the TAS

BEGINNING PERIOD OF AVAILABILITY

 

4

13

16

X

Always

  • Lookup the TAS for the Fund
  • Populate using the Beginning Period of Availability component of the TAS

ENDING PERIOD OF AVAILABILITY

4

17

20

X

Always

  • Lookup the TAS for the Fund
  • Populate using the Ending Period of Availability component of the TAS

AVAILABILITY TYPE INDICATOR

1

21

21

X

Always

  • Lookup the TAS for the Fund
  • If there is a Cancellation Date for the TAS and the Year and Month for this date is less than the Parameter Year and Month, populate with "C", otherwise populate with the value of the Availability Type Indicator component of the TAS.

MAIN ACCOUNT CODE

4

22

25

X

Always

  • Lookup the TAS for the Fund
  • Populate from the Main Account Code component of the TAS

SUB ACCOUNT CODE

3

26

28

X

Always

  • Lookup the TAS for the Fund
  • Populate using the Sub Account Code component of the TAS

USSGL ACCOUNT NUMBER CODE

6

29

34

X

Always

  • Look up the parent account for the child account that matches the USSGL on the FV USSGL Account Table
  • Populate with the USSGL Account

DOLLAR AMOUNT

21

35

55

9

Always

  • Populate from summarized amounts of GTAS Extract Data

DEBIT CREDIT INDICATOR

1

56

56

X

Always

  • Populate based on the balance of summarized amount: Debit for a positive amount or Credit Balance for a negative amount.

BEGIN END INDICATOR

1

57

57

X

Always

  • Populate based on GTAS Attributes Table value for GL Account

AUTHORITY TYPE CODE

 

1

58

58

X

If the Authority Type Code GTAS Attribute value for the GL Account is not null

  • Populate from the GTAS Extract Table

REIMBURSABLE INDICATOR

 

1

59

59

X

If the Direct or Reimbursable Code GTAS Attribute value for the GL Account is not null

  • Lookup the Direct or Reimbursable Code attribute for the Fund on the Fund Attributes form.
  • Populate from the Direct or Reimbursable Code Fund attribute

APPORTIONMENT CATEGORY CODE

 

1

60

60

X

If the Apportionment Category Code GTAS attribute value for the GL Account is not null

  • Lookup Apportionment Category Code attribute for the Fund on the Fund Attributes form.
  • Populate from the Apportionment Category Code Fund attribute

APPORTIONMENT CATEGORY B PROGRAM CODE

 

4

61

64

X

If the Apportionment Category Code GTAS Attribute value for the GL Account is “B”

  • Look up “Apportionment Category B Code” as the Code Type in the Reporting Codes Table
  • Populate the value of the Apportionment Category B Code based on the configuration mapping.

PROGRAM REPORT CATEGORY CODE

 

2

65

66

X

If the Apportionment Category Code GTAS Attribute value for the GL Account is “A” or “B”

  • Look up “Program Report Category Number” as the Code Type in the Reporting Codes Table
  • Populate the value of the Program Report Category Code based on the configuration mapping.

FEDERAL/ NON-FEDERAL INDICATOR

1

67

67

X

Always

  • Populate from the GTAS Extract Table

TRADING PARTNER AGENCY IDENTIFIER

3

68

70

X

Always

  • Populate from the GTAS Extract Table

TRADING PARTNER MAIN ACCOUNT CODE

4

71

74

X

Always

  • Populate from the GTAS Extract Table

YEAR OF BUDGET AUTHORITY CODE

 

3

75

77

X

If the New or Bal Code GTAS Attribute value for the GL Account is not null.

  • If the Budget Fiscal Year is less than the Fiscal Year parameter, populate with BAL, otherwise populate with NEW. 

AVAILABLITY TIME INDICATOR

1

78

78

X

If the Current or Subsequent Code GTAS Attribute value for the GL Account is not nul

  • Look up the GTAS Attributes for the GL Account
  • Populate with the value of the Current or Subsequent Code 

BEA CATEGORY INDICATOR

1

79

79

X

If the BEA Category Code GTAS Attribute value for the GL Account is not null

  • If the BEA Category Code Account Type GTAS Attribute value = “Budget Authority”,
    • Lookup the Budget Authority BEA Category Code Fund Attribute on the Fund Attributes form.
    • Populate with the value of the Budget Authority BEA Category Code Fund Attribute.
  • If the BEA Category Code Account Type GTAS Attribute value = “Outlays”,
    • Lookup the Outlays BEA Category Code Fund Attribute on the Fund Attributes form.
    • Populate with the value of the Outlays BEA Category Code Fund Attribute.

BORROWING SOURCE

 

1

80

80

X

If the Borrowing Source Code GTAS attribute value for the GL Account is “Y”

  • Lookup the Borrowing Source Code Fund Attributes for the Fund on the Fund Attributes form.
  • Use the value of the Borrowing Source Code Fund Attribute 

EXCHANGE NON-EXCHANGE INDICATOR

 

1

81

81

X

If the Exchange  or Non-exchange Code GTAS Attribute value for the GL Account is not null

  • Look up the Exchange or Non-exchange Code GTAS Attributes for the GL Account 
  • Populate with the Exchange / Non Exchange Code GTAS Attribute value 

CUSTODIAL ACTIVITY INDICATOR

1

82

82

X

If the Custodial Activity GTAS attribute value for the GL Account is not null

  • Lookup the Custodial or Noncustodial Fund Attribute on the Fund Attributes form.
  • Use the value of the Custodial or Noncustodial Code Fund Attribute. 

BUDGETARY IMPACT INDICATOR

1

83

83

X

If the Budgetary Impact Indicator GTAS attribute value for the GL Account is not null

  • Populate from the GTAS Extract Table

 

PRIOR YEAR ADJUSTMENT CODE

1

84

84

X

If the Prior Year Adjustment Code GTAS attribute value for the GL Account is not null

  • Look up the Prior Year Adjustment Code GTAS Attribute for the GL Account
  • If the GTAS Begin End Indicator is E or if the GTAS Fiscal Year submission parameter equals the Budget Fiscal Year on the transaction, populate with X, otherwise, Populate with the Prior Year Adjustment Code GTAS attribute value

CREDIT COHORT YEAR

4

85

88

X

If the Financing Account Code for TAS of the Fund = D or G and the USSGL account is a budgetary account

  • Determine the Credit Cohort Year Segment from the Federal Financial Options 
  • Populate with Credit Cohort Year value from the Credit Cohort Year Segment identified on Federal Financial Options form.

PROGRAM INDICATOR

1

89

89

X

If the Program Cost Indicator GTAS Attribute for the GL Account in not null.

  • Look up “Program Cost Code” for the Code Type in the Reporting Codes Table
  • Populate the value of the Program Cost Indicator based on the configuration mapping.

 

GTAS Trial Balance

The GTAS Trial Balance includes USSGL Balances at the GTAS Attribute level of detail

The GTAS Trial Balance will display the following data:

GTAS Trial Balance Report

 

 

Ledger:

XXXXXXXXXXXXXXXXXXXX

 

Report Date:

99/99/9999  99:99

Flexfield Low

XXXXXXXXXXXXXXXXXXXXXXXXXXX

 

Page::

99999

Flexfield High

XXXXXXXXXXXXXXXXXXXXXXXXXXX

 

 

 

Period:

XXXXXXXXXXXXXXXXXXXX

 

 

 

Agency ID  Low

XXXXXXXXXXXXXXXXXXXX

 

 

 

Agency ID High

XXXXXXXXXXXXXXXXXXXX

 

 

 

Main Account  Low

XXXXXXXXXXXXXXXXXXXX

 

 

 

Main Account High

XXXXXXXXXXXXXXXXXXXX

 

 

 

Treasury Account Symbol

XXXXXXXXXXXXXXXXXXXX

 

 

 

 

TAS Components

 

ATA

AID

MAIN

BPOA

EPOA

A

SUB

 

999

999

9999

9999

9999

X

999

 

Acct No

Beginning Balance

Current Period Debits

Current Period Credits

Ending Balance

ATC

DRC

ACC

ACB

PRC

FNF

TPA

TPM

NBC

CSC

BEA

BSC

ENC

CNC

BII

PYA

CCY

PCI

XXXXXXXXXX

-9,999,999,999,999,990

-9,999,999,999,990

-9,999,999,999,990

-9,999,999,999,999,990

X

X

X

9999

99

X

999

9999

XXX

X

X

X

X

X

X

X

9999

X

XXXXXXXXXX

-9,999,999,999,999,990

-9,999,999,999,990

-9,999,999,999,990

-9,999,999,999,999,990

X

X

X

9999

99

X

999

9999

XXX

X

X

X

X

X

X

X

9999

X

XXXXXXXXXX

-9,999,999,999,999,990

-9,999,999,999,990

-9,999,999,999,990

-9,999,999,999,999,990

X

X

X

9999

99

X

999

9999

XXX

X

X

X

X

X

X

X

9999

X

XXXXXXXXXX

-9,999,999,999,999,990

-9,999,999,999,990

-9,999,999,999,990

-9,999,999,999,999,990

X

X

X

9999

99

X

999

9999

XXX

X

X

X

X

X

X

X

9999

X

XXXXXXXXXX

-9,999,999,999,999,990

-9,999,999,999,990

-9,999,999,999,990

-9,999,999,999,999,990

X

X

X

9999

99

X

999

9999

XXX

X

X

X

X

X

X

X

9999

X

XXXXXXXXXX

-9,999,999,999,999,990

-9,999,999,999,990

-9,999,999,999,990

-9,999,999,999,999,990

X

X

X

9999

99

X

999

9999

XXX

X

X

X

X

X

X

X

9999

X

TAS Total

 

-9,999,999,999,990

-9,999,999,999,990

 

 

 

Acronyms

A

Availability Type Code

ACB

Apportionment Category B Program Code

ACC

Apportionment Category Code

AID

Agency Identifier

ATA

Allocation Transfer Agency Identifier

ATC

Authority Type Code

BEA

BEA Category Code

BII

Budget Impact Indicator

BPOA

Beginning Period of Availability

BSC

Borrowing Source Code

CNC

Custodial or Noncustodial Code

CSC

Current or Subsequent Code

CCY

Credit Cohort Year

DRC

Direct or Reimbursable Code

ENC

Exchange or Non-exchange Code

EPOA

Ending Period of Availability

FNF

Federal or Non-Federal Code

MAIN

Main Account Code

NBC

New or Bal Code

PCI

Program Cost Indicator

PRC

Program Reporting Category Code

PYA

Prior Year Adjustment Code

TAS

Treasury Account Symbol

TPA

Trading Partner Agency Identifier

TPM

Trading Partner Main Account

SUB

Sub-Account Code

GTAS Transaction Register

The GTAS Transaction Register Report includes USSGL transaction activity at the GTAS Attribute level of detail

The GTAS Transaction Register report will display the following data:

GTAS Transaction Register

 

Ledger:

XXXXXXXXXXXXXXXXXXXX

 

Report Date:

99/99/9999 99:99

Flexfield Low:

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

 

Page::

99999

Flexfield High:

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

 

 

Start Period:

XXXXXXXXXXXXXXXXXXXX

 

 

End Period:

XXXXXXXXXXXXXXXXXXXX

 

 

Posted Date From:

99/99/9999

 

 

Posted Date To:

99/99/9999

 

Journal Source:

XXXXXXXXXXXXXXXXXXXX

 

Journal Category:

XXXXXXXXXXXXXXXXXXXX

 

Agency ID  Low

XXXXXXXXXXXXXXXXXXXX

 

 

 

 

Agency ID High

XXXXXXXXXXXXXXXXXXXX

 

 

 

 

Main Account  Low

XXXXXXXXXXXXXXXXXXXX

 

 

 

 

Main Account High

XXXXXXXXXXXXXXXXXXXX

 

 

 

 

               
 

TAS Components

 

ATA

AID

BPOA

EPOA

A

MAIN

SUB

 

999

999

9999

9999

X

9999

999

 

Source

Category

 

XXXXXXXXXXXXXXXXXXXX

XXXXXXXXXXXXXXXXXX

 

 

Transaction Number

 

XXXXXXXXXXXXXXXXXXXX

 

Event ID

US Sgl

Accounting Flexfield

Debit Amount

Credit Amount

GL Date

Posted Date

ATC

DRC

ACC

ACB

PRC

FNF

TPA

TPM

NBC

CSC

ENC

BEA

BSC

CNC

BII

PYA

CCY

PCI

999999999999999

XXXXXX

XXXXXXXXXXXXXXXXXXXXXXXXXXX

999,999,999,999

999,999,999,999

XXX-XX-XXXX

XXX-XX-XXXX

X

X

X

9999

99

X

999

9999

X

X

X

X

X

X

X

X

9999

X

999999999999999

XXXXXX

XXXXXXXXXXXXXXXXXXXXXXXXXXX

999,999,999,999

999,999,999,999

XXX-XX-XXXX

XXX-XX-XXXX

X

X

X

9999

99

X

999

9999

X

X

X

X

X

X

X

X

9999

X

999999999999999

XXXXXX

XXXXXXXXXXXXXXXXXXXXXXXXXXX

999,999,999,999

999,999,999,999

XXX-XX-XXXX

XXX-XX-XXXX

X

X

X

9999

99

X

999

9999

X

X

X

X

X

X

X

X

9999

X

999999999999999

XXXXXX

XXXXXXXXXXXXXXXXXXXXXXXXXXX

999,999,999,999

999,999,999,999

XXX-XX-XXXX

XXX-XX-XXXX

X

X

X

9999

99

X

999

9999

X

X

X

X

X

X

X

X

9999

X

Transaction Number Total

999,999,999,999

999,999,999,990

 

 

Transaction Number

 

XXXXXXXXXXXXXXXXXXXX

 

Event ID

US Sgl

Accounting Flexfield

Debit Amount

Credit Amount

GL Date

Posted Date

ATC

DRC

ACC

ACB

PRC

FNF

TPA

TPM

NBC

CSC

ENC

BEA

BSC

CNC

BII

PYA

CCY

PCI

999999999999999

 XXXXXX

XXXXXXXXXXXXXXXXXXXXXXXXXXX

999,999,999,999

999,999,999,999

XXX-XX-XXXX

XXX-XX-XXXX

X

X

X

9999

99

X

999

9999

X

X

X

X

X

X

X

X

9999

X

999999999999999

XXXXXX

XXXXXXXXXXXXXXXXXXXXXXXXXXX

999,999,999,999

999,999,999,999

XXX-XX-XXXX

XXX-XX-XXXX

X

X

X

9999

99

X

999

9999

X

X

X

X

X

X

X

X

9999

X

Transaction Number Total

999,999,999,999

999,999,999,990

 

TAS Component Total

999,999,999,999

999,999,999,990

 

 

 

Acronyms

A

Availability Type Code

ACB

Apportionment Category B Program Code

ACC

Apportionment Category Code

AID

Agency Identifier

ATA

Allocation Transfer Agency Identifier

ATC

Authority Type Code

BEA

BEA Category Code

BII

Budget Impact Indicator

BPOA

Beginning Period of Availability

BSC

Borrowing Source Code

CNC

Custodial or Noncustodial Code

CSC

Current or Subsequent Code

CCY

Credit Cohort Year

DRC

Direct or Reimbursable Code

ENC

Exchange or Non-exchange Code

EPOA

Ending Period of Availability

FNF

Federal or Non-Federal Code

MAIN

Main Account Code

NBC

New or Bal Code

PCI

Program Cost Indicator

PRC

Program Reporting Category Code

PYA

Prior Year Adjustment Code

TAS

Treasury Account Symbol

TPA

Trading Partner Agency Identifier

TPM

Trading Partner Main Account

SUB

Sub-Account Code

Create GTAS Ending Balances

If the Save Ending Balances parameter is “Y”, the process creates ending balances records on the GTAS Ending Balances Table.   GTAS Ending Balance records are created from records in the GTAS Extract Table.  However, only GTAS Extract Table records with a Begin End Indicator of “E” are included in the GTAS Ending Balances Table.  The GTAS Ending Balance Table includes the same data elements included in the GTAS Extract Table.  However, it does not include a Begin End Indicator and also include a Fiscal Year element.  

The data elements in the GTAS Ending Balances Table are provided in the following table. 

Field Name

Source

Ledger

GTAS Interface Process Parameter

Fiscal Year

GTAS Interface Process Parameter

CCID

GTAS Extract Table

Fund

GTAS Extract Table

Natural Account

GTAS Extract Table

Debit Credit Indicator

GTAS Extract Table

Begin End Indicator

GTAS Extract Table

Authority Type Code

GTAS Extract Table

Federal or Non-Federal Code

GTAS Extract Table

Trading Partner Agency Identifier

GTAS Extract Table

Trading Partner Main Account Code

GTAS Extract Table

Budgetary Impact Indicator

GTAS Extract Table

Dollar Amount

GTAS Extract Table

 

FACTS I & II Windows, Processes, and Reports 

The following FACTS I and FACTS II related windows have been removed: 

The following FACTS I and II related concurrent processes have been removed:

 The following RXi Attribute sets have been decommissioned:

 

 Menu Options

Menu Items Removed

Menu Items Added

Menu Items Changed

From

To

Setup>Appropriation

Setup>Treasury

Setup>Appropriation>Trading Partner TAS/BETC Mapping

Setup>Treasury >Trading Partner TAS

Setup>Federal Report Definitions>Agency Location Code

Setup>Treasury > Agency Location Code

Setup>Federal Report Definitions>Define Reporting Codes

Setup>Treasury > Define Reporting Codes

Setup>Appropriation>Treasury Account Symbols

Setup>Treasury>Treasury Account Symbols

Setup>Appropriation>Budget Codes

Setup>Treasury>Budget Codes

Setup>Appropriation>Fund Attributes

Setup>Treasury>Fund Attributes

Setup>Appropriation>Rates

Setup>Treasury>Rates

Setup>Appropriation>Purge Treasury Symbols

Setup>Treasury>Purge Treasury Symbols

Setup>Appropriation>Business Event Type Codes (BETC)

Setup>Treasury> Business Event Type Codes (BETC)

Setup>Appropriation>TAS/BETC Mapping

Setup>Treasury> TAS/BETC Mapping

Setup>Appropriation>Trading Partner TAS/BETC Mapping

Setup>Treasury>Trading Partner TAS

 

GTAS Migration Process

The GTAS Migration process, submitted through the concurrent request window, results in the following migration of configuration data:

Authority Duration Code & Availability Type

Authority Duration Code and Availability Type defined on the Treasury Account Symbol window are migrated as follows based on Authority Duration Code, Availability Type, and Receipt Account Indicator values that existed prior to the patch:

Pre migration value

 

Post migration value

           

Authority Duration code

Availability Type

Receipt Account Indicator

 

Authority Duration Code

Availability Type

 

 

 

 

 

 

Any Value

Any Value

Checked

 

R: Receipt

Null/blank

A: Annual account

Blank

Unchecked

 

A: Annual

Null/blank

M: Multiyear account

Blank

Unchecked

 

M: Multi-year

Null/blank

X: No-year account

F: Clearing/ Suspense TAS

Unchecked

 

F: Clearing/ Suspense

F: Clearing/ Suspense TAS

X: No-year account

Is not F: Clearing/ Suspense TAS

Unchecked

 

X: No-year

X: No-year

 Fund Type

Fund Type values on the Define Treasury Accounts Symbols window are migrated as follows based on Main Account and Receipt Account Indicator values that existed prior to the patch:

Main Account Code

TAS Receipt Account Indicator (pre GTAS)

GTAS Fund Type

0000–3499 OR 3600-3799 and Availability Type is not 'F'

Unchecked

EG-General Fund

Checked

UG-Unavailable General Fund Receipt

5000–5999

Unchecked

ES-Special Fund

Checked

US: Unavailable Special Fund Receipt

4000–4499

N/A

EP - Public Enterprise Revolving Fund

4500–4999

N/A

ER-Intra-governmental Revolving Funds

3900–3959

N/A

EM- Management Fund

3960–3999

N/A

EC-Consolidated Working Fund

6000–6999

N/A

DF- Deposit Fund

8000–8399 and 8500–8999

Unchecked

ET: Trust Non-revolving Fund

Checked

UT-Trust Non-Revolving Fund Receipt

8400–8499

N/A

TR-Trust Revolving Fund

Availability Type is 'F'

N/A

CF- Clearing Account 

GTAS Reportable Indicator

The new GTAS Reportable Indicator checkbox on the Define Treasury Accounts Symbols window is checked if the old FACTS Reportable attribute was set to FACTS I and/or FACTS II reportable, otherwise, it is unchecked.

Outlay BEA Category Code

Migration of the Outlay BEA Category Code migrates with the same value populated in the BEA Category Code.

Apportionment Category Code

Apportionment Category Code values on the Define Fund Attributes window are migrated from a value of “C” to “E”.

Budget Codes

Budget Code records are deleted as part of GTAS Migration.  New Budget Codes will be entered manually. 

Reporting Codes

Data contained in the Reporting Code Mapping section of the Reporting Codes window are deleted as the lengths for these values have changed.   New values will have to be entered manually. 

 

Treasury Account Symbol Agency AID and ATA

The two-character Department ID and Department Transfer is migrated to a new three character GTAS Agency identifier (AID) and Allocation Transfer Agency identifier (ATA) on the Define Treasury Account Symbols window.  The migration uses the crosswalk data from the Treasury FMS Shared Accounting Module (SAM) located at: 

https://www.sam.fms.treas.gov/sampublic/tasbetc.htm

Existing combinations of Department Codes, Main Accounts, Transfer Department Codes, and Sub Accounts are used to derive the new Agency Identifiers and Allocation Transfer Agency Identifiers using the SAM crosswalk.  

If these four attributes values are not found on the SAM crosswalk for an existing Treasury Account Symbol, the Agency Identifier and Allocation Transfer Agency Identifier are not migrated from two to three characters and the migration process produces a report that lists the values for these four attributes.

Customer Trading Partner Agency Identifier DFF

The two-character Trading Partner DFF (Customer Trading Partner assigned on the Federal Parameters window) for each Customer Account record is migrated to a new three-character Trading Partner Agency Identifier DFF (GTAS Customer Trading Partner assigned on the Federal Parameters window).  Existing two-character Trading Partners on Customer Account records are matched to the Star Dept Reg on the SAM crosswalk.  If a match exists on the SAM crosswalk, the corresponding three-character SAM AID value is used to update the new three-character Trading Partner Agency Identifier DFF. 

Customer Accounts with a two-character Trading Partner DFF values of 48 or 95 are not updated with a three-character Trading Partner Agency Identifier DFF value as 48 and 95 each map to multiple three-character AIDs on the SAM crosswalk.  These Customer Accounts records are listed on the process output and will require manual update of the three-character Trading Partner Agency Identifier.

 Suppliers New Trading Partner Agency Identifier and Federal or Non-Federal code

The two-character Trading Partner DFF (Vendor Trading Partner assigned on the Federal Parameters window) on the Supplier record is migrated to a new three-character Trading Partner Agency Identifier attribute.  Existing two-character Trading Partners defined on Supplier records are matched to the Star Dept Reg on the SAM crosswalk.  If a match exists on the SAM crosswalk, the corresponding three-character SAM AID value is used to update the new three-character Trading Partner Agency Identifier attribute. 

Suppliers with a two-character Trading Partner values of 48 or 95 are not updated with a three-character Trading Partner Agency Identifier value as 48 and 95 each map to multiple three-character AIDs on the SAM crosswalk.  These Supplier records are listed on the process output and will require manual update of the three-character Trading Partner Agency Identifier.

 The Supplier Type is migrated to a new Federal or Non-Federal Code field as follows:

Supplier Type

Federal or

Non-Federal Code

Federal

F: Federal

All other Supplier Type values

N: Non Federal

Sample Output for the GTAS Migration Process

The following is a sample of output for the GTAS Migration Process.  The data is this report is test data and for illustrative purposes only.

 

GTAS Migrate Transactional Agency IDs Process

The GTAS Migrate Transactional Agency IDs Process, submitted through the concurrent process window, migrates two-character Trading Partner Department Codes to three character Trading Partner Agency IDs for Budget transactions and GL Journals.

Budget Transaction Trading Partner AID Migration

If the Trading Partner AID (Appropriation Direct transfer Information Agency ID) is other than 48 or 95, then the value of the existing 2 digit Trading Partner AID on the STAR Dept Reg field of the treasury SAM file located: https://www.sam.fms.treas.gov/sampublic/tasbetc.htm is used to lookup the corresponding 3 digit AID on the SAM file that will replace the existing 2 digit value.  The Main account remains unchanged.

If the Trading Partner AID (Appropriation Direct transfer Information Agency ID) is 48 or 95, then the value of the existing 2 digit Trading Partner AID in the STAR Dept Reg field and the Main Account in the STAR Main Acct field of the treasury SAM file located  https://www.sam.fms.treas.gov/sampublic/tasbetc.htm are used to lookup the corresponding 3 digit AID on the SAM file that will replace to existing 2 digit field (48 or 95).  The Main account will remain unchanged.

Budget transactions that do not meet the above criteria, and therefore, do not have a corresponding match on the SAM file will be reported on an exception report.  This report output lists Trading Partner AID, and Trading Partner MAIN combinations with no valid matches on the SAM file.  The following fields are displayed on the report: Document Number, Trading Partner AID, and Trading Partner MAIN.

GL Journal Trading Partner DFF Migration

If the DFF for the GL Journal Trading Partner AID/Main Account is 2 digits or 6 digits and the value of the 1st 2 digits is other than 48 or 95 then the existing first 2 digit (assumed Trading Partner AID) in the STAR Dept Reg field of the treasury SAM file located: https://www.sam.fms.treas.gov/sampublic/tasbetc.htm is used to lookup the corresponding 3 digit AID on the SAM file that will be used to replace the  existing 1st  2 digit of the field.  The remaining 4 digits, if in existence, will remain unchanged.  Note that the DFF will be either 3 digits or 7 digits after migration.

If the DFF value for the GL Journal Trading Partner AID/Main Account is 2 digits only and the value of the 2 digits is 48 or 95 then an exception is reported.

If the value of the DFF for the GL Journal Trading Partner AID/Main Account is 6 digits and the value of the 1st 2 digits is 48 or 95 then look up the value of the existing first 2 digit (assumed Trading Partner AID) in the STAR Dept Reg field and the remaining 4 digits (assumed Trading Partner Main Account) in the STAR Main Acct field of the treasury SAM file located: https://www.sam.fms.treas.gov/sampublic/tasbetc.htm are used to lookup the corresponding 3 digit AID on the SAM file that will replace to existing 1st  2 digit of the field.  The remaining 4 digits, if in existence, will remain unchanged.  Note that the DFF will be 7 digits after migration.

GL Journals that do not meet the above criteria and therefore do not have a corresponding match on the SAM file will be reported on an exception report.  This report output lists the Journals including the Journal Name, Journal Line, and GL Journal DFF (assumed Trading Partner AID and MAIN) values with no valid matches on the SAM file.


Migrate FACTS End Bal to GTAS End Bal Process

The Migrate FACTS End Bal to GTAS End Ball process will read all rows on the GTAS Federal Accounts Table and migrate corresponding account balances to the GTAS Ending Balances Table.   Balances will be migrated from the following sources as follows:

 The GTAS Balances Table needs to be populated to ensure GTAS has the correct beginning balances for the GTAS Interface Process.   Customers who do not already use EBS FACTS processes, will need to populate this table.

For each row on the GTAS Federal Accounts Table where the Federal or Non-Federal Code = ’Y”, the GTAS Ending Balances table (fv_gtas_ending_balances) must be populated at the following level of detail.

 

Column in Table

How to Populate

ACCOUNT_NUMBER

Populate with Natural Account value

D_C_INDICATOR

Populate with:

-          “D” for Debit Balance

-          “C” for Credit Balance 

AMOUNT  (-ve if credit)

Populate with  dollar amount balance summarized to the level of detail for the other attributes in this table.  Populate with negative amount if amount is credit.

SET_OF_BOOKS_ID

Populate with Set of Books ID

FISCAL_YEAR

Populate with “2012” for testing with Treasury 

Populate with “2013” when populating in production for use with Fiscal Year 2014 

FUND_VALUE

Populate with Fund (balancing segment)

CCID

Populate with CCID

AUTHORITY_TYPE_CODE

If the Authority Code for the GL Account on the Federal Accounts Table is “Y”, populate with the Authority Type Code value for the corresponding GL Account on that GTAS Attributes Table; otherwise, leave blank. 

FED_NON_FED

Populate with: 

“F “ – if the GTAS Attributes Table includes an “F” for the GL  Account and the Trading Partner is Federal

 “G” – the above condition is not met and  the GTAS Attributes Table includes only a  “G” for the GL Account and the Trading Partner is Federal

“N” – the above conditions are not met and the GTAS Attributes Table includes an “N” and the Trading Partner is Non-Federal 

BUDGET_IMPACT_IND

Blank

TRADING_PARTNER_AGENCY_ID

If FED_NON_FED = “G, populate with 099” 

If FED_NON_FED  = “F”,  populate with 3 character Trading Partner Agency ID   

If FED_NON_FED = “N”, leave blank 

TRADING_PARTNER_MAIN_ACCOUNT

If FED_NON_FED = “G”,  populate with “0000”

If FED_NON_FED = “F”,  populate with Trading Partner Main Account  (only required for GL accounts that currently require main account to be populated for FACTS II)

 If FED_NON_FED = “N”, leave blank 

END_BAL_IND

Populate with “Y” 

Year End Closing Process

The Authority Duration Code has been modified to make use of the new LOV values.  The Closing process now considers these new values when the process is executed.

Important GTAS Migration Manual Steps to be Performed by the User

All of the following steps need to be performed if the GTAS Phase I or Phase II patches were not previously applied.  If the Phase I GTAS patch was previously applied and the Phase I manual steps were performed, the only steps that need to be performed are the steps at the end of this section under Manual Steps Necessary for Phase III Migration.

Manual Steps Necessary if the Phase I II, or, III Patches were not Previously Applied 

Prior to applying the upgrade patch, the following steps should be performed: 

 

Manual Steps Necessary if the Phase II or Phase III patches were not previously applied

After the upgrade patch is applied, the following steps should be performed: 

It should be noted that the GTAS Migration process deletes all existing three character Reporting Codes


The following migrated data should be validated:

Window / Page

Attribute(s)

Validation

Define Treasury Account Symbols

 

Agency ID  and ATA 

Fund Type

 

 Authority Duration Code

 Availability Type

 

GTAS Reportable Indicator

Validate migration of Agency ID and ATA from two to three character

 Validate migration from old Fund Type values to new GTAS Fund Type values 

Validate migration from old Authority Duration Code values to new GTAS Authority Duration Code values 

Validate migration from old Availability Type values to new GTAS Availability Type

Validate the GTAS Reportable Indicator is check for all Treasury Account Symbols that were previously FACTS I and/or II Reportable 

Define Budget Codes

Budget Code records

Validate Budget Code have been deleted.

Define Fund Attributes

Apportionment Category Code

Validate migration of Apportionment Category Code values from “C” to “E”

Suppliers

Federal or Non-Federal Code

 Trading Partner Agency Identifier

Validate migration from Customer Classification to new Federal or Non Federal Code

 Validate migration from 2 character Trading Partner DFF value to new 3 character Trading Partner Agency Identifier value

Customer Account

Trading Partner Agency Identifier

Validate migration from 2 character Trading Partner DFF value to new 3 character Trading Partner Agency Identifier DFF value

Manual Steps Necessary for Phase III Migration (needed if Phase II was not applied)

After the upgrade patch is applied, the following steps should be performed:

Manual Steps Necessary for Phase IV

  • Run the GTAS Activity Balance Creation Process through the period for which GTAS balances will be created. This will make the Fiscal year available on the parameters for the GTAS Migrate AID from 2 to 3 Digits process.  
  • Run the GTAS Migrate AID from 2 to 3 Digits process to migrate transactional AID data.  The fiscal year entered will be the year for which the migration will occur.  This parameter is needed since customers testing with Treasury will use Fiscal Year 2013 and will use Fiscal Year 2014 for Production.

Post Migration Processes Required to Create the GTAS Bulk File

The following steps are necessary to create the GTAS Bulk File to be sent to Treasury.

 

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!


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