Redwood: Manage Receiving Transaction Interface Records Using a Spreadsheet

Certain business processes or integration designs require that you create receipts using REST services or file based data import (FBDI). When creating receipts using these methods, there's always a chance that small mistakes in the data cause records to not process and remain in the receiving interface. If this happens, you need the ability to review these error records, correct the data, and then resubmit them for processing. Now you can manage your existing receiving transaction interface records with a predefined spreadsheet template that's configured using the Oracle Visual Builder Add-in for Excel.

Select the Download Receiving Receipt Interface Records in Spreadsheet and Download Receiving Transaction Interface Records in Spreadsheet tasks to download the excel sheets containing pending transactions in the  receiving interface table.

Receiving Receipt Interface Records in Spreadsheet

Receiving Receipt Interface Records in Spreadsheet

Receiving Transaction Interface Records in Spreadsheet

Receiving Transaction Interface Records in Spreadsheet

This feature provides you the ability to efficiently review and manage the receipt records present in the receiving interface.

Steps to Enable

Follow these steps to enable or disable this feature:

  1. In the Setup and Maintenance work area, search for and select the Manage Administrator Profile Values task.
  2. On the Manage Administrator Profile Values page:
  • To use the Redwood Reservations page, search for and select the ORA_RCV_RECEIVING_INTERFACE_RECORDS_IN_SPREADSHEET_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 in the profile value will affect users the next time they sign in.

Tips And Considerations

Download the latest version of Oracle Visual Builder Add-in for Excel.

Key Resources

  • 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 duty roles can access this feature:

  • Review Receiving Open Interface (RCV_REVIEW_RECEIVING_OPEN_INTERFACE_PRIV)

This privilege was available prior to this update.