More4Apps ADI Solutions for Oracle

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
Updated wizard to use _vl tables where possible due to issue with multi lingual install
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.

Version 1.3.0 01 May 2008
Added in cost details for the assembly
Added in cost rates for the resources

Version 1.3.1 06 May 2008
Fixed issue with common routings not working due to component validation.

Version 1.1.9 02-March-2008
Fixed issue where user uploads routing, then makes additional change where the date stamp of the initial load didn't include the time portion of the stamp.
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.2.0 14-March-2008
Added descriptive colomns for Assembly, Department and resource
Updated frmHeader, frmOperations and frmResources to update descriptive elements'
Updated the way the wizard works with messages to use bom_lists instead of mtl_error_messages
Changed tool bars to only show DFF buttons when the DFF is used in Oracle.

Version 1.2.1 14-March-2008
Fixed issue with frmRoutingOperationsResource form updating the resouce column spreadsheet when cancelling out of the form.

Version 1.1.8 4 February 08
Fixed issue where usage/rate at resource wouldn't accept zero

Version 1.1.7 19 January 08
Build cascade functionality for exploder
Updated exploder to check bill of material for the routing alternate exists

Version 1.1.6 19 January 08
Update locator to not use CCID
Updated Gensupport to only bring back Bom or Rtg specific error messages

Version 1.1.5 16 January 08
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 January 08
Fixed issue with downloading not allowing alternate explosion

Version 1.1.3 12 January 08
Removed public macros
Stopped Excel asking for changes to be saved on exit when no changes made

Version 1.1.3 12 January 08
Removed public macros
Stopped Excel asking for changes to be saved on exit when no changes made

Version 1.1.2 11 January 08
Licence Key validation on entry required upgrading

Version 1.1.1 11 January 08
Updated GenSupport for build proc and build rec to handle date value SYSDATE

Version 1.1.0 29 December 07
Moved toolbar code to it's 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 December 07
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 it's own module

Version 1.0.10 11 December 07
Added in functionality to default download fields from previous downloads
Reinstated user defined required field functionality, removed in prev version.
Fixed bug with upload of Schedule Resource flag.

Version 1.0.9 04 December 07
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 November 07
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 array's were holding old data
Fixed exists_component where it was comparing value with null rather than default value for the field, when the field didn't 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 don't 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 MFG_ORGANIZATION_ID when running flexfield table based validation. Update done to supply mod_flex the default organization_id for KFF and DFF validation. This required changes to Mod_Flex and Frm_Flex.
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 7 November 07
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 September 07
Added in delete group and delete resource functionality
Reimported frmchooseorg 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 September 07
Rebuilt revisions to use a combobox in the routing form.

Version 1.0.4 21 August 07
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 6 July 07
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 June 07
Added in toolbar option for login form type (SSO or normal)
Added download item from/to functionality

Version 1.0.1 20 June 07
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 cancelling 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 12 June 07
Initial Beta Release

Friday, July 11, 2008

Wednesday, March 19, 2008

Monday, February 4, 2008

Saturday, January 12, 2008

Friday, January 11, 2008

Friday, October 5, 2007