Package Body Version - This is the product packages included in the current version of the wizard. The Minimum version (shown in brackets) is the lowest version of the package required to enable the wizard to function.
Wizard Version
|
2.2.11 (10-Nov-2011)
|
|
Package Body Version
|
1.2.3 (Minimum 1.2.3) |
-
Fixed delete group operations not loading subsequent delete groups.
Version 2.2.10 (21-Oct-2011)
Fixed delete group operations not loading.
Version 2.2.9 (10-Oct-2011)
Fixed download based on form leaving data on the form.
Updated web page links on startup form.
Version 2.2.8 (07-Oct-2011)
Fixed date downloader where download not removing spaces from end of downloaded date.
Version 2.2.7 (05-Oct-2011)
Fixed issue with color of assembly not setting correctly.
Fixed yield turning into mandatory field when it is optional in the operation form.
Version 2.2.6 (28-Sep-2011)
Fixed issue with arrow down operation not taking resources into account.
Fixed available 24hrs flag being incorrectly set in routing operations form.
Fixed available 24hrs flag being incorrectly set in routing upload.
Added trim to convert date function so downloaded dates are returned correctly.
Version 2.2.5 (15-Sep-2011)
Fixed issues with operations form where routing header exists but not operations causing form to fail on opening. Updated common modules
Version 2.2.4 (06-Jul-2011)
Fixed issues with decimal and date downloads not downloading properly
Fixed issue where adding resources to std non referenced not loading.
Version 2.2.3 (30-Jun-2011)
Updated Common Modules.
Added in functionality to stop users entering data when opening a form.
Version 2.2.2 (03-Jun-2011)
Fixed issue with resource principal flag not loading.
Version 2.2.1 27-May-2011)
Fixed an issue with resources not loading
Fixed error with defaulting next resource sequence in resources form.
Version 2.2.0 (20-May-2011)
Added Engineering Support to wizard.
Added ignore clause for standard resources.
Fixed issue with spin button down on operation going to the last record
Changed load validation to only check resources one at a time rather than caching them, helps with large set of resources.
Version 2.1.22 (12-May-2011)
Changed download form to allow download by resource without operation
Version 2.1.21 (08-Apr-2011)
Fixed wizard expecting DFF columns to have context field on sheet
Fixed wizard erroring when resource department description field missing
Found full table scan in resources query, added department join to organization which was missing.
Version 2.1.20 (08-Apr-2011)
Fixed exploder issue which stopped explosion working
Fixed revision form not loading even when item was allowed a revision
Added download data from worksheet functionality
Version 2.1.19 (08-Apr-2011)
Fixed department combo box not updating when you change organization in download form
Fixed validation committing some transactions
Changed validator to only look for resources for the particular bom when updating resources and
to only do a mass search when creating a new resource and that resource doesnt exist.
Version 2.1.18 (05-Mar-2011)
Fixed issue with moving between operations.
Fixed validated message upon load being green not yellow
Applied latest common modules code
Version 2.1.17 (22-Sep-2010)
Updated common modules
Fixed download not downloading current correctly when using between statement
Fixed issue where activity not loading or validating before api call
Fixed issue where resource not loading/validating before api call
Added pre api validation for Usage, Schedule Sequence, Substitute Group Number
Version 2.1.16 (09-May-2010)
Fixed issue with error status not updating
Fixed issue with very small number using exponent not loading or comparing correctly
Changed resource form, removing issue when loaded resource doesn't exist causing a form
Version 2.1.15 (18-Mar-2010)
Toolbar and Menu improvements
Version 2.1.14 (09-Mar-2010)
Wizard not reseting upload error exists flag.
Bug in cboschedule in the operation resources form.
Session ID duplicate variable causing large block not to load
If delete group isnt used form had deletegroup error
Version 2.1.13 (07-Mar-2010)
Updated get_resource cbos to use cbo.column
Fixed download resources downloading to the wrong column for item/lot information Changed uploader to upload resources within operations for cleaner design
Changed Get functions to use more bind variables.
Version 2.1.12 (05-March-2010)
Update get revisions code to look at implemented ECOs only
Fixed large block not returning error based on row ID error being returned
Version 2.1.11 (02-Mar-2010)
Changed download to use bind variables
Changed checkboxes and yes no to by multilingual
Changed downloader to use right to cell function
Put in multilingual date conversion.
Put in euro number decimal conversion
Version 2.1.10 (01-Mar-2010)
Added in check for MSC ATP as r11.5.7 doesnt support this
Updated geninvsupport for 11.5.7, fixed alias bug
Fixed issue with download and assembly form where current default organization is invalid causing array index issue.
Fixed issue with cost type not joining on the correct column
Version 2.1.9 (04-Dec-2009)
Fixed bug where org access bind variable too long for 8i database
Added check for invalid organization to then automatically default to
Version 2.1.8 (04-Nov-2009)
Reapplied InvGen, Gen modules, removing reference to mfg_lookups which caused r11.5.9 issues.
Fixed end of load messages bug
Changed how cancel messages works
Applied change so fields change color when then error before Oracle PL/SQL validation
Updated common modules
Fixed loading issues with incorrect load numbers. Set wizard to ignore accepted records but load everything else.
Added in cacheRow p_currentrow/revertrow to fix excel 2007 bug.
Version 2.1.7 (14-Sep-2009)
Updated sign on tool bar lOV's
Version 2.1.6 (22-Jul-2009)
Removed POW button.
Fixed mandatory field bug
Changed Setup Sheet to new sheet with new URL
Version 2.1.5 (13-May-2009)
Fixed issue with calls to old AWsheet etc in download and upload
Changed download module to show all alternates when item range is blank or item range entered.
Version 2.1.4 (01-Apr-2009)
Fixed type mismatch issue when loading
Version 2.1.3 (10-Mar-2009)
Fixed issue where resources wouldn't load.
Updated resource caching to work correctly, loading existing resources at time routing is returned (if it exists)
Version 2.1.2 (07-Mar-2009)
Fixed issue with speed of returning resource SQL being slow
Added DFF button to Routing, Operation and Resource forms
Fixed bug in get next resource sequence ID where max value from db could be bigger than in S/S but S/S value taking precedence
Fixed toggle resources populating fields when no data in the line
Added set focus on columns when users zoom between forms
Version 2.1.1 (04-Mar-2009)
Changed font and colour for form zooms to match Bom wizard
Removed tools -> references Ref Edit Control. Causing wizard to blow up on vb std commands
Version 2.1.0 (20-Jan-2009)
Changed upload_revision variable to be within routing header details
Fixed upload trying to upload referenced operation columns which cant be modified.
Fixed revision design to not allow user specific revision if item revision doesnt exist or routing revision doesnt exist.
Updated Routing Header form to not default a revision when creating a new routing (Unless item revision exists)
Updated Routing Header form to use ItemInformation record type
Changed way Department and Resources are queried, now using enhanced caching to speed load times
Added toggle functionality to the wizard forms
Fixed issue with sysdate and decimal places using comma vs full stop.
Version 2.0.2 (24-Dec-2008)
Updated Gensupport package to download dates with time in a generic format
Version 2.0.1 (27-Oct-2008)
Updated XMLHTTP package
Version 2.0.0 (02-Sep-2008)
Updated gensupport and invsupport modules
Added in new activation key functionality and modules
Version 1.5.2 (08-Aug-2008)
Uupdated invGenModule and frmUserProfile
Version 1.5.1 (11-Jun-2008)
Bug in get_organization_id, i < myubound org info instead of i <=, missing last org off the list.
Version 1.5.0 (09-Jun-2008)
Updated Invgensupport and mfgsupport modules
Incorporated record types for the assembly and the routing header all thru the wizard
Updated the set status column stuff.
Added New Operation Column
Changed OpResources form to handle other language lovs
Version 1.4.2 (06-June-2008)
Fixed issue with cost_type download sql in frmcosttype
Version 1.4.1 (19-May-2008)
Updated download to allow from row 10 instead of 11.
Changed mtl_system_items view back to _kfv as the other view was missing from some customer instances.
Version 1.4.0 (14-May-2008)
Added right click mouse menu to wizard.
Updated wizard to use _vl tables where possible due to issue with multi lingual install
Updated MFG and Common modules from Bom wizard.
Added download to new sheet functionality
Added cost type changes to download costing information
Added download memory of previous downloads to the header form so the prev used header is passed as the default to the download form.
Fixed issue with download departments code.
Version 1.3.1 (06-May-2008)
Fixed issue with common routings not working due to component validation.
Version 1.3.0 (01-May-2008)
Added in cost details for the assembly
Added in cost rates for the resources
Version 1.2.1 (14-March-2008)
Fixed issue with frmRoutingOperationsResource form updating the spreadsheet when cancelling.
Version 1.2.0 (14-Mar-2008)
Added descriptive colomns for Assembly, Department and resource
Updated frmHeader, frmOperations and frmResources to update descriptive elements
Removed apps_initialize and combined it with cache_lov and renamed to post_login_process
Updated the way the wizard works with messages to use bom_lists instead of mtl_errormessages
Changed tool bars to only show DFF face buttons when the DFF exists.
Version 1.1.9 (02-Mar-2008)
Updated MFGcommon, removed reference to oldxml package
Added additional translation message information.
Fixed issue where user uploads routing, then makes additional change where the date stamp of the initial load didnt include the time portion of the stamp. Updated exists_routing_operations to update the load variable with the date incl the time stamp from the database.
Changed wizard to allow null in the effective date, which will then default to the upload date
Added in functionality to include loading the completion subinv and completion locator.
Version 1.1.8 (04-Feb-2008)
Fixed issue where usage/rate at resource wouldnt accept zero.
Version 1.1.7 (19-Jan-2008)
Build cascade functionality for exploder
Updated exploder to check bill of material for the routing alternate exists
Version 1.1.6 (19-Jan-2008)
Update locator to not use CCID
Updated Gensupport to only bring back Bom or Rtg specific error messages
Version 1.1.5 (16-Jan-2008)
Fixed locator issue in routing header form
Fixed writetocell issue in download
Fixed download Attributes that were off by a factor of one ie attr 1 going to attr2 column
Version 1.1.4 (14-Jan-2008)
Fixed issue with downloading not allowing alternate explosion
Version 1.1.3 (12-Jan-2008)
Removed public macros
Stopped Excel asking for changes to be saved on exit when no changes made
Version 1.1.2 (11-Jan-2008)
Licence Key validation on entry required upgrading
Version 1.1.1 (11-Jan-2008)
Updated GenSupport for build proc and build rec to handle date value SYSDATE
Version 1.1.0 (29-Dec-2007)
Moved toolbar code to its own module, created MFGsupport module for RTG and BOM common code. Moved more4apps generic stuff to GenSupport module.
Created Bom exploder to explode the components of the bom and downloading the routings for the assemblies downloaded.
Version 1.0.11 (13-Dec-2007)
Updated form header and download KFF for items to show the item description in the LOV.
Updated error with standard rate and schedule resource where they were not uploading correctly.
Moved toolbar code to its own module
Version 1.0.10 (11-Dec-2007)
Added in functionality to default download fields from previous downloads
Reinstated user defined required field functionality, removed in prevVersion.
Fixed bug with upload of Schedule Resource flag.
Version 1.0.9 (04-Dec-2007 )
Updated DFF and KFF modules
Fixed error with small block missing begin and end
Updated error where operation sequence data is not being reset
Version 1.0.8 (26-Nov-2007 )
Changed download form to change the implementation date when the revision changes.
Updated upload selected record to give the option to allow the user to upload without having to manually delete error messages.
Changed download assembly to only list items with a routing rather than all items
Fixed bug where operation and resource arrays were holding old data
Fixed exists_component where it was comparing value with null rather than default value for the field, when the field didnt have a value
Changed OrgInfo sql to check the org_access_view for security on inv organizations
Fixed code in operations form where referenced check box would not send data back to the form, when changing the operation code to null.
Changed operations form, so the department is viewable but not enterable if the operation code is entered. Since you cannot change depts with std ops.
Fixed download and header forms to return the current org_code to settings123 so you dont have to choose the org code each time.
Fixed issue where upload of resource was applying the resource to the wrong line.
Updated wizard to set ORGANIZATION_ID when running flexfield table based validation. Update done to supply mod_flex the default organization_id for KFF and DFF validation.
Got rid of l_default_org_id as it was causing confusion and not really required.
Fixed various errors in the way revisions and the current revision was working.
Changed SQL for standard operations to only include non process mfg std operation codes
Changed Download so when you download From - To it removes the revision.
Version 1.0.7 (07-Nov-200 7)
Changed the way revisions are downloaded
Fixed bug with header form not selecting current revision from spreadsheet
Changed download form to only allow assembly command button and assembly to details if the assembly field has been entered.
Version 1.0.6 (20-Sep-2007 )
Added in delete group and delete resource functionality
Reimported choose org after bug found in bom wizard with it
Moved Validate Operation to within Validate Routing, updated rejection error counter to be invoked when an error is found while doing the validation, not just when the pl/sql runs.
Changed resources form so resource change automatically defaults when the user changes the resource.
Version 1.0.5 (10-Sep-2007 )
Rebuilt revisions to use a combobox in the routing form.
Version 1.0.4 (21-Aug-2007 )
Fixed DFF forms to point to the correct tables.
Found code error when opening resources form causing type mismatch.
Updated revisions form to stop allowing the creation of revisions that already exists (ie exists for the future).
Version 1.0.3 (06-Ju l-2007 )
Updated tool bar tip for toggling popup messages
Changed frmRevision to validate New revision to after update to allow multi character revisions
Fixed download revision string not being set correctly
Fixed Download of common to show correctly, with common option box for routing operations
Version 1.0.2 (20-J un-2007 )
Added in toolbar option for login form type (SSO or normal)
Added download item from/to functionality
Version 1.0.1 (20-Jun-2007 )
Added in defaulting resource sequence when standard operation in use.
Fixed tab order issue with resource and operations form
Fixed DFF not downloading
Fixed cancel toolbar not canceling load
Added toggle button to show/hide popup messages.
Created check in resources form to make sure the sequence number doesn't exist for a std operation already.
Fixed download resource not decoding value_id to meaning for basis
Fixed percentage offset not working correctly in resources form
Validate resources procedure was not being called. Included this.
Removed redundant code in resource form by using validate resource before opening the form, this catches generic problems before going to the database.
Fixed Error in UOM for resources shows OSP value instead of UOM
Version 1.0.0
Initial Version
