1.7.12 (01-Sep-2025)

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

1.7.11 (12-Jun-2025)

Internal Bug Fix

1.7.10 (12-Jun-2025)

Fixed the issue of blank out source type when updating item/subinventory assignments

1.7.09 (25-Feb-2025)

Enhanced the Wizard - It will now function using the right-click-menu, without the More4apps ribbon tabs.

1.7.08 (07-Jan-2025)

Internal update.

1.7.07 (06-Jan-2025)

Fixed bug where the Wizard would not function and displayed the following message after login: The earliest version allowed of Item Extension Wizard is x.xx.x This version is x.xx.x. Please contact your administrator.

1.7.06 (09-Oct-2024)

Internal update.

1.7.05 (08-Oct-2024)

Added Default Browser Login option.

1.7.04 (01-Aug-2024)

Turn off Log file.

1.7.03 (31-Jul-2024)

Fixed issues of Item Ext Wizard Error when inactivating a Cust Item.

1.7.02 (30-Apr-2024)

Fixed issues of profile: IEW Minimum version, IEW Allowed version, IEW Latest version used.

1.7.01 (05-Apr-2024)

Internal update.

1.7.00 (14-Mar-2024)

Sourcing Assignment mode: Fixed the blank issue in the required field.

1.6.99 (06-Mar-2024)

Customer Item Xref mode: Fixed the error message issues.

1.6.98 (28-Feb-2024)

Internal update.

1.6.97 (05-Feb-2024)

Fixed the ribbon User Instructions link issues.

1.6.96 (22-Nov-2023)

Customer Item Xref mode: Fixed the issue of 'Departure Plan Required' not able to update and validation issues. Fixed the SQL error when updating multi records with same customer, customer item, and inventory item.

1.6.95 (17-Nov-2023)

Fixed an issue where an End to End Trace might not return the SQL statement's execution plan.

1.6.94 (09-Nov-2023)

Customer Item Xref mode: Changed the form size.

1.6.93 (19-Oct-2023)

Manufacture Part mode: Add a call to the concurrent program at the end of the upload to fix the item invisible issues in Iprocurement page.

1.6.92 (10-Oct-2023)

Added new digital signature.

1.6.91 (21-Sep-2023)

Customer Item Xrefs mode: Made forms larger to accommodate 2nd line of error message.

1.6.90 (01-Sep-2023)

Internal update.

1.6.89 (31-Aug-2023)

Manufacture Part mode: Fixed the issue when no DFF on the sheet.

1.6.88 (31-Aug-2023)

Remove the direct table insert and use the private package mtl_mfg_part_numbers_pkg instead.insert_row to fix the issue of invisible Manu Part number in iProcurement page.

1.6.87 (15-Aug-2023)

Fixed the issue of Safety Stock New Effective Date mandatory while it is not in the sheet.

1.6.86 (15-Aug-2023)

Fixed the form message invisible issues.

1.6.85 (11-Aug-2023)

Container Item mode: Fixed the buffer too small message.

1.6.84 (11-Aug-2023)

UOM Inter-class mode: Fixed the issue of unexpected null value.

1.6.83 (11-Aug-2023)

Internal update.

1.6.82 (11-Aug-2023)

Internal update.

1.6.81 (10-Aug-2023)

Container Item mode: Added creating existing records validation on the form.

1.6.80 (09-Aug-2023)

Container Item mode: Added updating non-existing records validation on the form.

1.6.79 (07-Aug-2023)

Container Item mode: Added upload action column and validation in the uploading sql; provide the N as default value on the upload SQL if no data in the sheet.

1.6.78 (04-Aug-2023)

Container Item mode: Fixed fields blanked out unexpectedly issues.

1.6.77 (11-Jul-2023)

Updated the IW Extension package version in the log file.

1.6.76 (05-Jul-2023)

Removed the extension package.

1.6.75 (12-Jun-2023)

Internal update.

1.6.74 (08-Jun-2023)

Moved the Customer Item DFF next to the Customer Item section.

1.6.73 (06-Jun-2023)

Customer Xref mode: Removed mandatory for columns 'Master container' and 'Detailed Container'.

1.6.72 (31-May-2023)

Customer Xref Mode: Fixed the mandatory column missing issues.

1.6.71 (08-May-2023)

Internal update.

1.6.70 (08-May-2023)

Item Related mode: Fixed issue where users can still use the mode with R12.2.1 instance.

1.6.69 (05-May-2023)

Related Item mode: Removed the mode from the Wizard.

1.6.68 (05-May-2023)

Internal update.

1.6.67 (29-Mar-2023)

Fixed the issue of updating Safety Stock Quantity without the column 'New Quantity'.

1.6.66 (29-Mar-2023)

Safety Stock mode: Removed Action column.

1.6.65 (29-Mar-2023)

Safety Stock mode: changed Action column to optional.

1.6.64 (13-Mar-2023)

Safety Stock mode: Added Action column.

1.6.63 (08-Mar-2023)

Safety Stock mode: Fixed Safety Stock New Quantity issues.

1.6.62 (08-Mar-2023)

Safety Stock mode: Fixed the download issues when same item has same effective date, but with different org.

1.6.61 (27-Feb-2023)

Fixed User Instructions link.

1.6.60 (23-Feb-2023)

Fixed issue when [BLANK] is put in the Customer Name and Commodity Code fields.

1.6.59 (15-Feb-2023)

Internal update.

1.6.58 (15-Feb-2023)

Fixed issue when putting [BLANK] in the Level and and Customer Item field.

1.6.57 (09-Feb-2023)

Fixed issue when closing the Download filter size form with X.

1.6.56 (08-Feb-2023)

Customer XRefs mode: Fixed the issue when [BLANK] in the Level field.

1.6.55 (06-Feb-2023)

Internal update.

1.6.54 (06-Feb-2023)

Group the download button with Download Batch size filter onto one.

1.6.53 (06-Feb-2023)

Group the download button with Download Batch size filter onto one.

1.6.52 (06-Feb-2023)

Fixed issue of getting HTTP error 400 bad request while downloading large data.

1.6.51 (18-Jan-2023)

Fixed issue that caused large uploads to unexpectedly fail with error "438(Object doesn't support)".
Removed unsecure document links.
Fixed issue where enabling end to end trace did not generate the trace.

1.6.50 (13-Sep-2022)

Removed Specification mode and put into Item Wizard.

1.6.49 (12-Sep-2022)

Updating Licencing Modules.

1.6.48 (12-Sep-2022)

Updating Licencing Modules.

1.6.47 (25-Jul-2022)

Fixed issues when opening the form get error message (Item Number). Unable to find a match for the value you entered after being able to download.

1.6.46 (21-Jul-2022)

UOM Inter-class mode: Fixed the read only column default that won't update.

1.6.45 (21-Jul-2022)

UOM Inter-class mode: Fixed the read only column default features.

1.6.44 (11-Jul-2022)

Order the mode name in alphabetical order.

1.6.43 (11-Jul-2022)

Changed the mode name from UOM Intraclass to UOM Intra-class.

1.6.42 (11-Jul-2022)

Fixed the BLANK issue when updating.

1.6.41 (05-Jul-2022)

Internal update.

1.6.40 (28-Jun-2022)

Cross Reference mode: Removed mode and example sheet.
Added ABC Assignment mode example sheet.

1.6.39 (28-Jun-2022)

Transaction Default mode: Added the validation to stop supporting this mode from 12.2 onwards.

1.6.38 (11-Apr-2022)

Fix for One Drive saving issue by removing code from the on-save event.

1.6.37 (30-Mar-2022)

Fixed the ribbon Logging issue.

1.6.36 (29-Mar-2022)

Fixed the ribbon tooltips issue.

1.6.35 (21-Mar-2022)

Internal update.

1.6.34 (17-Mar-2022)

Internal update.

1.6.33 (03-Mar-2022)

Fixed issue with not being able to access Subinventory.

1.6.32 (25-Feb-2022)

Internal enhancement.

1.6.31 (25-Feb-2022)

Removed the profile for source assignment mode since it is using API, instead of table direct insert.

1.6.30 (25-Feb-2022)

Fixed issue with duplicated DFF columns in DFF Customer Item XRefs.

1.6.29 (20-Jan-2022)

Fixed issue with updating the lower area in Specification.

1.6.28 (14-Jan-2022)

Internal enhancement.

1.6.27 (01-Jun-2021)

Fixed the issue of min-max qty validation.

1.6.26 (01-Jun-2021)

