8.1.59 (11-Apr-2025)

Fixed issue where Component Operation Sequence LOV was not allowing Operations from Primary Routing for Optional Components on Alternate Bills.

8.1.58 (10-Apr-2025)

Added ordering to the download.

8.1.57 (08-Apr-2025)

Improved the Operation Description download SQL.

8.1.56 (28-Mar-2025)

Removed the 'Extended Costs' columns.

8.1.55 (25-Mar-2025)

Internal update.

8.1.54 (04-Mar-2025)

Make Extended Qty column coloured as Display Only.

8.1.53 (04-Mar-2025)

Fixed Component Description is not populating with the download.

8.1.52 (28-Feb-2025)

Add Component ECO and ECO Status to the download in standard BOM mode.

8.1.51 (26-Feb-2025)

Add extended qty columns on the component section for Explode.

8.1.50 (18-Feb-2025)

Fixed the invalid identifier for Engineering Flag field in Engineering mode downloading.

8.1.49 (23-Jan-2025)

Corrected download error "SQLException: ORA-01427: single-row subquery returns more than one row".

8.1.48 (23-Jan-2025)

Corrected upload error "ORA-06550: line 18, column 127 PLS-00201:identifier L_DISABLE_DATE must be declared."

8.1.47 (22-Jan-2025)

Fixed additional issue identified in Component download.

8.1.46 (21-Jan-2025)

Fixed additional issue identified in Component download.

8.1.45 (21-Jan-2025)

Improved Component download SQL.

8.1.44 (31-Oct-2024)

Restricted Base Model column to BOM mode only.

8.1.43 (30-Oct-2024)

Corrected issue with Base Model not restricting downloads via form.

8.1.42 (29-Oct-2024)

Added Base Model column.

8.1.41 (22-Oct-2024)

Corrected new columns validation behaviour.

8.1.40 (18-Oct-2024)

Added better visualization of exploded data levels.

8.1.39 (16-Oct-2024)

Fixed bug where exploder was still not returning all data.

8.1.38 (15-Oct-2024)

Fixed bug where exploder was not returning all data.

8.1.37 (15-Oct-2024)

Added Default Browser Login option.

8.1.36 (01-Oct-2024)

Removed Inverse calculation and now uploads Qty per Usage if provided, otherwise uploads Inverse Usage.

8.1.35 (10-Jul-2024)

Restricted download of Operation Descriptions to respect Alternate.

8.1.34 (10-Jul-2024)

Restricted Operation LOV to include only similar Alternate operations.

8.1.33 (08-Jul-2024)

Fixed the explode issues while same components added onto assembly at different level.

8.1.32 (05-Jul-2024)

Corrected Operation LOV ordering.

8.1.31 (04-Jul-2024)

Improved downloading of Operation Descriptions.

8.1.30 (27-Jun-2024)

Corrected downloading of Operation Descriptions.

8.1.29 (27-Jun-2024)

Internal update.

8.1.28 (25-Jun-2024)

Internal update.

8.1.27 (24-Jun-2024)

Fixed the issue of common Assembly Query when item is multi segment.

8.1.26 (05-Jun-2024)

Fixed the issue where Explode by sheet seems to be missing some children parts.

8.1.25 (05-Jun-2024)

Internal update.

8.1.24 (13-Mar-2024)

Fixed the issue of the operation description when effective date is not current date.

8.1.23 (11-Mar-2024)

Internal update.

8.1.22 (11-Mar-2024)

Fixed the download issue when display all selected.

8.1.21 (05-Jan-2024)

Fixed the download issue when the ECO is not implemented.

8.1.20 (05-Jan-2024)

Fixed issue where the operation description is not displaying the current operation description on some lines.

8.1.19 (27-Nov-2023)

Fixed issue where an End to End Trace might not return the SQL statement's execution plan.

8.1.18 (10-Nov-2023)

Changed Upload to allow a yield greater than 1 with warning message.

8.1.17 (12-Oct-2023)

Made Attachment Sequence column mandatory.

8.1.16 (10-Oct-2023)

Fixed bug where Attachment Sequence was not being downloaded.

8.1.15 (12-Sep-2023)

Corrected divide by zero issues when Qty Per Assembly is zero.
Added new digital signature.

8.1.14 (07-Sep-2023)

Fixed error when running the install script: identifier 'M4APS_BMW_EXTENSION.EXTEND_BOM" must be declared.

8.1.13 (06-Sep-2023)

Corrected validation issue "[Assigned Operation] dependencies are invalid: Operation".

8.1.12 (30-Aug-2023)

Updated Assigned Operation Description validation to prevent descriptions being replaced with '-'

8.1.11 (29-Aug-2023)

Prevented API from creating partial Bills in certain circumstances.

8.1.10 (24-Aug-2023)

Removed validation on Enable Attributes Update which prevented updates to the Header section.

8.1.09 (16-Aug-2023)

Corrected validation issue with Unit Effective Components.

8.1.08 (16-Aug-2023)

Expanded messaging area on all forms to accommodate messages longer than a single line.

8.1.07 (15-Aug-2023)

Corrected validation caching issue on Alternate.

8.1.06 (04-Aug-2023)

Applied validation to Reference Designator to enforce 15 character limit.

8.1.05 (04-Aug-2023)

Corrected validation issue when neither Inverse Usage or Qty Per Assembly had been provided.

8.1.04 (04-Aug-2023)

Corrected functionality of Inverse Usage/Qty Per Assembly so that an entered Qty Per Assembly does not get defaulted back to 1.

8.1.03 (03-Aug-2023)

ENG mode: Fixed SQL error caused when Download by form with Component criteria.

8.1.02 (02-Aug-2023)

Fixed SQL errors when downloading from form and using Incl Other Components.

8.1.01 (01-Aug-2023)

Fixed download to respect the ribbon 'Incl Common Components' filter.
When 'Incl Common Components is set to No, the Wizard will download Components for Non-Common BOM and Common BOM where Attributes Update is enabled.

8.1.00 (21-Jul-2023)

Added Inverse Usage column to the Components section.

8.0.28 (20-Jul-2023)

Corrected Error-2147467259 (Expression must evaluate to a node-set.....)

8.0.27 (20-Jul-2023)

corrected download error following upload when only the header section exists.

8.0.26 (21-Jun-2023)

Corrected missing option to upload attachments

8.0.25 (21-Jun-2023)

Corrected header form field Alternate to allow multiple typed characters and increased message display area.

8.0.24 (13-Jun-2023)

Engineering mode: Corrected SQL error in Download form.

8.0.23 (08-Jun-2023)

Internal update.

8.0.22 (30-May-2023)

Internal update.

8.0.21 (30-May-2023)

Fixed the issues with [BLANK] functionality erroring on numeric fields.

8.0.20 (25-May-2023)

Changed Cost Type columns to Read only text box in the Component Cost form and Assembly Cost Type form.
Fixed the issue with Assembly Costs form not populating.

8.0.19 (18-May-2023)

Changed Cost Type columns to indicate they are display only on the template.

8.0.18 (17-May-2023)

Corrected initialization issue following an upload without Attachment columns.

8.0.17 (12-May-2023)

Moved Cost Type option LOV off the ribbon and into a separated form to eleviate performance issues.

8.0.16 (09-May-2023)

Internal update.

8.0.15 (02-May-2023)

Corrected extension package returned message not appearing on sheet.

8.0.14 (20-Apr-2023)

MNB mode: Corrected Component validation SQL.

8.0.13 (20-Apr-2023)

Corrected Enable Attribute Updates column during upload.

8.0.12 (19-Apr-2023)

Internal update.

8.0.11 (18-Apr-2023)

Corrected 'PLS-00103: Encountered the symbol "," when expecting one of the following:' error when creating a new BOM.

8.0.10 (14-Apr-2023)

ENG mode: Corrected download.

8.0.09 (14-Apr-2023)

RRB mode: Corrected VBA error when uploading.

8.0.08 (14-Apr-2023)

RRB mode: Corrected validation issue with Substitute Components.

8.0.07 (13-Apr-2023)

Corrected validation issue with Assigned Operation.

8.0.06 (13-Apr-2023)

Correct download SQL issue.

8.0.05 (11-Apr-2023)

Corrected issues when attempting to use modes containing columns not appropriate for the mode.

8.0.04 (04-Apr-2023)

Corrected ORA-00904: "ASSEMBLYEFF"."DECODE": invalid identifier during download.

8.0.03 (31-Mar-2023)

Updated Component & Substitute Component validation to no longer be restricted to only bom_enabled items.

8.0.02 (24-Mar-2023)

Corrected issue of not being able to open child forms after an upload.

8.0.01 (22-Mar-2023)

