Version 2.1.16 09-May-2010

1. Fixed issue with error status not updating

2. Fixed issue with very small number using exponent not loading or comparing correctly

3. Changed resource form, removing issue when loaded resource doesn't exist causing a form

Version 2.1.15 18-March-2010

1. Toolbar and Menu improvements

Version 2.1.14 09-March-2010

1. Wizard not reseting upload error exists flag.

2. Bug in cboschedule in the operation resources form.

3. Session ID duplicate variable causing large block not to load

4. If delete group isnt used form had deletegroup error

Version 2.1.13 07-March-2010

1. Updated get_resource cbos to use cbo.column

2. Fixed download resources downloading to the wrong column for item/lot information

3. Changed uploader to upload resources within operations for cleaner design

4. Changed Get functions to use more bind variables.

Version 2.1.12 05-March-2010

1. Update get revisions code to look at implemented ECOs only

2. Fixed large block not returning error based on row ID error being returned

Version 2.1.11 02-March-2010

1. Changed download to use bind variables

2. Changed checkboxes and yes no to by multilingual

3. Changed downloader to use right to cell function

4. Put in multilingual date conversion.

5. Put in euro number decimal conversion

Version 2.1.10 01-March-2010

1. Added in check for MSC ATP as r11.5.7 doesnt support this

2. updated geninvsupport for 11.5.7, fixed alias bug

3. Fixed issue with download and assembly form where current default organization is invalid causing

array index issue.

4. Fixed issue with cost type not joining on the correct column

Version 2.1.9 04-December-2009

1. Fixed bug where org access bind variable too long for 8i database

2. Added check for invalid organization to then automatically default to

Version 2.1.8 04-November-2009

1. Reapplied InvGen, Gen modules, removing reference to mfg_lookups which caused r11.5.9 issues.

2. Fixed end of load messages bug

3. Changed how cancel messages works

4. Applied change so fields change color when then error before Oracle PL/SQL validation

5. Updated common modules

6. Fixed loading issues with incorrect load numbers. Set wizard to ignore accepted records but load everything else.

7. Added in cacheRow p_currentrow/revertrow to fix excel 2007 bug.

Version 2.1.7 14-September-2009

1. Updated sign on tool bar lovs

Version 2.1.6 22-July-2009

1. Removed POW button.

2. Fixed mandatory field bug

3. Changed Setup Sheet to new sheet with new URL

Version 2.1.5 13-May-2009

1. Fixed issue with calls to old AWsheet etc in download and upload

2. Changed download module to show all alternates when item range is blank or item range entered.

Version 2.1.4 01-April-2009

1. Fixed type mismatch issue when loading

Version 2.1.3 10-March-2009

1. Fixed issue where resources wouldnt load.

2. Updated resource caching to work correctly, loading existing resources at time routing is returned (if it exists)

Version 2.1.2 07-March-2009

1. Fixed issue with speed of returning resource SQL being slow

2. Added DFF button to Routing, Operation and Resource forms

3. 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

4. Fixed toggle resources populating fields when no data in the line

5. Added set focus on columns when users zoom between forms

Version 2.1.1 04-March-2009

1. Changed font and colour for form zooms to match Bom wizard

2. Removed tools -> references Ref Edit Control. Causing wizard to blow up on vb std commands

Version 2.1.0 20-January-2009

1. Changed upload_revision variable to be within routing header details

2. Fixed upload trying to upload referenced operation columns which cant be modified.

3. Fixed revision design to not allow user specific revision if item revision doesnt exist

or routing revision doesnt exist.

4. Updated Routing Header form to not default a revision when creating a new routing (Unless item revision exists)

5. Updated Routing Header form to use ItemInformation record type

6. Changed way Department and Resources are queried, now using enhanced caching to speed load times

7. Added toggle functionality to the wizard forms

8. Fixed issue with sysdate and decimal places using comma vs full stop.

Version 2.0.2 24-December-2008

1. Updated Gensupport package to download dates with time in a generic format

Version 2.0.1 27-October-2008

1. Updated XMLHTTP package

Version 2.0.0 02-September-2008

1. Updated gensupport and invsupport modules

2. Added in new activation key functionality and modules

Version 1.5.2 08-August-2008

1. updated invGenModule and frmUserProfile

Version 1.5.1 11-June-2008

1. Bug in get_organization_id, i < myubound org info instead of i <=, missing last org off the list.

Version 1.5.0 09-June-2008

1. Updated Invgensupport and mfgsupport modules

2. Incorporated record types for the assembly and the routing header all thru the wizard

3. Updated the set status column stuff.

4. Added New Operation Column

5. Changed OpResources form to handle other language lovs

Version 1.4.2 06-June-2008

1. Fixed issue with cost_type download sql in frmcosttype

Version 1.4.1 19-May-2008

1. Updated download to allow from row 10 instead of 11.

2. 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

1. Added right click mouse menu to wizard.

2. Updated wizard to use _vl tables where possible due to issue with multi lingual install

3. Updated MFG and Common modules from Bom wizard.

4. Added download to new sheet functionality

5. Added cost type changes to download costing information

6. Added download memory of previous downloads to the header form so the prev used header is passed

as the default to the download form.

7. Fixed issue with download departments code.

Version 1.3.1 06-May-2008

1. Fixed issue with common routings not working due to component validation.

Version 1.3.0 01-May-2008

1. Added in cost details for the assembly

2. Added in cost rates for the resources

Version 1.2.1 14-March-2008