Safety Stock mode: Added the download param type as numeric in Download selected.

1.6.25 (31-May-2021)

Safety Stock mode: Fixed issue with quantity while entering a letter.

1.6.24 (26-May-2021)

Safety Stock mode: Fixed SQL error when new quantity input as character.

1.6.23 (26-May-2021)

Safety Stock mode: Fixed SQL error when new quantity input as character.

1.6.22 (26-May-2021)

Subinventory mode: Fixed issue with BLANK functionality.

1.6.21 (11-May-2021)

Fixed the issue of special character KFF.

1.6.20 (28-Apr-2021)

Cross Ref Mode: Fixed the issue of special character in cross reference value.

1.6.19 (28-Apr-2021)

Cross Ref Mode: Fixed the issue of special character in cross reference value.

1.6.18 (28-Apr-2021)

Fixed the issue of not being able to update the customer item cross ref status and rank properly.

1.6.17 (16-Apr-2021)

Customer Item XRefs Mode and Safety Stock Mode: Fixed the profile issue for each mode.

1.6.16 (16-Mar-2021)

Updated security.

1.6.15 (16-Mar-2021)

Updated security.

1.6.14 (15-Mar-2021)

Specification Mode: Fixed the 1000 cache error.

1.6.13 (02-Mar-2021)

Added Specification DFF and Element DFF.

1.6.12 (22-Feb-2021)

Fixed issue with error message like 'A name was started with an invalid character'.

1.6.11 (27-Jan-2021)

Customer XRef Mode: Fixed issue with duplicated records.

1.6.10 (17-Sep-2020)

Fixed the version issue.

1.6.09 (17-Sep-2020)

Fixed the issue with error message when Template123 missing.

1.6.08 (16-Sep-2020)

Fixed the issue of Template123 missing.

1.6.07 (15-Sep-2020)

Safety Mode: Fixed the issue of unclear form.

1.6.06 (10-Sep-2020)

Subinventory Mode: Fixed the issue with list value in Source Organization code and source subinventory.

1.6.05 (03-Sep-2020)

Updated security.

1.6.04 (02-Sep-2020)

Fixed the issue of error in Safety Stock New Quantity while deleting.

1.6.03 (02-Sep-2020)

Fixed issue with the display of the small size of the Safety Stock form.

1.6.02 (02-Sep-2020)

Fixed the issue of creating a new safety stock with old days/missing updating value.

1.6.01 (02-Sep-2020)

Fixed the issue of not being able to update/delete the safety stock when the effective date is in the past.

1.6.00 (01-Sep-2020)

Fixed the issue of error message while source UOM is blank.

1.5.99 (27-Aug-2020)

Fixed the issue of dependence between Item Number and default locator. Hidden other mode example sheets according to the CACS EBs Example sheets requirements.

1.5.98 (26-Aug-2020)

Transaction Default Mode: Fixed the issue of error message/color for the Locator when transactable attribute is not set for the item.

1.5.97 (26-Aug-2020)

Intra-class mode: Fixed the issue of incorrect List value in Dimension UOM attributes.

1.5.96 (26-Aug-2020)

Transaction Default Mode: Fixed the issue of validation of Locator when opening the blank form.

1.5.95 (25-Aug-2020)

Transaction Default Mode: Fixed the issue of list of default type.

1.5.94 (20-Aug-2020)

Fixed the issue with deleting Cross Reference.

1.5.93 (20-Aug-2020)

Cross Reference Mode: Fixed the issue of new cross reference value required in the form.

1.5.92 (20-Aug-2020)

Cross Reference Mode: Made the New Cross Ref Value optional in the form and updated the Cross Reference Example Sheet.

1.5.91 (20-Aug-2020)

Cross Reference Mode: Fixed the issue of unclear error message for the creation of new cross reference.

1.5.90 (20-Aug-2020)

Cross Reference Mode: Fixed the issue of New Cross Ref Value required while updating DFF.

1.5.89 (19-Aug-2020)

Specification Mode: Fixed the issue of incorrect error message.

1.5.88 (10-Aug-2020)

Fixed the version issues.

1.5.87 (10-Aug-2020)

Fixed the issue of cross reference delete features while New Cross Ref Value is empty.

1.5.86 (03-Aug-2020)

Subinventory Mode: Fixed the issue of 11i updating.

1.5.85 (20-Jul-2020)

Internal enhancement.

1.5.84 (20-May-2020)

Fixed the issues of error while downloading based on the XRef Inventory Item in Customer Item Cross Reference mode.

1.5.83 (15-May-2020)

Updated security.

1.5.82 (14-May-2020)

Added the master organization code onto the Organization Code.

1.5.81 (06-May-2020)

Made Source Unit field shaded in the form.

1.5.80 (06-May-2020)

Updated the Template123 Read only columns color.

1.5.79 (05-May-2020)

Fixed issue with the 'Help' button - User Instructions.

1.5.78 (05-May-2020)

Fixed issue with the 'Help' button - Release Notes.

1.5.77 (05-May-2020)

Container Items - Fixed the issue of SQL error while downloading multiple items.

1.5.76 (01-May-2020)

Internal enhancement.

1.5.75 (09-Apr-2020)

Fixed issue of creating related item while Reciprocal Relationship flag is missing value.

1.5.74 (17-Mar-2020)

Rebranding of logo and color scheme.

1.5.73 (06-Feb-2020)

Customer XReference - Fixed the issue of SQL error when clicking on the Item via the form.

1.5.72 (03-Jan-2020)

Fixed the issue of updating UOM when GTIN profile set up and non_GTIN type.

1.5.71 (03-Jan-2020)

Fixed the issue of updating UOM when GTIN profile is not set up.

1.5.70 (03-Jan-2020)

Fixed the issue of updating UOM when GTIN profile set up.

1.5.69 (17-Dec-2019)

Major update for Common, Core and Custom Query.

1.5.68 (17-Dec-2019)

Major update for Common, Core and Custom Query.

1.5.67 (22-Oct-2019)

Fixed the DFF form references issues.

1.5.66 (21-Oct-2019)

Fixed the DFF form references for Address column.

1.5.65 (21-Aug-2019)

Internal enhancements.

1.5.64 (28-Jun-2019)

Safety Stock - Fixed error when uploading a large amount of records.

1.5.63 (27-Jun-2019)

Cross Reference - Fixed error in implementation when using older servlets.

1.5.62 (24-Jun-2019)

Internal fixes.

1.5.61 (24-Jun-2019)

Internal enhancement.

1.5.60 (26-Apr-2019)

Specifications - Fixed validation error when using [BLANK].

1.5.59 (16-Nov-2018)

Fixed error when attempting to upload with a DFF that has a reference field.

1.5.58 (02-Nov-2018)

Cross Reference - Fixed upload error when update Cross Reference values in 11i.

1.5.57 (24-Oct-2018)

Cross Reference - Fixed Upload error when update Cross Reference values in 11i.

1.5.56 (02-Oct-2018)

Internal enhancements.

1.5.55 (02-Oct-2018)

Internal enhancements.

1.5.54 (24-Aug-2018)

Internal enhancements.

1.5.53 (20-Aug-2018)

Fixed issue where duplicated PL/SQL UOM procedures in Post_login_Events would cause an XPROC error when inserting.

1.5.52 (25-May-2018)

Specifications - Fixed validation error when the 'Spec Effective From' or 'Spec Effective To' columns are removed from the sheet.

1.5.51 (25-May-2018)

Specifications - Fixed validation error where it was expecting Specification Elements when Reference Spec had a value.

1.5.50 (22-May-2018)

Pending Status - Fixed error where date formats were being changed on the sheet when doing an upload.
Fixed validation error when attempting to Delete a Pending Status.
Specifications - Fixed error where the Reference Spec column was disabled on the form.
Added validation to make sure Specification Elements have been added.
UOM Intraclass - Fixed upload error as uploading rows with different Base UOM's resulted in rows being skipped.
Container Items - Fixed download error where Items without Container Types were not getting downloaded.

1.5.49 (15-May-2018)

Custom Query - Updated Downloader modules to fix error when changing between Download via Form and Download via Sheet.

1.5.48 (04-May-2018)

Specifications - Fixed error when Downloading via sheet with no criteria.
Updated the Cross Reference example sheet to include the New Cross Ref Value column.
Cross Reference - Added validation so that New Cross Ref Value column is not required when deleting a cross reference.

1.5.47 (02-May-2018)

