Oracle U.S. Federal Financials User Guide

Skip Headers

Title and Copyright Information

Send Us Your Comments

Preface

Product Overview

Overview

Oracle Public Sector Financials Modules in Oracle U.S. Federal Financials Diagram

Oracle U.S. Federal General Ledger Features Diagram

Oracle U.S. Federal General Ledger Features

Budget Execution

Funds Available

Year-End Closing

General Ledger Federal Reports

Oracle U.S. Federal Purchasing Features Diagram

Oracle U.S. Federal Purchasing Features

Accounting Using Oracle Subledger Accounting

Document Cross-referencing

Prior Period Receipts

Purchasing Federal Reports

Oracle U.S. Federal Payables Features Diagram

Oracle U.S. Federal Payables Features

Central Contractor Registration (CCR)

Suppliers Deactivation Report

Prompt Payment

IPAC Disbursement

Third Party Payments

Treasury Payments

Treasury Confirmation

Document Cross-referencing

Accounting Using Oracle Subledger Accounting

Cash Position Detail Report

Payables Federal Reports

Oracle U.S. Federal Receivables Features Diagram

Oracle U.S. Federal Receivables Features

Receivables Management

Interagency Transactions

Accounting Using Oracle Subledger Accounting

Receivables Federal Reports

Accounting Using Oracle Subledger Accounting

Overview

Accounting Event Model Overview

Budget Execution

Overview

Budget Execution Transactions

Overview

Budget Execution Open Interface

Overview

Budget Execution Approval Workflow Process

Overview

Prerequisites

Budget Execution Approval Item Type

Budget Execution Approval Workflow Diagram

Budget Execution Approval Workflow Process

Start (Node 1)

Verify Document Status (Node 2)

Document Failed Status Check (Node 3)

End (Document Invalid Status) (Node 4)

Is RPR To Document ID Provided? (Node 5)

Get RPR Details (Node 6)

Approve Document (Node 7)

Document Rejected (Node 8)

End (Document Rejected) (Node 9)

Approve Document: Reminder 1 (Node 10)

Reserve and Approve Document (Node 11)

Unable to Reserve Document (Node 12)

End (Document Not Reserved) (Node 13)

Approve Document: Reminder 2 (Node 14)

Document Approved and Reserved (Node 15)

End (Node 16)

Timeout: Document Not Approved (Node 17)

End (Document Not Approved) (Node 18)

Customizing Budget Execution Approval Workflow

Required Modifications

Supported and Unsupported Customizations

Creating a New Custom Process

Workflow Troubleshooting

Attachments in Oracle U.S. Federal Financials

Budget Execution Transaction Summary Procedures

Overview

Viewing Budget Transaction Summary

Budget Execution Report

Overview

Generating the Budget Execution Transaction Register Report

Budget Execution Transaction Register Report

Generating the Budget Execution Transaction Register by Treasury Symbol Report

Budget Execution Transaction Register by Treasury Symbol Report Description

Budgetary Control Results Report

Budgetary Control Results Report

Treasury Symbol Listing Report

Overview

Prompt Payment

Overview

U.S. Federal Payables Processing Cycle Diagram

U.S. Federal Payables Processing Cycle Diagram Description

Due Date Calculation Process

Economically Beneficial Discount Process

Reason Code Process

Prompt Payment Process

Prompt Payment Process Overview

Prerequisites

Calculating the Due Date

Economically Beneficial Discount

Recording Invoice Returns

Recording Prior Period Receipts

Assigning Reason Codes

Prompt Payment Report Procedures

Overview

Prompt Payment Due Date Report

Prompt Payment Due Date Report Description

Generating the Prompt Payment Report

Prompt Payment Report Description

Prompt Payment Exception Report

Prompt Payment Exception Report Description

Payments Without Reason Codes Report

Payments Without Reason Codes Report Description

Cash Position Detail Report

Cash Position Detail Report

Prerequisites

Generating the Cash Position Detail Report

Cash Position Detail Report Description

SF 1166 Voucher and Schedule of Payments

Overview

