5.0.34 (10-Sep-2025)

Fixed error "Compile error in hidden module: fndXMLParse..."

5.0.33 (02-Sep-2025)

Internal Bug Fix

5.0.32 (01-Sep-2025)

Resolved an issue introduced in Microsoft Office update version 2508 that caused a ‘Microsoft Visual C++ Runtime Library - Assertion Failed’ error.

5.0.31 (28-Aug-2025)

Internal Bug Fix

5.0.30 (01-Jul-2025)

Moved the Effective Date from right to the left while opening the Form.

5.0.27 (13-Jun-2025)

Fixed the issue of defaulting Charge type in the Operation Resource section.

5.0.26 (13-Jun-2025)

Improved the validation of Operation Sequence to exclude inactive operations.

5.0.25 (10-Jun-2025)

Fixed the issue of Attachment Upload erroring while creating a new routing. Changed the initial design of New Operation Sequenc3e, New Effective From, New Alt Resource.

5.0.24 (04-Jun-2025)

Fixed the VBA run time error '9999' when updating resources.

5.0.23 (19-May-2025)

Fixed the issues of outing Explosion Only Exploding Items without the routings.

5.0.22 (15-Apr-2025)

Default Browser Login - Fixed bug where the browser would not navigate away from the homepage. This stopped the login process from completing.
Enhanced the Wizard - It will now function using the right click menu, without the More4apps Ribbon Tabs.

5.0.21 (10-Jan-2025)

Fixed issue for [BLANK] functionality not working for 'Routing Comment'.

5.0.20 (09-Jan-2025)

Fixed issue for [BLANK] functionality not working for 'Completion Subinventory' and 'Completion Locator'.

5.0.19 (13-Dec-2024)

Added fix for Error: ORA-06550 PLS-00172: string literal too long.

5.0.18 (12-Nov-2024)

Corrected exploder not displaying full structure.

5.0.17 (31-Oct-2024)

Added Exploder Level columns to visualize exploded structures.

5.0.16 (30-Oct-2024)

Added Base Model column and made available as a download filter.

5.0.15 (17-Oct-2024)

Internal update.

5.0.14 (15-Oct-2024)

Added Default Browser Login option.

5.0.13 (02-Jul-2024)

Updated Alternate Resource download ordering.

5.0.12 (26-Jun-2024)

Corrected Alt Resource download.

5.0.11 (05-Jun-2024)

Internal update.

5.0.10 (10-May-2024)

Added defaulting of 'Primary' to Alternate column in all modes.

5.0.09 (01-Dec-2023)

Corrected issue where leaving a % in the Operation Sequence form field resulted in a SQL error.

5.0.08 (17-Nov-2023)

Internal update.

5.0.07 (17-Nov-2023)

Internal update.

5.0.06 (01-Nov-2023)

Fix where the End-to-End Trace might not return the SQL Statement's execution plan.

5.0.05 (07-Jul-2023)

Made Alt Resource a required value when attempting a Delete action at the Alt Resource level.

5.0.04 (06-Jul-2023)

Prevent Operation Sequence erroring when multiple operations exist with the same sequence number.

5.0.03 (05-Jul-2023)

SQL error originating in Download Setting form resolved.

5.0.02 (28-Jun-2023)

Corrected ORA-20102: Error in P_INIT: ORA-01438: value larger than specified precision allowed for this column.

5.0.01 (25-May-2023)

Fixed the error message 'SQL Error:com.more4apps.r12.servlet.tjava.sql.SQLException: ORA-20102: Error in P_INIT: ORA-31011: XML parsing failed' when logging.

5.0.00 (18-May-2023)

This version is a major upgrade and your current worksheets will not work in this Wizard.
Upgrades to this version should be planned and tested. We will be contacting all support customers with more information soon.
- Improved with new Ribbon.
- Improved performance.
- Added Modes: Manufacturing and Engineering.
- Added ability to manage worksheets with template functionality.
- Download filters previously available in ribbon, now replaced by a new 'Download Settings' button on the Ribbon.
- Header section split into 'Items'/'Revisions'/Routings' sections.

4.4.04 (08-Mar-2023)

Internal update.

4.4.03 (23-Feb-2023)

Internal updates.

4.4.02 (04-Jan-2023)

Internal update.

4.4.01 (29-Sep-2022)

Internal update.

4.4.00 (29-Sep-2022)

Internal update.

4.3.99 (13-Sep-2022)

Internal update.

4.3.98 (14-Jul-2022)

Fixed upload error when Completion Subinventory column was removed.

4.3.97 (13-May-2022)

Fixed Help tooltips.

4.3.96 (13-May-2022)

Fixed issue with Download form by ensuring Operation Sequence is numeric.

4.3.95 (12-May-2022)

Fixed spelling error in Export URL and Import URL tooltip.

4.3.94 (11-May-2022)

Fixed validation error in Resource Sequence column where existing values were getting overwritten by default value if left blank.

4.3.93 (09-May-2022)

Fixed upload error where existing values were getting overwritten by default values if left blank, by removing defaulting on Assigned Unit, Schedule Resource, and Charge type columns.

4.3.92 (04-May-2022)

Internal update.

4.3.91 (07-Apr-2022)

Fix for One Drive saving issue by removing code from the on_save event.

4.3.90 (01-Apr-2022)

Internal update.

4.3.89 (08-Mar-2022)

Fixed bug in Subinventory Locator validation.

4.3.88 (01-Feb-2022)

Fixed bug in 'Effectivity' validation where it was testing 'Effective From' instead of 'Effective To'.

4.3.87 (14-Jan-2022)

Custom Query SQL Injection update.

4.3.86 (13-Jan-2022)

Fixed bug where Effective To date did not confirm to the Allow_Past_Dates profile.

4.3.85 (23-Dec-2021)

Fixed bug where getting PL/SQL exception of PLS-00703: multiple instances of named argument in list.

4.3.84 (23-Dec-2021)

Fixed bug where blanking Completion Subinventory and/or Completion Locator on upload would overwrite them to NULL.

