Inactivate Suppliers

Use the inactivate suppliers scheduled process to inactivate suppliers that have no sourcing, purchasing or invoicing transactions in a time period, or suppliers that are marked as one-time and have been paid at least once.

As a supplier administrator, I want the ability to automatically identify and inactivate suppliers that are no longer active.

If a supplier has no sourcing, purchasing or invoicing documents in a configured time period, or the supplier is a one-time supplier and has been paid once, the inactivate suppliers job will do the following:

  • Stamp current date as the inactive date for such suppliers, and
  • Provide an output report that helps identify suppliers that could not get inactivated due to error in updating their profile.

When to Use

To keep your supply base current, you must identify and inactivate suppliers that you are no longer doing business with. You must also inactivate suppliers that were created as one-time and have received a payment.

We recommend that you configure the inactivate suppliers job to identify such suppliers and inactivate them automatically in the background thus reducing the overhead of supplier administrators and also provide an improved supplier search experience that filters out inactive suppliers.

Privileges Required

To inactivate suppliers, you must have this privilege (ORA_POZ_AUTO_INACTIVATE_SUPPLIERS_PRIV), this privilege (POZ_IMPORT_SUPPLIER_PRIV), or this privilege (FND_MANAGE_SCHEDULED_PROCESSES_PRIV). If you don't have either of these privileges assigned already, check with your administrator.

Specifications

Review the following before setting up this scheduled process:
Specification Description
Job Type Scheduled.
Frequency If you are using the application for a long period, the first job run will result into large record updates. Execute the first job as single instance and then schedule the next runs on monthly basis.
Time of Day After work hours.
Duration Typically less than 2 minutes.
Compatibility There should be only one instance of the job running at any one time and there is no current functional need to be able to run multiple instances of this process at the same time.

Parameters

Parameter

Optional or Required

Description

Parameter Value

Special Combination Required

Notes

Suppliers with No Transactions

Optional

To inactivate suppliers with no recent purchase orders, invoices and sourcing transactions, one needs to submit the job with the suppliers with no transactions parameter as Yes.

N/A

None

N/A

Months Since Last Transactions

Optional

Enter the number of months to identify suppliers with no transactions as a value for the months since last transactions parameter.

N/A

If the suppliers with no transactions parameter is selected as Yes, one must enter a value for this parameter.

N/A

Paid One-Time Suppliers

Optional

To inactivate one-time suppliers who received at least one payment, one needs to submit the job with the paid one-time suppliers parameter as Yes.

N/A

None

N/A

Generate inactivation list only

Optional

To review the list of suppliers to be inactivated based on the specified parameters before inactivating the suppliers, one needs to submit the job with the generate inactivation list only option selected.

N/A

None

N/A

Troubleshooting Information

  • You can view the status of the inactivate suppliers operation on the scheduled processes UI.
  • The validation errors and warning messages that prevented the supplier inactivation are displayed in the job’s output report.
  • Any interactive warning validations are NOT performed.
  • When the program is submitted, you can Resubmit, Put on Hold, Cancel Process, Release Process as provided by the Scheduled Processes UI.
  • If the job fails, check the error log output to find the error encountered during the job run.