3Inventory Transactions

This chapter contains the following:

Subinventory Transfers

Use a subinventory transfer to transfer material within your current organization between subinventories, or between two locators within the same subinventory. Examples of subinventory transfers are transferring between asset and expense subinventories, and transferring between tracked and non-tracked subinventories.

Availability types denote quantities of items that are available to transfer, and that are on hand.

You can view quantities in these availability types:

  • Available

  • Secondary Available Quantity

  • On Hand

  • Secondary On-hand Quantity

Available

The quantity that's available to transfer based on the unit of measure you specify, which is the quantity on hand less all reservations for the item. This amount could include the amount that you have reserved if you enter a transaction source that has reservations against it. The available quantity includes reservations against the current transaction source, and is specific to the revision level, lot number, source subinventory, and source locator that you specify for the transfer.

Secondary Available Quantity

The quantity that's available to transfer in the secondary unit of measure. This value displays if the item is under dual unit of measure control.

On Hand

The current on-hand quantity for the item, based on the unit of measure you specify. The on-hand quantity is specific to the revision, lot number, source subinventory, and source locator you specify for the transfer. On-hand includes quantities for pending transactions.

Secondary On-Hand Quantity

The current on-hand quantity of the item in the secondary unit of measure. This value displays if the item is under dual unit of measure control.

FAQs for Subinventory Transfers

Use the Create Subinventory Transfer page to create a subinventory transfer. Subinventory transfers occur immediately after you create and submit them.

Enter a value for the owning party on the Create Subinventory Transfer page.

Miscellaneous Transactions

A miscellaneous transaction is a transaction, such as a miscellaneous issue or miscellaneous receipt, that you can use to issue material that doesn't have or require documentation support.

These aspects are important when creating miscellaneous transactions:

  • Examples

  • E-signatures for approval

Examples

In your organization, you can create miscellaneous transactions to:

  • Perform manual adjustments to the general ledger by receiving material from one account to inventory, then issuing that material from inventory to a different account

  • Load all on-hand items at the beginning of the Oracle Fusion Inventory Management implementation process

  • Issue items to individuals, departments, or projects

  • Receive items that were acquired without purchase orders

  • Enter adjustments and corrections to system quantities outside of performing cycle counting or physical inventory counting, due to theft, vandalism, loss, shelf life expiration, or inaccurate record keeping

  • Issue damaged items to expense accounts, such as scrap

E-Signatures for Approval

If miscellaneous transactions are configured for approval using e-signatures, the E-Signature page opens when you create a miscellaneous transaction and click Submit for Approval. Use the page to approve the transaction.

The e-signature IDs are recorded and available on the Review Completed Transactions and Review Completed Transaction Details pages.

For information about e-signatures, see the Oracle SCM Using E-Signatures and E-Records guide, available on the Oracle Help Center.

For information about how to configure e-signatures for supply chain management transactions, see the Oracle SCM Cloud Implementing Manufacturing and Supply Chain Materials Management guide, available on the Oracle Help Center.

The Create Miscellaneous Transaction page provides you with an efficient way to manage items that don't require documentation support. When you use miscellaneous transactions as part of your stockroom procedures, you need an easy way to determine which subinventories and locators contain item on-hand and available quantity.

You can search for item availability across subinventories and successfully process miscellaneous transactions by selecting the Search On-Hand Quantity icon. To enable the Search On-Hand Quantity icon, you must first enter an item on the transaction line.

Note: The Search On-Hand Quantity column is hidden by default and you must select it from the View menu.

FAQs for Miscellaneous Transactions

A miscellaneous transaction is a transaction, such as a miscellaneous issue or miscellaneous receipt, that you can use to issue material that does not have or require documentation support. You can create miscellaneous transactions to make ad-hoc adjustments to on-hand quantities, or to issue material to individuals or projects that are not in inventory or receiving, such as a research and development group or an accounting department.

Create a miscellaneous transaction of type miscellaneous receipt.

Create a miscellaneous issue on the Create Miscellaneous Transaction page. Access this page from the task pane of the Inventory Management work area.

You can click Enter Cost Details to specify a cost for the transaction that's other than the default. If you don't specify a cost, the default current cost of the item is used.

How can I enter the unit cost for miscellaneous transactions?

Enter unit costs on the Create Miscellaneous Transaction page or through the Transaction Manager service.

To default the Use Current Item Cost field to Yes on the Create Miscellaneous Transaction page, select the Use Current Item Cost check box on the Manage inventory Organization Parameters page. You must enable this parameter for each organization.

Yes, you can enter the requester for a miscellaneous transaction. To enter or view the requester you must first enable the Requester column from the View menu on the Create Miscellaneous Transaction page. Select View > Columns > Requester.

Enter a value for the owning party on the Create Miscellaneous Transaction page.

Interorganization Transfers

Interorganization transfers enable you to transfer material between inventory organizations, which can be necessary if you define multiple inventories, warehouses, and manufacturing facilities as distinct inventory organizations.

In addition to being able to transfer one or more items in a single transaction, you can transfer partial quantities of the same item to different subinventories and locators in a single transaction. The items that you transfer must exist in both the source and destination organizations.

You can create these types of interorganization transfers:

  • Direct interorganization transfers

  • In-Transit interorganization transfers

Direct Interorganization Transfers

Direct interorganization transfers move items directly between inventory organizations. The destination organization receives the material immediately when you submit the transaction.

In-Transit Interorganization Transfers

In-transit interorganization transfers move items directly from the source organization to in-transit inventory. You usually transfer material to in-transit inventory when transportation time is significant.

FAQs for Interorganization Transfers

Enter a value for the owning party on the Create Interorganization Transfer page.