Engineering mode: Added Validate concurrent option.

8.0.00 (09-Feb-2023)

Bill of Materials mode: Added Validate Concurrent option.

7.2.36 (17-Jan-2023)

Fixed issue that caused large uploads to unexpectedly fail with error "438(Object doesn't support)".

7.2.35 (13-Jan-2023)

Fixed issue where trace files were not being generated.

7.2.34 (28-Nov-2022)

All modes: Improved 'New Effective From' validation performance.

7.2.33 (22-Nov-2022)

All modes: Added validation to New Effective From column to catch wrong (non date/time) data types.

7.2.32 (20-Nov-2022)

Internal update.

7.2.31 (16-Nov-2022)

Internal update.

7.2.30 (15-Nov-2022)

Bill of Materials mode: Added validation to prevent changing Effective From date/time on a Component of a Common Bill.

7.2.29 (07-Nov-2022)

All modes: Added 'New Effective From' column.

7.2.28 (02-Nov-2022)

Internal update.

7.2.27 (18-Oct-2022)

Fixed bug where Implode download was not returning Components.

7.2.26 (13-Oct-2022)

Engineering mode: Fixed error with Common BOM upload.

7.2.25 (12-Oct-2022)

All modes: Fixed issue where 'Enable Attributes Update' column could not be removed from sheet.

7.2.24 (05-May-2022)

Fixed issue where download by sheet was running a download based on empty lines and fixed issue with depreciated References.

7.2.23 (29-Sep-2022)

Internal update.

7.2.22 (27-Sep-2022)

Fixed issue where download splash form was automatically closing after download

7.2.21 (13-Sep-2022)

Internal update.

7.2.20 (15-Jun-2022)

All modes: Added Download Filter Limit Setting (Batchsizing).

7.2.19 (04-May-2022)

Internal update.

7.2.18 (07-Apr-2022)

Fix for One Drive saving issue by removing code from the on_save event.

7.2.17 (06-Apr-2022)

Internal update.

7.2.16 (06-Apr-2022)

Internal update.

7.2.15 (05-Apr-2022)

Internal update.

7.2.14 (01-Apr-2022)

Corrected tooltip spelling for URL Export/Import icon.

7.2.13 (01-Apr-2022)

Internal update.

7.2.12 (25-Mar-2022)

Internal update.

7.2.11 (16-Mar-2022)

Fixed issue where Wizard would not upload disabled components.

7.2.10 (09-Feb-2022)

All modes - Fixed bug in Common Bill validation where it was erroring incorrectly when both Common Organization and Common Assembly columns were blank.

7.2.09 (09-Feb-2022)

All modes - Fixed issue where children were not being downloaded during Explode.

7.2.08 (08-Feb-2022)

All modes - Fixed issue where common BOMS were being Uploaded in 11i.

7.2.07 (03-Feb-2022)

All modes - Fixed issue where download failed after implosion.

7.2.06 (03-Feb-2022)

All modes - Fixed issue with download Common BOM Attachments and added validation to prevent uploading Attachments for Common BOM.

7.2.05 (02-Feb-2022)

Std BOM, Engineering, Maintenance and Rebuildable Modes - Fixed bug with download in 11i.

7.2.04 (21-Jan-2022)

All Modes - Fixed issue with upload when Attributes are enabled.

7.2.03 (14-Jan-2022)

Security update for Custom Query.

7.2.02 (10-Jan-2022)

Fixed error when updating Component Basis Type.

7.2.01 (14-Dec-2021)

Internal update.

7.2.00 (13-Dec-2021)

Added the Engineering BOM mode.

7.1.59 (13-Dec-2021)

Removed concurrent upload as it didn't improve performance.

7.1.58 (01-Dec-2021)

Fixed Imploder to stop deleting duplicate occurrances.

7.1.57 (10-Nov-2021)

Corrected Reference Designator validation to error on Option class Component.

7.1.56 (01-Nov-2021)

Fixed incorrect Common BOMs being returned by Implode.

7.1.55 (11-Oct-2021)

Upgraded Extension Package and fixed bug where Extension Package status was not showing

7.1.54 (13-Sep-2021)

Internal enhancement.

7.1.53 (10-Sep-2021)

Allow inactive existing Components to be uploaded.

7.1.52 (10-Aug-2021)

Internal enhancement.

7.1.51 (04-Aug-2021)

Internal enhancement.

7.1.50 (21-Jul-2021)

Internal enhancement.

7.1.49 (17-Jun-2021)

Upload performance improvement.

7.1.48 (17-Jun-2021)

Upload performance improvement.

7.1.47 (11-Jun-2021)

Internal enhancement.

7.1.46 (09-Jun-2021)

Multilingual Improvement.

7.1.45 (02-Jun-2021)

Internal enhancement.

7.1.44 (01-Jun-2021)

Updated security.

7.1.43 (17-May-2021)

Changed the ribbon forms LOV to match the section order on the sheet.

7.1.42 (17-May-2021)

Internal enhancement.

7.1.41 (17-May-2021)

Internal enhancement.

7.1.40 (10-May-2021)

Fixed bug in Upload.

7.1.39 (21-Apr-2021)

Fixed bug where the Wizard would fail if profile "BOM:ITEM_SEQUENCE_INCREMENT" was not set.

7.1.38 (19-Apr-2021)

Internal enhancement.

7.1.37 (16-Apr-2021)

Updated security.

7.1.36 (15-Apr-2021)

Unified text size on forms.

7.1.35 (13-Apr-2021)

Fixed bug in background Upload process.

7.1.34 (07-Apr-2021)

Fixed bug in background process.

7.1.33 (07-Apr-2021)

Added Validate Concurrent (Background Processing).

7.1.32 (07-Apr-2021)

Internal enhancement.

7.1.31 (01-Apr-2021)

Updated security.

7.1.30 (30-Mar-2021)

Fixed bug where Inventory Org ctl on Header form(s) was not turning red when invalid.

7.1.29 (24-Mar-2021)

Fixed bug in WIP Supply Type validation where Wizard failed when value not in LOV.

7.1.28 (23-Mar-2021)

Internal enhancement.

7.1.27 (22-Mar-2021)

Bug fix on Common Component download.

7.1.26 (18-Mar-2021)

Bug fix on Include Cost Rollup Report column.

7.1.25 (11-Mar-2021)

Internal enhancement.

7.1.24 (11-Mar-2021)

Fixed validation overload bug.

7.1.23 (09-Mar-0021)

Updated security.

7.1.22 (09-Mar-2021)

Internal enhancement.

7.1.21 (04-Mar-2021)

Internal enhancement.

7.1.20 (04-Mar-2021)

Added functionality allowing the user to choose to create a report as part of a Cost Rollup.

7.1.19 (02-Mar-0021)

Updated security.

7.1.18 (26-Feb-2021)

Fixed bug where Patch 17774427 error message was occurring in R12.2 instances which have the patch as part of the release.

7.1.17 (18-Feb-0021)

Fixed bug with loading message in R11.

7.1.16 (16-Dec-2020)

Fixed bug where display only column Common Assembly description was being validated when uploading Attachments.

7.1.15 (02-Nov-2020)

Internal Update.

7.1.14 (28-Oct-2020)

Fixed bug with Revision Dates on the download form and made unfiltered form download the same as sheet download.

7.1.13 (27-Oct-2020)

Fixed bug with validation on Common Assembly and EnableAttrUpdate cols, where wrong Assembly was being returned in the error message.

7.1.12 (19-Oct-2020)

Fixed bug where couldn't Create Reference Designators on Upload.

7.1.11 (12-Oct-2020)

Fixed error when trying to Create Common Bills when 1 or more of (Common Assembly Org, Common Assembly, Enable Attributes Update) columns don't exist. Fixed bug where couldn't Create a Common BOM with Enable Attributes Update set to 'Yes'.

7.1.10 (07-Oct-2020)

Internal enhancement.

7.1.4 (17-Sep-2020)

Fixed bug where Download Form include Unimplemented Components filter was erratic.

7.1.3 (15-Sep-2020)

Fixed bug where Component Implemented Date was being overwritten with blank.

7.1.2 (14-Sep-2020)

Stopped unimplemented Components being Updated or Deleted.

7.1.1 (04-Sep-2020)

Fixed bug with Minimum Package Version Required error message.

7.1.0 (31-Aug-2020)

Added Explode and Implode by sheet functionality. Improved Error message. Fixed bug with Updating Attribute Enabled Common BOM. Updated Example Sheets.

7.0.6 (29-Jul-2020)

Fixed Reference Designator validation error in 11i.

7.0.5 (08-Jun-2020)

Updated security.

7.0.4 (15-Jun-2020)