Cross Reference - Added 'New Cross Ref Value' column as previously attempting to update duplicate GTIN Cross References would cause a conflict with the API.

1.5.46 (01-May-2018)

Internal update.

1.5.45 (01-May-2018)

Hide the menu buttons of Line form, Header DFF form and Line DFF form if selected mode does not have these sections implemented.

1.5.44 (16-Apr-2018)

Customer Item XRefs - Fixed error where the XRef Customer Item was not defaulting correctly from the Customer Item.

1.5.43 (13-Apr-2018)

Cross Reference - Fixed Primary Key Violation error when trying to update.

1.5.42 (12-Apr-2018)

Safety Stock - Fixed error where the Display only columns were not grey on the form.

1.5.41 (11-Apr-2018)

Cross Reference - Fixed validation error when attempting to Delete a Cross Reference.
Transaction Default - Fixed error when attempting to download multiple rows in one download.
Safety Stock - Fixed error when searching for an Item Number.
Customer Item XRefs - Made the XRef Customer Item Display Only.

1.5.40 (10-Apr-2018)

Fixed error where the Download via Sheet icon on the Custom Query ribbon tab was missing.

1.5.39 (04-Apr-2018)

Updated Security.

1.5.38 (20-Mar-2018)

Cross Reference - Fixed error when Downloading as the Cross Reference Value was not printing leading zeros correctly.

1.5.37 (13-Feb-2018)

Updated Downloader Modules.

1.5.36 (25-Jan-2018)

Cross Reference - Improved the error message when the length of cross reference value is exceeding the maximum length of Oracle requests.

1.5.35 (22-Jan-2018)

Cross Reference - Fixed the issue where upload failed if the cross reference value has over 25 characters.

1.5.34 (19-Jan-2018)

Cross Reference - Fixed the issue where upload failed if the cross reference value has over 25 characters.
Fixed the issue where no error message returned if cross reference upload failed with an Oracle API error.

1.5.33 (11-Dec-2017)

Sourcing Assignment - Fixed upload error when the Delete Sourcing Rule column was not on the sheet.

1.5.32 (02-Nov-2017)

Transaction Default - Supported multiple Subinventory/Locator combinations for the same Org/Item/Default_type.

1.5.31 (31-Oct-2017)

Added in fix for reinstalling profile options where the profile option value was being overwritten.

1.5.30 (30-Oct-2017)

Added IEW_Latest_Version_Check to prevent profile options from being reinstalled when the Version Number profile option is the same as the one on the DB.

1.5.29 (12-Oct-2017)

Updated Security.

1.5.28 (12-Oct-2017)

Updated core to 213.02 to add the ability to write raw xml to error log sheet when parsing xml error happens.

1.5.27 (20-Sep-2017)

Related Item - Fixed the issue downloading got SQL error when having Related Item in the spreadsheet as one of download criteria.
All Modes - Fixed the issue where Date DFF value displays incorrectly on download.

1.5.26 (08-Sep-2017)

Related Item - Removed validation of start date have to be greater than end date if it is a deletion.
Fixed the issue where wrong data downloaded when the data type of Descriptive flexfield columns were standard date type.

1.5.25 (07-Sep-2017)

Added DFF support to Related Item.

1.5.24 (30-Aug-2017)

Support passing inventory_item_number to extension package.

1.5.23 (30-Aug-2017)

Fixed the issue where Download via Sheet did not take all the value in the spreadsheet as download criteria.

1.5.22 (29-Aug-2017)

Added the checking for having using extension package enabled but no extension package installed.

1.5.21 (28-Aug-2017)

Fixed the issue where download failed with table or view does not exist error.

1.5.20 (28-Aug-2017)

Cross Reference - Added extension package support.
Added Item Description column.

1.5.19 (25-Aug-2017)

Cross Reference - Added extension package and Item description.

1.5.18 (14-Aug-2017)

Transaction Default - Fixed the issue getting SQL error when searching default locators combination.

1.5.17 (14-Aug-2017)

Customer fix.

1.5.16 (11-Aug-2017)

Transaction Default - Fixed the issue where upload failed due to the limitation of maximum size of pl/sql block in R11.

1.5.15 (11-Aug-2017)

Transaction Default - Fixed the issue getting http error on R11 for bulk data load.

1.5.14 (03-Aug-2017)

Updated Security.

1.5.13 (02-Aug-2017)

Internal fix.

1.5.12 (01-Aug-2017)

Fixed issue when getting error message when searching the list for key flexfield segments.

1.5.11 (01-Aug-2017)

Updated the core code.

1.5.10 (31-Jul-2017)

Updated the common code to the latest version.

1.5.09 (31-Jul-2017)

Subinventory - Fixed the issue where failed to get list of values of segments which is table type and using MFG_ORGANIZATION_ID in the value set.

1.5.08 (28-Jul-2017)

Subinventory - Changed so IEW does not use the IW server package.

1.5.07 (28-Jul-2017)

Fixed the issue where failure to upload the item when the organization does not have an operating unit.

1.5.06 (21-Jul-2017)

Related Item - Fixed the issue where code blew up if the Effective Date From or Effective To is invalid date format or removed Effective Date From.

1.5.05 (20-Jul-2017)

Related Item - Fixed the issue where code blew up if the Effective Date From or Effective To is invalid date format.

1.5.04 (20-Jul-2017)

Updated the 'Setup' sheet to the latest one.

1.5.03 (20-Jul-2017)

Added writing warning message for upload to message column.
Specification: When no data changed as Specification Element exists upload results will be marked as 'Warning' rather than 'Accepted'.

1.5.02 (17-Jul-2017)

Customer Item XRef: Fixed the issue where code blows up when "Departure Plan Required" and "Departure Plan Before Build" do not exist in the spreadsheet.

1.5.01 (13-Jul-2017)

Customer Item XRef: Fixed the issue where after removing Positive Demand Tolerance column code blow up when uploading.
Safety Stock, ABC Assignment: Fixed the issue uploading failed all the time. Set the defaulter as the column validator wrongly.

1.5.00 (12-Jul-2017)

Specification, Related Item, UOM IntraClass: Fixed the issue where after removing some of columns code blow up when uploading.

1.4.99 (12-Jul-2017)

Updated to the latest common code to fix the issue where code blows up after removing DFF context then opening the form or removing all DFF columns then doing upload.
Subinventory: Fixed the issue where after removing some of columns code blow up when uploading.

1.4.98 (07-Jul-2017)

Internal fix.

1.4.97 (06-Jul-2017)

Fixed the issue downloading wrong locators.

1.4.96 (06-Jul-2017)

Added ribbon gallery 'Form' and moved 'Header Form', 'Line Form' under it.
Updated core to the latest version (212.23 currently).

1.4.95 (03-Jul-2017)

Upgraded the Core to 213 release (212.21 currently).

1.4.94 (03-Jul-2017)

Related Item: Fixed the issue not writing the error message to Process Message column.
Customer Item XRef: Fixed the issue where the code blows up when uploading and XRef Customer Item column does not exist in the spreadsheet.
Subinventory: Fixed the issue where code blows up when searching supplier, subinventory or searching source subinventory. Added dependency to Subinventory search control.

1.4.93 (29-Jun-2017)

Fixed the issue where the upload with DFF columns failed for all modes having DFF columns.
Updated to new common code to fix printing of data when chunking a parent download with no children.
Cross Reference: Fixed the issue showing the non-sense error message when validating Unit of Measure. Fixed the issue not writing the error message to Process Message column.

1.4.92 (28-Jun-2017)

Container Item: Fixed the issue where DFF values were not uploading.
Customer Item XRef: Fixed the issue where DFF values were not uploaded. Fixed the issue with XRef Custom Item.
Transaction Default: Fixed downloading failed with SQL error. Updated to new common code to fix printing of data when chunking a parent download with no children.

1.4.91 (26-Jun-2017)

Updated the DW to the latest version 1.0.79

1.4.90 (30-May-2017)

WIP - Common 2.4 upgrade.

1.4.89 (25-May-2017)

Container Item: Maximum Load Quality is now required and not allowed to remove the column from spreadsheet.
Specification: Fixed the issue that upload failed if Spec Enabled does not exist in the spreadsheet.
Related Item: Fixed the issue that upload failed if Delete Relationship column does not exist in the spreadsheet. Fixed the issue that upload failed if Reciprocal Relationship column does not exist in the spreadsheet and the Relationship type is 'Related'.
UOM Intraclass: Fixed the issue where download failed if Base UOM column does not exist in the spreadsheet.
Transaction Default: Fixed the issue that Default Locator search did not work. Fixed the issue where upload failed if column 'Default Locator' does not exist in the spreadsheet.