4.3.83 (05-Aug-2021)

Internal update.

4.3.82 (16-Jul-2021)

Fixed issue with bulk download when using the Download form.

4.3.81 (03-Jun-2021)

Fixed spelling for ribbon 'Logging' button comment.

4.3.80 (03-Jun-2021)

Updated security.

4.3.79 (04-May-2021)

Fixed bug where blank Referenced Operation flag on Create would sometimes error.

4.3.78 (03-May-2021)

Updated security.

4.3.77 (30-Apr-2021)

Fixed 'Missing IN or OUT parameter at index: 1' error.

4.3.76 (14-Apr-2021)

Fixed bug where Revision fields were not being updated/defaulted correctly on the Header form.

4.3.75 (09-Apr-2021)

Updated security.

4.3.74 (31-Mar-2021)

Updated security.

4.3.73 (30-Nov-2020)

Fixed large download issue that would result in a 'HTTP 413 - Request Entity Too Large' error.

4.3.72 (17-Nov-2020)

Updated security.

4.3.71 (17-Nov-2020)

Fixed Locator upload issue.

4.3.70 (16-Nov-2020)

Internal enhancement.

4.3.69 (23-Oct-2020)

Fixed bug where header form wouldn't open in 11i.

4.3.68 (02-Oct-2020)

Updated security.

4.3.67 (20-Jul-2020)

Added validation to trap Option Dependent flag on Standard Routings.

4.3.66 (15-Jun-2020)

Changed login from SSO to Standard and re-versioned.

4.3.65 (12-Jun-2020)

Updated security.

4.3.64 (10-Jun-2020)

Internal update.

4.3.63 (10-Jun-2020)

Internal update.

4.3.62 (10-Jun-2020)

Fixed problem where Download form failed with SQL error.

4.3.61 (31-Mar-2020)

Corrected Cost Type LOV.

4.3.60 (30-Mar-2020)

Changed the error message received when double-clicking on a sheet not created from Template123 ie mode ('Routing') not in cell.

4.3.59 (30-Mar-2020)

Fixed issue where double-clicking on Setup sheet or when logged into an incorrect Responsibility opened the Header form.

4.3.58 (24-Mar-2020)

Internal update.

4.3.57 (24-Mar-2020)

Rebranding of logo and new color scheme.

4.3.56 (06-Mar-2020)

Fixed Operation Sequence Number validation to allow Engineering Change Order affected Operations.

4.3.55 (05-Mar-2020)

Fixed issue where download wasn't recognizing that Resource had been disabled by Engineering Change Order.

4.3.54 (03-Mar-2020)

Updated security.

4.3.53 (19-Feb-2020)

Corrected download Resource filter (Download form) to stop returned the header when the Resource doesn't exist.

4.3.52 (17-Feb-2020)

Added Disabled Resource filter to Download form.

4.3.51 (14-Feb-2020)

Changed 'disabled' filter to return disabled Resources when ribbon display option is 'All'.

4.3.50 (14-Feb-2020)

Added 'disabled' filter to Resource downloads. The filter compares the Resource Disabled Date with the ribbon Effective Date.

4.3.49 (11-Feb-2020)

Corrected Disabled Date validation to allow re-enabling an Operation if Patch 17774427 is applied and made it necessary to use [BLANK] to erase the Disabled Date ensuring it is a deliberate action.

4.3.48 (11-Feb-2020)

Corrected downloads (Form and Sheet) to properly be Display Option (Current, Current and Future, All).

4.3.47 (16-Jan-2020)

Removed Resource Schedule validation message and returned to using the API message.

4.3.46 (23-Dec-2019)

Changed option dependent validation to look at Base Item Type for Model Routings.

4.3.45 (28-Nov-2019)

Updated security.

4.3.44 (21-Oct-2019)

Updated security.

4.3.43 (09-Oct-2019)

Fixed Alternate validation when attempting to Upload Selected.

4.3.42 (02-Sep-2019)

Fixed problem with Upload Engineering Routing when column not on the sheet.

4.3.41 (30-Aug-2019)

Set Engineering Routing column with default values.

4.3.40 (21-Aug-2019)

Wizard now validates 'Engineering Routing' column and Engineering Routing Flag Rules.

4.3.39 (01-Aug-2019)

Changed text for Application Mode icon.

4.3.38 (01-Aug-2019)

Internal update.

4.3.37 (23-Jul-2019)

Fixed issue with date formats.

4.3.36 (22-Jul-2019)

Updated security.

4.3.35 (09-Jul-2019)

Fixed Download form SQL error when filtering by Resource.

4.3.34 (02-Jul-2019)

Fixed download error when child and grandchild sections removed from sheet.

4.3.33 (02-Jul-2019)

Internal enhancement.

4.3.32 (01-Jul-2019)

Fixed fault with "Include in Cost Rollup" upload.

4.3.31 (19-Jun-2019)

Fixed fault with 'Clear Status Columns' ribbon control.

4.3.30 (18-Jun-2019)

Fixed Retrieving Flexfield Delimiters issue.

4.3.29 (17-Jun-2019)

Changed 3 tier header for Attachments on Template Sheet to 2 tier header to conform with M4A guidelines, and renamed Header Attachment columns on the Template Sheet, to include the section name to match the Operations Attachment columns naming convention.

4.3.28 (17-Jun-2019)

Fixed bug where 'Edit Template' ribbon control was initially returning message "Template123 Sheet is now hidden" when the Template Sheet was already hidden.

4.3.27 (17-Jun-2019)

Created new Example sheet with updated colours.

4.3.26 (12-Jun-2019)

Updated colours and Setup sheet.

4.3.25 (29-May-2019)

Internal enhancement.

4.3.24 (29-May-2019)

Fixed bug where Wizard errored if child and/or grandchild sections were missing.

4.3.23 (27-May-2019)

Fixed bug where Wizard errored if Alternate was missing. Alternate is now Mandatory.

4.3.22 (17-May-2019)

