Print Cancel Transfer Order Report

Use the Print Cancel Transfer Order Report scheduled process to perform a mass cancellation of the remaining quantities on transfer order lines.

The remaining quantity is the difference between the requested quantity and the shipped quantity on the transfer order lines. Once all transfer order line quantities are either canceled or fulfilled (delivered in destination), the transfer order is closed.

You can print the Print Cancel Transfer Order report using either one of two provided report formats:

• Requisition View: Shows transfer order information from a requisition focused point of view. The current status of open transfer orders, including details specific to the transfer orders sourced from Oracle Fusion Cloud Self-Service Procurement, are shown in this report format.

  Additionally, budget status, budget dates, and distribution accounts are shown providing a listing of transfer orders for use in period-end processing at sites using budgetary control and encumbrance accounting.

• Transfer Order View: Shows the current status of transfer order information oriented from the warehouse manager's point of view. This format provides details of the on-going status of transfer orders coming from many different transfer order sources without the budgetary control fields. The Transfer Order view is the default view.

When to Use

This mass cancellation of transfer orders can be more convenient than canceling one order at a time on the Manage Transfer Orders page. You can still perform an immediate cancellation of backorders at pick release, pick confirm, and ship confirm time. However, this process provides you with an alternative method to automatically cancel remaining quantities on transfer orders. The Print Cancel Transfer Order Report process provides an option to print a report and cancel the transfer order lines based on entered selection criteria. If you don’t select the cancel option, the report still prints, and the report shows what would be canceled if the cancel option was selected.

Privileges Required

• Print Cancel Transfer Order Report (INV_PRINT_CANCEL_TRANSFER_ORDER_REPORT_PRIV)

Specifications

Review the following before setting up this scheduled process:

Specification	Description
Job Type	Ad hoc job Scheduled
Frequency	As required.
Time of Day	Any time unless the number of transfer orders within the specified criteria is high. In that case, running the process outside of main operational hours is advisable.
Duration	The duration of the process depends on the parameters provided, and therefore the number of transfer orders within the specified criteria, while running the report.
Compatibility	There can be many requests running at the same time depending on the input parameters.

Parameters