1.4.88 (23-May-2017)

Cross Reference: Fixed the issue where failed to delete a cross reference if there is same cross reference existing with organization code is 'ALL'.

1.4.87 (03-May-2017)

Fixed Debug Upload options in the ribbon.

1.4.86 (02-May-2017)

Added fix for carriage return in 10.2 databases - caching mechanism wouldn't work. Transaction Default - Default Subinventory: Removed Filter from search as we have hit the servlet limit for search binding. This means extra subinventories will be added to the LOV.
However, validation will throw these out on upload. This has been fixed in Common 2.4

1.4.85 (01-May-2017)

Changed Item Number columns to use caching mechanism (Except for UOM modes) for performance boost.
Changed Transaction default Locator column to use caching for performance boost.

1.4.84 (11-Apr-2017)

Fixed the issue where ribbon button 'Show/Hide Login Info' did not work.

1.4.83 (27-Mar-2017)

Fixed issue for all modes where code blew up when the database has non-utf8 encoding.

1.4.82 (24-Mar-2017)

Manufacturer - Fixed the issue where code blows up when the database is 10g or encoding is not set to utf-8.

1.4.81 (28-Feb-2017)

Manufacturer - Improved the error message when record does exist in the database.

1.4.80 (27-Feb-2017)

Manufacturer - Fixed the issue where upload blow up if the DFF content contains special characters like singe quote.
Fixed issue where error message from upload package was not written back to upload error message column.

1.4.79 (27-Feb-2017)

Now setting Language on Login: Language for the user is now being set from user's EBS preferences irrespective of what is chosen on the Browser Login page.

1.4.78 (27-Feb-2017)

Manufacturer - Implemented the DFF section.
Ribbon - Added DFF buttons to open DFF forms for header and line.

1.4.77 (09-Feb-2017)

Customer Item XRefs - Fixed the issue where the form labels were partially hidden.

1.4.76 (02-Feb-2017)

Updated Download to the latest version (1.0.71).
Related Item - Fixed the issue where the upload results for all the lines except last line were not written back to the spreadsheet.

1.4.75 (28-Dec-2016)

Sorting all LOVs alphabetically.

1.4.74 (15-Dec-2016)

Added fix for Customer Number defaulting.

1.4.73 (14-Dec-2016)

Changed Customer Number to be driving column. Name will default number in a 1-1 relationship. Number used for upload.
Implemented fix for 'overflow' error when selecting responsibility on login.

1.4.72 (12-Dec-2016)

Fixed ambiguity where Customer Name in Customer XRef template was not mandatory but user form is.

