Excel Integration for Oracle Cloud PLM

Excel Integration for Oracle Cloud PLM allows you to integrate and update search, BOMs, AMLs and change creation. With our ingenious integration solution between Microsoft Excel and Oracle Cloud PLM, this can ultimately help Product Teams save time and generate value.

 excel_integration_oracle_cloud_thumb

Excel Integration for Oracle Cloud PLM

Highlights

 
Search & Update
  • Execute PLM Search from within Excel
  • Associate Oracle Cloud Search with a sheet
  • Modify required attributes and Update to Oracle Cloud
BOM / AML
  • Get BOM and AML in Excel
  • Update BOM or AML
  • May create new BOMs from the excel sheet

Updating Data to Oracle Cloud PLM

 

By clicking on “Update Current Sheet Data” you can simply open a change configuration window.

Imported Oracle Cloud PLM Search

 

The columns are displayed like they are configured in Oracle Cloud PLM. There are no limitations on what kind of columns can be imported.

Exporting Data to Oracle Cloud PLM

 

After the update, the Change in Oracle Cloud PLM has the Item added to its Affected Items tab. It now has a new description and it’s change controlled attribute is redlined.

Importing BOM from Oracle Cloud PLM

Multiple BOMs can be pulled at the same time by providing a comma separated list of item numbers.

Updating BOM

After the update, the Change has been created and the Item has been added to the Affected Items. The change in quantity in the BOM has also been redlined.

Importing BOM from Oracle Cloud PLM

 

Multiple BOMs can be pulled at the same time by providing a comma separated list of item numbers.

Importing AML from Oracle Cloud PLM

 

Multiple AMLs can be pulled at the same time by providing a comma separated list of item numbers.

 

 

Updating AML

After the update, the change has been created and the item has been added to the affected items. The deletion of the manufacturer has been shown in the redlines.

Updating All

 If all of the sheets opened in Excel are saved searches, BOMs or AMLs, and need to be added to a single Change Order, then you can go ahead and click Update All.

Contact us today to schedule a demo!