Prerequisites

Generating the SF 1166 Voucher and Schedule of Payments

Payment Instruction Treasury Symbol Listing Report

Payment Instruction Treasury Symbol Listing Report

Summary Schedules

Summary Schedules

Generating Summary Schedules

Treasury Confirmation

Overview

Prerequisites

Treasury Confirmation and Reconciliation

Viewing Treasury Confirmation

Refunds

Overview of Refunds

Historical Third Party Report

Historical Third Party Report

Prerequisites

Generating Historical Third Party Remittance Report

Historical Third Party Remittance Report Description

Interagency Transaction Processes

Interagency Transaction Processes Overview

Setup and Processing Considerations for the SF 1081

Interagency Billing and Payment for SF 1080 Transactions Diagram

Interagency Billing and Payment for SF 1081 Transactions Diagram

Interagency Billing and Payment for IPAC Transactions Diagram

IPAC Bulk File and Automatic Receipt Creation Process Diagram

IPAC Disbursement Process Diagram

Interagency Transactions Processes

References

Interagency Transaction Procedures

Overview of Interagency Transaction

Prerequisites

Generating the SF 1080 Voucher for Transfers Between Appropriations and/or Funds

SF 1080 Voucher for Transfers Between Appropriations and/or Funds Document Description Table

Generating SF 1081 Voucher and Schedule of Withdrawals and Credits

SF 1081 Voucher and Schedule of Withdrawals and Credits Document Description Table

Initiating the IPAC Transaction Selection

Viewing and Excluding IPAC Transactions

IPAC Transaction Detail Report Description

IPAC Exception Report Description

Generating the IPAC Bulk File

IPAC Bulk File Format

IPAC Bulk File Format Description

IPAC Bulk File Exception Report

Generating the Upload IPAC Disbursement

IPAC Disbursement Exception Report Description

Invoice Approval and Payment Output Report

Entering Interagency Transfers

Receivables Management Process

Receivables Management Process

Federal Requirements

U.S. Federal Receivables and Debt Collection Processing Cycle Diagram

U.S. Federal Receivables and Debt Collection Processing Cycle Diagram Description

U.S. Federal Receivables - 1099-C Cancellation of Debt Diagram

U.S. Federal Receivables - 1099-C Cancellation of Debt Diagram Description

Finance Charges Process

Delinquent Invoice Referral Process

Cash Receipts Process

1099-C Cancellation of Debt Process

References

Receivables Management Procedures

Receivables Management Procedures

Prerequisites

Assigning Finance Charges

Waiving Finance Charges

Accruing Finance Charges Report

Writing Off Invoices

Applying Cash Receipts

Generating the Lockbox Finance Charge Application

Finance Charges Inquiry

Generating the 1099-C Setup

Maintaining 1099-C Information

Assigning an Invoice Status

Receivables Management Report Procedures

Receivables Management Report Procedures

Reimbursable Agreement Billing and Reporting

Prerequisites

Reimbursable Activity Report

Generate Receivables Reimbursable Related Expenditures

FMS Form 224 Statement of Transactions Process

Overview of FMS Form 224 Statement of Transactions

FMS Form 224 Statement of Transactions Report Procedures

Overview of the FMS Form 224 Statement of Transactions Report

FMS Form 1219/1220

Overview

FMS Form 1219/1220 Process Diagram

Using FMS Form 1219/1220

Using the FMS Form 1219/1220 Process and Report

FMS Forms 1219/1220 Process and Report

FMS Form 1219/1220 Process

Updating FMS Form 1219/1220

FMS Form 1219/1220 Report

FMS Form 1219/1220 Exception Report

FACTS I Process

FACTS I Process

FACTS I Process Steps Diagram

FACTS I Process Steps

FACTS I Procedures

FACTS I Procedures

FACTS I Required Files

FACTS I Federal Accounts Creation Process

FACTS I Customer Class Code Update Process

FACTS I Vendor Type Update Process

FACTS I Journal Creation Process

FACTS I Interface Process

Generating FACTS Interface Process

Prerequisites

