One of the most powerful features of the Bill of Materials Wizard is the ability to extract/download information from Oracle Bill of Materials tables and use it as the basis for a new Bill of Materials, or update an existing Bill of Materials.
There are three methods provided by Routing Wizard to download existing information into your worksheet from Oracle:
·Method 1 - Use aDownload Formwhich provides multiple criteria for you to target the required Bills.
·Method 2 - Use theDownload using Sheet Dataoption and enter multiple criteria into your worksheet to download based on the data entered.
·Method 3 – Use theCustom Query Ribbon. This feature allows users to run pre-defined queries created by their Administrators where they are assigned to the same Oracle Responsibility being used in the Wizard.
Note -Download using sheet data, filters the data downloaded by the default Category Set and excludes Items with no assigned Category Set. Downloading by Form, by default, filters the same, however this can be changed by the user.