Oracle U.S. Federal Financials User Guide

Contents

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 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
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