Made BOM mode Component LOV return list of valid item s when Assembly is invalid.

7.0.3 (06-May-2020)

Fixed duplicate Component error for Unit effect BOMs in Bill of Material mode.

7.0.2 (24-Apr-2020)

Fixed error in Component validation when profile 'BOM:MANDATORY_ATO_IN_PTO' is not set.

7.0.1 (23-Apr-2020)

Fixed issue where small decimal number was uploading as Zero in Substitute Component Quantity column.

7.0.00 (25-Mar-2020)

New architecture.
Four new modes: Standard BOM, Asset BOM, Maintenance BOM, Rebuildable BOM.
Significant performance improvements and improved templating.
Improved validation for Common BOMs.
Upload Action changed where individual sections can be uploaded without uploading the entire hierarchy.
Error messages now prefixed to show their origin:
No prefix Wizard validation
API Error: Returned from API
E:} EXT PACKAGE MESSAGE: Returned from Extension package
Explode Download now returns disabled grandchildren only when display option is ‘All’.
Download filters added: Item Status, Include Bills with no assigned Category, Include Implemented Only Components.
Rebranding of logo and color scheme.

3.13.85 (18-Feb-2019)

Removed version number from Template Sheet as it updated post_Login and was always showing the previous version when first opened.

3.13.84 (15-Feb-2019)

Removed version number from Setup Sheet as it updated post_Login and was always showing the previous version when first opened.

3.13.83 (07-Feb-2019)

Fixed bug where Wizard would fail if Enable_Attributes_Update column removed when updating common BOM.
Added validation to test for Patch 17774427 which is needed to run upload of Common BOMs correctly.
Updated Sample Full Sheet to include column Enable_Attributes_update, and added an example of trying to upload a Common BOM without Patch 17774427.

3.13.82 (07-Jan-2019)

Reinstated Example sheets.

3.13.81 (07-Jan-2019)

Updated Custom Query and Core Version/Date.

3.13.80 (21-Dec-2018)

Fixed error with BasisType validator not recognizing sheet value.

3.13.79 (19-Dec-2018)

Fixed upload Attachment error.

3.13.78 (14-Nov-2018)

Fixed error handling bug in Download Form Startup

3.13.77 (11-Oct-2018)

Updated security.

3.13.76 (04-Sep-2018)

Updated security.

3.13.75 (03-Sep-2018)

Added R12 column 'Enable Attributes Update' when commoning BOM's.

3.13.74 (07-Aug-2018)

Fixed bug where Required to Ship and Inc On Ship Doc fields not uploading.

3.13.73 (07-Aug-2018)

Fixed bug where Upload and Header form errored when Common BOM not found and Child Section is off sheet.

3.13.72 (27-Jul-2018)

Fixed bug with changing Effectivity Dates.

3.13.71 (03-Jul-2018)

Updated security.

3.13.70 (19-Jun-2018)

Fixed overwritten date on Download form when Imploding.

3.13.69 (19-Jun-2018)

Fixed problem with date being overwritten.

3.13.68 (19-Jun-2018)

Fixed problems on Download form and Download selected, where if new date entered via calendar, it was wrong date format for Implode.

3.13.67 (11-Jun-2018)

Added ability to download UnImplemented/Pending Components on ECO's.

3.13.66 (01-Jun-2018)

Internal updates.

3.13.65 (08-May-2018)

Fixed the issue where getting error "Target attachment record ID does not exist in Oracle" sometimes when uploading the attachment for a new created BOM.

3.13.64 (04-May-2018)

Internal update.

3.13.63 (13-Apr-2018)

Updated security.

3.13.62 (13-Apr-2018)

Fixed Default Effective From date not being written to sheet on upload.

3.13.61 (21-Mar-2018)

Fixed bug where "Cannot find required column header 'Effective From'" was being shown when Assembly_Item_type = 1 (Asset Group) and Effective_From column removed from sheet (valid scenario).

3.13.60 (08-Mar-2018)

Fixed bug in Download by Sheet where, if Item was listed more than once on the sheet it returned error "This key is already associated with an element of this collection".

3.13.59 (02-Mar-2018)

Fixed bug where valid Assembly was erroring as invalid.

3.13.58 (02-Mar-2018)

Reinstated the ability to remove the Effective From column when using Asset Group BOMs which use UnitNumber Effectivity.

3.13.57 (16-Feb-2018)

Updated Download Wizard.

3.13.56 (02-Feb-2018)

Fixed the issue where getting the error message Error 457 (This key is already associated with an element of this collection) during the login.

3.13.55 (22-Dec-2017)

Fixed the issue where opening attachment form failed when trying to open the form on a section without Attachment section.

3.13.54 (19-Dec-2017)

Fixed the issue where opening attachment form and 'Upload Selected Attachments' blow up if no BOM Header data for current select row and row 10 is blank.

3.13.53 (18-Dec-2017)

Internal update.

3.13.52 (18-Dec-2017)

Fix for bug when opening the Header form with an invalid item.

3.13.51 (15-Dec-2017)

Internal update.

3.13.50 (15-Dec-2017)

Added function to upload all attachments after uploading the BOM data.
Added 'Upload Selected Attachments' on the ribbon toolbar to upload all attachments for all selected parent.

3.13.49 (08-Dec-2017)

Fixed bug on frmDownload where Assembly was needed to do an Implode.

3.13.48 (24-Oct-2017)

Fixed bug where Component Revisions were only returning the first Revision found.

3.13.47 (19-Oct-2017)

Internal update.

3.13.46 (17-Oct-2017)

Added Component Revision column.

3.13.45 (28-Sep-2017)

Added Processing form to Download to stop ability to open new sheet/Wizard/form in current session.

3.13.44 (15-Sep-2017)

Changed the functionality around Mandatory Effective_From column.

3.13.43 (14-Sep-2017)

Made the Effective_From column mandatory if downloading Component data.

3.13.42 (08-Sep-2017)

Updated Package information.

3.13.41 (06-Sep-2017)

Internal update.

3.13.40 (06-Sep-2017)

Internal update.

3.13.39 (05-Sep-2017)

Fixed bug where Wizard expecting locator when locator control is at item level.

3.13.38 (28-Aug-2017)

Fixed bug where uploading attachment failed if no description column or no title column in the spreadsheet.
Fixed bug where uploading URL attachment failed.

3.13.37 (25-Aug-2017)

Changed text validation to allow 32000 characters. Previously was 4000.

3.13.36 (23-Aug-2017)

Fixed Download error on 64bit XLS 2016. Cell contents were being copied into every cell across the entire row.

3.13.35 (23-Aug-2017)

Fixed invalidation of Component DFF Context field.

3.13.34 (23-Aug-2017)

Added [BLANK] functionality to DFFs.

3.13.33 (18-Aug-2017)

Internal update.

3.13.32 (04-Aug-2017)

Fixed Supply Locator error.

3.13.31 (26-Jul-2017)

Fixed bug where Component level DFF context was not being uploaded.

3.13.30 (25-Jul-2017)

Internal update.

3.13.29 (20-Jul-2017)

Fixed bug in Component form.

3.13.28 (18-Jul-2017)

Fixed bug to stop separators being downloaded into the locator column when there should be no locator data. This bug was introduced in version 3.13.27.

3.13.27 (17-Jul-2017)

Changes made to better support the Locators flexfield.
Now resolves Project and Task values (previously IDs were shown) and supports false delimiters.

3.13.26 (10-Jul-2017)

Updated Custom Query ribbon.

3.13.25 (10-Jul-2017)

Updated Download Wizard.

3.13.24 (10-Jul-2017)

Fixed Wizard from erroring when Attach Title column removed from sheet.

3.13.23 (07-Jul-2017)

Fixed DFF issue.

3.13.22 (05-Jul-2017)

Added Attribute5 column into Template123 sheet.

3.13.21 (04-Jul-2017)

Fixed BOM Component form. Stopped Download (Form and Sheet) returning BOMs for Orgs outside Responsibility i.e. Now if Org not in LOV, no download.

3.13.20 (03-Jul-2017)

Fix to stop Wizard trying to validate Components when they are not on the sheet.

3.13.19 (30-Jun-2017)

To alter Assembly LOV to reflect Oracle men functions ie Manufacturing, EAM and Engineering.

3.13.18 (26-Jun-2017)

Altered Get Locators function to show Project and Task.

3.13.17 (22-Jun-2017)

Added the full Template123 sheet back into Wizard.

3.13.16 (13-Jun-2017)

Added checks for columns removed from sheet.

3.13.15 (08-Jun-2017)

Fixed attachment issue. Now able to load Attachments for standard or EAM BOMs.