Interorganization transfers trigger consumption (ownership change) by default. If you want the material to remain consigned, you must set up a consumption rule to specify that consumption does not occur with interorganization transfers.

Set up a consumption rule to specify that consumption does not occur with an interorganization transfer. Otherwise, the interorganization transfer triggers consumption (ownership change) by default.

Movement Requests

Movement requests are requests for the movement of material within an inventory organization such as a warehouse or facility.

These types of movement requests exist:

  • Requisition movement requests

  • Replenishment movement requests

  • Shop floor movement requests

Requisition Movement Requests

Requisition movement requests are manually created, and can be used for subinventory transfers and account issues. Once a movement request has been submitted, the movement request is ready to be sourced and transacted.

A movement request creates instructions to pick or move material for warehouse personnel. You can create a requisition movement request to manually relocate stock within a warehouse. You can also create a requisition movement request to issue material out of a certain location. For example, you might want to issue out stock for damaged goods, or to a certain project.

Replenishment Movement Requests

Replenishment movement requests are requests that are generated by min-max planning to replenish material when a minimum quantity for a specific item is reached. Replenishment movement requests replenish material that's sourced from a different location within the same inventory organization. For example, a requisition movement request can be generated to move material from a bulk locator to a fast pick locator.

Shop Floor Movement Requests

Shop floor movement requests are requests to perform replenishment for components needed for manufacturing and maintenance work orders. Shop floor movement requests move materials either to WIP supply locations or directly to the work order from the warehouse locations.

You can create a pick request to inventory for one or more multiple work orders. Warehouse personnel pick the components from warehouse locations in the same manner as is done for sales orders, transfer orders and replenishment requests.

When you fully transact a movement request, you perform the complete process required to request movement of material, physically move material, and confirm physical movement of material.

Scenario

You are charged with performing the entire movement request process flow.

The movement request process flow includes creating a movement request, running the Print Movement Request Pick Slip Report, physically picking material, and confirming pick slips, as illustrated in the following diagram:

Movement request process flow

To perform the movement request process flow:

  1. Manually create a requisition movement request on the Manage Movement Requests page.

  2. Run the Print Movement Request Pick Slip Report using the Enterprise Scheduler Service.

    Give the pick slips to the warehouse operator.

    Note: Set the Release Approved Lines parameter on the Print Movement Request Pick Slip Report to Yes to eliminate the need to perform the pick in the Reservations and Picks pages.
  3. Physically move material according to the Movement Request Pick Slip Report's specifications.

  4. Confirm pick slips.

    To confirm pick slips, verify that you have moved the material according to the Movement Request Pick Slip report, and confirm the items to be shipped on the Confirm Pick Slips page.

    If necessary, you also enter discrepancies such as changing the quantity of items that you picked.

This example illustrates the prerequisites that you need to perform to set up the generation of replenishment movement requests.

Scenario

You are charged with performing the prerequisites necessary to set up the generation of replenishment movement requests. You need to perform these steps:

  1. Set up min-max planning on the subinventory level.

    On the Create Subinventory or Edit Subinventory page:

    • Select item sourcing options

    • (Optional) Specify lead times

  2. Set up min-max planning on the item subinventory level.

    On the Add Item to Subinventory page or Edit Item Subinventory page:

    • Select Min-Max planning.

    • Specify minimum and maximum quantities.

    • (Optional) Specify the desired fixed lot multiple value or minimum and maximum order quantities.

      You only need to specify these values if supplier constraints affect replenishment.

    • Select Subinventory for the item sourcing option, as well as the source subinventory.

    • (Optional) Specify lead times.

  3. In the Print Min-Max Planning Report Enterprise Scheduler Service program, select Subinventory for the planning level.

    The Min-Max Planning Report generates movement requests to replenish material for the items and subinventories for which you set up min-max planning.

  4. Run the Print Min-Max Planning Report Enterprise Scheduler Service program.

FAQs for Movement Requests

Can I create a movement request from the Manage Items Quantities page?

Yes, select Request Miscellaneous Transactions from the Actions menu to access the Create Miscellaneous Transactions page. Attributes from the selected line on the Manage Item Quantities page, such as item details, subinventory, and location carry over to the Create Miscellaneous Transaction page. Once you create and submit the transaction, you're automatically returned to the Manage Item Quantities page.

Yes, you can enter the requester for a requisition movement request when creating movement requests using the Manage Movement Requests page. You can also view the requester on the Review Completed Transactions page. To enter or view the requester, you must first enable the Requester column from the View menu on these pages. Select View > Columns > Requester.

Pending Transactions

A pending transaction is either a transaction that's waiting to be executed, or a transaction that has been executed, but has resulted in an error.

For miscellaneous receipts, miscellaneous issues, subinventory transfers, interorganization transfers, and user-defined transactions that are waiting to be executed or have errors, do the following:

  1. Click Manage Pending Transactions from the Inventory task list in the Inventory Management work area.

  2. Edit the errors.

  3. Click Add All to Process Schedule. You can optionally select rows in the table and click Add Selected to Process Schedule to process only your selected rows.

    Note: You can process a maximum of 500 rows at a time.

For pending cycle count adjustment transactions do the following:

  1. Open the scheduled process interface.

  2. Search for and run Import Count Sequences.

For cycle count adjustment errors, do the following:

  1. Download the Review Count Interface Records spreadsheet from the Counts task list in the Inventory Management work area.

  2. Edit the errors.

  3. Upload the data.

To do this task you need a Microsoft Excel add-in. From the Navigator, click Tools > Download Desktop Integration to install the add-in.

You can delete a pending inventory transaction if the transaction is no longer wanted or needed. Once you delete the pending transactions, the quantities return to the inventories that they came from. All associated transactions revert to the setups prior to the creation of the transactions.