1.4.71.7 (16-Mar-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.

1.4.71 (12-Dec-2016)

Fixed compile error when logging in while using 64 bit excel.

1.4.70 (07-Dec-2016)

Updated Security.

1.4.69 (06-Dec-2016)

Fixed issue where upload failed when deleting records.

1.4.68 (06-Dec-2016)

Cross Reference, Subinventory, Container Items, Customer Item - Fixed issue where upload will blow up if there is no any DFF in the database.

1.4.67 (29-Nov-2016)

Added carriage return at the end of the upload plsql block for each mode as the upload might fail if the length of one line exceeds 64K.

1.4.66 (21-Nov-2016)

Corrected the name of Ribbon for IEW.
Pending Status - Added the validation that we should only be able to delete a row if it has not yet been implemented.
Transaction Default - Added validate status checking when deleting transaction default just in case subinventory or locator is invalid and causes SQL error.

1.4.65 (14-Nov-2016)

ABC Assignment - ABC Groups which do not have a compile or do not have any class will not be listed in the form.
Customer Item XRef - Fixed the issue where fake failure error messages are written back.

1.4.64 (09-Nov-2016)

Changed all status and message columns to mandatory to stop user from deleting them when creating the template.
Specification - Added validation to check the data type of target value and upper/lower limit according to the data type of element.
Fixed issue where API error for upload was not written back to spreadsheet.

1.4.63 (08-Nov-2016)

Specification - Change the validation for high and low limit to allow the same value for high value and low value.
Cross Reference - parentSection.selectSQL: Changed back to use combination as the Element rather than the cross_reference_id as before R12 there is no cross_reference_id in the MTL_CROSS_REFERENCES_V.
Related Item - Changed the error message to INV_DUP:"Relationship is already defined" when data exists.

1.4.62 (04-Nov-2016)

Subinventory, Specification - Added separately upload status and messages columns for children section.
Subinventory - Added the data type validation to stop the code blowing up when non-numeric characters entered.
Fixed the issue where the value was not cleared when entering [BLANK].
Fixed issue where upload results for locators will overwrite the result of Subinventories.
Pending Status - Fixed issue where duplicated records were downloaded.

1.4.61 (27-Oct-2016)

Safety Stock - Allow the user to delete regardless if the effective date is greater than today.
UOM Intraclass - Fixed issue where the UOM Length, Width and Height were not uploaded.
Container Item - Fixed the upload issue where MAX LOAD QUANTITY wasn’t uploaded.
Modified the template123 sheet to set all display only columns to read only with grey colour.
Customer Item XRef - Change the customer number to writable and write customer number back to spreadsheet when we get the customer number back from customer name.
Added validation to check if there are multiple customers returned using the customer name, then customer number field is required.

1.4.60 (21-Oct-2016)

Subinventory - Changed the template123 to make Locator to have children section style.
Tran Default - Fixed issue where organization code is used as organization id for locator querying and this failed to retrieve the locator list.

1.4.59 (21-Oct-2016)

Specification - Fixed the download issue where wrong data were written to the spreadsheet.
Specification - Fixed the issue where labels of Element, UOM and Enabled were truncated on the user form as the length of label control was too short.
Fixed issue where code blew up when assigning the responsibility without choosing any template.
Customer Item XRef - Fixed issue where failure to load user form if DFF columns are removed from either template or spreadsheet.
Fixed issue when SQL error returned when download Customer Item XRef.
Customer Item XRef - Allow the update for all the columns when only part of columns of customer item were allowed to be updated.

1.4.58 (19-Oct-2016)

Fixed issue when failing to open the form for all modes that have DFF columns but DFF columns are removed from the customized template.
Container Item - Fixed issue of failing to upload DFF columns.
Cross Reference, Manufacturing, Pending Status, Sourcing Assignment, Transaction Default - Fixed the issues where duplicated records were downloaded.
Fixed issue when failure to open Customer item/Customer Item Refer form when no DFF set for customer item/customer item reference.
Removed the extra Item Number column for ABC Assignment and Sourcing Rule Assignment.

1.4.57 (17-Oct-2016)

UOM InterClass - Made changes for following controls:
- Made Destination Class as display only
- Made Destination Unit as required
- Made Disable Date as not required
ABC Assignment - Fixed the issue when duplicated items were downloaded.
Fixed issue where ABC Class was not populated after choosing the organization and ABC group.

1.4.56 (14-Oct-2016)

Fixed issue where failed to retrieve list of value for Customer Item.
Fixed issue when double clicking Customer Item Reference DFF context will open the customer item DFF form.

1.4.55 (12-Oct-2016)

Updated to the latest common.

1.4.54 (12-Oct-2016)

Fixed issue when Customer Number was not populated after choosing the customer name.
Fixed issue that failed to create/update the Customer item XRef as Customer item number was used and won’t be accepted by Oracle.

1.4.53 (07-Oct-2016)

Added Source Class to form of Inter-Class to fix the issue that UOM Inter Class Source Class is not automatically populating.
Fixed issue of disable data was missed when creating/updating Customer Item.
Changed the Source Class of Intra Class to the class of source unit. Previously it was using the class of UOM of ITEM primary UOM which is wrong.
Created a new separated form for inter-class and no longer shares the form of intra-class.

1.4.52 (29-Sep-2016)

Another fix for no function status issue for Sourcing Assignment module.

1.4.51 (09-Sep-2016)

Fixed the no function status issue with Sourcing Assignment module.

1.4.50 (09-Sep-2016)

Fixed issue when Effective Date From is blank the validation of Related Item Effective Date blows up.

1.4.49 (08-Sep-2016)

Fixed issue when deletion of Manufacturer and Related Item blows up.
Fixed issue when duplicated records were downloaded for Manufacturer.

1.4.48 (07-Sep-2016)

Added 'Transaction Type' for Transaction Default to separate subinventory setting and locator setting.

1.4.47 (04-Aug-2016)

Fixed issue when code blows up when having % for Container Maximum Quantity.

1.4.46 (01-Sep-2016)

Fixed issue when incorrect list of value were returned for subinventory and locator.

1.4.45 (31-Aug-2016)

Fixed issue of no function status for all modules. The issue occurs when switching between different responsibilities.

1.4.44 (31-Aug-2016)

Added checking for depLevel to stop code blowing up when Definition Level column is missing in the spreadsheet.

1.4.43 (30-Aug-2016)

Updated the DW to the latest version 1.5.08

1.4.42 (04-Aug-2016)

Fixed the issue when the list of values missed the locators which have item as null.

1.4.41 (22-Jul-2016)

Fixed the issue that user could not create new locators/locators with projects (in past or present).

1.4.40 (28-Jun-2016)

Fixed Profile Option Upload Security.

1.4.39 (28-Jun-2016)

Changed to using master organization for the validation of Reciprocal Relationship.

1.4.38 (24-Jun-2016)

Added profile option "More4Apps: IW Override Upload Security" at the responsibility level. Set to Yes to override function security.

1.4.37 (23-Jun-2016)

Fixed issue where Related Item Effective Date validation failed and code blew up.

1.4.36 (20-Jun-2016)

Added a new function name for defining Sourcing Rules.

1.4.35 (02-Jun-2016)

Security improvement.

1.4.34 (27-May-2016)

Removed Org ID column from Manufacturer and Related Item mode as we need the master organization rather than all the organization units.

1.4.33 (16-May-2016)

Fixed the issue that time was missed for last_update_date and creation_date. Only the date was reflected.

1.4.32 (19-Apr-2016)

Added debug mode option.

1.4.31 (03-Mar-2016)

Security improvement.

1.4.30 (26-Feb-2016)

Changed the name of Wizard logo picture from picture1 to CustomLogo.

1.4.29 (26-Feb-2016)

Added Downloader functionality into the Wizard.

1.4.28 (18-Feb-2016)

Updated to latest common 2.

1.4.27 (26-Jan-2016)

Fixed custom column labels on multi-mode columns from causing a crash when loading the form.

1.4.26 (26-Jan-2016)

Fixed the issue that numeric values was returned as string.

1.4.25 (10-Oct-2015)

UOM Inter-Class: Removed source class from defaulting as can only be retrieved on download once a conversion is created.

1.4.24 (03-Oct-2015)

UOM: Separated columns into Source And Destination.

1.4.23 (02-Oct-2015)

UOM Inter-Class mode: Added ability to update disable date and conversion rate.

1.4.22 (30-Oct-2015)

Added UOM Inter-Class mode.

1.4.21 (02-Oct-2015)

Fixed UOM length, width and height columns rounding numbers when inserting into oracle for UOM Intraclass.

1.4.20 (24-Sep-2015)

UOM IntraClass - Fixed issue where wrong mode causes form to crash.

1.4.19 (27-Jul-2015)

UOM INtraClass - Fixed issue where conversion value loaded into oracle was missing decimal places.

1.4.18 (30-Jun-2015)

UOM IntraClass - fixed issue where an error occurs on disable date.

1.4.17 (07-Apr-2015)

Cust Item XRef - fixed Xrefs not being uploaded when customer item was being created.

1.4.16 (27-Mar-2015)

Customer Item XRef - Changed caching of customer item IDs to include customer item in key

1.4.15 (25-Mar-2015)

Customer Item XRef - Changed customer Item to have search control.

1.4.14 (18-Mar-2015)

Related item - Fixed "Delete Relationship" not validating dependent columns.
Related item - Related Item API will reject relationship type Related'. Have fixed to use original upload for this type.

1.4.13 (16-Mar-2015)

Safety Stocks - Added Item ID join to download as too many results were being returned.

1.4.12 (04-Mar-2015)

Fixed pending status mode upload
Pending Status - can now create new pending status for same item where effective date is different
Pending Status - can now delete pending status where implemented date isnt set
Pending Status - Added implemented Date display only column

1.4.11 (20-Feb-2015)

Fixed Customer Item Updating running slowly.

1.4.10 (18-Feb-2015)

Enhancement - Enabled Customer Item XRef update fields: inactive flag & rank (preference_number) and DFFs.

1.4.09 (13-Feb-2015)

Changed Customer Item XRef to look at customer Number over customer name (to derive ID) for upload/validation as customer name can have multiple customer numbers.

1.4.08 (11-Feb-2015)

Cleaned up workbook styles.

1.4.07 (11-Feb-2015)

Enhancement - Added Safety Stock load type.

1.4.06 (10-Feb-2015)

Fixed downloading by customer item XRef inventory item download column.

1.4.05 (04-Jan-2015)

Cust Item XRef - Added Customer Number as download column.

1.4.04 (13-Jan-2015)

Cross Reference mode - Fixed issue where independent ORGS would not download.

1.4.03 (07-Jan-2015)

All Modes - Fixed Upload ALL issue where lines were being excluded from upload

1.4.02 (07-Jan-2015)

Improved the performance for Cross Reference download.

1.4.01 (05-Dec-2014)

Performance improvement.

1.4.00 (16-Dec-2014)

Fixed issue that failed to upload Intra-class without error message.

1.3.99 (02-Dec-2014)

Cross Reference - Fixed org ALL validation where organization ID was returning -1.

1.3.98 (13-Nov-2014)

Security improvement.

1.3.97 (04-Nov-2014)

Fixed issue if no organizations are found, alert the user instead of blowing up.

1.3.96 (04-Nov-2014)

Added INV_INVIDITM_ORG to Cross Reference Function check.

1.3.95 (31-Oct-2014)

Trans Default - Fixed KFF form project segments being added/removed when doing upload.

1.3.94 (28-Oct-2014)

Customer Item XRef - Fixed Container fields not updating in some circumstances.

1.3.93 (28-Oct-2014)

Implemented Detail Container and Master Container.

1.3.92 (07-Oct-2014)

Customer Item XRef - Customer Item XRef item dropdown now changes depending on customer item

1.3.91 (07-Oct-2014)

IEWRibbon, Customize Fields now calls SelectFields for the mandatory fields form

1.3.90 (06-Oct-2014)

Replaced recent changes and put in Team Leader’s SetMode code from Common Implementation

1.3.89 (06-Oct-2014)

Changed ribNewSheet_onAction to check for a valid mode before opening frmNewWorksheet
Changed the wording on the ribbon from Select Mandatory Fields to Customize Fields

1.3.88 (02-Oct-2014)

Changed the way we disabled the modes via frmSecureModes as hiding from the ribbon dropdown was creating errors as indexes were changing

1.3.87 (25-Sep-2014)

set sws.Cells(5, 1) = 1 in frmSecureMode as was getting subscript out of range errors when removing modes from Upload Option Dropdown

1.3.86 (15-Sep-2014)

Related item Mode – validatorRelEffectiveDates (check for relationship dates not needed)

1.3.85 (10-Sep-2014)

Related Item Mode – Effective dates not required to be present for relationship type on delete

1.3.84 (09-Sep-2014)

Related Item Mode – Change Planning Level validation to allow for ‘No’ but not ‘Yes’ for relationships without planning enabled

1.3.83 (09-Sep-2014)

Related Item Mode – Can create related items for type migration without dates

1.3.82 (09-Sep-2014)

Moved current date validation to isValidUpload from validatorRelEffectiveDates as we only need to validate this if not deleting a relationship

1.3.81 (03-Sep-2014)

Fixed Default Row formatting in Template123

1.3.80 (03-Sep-2014)

Fixed grammar in preview sheets row 10 defaults Cell A10

1.3.79 (02-Sep-2014)

Fixed grammar in row 10 defaults Cell A10

1.3.78 (01-Sep-2014)

Spec UOM in specifications mode: LOV now allows percentage symbol
Support – ShowForm – Added check for message column so section form does not open
Removed upload ID from being returned in specifications as not needed.
Check added to SetReturnResults to ensure status is not overwritten with multiple messages

1.3.77 (28-Aug-2014)

Fixed issue where row 10 would be populated when saving child data

1.3.76 (26-Aug-2014)

Added absolute cell reference to defaultRow10Formula, fixed clearing cell contents of formula

1.3.75 (26-Aug-2014)

SQL default now populates for each section on upload all
Formulas are no longer written to sheets

1.3.73 (20-Aug-2014)

For Default Row consistency across Wizards, added note and changed colour of default row in status column

1.3.72 (15-Aug-2014)

Use setBlank in validatorNumeric for container maximum quantity column in container items
Implemented new common defaultRow 10 and upload profile option
Removed Process ID Column as not needed

1.3.71 (14-Aug-2014)

Removed IW from WizardIgnoresOrganisation as cust item Xref uses the cache IOU ID for getMasterOrg

1.3.70 (14-Aug-2014)

Changed M4APS_APPS to IW which will mean core profile options and license keys/users come under IW
appCustomisations has notes relating to wizard specific core changes, every time the core is updated please read the notes
Wizard specific profile options now use M4APS_APPS_IW for the creation and check of the Wizard specific profile options

1.3.69 (12-Aug-2014)

Fixed issue where mandatory column messages didn’t appear as was not checking setWizardColumnHeaders

1.3.68 (28-Jul-2014)

Fixed Customer Item XRef form labels being misaligned
UploadCustomerItem – Removed master item ID check as not needed for update

1.3.67 (25-Jul-2014)

Cross reference download required a join back to the item table even if item number not selected. Changed to use view to get around this

1.3.66 (21-Jul-2014)

Supply Subinventory field – Subinventory is now mandatory
‘Default Subinventory’ and ‘Default Locator’ fields should not validate false on form open

1.3.65 (21-Jul-2014)

ABC Item field is now mandatory for ABC Assignment

1.3.64 (18-Jul-2014)

Validator Trans Default – Pass in ctl to SetSQL
UOM Conversion is now mandatory

1.3.63 (18-Jul-2014)

Fixed Organization column not being created on Sourcing Assignment template

1.3.62 (17-Jul-2014)

Profile Options changed from IW to IEW

1.3.61 (16-Jul-2014)

Updated Core to 209 for 12.2 fix

1.3.60 (11-Jul-2014)

Added ‘Cross Ref Value’ as a downloadable column for Cross Reference Mode

1.3.59 (10-Jul-2014)

Made Default Sub isRequired in Mode Trans Default
Removed isblank(row) from validatorItem as column is required anyway

1.3.58 (09-Jul-2014)

Check for section.items (if there is none, then mode is wrong)
Customer Item LOV now updates when changing customer name

1.3.57 (09-Jul-2014)

Changed all form tab ordering and coded form cursor to appear in the control corresponding to the column double clicked on

1.3.56 (08-Jul-2014)

Fixed Transaction Default Validating false on form startup (now is based on org code)

1.3.55 (08-Jul-2014)

Changed Customer Item Upload SQL
Fixed Tab Indexing on Customer Item XRef Form
Fixed duplicate error messages

1.3.54 (08-Jul-2014)

Changed Customer Item Upload SQL
Changed from “Validate and Upload” to “Validate Commit” in ribbon

1.3.53 (08-Jul-2014)

Customer Item Desc in CustItemXRef mode now clears
Down arrow key only validates on last record

1.3.52 (07-Jul-2014)

Changed XRef Customer Item to combobox to allow for blank values (from disabled text control)
Changed ValidatorCustomerItemXRef to add the cust Item to the list box and validate

1.3.51 (04-Jul-2014)

Started Versioning from .5 as needs to be lower than Item Wizard
Removed XRef Active default value as was causing validation errors
Fixed fields not being validated on OK for each DFF section

1.3.5 (03-Jul-2014)

Check for isDebug in SetReturnResults to only display Upload ID in debug mode
ABC easy as 1 2 3, Fixed modes being in alphabetical order
Fixed value required when value was specified in form
Customer Item Description in Cust Item XRef Mode now uses ValidatorDefaultParent to OverWrite when changing cust item
Download when whole row selected should be a lot faster (was adding data based on cell, not row)
Fixed ‘Online Documentation’ and ‘Getting Started’ Links on the Setup sheet
Added Duplicate Error Message on Cust Item XRef Upload

1.3.4 (02-Jul-2014)

Fixed Base UOM for UOM Intraclass Mode downloading incorrectly
Added DFF Attribute Columns to template to fix column formatting
Fixed Global DFFs not appearing when context changes using custom column labels
Updated Section Upload message
Customer Item Xref Item messages now display correctly in the results column

1.3.3 (30-Jun-2014)

Removed old redundant ‘set controls’ in cross reference as already in Main
Fixed DFF fields with custom labels causing errors in upload (for each section with DFF)

1.3.2 (27-Jun-2014)

Added line number check for if line numbers have not been added
Can now download by Container Item in mode Container Items
Customer Item XRef – Customer Item DFF context dropdown column width increased as truncating text
Changed ‘Required Column’ message in Main to give the user a clue as to why they are receiving it

1.3.1 (27-Jun-2014)

Fixed KFFs dependencies to be in line with new dependency model

1.3.0 (25-Jun-2014)

Changed processing form error message to inform that the header has only been uploaded
Fixed issue with Customer Item XRef upload not returning error messages

1.2.9 (24-Jun-2014)

Changed Alternate wizard function from INV_INVIDITM to INV_INVIDITM_MANU for manufacturing parts mode

1.2.8 (20-Jun-2014)

Changed Customer Items Upload PLSQL to return message if update is successful
Container Quantity cannot be blank for Container Items Mode

1.2.7 (19-Jun-2014)

Moved col.control check for context so form tab still set if ctl is nothing in SetControls
Added check for DFF col to set multipage in SetControls

1.2.6 (18-Jun-2014)

Added ‘Uploading to Oracle’ message in processing form when uploading to Oracle
Added ValidatorXRank for XRef Rank so rank is only invalid if there is no xref customer item
Fixed form not opening the correct tab when opening a child section (for each section with children)

1.2.5 (16-Jun-2014)

Made “Context Value” label larger as value was being cut off in Dff Customer Items in Customer Item Xrefs mode
Removed validate extension at the beginning of ValidatorCustomerItem as error messages were causing confusion and it is not needed

1.2.4 (10-Jun-2014)

Updated dependencies with the new common dependency model

1.2.3 (10-Jun-2014)

Fixed Transaction Default download not downloading

1.2.2 (10-Jun-2014)

Allowed Supplier when planning level checked in validatorPlanningLevel

1.2.1 (09-Jun-2014)

validatorPlanningLevel: Added in check for source type = supplier ID(2)

1.2.0 (05-Jun-2014)

Added checkPlanningLevel to validatorPlanningLevel to only check planning level for MIN-MAX PLANNING, MIN MIN MAX QTY, MAX MIN MAX QTY

1.1.9 (05-Jun-2014)

Added validatorFilterKFF for Default Locator in Transaction Default mode

1.1.8 (05-Jun-2014)

Fixed organization ID query Union join in ImplementationParent for cross reference section

1.1.7 (04-Jun-2014)

Set isAllowedBlank = vbTrue in implementationSpecifications for columns:
Spec Upper Limit Spec Lower Limits
User Upper Limit User Lower Limit
Reasonable Upper Limit Reasonable Lower Limit

1.1.6 (30-May-2014)

Changed implementation for Subinventory Supply Locator to use CASE in col.SQL

1.1.5 (30-May-2014)

Extended ValidatorLOV onto Supply Locator as there was no LOV check
Changed implementation for organization code to bring back project enabled for Project Segments
Used ‘lookup_code’ for sqlColumn in Delete Transaction Default in ImplementationTransDefault
Changed Delete Transaction Default Bound column to 2 for dependency
Removed disabling of control when “Yes” in ValidatorDeleteTranDefault
Changed downloader of Supply Locator to add in false delimiters
ValidatorSupplyLocator now adjusts KFF form object depending if project enabled to display correct segments

1.1.4 (27-May-2014)

Changed bound column of cboCustomerItem_1 to 1 from 2 to prevent ctl null value on form startup frmCustomerItemXRef
Changed supply locator to generate concatenated segments with false delimiters in subinventory implementation

1.1.3 (27-May-2014)

Fixed bug preventing data from being written to sheet in each form (Ensure row C_STATUS is valid)

1.1.2 (26-May-2014)

Fixed wrong columns being used in the minimum maximum ValidatorMinMaxValues

1.1.1 (26-May-2014)

Added ValidatorMinMaxValues to ensure min values are less than max values for mode subinventory
Changed Base UOM download column from b.unit_of_measure to item.primary_unit_of_measure for correct data

1.1.0 (23-May-2014)

Update Core Modules to 208 and Common Code
Fixed Online-Documentation and Online-Release notes links
Changed ‘subinventory_context’ to ‘cross_ref_context’ as was not downloading into Xref context column
Used new form code on each form sections startup to get the correct row
MTL_CROSS_REFERENCES used for DFF (for reference client was expecting MTL_CROSS_REFERENCE_TYPES)

1.0.99 (20-May-2014)

Spec Enabled field flag now uploads correctly (previously was always being set to No)
Error message now displays when Specification already exists in upload

1.0.98 (19-May-2014)

Fixed validatorLOV crash for Delete Specification by changing Bound Column from 3 to 2

1.0.97 (15-May-2014)

Removed column “Test10″ from Sub Inventory template
Removed column “Organization Code” from UOM Intraclass as not used
Updated templates to include blank separators
Added Related Items Example Sheet

1.0.96 (14-May-2014)

Fixed bug in Cross References Context DFF preventing user from using DFFs

1.0.95 (13-May-2014)

Removed Item Number column from ABC and XRef templates, as well as Organization Code from Xref as not used

1.0.94 (12-May-2014)

Supply Subinventory field is now mandatory, forms for other modes do not open
Error message updated in Initialise Columns displaying mode
Sourcing Assignment Upload now deletes records and displays error if none found
Column ‘Item Number’ Removed from Sourcing Assignment template as not used

1.0.93 (12-May-2014)

Can now download using the Manufacturer Part field in Manufacturer template

1.0.92 (09-May-2014)

Fixed bug preventing user from creating a “Container Items” template

1.0.91 (09-May-2014)

Updated fndBlockList

1.0.90 (07-May-2014)

New Wizard Logo, Originally Item Wizard now Item Extension Wizard

1.0.89 (05-May-2014)

Fixed problem with user defined labels using new function SetLoadedColumnLabels

1.0.88 (30-Apr-2014)

Implemented frmNewWorksheet to create a new sheet based on a mode

1.0.87 (30-Apr-2014)

Added update functionality for customer item upload

1.0.86 (07-Apr-2014)

Changed ProcessID to not be a Data column so it is not required on upload

1.0.85 (04-Apr-2014)

Changed the way frmCrossReference checks if the column is the dff context as it was causing an error
Changed the GetMasterOrg SQL to use the operating unit as this is more correct
Added new Support and modUserDefMan to fix the mandatory column setup

1.0.84 (31-Mar-2014)

DownloadControl change from 10 to 100 records per batch

1.0.83 (20-Mar-2014)

Ribbon fixed to reflect product name

1.0.82 (19-Mar-2014)

Modified cross reference update check as it was incorrectly updating org_independent records

1.0.81 (19-Mar-2014)

Changed the Org Code download param for Cross Reference mode to allow using “ALL” as download criteria

1.0.80 (19-Mar-2014)

Set the cross ref all orgs flag to ‘N’ when not all orgs as null is not acceptable

1.0.79 (19-Mar-2014)

Changed the organization_id column for ALL org to return -1, using master org excluded the real master org from the list as using same id
Added UniqueKey to the org sql so we can have the master org and ALL org with the same org id

1.0.78 (14-Mar-2014)

Check child sections exist in various places

1.0.77 (11-Mar-2014)

Added some plsql to UploadCustomerItem/XRef to determine if we need to create or update
Updated Common Code – Added WIZARD_PICTURE global const

1.0.76 (03-Mar-2014)

Corrected the Wizard Function for Sourcing Assignment mode

1.0.75 (27-Feb-2014)

Removed order by level from the CIX section download sql and added it to the dRec for the Level column as it was causing an error

1.0.74 (27-Feb-2014)

Added Last_Update_Date and last_updated_by to updateUOMIntraclassSQL

1.0.73 (26-Feb-2014)

UploadCrossReference now sets the program_id and created_by correctly
In ValidatorUNTEffectiveDates – Do not check isValidType when the column is blank or it will give an Invalid Date error

1.0.72 (24-Feb-2014)

Changes the column indexs in IEWToolbarMenu to align with the new settings123 layout

1.0.71 (21-Feb-2014)

Fixed some issues with ValidatorCustomerItem

1.0.70 (20-Feb-2014)

Enabled Processing form for Upload and Download with refresh value of 5

1.0.69 (17-Feb-2014)

Updated Common Classes
Modified the LOV sql for organization when in Cross Reference mode. Now has “ALL” at the top (Master Org)
Modified the download for organization when in Cross Reference mode. org code is decoded to return ‘ALL’ when the org_independent_flag is ‘Y’

1.0.68 (17-Feb-2014)

Dimension UOM now downloads the value rather than the code

1.0.67 (17-Feb-2014)

Primary UOM is now corrected to Base UOM. Corrected Download SQL for Base UOM

1.0.66 (17-Feb-2014)

Changed Item Number sql to retrieve Base_Uom_Code and Base_Unit_Of_Measure

1.0.65 (11-Feb-2014)

In ValidatCustomerItem – check that the Customer Name and Item Definition Level are valid before doing the Customer Item exists check

1.0.64 (11-Feb-2014)

Fixed bug where SQL was malformed for container items when there were no DFF columns on the sheet

1.0.63 (07-Feb-2014)

Fixed the updating of UOM Intraclass Conversions, added conversion_rate update and changed disable date to use sysdate when user selects todays date

1.0.62 (04-Feb-2014)

Now Calling Install_Database_Objects in post login events instead of Custom_Install to ensure we get all the required profile options
Changed Upload Procedure Error Handlers for all modes to be entry points. The Application.Run that calls them blocks the error from throwing any higher
Sourcing Assignment mode in progress
Changed ValidatorParent to not overwrite existing values

1.0.61 (03-Feb-2014)

NEW PACKAGE REQUIRED FOR 11i. Added function callUOMIntraclassSQL to Upload so we can call M4APPS_ITEMWIZARD package for 11i.
Removed message that prevents uploading UOM Intraclass in 11i

1.0.60 (29-Jan-2014)

Ribbons Enabled

1.0.56 (29-Jan-2014)

Undid above change as was incorrect. Now checking if the date is today then use sysdate so we have the exact time

1.0.55 (28-Jan-2014)

Added new UploadProcedure “UploadRelatedItemAPI” to be used for R12 environments.
Upload Procedure for Related Items is set in InitialiseColumns depending on Oracle Version R12 or 11i
Added validation to ValidateRelEffectiveDates – Date must be later than today’s date

1.0.54 (20-Jan-2014)

Removed isRequired for CustomerName as CustomerNumber is the primary and is now used on the Upload

1.0.53 (06-Jan-2014)

Added idRoe.exists checks for active and departure flags in Upload – UploadCustomerItem code
Updated frmFlex code to not trim segments by delimeter if it is a single segment setup

1.0.52 (10-Dec-2013)

Changed getMasterOrg call to look at the master organization of the organization returned from the OM validation organization profile option

1.0.51 (05-Sep-2013)

Set roe.item(C_STATUS) to valid in all mode forms to fix problem where data was not being written back to the sheet

1.0.50 (02-Sep-2013)

Changed some hardcoded values for user_ids to p_user_id in UploadTransactionDefault
Removed the subinventory exists check from UploadTransactionDefault as it was causing incorrect data to get into the table

1.0.49 (28-Aug-2013)

Removed Address from Level LOV as we don’t support it
Fixed Typo in ValidatorRelEffectiveDates
Fixed problem with ValidatorHighLow where a blank upper limit when entering a lower(and vice versa) caused a type mismatch error
Changed the continue_Level to vbAbort when InitialiseColumns fails on upload so it doesn’t attempt to upload
Added check to setMode to exclude Org and Item columns for CIX mode

1.0.48 (26-Aug-2013)

Changed CustomerItemXRef Upload SQL to delete from the interface for the user_id before loading

1.0.47 (15-Aug-2013)

Changed the alternative wizard function for ABC mode from INV_INVADACA to INV_INVADAGR

1.0.46 (08-Aug-2013)

Set isFormReturn to vbFalse on form close for all mode forms and it was being set true by kff causing control text to be retained with no data

1.0.45 (07-Jul-2013)

Added create profile options for Container Item, Subinventory and ABC Assignment modes
Updated Core Code 205
Added call to Custom_Install in Post_Login_Events of appCustomisations
Set x_sob_id to the cached set of books value in getMainMultiCall as it was not being set

1.0.44 (17-Jul-2013)

Corrected ImplementationSubinventory to pass in the correct 2nd parameter for validatorDeleteTranDefault
In validatorDeleteTranDefault, the default subinventory will always be added as part of the identifier, made this column dependent on default subinventory
Made use of dependencies LocDepOrgID and LocDepSub in implementationTransDefault,
These use blank operators as the sql was returning double = on locator search

1.0.43 (17-Jul-2013)

Removed the restrict Locators check in ValidatorTransDefault to match Oracle

1.0.42 (16-Jul-2013)

Fixed ValidatorCrossRefAllOrgs to check the org when the value is ‘Y’ Or ‘Yes’

1.0.41 (16-Jul-2013)

Made Organization Code a required column
Corrected the DFF Context Name for CIXREF mode
Made the ABC Class column a standard LOV rather than a restricted list
Changed the ABC Assignment and Transaction Default form cmd search buttons forecolor to black instead of blue
Made ABC Group, ABC Item and ABC Class columns mandatory for the ABC Assignment mode

1.0.40 (15-Jul-2013)

Changed transaction defaults for locator to allow multiple subinventories where a locator exists

1.0.39 (05-Jul-2013)

Added Check that par level exists in the row before trying to add it to the sql in UploadSubinventory

1.0.38 (04-Jul-2013)

Added ABC Assignment mode

1.0.37 (18-Jun-2013)

Fixed dffType code to work with the form labels specified by the user

1.0.36 (17-Jun-2013)

Ensure dffType exists before setting dffPanel in form code

1.0.35 (31-May-2013)

Modified Support Function getFormRow to get the correct startrow as it was retrieving the header above when saving, causing an overwrite
Changed UploadContainerItem returnSQL to return ERROR as was setting status to loaded when attempting to upload multiple invalid container items

1.0.34 (24-May-2013)

Added ValidatorDepPlan that prevents Departure Plan Before Build being Yes when Departure Plan Required is not Yes
Added ValidatorInventoryItemXRef to check if a customer item cross reference already exists
Customer Item Active and Customer Item XRef Active now default to Yes
Modified Customer Item XRef download SQL to allow a download based on Inventory Item
Changed container load as inv item join to organization ci.master_organization_id was missing

1.0.33 (22-May-2013)

Added not nothing checks for colParent context in initialiseColumns

1.0.32 (17-May-2013)

Updated Common Code
Added AccumulateSQLBlock to main and set the data to processBlockDataList directly rather than passing in an fndEntityList

1.0.31 (17-Apr-2013)

Began Implementing new mode “Customer Item Cross References”
Removed Master Container and Detail Container columns for Customer Item Cross XRef mode as the sql is not complete
Added mode check in upload row for Customer Item XRef mode so upload will continue when header status is LOADED
Added Validation to ValidatorMinMax so that you must have a min and max value when MinMaxPlanned is true and you must have a max if a min is entered
Added Min and Max as dependent columns to minmaxplanned, and added Max as a dependent col to Min
Added default “No” to column Reciprocal Relationship in ImplementationRelatedItem
Added to UploadContainerItem so that it now allows updates and does not create duplicate container items
Added depOrg and depItem not nothing checks to Implementation class modules as this was causing an error when attempting to open a form in the wrong mode
Added validation to the reciprocal relationship column so that it cannot be set to yes when the opposite relationship exists

1.0.30 (27-Mar-2013)

Added ValidatorParValue to validate based on par level planning and numeric values
Changed download decode statement for Min Max Planned column in ImplementationSubinventory so it returns a null when this is disabled
Added new tables to Subinventory Implementation for use by above decode statement. These changes are excluded for 11.5.9
Added C_DECIMAL column types to columns using ValidatorNumeric in ImplementationSubinventory to prevent type mismatch error
Process Section in Valid Upload now takes a bErrorOnInvalidSection, This is only True for Subinventory mode

1.0.29 (25-Mar-2013)

Implemented new upload sql for Transaction Default mode, it now allows for updates to transaction defaults
Set sqlColumn for ValTransDefaultLoc in ImplementationTransDefault as this was causing a sql error

1.0.28 (22-Mar-2013)

Added new dependencies for related item with C_BLANK as the operator parameter as the operators are already included in the SQL

1.0.27 (22-Mar-2013)

Fixed Subinventory DFF Upload, all attributes added to declare and call SQL
Changed frmSubinventory supply locater column count from 3 to 2, this fixed a bug where selecting from the LOV returned a null value

1.0.26 (21-Mar-2013)

Added Oracle version check to Uploadrow when the mode is UOM Intraclass as this mode is only supported by r12
Modified validatorSource to extend validatorLOV
Implemented DFF functionality for the Subinventory mode

1.0.25 (15-Mar-2013)

Added code to all mode forms to set the startrow to the active row when adding a blank row
All mode forms now use validateElementHierarchy
Modified UOMIntraclass upload sql to return warning instead of error when trying to upload a uom conversion that already exists
UOM Intraclass source unit lov now returns all uoms related to the item, regardless of whether they have been created already
Implemented new form functions getFormRow and setControls in frmUOMIntraclass and frmContainerItem
Added DFF insert sql into uploadContainerItem in Upload code
Fixed problem in validator parent that was check for a parent entity list, no longer needed with changes to validator LOV

1.0.24 (11-Mar-2013)

Added UOM Intraclass conversion columns and form
Changed ImplementationParent to break down SQL into select, from and where strings so custom sql can be appended for different modes
Added validation to ensure all dimension fields are entered if any are entered
Added validation check to ensure the selected item is able to have a UOM conversion
Uploading a row in UOM Intraclass mode now successfully loads the conversions
Added ValidatorPrimaryUOM so the PrimaryUOM displays based on the item and sets the idRow to the uom_code
Set Mandatory Columns for UOM Intraclass Conversions mode
Set validate to true by default for ValidatorParent
Fixed validation issue with ValidatorDimensions
Added check to ensure controls are enabled before setting focus to frmUOMIntraclass and frmContainerItem
Modified UOM Intraclass Conversion mode to no longer require the Organization Code column
Imported common and core code, this resolved the issue where the dff download was returning Y instead of Yes
Added check to only enable Par value column for subinventory mode when package version is not 11.5.9
Added mode check in ImplementationParent to fix a problem with the source unit LOV not populating

1.0.23 (30-Jan-2013)

Fixed issue with misspelt Fixed Lot Multiplier template heading

1.0.22 (24-Jan-2013)

Fixed problem where the create template duplicated the process status column

1.0.21 (18-Jan-2013)

Changed form test to be after the initialised test

1.0.20 (18-Jan-2013)

Fixed bug where container type tag being assigned to the cross reference form

1.0.19 (20-Dec-2012)

Turned tracing off in Load_File_R12 procedure.  Changed call to m4aServlet/upload file

1.0.18 (18-Dec-2012)

Added ValidatorHighLow for numeric high low limit columns

1.0.17 (07-Dec-2012)

Activated the form icon

1.0.16 (06-Dec-2012)

Reset LOV data if mode changes
Made Manufacturer Part Numbers a C_STATIC column type to ensure delete dependence works correctly

1.0.15 (05-Dec-2012)

Fixed transaction defaults issue where Wizard was not validating inv item id correctly against the subinv
Changed related items to disallow dates older than current date

1.0.14 (30-Nov-2012)

If min/max planned flag is null then set to N if create else null if update

1.0.13 (30-Nov-2012)

Fixed issue in subinv uploads not allowing zero min/max values

1.0.12 (05-Nov-2012)

Added latest common code that saves formulas if value has not changed

1.0.11 (25-Oct-2012)

Fixed problem with the specification dates erroring during validation

1.0.10 (11-Oct-2012)

Corrected issue with the Context column causing the Validator Text to error

1.0.09 (10-Oct-2012)

Update the subinventory download to use correct join organization_id=base.source_organization_id

1.0.8 (09-Oct-2012)

Use cross_reference_id during updates when in R12

1.0.7 (28-Sep-2012)

Updated yes/no values for item min/max

1.0.6 (28-Sep-2012)

Restricted the manufacturer list of values
Added profile security for modes that table insert

1.0.5 (10-Sep-2012)

Updated Functional Security

1.0.4 (06-Sep-2012)

Added Cross Reference DFF

1.0.3 (31-Jul-2012)

Fixed issues with specification

1.0.2 (28-Jul-2012)

Added Cross Reference Mode

1.0.1 (01-Jul-2012)

Fixed issues raised on Subinventory mode

1.0.0 (01-Jul-2012)

Base Line