3.13.14 (07-Jun-2017)

Fixed From_Unit_Number removal from sheet when opening form.

3.13.13 (06-Jun-2017)

Updated security.

3.13.12 (22-May-2017)

Fixed error message on Validate Unit From Number to read better.

3.13.11 (12-May-2017)

Fixed validation error on upload of EAM Asset Group BOMs, where FromUnitNumber was being loaded as ToUnitNumber on Create.
Added BOM_Enabled_Items and EAM_Item_Types filters to Component LOV.

3.13.10 (01-May-2017)

Fixed validation error on Upload of EAM Asset Activity BOMs.

3.13.09 (01-May-2017)

Improved Component form performance around Unit Numbers.

3.13.08 (28-Apr-2017)

Improved EAM Asset Group validation performance.

3.13.07 (13-Apr-2017)

Stopped Wizard trying to Explode when Assembly name has % in it.

3.13.06 (11-Apr-2017)

Removed 'New_From_End_Unit_Number' cbo from frmBomComponents To_End_Item_Number. Is no longer a required field.

3.13.05 (11-Apr-2017)

Further fix to 'End_Item_Unit_Number' validation.

3.13.04 (03-Apr-2017)

Updated security.

3.13.03 (28-Mar-2017)

Fixed 'Enforced Integer Requirements' upload.

3.13.02 (28-Mar-2017)

Fixed 'End_Item_Unit_Number' validation.

3.13.01 (21-Mar-2017)

Changed Component form behaviour for easier use and better performance.

3.13.00 (16-Mar-2017)

Fixed validation problem(s) with EAM Asset Activity BOMs.

3.12.99 (07-Mar-2017)

Fixed problem(s) with FromEndItemUnitNumber upload.

3.12.98 (07-Mar-2017)

Updated security.

3.12.97 (27-Feb-2017)

Updated Downloader module.

3.12.96 (22-Feb-2017)

Fixed problem where uploading multiple BOMs resulted in only those up to the First Delete_Group being validated properly.

3.12.95 (21-Feb-2017)

Cleaned Extension package.

3.12.94 (17-Feb-2017)

Added functionality, where if either Min or Max = [BLANK] then both = [BLANK], if one of them is off the sheet it now errors.

3.12.93 (17-Feb-2017)

Fixed update problem when [BLANK] entered into MinOrdQty or MaxOrdQty cols which are of type Number.
Stopped Validation on display only 'Shipping Allowed' column.

3.12.92 (15-Feb-2017)

Changed how data is returned from Extension to Package to ensure all rows returned.

3.12.91 (08-Feb-2017)

Added Extension Package functionality.
Added the Profile Option 'More4Apps: BMW Enable Extension Pkg'.

3.12.90 (17-Jan-2017)

Now setting Language on Login: Language for the user is now being set from user's EBS preferences irrespective of what is chosen on the Browser Login page.

3.12.89 (12-Dec-2016)

Fixed Download form when validating Orgs and NO BOMs are against Org which was causing error 9999.

3.12.88 (09-Dec-2016)

Internal update.

3.12.87 (07-Dec-2016)

Updated Downloader modules.

3.12.86 (06-Dec-2016)

Modified Currency conversion type SQL in Cost Roll Up process to fix issue when some customers have a different setup to normal.

3.12.85 (21-Nov-2016)

Fixed bug where a one segment Key Flexfield that contains a false delimiter will return an 'Invalid Combination' message.

3.12.84 (21-Nov-2016)

Fixed templating problem when Downloading/Exploding to new sheet.

3.12.83 (10-Nov-2016)

Fixed issue with multi-lingual Yes/No fields.

3.12.82 (07-Nov-2016)

Fixed issue where the Basis Type column would cause an error in the 11i instances.

3.12.81 (04-Nov-2016)

Fixed Download form error when trying to use Org with no Max_BOM_Level set.

3.12.80 (01-Nov-2016)

Removed Operation Pull restriction from Components form.

3.12.79 (14-Oct-2016)

Changed functionality of Exploder. Explode now defaults ‘Alternate’ to 'Primary' if not defined instead of error message.

3.12.78 (13-Oct-2016)

Added checks to ensure Org, Assembly and Alternate are defined for Explode.

3.12.77 (13-Oct-2016)

Changed the placement of the error message for Exploder to before the Download.

3.12.76 (12-Oct-2016)

Changed functionality to now download by Org only or Assembly only.

3.12.75 (11-Oct-2016)

Fixed error when no Inv Org specified for Exploder.

3.12.74 (10-Oct-2016)

Fixed error with New Effective From Upload.

3.12.73 (07-Oct-2016)

Reinstalled Template123 sheet.

3.12.72 (07-Oct-2016)

Correct New Effective From validation.

3.12.71 (06-Oct-2016)

Added New Effective From Date functionality. New Effective From date cannot be before the current db date/time.

3.12.70 (01-Sep-2016)

Updated Downloader modules.

3.12.69 (16-Aug-2016)

Fixed Upload issue with committing changes to 'Required To Ship' and 'Inc On Ship Docs' fields for Assembly Item Types of PTO and ATO.

3.12.69 (16-Aug-2016)

Fixed Upload issue when committing changes to 'Required Top Ship' and 'Inc On Ship Docs' fields for Assembly Item Types of PTO and ATO.

3.12.68 (16-Aug-2016)

Modified sheet printout to better show next BOM when exploding a range of BOMs.

3.12.67 (25-Jul-2016)

Fixed the background colour of Assembly to become yellow when Assembly validated.

3.12.66 (25-Jul-2016)

Changed the Download form to print the Unexploded Components before the Exploded Components.

3.12.65 (21-Jul-2016)

Changed the Exploder on the Download form to match the Exploder using Sheet data.

3.12.64 (11-Jul-2016)

Imported new downloader code (version 1.0.51) to fix compile error that occurs on some Windows 7 machines.

3.12.63 (06-Jul-2016)

Fixed bug where only Global Data Elements were being exposed by the DFF.
Fixed bug where No Header DFF was being uploaded under any circumstances.

3.12.62 (14-Jun-2016)

Fixed Download form Explode error.

3.12.61 (23-May-2016)

Updated security.

3.12.60 (20-May-2016)

Added Attachment and Sequence columns to Attachments.

3.12.59 (12-May-2016)

Fixed Exploder. Revisions had an issue where the latest revision wasn’t being downloaded.

3.12.58 (06-May-2016)

Fixed Upload issue where upload would fail on customer sites due to package callers.

3.12.57 (06-May-2016)

Fixed Download selected imploder.
Fixed From End Item Unit Number Error. When blank was throwing an error.

3.12.56 (05-May-2016)

Improved upload when Shipping Allowed was included in the spreadsheet.

3.12.55 (03-May-2016)

Added Implode via Download Selected.

3.12.54 (30-Mar-2016)

Added in Basis Type column.

3.12.53 (18-Mar-2016)

Updated security.

3.12.52 (03-Mar-2016)

Updated security.

3.12.51 (26-Feb-2016)

Modified Create Only Profile Option access code.

3.12.50 (10-Feb-2016)

Added Create Only Profile Option.
Added Support for EAM.
Added Implemented column.

3.12.49 (12-Jan-2016)

Added ability to Modify Common BOMs on upload.

3.12.48.7 (15-May-2017)

Fixed issue where users are being logged in with the wrong language.
Further Information: In EBS 12.2 a framework patch has stopped us from being able to select a language in the browser login page.
To work around this problem the language for the user is now being set from user's EBS preferences irrespective of what is chosen on the Browser Login page.

3.12.48 (03-Dec-2015)

Fixed Form Open Error when organization invalid.
Fixed component form defaulting to Assembly Pull when bulk supply type.
Fixed issue with Downloader with European Decimal format.

3.12.47 (05-Nov-2015)

Fixed Debug Upload LOV not showing an option when opening the wizard

3.12.46 (04-Nov-2015)

Fixed excel 2003 issue caused by the workbooks styles.
Updated Security.

3.12.45 (28-Oct-2015)

Fixed applying quantities to BOM's where there was quantities valid and setting to 0 it was failing

3.12.44 (22-Oct-2015)

Changed Exploder to put correct implementation date into exploded data, rather than sysdate

3.12.43 (21-Oct-2015)

This stops the Min and Max Ord Qty being Upload when there is nothing on the sheet.
Added code to delete from BOM_explosion_temp.
Changed download sql for explosion to reference bill sequence id correctly for components.
Concatenated parent item number to download level field.

3.12.42 (21-Oct-2015)

Fixed min/max qty's using long and uploading 0 instead of null

3.12.41 (21-Oct-2015)

Fixed exploder not working for R12 and exploder not in the correct order