Fixed bug with Operation Description validation when Operation code is not on sheet.

4.3.21 (13-May-2019)

Stopped Wizard from downloading Operations from unimplemented ECOs.

4.3.20 (13-May-2019)

Updated Custom Query to version 1.1.14 and Fixed bug in download by sheet where the Operation description was not downloaded when Operation Code was not on the sheet.

4.3.19 (26-Apr-2019)

Updated security.

4.3.18 (26-Apr-2019)

Internal update.

4.3.17 (25-Apr-2019)

Fixed bug where Upload sometimes incorrectly errored saying 'Cannot upload as Assembly does not exist'.

4.3.16 (14-Jan-2019)

Fixed Customize Fields form bug where mandatory columns could be unclicked and not be on new sheet.

4.3.15 (09-Jan-2019)

Fixed Effective Date format on download.
Fixed Resource DFF download error.

4.3.14 (21-Dec-2018)

Re-established 'Show_RTW_Toolbars' macro in Developer.Macro tab of Ribbon and removed 'Test' macros from list.

4.3.13 (20-Dec-2018)

Fixed download error as Alternate Resource DFFs were not downloading.

4.3.12 (21-Nov-2018)

Fixed error when attempting an upload when using a Trial Licence.
Fixed Upload error when attempting to delete a Routing that has Alternate Resources.

4.3.11 (16-Nov-2018)

Fixed error where the Resource Basis was getting set to invalid incorrectly.
Fixed Engineering Routing Check as was displaying the incorrect message when using a responsibility that doesn’t have access to Engineering and Manufacturing Routings.

4.3.10 (14-Nov-2018)

Added Alternate Resource button forms to the ribbon.

4.3.09 (13-Nov-2018)

Added functionality to load Resource Alternates.

4.3.08 (15-Oct-2018)

Fixed bug where DFFs were not resolving ID-> Value correctly.
Fixed bug where Operation Context was being downloaded to Resource Context

4.3.07 (11-Oct-2018)

Fixed error '9999' occurring during download.

4.3.06 (10-Oct-2018)

Fixed issue when downloading a routing with DFF attributes.

4.3.05 (04-Oct-2018)

Internal update.

4.3.04 (28-Sep-2018)

Fixed problem where DFFs were not resolving ID to values.

4.3.03 (24-Sep-2018)

Fixed error 'Cannot Update Resource as Resource does not Exist'.

4.3.02 (04-Sep-2018)

Updated security.

4.3.01 (30-Aug-2018)

Fixed 64 bit Attachment issues.

4.3.00 (23-Aug-2018)

Internal update.

4.2.99 (20-Aug-2018)

Added new buttons 'Logging' and 'Help' to the menu.

4.2.98 (15-Aug-2018)

Fixed bug where all the attributes for the Operation DFF were disabled in the DFF form.

4.2.97 (14-Aug-2018)

Fixed performance/stability issue when creating a new sheet from template.

4.2.96 (13-Aug-2018)

Added support for profile option value.

4.2.95 (02-Aug-2018)

Updated security.

4.2.94 (03-Jul-2018)

Updated security.

4.2.93 (15-Jun-2018)

Fixed fault where user couldn't change logo on Template sheet.

4.2.92 (04-Apr-2018)

Fixed Download form filtering.

4.2.91 (23-Feb-2018)

Fixed download bug.

4.2.90 (16-Feb-2018)

Updated Download Wizard.

4.2.89 (08-Feb-2018)

Added Resource Sheet download filter.

4.2.88 (25-Jan-2018)

Added Operation Code(s) filter to Download form.

4.2.87 (08-Jan-2018)

Added functionality to Effective Date validation.

4.2.86 (22-Dec-2017)

Updated Security.

4.2.85 (21-Dec-2017)

Fixed error when Downloading via the form as Routings were not being downloaded as expected.

4.2.84 (21-Dec-2017)

Added Routing Revision DFF button and Downloader tab to the right click menu.
Added data to the Example Sheet.

4.2.83 (19-Dec-2017)

The Wizard now freezes the Default Row when creating a sheet using 'All Columns' so the first 10 rows are always visible.

4.2.82 (19-Dec-2017)

Wizard now freezes the Default Row so the first 10 rows are always visible.

4.2.81 (19-Dec-2017)

Changed error message wording when attempting to open a DFF when the context column has been removed.
Changed error message when Download using sheet data above row 11.
Fixed validation error on the Delete Resource column as was being set to invalid when no value was entered.

4.2.80 (19-Dec-2017)

Fixed error when opening the Routing Revision DFF form when the Context was not on the sheet.
Changed error message when opening the Download form above row 11.
Fixed error when selecting a date using the Effective Date button on the ribbon.

4.2.79 (14-Dec-2017)

Changed locator SQL as it had the potential to cause data corruption.

4.2.78 (12-Dec-2017)

Fixed error where Header and Line attachments were not downloading.
Fixed error where Operation display only columns on the Operation Resource form were not populating as expected.
Fixed error when uploading with a cut down sheet.

4.2.77 (12-Dec-2017)

Investigated changing Effective_From Dates.

4.2.76 (08-Dec-2017)

Fixed error when doing an Explode with no Resource Rate columns on the sheet.

4.2.75 (05-Dec-2017)

Improved upload performance.

4.2.74 (05-Dec-2017)

Fixed error with the Exploder when using an Alternate other than Primary.

4.2.73 (04-Dec-2017)

Fixed bug where Operation DFF were downloading into Resource DFF.

4.2.72 (01-Dec-2017)

Implemented Exploder functionality into the Download form.

4.2.71 (29-Nov-2017)

Fixed issue with Ribbon Display Mode where "Current and Future" wasn't downloading a newly created Operation.
Fixed issue with DFFs where ID not value was being printed to sheet on download.

4.2.70 (29-Nov-2017)

Fixed Basis field being overwritten with ID.
Fixed Common Routing invalidating when 'Create' selected in Upload Mode.

4.2.69 (13-Oct-2017)

Downloader installed.

