Manage Supplier On-Hand Quantities Using a Redwood Page

You can now use the Redwood user experience to upload and review your supplier’s on-hand quantities. Using the Supplier On-Hand Quantities task, you have access to two pages: On-Hand Quantities and On-Hand files.

Here are a few things you can do on the On-Hand files page:

  • Click Download Template to download the template. Enter the supplier on-hand quantities along with these fields: Item, Supplier Item, Supplier, Supplier Site, Procurement BU, Quantity and UOM.
  • After clicking the Upload button, drag and drop the file to upload it.
  • Search by file status or file name.
  • You can review the number of records processed and number of records failed for each uploaded file.
  • Click the number of records failed to see the error message for the specific row.

Here are a few things you can do on the On-Hand Quantities page:

  • Search by supplier, supplier site, or item and review the on-hand quantity.
  • Select one or more rows and click Delete to delete the records.

NOTE: The Supplier On-Hand Quantities task is also accessible to your supplier users via Oracle Supplier Portal.

The Supplier On-Hand Quantities page lists the current on-hand quantities for supplier items, organized and filtered by supplier, supplier site, and item. Additionally, any existing supplier item numbers are also listed.

Supplier On-Hand Quantities page in the Redwood user experience

Supplier On-Hand Quantities page in the Redwood user experience

To delete existing quantities, select the desired rows and click Delete.

Go to the On-hand Files page to upload supplier on-hand quantities, review existing supplier on-hand uploads, and download a file template to use for uploading data. Files in Failure or Partial Success status display the number of failed entries in the Failed column. Click the number link to view errors.

On-Hand Files page in the Redwood user experience

On-Hand Files page in the Redwood user experience

On-Hand File processing errors page in the Redwood user experience

On-Hand File processing errors page in the Redwood user experience

Click Download Template to retrieve the .csv file formatted with the necessary columns for uploading new on-hand quantities.

Click Upload to open the Upload file dialog, then drag your .csv or compressed (zip) .csv file containing on-hand quantities. You can change the file’s display name, if needed. After the file is uploaded, it will be processed asynchronously. Refresh the page to see the latest update and check its status.

Upload File dialog in the Redwood user experience

Upload File dialog in the Redwood user experience

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

To use the Manage Supplier On-Hand Quantities Using a Redwood Page feature, you must opt in to its parent feature: Supply Collaboration. If you’ve already opted in to this parent feature, then you don’t have to opt in again.

Follow these steps to enable or disable the Manage Supplier On-Hand Quantities Using a Redwood Page feature:

  1. In the Setup and Maintenance work area, search for and select the task Manage Profile Options for Supply Chain Collaboration.
  1. On the Manage Administrator Profile Values page, search for and select the ORA_VCS_SC_SUPPLY_DATA_PAGES_REDWOOD_ENABLED profile option code.
  1. In the Profile Values section, set the Site Level to Yes or No. The default value is No.
  • Yes = enables the feature
  • No = disables the feature
  1. Click Save and Close. Changes to the profile value will affect the users the next time they sign in.

After this feature is enabled, the navigation to the Supplier On-Hand Quantities pages using quick actions and the supply collaboration landing’s page panel task is updated to display Supplier On-Hand Quantities instead of Manage Supplier On-Hand Quantity.

Access Requirements

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

  • Manage Supplier On-Hand Quantities as Enterprise User (VCS_MANAGE_SUPPLIER_ONHAND_ENTERPRISE_PRIV)

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

  • Manage Supplier On-Hand Quantities as Supplier User (VCS_MANAGE_SUPPLIER_ONHAND_SUPPLIER_PRIV)

These privileges were available prior to this update.