3.12.40 (15-Oct-2015)

Added ability to specify a blank Minimum and Maximum Order Quantities

3.12.39 (13-Oct-2015)

Added ability to update Minimum and Maximum Order Quantities

3.12.38 (12-Oct-2015)

Updated Security

3.12.37 (09-Oct-2015)

Fixed bug with min and max quantities not loading

3.12.36 (05-Oct-2015)

Added Debug Upload Option In Ribbon

3.12.35 (07-Sep-2015)

Added explode level to improve ability to work out components, sub components etc

3.12.34 (01-Sep-2015)

Updated Download Wizard Functionality

3.12.33 (28-Aug-2015)

Added Download Wizard Functionality

3.12.32 (29-Jul-2015)

Re-Enabled Download button when the user chooses a date/time in the download selected form

3.12.31 (22-Jul-2015)

Fixed bug in component form causing error in costing code if component not already on the sheet.
Added assemblies to item cache. Added database data/time finder to cache as well to reduce database hits.

3.12.30 (09-Jul-2015)

Stopped user from exploding items via download selected when item has a wildcard.
Fixed issue with comments mandatory field not yellow in user form.
Fixed download to new sheet for explosion putting data in row 9.

3.12.29 (09-Jul-2015)

Fixed issue where user could open other forms during download process

3.12.28 (07-Jul-2015)

Fixed bug where explode button is available without an Assembly in the download form.

3.12.27 (07-Jul-2015)

Technical infrastructure update

3.12.26 (07-Jul-2015)

Updated Security

3.12.25 (11-Jun-2015)

Added in caching of item number details to speed up loading process

3.12.24 (09-Jun-2015)

Technical infrastructure update

3.12.23 (18-May-2015)

Added support for component extended cost.
Fix to missing alias on BOM_lists table causing XML errors.

3.12.22 (15-May-2015)

Added support for component make buy flag and based on cost rollup within the costing information section

3.12.21 (28-Apr-2015)

Added ability to limit users to validate only via profile option

3.12.20 (09-Apr-2015)

Fixed bug where Supply locator wasn’t being updated form a blank value unless a shipping column was provided

3.12.19 (06-Apr-2015)

Fixed bug where Substitute components wouldn't download unless Assigned Operation Section on the sheet

3.12.18 (25-Mar-2015)

Download Form bug - List of values for categories does not correspond to category set
Changed procedure kffLocal.CategoryKFF.
Structure was not being set to the passed in structure (CatFlexStructureID).
The structure was only being set once on initialisation of the Flexfield.
Moved code (kffCategory.StructureID = CatFlexStructureID) outside of the if statement.

3.12.17 (09-Mar-2015)

Reordered Right-click Menu order to match toolbar

3.12.16 (19-Dec-2014)

Changed procedure GenINVsupport.Get_Current_Item_Details.
Fixed bug where check for multiple item segments in most cases the Wizard only filtered on segment1 with the complete Concatenated String.
Changed procedure kffStructure.getSegmentSQLFilterAndBinds

3.12.15 (15-Dec-2014)

Changed procedure AppMain.Post_login_events. Added call to DumpFlexFields.
The KFFs were not being re-initialised on login.
Meaning when changing from instance A to B. The wizard changed procedure kfflocal.DumpFlexFields.
Fixed bug where call to reset AssemblyKFF had the wrong number of parameters.
Added central error handler.
Changed procedure kffSegmentSQL.TableBasedLovSQL. Changed the select clause. If no ID column is provided.
This fixes a bug in the KffForm.tableOrSpecialLOV.
Changed procedure kffSegmentSQL.TableBasedLovSQL. Fixed bug which would have shown from the KFF form.
Changed procedure KFFForm.tableOrSpecialLOV. Added code to replace :NULL in $FLEX$.???:NULL. valueSet.
Changed procedure kffForm.IsParentSelected. Removed parent enabling/disabling for Item flexfields.

3.12.14 (01-Dec-2014)

Changed core to 2.10

3.12.13 (06-Nov-2014)

Fixed Excel 2003 Compile error in hidden module: AppMain

3.12.12 (06-Nov-2014)

Changed get current item details to work when no user item type defined

3.12.11 (04-Nov-2014)

Fixed Wizard doing update when it should have ignored a row due to blank supply subinv

3.12.10 (22-Oct-2014)

Fixed unhandled error going to components form when revisions do not exist for the item

3.12.09 (20-Sep-2014)

Changed item validation for single segment item key flexfield to tie back to segment1 to improve performance

3.12.08 (20-Sep-2014)

Changed component form to check if EAM so units load correctly.
Fixed bug in download form, if user hasn't got access to the last used org then the form provides better error handling.

3.12.07 (15-Aug-2014)

Added in profile option to restrict user access on Validate Commit

3.12.06 (15-Aug-2014)

Changed end unit fields to not be mandatory if not an EAM org.
Changed imploder to default implementation date upon download.
Fixed download form not putting date in the correct format when changing revisions.

3.12.05 (14-Aug-2014)

Changed the way the shipping flags worked as they didn't upload correctly for a customer.
Changed shipping allowed to be an information only field since it is controlled at the item.

3.12.04 (10-Aug-2014)

Added compare ribbon option

3.12.03 (25-Jul-2014)

Fixed bug causing common BOM loads to fail if more than one BOM being loaded at a time

3.12.02 (23-Jul-2014)

EBS 12.2 fix Long_to_char for long_to_char sql errors caused by table based validation sets.
Core 209 imported.
DFFmod.Search_Value_Set_ID sql updated for 12.2

3.12.01 (16-Jul-2014)

Added in Type of control checks for Effective From and To dates in module. BomComponentInfo as dependence on the days and months were being swapped around randomly.
On startup of frmBomComponents added in. Text when setting the database date to the control which sets the date formats correctly.

3.12.00 (27-May-2014)

Added in download criteria by category/category set and added columns to spreadsheet

3.11.06 (27-May-2014)

Updated common code

3.11.05 (22-Apr-2014)

Fixed bug with ambiguous column on msi.Eng_item_flag missing msi

3.11.04 (28-Jan-2014)

Fixed bug with include in cost rollup not updating

3.11.03 (28-Jan-2014)

Changed execute to not use vba true/false and hard code "TRUE"/"FALSE" for NLS translation

3.11.02 (28-Jan-2014)

Fixed bug where Wizard expected Enforce Integer Column to exist when it is optional

3.11.01 (28-Jan-2014)

Added Support for Enforce Integer Requirements

3.11.00 (28-Jan-2014)

Added exploder functionality to download selected from worksheet.
Fixed bug where user presses upload with no records affecting row 9.

3.10.05 (28-Jan-2014)

Fixed a ribbon error which wasn't displaying menu toolbar buttons in 2010/2007 when saved as xls format.
Icon for application mode in toolbar/menu now displayed as a coloured flag.

3.10.04 (23-Jan-2014)

Fixed bug in components form where Date from/to selected by calendar wasn't updating the worksheet

3.10.03 (23-Dec-2013)

Fixed bug where delete ref des wasn't working.
Fixed delete groups not working for components.

3.10.02 (05-Dec-2013)

Added imploder function to the Wizard

3.10.01 (26-Nov-2013)

Minor fix for Ribbon/Toolbar bug on selecting Rollup Costs.
Ribbon code update.
Attachments added to ribbon/toolbar menu.

3.10.00 (21-Nov-2013)

Added attachment functionality.
Fixed bug where new components for a BOM default to today’s date even if the spreadsheet already has a date.
Fixed bug where reference quantity was being ignored.

3.9.21 (04-Oct-2013)

Added error handling to download areas.
Updated common modules to 204.12

3.9.20 (17-Aug-2013)

Made upload selected and download selected public subs for 3rd party macros

3.9.19 (17-Jul-2013)

Stopped wizard ending with unhandled exception when implementation date column missing.
Stopped Header from erasing a new revision if you revalidate the item.

3.9.18 (02-Jul-2013)

Key Flexfield upgrade

3.9.17 (16-May-2013)

Fixed bug with select common Assembly not working correctly.
Changed get item cost sql as grouping not required.
Fixed bug where yield is a required field.
Fixed DFF's not loading when user resp is not a BOM application responsibility.
Changed enforcement of future dated components to be No if profile option is null.
Changed new operation validation to be done after getting sequence id for the component.

3.9.16 (02-May-2013)

Changed downloader to allow where used to work where component could also be a common BOM component

3.9.15 (18-Apr-2013)

Fixed bug with revision label in assembly header form not taking value from spreadsheet.
Updated invalid location error message to say locator has invalid material status.
Fixed bug where wizard didn't clean out BOM lists.
Fixed component effectivity bug where components were not converting dates correctly.