Parameter	Optional, Conditional, or Required	Description	Parameter Values	Special Combinations Required	Notes
Transaction Origin Type	Optional	Specify the source of the transfer order. The default value is blank (all included).	Inventory Min-max planning Order Management PAR replenishment Planning Requisition Return Supply Chain Orchestration	None	N/A
Requester	Optional	Specify a requester on the transfer order.	Employee name	None	N/A
Preparer	Optional	Specify a preparer on the transfer order.	Employee name	None	N/A
Requisitioning BU	Conditional	Specify a requisitioning business unit on the transfer order.	Business unit	At least one of Requisitioning BU, Source Organization, and Destination Organization is required.	N/A
Source Organization	Conditional	Specify a source organization on the transfer order.	Organization	At least one of Requisitioning BU, Source Organization, and Destination Organization is required.	N/A
Destination Organization	Conditional	Specify a destination organization on the transfer order.	Organization	At least one of Requisitioning BU, Source Organization, and Destination Organization is required.	N/A
Destination Subinventory	Optional	Specify a destination subinventory on the transfer order.	Subinventory	None	N/A
Destination Type	Optional	Specify a destination type value of none, inventory, or expense on the transfer order. The default value is blank (all included).	None ( blank) Inventory Expense	None	N/A
From Creation Date	Optional	Specify the transfer order from creation date.	Date	None	N/A
To Creation Date	Optional	Specify the transfer order to creation date.	Date	None	N/A
From Budget Date	Optional	Specify the transfer order from budget date.	Date	None	N/A
To Budget Date	Optional	Specify the transfer order to budget date.	Date	None	N/A
Charge Account	Optional	Specify a charge account on the transfer order.	Charge account	None	N/A
Item	Optional	Specify an item on the transfer order.	Item	None	N/A
Number of Days Without Activity	Optional	Enter a value for the Number of Days Without Activity field to cancel transfer orders that meet this requirement. For example, if you enter a value of 10 in this field, the process cancels transfer orders that have had no activity for 10 or more days. The default value is 0.	Number of days	None	N/A
Transfer Orders	Optional	Specify a transfer order	Transfer order	None	N/A
Requisition	Optional	Specify a requisition that’s the source of the transfer order.	Requisition	None	N/A
Destination Location	Optional	Specify a destination location on the transfer order.	Location	None	N/A
Shipping Priority	Optional	Specify a shipping priority on the transfer order.	Shipping priority	None	N/A
Selection Date Type	Optional	Specify a date type value of none, scheduled ship date, or requested delivery date. The default value is blank (all included).	None (left blank) Scheduled ship date Requested delivery date	Works with the Selection Date Offset field.	N/A
Selection Date Offset	Optional	This option lets you cancel transfer orders for a specified number of days after either the scheduled ship date or the requested delivery date. The default value is 0.	Number of days	Works with the Selection Date Type field.	N/A
Percentage Filled	Optional	Use this value to optionally determine whether transfer orders meeting the selection criteria should be canceled. This option enables you to cancel based on the percentage filled on the transfer orders that are partially shipped. For example, if 95% of an order is shipped, then you can cancel the remaining quantity on the transfer order. The percentage filled is the rate determined by dividing the Shipped Quantity by the Requested Quantity. If the calculated percentage filled is greater than or equal to the entered value, then the process selects the orders for cancelation. The default value is 0.	Percentage	None	N/A
Backordered Transfer Orders Only	Optional	Set this value to indicate whether you want to include only transfer orders that have a backordered line. If this option is selected, then in addition to meeting all other selection criteria, the transfer order line also needs to have quantities in a backordered status. The default value is Yes. There might be some quantities in a backorder status and other quantities that aren't. If any backorder was created for the transfer order line, then the transfer order line is eligible to be canceled.	Yes No	None	N/A
Cancel Orders	Optional	The process cancels the remaining quantity on transfer order lines. This reduces the quantity on the transfer order line down to the previously shipped quantity. This process also then cancels delivery lines in shipping associated with that transfer order line. All processing that occurs when a quantity on a transfer order line is reduced or canceled from the Manage Transfer Orders page is performed when canceling or reducing the quantity using the Cancel Transfer Order Report process. This includes updating budget dollars, and closing completely shipped or canceled orders. The default value is No. You can cancel transfer order lines in these situations: Transfer order lines meeting selection criteria with no current fulfillment activity. This enables you to cancel all lines with no activity. Transfer order lines meeting selection criteria including those with released lines. This includes transfer orders with lines in a Released to Warehouse or Staged status. Transfer order lines with backordered quantities only. This enables you to cancel transfer orders that have gone through pick release processing and have had a backorder created for them. When canceling quantities from the Print Cancel Transfer Order Report process, the cancel action: Cancels the line if there’s been no shipping activity. Automatically reduces the quantity to the shipped quantity if there’s been shipping activity. If you don't select the Cancel Orders option, the process prints the report only without canceling any transfer orders.	Yes No	None	N/A
Include in Process Orders	Optional	Specify whether you want to cancel orders that have lines in the Released to Warehouse or Staged status. If this option is set to No, then transfer order lines with a line in either of these two statuses can’t be canceled. The default value is No. The process still extracts and reports on these lines, but if you selected the Cancel Orders option, then these lines receive a warning message on the report letting you know that the transfer order line couldn't be canceled because it's in the process of being picked and shipped.	Yes No	None	N/A
Sort By	Optional	Specify the order the transfer orders are processed.	Item Last update date Transfer order	None	N/A
Project Number	Optional	Specify a project number on the transfer order.	Project number	None	N/A
Task Number	Optional	Specify a task number on the transfer order.	Task number	Dependent on the Project Number value.	N/A

Troubleshooting Information

• You can view the status of the process in the Scheduled Processes work area. If the process status is error, select the row and click the log and output attachment on the Process Details tab. Download the log and output file. Share the files with support to log a service request.
• The Print Cancel Transfer Order Report output displays the results of the cancel process. This explains the three possible values for the Cancel Results column:
  • Success: The cancel processing was successful.
  • Error: You might receive an error message in cases where the cancel processing is rejected by shipping. For example, this can happen when a line is shipped, but the shipped quantity hasn't yet been interfaced. The transfer order line level won't be correct until the transaction is posted. In this situation, the line appears on the report along with an error message from shipping explaining the issue.
  • Submitted: The transfer order is being processed through Oracle Fusion Cloud Order Management and the cancel request has been submitted to Oracle Order Management. To later verify that the transfer order line has been canceled, you can view it from the Manage Transfer Orders page.