Version 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.
Version 3.4.1 23-Jul-2010
Created work around for bom exploder where it returns an assembly twice when a DFF exists.
Version 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
Version 3.3.17 17-Jul-2010
Changed wizard so Alternate and Effective to dates are no longer required.
Version 3.3.16 8-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 cauing 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
Version 3.3.15 8-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 valiation at line level before load as API allows invalid DFFs to be loaded.
Added Engineering flag on bom header form.
Version 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.
Version 3.3.13 28 March 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.
Version 3.3.12 18 March 2010
Improvements to Toolbars and Rightclick Menus
Version 3.3.11 10 March 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.
Version 3.3.10 04 March 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.
Version 3.3.9 AMG 02 March 2010
Added common code for Right-click and Toolbar handling
Version 3.3.8 25 February 2010
Fixed duplicate bind issue when downloading current Bom.
Fixed download not building revision cbo box correctly.
Version 3.3.7 16 February 2010
Fixed issue in validate Yes/No fields not returning message correctly
Fixed download exploder setting cell where revision description not existing.
Version 3.3.6 16 February 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.
Version 3.3.5 02 February 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
Version 3.3.4 26 January 2010
Fixed download issue where reference designators does not exist trying to reference designator column.
Version 3.3.3 26 January 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
Version 3.3.2 22 December 2009
Fixed bug with cost types not choosing based on the current organization.
Added support for 11.5.7 not handling MSC ATP flag
Version 3.3.1 22 November 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
Version 3.3.1 22 November 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
Version 3.3.0 04 November 2009
Fixed bug where 11.5.9 stopped working
Changed upload cancel to use user exception
Fixed issues around how the bom header loads.
Version 3.2.9 21 October 2009
Fixed bug where supply type not changing colour when LOV is incorrect.
Version 3.2.8 17 September 2009
Fixed component form lov on new operation not set to red when invalid.
Updated ref des continue to ok.
Version 3.2.7 14 September 2009
Message for reference designator qty on wrong line
Reference designators not loading for alternate fixed.
Template hide/show not functioning, now fixed.
Version 3.2.6 14 September 2009
Updated toolbar logins to use the new standard and alternate options
Version 3.2.6 14 September 2009
Updated toolbar logins to use the new standard and alternate options
Version 3.2.5 07 July 2009
Bug in components form not bringing back assembly UOM or description.
Bug in ref des form not bringing back assembly UOM.
Version 3.2.4 07 July 2009
Changed download functionality to allow alternate only, also allowed users to choose all alternates as an option
Version 3.2.3 23 June 2009
Fixed issue where error message going into implementation date
Version 3.2.2 22 May 2009
Added unit of measure display details for assembly and component
Version 3.2.1 22 April 2009
Fixed issue where getting the system date was not working correctly
Version 3.2.0 04 April 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
Version 3.1.2 04 February 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
Version 3.1.1 03 February 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
Version 3.1.0 22 January 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.
Version 3.0.5 17 December 2008
Updated Download date format for Long dates to work for multiple countries and languages.
Version 3.0.4 26 November 2008
Updated More4Apps Connection to oracle apps module Updated Components form to not make Wip supply type mandatory
Version 3.0.3 03 November 2008
Fixed right mouse click menu. So it doesnt persists after the BOM has closed
Version 3.0.2 25 September 2008
Fixed Bug where reference designators were not loading due to date issues when loading the components.
Version 3.0.0 02 September 2008
Updated gensupport and invsupport modules
Added in new activation key functionality and modules
Version 2.6.7 12 August 2008
Fixed bug where download common assembly description not returned
Version 2.6.6 08 August 2008
Fixed bug in when returning effectivity control
Fixed trapping when org code is invalid when user uses component form
Updated frmUserProfile
Version 2.6.5 04 August 2008
Fixed bug in get_organization_id where myubound not incl the last org
Fixed subinventory bug in load_components, causing the load to fail
Version 2.6.3 01 July 2008
Fixed but in exists_exact_component where numeric record type wipsupplytype in componentinfo was being set to "NULL"
Version 2.6.2 07 June 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
Version 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
Version 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
Version 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.
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.
Version 2.2.3 08 February 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.
Version 2.2.4 12 February 2008
Fixed issue where 'Effective' To date was not being loaded
Version 2.2.5 01 March 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
Version 2.3.0 05 March 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.
Version 2.3.1 11 March 2008
Changed upload method to use a temp table for both large and small boms
Version 2.3.2 12 March 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
Version 2.2.2 4 February 08
Key flexfield form was not writing selected Assembly values back to fields in download form
Version 2.2.1 3 February 08
Stop program writing to back sheet unnecessarily on opening spreadsheet
Version 2.2.0 24 January 08
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
Version 2.1.8 29 December 07
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.
Version 2.1.7 20 December 07
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.
Version 2.1.6 5 December 07
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.
Version 2.1.5 5 December 07
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.
Version 2.1.4 1 December 07
Fixed download functionality to download by effective date rather than revision if downloading assembly from - to.
Version 2.1.3 16 November 07
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 allow's ignore rows to be loaded (however not currently done as bom api seems to work fine without them).
Version 2.1.2 12 November 07
Added in where used component functionality to the download form.
Version 2.1.1 07 November 07
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.
Version 2.1.0 01 November 07
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
Version 1.1.5 06 June 07
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.
Version 1.1.3 02 May 07
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.
Version 1.1.2 12 Apr 07
Changed the checking of existance 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
Version 1.1.1 10 Apr 07
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
Version 1.1.0 19 Mar 07
Fix for timeout problem caused by Internet Explorer 7
Updated component kff to reference location kff differently to remove ambiguous sql statement.
Version 1.0.9 13 Feb 07
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
Version 1.0.8 01 February 2007
Update components form layout to be clearer
Updated flex modules bug fixes
Version 1.0.7 29 January 2007
Upgraded Key flexfield module
Included descriptive flexfields in code
Rebuilt download module to include flexfields
Locator functionality now working in the form
Version 1.0.6 24 November 2006
Removed upload all providing feed back as each bom is loaded
Turned public subs into functions so only toolbars show
Version 1.0.5 24 November 2006
Download not downloading to the second, change build_sql statement
Version 1.0.4 23 November 2006
Fixed issue with download of reference designators
Version 1.0.3 9 November 2006
Created first release to public
Version 1.0.2
This is the first beta release