3.9.14 (29-Mar-2013)

Fixed bug with download changes where bom won't download if operation codes are not found.
Fixed issue with subinv/locator not being able to be nulled out.

3.9.13 (18-Mar-2013)

Fixed bug with get component dates not validating minutes correctly.
Updated download where used to only use the routing operation effective at the date/time of the download.
Added in functionality for substitute components, by default the substitute quantity equals the component quantity.

3.9.12 (13-Mar-2013)

Changed wizard to allow the same item with same item sequence and same operation with different dates to be loaded.
Fixed bug when loading cut down trying to load wip supply type = 0 instead of null.

3.9.11 (30-Jan-2013)

Fixed bug where subinv and locator values couldn't be set to NULL

3.9.10 (30-Jan-2013)

Added functionality to allow users to assign reference designators in one cell in the form AA, BB, CC as individual designators.
Fixed bug in download form where it would error if a where used component not selected.

3.9.9 (25-Jan-2013)

Added functionality to derive current item sequence if operation and item numbers provided.
Added functionality to allow download of multiple items within a BOM so the entire BOM doesn't have to be downloaded.
Fixed BOM header form bug erroring when selecting a revision.

3.9.8 (10-Jan-2013)

Fixed issue where invalid component causing rest of BOM not to be validated

3.9.7 (10-Jan-2013)

Applied fixes to effectivity date code not validating correctly
Fixed bug in operation listing where alternates were not taken into about in the user form

3.9.6 (10-Jan-2013)

Changed effectivity dates past due to use a profile rather than enforced value.
Included new profile option to allow item sequence to use unused sequences within the operation list when doing an update. By default this is not used.
Rebuilt Component Validation to use object for data loads to improve performance and validation.
Fixed issue with operations for alternates not working correctly.

3.9.5 (10-Dec-2012)

Fixed issue where effective end date couldn’t be null’d out
Fixed issue where Wizard would allow end dates for past dates

3.9.4 (02-Nov-2012)

Changed component form, when changing source subinv it revalidates the locator or clears it out if subinv not locator controlled.

3.9.3 (06-Nov-2012)

Fixed issue with, based decimal separators for getting Oracle release version and cost details
Added form defaulting in the components to the default supply type when it is a new component for a BOM and profile option BOM: Default WIP Supply Values for Components is set to Yes

3.9.2 (10-Oct-2012)

Fixed issue where component date not defaulting on a new BOM component line.
Added functionality to set the defaulting of component dates to be the same for all line lines to use the same value, which is set when the header is loaded.

3.9.1 (10-Oct-2012)

Updated download selected to use common error handler

3.9.0 (06-Sep-2012)

Ribbons added.

3.8.9 (05-Sep-2012)

Updated common code for connectivity

3.8.8 (03-Sep-2012)

Updated common modules ready for new toolbar

3.8.7 (06-Jun-2012)

Fixed exploder level download being ignored.
changed the download form to use system date as the current date rather than the last revision implementation date.

3.8.6 (06-Jun-2012)

Changed download selected to allow download options of all, future & current and current.

3.8.5 (05-Jun-2012)

Updated common modules, now supports 64bit Excel

3.8.4 (02-Apr-2012)

Fixed download assembly LOV not working when instances don’t have earn_item_typeset to 0, 1 or 2

3.8.3 (01-Mar-2012)

Fixed download form exploder issue

3.8.2 (05-Dec-2011)

Added security for EAM BOMs so you can only load them if you have forms access.
Fixed issue where levels below component forms would not load.

3.8.1 (17-Nov-2011)

Fixed issue with validate new BOM not allowing operation to be blank.

3.8.0 (17-Nov-2011)

Added support for EAM BOMs.
Added in defaulting item sequences when creating a new BOM or adding an item that doesn’t exist to an existing BOM.
Fixed issue with supply type and subinv not Null valuing correctly.

3.7.11 (05-Nov-2011)

Added effectivity date to the download from form functionality.
Fixed issue where Assy item type not showing in exploded download.

3.7.10 (02-Nov-2011)

Added User item type to the Wizard assembly, component, substitute items.

3.7.9 (26-Aug-2011)

Fixed download from s/sheet not working on cut down worksheet
Fixed bug where download form sets errors around revision on the s/sheet

3.7.8 (03-Aug-2011)

Added in functionality to explode to a certain level.
Changed information only fields to color cells in light grey to make find/replace easier.

3.7.7 (05-Jul-2011)

Fixed small bug with upload when toggling messages on/off at time of upload.
Fixed download common BOM duplicating components from multiple organizations.
Fixed download from s/sheet downloading BOMs from orgs user does not have access to.

3.7.6 (30-Jun-2011)

Fixed component form not allowing a change to planning percent when an option class.
Added in disable form functionality while form is loading.

3.7.5 (01-Jun-2011)

Fixed assigned component double up issue with insert statement.
Fixed bug where reference designator not checked for option class BOMs.

3.7.4 (23-May-2011)

Updated get component details loop to stop when a match found this helps improve validation speeds.

3.7.3 (12-May-2011)

Updated common modules to fix XML validation errors.
Updated exploder to work for engineering items.

3.7.2 (06-May-2011)

Fixed when ‘Upload entire Worksheet’ selected, it did not skip the already loaded and ‘Accepted’ BOMs.
Fixed issue where the download form not defaulting the alternate setting.
Fixed substitute components downloading on the wrong line.
Fixed issue where toggle between records on substitute form not working.
Fixed issue on components form where substitute components button could not be selected.

3.7.1 (29-Apr-2011)

Added substitute component functionality. Added Assigned Operation Description.
Added check to make sure duplicate components, assigned ops and reference designators fail when validating.
Added version number showing on Wizard form.

3.6.7 (30-Mar-2011)

Fixed bug in exploder where it was always returning the latest implemented revision rather than at the date/time specified in the exploder.
Added in ability to view operation description not just number.
Changed width of operation column to handle operation numbers in the form of up to 5 characters.
Fixed upload error message if next BOMs first line had an error when loading multiple BOMs on one page.

3.6.6 (11-Feb-2011)

Fixed conditional format issue causing wizard to not save and crash.
Improved error handling for assigned operations.
Changed trial functionality to logout after trial upload.
Fixed issue where adding a new component and ref des doesn’t upload ref des.
Fixed issue where you could assign the same operation at the assignment as the component.
Changed icon when in both Eng and MFG mode, instead of showing as engineering
Fixed upload error where wizard tries to create a new revision when the referenced revision is not implemented.
Fixed delete assigned units not working.
Fixed bug where validate assigned operations not checking the BOM type when uploading.
Fixed validation issue where wizard was not caching Assembly and component information when loading reference designators, causing a slow down in processing time

3.6.5 (26-Jan-2011)

Changed get subinventories to only call database when item is subinventory restricted, otherwise caching values from Assembly.
Added download based on spreadsheet data functionality.

3.6.4 (24-Jan-2011)

Fixed issue where null costed component translating into ‘no’ rather than taking the item default.

3.6.3 (14-Jan-2011)

Fixed issue where choosing assembly to in download form presenting error message screen.
Issue fixed with new bom reference designators not loading on an already created Bill of material.
Updated generic packages to fix issue where large BOMs would not load.
Fixed security to check to allow validation but not upload if user doesn’t have access to BOM or ENG bill of materials form.

3.6.2 (14-Jan-2011)

Fixed issue where form wouldn’t allow you to check delete ref des.
Fixed ref des form writing description to the wrong field.
Stopped default cost info writing on the wrong row when opening ref des or assigned units form.

3.6.1 (20-Dec-2010)

Fixed issue with revision prev date when opening form and no BOM existing causing type mismatch.

3.6.0 (05-Dec-2010)

Changed Ref des and components to use object rather than record code.
Changed menu options to allow update only mode.
Changed menu to have validate and validate commit options.

3.5.1 (05-Nov-2010)

Infrastructure change invalidated exploder functionality, fixed this issue.

3.5.0 (05-Nov-2010)

Added support for Additional Assigned Operations functionality.
Fixed issue with Mutually exclusive looking at component BOM type not header BOM type.

3.4.9 (05-Nov-2010)

Changed mutually exclusive validation to not just on API as it was ignoring the value in the API
Changed download to do full initialize so column definitions are reset

3.4.8 (23-Sep-2010)

Fixed Defaulting effectivity date not putting time portion in for components for some customers.
Fixed bug where max order quantity defaulting in components form.

3.4.7 (07-Sep-2010)

