Processing and Generating the Object and Program Report

This topic discusses processing used to generate the Federal Object Class and Program Code Interface report.

Page Name

Definition Name

Usage

Federal Object Class and Program Code Interface Page

FOMB_RUNCNTL

Run processes that extract data to the staging table, create the output bulk file, and generate a report of data from the staging table.

Federal Object Class and Program Code Interface processing does the following:

  1. Selects and accumulates data from the ledger.

  2. Associates the data with attributes.

  3. Loads the data to a staging table.

  4. Creates the bulk file.

  5. Generates a report with data from the staging table.

You can review information in the bulk file or in the report. It is important to review the report before submitting the file to Treasury.

The PSJob FOMBRUN automatically runs three processes separately and in the order displayed in this table. You can run the job only, not the individual processes.

Order

Process Description

Process Name

Process Type

Output Format

1

Data Extraction

FOMB_EXTRACT

Application Engine

Data

2

Bulk File Creation

FOMB_BULK_FL

Application Engine

TXT

3

Report

FOMBRPT

BI Publisher

PDF

Use the Federal Object Class and Program Code Interface run control page (FOMB_RUNCNTL) to run processes that extract data to the staging table, create the output bulk file, and generate the report.

Navigation:

General Ledger > Federal Reports > Obj Class Program Code Intfc > Definition > Federal Object Class and Program Code Interface

This example illustrates the fields and controls on the Federal Object Class and Program Code Interface run control page. You can find definitions for the fields and controls later on this page.

 Federal Object Class and Program Code Interface page

Field or Control

Description

Business Unit (GL Business Unit)

Select the GL Business Unit for which to run the interface.

Report ID

Select a free-form Report ID to identify the dataset for the program run.

Note: Using Report ID enables data from previous reporting to be saved in the staging tables.

Fiscal Year

Enter the fiscal year for which to select data.

From Period/To Period

Enter the accounting periods to select data in the fiscal year entered. The From Period field value is always 1.

Report Type

Select to run the process for:

  • Object Class – Selects ledger data by Object Class only.

  • Program – Selects ledger data by Program Code only.

  • Both – Select ledger data by both Object Class and Program Code.

Tree Group

Select the Tree Group for attributes and tree derivation.

See Setting Up Trees for the Object and Program Report.

File Name

Enter the name for the bulk file. You must use a .txt file extension. Do not enter a path.

Adjustment Period

Select adjustment period(s) to be included as part of the ending balance.

TAS

Select the TAS that is associated with the funds being reported. This is a required field.