Use the Manage Pending Transaction pages to delete pending transactions:

  1. On the Manage Pending Transactions page, click the View Pending Transactions button.

  2. On the View Pending Transactions page, search for the records that you want to delete. You can search by organization, processing status, transaction date, transaction type, and more.

  3. Select each transaction row that you want to delete. You can select up to 500 rows to delete at one time.

  4. Click the Delete icon. You can also select Delete from the Actions menu.

This deletes the transactions from the Inventory Transactions Interface table (INV_TRANSACTIONS_INTERFACE).

Note: To delete a pick pending transaction, you must remove the pick transactions using the Confirm Pick Slip pages instead of the Manage Pending Transaction pages. From the Confirm Pick Slip page, search by order number and pick 0 for the pick lines that you want to delete.

FAQs for Pending Transactions

Use the Manage Pending Transaction pages to correct pending transaction errors for miscellaneous receipts, miscellaneous issues, subinventory transfers, inter-organization transfers, and user-defined transactions.

Click a link for an error transaction on the Manage Pending Transactions page. Select a row to edit and click the Edit icon. Make your corrections and save them. Then, click the Add All to Process Schedule button.

The Validated transaction state denotes an inventory transaction that's created in the Oracle Fusion Inventory Management application.

The Staged transaction state denotes a transaction whose record is in the transaction open interface table. Usually, Staged transactions are created in external applications.

The transaction is submitted. The transaction will be executed when the Transaction Manager runs the next time.

Use the Confirm Pick Slip page (instead of the Manage Pending Transactions page) to delete a pick pending transaction. From the Confirm Pick Slip page, search by order number and pick 0 for the pick lines that you want to delete.

If the shipment lines are in Released to Warehouse status, then the pick slip report has been printed for the pickers to complete their picks. It's assumed that the materials have been physically moved to the staging subinventory. For this reason, picking lines are kept when a sales order is canceled. To remove this transaction, you have two choices. You can either pick the full quantity and the material moves to the staging subinventory, but isn't attached to the sales orders. Or, if the full material isn't physically moved, you can pick 0 for the picking lines from the Confirm Picks Slips page to delete the transaction.

Note: You must use the Confirm Pick Slip page (instead of the Manage Pending Transactions page) to delete a pick pending transaction.

Cycle count records must be processed and in a transaction process status of Staged to be deleted from the View Pending transactions page. You must first run the Manage Inventory Transactions scheduled process to get these records to a Staged status. Then, you can delete the cycle count transactions.

Note: Don't purge the cycle count or physical inventory until the cycle count records are completely processed and moved to completed transactions.

Use the Manage Pending Transactions page to delete transactions from the Inventory Transactions Interface table (INV_TRANSACTIONS_INTERFACE). On the Manage Pending Transactions page, click the View Pending Transactions button. Search for the records that you want to delete. Select each transaction row that you want to delete and click the Delete icon. You can select up to 500 rows to delete at one time.

Review Completed Transactions

Use the Review Completed Transactions page to search for and view details of completed inventory transactions. From the Inventory Management work area, select Review Completed Transactions from the task pane.

To search for detailed information for completed transactions, enter any combination of search criteria. Select View and then Columns to choose additional fields to display on the Review Completed Transactions page. Click on a transaction in the Search Results table to drill down to the Completed Transaction Details page to review a detailed, single record view of the transaction.

This table provides a summary of the completed transaction details that you can view on both the Review Completed Transactions and Completed Transaction Details pages.

Completed Transaction Details Description

Location

View item, subinventory, locator, and quantity information. You can also view details such as revisions, transfer information, and attachments.

Transaction

View transaction details such as transaction date, transaction type, transaction action, transaction source type, transaction costed status, and more.

In Transit

View the shipment number, waybill, carrier, and packing unit information for in-transit shipments.

Consigned Inventory

View the owning party, consumption advice, and transfer owning party details. You can also review the purchase order, receipt, and error information if provided.

Tax Determinants

View details on transactions such as receipt, ship confirm, and consumption that become inputs into the tax determination process. Examples of tax determinants are taxation county, product fiscal classification, and tax classification code.

Additional Information

View additional information that you may have provided for your transactions such as patient account or other user-defined flexfields.

You can also view lot and serial information when applicable. The lot and serial information is only enabled if the item is lot controlled, serial controlled, or both. To view lot and serial information for a transaction, click the View Lot and Serial Details icon on the Review Completed Transactions page. You may have to add the Lot and Serial Numbers column to the page by selecting View > Columns > Lot and Serial Numbers. To access lot and serial details from the Completed Transaction Details page, click the View Lot and Serial Numbers button.

In addition, on the Review Completed Transactions page you can export your completed transactions to a Microsoft Excel file. Select Export to Excel from the Actions menu or click the table icon.

Discrete Manufacturing Sourced Inventory Transactions

Discrete Manufacturing Sourced Inventory Transactions

Oracle Fusion Inventory Management interfaces with Oracle Fusion Discrete Manufacturing to process work in process (WIP) inventory transactions.

Here are the process flow steps for WIP inventory transactions:

  1. Discrete Manufacturing initiates the processing of WIP transactions.

  2. Discrete Manufacturing generates inventory transactions in the Inventory Interface tables.

  3. Discrete Manufacturing calls the Inventory Transaction Manager to process the WIP inventory transactions.

  4. Inventory Transaction Manager process returns a response to the Discrete Manufacturing application.

  5. Handling of WIP inventory transactions errors.

  6. Review completed inventory transactions.

Discrete Manufacturing Initiates the Processing of WIP Transactions

Discrete Manufacturing processes transactions within the WIP application. You can enter WIP transactions through user interfaces, or you can batch them in transaction tables and process them in a background mode.

