Introduction:
The Oracle Visual Builder Add-in for Excel connects Excel spreadsheets with REST services, enabling you to retrieve, analyze, and edit business data directly from the service. You can download data into an Excel spreadsheet, make modifications, and then upload your changes back to the service.
Cause of the issue:
Utilizing the “Oracle Visual Builder” add-in to clear a large number of inventory transactions that are stuck in the interface table due to incorrect sub inventory locations of the items. This approach allows us to integrate the Staged Transactions REST API with Excel, enabling the download of errored transactions from the Manage Pending Inventory Transactions screen. These transactions can then be updated in bulk and re-uploaded to the cloud, streamlining the process and significantly reducing the workload compared to the traditional method of manually clearing each record.
How do we solve:
To efficiently update bulk inventory transactions stuck in the interface table in Oracle Fusion, you can use the Oracle Visual Builder Add-in for Excel.
Step 1 : Download & Install Add-in
Download the Oracle Visual Builder add-in from the official Oracle website and install it on Excel.
Step 2: Setup in Excel
Open Excel, navigate to the Oracle Visual Builder tab, and use the Designer option to add the web address of the staged transactions.
Sign in to your Oracle application and configure the settings by selecting Inventory Staged Transactions and the Table Layout.
Step 3: Query & Filter
In the Query tab, customize your filter fields (e.g., organization name, item number) to focus on the pending transactions.
Step 4: Download Data
Download the filtered data into Excel for editing.
Step 5: Update & Upload
Make necessary updates in Excel and upload the changes back to Oracle Fusion.
Step 6: Verify in Oracle Fusion
Check the Manage Pending Transactions screen in Oracle Fusion to ensure the updates are reflected.
Step 7: Schedule Process
Add the updated transactions to the schedule process and run “Manage Inventory Transactions” to clear pending items.
Note: Please refer to the attached document for detailed steps
updating-bulk-records-pending-under-inventory-transactions-using-oracle-visual-builder
Conclusion:
By utilizing the Oracle Visual Builder add-in, we can efficiently update a large volume of pending inventory transactions directly within Excel. After making the necessary changes, the modified data can be easily re-uploaded to Oracle Fusion. This method significantly reduces the workload and time required compared to the traditional approach of manually updating each record individually within the system.