4.2.68 (13-Oct-2017)

Fixed download SQL error.

4.2.67 (13-Oct-2017)

Fixed error where Resource Basis was uploading Default Value and not overwritten Value.

4.2.66 (12-Oct-2017)

Fixed error when the Operation Code was not on the sheet but the Operations Description was.
Fixed multiple issues for when there were columns missing from the sheet.
Added Example Sheet.

4.2.65 (14-Sep-2017)

Updated Security.

4.2.64 (10-Aug-2017)

Changed functionality around Common Routing.

4.2.63 (04-Aug-2017)

Fixed CommonRouting Validation Error. % symbol search was blowing up.

4.2.62 (04-Aug-2017)

Changed Revision Upload functionality. Now Current Revision columns are truly Display Only and are no longer Uploaded.
Revision data only included in Upload if Routing being Updated with a New Revision. Cannot enter a Revision on Create - Oracle sets first Revision at [NOW].

4.2.61 (22-Jun-2017)

Turned Error handing off this time.

4.2.60 (22-Jun-2017)

Changed functionality of Department column validation.

4.2.59 (16-Jun-2017)

Fixed Wizard not downloading Routings in BOMInquiry Responsibility. BOMInquiry Responsibility is Query only no Update, Create or Delete. This means download only, no upload. Wizard downloads Manufacturing Routings only, no Engineering, when in Inquiry Responsibility. Wizard will message if upload attempted in Inquiry Responsibility.

4.2.58 (06-Jun-2017)

Updated Security.

4.2.57 (12-May-2017)

Applied the language patch, changed browser settings to suppress JavaScript errors during login. Fixed the issue where code blows up with running pl/sql error.

4.2.56 (11-May-2017)

Changed Resource SQL to exclude End_Dated Resources from the LOV.

4.2.55 (08-May-2017)

Added search restriction to Operation Resource column.

4.2.54 (04-May-2017)

Added Search Restriction to cboCostType on both frmDownload and frmCostType.

4.2.53 (05-Apr-2017)

Fixed an issue with 'PastDatesAllowed' profile.

4.2.52 (30-Mar-2017)

Added 'Basis' defaulting from Resource when no Basis specified on sheet.

4.2.51 (23-Mar-2017)

Fixed Option Dependent validation.

4.2.50 (23-Mar-2017)

Fixed Department filter in Download form.

4.2.49 (23-Mar-2017)

Changed Dependencies around RoutingRevision to break dependency_Chain
Routing Revision was being queried via the chain of dependence when Org was selected.
Added Search Control to Operation Code on Routing Operations form.

4.2.48 (22-Mar-2017)

Fixed Upload problem where Effective Date on the sheet was in a different format to Oracle eqivalent value. Added trap for non-Date values to Effective From column.

4.2.47 (15-Mar-2017)

Fixed download problem in 'Download form'.

4.2.46 (15-Mar-2017)

No Code Change. Reset Ribbon Resource checkboxes.

4.2.45 (15-Mar-2017)

Fixed Resource download problem.
When Resource Costs type (on ribbon) was different to the actual Resource Cost Type, zero Resources were returned, even if the Resources existed.

4.2.44 (17-Feb-2017)

Fixed possible download attachments problem.

4.2.43 (23-Jan-2017)

Fixed update problem. When doing 'Update - Create - Update' sequence the newly 'Created' Operation/Effective_From_Date was being set as invalid.

4.2.42 (09-Jan-2017)

Fixed inability to add resources to duplicate operation.
Fixed Effective_From date being overwritten with sysdate on 'Create'.

4.2.41 (21-Dec-2016)

Fixed Download form problem when no Cost Type selected.

4.2.40 (30-Nov-2016)

Fixed Operations form error when Assembly invalid.

4.2.39 (29-Nov-2016)

Fixed multiple Resource download.

4.2.38 (29-Nov-2016)

Fixed upload error when creating Operation and Resource.

4.2.37 (25-Nov-2016)

Fixed Form(s) opening error when data invalid case.

4.2.36 (25-Nov-2016)

Fixed upload error when DFF Section(s) removed from sheet case.
Fixed Header form errors when creating a new Routing.
Fixed Header form issue with Assembly Description field not populating.
Fixed Header Form issue with Revision Date populating with [NOW].

4.2.35 (14-Nov-2016)

Added Validation to ensure 'Option Dependent" flag is 'No' if Assembly_Item_type is Standard (ie not an option class).
When creating new Operation line, Effective Date is now defaulting to today’s date.
When creating new Operation line, Operation sequence is now defaulting to last Operation Sequence +10.
When creating new Operation line, Option Dependent flag is now defaulting to 'No'.

4.2.34 (08-Nov-2016)

Fixed Download form issue when downloading via form and specifying Department resources where every routing would be downloaded.

4.2.33 (25-Oct-2016)

Fixed [Blank] functionality for DFFs.

4.2.32 (21-Oct-2016)

Fixed DFF naming in upload.

4.2.31 (21-Oct-2016)

Fixed upload of routing DFF.

4.2.30 (21-Oct-2016)

Modified Revision Validation for when creating new Routings and the Oracle Organization default for revisions is required.

4.2.29 (21-Oct-2016)

Added functionality - can now create new Routing and Routing Revision DFF at same time.
Fixed DFF upload validation.

4.2.28 (19-Oct-2016)

Changed Upload Validation. If Both Current Revision and Revision (new) fields are blank - will default to Current Revision. Will now update Revision DFF against any Alternate.

4.2.27 (19-Oct-2016)

Corrected problem with Download falsely populating Common Routing fields.

4.2.26 (18-Oct-2016)

Corrected problem with Download form erroring when Operation column removed. Stopped User entry to Revision and Effective Date fields on Header form.

4.2.25 (17-Oct-2016)

Corrected problem with downloading twice.

4.2.24 (17-Oct-2016)

Corrected problem with new DFF running in instance.

4.2.23 (17-Oct-2016)

Added routing Revision DFF fields to sheet and Routing Revision DFF form to ribbon.