Fixed issue where minimum and maximum order quantity’s being populated with a value when a standard bom.
Created user friendly error message when BOM has more levels than setup in oracle causing exploder to fail.
Fixed download issue where if you download a range of bills on a sheet with BOMs it was overwriting some of them.
Changed the cost functionality in the BOM header to be just a list of values.
Fixed issue where min and max order qty’s not downloading.
Made change to qty related reference designators to check the total count including those for the component not being uploaded at the time.
Allowed min/max order qtys for non model and option BOMs.

3.4.6 (20-Aug-2010)

Added functionality to accept updates to subinventory and locator with the value NULL.

3.4.5 (20-Aug-2010)

Fixed issue where reference designator form not loading if not on a component line.
Removed writing of component/assy description at the wrong level.
Fixed ref des loading against the incorrect component.

3.4.4 (20-Aug-2010)

Added functionality to accept updates to supply type with the value NULL.

3.4.3 (20-Aug-2010)

Fixed bug in components upload not accepting null date.
Fixed ref des bug treating deletion as part of the reference designator quantity.
Fixed bug in component form erroring when selecting components.
Fixed issue where change to qty related BOM not updating the component level.
Stopped Effective To date from being enterable in the form if the field is not on the spreadsheet.

3.4.2 (09-Aug-2010)

Updated ref des validate to work when delete group column missing.
Fixed bug in ref des validator switching invalid ref des to valid when validating delete refdes flag.

3.4.1 (23-Jul-2010)

Created work around for bom exploder where it returns an assembly twice when a DFF exists.

3.4.0 (23-Jul-2010)

Added in display only field to show if engineering item.
Added in functionality to allow the deletion of reference designators.
Rewrote part of the validation for refdes and components.
Updated downloader to look at eng item flags.

3.3.17 (17-Jul-2010)

Changed Wizard so Alternate and Effective to dates are no longer required.

3.3.16 (08-Jul-2010)

Fixed issue with Option class erroring for model BOMs.
Fixed problem with option component not returned in item where clause.
Adding component to a BOM was always using sysdate not the effective date.
Fixed download with wild card doing a between when the assy from = assy to causing no records to return.
Changed downloader to check to see if it is in the middle of a BOM, if so then move the download to the end of it.

3.3.15 (08-Jul-2010)

Added functionality to allow engineering and manufacturing items to be loaded at the same time when in engineering mode.
Added validation to check if engineering item at BOM header.
Added in DFF validation at line level before load as API allows invalid DFFs to be loaded.
Added Engineering flag on BOM header form.

3.3.14 (18-Jun-2010)

Fixed download component ignoring components without wip supply type.
Changed download assembly removed adding wild card when defaulting assembly.
Updated setup sheet.
Added shipping_allowed component attribute to be updated.

3.3.13 (28-Mar-2010)

Improved users ability to enter a negative quantity in components form.
Changed delete group component to ignore lines where delete group is null.
Fixed issue when doing upload selected range leaving error status when load successful.
Fixed issue with MFG_lookups being used, affecting 11.5.9 or lower.
Fixed issue with end dated component effectivity date not converting correctly when checking if the component exists.
Changed cancel message to stop all processing so all subsequent bills do not load.

3.3.12 (18-Mar-2010)

Improvements to toolbars and right-click menus.

3.3.11 (10-Mar-2010)

Fixed error message showing when delete group load was successful.
Routing revision label from current revision not showing correctly.
Changed download when items are between to look at which item is larger and change the between statement to suite.
Fixed component data not updating when you zoom to reference designator form.

3.3.10 (04-Mar-2010)

Master Org Delete Groups missing from delete group LOV, these are now included.
Fixed Bug in Header form where Org code being removed when you press OK button.
Fixed issue where revision information not writing to the sheet when selecting components form.
Changed revision form to disable revision description and label if the columns don’t exist.
Fixed download common components functionality not downloading correctly.

3.3.9 (02-Mar-2010)

Added common code for Right-click and toolbar handling.

3.3.8 (25-Feb-2010)

Fixed duplicate bind issue when downloading current BOM.
Fixed download not building revision cbo box correctly.

3.3.7 (16-Feb-2010)

Fixed issue in validate Yes/No fields not returning message correctly.
Fixed download exploder setting cell where revision description not existing.

3.3.6 (16-Feb-2010)

Fixed invalid validation where wizard was not effective end dated correctly
Fixed issue with european language date and decimal place issues.
Added functionality so if the effective start date is missing on an existing BOM it automatically populates it.
Fixed issue where upload message colour changing not correct

3.3.5 (02-Feb-2010)

Fixed invalid validation where wizard was not checking maximum qty for optional components correctly.
Fixed issue where up/down scrolling not updating the component details.
Fixed issue where minimum/maximum optional qty not allowed to be negative.

3.3.4 (26-Jan-2010)

Fixed download issue where reference designators does not exist trying to reference designator column.

3.3.3 (26-Jan-2010)

Removed Original System Reference Required Column
Updated validation of yield to default 1 when it is null.
Added validation on yield to check it is a number

3.3.2 (22-Dec-2009)

Fixed bug with cost types not choosing based on the current organization.
Added support for 11.5.7 not handling MSC ATP flag.

3.3.1 (22-Nov-2009)

Updated forms to fix Excel 2007 issue causing the spreadsheet to grow in size each time the form is opened.
Fixed bug where alternate BOMs couldn’t be exploded.
Fixed bug in update/create of common items.
Removed requirement of delete BOM header group column in spreadsheet.
Updated forms to fix excel 2007 issue causing the spreadsheet to grow in size each time the form is opened.
Fixed bug where alternate BOMs couldn’t be exploded.
Fixed bug in update/create of common items.
Removed requirement of delete BOM header group column in spreadsheet.

3.3.0 (04-Nov-2009)

Fixed bug where 11.5.9 stopped working.
Changed upload cancel to use user exception.
Fixed issues around how the BOM header loads.

3.2.9 (21-Oct-2009)

Fixed bug where supply type not changing colour when LOV is incorrect.

3.2.8 (17-Sep-2009)

Fixed component form lov on new operation not set to red when invalid.
Updated ref des continue to ok.

3.2.7 (14-Sep-2009)

Message for reference designator qty on wrong line.
Reference designators not loading for alternate fixed.
Template hide/show not functioning, now fixed.

3.2.6 (14-Sep-2009)

Updated toolbar logins to use the new standard and alternate options.

3.2.5 (07-Jul-2009)

Bug in components form not bringing back assembly UOM or description.
Bug in ref des form not bringing back assembly UOM.

3.2.4 (07-Jul-2009)

Changed download functionality to allow alternate only, also allowed users to choose all alternates as an option.

3.2.3 (23-Jun-0200)

Fixed issue where error message going into implementation date.

3.2.2 (22-May-2009)

Added unit of measure display details for assembly and component.

3.2.1 (22-Apr-2009)

Fixed issue where getting the system date was not working correctly.

3.2.0 (04-Apr-2009)

Technology change to use Bind Variables in many of the SQL calls, helps reduce Database cache requirements.
Fixed bug where status message Error appearing in the wrong column.

3.1.2 (04-Feb-2009)

Fixed bug with spin up going above line 10 Added Cache of spin and form zoom of assembly and component details to speed form performance

3.1.1 (03-Feb-2009)

Fixed bug with get_sys_date when using decimals and different countries Fixed bug in validate components where if component wasn’t found it had type mismatch Added spin buttons to all forms and form zoom buttons Added in dff zoom button on forms

3.1.0 (22-Jan-2009)

Fixed download components issue with dates Changed component validation to use componentloaddetails
Changed bom header validation for implementation date into validate BOM rather than load BOM
Reimported GenSupport and MFGSupport, changed way the call to get sysdate works

3.0.7 (06-Aug-2025)

Added form reference for COMPONENT_SEQUENCE_ID to fix the DFF download issues.

3.0.5 (17-Dec-2008)

Updated Download date format for Long dates to work for multiple countries and languages

3.0.4 (26-Nov-2008)

Updated More4Apps Connection to oracle apps module Updated Components form to not make Wip supply type mandatory

3.0.3 (03-Nov-2008)

Fixed right mouse click menu. So it doesn’t persist after the BOM has closed

3.0.2 (25-Sep-2008)

Fixed Bug where reference designators were not loading due to date issues when loading the components

3.0.0 (02-Sep-2008)

Updated gensupport and invsupport modules
Added in new activation key functionality and modules

2.6.7 (12-Aug-2008)

Fixed bug where download common assembly description not returned

2.6.6 (08-Aug-2008)

Fixed bug in when returning effectivity control
Fixed trapping when org code is invalid when user uses component form
Updated frmUserProfile

2.6.5 (04-Aug-2008)

Fixed bug in get_organization_id where myubound not incl the last org

2.6.4 (07-Jul-2008)