Discrete Manufacturing Generates Inventory Transactions in the Inventory Interface Tables

Discrete Manufacturing determines which inventory transactions to pass to inventory, and then generates these transactions in the Inventory Transaction Interface tables. The transferred information includes core transaction details such as transaction type, inventory item, quantity, UOM, subinventory, locator, and so forth.

The interface supports these WIP transactions:

  • Work in Process Material Issue

  • Work in Process Material Return

  • Work in Process Product Completion

  • Work in Process Return

  • Work in Process Negative Material Issue

  • Work in Process Negative Material Return

Discrete Manufacturing Calls the Inventory Transaction Manager to Process WIP Transactions

Discrete Manufacturing initiates the processing of the Inventory Transaction Manager. This process validates WIP transactions, applies necessary options, and updates inventory tables. The process deletes transactions that pass validation from the inventory transaction interface tables and updates on-hand balances and lot and serial details in the core inventory tables.

Inventory Transaction Manager Returns a Response to Discrete Manufacturing

Once processing of designated transactions is complete, the Inventory Transactions Manager process returns either a success or failure status to the calling Discrete Manufacturing application.

Handling of WIP Inventory Transaction Errors

If an error is found, the calling application in Discrete Manufacturing makes the appropriate error message available to the user for resolution. Note that the transaction is cleared out of the inventory interface table and must be resolved in the Discrete Manufacturing application that originated the WIP inventory transaction. Once the error is resolved, the originating application can resubmit the transaction for processing.

Review Completed Inventory Transactions

You can view successfully processed inventory transactions using the Review Completed Inventory Transactions user interface.

Work in Process Negative Material Return Transactions

We have two types of Work in Process Negative Material Return Transactions.

These include:

  • Work in Process Negative Material Issue

  • Work in Process Negative Material Return

Work in Process Negative Material Issue

The Work in Process Negative Material Issue transaction type enables you to recover byproducts from the manufacturing processes. This transaction provides a way to remove components from a final assembly that must be replaced or upgraded, and places the components back into inventory. The Work in Process Negative Material Issue transaction issues components from jobs and schedules to inventory to fulfill negative material requirements.

Work in Process Negative Material Return

The Work in Process Negative Material Return transaction type reverses the Work in Process Negative Material Issue transaction. This transaction enables components that are put back into inventory using the Work in Process Negative Material Issue, to be issued back to the original rework work order when the original transaction was done in error.

This transaction returns components to jobs and schedules from inventory to fulfill negative material requirements. A WIP negative material return reverses a WIP negative material issue.

Note: If you perform a negative material return transaction to return components that are under lot, serial, or lot and serial number control, you must identify the lots and serial numbers to perform the transaction.

Serial Numbers and Rework Work Orders

When performing a Work in Process Material Issue transaction for a lot or serialized assembly item into a rework work order, the lot or serial number isn't required.

Lot and serial numbers aren't required for the following Work in Process transaction types:

  • Work in Process Material Issue

  • Work in Process Material Return

  • Work in Process Product Completion

  • Work in Process Return

However, lot and serial numbers are required for these two Work in Process transaction types:

  • Work in Process Negative Material Issue

  • Work in Process Negative Material Return

FAQs for Discrete Manufacturing Sourced Inventory Transactions

What happens if I perform a negative material return transaction for lot or serial controlled items?

You must identify the lots and serial numbers to perform Work in Process Negative Material Issue and Work in Process Negative Material Return transactions.

Reservations and Picks

Availability and promise of delivery is vital for any business. You can guarantee availability by creating linkages between the supply and demand sources by using reservations and picks.

A reservation is an association between a demand source and a supply source to ensure availability. A reservation creates a data link between supply and demand and represents a guaranteed allotment of material to a specified demand source. A pick is a directive to move material for a particular demand from one specific inventory location to another location.

Both reservations and picks ensure that material for a demand isn't available for another demand to be reserved or picked from. You can transfer reserved inventory from one demand or supply source to another, but you can't pick reserved inventory for another demand source. Use the Manage Reservations and Picks page to view snapshots of reservations and picks on a single page. This helps in reserving or picking for a demand.

For example, when a request to reserve material for a sales order is placed, and enough available to reserve quantity exists for an item, a reservation is placed. This reservation ensures that a certain quantity of item is available on a certain date when transacted. Once reserved or picked, the product can't be picked for another sales order or issued out from inventory.

With the Manage Reservations and Picks page, you can:

  • Create, edit, delete, and view reservations and picks

  • Choose available quantity for reservations and picks

  • Reserve material for a customer without the order information using user-defined reservations

  • View the material consumption picture for an item, a particular customer, a particular order, or a combination of these

  • Transfer reservations from one supply (or multiple sources) to another, or one demand (or multiple demands) to another

  • Specify the reservation controls such as lot, revision, subinventory, and locator

  • Check the on-hand and available to reserve quantities

A reservation is a link between a supply document and a demand document. For example, you can create a reservation for a demand document type of sales order against a supply document type of purchase order. The reservation creates the association between these two documents and ensures that the specified quantity of an item is available on a certain date.

Item reservations prevent picking material you previously set aside for a sales order, account, account alias, or user-defined demand. You can also create reservations for different types of supplies such as on-hand inventory or purchase orders.

You can manually create a reservation or set parameters for the application to automatically generate the reservation. You can reserve material at the subinventory, locator, and if applicable, lot and serial number level.

Once reserved, you:

  • Can transfer reserved material from one demand or supply source to another.

  • Can't allocate the product to another supply source or transfer the product within inventory if the reservation is to a subinventory and locator. You can do this if the reservation is at a high level.

  • Can't pick reserved inventory for another demand source.