4.2.22 (30-Sep-2016)

Fixed Download form error message occurring when using only Org and Alt and Item Status to download.

4.2.21 (28-Sep-2016)

Fixed Download form error message occurring when using only Org and Alt to download.

4.2.20 (23-Sep-2016)

Fixed Download form Revision issue.

4.2.19 (09-Sep-2016)

Fixed spelling mistake on Template123 sheet.

4.2.18 (30-Aug-2016)

Added Defaulting to the ChargeType column based on the Resource.

4.2.17 (23-Aug-2016)

Fixed bug in Header Attachment download.

4.2.16 (23-Aug-2016)

Ordered Header and Line Attachments.

4.2.15 (22-Aug-2016)

Enhanced Item Status criteria on Download form and Sheet Download to work with new architecture.

4.2.14 (18-Aug-2016)

Improved Download performance.

4.2.13 (17-Aug-2016)

Enabled DownloadForm checkbox for 'IncludeExtraResources'.

4.2.12 (16-Aug-2016)

Upgraded download to new architecture.

4.2.11.8 (15-May-2017)

Fixed issue where users are being logged in with the wrong language.
Further Information: In EBS 12.2 a framework patch has stopped us from being able to select a language in the browser login page.
To work around this problem the language for the user is now being set from user's EBS preferences irrespective of what is chosen on the Browser Login page.

4.2.11 (29-Jul-2016)

Fixed Derive Mode when uploading. A previous version (4.2.10) modified how the Derive mode was working.

4.2.10 (29-Jul-2016)

Fixed Validation For 'Resource Sequence' and 'Operation Sequence' on their respective Forms when Upload Mode was Blank.
Improved Validation against CounPoint/AutoCharge/Backflush columns.

4.2.09 (29-Jul-2016)

Fixed the Operation Upload Mode LOV not populating when opening Resource Form

4.2.08 (28-Jul-2016)

Added Functionality to CountPoint/AutoCharge/Backflush Uploading to ensure correct validation of all possible combinations of the columns.
Fixed Wizard issue when filtering by a Resource on the Download Form when Resource section removed from sheet.
Fixed Download Form returning no values when 'Include Other Resources within Operations' is checked.
Fixed the Download Form Breaking when not specifying an Org.
Fixed the Download Form Breaking when using the Multiple Resources Button.

4.2.07 (27-Jul-2016)

Enabled wizard to end date operation sequences and add new departments for the same sequence in the same load.

4.2.06 (25-Jul-2016)

Fixed Issue when the Download Form was giving an Excel Error 457 Message when opening the form and then clicking into a different program, eg a web browser.

4.2.05 (22-Jul-2016)

Added Checks on Date Columns to ensure a valid date is entered.

4.2.04 (21-Jul-2016)

Fixed Template issue. Generated sheets had the break between sections in the wrong place.

4.2.03 (20-Jul-2016)

Fixed Attachment Upload problems.

4.2.02 (19-Jul-2016)

Can now upload routing to a new Org. NB: Effective From Date/Time cannot be before current DBMS time so use [NOW] if necessary.

4.2.01 (07-Jul-2016)

Added functionality. It is now possible to download with sections removed without mandatory columns from removed sections erroring.
Sections are only downloaded if they exist on the sheet.
Column Headers (Names) can be changed via the 'Customize Fields' Form.
Completion Subinventory and Engineering Item columns are no longer mandatory.
Fixed Upload error. No attempt is made to upload DFF columns removed from sheet.
All Form YES/NO LOVs are now multilingual.

4.2.00 (07-Jul-2016)

Internal Enhancement.

4.1.60 (06-Jul-2016)

Fixed Error when Uploading with Usage column removed from sheet.

4.1.59 (05-Jul-2016)

Fixed Multilanguage Upload Problem.

4.1.58 (05-Jul-2016)

Fixed Error when Uploading with Completion Subinventory column removed from sheet.
Updated Security.
Fixed Error with Download Form when including Costs.

4.1.57 (01-Jul-2016)

Fixed problems with Wizard crashing in R12.2.4
Modified Effective Date Validation to stop "Effective From cannot be before the current database date and time” msg when Updating or using 'NOW'.
Updated Logout button to show either Login or Logout as relevant.

4.1.56 (29-Jun-2016)

Fixed Schedule Resource Error.
When the scheduled flag was set to "N", an error message for lines with zero hours occurred.

4.1.55 (28-Jun-2016)

Fixed problem with Delete Group.

4.1.54 (27-Jun-2016)

Fixed LogOut Button on Ribbon to set Routing Mode on LogIn.

4.1.53 (27-Jun-2016)

Improved defaulting of Effective Date.

4.1.52 (24-Jun-2016)

Fixed Wizard failure when trying to download using more than 5 criteria.

4.1.51 (24-Jun-2016)

Fixed 'Online Documentation' hyperlink on Setup sheet to go to RTW Documentation.

4.1.50 (23-Jun-2016)

Referenced Standard Operation Resources now handled correctly i.e. cannot Create or Update a resource on a Referenced Operation.

4.1.49 (21-Jun-2016)

Reset Tabbing Order on Forms to tab horizontally left to right within the groups.
Download Performance Improved greatly.

4.1.48 (16-Jun-2016)

Fixed bug with Revision Date when Creating on Routing Header form, Sorted Tabbing order on download form.

4.1.47 (10-Jun-2016)

Fixed performance issues with download SQL.

4.1.46 (09-Jun-2016)

Internal enhancements.

4.1.45 (08-Jun-2016)

Added validation to Lead Time to catch values over 100%.

4.1.43 (03-Jun-2016)

Internal enhancements.

4.1.42 (31-May-2016)

Updated Download SQL to make it faster and more efficient.

4.1.41 (30-May-2016)

Internal enhancements.

4.1.40 (25-May-2016)

Effective Date on Ribbon enhanced to avoid US/UK date format confusion.

4.1.39 (25-May-2016)

