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

Suppliers Deactivation Report Procedures

Overview

The Suppliers Deactivation Report enables users to activate or deactivate vendors that do not have any purchasing or payment activity in the given time period.

Purchasing activity includes a supplier's purchase requisitions or purchase orders created or updated. This includes all documents even if they are not completed or approved.

Payment activity includes a supplier's invoices, debit memos, credit memos, payments, or refunds entered or updated.

The Suppliers Deactivation Report process includes these steps:

  1. Users run the Suppliers Deactivation Report with the Deactivate Suppliers parameter set to No.

  2. Users review the report and note the suppliers that should remain active.

  3. Users rerun the Suppliers Deactivation Report with the Deactivate Suppliers parameter set to Yes.

  4. Users navigate to the Supplier window and query the suppliers noted in Step 2 that should not be deactivated and delete the value in the Inactive On field.

  5. To verify that the correct suppliers are deactivated, users run the Suppliers Deactivation Report with the Deactivate Suppliers parameter set to No.

    The Deactivated Supplier Listing section displays the deactivated suppliers.

Generating the Suppliers Deactivation Report and Deactivating Suppliers

Viewing the Suppliers Deactivation Report

To run the Suppliers Deactivation Report:

  1. Navigate to the Submit Request window.

  2. In the Request Name field, select Suppliers Deactivation Report.

  3. In the Operating Unit field, select an operating unit.

  4. In the Supplier Name From field, optionally select a supplier name designating where to begin report generation for the range of suppliers.

  5. In the Supplier Name To field, optionally select a supplier designating where to end report generation for the range of suppliers.

    Note: Users can enter a value in Supplier Name From field without having to enter a value in the Supplier Name To field. Users select the default value in the Supplier Name To field and delete it.

  6. In the Date Since No Activity field, enter a begin date for reporting suppliers without any activity.

    Note: The current system date is the end date for reporting suppliers with no activity.

  7. To review the list of suppliers with no activity, select N in the Deactivate Suppliers field.

Deactivating Suppliers

To deactivate suppliers:

  1. Repeat Steps 1 through 5from the Viewing the Suppliers Deactivation Report.

  2. In the Deactivate Suppliers field, select Y.

Reactivating Suppliers

To reactivate suppliers:

  1. In Payables, navigate to the Suppliers window.

  2. In the Inactive On field, delete the value.

Suppliers Deactivation Report Description

The following table describes the Suppliers Deactivation report.

Suppliers Deactivation Report Description
Column Description
Supplier Name Vendor name
Supplier Num Number assigned to vendor
Site Supplier site
Days Since Last Activity Number of days without activity; calculated by the report program
Date of Last Activity Date of last invoice, purchase order, requisition, or payment
Supplier Name Vendor name
Supplier Num Number assigned to vendor
Site Supplier site
Date Deactivated Date supplier deactivated. The system enters the current system date as the inactivate date for any suppliers picked up by the report.

Note: All supplier sites must be deactivated before the system deactivates a supplier.