Let's look at these important aspects of reservations:

  • Reservation Types

  • Supply and demand source types

  • Reservations with no existing demand

  • Create Reservations page

Reservation Types

For on-hand inventory supply, there are two types of reservations:

  • High-level reservations: contain information about the item and the organization.

  • Low-level reservations: contain more detailed information about the item such as revision, lot number, subinventory, serial number, and locator.

With high-level reservations, you aren't reserving against a specific subinventory. So, issued stock can come from any available subinventory. If you want to issue material from a specific subinventory, use the Manage Reservations and Picks page to specify the subinventory details.

Note: The sales order line has a subinventory attribute and the reservation APIs honor this field if you specify the subinventory at the line level. You can change the subinventory or leave it blank.

Supply and Demand Source Types

Supply source types include:

  • On hand

  • Purchase order

  • Internal requisition

  • Transfer order

  • Transfer order returns

  • Work order

The demand source for reservations may be an application or user-defined transaction source type. Demand source types include:

  • Account

  • Account alias

  • Cycle count

  • Movement request

  • Sales order

  • Shipment request

  • User defined

  • Transfer order

  • Work order

Note: For any supply and demand document, for example purchase order, the document number and line number identifies the item quantity to reserve.

Reservations with No Existing Demand

You can use the Manage Reservations and Picks task to create inventory reservations when you don't have an existing demand, such as a sales order or transfer order, to reserve inventory against. In these cases, you can create a user-defined, account, or account alias demand.

Here are the demand document types you can use when there is no existing demand document:

Demand Document Type Description

User-defined demand

Use the user-defined document type when there isn't an official demand document such as a sales order or movement request. For example, you may not want to create an ad-hoc reservation against material they you may need at some future point in time.

Account alias

An account alias is an alternate name for an account number, and is used to more easily identify an account when performing a transaction. You can select an account alias as a demand source when performing a reservation. You can also select an account alias as a transaction source when performing a miscellaneous transaction.

Account

The Account demand is similar to the Account Alias. But in this case, you use the actual account number to reserve against and not the account alias.

It's important to note that you can't automate or use the picking process to relieve the user-defined, account alias, or account demand types. But, you can relieve them using the miscellaneous inventory transactions. For example, if you create a user-defined demand and reference an external document called DOC-123. Then you can perform a miscellaneous issue transaction and reference DOC-123 in the Source field when entering the transaction. After processing, the reservation relieves the user-defined demand of DOC-123 for the quantity on the miscellaneous issue transaction.

The account and account alias demand types work the same way. For example, if you create a reservation against an account demand type, you enter the account number when you create the reservation. If you then create an account miscellaneous issue transaction and use the account number in the Source field, the account reservation is relieved when you process that inventory transaction. And, the same idea holds true for the account alias demand type. But in this case, you use the account alias miscellaneous issue transaction.

Create Reservations page

Use the Manage Reservations user interface to create, view, update, transfer, and delete reservations. Use the Create Reservations page to create new reservations for a demand.

In the Demand section of the Create Reservations page, you can:

  • Create user-defined demand

  • Create account demand

  • Create account alias demand

  • Reserve automatically

In the On-Hand and Available Quantity section of the Create Reservations page:

  • You can view the on-hand and available quantities for the current reservation line.

  • The on-hand and available quantities change as you change the supply type, reservation quantity, or reservation levels.

  • The on-hand and available quantities change as you enter new reservation rows.

To access the Create Reservations page, select the Manage Reservations and Picks task from the Inventory Management work area. On the Manage Reservations and Picks page, select the Create Reservations button. You can also select Create Reservations from the Actions menu of the Search Results section. You can select the Create Reservations action with or without completing a search and selecting a node.

A pick is a directive to move material for a particular demand from one specific inventory location to another location. You can manually create a pick or set parameters for the application to automatically generate the pick. You can create a pick for material at the subinventory, locator, lot, and serial number level.

Use the Create Picks page to manually create new picks for a demand.

In the Demand section of the Create Picks page, you can:

  • Pick automatically

  • Generate a pick slip

  • Backorder a line

In the On-Hand and Available Quantity section of the Create Picks page:

  • You can view the on-hand and available quantities for the current pick line.

  • The on-hand and available quantities change as you change the pick quantity or levels (for example, changing the lot on an existing pick line).

  • The on-hand and available quantities change as you enter new pick rows.

When you manually create or edit a pick from the Reservations and Picks user interface, the destination subinventory and locator default based on the demand document type. For sales order and transfer order demand types, it's common for these fields to contain the default staging subinventory and locator for the item. You can create picks for movement requests from a sales order, internal order, and shipment request. You can also create picks for replenishment or requisition movement requests.

Note: The Create Pick action isn't applicable for User-Defined, Account, and Account Alias demand types.

To access the Create Picks page, select the Manage Reservations and Picks task from the Inventory Management work area. On the Manage Reservations and Picks page, select Create Picks from the Actions menu of the Search Results section. You can select the Create Picks action with or without completing a search and selecting a node.

You can create reservations and picks at different levels. Depending on the level you define, certain fields are mandatory, conditionally optional, or optional.

Reservations

You can create reservations at the organization, revision, lot, subinventory, and locator levels.

Note: You must first enter the lot, if you want to enter the subinventory and locator when creating reservations.
Reservation Level Mandatory or Optional Field Description

Organization and Item

Mandatory

Item reservations prevent the allocation of inventory that was previously set aside for a demand source in an organization.

Revision

Conditionally optional

Reservation at the revision level sets aside a revision of an item for the specified demand source.

Lot Number

Conditionally optional

If a lot is reserved for a demand source, it prevents allocation of any item in the lot for any other source.

