Oracle U.S. Federal Financials User Guide

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 Account Symbol Report

Budget Execution Transaction Register by Treasury Account Symbol Report Description

Budgetary Control Results Report

Overview

Federal Attributes (FAs)

Federal Specific Attributes for Suppliers and Customers

Federal Specific Attributes for Purchase Order and Release Forms

Federal Specific Attributes for PO Standard Purchase Order OAF Page

Federal Specific Attributes for AP Payables Invoices Workbench

Federal Specific Attributes for GL Journals Form

Federal Specific Attributes for AR Receivable Transactions

Federal Specific Attributes for AR Receivable Adjustments

Federal Specific Attributes for Miscellaneous Receipts

Federal Specific Attributes for PJ Project Agreements

PO Purchase Order API

Federal Specific FAs for AR Receivable Transaction API

AR Adjustment API

AR Miscellaneous Receipts API

IPAC Receivables Selection

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

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

Overview

Prerequisites

Generating the Cash Position Detail Report

Cash Position Detail Report Description

SPS and PAM Payment Process

Overview

Payment Information Repository (PIR)

Overview

Summary Schedules

Overview

Generating Summary Schedules

Treasury Confirmation

Overview

Journal Entry Creation

Prerequisites

Treasury Confirmation and Reconciliation

Viewing Treasury Confirmation

Refunds

Overview

Historical Third Party Report

Overview

Prerequisites

Generating Historical Third Party Remittance Report

Historical Third Party Remittance Report Description

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 Creation, IPAC Bulk File Reversal and IPAC Receipt Creation Process Diagram

IPAC Disbursement Process Diagram

Interagency Transactions Processes

References

Interagency Transaction Procedures

Overview

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

Viewing and Excluding IPAC Transactions

IPAC Receivable Detail Report Description

IPAC Receivable Exception Report Description

Generating the IPAC Bulk File

IPAC Bulk File Format

IPAC Bulk File Format Description

IPAC Bulk File Receipt Exception Report

IPAC Bulk File Cancel

Generating the Upload IPAC Disbursement

IPAC Import Payment Exception Report Description

Invoice Approval and Payment Output Report

Entering Interagency Transfers

Receivables Management Process

Overview

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

Overview

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

Overview

Reimbursable Agreement Billing and Reporting

Prerequisites

Reimbursable Activity Report

Generate Receivables Reimbursable Related Expenditures

FMS Form 224 Statement of Transactions Process

Overview

FMS Form 224 Statement of Transactions Report Procedures

Overview

Classification Transactions and Accountability (CTA) Process

Overview

CTA Reporting Requirements

CTA Submission Requirements

CTA Reporting Diagram

CTA Transactions Process Diagram Description

CTA Process

Classification Transactions and Accountability (CTA) Bulk File Procedures

Overview

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

Overview

FMS Form 1219/1220 Process

Updating FMS Form 1219/1220

FMS Form 1219/1220 Report

FMS Form 1219/1220 Exception Report

Federal File Creation Functionality

Overview

Federal File Creation Process Steps Diagram

Federal Attributes Setup

GTAS Attributes Table Setup Concurrent Process

Federal Accounts Creation

Federal Activity Attributes Creation

Federal File Creation Process

Accounts not Eligible for GTAS Report

GTAS Interface Validation Exception Report

GTAS Interface Edit Exception Report

GTAS Bulk File Interface Report

GTAS Bulk File

GTAS Ending BalancesTable

GTAS Trial Balances

GTAS Transaction Register

Object Class and Program Activity Procedures

Overview

Summary Trial Balance Report Procedures

Overview

Prerequisites

Generating the Trial Balance by Treasury Account Symbol Report

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

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

System for Award Management (SAM)

Overview

SAM Process Flow, First Time Use Diagram

SAM Process Flow Daily Updates Diagram

System for Award Management

System for Award Management (SAM) Procedures

Overview

Prerequisites

Importing the SAM Extract File

SAM 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

Overview

Features of Year-End Closing Process

Year-End Close Scenarios

Year-End Closing Procedures

Overview

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

Rollover Treasury Account Symbols Process

Overview

Records Created by Rollover Treasury Account Symbols Process

Managing the Rollover Treasury Account Symbols Process

Customer Account and Supplier Site Default TP TAS Rollover

Customer Account /Supplier Site Rollover Reports

Customer Account and Supplier Site Default TP TAS Rollover

Customer Account /Supplier Site Rollover Reports

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