1. Fixed issue with frmRoutingOperationsResource form updating the spreadsheet when cancelling.

Version 1.2.0 14-March-2008

1. Added descriptive colomns for Assembly, Department and resource

2. Updated frmHeader, frmOperations and frmResources to update descriptive elements

3. Removed apps_initialize and combined it with cache_lov and renamed to post_login_process

4. Updated the way the wizard works with messages to use bom_lists instead of mtl_errormessages

5. Changed tool bars to only show DFF face buttons when the DFF exists.

Version 1.1.9 02-March-2008

1. Updated MFGcommon, removed reference to oldxml package

2. Added additional translation message information.

3. 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.

4. changed wizard to allow null in the effective date, which will then default to the upload date

5. Added in functionality to include loading the completion subinv and completion locator.

Version 1.1.8 04-February-2008

1. Fixed issue where usage/rate at resource wouldnt accept zero.

Version 1.1.7 19-January-2008

1. Build cascade functionality for exploder

2. Updated exploder to check bill of material for the routing alternate exists

Version 1.1.6 19-January-2008

1. Update locator to not use CCID

2. Updated Gensupport to only bring back Bom or Rtg specific error messages

Version 1.1.5 16-January-2008

1. fixed locator issue in routing header form

2. fixed writetocell issue in download

3. fixed download Attributes that were off by a factor of one ie attr 1 going to attr2 column

Version 1.1.4 14-January-2008

1. Fixed issue with downloading not allowing alternate explosion

Version 1.1.3 12-January-2008

1. Removed public macros

2. Stopped Excel asking for changes to be saved on exit when no changes made

Version 1.1.2 11-January-2008

1. Licence Key validation on entry required upgrading

Version 1.1.1 11-January-2008

1. Updated GenSupport for build proc and build rec to handle date value SYSDATE

Version 1.1.0 29-December-2007

1. Moved toolbar code to its own module, created MFGsupport module for RTG and BOM

common code. Moved more4apps generic stuff to GenSupport module.

2. Created Bom exploder to explode the components of the bom and downloading the routings

for the assemblies downloaded.

Version 1.0.11 13-December-22007

1. Updated form header and download KFF for items to show the item description in

the LOV.

2. Updated error with standard rate and schedule resource where they were not uploading

correctly.

3. Moved toolbar code to its own module

Version 1.0.10 11-December-2007

1. Added in functionality to default download fields from previous downloads

2. Reinstated user defined required field functionality, removed in prevVersion.

3. Fixed bug with upload of Schedule Resource flag.

Version 1.0.9 04-December-2007

1. Updated DFF and KFF modules

2. Fixed error with small block missing begin and end

3. Updated error where operation sequence data is not being reset

Version 1.0.8 26-November-2007

1. Changed download form to change the implementation date when the revision

changes.

2. Updated upload selected record to give the option to allow the user to upload

without having to manually delete error messages.

3. Changed download assembly to only list items with a routing rather than all items

4. Fixed bug where operation and resource arrays were holding old data

5. Fixed exists_component where it was comparing value with null rather than default value

for the field, when the field didnt have a value

6. Changed OrgInfo sql to check the org_access_view for security on inv organizations

7. Fixed code in operations form where referenced check box would not send data back

to the form, when changing the operation code to null.

8. 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.

9. Fixed download and header forms to return the current org_code to settings123

so you dont have to choose the org code each time.

10.Fixed issue where upload of resource was applying the resource to the wrong line.

11.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.

12.Got rid of l_default_org_id as it was causing confusion and not really required.

13.Fixed various errors in the way revisions and the current revision was working.

14.Changed SQL for standard operations to only include non process mfg std

operation codes

15.Changed Download so when you download From - To it removes the revision.

Version 1.0.7 07-November-2007

1. Changed the way revisions are downloaded

2. Fixed bug with header form not selecting current revision from spreadsheet

3. 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-September-2007

1. Added in delete group and delete resource functionality

2. Reimported choose org after bug found in bom wizard with it

3. 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.

4. Changed resources form so resource change automatically defaults when the user

changes the resource.

Version 1.0.5 10-September-2007

1. Rebuilt revisions to use a combobox in the routing form.

Version 1.0.4 21-August-2007

1. Fixed DFF forms to point to the correct tables.

2. Found code error when opening resources form causing type mismatch.

3. Updated revisions form to stop allowing the creation of revisions that

already exists (ie exists for the future).

Version 1.0.3 06-July-2007

1. Updated tool bar tip for toggling popup messages

2. Changed frmRevision to validate New revision to after update to allow

multi character revisions

3. Fixed download revision string not being set correctly

4. Fixed Download of common to show correctly, with common option box for

routing operations

Version 1.0.2 20-June-2007

1. Added in toolbar option for login form type (SSO or normal)

2. Added download item from/to functionality

Version 1.0.1 20-June-2007

1. Added in defaulting resource sequence when standard operation in

use.

2. Fixed tab order issue with resource and operations form

3. Fixed DFF not downloading

4. Fixed cancel toolbar not cancelling load

5. Added toggle button to show/hide popup messages.

6. Created check in resources form to make sure the sequence number

doesnt exist for a std operation already.

7. Fixed download resource not decoding value_id to meaning for basis

8. Fixed percentage offset not working correctly in resources form

9. Validate resources procedure was not being called. Included this.

10. Removed redundant code in resource form by using validate resource

before opening the form, this catches generic problems before going

to the database.

11. Fixed Error in UOM for resources shows OSP value instead of UOM

Version 1.0.0 Initial Version