Subinventory

Optional

Subinventory reservation sets aside the items in the subinventory for the demand source.

Locator

Conditionally optional

You can reserve locator combinations such as rack, bin, and row for a demand source.

Serial Number

Conditionally optional

You can reserve serial numbers if they're available in inventory and unreserved, and the serial quantity is available for the reservation.

  • If serials are reserved, then pick release allocates these serials regardless of the suggestions made by the picking rules, assuming that the serial status allows pick release.

  • If serials are reserved, then pick release allocates the reserved serials first. For the remaining demand, it honors the organization parameter Allocate serial numbers.

Picks

You can create picks for items that are lot controlled or not lot controlled. A pick is always detailed at the lowest level.

Pick Items Mandatory Fields Optional Fields

Item with lot control

Organization, item, lot, subinventory.

Serial number

Item without lot control

Organization, item, subinventory.

Serial number

When you manually create or edit a pick from the Reservation and Picks user interface, the destination subinventory and locator default as the default staging subinventory and locator for the item.

Note: For picks, revision is mandatory if an item is revision controlled. Locator is mandatory when subinventory is locator controlled.

Use the Transfer Supply page to transfer the supply details from existing reservations lines to one or more reservation lines. For example, you may want to transfer reservations from on-hand inventory to any future purchase orders that are incoming. Also, if one or multiple lots are bad, you may want to transfer the reservations to other lots. You can transfer the partially or complete reserved quantity to one or more supply types using the Transfer Supply page.

From the Details section of the Manage Reservations and Picks page, you can navigate to the Transfer Supply page. Select Transfer Supply from the Actions menu of the Reservations tab.

Transfer Reservations from Supply

The transfer quantity for each line on the Transfer Supply page defaults from the reservation quantity. You can change this value. You can view the total reservation quantity and total transfer quantity at the bottom of each column. The value for the total transfer quantity changes as you enter or change the value of the Transfer Quantity field.

The Transfer Reservations from Supply reservation lines should all belong to the same organization. You can remove any rows from this region.

Transfer Reservations to Supply

Use the Transfer Reservation to Supply section of the Transfer Supply page to:

  • Search for availability at different levels such as organization, subinventory, lot, and locator

  • View the entire availability picture

  • Enter the transfer quantity for any available line to choose that line as the destination supply

You can also remove any rows from this region.

In the search results, the value for the Transfer Quantity field defaults as 0. You must enter the correct transfer quantity and it needs to be less than the value in the Available to Reserve Quantity field. Once you enter the transfer quantity, click Save and Close to transfer the source supply for all the demands in the source reservation lines (Transfer Reservations from Supply section) with supply from destination supply sources (Transfer Reservations to Supply section).

Note: You can't enter the transfer quantity for any line for which the destination supply details match the supply details of the source reservation lines.

Example

In the Transfer Quantity from Supply section, enter the quantity of the reservation you want to transfer from the supply.

In the Transfer Quantity to Supply section, search and select the new supply for you to transfer the reservations. For example, if you know that there is more quantity coming in for a particular item on a purchase order. Search for and select that purchase order row, and enter the quantity of the reservation that you want to transfer to that supply.

Save and close the page. This moves the reservation for that on-hand demand supply to the purchase order supply.

Use the Transfer Reserved Quantity page to transfer demand details for existing reservation lines. You can transfer a partial or the complete reserved quantity to one or more demand types. For example, you may identify material that you need to transfer from low-priority demand to high-priority demand. You can then transfer the reserved quantity to one or more demand types using the Transfer Reserved Quantity page.

From the Search Results section of the Manage Reservations and Picks page, you can navigate to the Transfer Demand page. Select Transfer Reserved Quantity from the Actions menu.

Source Demand Documents

You can view the total reservation quantity of the selected demands and the total transfer quantity at the bottom of each column. The value for the total transfer quantity changes as you enter or change the value of the Transfer Quantity field.

The Source Demand Document reservation lines should all belong to the same organization.

Destination Demand Documents

Use the Destination Demand Documents section of the Transfer Reserved Quantity page to:

  • Search for destination demand documents by document type, document number, document line, and demand document name.

  • Enter the transfer quantity for any available line to choose that as the destination for demand.

    Note: The total transfer quantity for lines in the Source Demand Document section should be always greater than the total transfer quantity for lines in the Destination Demand Document Demand section of the page.
  • Add user-friendly demands for which reservations already exist.

You can also remove any search results rows from this region.

In the search results, the value for the Transfer Quantity field defaults as 0. You must enter the correct transfer quantity and it needs to be less than the remaining unfulfilled quantity for the demand. Once you enter the transfer quantity, click Save and Close to transfer the material reserved from the source demand lines to the destination demand lines.

Note: You can't enter the transfer quantity for any line for which the destination demand details match the demand details of the source demand lines.

You can use the Manage Reservations and Picks task to create inventory reservations when you don't have an existing demand, such as a sales order or transfer order, to reserve inventory against. In these cases, you can create a user-defined, account, or account alias demand.

In our example, let's create an inventory reservation against a user-defined demand document type.

Here's a summary of our overall steps:

  • Create the user-defined demand document type

  • Confirm inventory reservation creation was successful

Create the User-Defined Demand Document Type

  1. From the Inventory Management work area, click the Tasks panel tab and select the Manage Reservations and Picks task.

  2. Click the Create Reservations button.

  3. In the Search Results: Demand region, click the Create list and then, select Create User-Defined Demand from the list.

  4. In the Create User-Defined Demand dialog box, enter or select these values:

    Fields Values

    Inventory Organization

    M1

    Supply Document Type

    On hand

    Demand Document Name

    Demand Document 01

    Item

    ABC01-100

    Subinventory

    KKCONSUB

    Reserved Quantity

    1

  5. Click OK to return to the Create Reservations page.

  6. Click Save and Close.

