Skip Headers

Oracle U.S. Federal Financials User Guide
Release 12.1
Part Number E13551-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Treasury Confirmation

Overview

Department of Treasury payments are recorded and confirmed in the Treasury Confirmation and Reconciliation window. You can find and view confirmed Department of Treasury payments in the Treasury Confirmation Inquiry window.

Treasury Confirmation and Reconciliation Window

You can use the Treasury Confirmation and Reconciliation window to complete these tasks:

Treasury Confirmation Inquiry

You can use the Treasury Confirmation Inquiry window to view this information:

Treasury Confirmation Process

The treasury confirmation process includes these steps:

  1. The agency enters and confirms the payment process request in Oracle Payables.

  2. The agency sends the payment file to Treasury for payment.

  3. Treasury sends back the Agency Confirmation report.

  4. The agency navigates to the Treasury Confirmation and Reconciliation window and enters the Accomplish Date, Amount, and the Treasury Check Information.

    If there is only one check range, the agency selects Single as the Range Type. The From and To fields are then required. If there are multiple check ranges, the agency selects Multiple as the Range Type and the agency enters at least two ranges in the Check Ranges window.

  5. If an offset occurs, the agency clicks Offset to enter Offset information from Treasury before confirming the payment.

  6. The agency clicks Confirm in the Treasury Confirmation and Reconciliation window.

    Journal entries are created if Disbursement in Transit in the Define Federal Options window is selected. The exchange rate and date used when creating the Treasury Confirmation journal is taken from the currency rate information defined on the payment process request.

Check Range Examples

Example 1: The Agency Confirmation Report contains an offset.

In this scenario, the offset payment check number is outside of the check range provided by Treasury, and the remaining check numbers are not resequenced.

The payment process request has 8 payments. The payment process request has payment numbers 2202 to 2209. The payment range assigned by Treasury for this payment file is 7 - 14. An offset occurs. Treasury number 74 is assigned to the fifth payment or the original Treasury number 11. This example could be entered in these ways.

A.

Perform these steps:

  1. Enter Single as the Range Type.

  2. Enter 7 in the From field and 14 in the To field.

  3. Place the cursor on the fifth payment, Treasury Check No. 11, in the Invoice Payment Details region.

  4. Click Offset.

  5. Enter the Corrected Treasury Check No. as 74.

    Gap is now selected for this record in the Invoice Payment Details region and Check Sequence Gap is selected.

B.

  1. In the Treasury Confirmation and Reconciliation window, click Check Ranges.

  2. Enter sequences as described in the following table:

Example 1B, Agency Confirmation Report Containing an Offset
Range Sequence From To
1 7 10
2 74 74
3 12 14

In both A and B, the Treasury check numbers would be assigned as described in the following table:

Example 1B, Treasury Check Number Assignments
Treasury Check Number Payables Check Number
7 2202
8 2203
9 2204
10 2205
74 2206
12 2207
13 2208
14 2209

Example 2: The agency Confirmation report contains an offset.

In this scenario, the offset check number is outside of the check range provided by Treasury, and the remaining check numbers are resequenced.

The payment process request has eight payments. The payment process request has payment numbers 2202 to 2209. The payment range assigned by Treasury for this payment file is 7 - 10 for the first four payments. The fifth payment is assigned treasury number 74, and the last three payments are assigned the range 11 - 13. This should be entered as:.

Complete the following steps:

  1. Enter Multiple as the Range Type.

  2. Click Check Ranges.

  3. Enter sequences as described in the following table:

    Example 2, Agency Confirmation Report Containing an Offset
    Range Sequence From To
    1 7 10
    2 74 74
    3 11 13

    The Treasury check numbers would be assigned as described in the following table below:

    Example 2, Treasury Check Number Assignments
    Treasury Check Number Payables Check Number
    7 2202
    8 2203
    9 2204
    10 2205
    74 2206
    11 2207
    12 2208
    13 2209

Example 3: Multiple check ranges have overlapping ranges.

You cannot use the same Treasury Check number twice for the same payment process request. You will receive an error if these Treasury Check number were entered in the Check Ranges window as described in the following table:

Example 3, Multiple Check Ranges with Ranges that Overlap
Range Sequence From To
1 7 10
2 74 77
3 75 90

Note: This example would result in an error because Range 2 and Range 3 both contain Treasury check numbers 75 through 77.

Prerequisites

Before recording and confirming Treasury payments, you must:

Related Topics

Federal Options Setup,Oracle U.S. Federal Financials Implementation Guide

Paying Invoices, Oracle Payables User Guide

Treasury Confirmation and Reconciliation

Recording and Confirming Department of Treasury Payments

To record and confirm Department of Treasury payment information, navigate to the Treasury Confirmation and Reconciliation window.

The following table describes selected fields on the Treasury Confirmation and Reconciliation window.

Treasury Confirmation and Reconciliation Window Description
Field Name Description
Operating Unit Operating unit of the record.

Note: The list of values include operating units assigned to the MO: Security profile.

Payment Instruction Payment Instruction
Reference Assigned by Admin User defined payment instruction name
Date Sent to Treasury Date payment batch sent to treasury; defaults to payment date in payables
Accomplished Date Department of Treasury document date; cannot be before the Date sent to Treasury
Range Type Range type values; includes single or multiple. Default value is single.
From Beginning check sequence number; required if the range type is single; disabled if range type is multiple
To Ending check sequence; required if range type is single; disabled if range type is multiple
Check Ranges Opens check ranges window; disabled if range type is single
Check Sequence Gap Selected when the range type is set to multiple or when a payment in the batch has an offset record with a corrected treasury check no.
Treasury Check No Department of treasury check number
Amount Document amount
Void Indicates that payment is voided

Note: When a payment is voided in payables, the void check box is selected in the treasury confirmation and reconciliation window.

Offset Indicates payment has offset
Gap Indicates payment has a document number sequence gap

Backing Out Confirmed Department of Treasury Payments

Click Back Out on the Treasury Confirmation and Reconciliation window if you make a mistake when entering data. For example, you enter an incorrect Accomplished Date. All journal entries created by the confirmation are reversed.

Voiding Confirmed Payments

To reverse the confirmation entries for payments voided in Oracle Payables after the payment was Treasury Confirmed, use the Submit Request window and select Disbursements in Transit Voided Checks.

Offsetting Payments

To offset a payment before confirmation, navigate to the Treasury Confirmation and Reconciliation window.

The following table describes selected fields on the Treasury Confirmation Offset window.

Treasury Confirmation Offset Window Description
Field Name Description
Vendor Name Derived from treasury confirmation and reconciliation window
Original Treasury Check No. Derived from treasury confirmation and reconciliation window
Corrected Treasury Check No. Corrected department of treasury check number
Offset Party Name Offset source
Original Payment Amount Derived from treasury confirmation and reconciliation window
Net Payment Amount Displayed if offset amount is entered; calculated value derived from original payment amount less offset amount
Void Indicates payment is voided

Related Topics

Using Standard Request Submission, Oracle Applications User Guide

Viewing Treasury Confirmation

To find and view Department of Treasury payment information:

  1. Navigate to the Treasury Confirmation Inquiry window.

  2. Query one or more fields.

  3. Click Treasury Confirmation or double click a record to go to the Treasury Confirmation and Reconciliation window.

    The associated Department of Treasury payment information is displayed in the Treasury Confirmation and Reconciliation window.

Related Topics

Accounting Using Oracle Subledger Accounting