Now tests if the Resource Schedule flag is set to 'No' when the Usage/inverse usage is 0 and the UOM is time Based.
Now test if the Resource Flag is set to 'No' if the UOM type is not Time based.

4.1.38 (25-May-2016)

Made the Effective Date from and the Engineering Routing columns mandatory as they are required.

4.1.37 (23-May-2016)

Updated Security.

4.1.36 (18-May-2016)

Fixed download issue in download form when specifying item statuses but not assemblies.

4.1.35 (18-May-2016)

Fixed download issue when operations and resources were all the exact same thus only the first record would download.

4.1.34 (17-May-2016)

Fixed SQL Parse error when not specifying an Assembly in the Download form.

4.1.33 (14-May-2016)

Fixed issue of Resources not downloading when downloading multiple Assemblies at once.

4.1.32 (12-May-2016)

Fixed issue with Downloading multiple selected Routings from the sheet. Download would only bring back the first due to revision conflicts.

4.1.31 (11-May-2016)

Fixed the Count Point, Backflush, Autocharge Matrix dependency issue, errors were occurring with no messages.

4.1.30 (10-May-2016)

Internal enhancements.

4.1.29 (10-May-2016)

Fixed Derive mode issue when updating a routing whilst creating operations.
Fixed Multiple Resources Button in the download form when no resources were against the department specified.
Restricted Organization list to responsibility of user and removed defaulting of 'M1'.

4.1.28 (02-May-2016)

Changed Ribbon Date to show with month included eg instead of 01/05/2016 it will instead appear like 01/May/2016.

4.1.27 (28-Apr-2016)

Fixed Referenced error when the field was left blank.
Removed Engineering Change Order Column as it is not currently supported.

4.1.26 (26-Apr-2016)

Fixed Include Common Operations Checkbox to download based on common routings.

4.1.25 (18-Apr-2016)

Fixed Include All Resources checkbox in download form to include correct resources on download.

4.1.24 (07-Apr-2016)

Found issue with Derive mode not working in validation and setting incorrect transaction types.

4.1.23 (07-Apr-2016)

Modified Engineering Routing to default from parent, still holds validation against engineering routings.

4.1.22 (07-Apr-2016)

Modified Derive Mode Control to perform as intended.

4.1.21 (06-Apr-2016)

Fixed Download form when only using the Resource Code and Organization as download criteria.

4.1.20 (01-Apr-2016)

Fixed Capable To Promise Error on Upload in 12.2.5.

4.1.19 (01-Apr-2016)

Fixed issue of every column being loaded despite not being on the sheet causing a code error.

4.1.18 (31-Mar-2016)

Fixed issue with having a reduced header section sheet without revisions, was causing an issue when opening some forms.
Improved Download speed when using the download form to perform faster and not blow up.

4.1.17 (18-Mar-2016)

Updated Security.

4.1.16 (03-Mar-2016)

Updated Security.

4.1.15 (02-Mar-2016)

Fixed Issue for Multiple Item Statuses being downloaded.

4.1.14 (24-Feb-2016)

Fixed issue with Usage columns when giving an error on Validation.

4.1.13 (09-Feb-2016)

Fixed issue with Attachments not downloading due to large amounts being brought back.

4.1.12 (05-Feb-2016)

Fixed issue with Operation Resources not downloading.
Fixed issue when downloading as was blowing up when Resource Rate was removed from the sheet.

4.1.11 (22-Jan-2016)

Added Autocharge column.

4.1.10 (22-Jan-2016)

Changed resources to order in descending order.
Fixed incorrect Standard Rate flag setup.
Fixed error where Resource Rate and Extended Resource Rate weren’t on the sheet.

4.1.09 (21-Jan-2016)

Added Ribbon LOV to handle Resource Costs. The Default for this is Frozen.

4.1.08 (18-Jan-2016)

Fixed error relating to invalid Resources.

4.1.07 (22-Dec-2015)

Updated Security.

4.1.06 (21-Dec-2015)

changed basis download to handle multi-language.

4.1.05 (18-Dec-2015)

Changed Dates to handle being in a different language
Changed Checkboxes to Combo boxes to solve multi language issues.

4.1.04 (16-Dec-2015)

Internal enhancements.

4.1.03 (07-Dec-2015)

Changed Ribbon check boxes to retain saved checked options.
Added support for mandatory columns.

4.1.02 (09-Dec-2015)

Modified Revision date Validation for when looking at Current Revisions and New Revisions
Changed Function type to allow users access to correct forms they are able to access in Oracle
Added support to allow only the Inverse Usage column on the sheet.
Added ability to not have the Effective To column on the spreadsheet.

4.1.01 (07-Dec-2015)

Added support for Multi-language.

4.1.00 (26-Nov-2015)

The use of upload columns instead of a ribbon controlled upload ( Along with a Derive Mode to carry the Upload mode down the sections from the header).
There is no longer a Cost selector on the sheet, it now has its own section (Download and Display only).
Costs can be included or excluded via the ribbon.
Revisions are now created in the Header form, not a stand-alone form.
Download Tools are now in the Ribbon where previously they were in a separate pop up form.
Normalise & Denormalise Tools.

2.5.37 (16-Dec-2014)

Updated Error Handling for Flexfields
Fixed key flexfield segment 11 populating segment 1

2.5.36 (16-Dec-2014)

Changed procedure SQL used for finding if routing exists causing ORA-00904 when using 11 segment Item Key flexfield
Misses out the first quote and the last quote in the 'IN' statement. And hence ora-00904: "V1": inva

2.5.35 (12-Dec-2014)

Changed Flex form. Added extra segment now has 11

2.5.34 (02-Dec-2014)

Added support for 11 segment assembly KFF upload

2.5.33 (02-Dec-2014)

Changed get resources for download to improve performance

2.5.32 (02-Dec-2014)

Changed download selected to require non normalised header/operations/resources as per common infrastructure
Added in upload to inverse usage to remove rounding issues

2.5.31 (14-Nov-2014)

Fixed bug where header DFF context value not being reset from last DFF (resource or operation) download

