[Core Federal Financial System\
Software Qualification Test]{.smallcaps}

Oracle Report Sources

[November 14, 2023]{.smallcaps}

# Contents {#contents .H1-No-Number .unnumbered}

[Introduction 1](#introduction)

[Tested Reports 1](#tested-reports)

> [Table‑1. Oracle Qualification Test Report Sources
> 2](#__RefHeading___Toc52164238)

## Introduction

This document contains information about reports generated during Joint
Financial Management Improvement Program (JFMIP) qualification test of:

**Oracle E-Business Suite 11i, Version 11i.9**

JFMIP employs a formal qualification test to determine whether subject
financial management system (FMS) products comply with all published
requirements.

For more information about testing in general and other key JFMIP
programs, please log on to our web site (www.jfmip.gov) or contact Mr.
Stephen Balsam (stephen.balsam@gsa.gov).

## Tested Reports

During the test, a vendor is required to generate a number of reports.
These reports are subject to validation by JFMIP testers to assure their
form and content meet published mandatory requirements. Table 1 contains
a complete listing of the reports a vendor is required to produce. They
are categorized as follows:

-   Cycle End Reports

-   Financial Statements

-   Standard Reports

-   Cost Management Reports

-   Receivable Management Reports

-   FACTS Reports

    This table shows the test step and requirement used by JFMIP to
    specify each tested report. The report name used by JFMIP is
    cross-referenced in this table to the vendor's report name. Lastly,
    the tested package source module is indicated.

+-----------------------+----+----+---------+----------+-------------+
| []{#__Ref             |    |    |         |          |             |
| Heading___Toc52164238 |    |    |         |          |             |
| .anchor}Table‑1.      |    |    |         |          |             |
| Oracle Qualification  |    |    |         |          |             |
| Test Report Sources   |    |    |         |          |             |
+=======================+====+====+=========+==========+=============+
| Test Script Report    | Te | Rq | Vendor  | Vendor   | Vendor      |
| Name                  | st | mt | Report  | Identi   | Report      |
|                       | S  | s. | Name    | fication | Source      |
|                       | te | Te |         | Key      |             |
|                       | ps | st |         |          |             |
|                       |    | ed |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| **Cycle End Reports** |    |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Transaction Register  | RR | R  | RX      | RXFVFTXR | Oracle      |
|                       | 1- | C- | only:   |          | Federal     |
|                       | 24 | 05 | FACTS   |          | Financials  |
|                       | .1 |    | Tran    |          |             |
|                       |    |    | saction |          |             |
|                       |    |    | R       |          |             |
|                       |    |    | egister |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Summary Trial Balance | RR | R  | RX      | RXFVTBTS | Oracle      |
|                       | 1- | C- | only:   |          | Federal     |
|                       | 24 | 03 | Trial   |          | Financials  |
|                       | .1 |    | Balance |          |             |
|                       |    |    | by      |          |             |
|                       |    |    | T       |          |             |
|                       |    |    | reasury |          |             |
|                       |    |    | Symbol  |          |             |
+-----------------------+----+----+---------+----------+-------------+
| FACTS I Trial Balance | RR | R  | RX      | RXFVF1TB | Oracle      |
|                       | 1- | C- | only:   |          | Federal     |
|                       | 24 | 04 | FACTS I |          | Financials  |
|                       | .1 |    | Trial   |          |             |
|                       |    |    | Balance |          |             |
+-----------------------+----+----+---------+----------+-------------+
| FACTS II Trial        | RR | R  | RX      | RXFVFCTB | Oracle      |
| Balance               | 1- | C- | only:   |          | Federal     |
|                       | 24 | 04 | FACTS   |          | Financials  |
|                       | .1 |    | II      |          |             |
|                       |    |    | Trial   |          |             |
|                       |    |    | Balance |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Funds Availability    | RR | R  | Status  | FVFUNAVB | Oracle      |
| Report                | 1- | C- | of      |          | Federal     |
|                       | 24 | 02 | Funds   |          | Financials  |
|                       | .1 |    | Avail   |          |             |
|                       |    |    | ability |          |             |
|                       |    |    | Process |          |             |
+-----------------------+----+----+---------+----------+-------------+
| **Financial           |    |    |         |          |             |
| Statements**          |    |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Consolidated Balance  | R  | R  | Conso   | FVXCFSPB | Oracle      |
| Sheet                 | A1 | B- | lidated |          | Federal     |
|                       | .2 | 05 | Fi      |          | Financials  |
|                       |    |    | nancial |          |             |
|                       | R  |    | Sta     |          |             |
|                       | Q1 |    | tements |          |             |
|                       | .1 |    | Process |          |             |
|                       |    |    |         |          |             |
|                       | R  |    |         |          |             |
|                       | Q3 |    |         |          |             |
|                       | .1 |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Consolidated          | R  | R  | Conso   | FVXCFSPB | Oracle      |
| Statement of Net      | A1 | B- | lidated |          | Federal     |
| Costs                 | .3 | 05 | Fi      |          | Financials  |
|                       |    |    | nancial |          |             |
|                       | R  |    | Sta     |          |             |
|                       | Q1 |    | tements |          |             |
|                       | .2 |    | Process |          |             |
|                       |    |    |         |          |             |
|                       | R  |    |         |          |             |
|                       | Q3 |    |         |          |             |
|                       | .2 |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Combined Statement of | R  | R  | Conso   | FVXCFSPB | Oracle      |
| Budgetary Resources   | A1 | B- | lidated |          | Federal     |
|                       | .4 | 05 | Fi      |          | Financials  |
|                       |    |    | nancial |          |             |
|                       | R  |    | Sta     |          |             |
|                       | Q1 |    | tements |          |             |
|                       | .3 |    | Process |          |             |
|                       |    |    |         |          |             |
|                       | R  |    |         |          |             |
|                       | Q3 |    |         |          |             |
|                       | .3 |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Consolidated          | R  | R  | Conso   | FVXCFSPB | Oracle      |
| Statement of Changes  | A1 | B- | lidated |          | Federal     |
| in Net Position       | .6 | 05 | Fi      |          | Financials  |
|                       |    |    | nancial |          |             |
|                       |    |    | Sta     |          |             |
|                       |    |    | tements |          |             |
|                       |    |    | Process |          |             |
+-----------------------+----+----+---------+----------+-------------+
| **Standard Reports**  |    |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| SF-132, Apportionment | A  | CF | SF132   | FVSF132R | Oracle      |
| and Reapportionment   | L1 | A- | Apport  |          | Federal     |
| Schedule              | .1 | 05 | ionment |          | Financials  |
|                       |    |    | and     |          |             |
|                       | A  | FM | R       |          |             |
|                       | L1 | C- | eapport |          |             |
|                       | .8 | 01 | ionment |          |             |
|                       |    |    | S       |          |             |
|                       |    | FM | chedule |          |             |
|                       |    | C- |         |          |             |
|                       |    | 06 |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| SF-133, Report on     | R  | R  | SF133   | FV133NYB | Oracle      |
| Budget Execution and  | A1 | B- | M       |          | Federal     |
| Budgetary Resources   | .1 | 03 | ultiple | FVSF133B | Financials  |
|                       |    |    | Year/   |          |             |
|                       | R  |    | No Year |          | Oracle      |
|                       | Q2 |    | Report  |          | Federal     |
|                       | .3 |    |         |          | Financials  |
|                       |    |    | SF133   |          |             |
|                       |    |    | One     |          |             |
|                       |    |    | Year    |          |             |
|                       |    |    | Report  |          |             |
+-----------------------+----+----+---------+----------+-------------+
| FMS-224, Statement of | RR |    | FMS     | FVSF224P | Oracle      |
| Transactions          | 5. |    | Form    |          | Federal     |
|                       | 1, |    | 224     |          | Financials  |
|                       | RR |    | Process |          |             |
|                       | 22 |    |         |          |             |
|                       | .1 |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| FMS-224 Supporting    | R  | R  | FMS     | FVSF224P | Oracle      |
| Detail Report         | R5 | C- | Form    |          | Federal     |
|                       | .2 | 01 | 224     |          | Financials  |
|                       |    |    | Process |          |             |
|                       | RR |    |         |          |             |
|                       | 22 |    |         |          |             |
|                       | .2 |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| SF-1081               | RO | RM | SF 1081 | FVX1081L | Oracle      |
|                       | 1. | B- | Process |          | Federal     |
|                       | 12 | 09 |         |          | Financials  |
+-----------------------+----+----+---------+----------+-------------+
| IRS-1099 MISC         | P  | P  | 1099    | APTCMT   | Oracle      |
|                       | E4 | MA | Ele     |          | Payables    |
|                       | .8 | -0 | ctronic | APXTRF99 |             |
|                       |    | 2, | Media   |          | Oracle      |
|                       |    | PM |         | APXTRRVT | Payables    |
|                       |    | D- | 1099    |          |             |
|                       |    | 09 | Forms   |          | Oracle      |
|                       |    |    |         |          | Payables    |
|                       |    |    | 1099    |          |             |
|                       |    |    | Payment |          |             |
|                       |    |    | Reports |          |             |
+-----------------------+----+----+---------+----------+-------------+
| IRS-1099C             | P  | R  | 1099-C  | FVR1099T | Oracle      |
|                       | E4 | MC | Ele     |          | Federal     |
|                       | .8 | -1 | ctronic | FVR1099R | Financials  |
|                       |    | 9, | Filing  |          |             |
|                       |    | PM |         |          | Oracle      |
|                       |    | C- | 1099-C  |          | Federal     |
|                       |    | 09 | Pre     |          | Financials  |
|                       |    |    | printed |          |             |
|                       |    |    | Form    |          |             |
|                       |    |    | Report  |          |             |
+-----------------------+----+----+---------+----------+-------------+
| **Cost Management     |    |    |         |          |             |
| Reports**             |    |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Income Statements     | C  | CM | Fi      | None     | Oracle      |
|                       | M2 | C- | nancial |          | General     |
|                       | .2 | 01 | Sta     |          | Ledger      |
|                       |    |    | tements |          |             |
|                       | C  |    | Ge      |          |             |
|                       | M3 |    | nerator |          |             |
|                       | .2 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | C  |    |         |          |             |
|                       | M3 |    |         |          |             |
|                       | .3 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | C  |    |         |          |             |
|                       | M3 |    |         |          |             |
|                       | .5 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | C  |    |         |          |             |
|                       | M3 |    |         |          |             |
|                       | .6 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | C  |    |         |          |             |
|                       | M3 |    |         |          |             |
|                       | .8 |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Fee Justification     | C  | CM | Fi      | None     | Oracle      |
| Report                | M3 | C- | nancial |          | General     |
|                       | .4 | 03 | Sta     |          | Ledger      |
|                       |    |    | tements |          |             |
|                       |    |    | Ge      |          |             |
|                       |    |    | nerator |          |             |
+-----------------------+----+----+---------+----------+-------------+
| **Receivable          |    |    |         |          |             |
| Management Reports**  |    |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Customer Account      | R  | RM | C       |          | Oracle      |
| Statements            | P1 | B- | ustomer |          | Discoverer  |
|                       | .2 | 14 | St      |          |             |
|                       |    |    | atement |          |             |
|                       | R  |    |         |          |             |
|                       | P2 |    |         |          |             |
|                       | .2 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | R  |    |         |          |             |
|                       | P3 |    |         |          |             |
|                       | .3 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | R  |    |         |          |             |
|                       | P3 |    |         |          |             |
|                       | .5 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | R  |    |         |          |             |
|                       | P9 |    |         |          |             |
|                       | .1 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | RP |    |         |          |             |
|                       | 11 |    |         |          |             |
|                       | .1 |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Aging Reports         | R  | RM | Rece    |          | Oracle      |
|                       | P3 | C- | ivables |          | Discoverer  |
|                       | .2 | 08 | due by  |          |             |
|                       |    |    | Fund    |          |             |
|                       | R  |    | and     |          |             |
|                       | P4 |    | C       |          |             |
|                       | .2 |    | ustomer |          |             |
|                       |    |    |         |          |             |
|                       | R  |    |         |          |             |
|                       | P5 |    |         |          |             |
|                       | .2 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | R  |    |         |          |             |
|                       | P6 |    |         |          |             |
|                       | .2 |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Billings              | R  | RM | Invoice | RA       | Oracle      |
|                       | P1 | B- | Print   | XINV_NEW | Receivables |
|                       | .1 | 09 | New     |          |             |
|                       |    |    | I       |          |             |
|                       | R  |    | nvoices |          |             |
|                       | P2 |    |         |          |             |
|                       | .1 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | R  |    |         |          |             |
|                       | P3 |    |         |          |             |
|                       | .1 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | R  |    |         |          |             |
|                       | P4 |    |         |          |             |
|                       | .1 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | R  |    |         |          |             |
|                       | P5 |    |         |          |             |
|                       | .1 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | R  |    |         |          |             |
|                       | P6 |    |         |          |             |
|                       | .1 |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Dunning Letters       | R  | RM | Dunning | ARDLGP   | Oracle      |
|                       | P1 | C- | Letter  |          | Receivables |
|                       | .3 | 06 | G       |          |             |
|                       |    |    | enerate |          |             |
|                       | R  |    |         |          |             |
|                       | P2 |    |         |          |             |
|                       | .3 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | R  |    |         |          |             |
|                       | P3 |    |         |          |             |
|                       | .4 |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Referral File         | R  | RM | Del     | FVXFDDIR | Oracle      |
|                       | D3 | C- | inquent |          | Federal     |
|                       | .4 | 12 | Invoice | FVXFDDIE | Financials  |
|                       |    |    | R       |          |             |
|                       |    |    | eferral |          | Oracle      |
|                       |    |    | Process |          | Federal     |
|                       |    |    |         |          | Financials  |
|                       |    |    | Del     |          |             |
|                       |    |    | inquent |          |             |
|                       |    |    | Invoice |          |             |
|                       |    |    | R       |          |             |
|                       |    |    | eferral |          |             |
|                       |    |    | Ele     |          |             |
|                       |    |    | ctronic |          |             |
|                       |    |    | File    |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Report on Receivables | R  | RM | Rece    |          | Oracle      |
|                       | P9 | C- | ivables |          | Discoverer  |
|                       | .2 | 15 | Due by  |          |             |
|                       |    |    | Fund    |          |             |
|                       |    |    | and     |          |             |
|                       |    |    | C       |          |             |
|                       |    |    | ustomer |          |             |
+-----------------------+----+----+---------+----------+-------------+
| **FACTS Reports**     |    |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Electronic files      | G  | R  | FACTS I | FVTIFACT | Oracle      |
|                       | 14 | B- | In      |          | Federal     |
|                       | .1 | 02 | terface | FVFC2SUB | Financials  |
|                       |    |    |         |          |             |
|                       | G  |    | FACTS   |          | Oracle      |
|                       | 14 |    | II      |          | Federal     |
|                       | .2 |    | Sub     |          | Financials  |
|                       |    |    | mission |          |             |
+-----------------------+----+----+---------+----------+-------------+
| Validation edits      | G  | R  | FACTS I | FVTIFACT | Oracle      |
|                       | 22 | B- | In      |          | Federal     |
|                       | .5 | 04 | terface | FVFC2SUB | Financials  |
|                       | G  |    |         |          |             |
|                       | 22 |    | FACTS   |          | Oracle      |
|                       | .7 |    | II      |          | Federal     |
|                       |    |    | Sub     |          | Financials  |
|                       | G  |    | mission |          |             |
|                       | 23 |    |         |          |             |
|                       | .1 |    |         |          |             |
|                       |    |    |         |          |             |
|                       | G  |    |         |          |             |
|                       | 23 |    |         |          |             |
|                       | .3 |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
|                       |    |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+
|                       |    |    |         |          |             |
+-----------------------+----+----+---------+----------+-------------+