Confirm Inventory Reservation Creation was Successful
  1. On the Manage Reservations and Picks page, in the Advanced search region, enter or select these values:

    Fields Values

    Search

    Reservations

    Inventory Organization

    M1

    Item

    ABC01-100

    Demand Document Type

    User Defined

  2. Click Search.

  3. Click the Expand icon next to Organization M1 to see the item node.

  4. Click the Expand icon next to ABC01-100 to see the user-defined node.

  5. Click the Expand icon next to the User-Defined node to see your demand document.

  6. Click Done.

FAQs for Reservations and Picks

A reservation links a supply source (such as on-hand inventory or a purchase order) to a demand source (such as an account, cycle count, or user-defined demand source), and guarantees allotment of material to the demand source. You can reserve material at the subinventory, locator, and if applicable, lot and serial number level.

A pick is a manually- or automatically-created suggestion to honor a reservation when on-hand inventory is available. Picks can be created for material at the subinventory, locator, lot, and serial number levels.

A cycle count reservation is a reservation with the demand document type of cycle count.

You can create a cycle count reservation if, during picking or shipping, you have determined missing material and you want to ensure that no one else tries to use or pick the missing material. Cycle count reservations are deleted when you perform a cycle count of the item in the specified location.

Reservations against the following supply sources are changed accordingly:

  • On hand: After on-hand supply has been issued against a specified demand, the on-hand quantity decreases by the amount that was issued. The same material can't be issued against another demand.

  • Purchase order: If you reduce the quantity of material in or cancel a purchase order that's reserved against a demand, the corresponding reservation is modified or canceled.

    Any other changes to the purchase order that affect the expected quantity also trigger changes to the associated reservation.

  • Requisition: If you reduce the quantity of material in or cancel a requisition that's reserved against a demand, the corresponding reservation is modified or canceled.

    Any other changes to the purchase order that affect the expected quantity also trigger changes to the associated reservation.

  • Transfer order: If you reduce the quantity of material in or cancel a transfer order that's reserved against a demand, the corresponding reservation is modified or canceled.

    Any other changes to the purchase order that affect the expected quantity also trigger changes to the associated reservation.

  • Transfer order return: If you cancel a transfer order return that's reserved against a demand, the corresponding reservation is canceled.

  • Work order: If you reduce the quantity of material in or cancel a work order that's reserved against a demand, the corresponding reservation is modified or canceled.

    Any other changes to the purchase order that affect the expected quantity also trigger changes to the associated reservation.

You must first enable the Enable reservation for work order materials plant parameter for the manufacturing plant's organization. Then, you can use the Manage Reservations and Picks page to reserve materials for work orders:

  • From Oracle Inventory Management Cloud: Select the Manage Reservations and Picks task from the Inventory Management work area to access the Create Reservations and Picks page. Select the Create Reservations button to open the Create Reservations page. You can manually create a reservation for the work order by entering the Demand Document Type and Demand Document Number. Enter the work order number for the Demand Document Number. Enter the work order number for the Demand Document Number.

  • From Oracle Manufacturing Cloud: Click the Reserve Materials Manually button on the Mange Work Order or Edit Work order page. This opens the Create Reservations page in Inventory Management. The Demand Document Type defaults as Work Order and the Demand Document Number defaults the work order number.

Confirm Pick Slips

Overview

You use the Confirm Pick Slips page to enter details of picked material and confirm a pick slip.

You can do the following as part of confirming a pick slip:

  • Enter details of picked material

  • View and modify details of picks on a pick slip

  • Enter multiple lot and serial number for picked material, if required

  • Enter the transaction date for each pick

  • Evaluate pick slip discrepancies

To confirm a pick slip, select Navigator > Supply Chain Execution > Inventory Management, and then click the Confirm Pick Slips task from the task panel.

To enter a serial number at pick confirmation, an item must be configured to create and assign serial numbers at pick confirmation. If you enter serial numbers at pick confirmation, your shipping personnel do not need to scan or enter serial numbers during the ship confirm process. This results in efficient processing of outbound shipments.

Note: If required, you can override the serial number entered at pick confirmation at shipment confirmation.

You can specify more than the requested quantity on your pick-and-move requests for sales orders, transfer orders, and work orders. This lets you pick a quantity that makes sense for your business, move it to a staging or processing location, perform your required tasks, and then take appropriate actions to handle the remaining quantities.

You can overpick and move materials on the Confirm Pick Slip page prior to staging the materials for shipping or the shop floor. Select the Overpick and Move icon for a pick line on the Confirm Pick Slip page to open the Overpick and Move window. This icon is available if the Allow overpicking for special handling check box is enabled at the inventory organization level. You can enter a picked quantity for the pick line that's greater than the requested quantity, and move it to an intermediary subinventory prior to confirming the pick to a staging subinventory. Applicable demand types, such as a shipment for a sales order or transfer order, or a work order to the shop floor, can then consume the pick.

Example

Let's look at an example where overpicking could be useful. Let's say that you have items that are boxed in multiples or lots and you need to breakdown the boxes to fulfill the requested quantity. It may not be efficient to perform the breakdown at a congested store's location. Instead, it's easier to move the material to a dedicated location for processing.

Validations

This table shows the validations that the application considers for overpick and move transactions.

Validation Description

Material Availability

There must be sufficient on-hand quantity available in the subinventory, locator, or lot for the picked quantity.

Other pick lines that are vying for the same material automatically move in parallel, prioritized by due date, across demand types unless there's sufficient on-hand quantity to fulfill them at the source after the move. These other pick lines must not be reserved at a detailed level such as subinventory, locator, and lot.