Fixed subinventory bug in load_components, causing the load to fail

2.6.3 (01-Jul-2008)

Fixed but in exists_exact_component where numeric record type wipsupplytype in componentinfo was being set to “NULL”

2.6.2 (07-Jun-2008)

Fixed issue with cost_type download sql not returning values
Updated download to multi-language date compatible. ie French April is AVR rather than APR

2.6.1 (30-May-2008)

Fixed issue with exploder not working
Changed download to return revision from form rather than the max revision found if the revision is set by the user

2.6.0 (26-May-2008)

Updated Components form to provide better validation for Option class, models and planned BOMs
Updated verification, loaded, failed functionality to reject count the BOMs, not the lines in the BOM

2.5.0 (14-May-2008)

Added in multilingual functionality for table calls where a _vl exists.
Updated download to allow from row 10 instead of 11

2.4.0 (01-May-2008)

Added in functionality to return cost information back to the spreadsheet. Updated header and components and download functionality for costing.
Fixed bug in download where common BOM information was not being downloaded. Fixed std and exploder downloaders.
Fixed download issue where alternate sometime blank on first download.
Updated get operations to check to see if the alternate routing exists, if so then use the alternates operations, if not then use the primary operations to validate/list from.
Fixed issue in bOM header where implementation date could be less than item revision date.
Added in New Operation functionality so operation sequences can be changed as per std form functionality.
Updated form bomheader so it provides default down load details
Updated form bomheader to allow user to choose the costing type
Updated form download to allow user to choose the costing type
Updated form download to allow the user to choose if they want to download to a new sheet

2.3.2 (12-Mar-2008)

Fixed issue with toolbar repositioning caused by Excel 2007
Fixed issue where toolbar DFF’s show when no DFF’s exist
Fixed BOM Header not working correctly for common bills of material

2.3.1 (11-Mar-2008)

Changed upload method to use a temp table for both large and small BOMs

2.3.0 (05-Mar-2008)

Added in functionality for Engineering note this does not include ECO reference information.
Added in functionality to default assembly, common assy and component descriptions as information only fields

2.2.5 (01-Mar-2008)

Removed additional information not needed in alternate LOV.
Fixed reference designator issue where item sequence was not properly referenced.
Fixed download issue where alternate list box not giving options when default assy exists

2.2.4 (12-Feb-2008)

Fixed issue where ‘Effective’ To date was not being loaded

2.2.3 (08-Feb-2008)

Fixed issue where get operations was looking at alternate for routing too, should always look at Primary routing not alternate.
Fixed issue where apostrophe couldn’t be used for reference designatorsFixed issue where download form wasn’t defaulting to future and current.

2.2.2 (04-Feb-2008)

Key flexfield form was not writing selected Assembly values back to fields in download form

2.2.1 (03-Feb-2008)

Stop program writing to back sheet unnecessarily on opening spreadsheet

2.2.0 (24-Jan-2008)

Upgraded DFF module
Fixed issues with variables not correctly defined, causing compile issue
Fixed download DFF issue with variables
Fixed common modules build rec call not working correctly for NULL values
Fixed date comparison where the day was the key driver rather than year first then month then date in download form cboassembly revision
Fixed error where upload all BOMs wasn’t being executed.
Get explosion data dff variables issues not fixed in issue #2 above.
Fixed issue with licence form
Fixed issue with save when creating toolbars
Fixed issue with ATP and component qty < 1 and a decimal failing validation

2.1.8 (29-Dec-2007)

Updated comments for explode, OK and Cancel buttons in download sheet
Added in ability to reload BOM if it errors so you don’t have to manually delete error messages.
Moved toolbar code to it’s own module, created MFGsupport module for RTG and BOM common code. Moved more4apps generic stuff to GenSupport module.
Updated download functionality to show users where the download is up to.
Fixed error when alternate is blank the form was not populating ‘Primary’ and upload would error due to operation not existing.
Bug with delete group at assembly stopping the load of new BOMs.

2.1.7 (20-Dec-2007)

Fixed Load_Bom bug with assembly delete group check at component level, wizard bombs if delete group field is missing
Updated comments for explode, OK and Cancel buttons in download sheet
Added in ability to reload BOM if it errors so you don’t have to manually delete error messages.
Moved toolbar code to it’s own module, created MFGsupport module for RTG and BOM common code. Moved more4apps generic stuff to GenSupport module.
Updated download functionality to show users where the download is up to.
Fixed error when alternate is blank the form was not populating ‘Primary’ and upload would error due to operation not existing.
Bug with delete group at assembly stopping the load of new BOMs.

2.1.6 (05-Dec-2007)

Fixed explosion bug where it stopped working due to using PL/SQL extend functionality
Added in download memory of previous queries.
Added in functionality to clear old messages before uploading – TO BE COMPLETED.

2.1.5 (05-Dec-2007)

Fixed bug where delete group ignored where there were multiple reference designators
Added download functionality to allow the user to choose the latest or current revision not just the revision from the list.
Changed explosion program to reference session ID and delete from temp table after explosion.

2.1.4 (01-Dec-2007)

Fixed download functionality to download by effective date rather than revision if downloading assembly from – to

2.1.3 (16-Nov-2007)

Added in delete group functionality
Changed sql for component SQL as it was incorrect
Added xxxinfo = empty to the start of assembly, component and ref des calls
Changes to load sql so the record number is generated in the PL/SQL rather than in vb, this allows ignore rows to be loaded (however not currently done as BOM API seems to work fine without them)

2.1.2 (12-Nov-2007)

Added in where used component functionality to the download form

2.1.1 (07-Nov-2007)

Removed requirement for common BOM columns on the wizard.
Updated bug in query explosion where it used the sysdate rather than the implementation date
Fixed bug in get top_comp_line where it was looking at the BOM top line.
Changed download form to only allow assembly command button and assembly to details if the assembly field has been entered.
Changed revision to use a list of values in the BOM header form. This allows users to modify BOMs that are destined for a future date.
Fixed bug where upload BOM expected a supply type to exist, however this is an optional field and should not be required.
Updated download to change the implementation date based on the revision date. So the date of the download lines up with the revision

2.1.0 (01-Nov-2007)

Fixed choose organization form not handling org’s starting with a 0 (zero)
Fixed common assembly issue where it was putting the description in the assembly field
Added Ability to download an Exploded Bill of Material
Changed choose org form, removed revert/cancel button and enforced the org combo box, ie you must choose a value
Added in functionality to main form where if the org code is invalid they must choose a new org code before the rest of the activate form fires
Fixed common assembly issue where it was putting the description in the assembly field
Added Bom Explosion Functionality to download Module

1.1.5 (06-Jun-2007)

Added toggle messages button, to allow users to not show the pop up error messages.
Fixed issue with the error message cancel button not cancelling the load

1.1.3 (02-May-2007)

Changed Download form to Allow partial item number for Downloading Assemblies.
Also updated the select Assembly for validation to only provide a list of items that have a bill of material.
Updated Download process to allows multiple Bills of Material to be loaded instead of just one

1.1.2 (12-Apr-2007)

Changed the checking of existence of refdes to use component_sequence_id as it was doing a full table scan.
Fixed bug where a ref des changes for a component, but the component does not change and it would try to do an update causing the oracle API to error with no changes allowed.
Fixed bug in load BOM where the component and refdes record sequences were going out of sync.
Changed download, now downloads date and time for component effective dates
Moved std more4apps utilities/calls to module M4ApsUtilities

1.1.1 (10-Apr-2007)

Fixed BOM header bug where it automatically chose the first item if it was a new BOM being created.
Fixed download form not returning revision description
Updated download form to download Yes and No instead of Y or N to the sheet to stay consistent with when the user uses the form

1.1.0 (19-Mar-2007)

Fix for timeout problem caused by Internet Explorer 7
Updated component kff to reference location kff differently to remove ambiguous sql statement

1.0.9 (13-Feb-2007)

Updated BOM header form to load the choose org form when no org has been defined. Useful for the very first time wizard is used.
Update the error messages to be more user friendly

1.0.8 (01-Feb-2007)

Update components form layout to be clearer
Updated flex modules bug fixes

1.0.7 (29-Jan-2007)

Upgraded Key flexfield module
Included descriptive flexfields in code
Rebuilt download module to include flexfields
Locator functionality now working in the form

1.0.6 (24-Nov-2006)

Removed upload all providing feed back as each BOM is loaded
Turned public subs into functions so only toolbars show

1.0.5 (24-Nov-2006)

Download not downloading to the second, change build_sql statement

1.0.4 (23-Nov-2006)

Fixed issue with download of reference designators

1.0.3 (09-Nov-2006)

Created first release to public