2.5.30 (31-Oct-2014)

Fixed Validate Resource Failing with divide by zero issue where resource has a usage of 0

2.5.29 (25-Sep-2014)

Fixed issue with download selected overwriting download criteria

2.5.28 (25-Sep-2014)

Fixed issue with resource field not working when usage column missing
Fixed vba not handling reoccurring decimals, now round cells to 5dp

2.5.27 (19-Sep-2014)

Changed download selected code to work on disable date and implemented date
Fixed bug where it wasn't allowing eng download when resp had both eng and mfg setup

2.5.26 (03-Sep-2014)

Changed operation download to allow implemented ECO's

2.5.25 (22-Aug-2014)

Updated Ribbon/Context Menu to be in order

2.5.24 (13-Aug-2014)

Added in Profile Option to limit user’s functionality to Validate Only
Fixed bug in operation resources with inverse usage causing vba to stop if inverse usage column missing
Added in missing Yield column in download

2.5.23 (06-Aug-2014)

Added support for Uploading Operation Attachments in InitializeAttachmentSections

2.5.22 (23-Jul-2014)

Added support for download by std operation

2.5.21 (23-Jul-2014)

Was an issue with decimal placing rounding when checking data entered in the sheet rather than via the form, Oracle rounds to 6dp so have hardcoded to be the same

2.5.20 (23-Jul-2014)

Added support to nulling out completion subinventory and locator
Added support for create ENG routings as this seems to be supported now

2.5.19 (22-Jul-2014)

Added in checks against Usage and Inverse usages in AppRTW. Whether or not values are present with one or both columns, missing columns and missing data

2.5.18 (21-Jul-2014)

EBS 12.2 fix Long_to_char for long_to_char sql errors caused by table based validation sets.'core 209 imported
DFFmod.Search_Value_Set_ID sql updated for 12.2

2.5.17 (04-Jul-2014)

Updated Wizard to handle multiple item segments (worked but was slow)
Fixed bug in user forms, not rendering multiple item segments correctly
Updated common code
Fixed inverse usage not loading when usage column missing
Added in multiple option, so you can choose more than one item status

2.5.16 (26-Jun-2014)

Changed Wizard to support Org codes such as 001 and 044

2.5.15 (12-Jun-2014)

Fixed bug where resource data not returning on download
Changed download selected to allow for referenced routing operations

2.5.14 (27-May-2014)

Updated common code

2.5.13 (16-May-2014)

Added the following functionality to downloads:
- You can now download by operation code, operation sequence and resource when downloading from spreadsheet
- Can routing download by item status
- In the routing form, allow users to select multiple alternates

2.5.12 (06-May-2014)

Fixed bug in with exploder not working

2.5.11 (22-Apr-2014)

Fixed bug in for standard operations not working if resource columns missing

2.5.10 (20-Apr-2014)

Fixed bug in download all alternates not working

2.5.09 (11-Feb-2014)

Fixed bug in revision date formatting incorrectly on sheet
Fixed delete group not loading due to revision date bug
Fixed validate message box not working
Added additional validation to operation code

2.5.08 (10-Feb-2014)

Changed download resources to download all resources for routing rather than by operation to improve performance

2.5.07 (03-Feb-2014)

attAttachment.cmdViewDoc_Click. Not showing form if navigation has been cancelled.
In the case where the browser decides to use another program to display a document (ie word) the word document will be displayed fine. But there will also be a browser window open with the message "Navigation Cancelled"
fndBrowser. Changed variable name WeBrowser to browser so Attachment form could access it
Fixed Divide by zero issue in routing operation resource download

2.5.06 (23-Jan-2014)

Fixed Divide by zero issue in routing operations form

2.5.05 (23-Dec-2013)

Added Clear button to download form
Changed check allowed past dates to default to Yes if profile option not set
Fixed Bug in form header with toggle up clearing out column headings

2.5.04 (17-Dec-2013)

Added Capable to promise flag to routing header

2.5.03 (11-Dec-2013)

Added download by item status in the download form
Added download multiple alternates in the download form
Added the following to download from spreadsheet: Department, Operation Sequence, Resource
Changed code so users can use inverse usage, and for it to upload into the inverse usage field in the API

2.5.02 (15-Nov-2013)

Fixed issue where you could create operations in the past when profile option set to 'No'
Fixed reference flag failing download

2.5.01 (15-Nov-2013)

Added ribbon and menu/toolbar options for Attachments functionality

2.5.00 (17-Oct-2013)

Added in check box to include referenced standard operations in the downloader
Updated common code

2.4.05 (17-Oct-2013)

Wizard now ignores lead time on standard operations
Added operation sequences as a filter on the download form
Fixed bug where std ops without resources fail validation
Added inverse field to Wizard

2.4.04 (01-Oct-2013)

Fixed exploder not working
Changed downloader so Eng user only see's Eng routings and MFG user only see's MFG routings

2.4.03 (01-Oct-2013)

Fixed issue delete resources not working after the first operation sequence

2.4.02 (07-Sep-2013)

Fixed issue with header DFF download not working correctly

2.4.01 (14-Aug-2013)

Fixed issue with duplicate locator in load caused by change on version 2.3.05

2.4.00 (01-Aug-2013)

Added ability to upload routing changes to an existing ECO

2.3.05 (17-Jul-2013)

Fixed issue with countpoint and backflush check boxes in the form not setting correctly.
Added check to locator load to make sure that just the delimiters alone don't load ie ".." as the cell value

2.3.04 (01-May-2013)

Added in delete operation resource functionality

2.3.03 (10-Jan-2013)

Added in validation to check primary exists before loading alternate
Fixed issue where effective end date couldn’t be null’d out
Fixed issue where Wizard would allow end dates for past dates
Fixed issue with defaulting next operation sequence not working correctly
Updated common code

2.3.02 (13-Dec-2012)

Fixed the Mode Option error and changed ribbon the Mode Icons

2.3.01 (11-Dec-2012)

New Excel 2007 and Ribbons enabled