You can split pick lines between the source and intermediary subinventory unless they're constrained by a lot. You can also override the source subinventory, locator, and lot, but the new values are subject to the same material availability rules.

Material Status of Source and Destination

If the source subinventory, locator, or lot disallow subinventory transfer transactions or pick transactions for the respective demand types, the overpick and move can't be completed.

If the intermediary subinventory disallows pick transactions for the respective demand types or the transaction isn't reservable, the overpick and move can't be completed.

Project or Common Inventory Integrity

The sales order, transfer order, or work order dictate the requirement for project or common inventory. The inventory isn't interchangeable.

Once you initiate the overpick and move transaction, the application reallocates the target pick line and other qualifying pick lines to their new source subinventory, and locator where applicable.

Considerations

Consider these items when performing an overpick:

  • The picked quantity must be greater than or equal to the requested quantity.

  • If your inventory organization is set to allow negative balances, you can overpick and move more than is on hand or available.

  • Excess material (material that you overpick over the requested quantity that's not allocated to other demand) is considered available for new demand at all times.

Note: You can't overpick serial-controlled items. You can't pick a single pick line that contains multiple lots.

Enable Overpicking for Sales Orders, Transfer Orders, and Work Orders

To enable overpicking, complete these steps:

  1. In the Setup and Maintenance work area, use the Manage Inventory Organizations task:

    • Offering: Manufacturing and Supply Chain Materials Management

    • Functional Area: Facilities

    • Task: Manage Inventory Organizations

  2. In the Organization field, select the inventory organization and click Search. The organization displays in the Search Results area.

  3. Click Manage Organization Parameters.

  4. Click the Item Sourcing Details tab.

  5. In the Picking Defaults section, select these check boxes:

    • Allow overpicking for special handling

    • Overpicking for movement request enabled

FAQs for Confirm Pick Slips

You can continue with processing the shipment and then ship confirming it as an integrated flow.

You can enter serial numbers at pick confirmation for inventory transactions such as sales order pick, transfer order pick, transfer order return pick, and movement request issue. For internal material transfers, you can enter serial numbers between two inventory organizations (interorganization transfer) including for expense destinations. For internal material transfers between two subinventories (intraorganization or intersubinventory transfer) you cannot enter serial numbers except for destination type expense.

This selection automatically closes replenishment movement requests from min-max planning that are partially filled at pick confirmation time.

Yes, if your inventory organization is set to allow negative balances, you can overpick and move more than the available on-hand quantity.

UOM Conversions

UOM conversions enable you to view different units of measure set up for an item in inventory transactions. With UOM conversions, you can order items in one unit of measure, and convert and fulfill the items in a different unit of measure.

The UOM conversions option is hidden by default. Enable UOM conversions by selecting the UOM Conversions item from the View menu on the following applicable pages:

  • Receive Expected Shipments

  • Put Away Receipts

  • Manage Transfer Orders

  • Create Subinventory Transfers

  • Create Interorganization Transfers

  • Confirm Pick Slips

  • Return Receipts

  • Cycle Count - Record Count Sequences

  • Physical Count - Record Physical Inventory Tags

  • Create Miscellaneous Transactions

  • Manage Shipment Lines

  • Manage Item Quantities

  • Manage Movement Requests

Select the UOM Conversions icon to access the View UOM Conversions page. On the View UOM Conversions page, you can view the UOM conversion between the transaction UOM and other item-specific defined UOMs.

Note: You can use UOM conversions if you have defined interclass and intraclass UOM conversions for your items.

Country of Origin Tracking

Country of Origin Tracking for Inventory Transactions

You can report and track the country of origin on on-hand quantity and inventory transactions in receiving, shipping, and inventory. Once you select the Enable Inventory Tracking by Country of Origin option on the Manage Inventory Organization Parameters page, country of origin tracking is available to you.

Report and track country of origin when you:

  • Receive purchase orders

    Receive and put away lines for a specific country of origin material. The country of origin on the purchase order defaults when receiving the lines.

  • Perform inventory transactions

    Use the Create Miscellaneous Transaction task to issue or receive country of origin-specific material. Use the Create Subinventory Transfer task to transfer country of origin-specific material. Use the Create Interorganization Transfer task to transfer country of origin-specific material across inventory organizations.

  • Confirm pick slips

    Pick confirm material for a specific country of origin. You may also override the picking recommendation.

  • Manage item quantities

    Query and review for on-hand inventory based on country of origin.

  • Review completed transactions

    Query and view completed transactions for country of origin-specific material using the Review Completed Transactions task

  • Perform cycle counting

    Record cycle count sequences and approve the sequences for country of origin-specific material.

  • Perform physical inventory

    Record physical inventory tags and approve the adjustments for country of origin-specific material.

  • Import material transactions to costing

    Use country of origin as an additional valuation structure attribute to track costs and value inventory.

  • Ship material

    Ship and quick ship the shipment lines with or without the country of origin-striped material.

Once you identify the country of origin details on a receipt, those details are then tracked by the various inventory functions that handle material within a warehouse. Tracking by country of origin helps you to maintain reporting compliance on import and export documents, take advantage of country specific trade agreements or other trade programs, and identify risk in supply chain sourcing as tariffs change.

Note:
  • Reservations don't support country of origin.

  • Country of origin is view only during inspection and put away transactions.

  • You can't stripe consigned inventory material for country of origin.

FAQs for Country of Origin Tracking

How can I track inventory transactions by country of origin?

Set up your inventory organization to track by country of origin. In the Setup and Maintenance work area, go to the Manage Inventory Organizations task. On the Manage Inventory Organization Parameters page, select the Enable inventory Tracking by Country of Origin check box.