Download Ribbon Filters

The Bill of Materials Ribbon has download parameters and filters that are used for both ‘Download via Form’ and ‘Download using Sheet Data’ downloads.

Display Option - The List of Values contains (Current, Current and Future, All).

This works in conjunction with the ‘Effective Date’ field on the Ribbon and allows you to filter the download based on Current, Current and Future or All.

Note: Downloading with the Display Option of ‘All’ may return Components that have been end dated, and/or Components pertaining to Operations that have been end dated in the Routing, these may be invalid for uploading.

Effectivity Date - This works in conjunction with the ‘Display Option’ and allows you to restrict the download to Bills/Revisions/Components that are active according to the ‘Display Option’ selected, at the Effective Date/time selected. The Effective Date/time is set by the Wizard at Login to be the current date/time and will remain for the duration of the session unless changed by the user. Click on the icon to change the date.

Include Common Components – If two or more organizations manufacture the same item using the same bill of materials, you can define the bill in one organization and reference it from the other organizations. Necessary changes must then be made only to the referenced bill. Oracle shows the components of the referenced bill for the common bill. The ‘Include Common Components’ filter gives the user the option to match the EBS form and show the referenced components (Yes) or not download Components that cannot be uploaded (No). The exception to the rule that “common components belong to the referenced bill” is: In R12 if the ‘Enable Attributes Update’ flag is set to yes, a copy of the components is applied to the common bill, so that certain material control attributes (Operation, Supply Type, Supply Subinventory, Supply Locator) can be updated to reflect the needs of the common organization. These components will be downloaded even when the ‘Include Common Components’ filter is No.

Cost Type Option - The list of values contains all Cost Types defined in the organization. Click on the icon to select the cost type you wish to download. The default cost type is ‘Frozen’.

Include Costs - Yes/No List of Values. This allows you to have a Cost Type set but not download it. The default is No.