FACTS I Exception Report Description

FACTS I Edit Check Process

FACTS I Detail Report Description

FACTS I Adjusted Trial Balance Bulk File Transfer Format

FACTS I Trial Balance Report

FACTS I Trial Balance Report

FACTS II Process

FACTS II Process

FACTS II Process Steps Diagram

FACTS II Process Steps

Facts II Ending Balance Detail Process

FACTS II Processing

Generating the FACTS II Bulk File

FACTS II Edit Check Report

FACTS II Exception Report

FACTS II Adjusted Trial Balance Report Procedure

FACTS II Bulk File Layout

FACTS II Report Procedures

Overview

Generating the FACTS II Trial Balance Report Procedure

FACTS Transaction Register

FACTS Transaction Register

SF 133 Report on Budget Execution Process

Overview of the SF 133 Report on Budget Execution Process

SF 133 Report on Budget Execution Diagram

SF 133 Report on Budget Execution

SF 133 Report on Budget Execution Procedures

Overview

Prerequisites

Generating the SF 133 Report on Budget Execution

GOALS Procedures

Definition of GOALS

Prerequisites

Generating the FMS Form 224 Statement of Transactions for Goals

Generating the FMS Form 1219/1220 for Goals

Summary Trial Balance Report Procedures

Overview

Prerequisites

Generating the Trial Balance by Treasury Symbol Report

Trial Balance by Treasury Symbol Report Description Table for the Default Attribute Set

Financial Statements Process

Financial Statements Process

Financial Statements

References

Financial Statements Procedures

Financial Statements Procedures

Prerequisites

Generating Financial Statements

SF 132 Apportionment Reapportionment Schedule Procedures

Overview

Entering the SF 132 Apportionment and Reapportionment Schedule

Generating the SF 132 Apportionment and Reapportionment Schedule Report

Funds Available Procedures

Overview

Prerequisites

Viewing Funds Available

Funds Availability Reports Procedures

Overview

Prerequisites

Generating the Funds Availability Reports

Funds Available - Total Resources Report Description

Funds Available - Funding Distributions Report Description

Funds Available - Spending Activity Report Description

Funds Available - Available Balances Report Description

Status of Obligations Report Procedures

Overview

Prerequisites

Generating the Status of Obligations Report

Status of Obligations Report Description

Form 1099-INT and Form 1099-G Procedures

Overview

Prerequisites

Generating Form 1099-G or Form 1099-INT

Generating Form 1096 for 1099-G or 1099-INT

Generating the Electronic Media 1099-INT or 1099-G

Document Cross-referencing Procedures

Overview

Viewing Documents

Central Contractor Registration (CCR)

Overview

CCR Process Flow, First Time Use Diagram

CCR Process Flow Daily Updates Diagram

Central Contract Registration

CCR XML Process Diagram

CCR XML

Central Contractor Registration (CCR) Procedures

Overview

Prerequisites

Importing the CCR Extract File

Generating the CCR XML

CCR Vendor Assignment

Supplier Tax Identification Number Listing Report

Overview

Prerequisites

Generating the Supplier Tax Identification Number Listing

Suppliers Deactivation Report Procedures

Overview

Suppliers Deactivation Report Description

Year-End Closing Process

Year-End Closing Process

Year-End Close Scenarios

Year-End Closing Procedures

Year-End Closing Procedures

Prerequisites

Generating the Year-End Closing Process

Year-End Closing Execution Report

Generating the Carry Forward Budgetary Account Balances Process

Prior Year Adjustment Transaction History

Overview

Viewing the PYA Transaction History Report Procedure

Generating the PYA Transaction History Report

Budget Execution Open Interface Tables

Understanding the Budget Execution Open Interface Tables

NOT NULL Columns

NULL Columns

Optional Columns

Budget Execution Open Interface Table Descriptions

FV_BE_INTERFACE_CONTROL

FV_BE_INTERFACE

Oracle U.S. Federal Financials Navigation Paths

Navigation

Glossary

Index

Oracle U.S. Federal Financials User Guide

Contents