Perform Mass Maintenance on Subinventories and Locators

In industries with constantly evolving goods or a large number of storage locations, managing key parameters of your subinventories, locators, and the items associated with both can be key to optimal operational efficiency. For example, subinventories represent Periodic Automatic Replenishment (PAR) locations for healthcare providers. Many of these PAR locations contain the same goods, and exactly which goods need to be stocked in all of these PAR locations can change often. When there can be hundreds of PAR locations, manually associating or disassociating goods to each and every PAR location quickly becomes a time-consuming task. In this update, you can now create and update multiple subinventories, locators, and item associations with subinventories or locators simultaneously.

The Redwood pages delivered as part of the Manage Subinventories and Locators on Redesigned Pages 24A feature has been enhanced to enable users to create and update multiple subinventories, locators, and item subinventory and locator associations. The new enhancements are accessible using the Configure Subinventories task from both the Inventory Management work area and the Setup and Maintenance work area. In this release, subinventories and locators can be created by copying them from an existing subinventory and locator.

You can also disassociate items associated with subinventories and locators.

These pages are enhanced to enable you to create and update multiple subinventories, locators, and item associations with subinventories or locators by uploading .csv files in a drawer component:

1. Subinventories
2. Subinventory Details
3. Locator Details
4. Associate Item with Subinventory
5. Associate Item with Locator
6. Item Details
7. Associate Locator with Item

Subinventories Page

Create Subinventories from Existing

These new Redwood pages will help you in mass maintenance of subinventories and locators:

1. Item Associations
2. Item Associations: Item Details
3. Action Status

Item Associations Page

Item Details Page

Action Status Page

You may now also use the Configure Subinventories in Spreadsheet task, which will download a seeded spreadsheet template using the Oracle Visual Builder for Excel plugin, for creating and updating subinventories and locators. You may also create and update item associations and disassociate items with subinventories and locators.

Configure Subinventories in Spreadsheet Task

These new scheduled processes are also introduced:

1. Perform Mass Maintenance on Subinventories and Locators: This process creates and updates multiple subinventories, locators, item subinventory associations, or item locator associations simultaneously. The process isn't available to be run manually by users, and it will be submitted automatically once a user submits the mass maintenance tasks.

2. Purge Subinventories and Locators Mass Maintenance Staging Records: This process purges mass maintenance data for subinventories and locators from the staging tables. The process can be run occasionally by customers once after they have created or updated large volumes of subinventories, locators, or item subinventory and locator associations.

These two processes are secured by the Manage Subinventory and Locator privilege.

This feature provides you a more efficient way to create or update multiple subinventories, locators, or the items associated with either.

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Manufacturing and Supply Chain Materials Management  No Longer Optional From: Update 24C

Tips And Considerations

Now you can create and update multiple subinventory, locator, item subinventory, and item locator settings using the enhanced Redwood pages.

• You may access this feature using the 24A opt-in Manage Subinventories and Locators on Redesigned Pages feature in the Inventory Management functional area.

• You may access this feature using the Configure Subinventories task from both the Inventory Management work area and the Setup and Maintenance work area.

• You may also use the Configure Subinventories in Spreadsheet task to access the integrated spreadsheet using the Oracle Visual Builder Add in for Excel for mass create and update functionality. You will need to provide credentials for the item subinventory associations and item locator associations worksheets separately.

• Using this feature, you may also disassociate multiple item subinventory and item locator associations. 

• You may check for any errors encountered while performing the mass maintenance tasks on the subinventories and locators by downloading the error file from the Action Status page.

Key Resources

• Watch the Perform Mass Maintenance on Subinventories and Locators Demo.
• Oracle Fusion Cloud SCM: Using Inventory Management guide, available on the Oracle Help Center.

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

• Get Item Rest (EGP_GET_ITEM_REST_PRIV)
• Manage Inventory Status (INV_MANAGE_INVENTORY_STATUS_PRIV)
• Manage Subinventory and Locator (INV_MANAGE_SUBINVENTORY_AND_LOCATOR_PRIV)
• Manage Unit of Measure Usage (INV_MANAGE_UNIT_OF_MEASURE_USAGE_PRIV)
• View Inventory On-Hand Balance Web Service (INV_VIEW_INVENTORY_ONHAND_BALANCE_WEB_SERVICE_PRIV)
• View Subinventory and Locator List of Values by Web Service (INV_VIEW_SUBINVENTORY_LOCATOR_LOV_WEB_SERVICE_PRIV)
• View Inventory Organizations List of Values by Web Service (RCS_VIEW_INV_ORG_LOV_WEB_SERVICE_PRIV)
• View Units of Measure List of Values by Web Service (RCS_VIEW_UNITS_OF_MEASURE_LOV_WEB_SERVICE_PRIV)

These privileges were available prior to this update.

Users who are assigned a configured job role that contains this duty role can access this feature:

• Configure Subinventory Using Responsive Inventory (ORA_INV_CONFIGURE_SUBINVENTORY_PWA_DUTY)

These privileges and the duty role were available prior to this update.