Version 3.7.8 (03-Aug-2011)
Added in functionality to explode to a certain level
changed information only fields to colour cells in light grey to make find/replace easier. |
 |
Version 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 too.
Version 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
Version 3.7.5 (01-JUN-2011)
Fixed bug where reference designator not checked for option class boms
Fixed assigned component double up issue with insert statement.
Version 3.7.4 DJW (23-May-2011)
Updated get component details loop to stop when a match found this helps improve validation speeds.
Version 3.7.3 (12-May-2011)
Updated common modules to fix XML validation errors
Updated exploder to work for enginering items.
Version 3.7.2 (6-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 sustitute form not working.
Fixed issue on components form where substitute components button could not be selected.
Version 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.
Version 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.
Version 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
Version 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.
Version 3.6.4 (24-Jan-2011)
Fixed issue where null costed component translating into 'no' rather than taking the item default.
Version 3.6.3 (14-Jan-2011)
Fixed issue where chosing 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.
Version 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
Version 3.6.1 (20-Dec-2010)
Fixed issue with revision prev date when opening form and no bom existing causing type mismatch
Version 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
Version 3.5.1 (05-Nov-2010)
Infrastructure change invalidated exploder functionality, fixed this issue.
Version 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.
Version 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.
Version 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
Version 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.
Version 3.4.6 (20-Aug-2010)
Added functionality to accept updates to subinventory and locator with the value NULL.
Version 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.
Version 3.4.4 (20-Aug-2010)
Added functionality to accept updates to supply type with the value NULL.
Version 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.
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-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.
Version 3.3.12 (18-Mar-2010)
Improvements to Toolbars and Rightclick Menus
Version 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.
Version 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.
Version 3.3.9 AMG (02-Mar-2010)
Added common code for Right-click and Toolbar handling
Version 3.3.8 (25-Feb-2010)
Fixed duplicate bind issue when downloading current Bom.
Fixed download not building revision cbo box correctly.
Version 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.
Version 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.
Version 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
Version 3.3.4 (26-Jan-2010)
Fixed download issue where reference designators does not exist trying to reference designator column.
Version 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
Version 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
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-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
Version 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.
Version 3.2.9 (21-Oct-2009)
Fixed bug where supply type not changing colour when LOV is incorrect.
Version 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.
Version 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.
Version 3.2.6 (14-Sep-2009)
Updated toolbar logins to use the new standard and alternate options
Version 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.
Version 3.2.4 (07-Jul-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-Apr-2009)
Fixed issue where getting the system date was not working correctly
Version 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
Version 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
Version 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.
Version 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.
Version 3.0.5 (17-Dec-2008)
Updated Download date format for Long dates to work for multiple countries and languages.
Version 3.0.4 (26-Nov-2008)
Updated More4Apps Connection to oracle apps module Updated Components form to not make Wip supply type mandatory
Version 3.0.3 (03-Nov-2008)
Fixed right mouse click menu. So it doesnt persists after the BOM has closed
Version 3.0.2 (25-Sep-2008)
Fixed Bug where reference designators were not loading due to date issues when loading the components.
Version 3.0.0 (02-Sep-2008)
Updated gensupport and invsupport modules
Added in new activation key functionality and modules
Version 2.6.7 (12-Aug-2008)
Fixed bug where download common assembly description not returned
Version 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
Version 2.6.5 (04-Aug-2008)
Fixed bug in get_organization_id where myubound not incl the last org
Version 2.6.4 (07-Jul-2008)
Fixed subinventory bug in load_components, causing the load to fail
Version 2.6.3 (01-Jul-2008)
Fixed but in exists_exact_component where numeric record type wipsupplytype in componentinfo was being set to "NULL"
Version 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
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.
Version 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.
Version 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.
Version 2.2.4 (12-Feb-2008)
Fixed issue where 'Effective' To date was not being loaded
Version 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
Version 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.
Version 2.3.1 (11-Mar-2008)
Changed upload method to use a temp table for both large and small boms
Version 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
Version 2.2.2 (4-Feb-2008)
Key flexfield form was not writing selected Assembly values back to fields in download form
Version 2.2.1 (3-Feb-2008)
Stop program writing to back sheet unnecessarily on opening spreadsheet
Version 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
Version 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.
Version 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.
Version 2.1.6 (5-Dec-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-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.
Version 2.1.4 (1-Dec-2007)
Fixed download functionality to download by effective date rather than revision if downloading assembly from - to.
Version 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 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-Nov-2007)
Added in where used component functionality to the download form.
Version 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.
Version 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
Version 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.
Version 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.
Version 1.1.2 (12-Apr-2007)
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 (0-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
Version 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.
Version 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
Version 1.0.8 (01-Feb-2007)
Update components form layout to be clearer
Updated flex modules bug fixes
Version 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
Version 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
Version 1.0.5 (24-Nov-2006)
Download not downloading to the second, change build_sql statement
Version 1.0.4 (23-Nov-2006)
Fixed issue with download of reference designators
Version 1.0.3 (9-Nov-2006)
Created first release to public
Version (1.0.2)
This is the first beta release