2.2.20 (28-Nov-2012)

Added in default sequencing for operations when loading.  This requires a new profile option
“More4Apps:RTW Insert Operation Into Next Available Sequence” if missing op sequences within a routing are going to be used
Changed loader so if only one record in an op and the effective date (excluding time) matches then use this record
Fixed uploader issue where it could miss out some resources

2.2.19 (16-Nov-2012)

Fixed issue with resource defaulting not working correctly
Changed routing header form so revision doesn’t error if BOM Assy is invalid
Added central error handler to RTW and RTW Sql modules

2.2.18 (07-Nov-2012)

Fixed issue with org level resource caching not working
Fixed resource existence check when resource is a number as the comparison wasn’t working
Fixed bug where effective date in download from form was coming from the sheet rather than download selected
Changed code to default the effective date in if is blank.  It will use the current date for the operation it exists, otherwise it will set it to today’s date.  If 2 records for the same op are found then it to today’s date
If user has both BOM and Eng within their responsibility it defaults to BOM
Fixed download routing revision date not in date format

2.2.17 (03-Sep-2012)

Fixed bug where new operation number wasn’t loading
Added check so referenced operations lead times cannot be set/entered

2.2.16 (03-Sep-2012)

Updated common code

2.2.15 (23-Feb-2012)

Changed upload to only look for assy and resource costs if the columns exist on the sheet
Fixed issue where date was swapping between DD-MM format to MM-DD

2.2.14 (17-Feb-2012)

Changed downloader SQL to improve performance for department and resource where used

2.2.13 (02-Feb-2012)

Added in functionality to allow multiple resources in download list

2.2.12 (01-Feb-2012)

Allowed use of a cut down sheet
Changed Wizard to allow update to department if there are no resources

2.2.11 (10-Oct-2011)

Fixed delete group operations not loading subsequent delete groups

2.2.10 (10-Oct-2011)

Fixed delete group operations not loading

2.2.9 (10-Oct-2011)

Fixed download based on form leaving data on the form
Updated web page links on startup form

2.2.8 (07-Oct-2011)

Fixed date downloader where download not removing spaces from end of down loaded

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

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

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

2.2.4 (06-Jun-2011)

Fixed issues with decimal and date downloads not downloading properly
Fixed issue where adding resources to std non referenced not loading

2.2.3 (30-Jun-2011)

Updated Common Modules
Added in Loading form functionality when opening a form

2.2.2 (03-Jun-2011)

Fixed issue with resource principal flag not loading

2.2.1 (27-May-2011)

Fixed an issue with resources not loading
Fixed error with defaulting next resource sequence in resources form

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

2.1.22 (12-May-2011)

Changed download form to allow download by resource with operation

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

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

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 doesn’t exist

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

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

2.1.16 (09-Mar-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 existing causing a form type mismatch error

2.1.15 (18-Mar-2010)

Toolbar and Menu improvements

2.1.14 (09-Mar-2010)

Wizard not resetting 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 isn’t used form had deletegroup error

2.1.13 (07-Mar-2010)

Updated get_resource cbo’s 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

2.1.12 (05-Mar-2010)

Update get revisions code to look at implemented ECO’s only
Fixed large block not returning error based on row ID error being returned
Updated get resource cost to look at array col 33

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<

2.1.10 (01-Mar-2010)

Added in check for MSC ATP as r11.5.7 doesn’t 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

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

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

2.1.7 (14-Sep-2009)

Updated sign on tool bar LOV’s

2.1.6 (22-Jul-2009)

Removed POW button
Fixed mandatory field bug
Changed Setup Sheet to new sheet with new URL

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

2.1.4 (01-Apr-2009)

Fixed type mismatch issue when loading<

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)

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

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

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 doesn’t exist or routing revision doesn’t 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

2.0.2 (19-Jun-2025)

Removed the mandatory features for the New Effective From, New Operation Sequence Number and New Alt Resource.

2.0.2 (18-Jun-2025)

Fixed the Operation Attachment uploading issue.

2.0.2 (24-Dec-2008)

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

2.0.1 (27-Oct-2008)

Updated XMLHTTP package

2.0.0 (02-Sep-2008)

Updated gensupport and invsupport modules
Added in new activation key functionality and modules

1.5.2 (08-Aug-2008)

Uupdated invGenModule and frmUserProfile

1.5.1 (11-Jun-2008)

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

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

1.4.2 (06-Jun-2008)

Fixed issue with cost_type download sql in frmcosttype

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

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

1.3.1 (06-May-2008)

Fixed issue with common routings not working due to component validation

1.3.0 (01-May-2008)

Added in cost details for the assembly
Added in cost rates for the resources

1.2.1 (14-Mar-2008)

Fixed issue with frmRoutingOperationsResource form updating the spreadsheet when cancelling

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

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 didn’t 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

1.1.8 (04-Feb-2008)

Fixed issue where usage/rate at resource wouldn’t accept zero

1.1.7 (19-Jan-2008)

Build cascade functionality for exploder
Updated exploder to check bill of material for the routing alternate exists

1.1.6 (19-Jan-2008)

Update locator to not use CCID
Updated Gensupport to only bring back Bom or Rtg specific error messages

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

1.1.4 (14-Jan-2008)

Fixed issue with downloading not allowing alternate explosion

1.1.3 (12-Jan-2008)

Removed public macros
Stopped Excel asking for changes to be saved on exit when no changes made

1.1.2 (11-Jan-2008)

Licence Key validation on entry required upgrading

1.1.1 (11-Jan-2008)

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

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

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

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

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

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 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 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 operati on codes
Changed Download so when you download From – To it removes the revision

1.0.7 (07-Nov-2007)

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

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

1.0.5 (10-Sep-2007)

Rebuilt revisions to use a combobox in the routing form

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)

1.0.3 (06-Jul-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

1.0.2 (20-Jun-2007)

Added in toolbar option for login form type (SSO or normal)
Added download item from/to functionality

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

1.0.0 (01-Jun-2007)

Initial Version