The Office of Management and Budget (OMB) requires agencies to submit an Object Class and Program Activity bulk file. This file is as a result of the Data Accountability and Transparency Act (DATA Act) to report summary obligation and outlays by program activity and object class.
As specified by OMB, agencies are required to submit an Object Class and Program Activity bulk file to them on a periodic basis.
Oracle Financials RXi Reports Administration Tool, Oracle Financials RXi Reports Administration Tool User Guide
Ensure the Object Class and Program Activity checkbox is selected for applicable US SGL Account on the US SGL Accounts form.
Ensure appropriation Object and Program Activity mapping is done on the Report Codes form.
Note: Accounting Flexfield ranges are available for use with Object Class and Program Activity when the “Use reporting code mapping” checkbox is selected. The header “Fund” and “Segment” values will not be available as they are entered in the Flexfield portion of the mapping.
To generate the Trial Balance by Treasury Account Symbol report:
Navigate to the Submit Request window.
In the Name field, select Object Class and Program Activity process.
In the Ledger field, select Ledger.
In the To Period, select the reporting period. (the Beginning Balance will be for the beginning of the Fiscal Year given the Reporting Period parameter provided.)
In the Report Type select Object Class and Program Activity (default), Object Class or Program Activity.
Select generate reports Yes to generate reports and bulk file, or No for exception and review without generation of the bulk file.
The process extracts General Ledger Summary data that meets all of the following criteria:
The Natural Account has a Parent Account that matches an account defined on the Define USSGL Account form with the Object Class Program Activity Reporting checkbox selected.
The General Ledger record meets the filtering criteria for the parameter provided for the process.
The Fund Type for the fund is not “DF” (Deposit Funds).
The Treasury Account Symbol for the fund has the GTAS Reportable Indicator selected.
The Treasury Account Symbol for Fund Segment is an unexpired account. This includes Treasury Account Symbols that meet at least one of the following:
Authority Duration Code = X or R
Authority Duration Code = A or M, and Ending Period of Availability is less than or equal to the Fiscal Year submission parameter
An extract file created summarizes data to the following level of detail:
Fiscal Year
Reporting Period
Allocation Transfer Agency Identifier
Agency Identifier
Beginning Period of Availability
Ending Period of Availability
Availability Type Indicator
Main Account Code
Sub Account Code
USSGL Account Number Code
Begin End Indicator
Reimbursable Indicator
Object Class Code
Program Reporting Code
The above is also the order in which the data in the bulk file is sorted.
The Object Class and Program Activity Bulk File Creation process performs validations after balances have been summarized to Object Class and Program Activity Bulk File level of detail. The following exceptions messages are generated as appropriate:
Account has multiple parents defined.
An Object Class Code is required but is not but is not configured on the Reporting Codes form.
Program Activity is required but is not but is not configured on the Reporting Codes form.
More than one Object Class Code is derived based on the configuration on the Reporting Codes form.
More than one Program Activity is derived based on the configuration on the Reporting Codes form.