3.02.19 (12-Mar-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.

3.02.18 (13-Dec-2024)

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

3.02.17 (11-Oct-2024)

Internal update.

3.02.16 (09-Oct-2024)

Added Default Browser Login option.

3.02.15 (12-Dec-2023)

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

3.02.14 (24-Aug-2023)

Fixed KFF Dynamic insert not printing XML information to edit sheet.

3.02.13 (21-Aug-2023)

Added Concatenated Segments option for Dynamic insert column.

3.02.12 (15-Aug-2023)

Internal update.

3.02.11 (15-Aug-2023)

Provided option for WValidatorSegmentSplit to return concatenated segments.

3.02.10 (02-Jun-2023)

Internal update.

3.02.09 (29-May-2023)

Now allows users when zero responsibility specified (form function will then be required).

3.02.08 (03-Apr-2023)

Internal update.

3.02.07 (17-Mar-2023)

Internal update.

3.02.06 (16-Mar-2023)

Fixed Logging button reverting back to code version.

3.02.05 (27-Feb-2023)

Internal update.

3.02.04 (23-Jan-2023)

Internal update.

3.02.03 (08-Nov-2022)

Internal update.

3.02.02 (08-Nov-2022)

Internal update.

3.02.01 (21-Nov-2022)

VBA error was fixed when the upload was performed using the 'Background Upload Selected' or 'Background Upload All' options.

3.02.00 (08-Nov-2022)

Internal update.

3.01.00 (04-Nov-2022)

Internal update.

3.00.28 (04-Oct-2022)

Internal update.

3.00.27 (06-Sep-2022)

Internal update.

3.00.26 (31-Aug-2022)

Internal update.

3.00.25 (03-Aug-2022)

Attempt to fix the issue when opening view concurrent request form which threw error of 'Could not set property value, type mismatch'.

3.00.24 (14-Jun-2022)

Fixed error when refreshing concurrent data while logging enabled.

3.00.23 (07-Jun-2022)

Internal update.

3.00.22 (10-May-2022)

Internal update.

3.00.21 (26-Apr-2022)

Internal update.

3.00.20 (08-Mar-2022)

Updated security.

3.00.19 (03-Mar-2022)

Internal update.

3.00.18 (04-Feb-2022)

Internal update.

3.00.17 (19-Jan-2022)

Internal update.

3.00.16 (06-Dec-2021)

Internal update.

3.00.15 (04-Nov-2021)

Internal update.

3.00.14 (03-Oct-2021)

Internal update.

3.00.13 (12-Aug-2021)

Fixed issue where free type text values containing a single quote would raise an exception.

3.00.12 (03-Aug-2021)

Internal update.

3.00.11 (03-May-2021)

Updated security.

3.00.10 (03-May-2021)

Updated security.

3.00.09 (01-Apr-2021)

Updated security.

3.00.08 (29-Mar-2021)

Internal update.

3.00.07 (17-Feb-2021)

Added logging of API package when Support Logging is toggled.

3.00.06 (13-Jan-2021)

Updated security.

3.00.05 (09-Sep-2020)

Fixed issue where single quotes in KFF segments would end up being converted to double quotes.

3.00.04 (01-Sep-2020)

Updated security.

3.00.03 (28-Aug-2020)

Fixed issue where large amounts of multiple child data could cause an upload error to occur.

3.00.02 (27-Aug-2020)

Fixed issue where large amounts of child data could cause an upload error to occur.

3.00.01 (03-Aug-2020)

Updated security.

3.00.00 (28-Jul-2020)

Improved performance for uploads.

2.13.03 (14-Jul-2020)

Internal update.

2.13.02 (08-Jul-2020)

Internal update.

2.13.01 (03-Jun-2020)

Fixed issue where Concurrent setup form would error when opening an existing concurrent setup.

2.13.00 (26-May-2020)

Removed'Update' Table Mode. Recommended to use a PL/SQL Wrapper package around direct table updates for security.

2.12.04 (06-May-2020)

Internal update.

2.12.03 (01-Apr-2020)

Fixed issue where the same DFF could not be added to multiple sections.

2.12.02 (27-Feb-2020)

Removed 'Template:' title from Edit By Sheet as the Logo was overlapping with the template title.

2.12.01 (24-Jan-2020)

Fixed issue where column heading format was not correct. Now includes white border for Row 10 and removed column heading borders.

2.12.00 (24-Jan-2020)

Updated example of 'SELECT 101 FROM DUAL' on KFF setup form to be 'SELECT 101 FLEX_NUM FROM DUAL' as SQL must now be aliased.
Fixed template import issue where product would error when trying to validate the package owner.
Updated with new branding colours and logo.

2.11.00 (21-Jan-2020)

Added 'KFF SQL Table Alias' field to Edit By Sheet to fix the issue where the alias could not be derived from the SQL column.

2.10.05 (07-Jan-2020)

Updated security.

2.10.04 (20-Dec-2019)

Improved debugging around the Download Selected/Download Form ribbon button click functions.

2.10.03 (17-Dec-2019)

Fixed the issue where code blew up during the login when the environment ask the alias to run the query.

2.10.02 (06-Dec-2019)

Added Template123 instruction image.

2.10.01 (02-Dec-2019)

Fixed KFF false delimiter issue on first segment when using the KFF form.

2.10.00 (25-Nov-2019)

Added parenthesis wrapping around column LOV where statement setups to protect OR statements.
Fixed issue where incorrect value was being uploaded when a KFF segment was left blank.
Fixed issue where KFF false delimiter was not being applied to the first segment in the KFF form.
Added Base64 Encoding of http parameter values to be compliant with firewall rules.
Major update for Common, Core and Custom Query. Firewall compliant encoding added.

2.9.15 (16-Oct-2019)

Fixed issue with Concurrent Override SQL not validating the required IDX/ValueX fields within the SQL statement. Now displays validation error and added further information into the Concurrent Override form.

2.9.14 (27-Aug-2019)

Custom Query update to fix various issues.

2.9.13 (26-Aug-2019)

Fixed issue when refreshing sheet data from a concurrent program that requires date fields.

2.9.12 (09-Aug-2019)

Updated security.

2.9.11 (07-Aug-2019)

Now disables the Responsibility page when creating/updating Loader download queries.

2.9.10 (30-Jul-2019)

Fixed issue encountered when validating a control on KFF form.

2.9.09 (10-Jun-2019)

Updated common to implement the Refresh performance query issue on 11.1 databases.

2.9.08 (30-May-2019)

Fixed issue with the 'Edit By Sheet’ data entry forms raising VBA errors on click/mouse events.

2.9.07 (30-May-2019)

Now prevents the Wizard from initialising when duplicate column headers are encountered.

2.9.06 (27-May-2019)

Fixed tabbing index order on DFF form.
Fixed status bar truncating messages. Extended the bars width.

2.9.05 (23-May-2019)

Custom Query updated to fix various issues with downloader queries.

2.9.04 (13-May-2019)

Removed static icons. 2007 will be blank but newer Excel versions will use new icons.

2.9.03 (13-May-2019)

Added new static clear status/form selection icons.

2.9.02 (13-May-2019)

Fixed issue where Import Template and DBMS Output was not present.

2.9.01 (09-May-2019)

Added new 'Clear Status’ columns options and added forms button into ribbon.

2.9.00 (23-Apr-2019)

Fixed issue where loaders can now support [BLANK] functionality for Procedure child sections.

2.8.08 (09-Apr-2019)

Enabled Copy functionality in manage template for supported loaders.
This enables users to be able to add custom view labels and change visible sections in separate templates.

2.8.07 (02-Apr-2019)

Fixed the issue where import/export URL do not work with macros cannot be found error.

2.8.06 (26-Mar-2019)

Updated security.

2.8.05 (18-Mar-2019)

Fixed issue where LOV would blow up when dependent on an invalid date field.

2.8.04 (18-Mar-2019)

Fixed issue where non-form fields weren't being validated and dependencies not set.

2.8.03 (14-Mar-2019)

Fixed issue where parent field substitutions could not be applied to the context column.

2.8.02 (14-Mar-2019)

Fixed Setup sheet spelling - changed spelling of US license to UK licence.

2.8.01 (13-Mar-2019)

Added new Setup sheet.

2.8.00 (11-Mar-2019)

Major update to attachment mode. Now requires entity user name and function name as input parameters.
Added backward compatibility for older attachment templates.
Added new logo and setup sheet.
Added Function Name/User Entity Name/Function Type to the attachment mode form when generating an attachment template.

2.7.09 (11-Mar-2019)

Fixed error where the Download form would be locked after using the Custom Query form.

2.7.08 (07-Mar-2019)

Updated to new error colour.
Fixed DFF validation issue printing no error message.
Fixed concurrent form defaulting to Cancel button after parameter selection.

2.7.07 (27-Feb-2019)

Updated error and user column heading colouring.
Fixed issue where fields relating to a non-existing API parameter were still being loaded and causing upload PL/SQL issues.

2.7.06 (26-Feb-2019)

Updated Wizard colours for new branding standards.

2.7.05 (25-Feb-2019)

Custom Query updated to version 1.1.14

2.7.04 (22-Feb-2019)

Fixed issue where free type fields would error with invalid data type as validation was reading the upload parameter type.

2.7.03 (07-Jan-2019)

Fixed issue in loaders with action columns where data was being uploaded when no action specified.

2.7.02 (08-Feb-2019)

Custom Query updated to version 1.1.14

2.7.01 (07-Jan-2019)

Implemented date fix where date parsing was incorrectly swapping day/month around for european formatting.

2.7.00 (31-Jan-2019)

Fixed issue introduced in 2.6.82 when using oracle default functions in Procedure mode.

2.6.82 (30-Jan-2019)

Added support for [BLANK] functionality for child sections.
Fixed issue where M4A_UPLOAD_IGNORED would appear in processing form instead of resolved message.

2.6.81 (21-Dec-2018)

Fixed upload issue on certain loaders where there were no return statements for post API call fields.

2.6.80 (20-Dec-2018)

Added version number to newly created sheets.

2.6.79 (18-Dec-2018)

Increased performance of loader Refresh queries where SQL index joins may be lost.

2.6.78 (10-Dec-2018)

Development platform - Added 'DO NOT USE' comments around private PL/SQL variables in Edit PL/SQL.
- Change API/Table call check to 'p_status = FND_API.G_RET_STS_SUCCESS' to allow for 'U' Oracle Status'.
- Fixed issue where 'p_status' was not correctly returning into the Wizard.

2.6.77 (06-Dec-2018)

New Common Support Sheet is generated when 'Logging' is enabled which displays DFF and instrumentation.
Now validates and prevents SQL from being applied to read only fields.
Now validates and prevents read only fields being used as dependencies.
Now supports ROWID for Delete From Interface definitions.

2.6.76 (04-Dec-2018)

Removed 'WIP' sheet from committed version of AIW.

2.6.75 (03-Dec-2018)

Fixed issue on Procedure templates with a defined concurrent program causing Wizard functions to present an incorrect background processing message after background upload.

2.6.74 (29-Nov-2018)

Fixed issue where newly created accepted/error definitions would not correctly save the data type into the template.

2.6.73 (12-Nov-2018)

Fixed the issue where getting error during the login if the last used template does not exist in the repository.
Removed the duplicated error message that "Template does not exist in the repository!"
Fixed issue with Custom Column Setup form where label would be invalid when other custom columns without labels were added.

2.6.72 (07-Nov-2018)

Fixed SQL Duplication issue caused by short list LOV invalid values and form tabbing.

2.6.71 (07-Nov-2018)

Fixed tab issue where validation would cause duplicated SQL issues when tabbing to support control and out.
Note that validation will no longer occur between control and its associated support control.

2.6.70 (06-Nov-2018)

Fixed tab issue where validation would not fire when tabbing on form controls.

2.6.69 (06-Nov-2018)

Fixed form event issues with tabbing causing multiple queries to fire.
Fixed form event issues causing control LOV lists to disappear when clicking during a form query.

2.6.68 (01-Nov-2018)

Added DFF logging when Logging Support is toggled.

2.6.67 (16-Oct-2018)

Fixed issue where the licence information in the About form was not refreshed after entering a new development Licence Key.

2.6.66 (16-Oct-2018)

The users will get the error that current user is not registered earlier instead of at the end of the login.

2.6.65 (12-Oct-2018)

Fixed issue where End-To-End form will not popup after closing End-To-End trace.

2.6.64 (12-Oct-2018)

Updated core code to fix a licencing form issue when retrieving the MD5 value from a template.

2.6.63 (11-Oct-2018)

Added support for contexts with table based LOV definitions for DFFs.

2.6.62 (11-Oct-2018)

Fixed the following issues:
- Assign users required when in trial.
- New Licence Key fails on loaders with multiple templates.
- After entering a new Licence Key code blew up when doing upload.

2.6.61 (01-Oct-2018)

Fixed crash when opening Wizard on Excel 2007.

2.6.60 (25-Sep-2018)

Fixed issue where text fields were being formatted as numbers in SQL queries causing SQL issues.

2.6.59 (25-Sep-2018)

Updated Security.

2.6.58 (19-Sep-2018)

Updated Custom Query.

2.6.57 (13-Sep-2018)

Added new option of Debug Upload Mode "End To End Trace Unlimited Size" to enable the trace with unlimited size of trace file.

2.6.56 (06-Sep-2018)

Fixed DFF issue where attributes were not being validated on context change in form.
Fixed issue where Data Type[0] didn't exist in SQL field when validating Refresh/Error SQL queries.

2.6.55 (04-Sep-2018)

Fixed clearing sheet download issue where not all sheet criteria was being cleared.

2.6.54 (04-Sep-2018)

Fixed the issue of the development licence key will be overwritten when entering a loader key.
Added showing message if the new entered licence key is not matching the current selected template.

2.6.53 (30-Aug-2018)

Cleaned Wizard.

2.6.52 (30-Aug-2018)

Fixed 64bit upload issue causing Accepted to be written to the sheet for interface records.

2.6.51 (30-Aug-2018)

Fixed 64bit LOV caching issue causing short-list LOVs to fail validation.
Fixed dependency form issue displaying error when adding multiple dependencies from different fields.

2.6.50 (20-Aug-2018)

Fixed issue where Download Form would error on Download Click when no queries exist in the Custom Query.
Fixed issue with the download where the cardinality hint was not being appended causing queries to time out.

2.6.49 (20-Aug-2018)

Fixed issue where clicking on a new blank row below data to add a new row would not link dependencies correctly.

2.6.48 (20-Aug-2018)

Updated to use new data store to save dramatically on memory.

2.6.47 (10-Aug-2018)

Fixed issue in validation mode where only single query records were being executed.

2.6.46 (10-Aug-2018)

Fixed issue where dividers in a new sheet were being formatted as black.

2.6.45 (09-Aug-2018)

Added validation blue colouring and fixed Attachment form upload issue.

2.6.44 (02-Aug-2018)

Fixed 11i attachment definition issue causing a SQL error.

2.6.43 (02-Aug-2018)

Fixed Attachment mode enforcing mandatory on sequence number. This field is now optional.
Fixed edit by sheet load after an attachment upload causing issues with loading.
Fixed Attachment mode uploads where primary key columns would not default or validate correctly.

2.6.42 (01-Aug-2018)

Fixed double click event which had been removed in a previous version.
Updated ribbon code to fix 64bit VBA ribbon issue and updated updated common code to fix load data form issues occurring with orphaned data.

2.6.41 (27-Jul-2018)

Fixed template synchronization issue causing status and message columns to have incorrect section mapping.

2.6.40 (27-Jul-2018)

Fixed template synchronization issue causing a VBA error when a new section is being added.

2.6.39 (24-Jul-2018)

Fixed excel 2007 ribbon crash issue on load.

2.6.38 (23-Jul-2018)

Fixed the issue where assigned user list for selected loader was not loaded correctly.

2.6.37 (19-Jul-2018)

Fixed issue with PL/SQL validation on date fields causing an upload error.

2.6.36 (13-Jul-2018)

Updated Custom Query.

2.6.35 (04-Jul-2018)

Fixed issue introduced in 2.6.34 where the ribbon would error on load.

2.6.34 (04-Jul-2018)

Fixed isUserTemplate VBA issue caused when loading an old template with responsibilities.

2.6.33 (02-Jul-2018)

Fixed ribbon supertips missing translation for normalization/help group.

2.6.32 (02-Jul-2018)

Updated core menu code to add ShowWizardToolbars macro.
Fixed Return Out Parameter issue returning variables when set to No.

2.6.31 (28-Jun-2018)

Updated Common to 3.4.35 to fix new logging multilingual code.

2.6.30 (28-Jun-2018)

Updated Common to fix attachment right click separator.

2.6.29 (28-Jun-2018)

Updated Common to 3.4.34 to implement the new ribbon.

2.6.28 (28-Jun-2018)

Fixed licencing issue where the set loader was not being corrected used to open the licencing about form.

2.6.27 (27-Jun-2018)

Removed digital signature as Excel workbook doubles in size.

2.6.26 (27-Jun-2018)

Fixed Download Form ribbon button issue causing a 'DownloadData' macro cannot be found.
Added digital signature to VBA.

2.6.25 (21-Jun-2018)

Copy to clipboard button has now been added after issue in 2.6.19

2.6.24 (20-Jun-2018)

Updated the ribbon core to the latest to fix a crash issue occurring on Excel 2010 with multiple workbooks open.
Wizard is now protected as Medium to ensure macros are not lost.

2.6.23 (19-Jun-2018)

Updated the ribbon core to the latest to revive the ribbon on load after VBA errors occur.

2.6.22 (19-Jun-2018)

Concurrent Form - Fixed the refresh button link being broken.

2.6.21 (19-Jun-2018)

Updated messages for the Help button as the message codes were appearing.

2.6.20 (19-Jun-2018)

Enable the Submit Concurrent Submissions in Procedure mode.
Updated Common to 3.4.18 for multilingual help buttons.

2.6.19 (15-Jun-2018)

Updated Common to 3.4.14 to implement the new ribbon core.

2.6.19 (15-Jun-2018)

Updated Common to 3.4.14 to implement the new ribbon core.

2.6.18 (13-Jun-2018)

Fixed documentation link for Downloader Queries on the setup page.
Fixed upload displaying an upload message when upload has been performed.

2.6.17 (12-Jun-2018)

Default the Manage Templates form to the template tab.
Fixed LOV Type LOV showing invalid values.

2.6.16 (12-Jun-2018)

Added Validation for Is LOV Numeric when validating Edit By Sheet.
Fixed is LOV Numeric flag not toggling for cache lists.

2.6.15 (08-Jun-2018)

Added Not Exists SQL toggle for refresh accepted/error SQL in concurrent setups.
Fixed KFF issue with project/task segments causing an error when building the dependency.

2.6.14 (07-Jun-2018)

Fixed defaulting date issue where date is not formatted due to the parent column type being a numeric or character data type.
Added support for SQL defaulting DateTime values.

2.6.13 (06-Jun-2018)

Fixed 64bit compile issue caused by the CTimer module.

2.6.12 (05-Jun-2018)

Refresh SQL now supports NULL comparisons where sheet values are missing (null) and are equivalent with DB NULL values.

2.6.11 (31-May-2018)

Updated Common Architecture to 3.3.02 and fixed an issue where default parent fields would trim time on Date/Time parent fields.

2.6.10 (30-May-2018)

Updated Common Architecture to 3.3.00 to fix form query issues and implement new internal function security structure.

2.6.09 (28-May-2018)

Fixed an issue where an entire record was being uploaded when a child errored.
Fixed an issue in Attachment mode where attachment sections would not upload.
Updated Common Architecture to 3.2.24 to fix an issue where cached values were not being extracted resulting in 'unable to find value' errors.

2.6.08 (24-May-2018)

Manage Templates Add Attributes form - Label now displays Attribute and Mapping as the number associations are irrelevant and Control LOV size has been increased.

2.6.07 (24-May-2018)

Updated Common Architecture to 3.2.23 to fix KFF form issues on load with dependencies.

2.6.06 (24-May-2018)

Fixed Manage Template setup form issues displaying a VBA error when resolving IDs to Values.
Fixed multiform manage template setup validation not setting values correctly when clicking OK without tabbing out of a control.

2.6.05 (23-May-2018)

Responsibilities are now inherited from old templates when importing new templates.
Fixed a VBA "C_ELEMENT" error occur when opening a KFF form with dependencies on the form.

2.6.04 (22-May-2018)

Updated Common Architecture to 3.2.17 to fix validation error issues with Free Type fields.

2.6.03 (21-May-2018)

Implemented fix where template could not be deleted if template name had leading/trailing whitespace.

2.6.02 (21-May-2018)

Updated Common Architecture to 3.2.14 to fix validation form issues displaying duplicate values when none occurred.

2.6.01 (17-May-2018)

Updated Common Architecture to 3.2.08 to fix various form asynchronous issues introduced in 3.2.00
Fixed an issue where a message box would pop up multiple times if the template is invalid in the current instance.

2.6.00 (14-May-2018)

Updated Common Architecture to 3.2.00 to fix form events being broken and preventing controls from being clicked.

2.5.61 (08-May-2018)

Updated Common Architecture to 3.1.08 to fix an issue where the DBMS Output sheet couldn't be created without causing a VBA error.

2.5.60 (04-May-2018)

Fixed an issue in Table mode where child records were being uploaded when the header was invalid in PL/SQL validation.

2.5.59 (04-May-2018)

Fixed issue where status and message for API Child Sections were being printed to row 1 on the spreadsheet when a PLSQL error occurs.
PL/SQL functions can now be assigned for API Child Sections columns.
Fixed issue when selecting a template and an invalid path was defaulted - this would cause the form to open a VBA error.

2.5.58 (01-May-2018)

Updated Security.

2.5.57 (17-Apr-2018)

Fixed group by expressions for long lists of value.

2.5.56 (17-Apr-2018)

Fixed issue where colour formatting wasn't printed when processing form cancel was pressed.

2.5.55 (16-Apr-2018)

Updated Common to 3.0.8 to fix an attachment uploading issue not validating the primary key fields correctly.
Updated message to include Responsibility when a template is not available to the current user to indicate a possible responsibility issue.
Fixed dependency builder issue where the dependent SQL field background colour wasn't being reset to valid on previous error and control change.

2.5.54 (12-Apr-2018)

Fixed DFF form references for context defaults not defaulting a parent columns text based value correctly.

2.5.53 (10-Apr-2018)

Updated common modules to fix an issue where KFF forms within DFF attributes caused an error when generating support controls.

2.5.52 (04-Apr-2018)

Fixed issue with default DFF SQL statements with dependencies causing a warning message to appear.
Default SQL statements reverted to line-by-line defaulting for backwards compatibility.

2.5.51 (03-Apr-2018)

Added validation when importing template XML to ensure that the template has a base template XML structure.

2.5.50 (03-Apr-2018)

Fixed DFF page issue warning when initialising a template with a concurrent form.

2.5.49 (28-Mar-2018)

Fixed issue with loading a Descriptive Flexfields form - setting the control page would cause a VBA error to occur.

2.5.48 (28-Mar-2018)

Updated Common to print orange headings for user fields.
Removed new Default Type of 'Sequence'. Function code has been refactored to account for sequences being returned on upload.
Fixed Default SQL compatibility issue with UNION statements.

2.5.47 (27-Mar-2018)

Fixed issue introduced in 2.5.45 where SQL statements would no longer default correctly.
Sequences must now be added in using the Default Type of 'Sequence'.
Sequences will be written back to the sheet if column is on sheet using the Default Type of 'Sequence'.
Added backwards compatibility for old defaulting with inline SQL bind statements. Any SQL without inline binds will use caching.
Fixed Oracle Functions in Table modes.

2.5.46 (27-Mar-2018)

Deleted non-setup worksheet left over after testing.

2.5.45 (27-Mar-2018)

Fixed caption for KFF forms now showing the custom column label.
Fixed issue where messages would be cleared on concurrent refresh/delete.

2.5.44 (26-Mar-2018)

Updated Downloader Modules.

2.5.43 (23-Mar-2018)

Fixed issue where data and messages were being loaded/printed to a previously used sheet when clicking 'Load’ in the Edit By Sheet.
Added Concurrent support for Concurrent Definitions without parameters.
Fixed issue when setting a default value in API parameters and hiding the sheet. The value will now be sent to the API correctly.

2.5.42 (23-Mar-2018)

Updated Downloader Modules.

2.5.41 (21-Mar-2018)

Updated Downloader Modules.

2.5.40 (23-Mar-2018)

Updated common 3 modules allowing downloads to be aborted when the processing 'Stop' button is pressed.
Multiple parent columns may now be used for defaulting by using a ; delimiter.

2.5.39 (19-Mar-2018)

Updated Downloader Modules.

2.5.38 (14-Mar-2018)

Added further performance improvements when initialising sheet data and cell colouring.
Fixed form opening blank row on an orphaned data row that has data.
Fixed form opening VBA issue on Edit By Sheet when adding custom columns.

2.5.37 (14-Mar-2018)

Added performance improvements when initialising sheet data.

2.5.36 (14-Mar-2018)

Fixed short list LOVs not correctly validating values when dependencies are set.

2.5.35 (13-Mar-2018)

Fixed issue when Managing Templates and loading form with column names. VBA would error.
Fixed issue when loading the form references DFF form and no attribute would be resolved.
Pending status is now only printed to sections with an Accepted SQL concurrent setup.

2.5.34 (13-Mar-2018)

Fixed form issue when opening blank record on child section below a record. Form now links dependencies correctly.
Fixed issue when opening up DFF Form References or any multi-row form builder in the Manage Templates form. VBA Error would occur.
Fixed error when opening dependency builder form on column validation in Edit By Sheet.

2.5.33 (11-Mar-2018)

Fixed Edit By Sheet loading template. Error occurs when processing Order By field.

2.5.32 (11-Mar-2018)

Fixed issue with messages printing with wrapped text.
Fixed encoding issues for EBS 11i and R12 systems using non UTF-8 charsets.
Fixed column PL/SQL validation issue when field and dependencies were blank.

2.5.31 (07-Mar-2018)

Updated common to fix attachment issue and improve form loading times.
Fixed concurrent program check when implemented refresh within an API - Pending is now printed correctly.

2.5.30 (05-Mar-2018)

Fixed issue with defaulting causing a VBA issue with the new architecture update.

2.5.29 (05-Mar-2018)

Updated common architecture to fix an issue when querying databases with ISO character sets (E.g LATIN-1).

2.5.28 (02-Mar-2018)

Updated Downloader Modules.

2.5.27 (27-Feb-2018)

Improved performance of upload for single section or header-single-line uploads.

2.5.26 (27-Feb-2018)

Updated common code with DFF form fixes.
Now supports concurrent Accepted SQL in API mode.

2.5.25 (23-Feb-2018)

Updated common architecture to fix issue on processing form where row number for initialisation would be 0.
Load Edit by sheet - now uses the application ThisWorkBook objects worksheet.

2.5.24 (20-Feb-2018)

Updated common to support new form reference model allowing form references to work without having the column on the sheet.

2.5.23 (20-Feb-2018)

API modes now correctly use a single-stage for uploading data as XML and calling the API.
Fixed issue when loading the Edit By Sheet template when first initialising wizard. VBA error would occur.

2.5.22 (19-Feb-2018)

Fixed initialisation issue when switching between Edit By Sheet form and standard Loader form. Edit By Sheet Form may appear instead.
Fixed concurrent refresh issue when using ROWID for sheet primary key field mapping.

2.5.21 (14-Feb-2018)

Added Clear Cache field to reset LOV values on form open or upload.

2.5.20 (13-Feb-2018)

Updated downloader modules to 1.1.01 and changed to Custom Query.
Fixed form control drop down issue showing the sheet column twice.

2.5.19 (13-Feb-2018)

Added prompt to delete corrupt templates if the user has system administration access.

2.5.18 (12-Feb-2018)

Fixed continuation of issue from 2.5.17. Templates will now save correctly without closing delimiters on older XML libraries.

2.5.17 (12-Feb-2018)

Fixed VBA error issue when importing template after opening Wizard.
Fixed issue importing new template - template uploads as invalid and returns an invalid XML error when loading Wizard.

2.5.16 (09-Feb-2018)

Updated Attachment architecture.

2.5.15 (09-Feb-2018)

Updated validated status.
Fixed an issue where only 1000 Accepted statuses would be printed after upload.

2.5.14 (09-Feb-2018)

Fixed issue when clicking on the 'Refresh from interface' button and an error occurring when no refresh has been set up.
Increased size of KFF form.
Increased performance of LOV validation.

2.5.13 (07-Feb-2018)

Fixed issue where XML queries did not have the DISTINCT clause added.
Remove LOV Cache Type as redundant.

2.5.12 (07-Feb-2018)

Increased KFF form size for larger GL accounts.
Removed mode from template display on ribbon to save space.
Edit by Sheet LOV now errors if dependencies are populated in select or from clauses.
Fixed default value on Edit By Sheet form disappearing when leaving control.
Fixed issue caused by large uploads with many children - XML message box would occur asking to reload XML.

2.5.11 (07-Feb-2018)

Updated caching modules in Wizard.

2.5.10 (06-Feb-2018)

Fixed issue where messages were not being written to the common log.

2.5.09 (06-Feb-2018)

Fixed an issue where the mode could not be resolved based off an ID written into the spreadsheet on workbook open.

2.5.08 (06-Feb-2018)

Fixed the DFF form control focusing being reset on validation back to the context.
Updated the core XML module to display query errors when XML cannot be manipulated in the DB.

2.5.07 (15-Feb-2018)

Fixed an issue with caching where defaulting and validating blank values with dependencies would cause performance issues.

2.5.06 (02-Feb-2018)

Display only columns without any defaulter will not have values overwritten.

2.5.05 (01-Feb-2018)

Updated common for the concurrent form.
Fixed issue where child record messages were not being returned.
Fixed template saving issue where other transactions could conflict.

2.5.04 (01-Feb-2018)

Fixed Refresh/Delete issue for concurrent processes and fixed issue to do with non-displayed column defaults not being populated.

2.5.03 (31-Jan-2018)

Fixed issue with processing form extending over 100%.

2.5.02 (31-Jan-2018)

Fixed issue where control value wasn't being validated when clicking form OK.

2.5.01 (30-Jan-2018)

Improved performance when loading templates.

2.5.00 (27-Jan-2018)

Updated to Common EBS 3.
Reduced number of processing form popups when managing templates.

2.4.41 (25-Jan-2018)

Updated Downloader Modules.

2.4.40 (25-Jan-2018)

Fixed return data issue which was blowing up when returning constant statuses from Oracle.

2.4.39 (23-Jan-2018)

Fixed Edit By Sheet load button issue causing a VBA error.

2.4.38 (17-Jan-2018)

Updated processing form achitecture code.

2.4.37 (16-Jan-2018)

Updated common architecture.
Improved writing data to sheet.
Removed ‘Save Data’ button.

2.4.36 (12-Jan-2018)

Updated dependency list errors to show the label instead of the column name.

2.4.35 (09-Jan-2018)

Updated with missing DFF module.

2.4.34 (09-Jan-2018)

Updated DFF modules form reference code.

2.4.33 (08-Jan-2018)

Updated common code (DFF modules).

2.4.32 (19-Dec-2017)

Updated common code.

2.4.31 (14-Dec-2017)

Fixed the issue where security group ID was not set to the session context.

2.4.30 (14-Dec-2017)

Added functionality to set the security Group ID for the ICX Session. HR Tools require this if companies have multiple Security Groups. Otherwise some LOVs will not return the correct values or more likely no values.

2.4.29 (08-Dec-2017)

Updated common code and free type LOV code.

2.4.28 (07-Dec-2017)

Updated upload colouring to print colours in a more efficient manner.

2.4.27 (06-Dec-2017)

Updated Concurrent form code to show column prompts on error messages in the submit concurrent form.

2.4.26 (06-Dec-2017)

Fixed issue with template not saving PL/SQL details correctly.
Fixed issue when trying to attempt to edit PL/SQL displaying that the user is not currently assigned to the template.
Fixed issue with long list LOV setups without a unique ID column defined still erroring on duplicate records (it shouldn’t).

2.4.25 (01-Dec-2017)

Fixed issue when creating a new template that already existed in the system - the duplicate check would fail.

2.4.24 (01-Dec-2017)

Fixed error message that appears when copying template (but then goes on to a success message).
Fixed issue where manager could not modify templates not assigned to the current user (even with admin access).

2.4.23 (30-Nov-2017)

Updated Attachment code.

2.4.22 (30-Nov-2017)

Updated Downloader Modules.

2.4.21 (30-Nov-2017)

Updated Downloader Modules.

2.4.20 (27-Nov-2017)

Added DBMS_UTILITY.FORMAT_ERROR_BACKTRACE for back tracing package issues.
Fixed concurrent parameter issue with display only fields.

2.4.19 (24-Nov-2017)

Fixed issue where license information was cut off due to the small size of license information area on the About form.

2.4.18 (17-Nov-2017)

Fixed issue from 2.4.17 where opening the edit by sheet form caused an object variable not set error.

2.4.17 (16-Nov-2017)

Fixed issue from 2.4.16 where uploads caused a VBA error.

2.4.16 (16-Nov-2017)

Fixed date time fields not displaying time correctly using 'Is Time' within a template.
Improved performance of templates loading by only loading templates when selected.
Fixed issue with DFF forms running queries when dependencies are not set.

2.4.15 (15-Nov-2017)

Developer: Fixed synchronize issue when the section name was changed causing a code error to appear.

2.4.14 (15-Nov-2017)

Developer: Added 'Override SQL' to the concurrent override form to allow overriding of SQL statements.

2.4.13 (13-Nov-2017)

Updated attachment architecture.
Fixed issue where attachments wouldn't load due to missing function name.

2.4.12 (13-Nov-2017)

Added KFF form fix where the concatenated segments was being printed to the sheet when the Cancel button was clicked.

2.4.11 (13-Nov-2017)

Fixed column ambiguous defined issue with similar column names in a table type.

2.4.10 (08-Nov-2017)

Fixed issue with concurrent requests when adding in line level error SQL.

2.4.09 (07-Nov-2017)

Fixed issue where short list LOVs may not be populated when using forms.

2.4.08 (03-Nov-2017)

Developer: INTERNAL: Parent columns can now be selected as a primary key column for concurrent refresh/delete.
Updated downloader modules - fixes issue in Banks and Branches downloader.

2.4.07 (01-Nov-2017)

Column custom view label is now displayed when executing queries.

2.4.06 (01-Nov-2017)

Fixed issue where column labels were not being used for error messages.

2.4.05 (01-Nov-2017)

Fixed issue with multiple messages not returning when refreshing concurrent errors.

2.4.04 (31-Oct-2017)

Fixed issue when using a KFF form and clicking the combinations tab when extra validation has been setup through server side code.

2.4.03 (27-Oct-2017)

Fixed issue where PL/SQL parameters would be too long as identifiers.

2.4.02 (26-Oct-2017)

Updated common modules.
Fixed error messages from LOVs - duplicate values found in SQL now error with a more descriptive message.

2.4.01 (25-Oct-2017)

Fixed issue with PL/SQL validation - on first upload invalid values were not returned as invalid.

2.4.00 (25-Oct-2017)

Updated attachment modules.

2.3.99 (24-Oct-2017)

Developer: Fixed issue where parameter names were exceeding PL/SQL limits causing an Oracle error to return when building templates.
Fixed an issue with PL/SQL names having a collision with standard parameter names.

2.3.98 (20-Oct-2017)

Updated delete from interface message asking to detail records from the interface table.

2.3.97 (19-Oct-2017)

Developer: Message columns can now be re-ordered and have a sub section name defined.
Import Template - clicking cancel does not display a message.
Fixed VBA issue on the DFF tab in manage template form causing error when entering a new DFF.

2.3.96 (13-Oct-2017)

Increased size of dependency form and added the SQL field as the dependency name.
Added validation to prevent own column from being set as a dependency.
Fixed issue where template definition couldn't be found when a record type was one of a table.
Added new Accepted/Error Concurrent refresh and delete from interface.
Removed Additional SQL as this should now be returned in the Accepted SQL.

2.3.95 (12-Oct-2017)

Duplicate records queried by LOVs now return an error if duplicate records are found.

2.3.94 (10-Oct-2017)

Updated EBS attachment modules.

2.3.93 (10-Oct-2017)

Updated common modules.

2.3.92 (10-Oct-2017)

Fixed issue where values were not defaulting from columns that were not set up on the spreadsheet but had an assigned default value.

2.3.91 (26-Sep-2017)

Enforced tighter security around template importing - Import Templates are now only available through sys admin or users with the Manage Template Profile option set.

2.3.90 (21-Sep-2017)

Developers: Fixed issue with DFF mapping - values were being cleared when saving the attribute form.
Fixed issue where a template was asking to be saved even with no user changes.

2.3.89 (20-Sep-2017)

Added More4Apps: AIW Disable Table Modes profile option allowing for Table Modes to be disabled from the Manage Template form.
Added More4Apps: AIW Disable PLSQL Development allowing for PL/SQL development to be disabled from the Manage Template form and Edit By Sheet.

2.3.88 (20-Sep-2017)

Updated DFF form modules - column labels now show on form.

2.3.87 (19-Sep-2017)

Updated Downloader Modules.

2.3.86 (15-Sep-2017)

Updated common modules.

2.3.85 (15-Sep-2017)

Fixed issue where DFF was not loaded because of case sensitivity match around the Descriptive Flexfield Code.

2.3.84 (15-Sep-2017)

Developer: DFF - Added Attribute Code (DFF Application Column) mapping for Descriptive Flexfield Segment mapping to application columns in Oracle.
Developer: Added import all for templates.

2.3.83 (14-Sep-2017)

Updated form code to show form when clicking on a message column.

2.3.82 (13-Sep-2017)

Fixed the issue of getting error message of failed to find the custom add-ins when opening the Wizard or during the login.

2.3.81 (13-Sep-2017)

Updated web services response data - error would occur when response status mapping wasn't set up.

2.3.80 (13-Sep-2017)

Updated section validation - parent section (not top level) is missing from the sheet then warn but allow loader to continue working without the parent.

2.3.79 (12-Sep-2017)

Fixed issue where disabled segments were showing in flexfields.

2.3.78 (12-Sep-2017)

Updated common modules.

2.3.77 (08-Sep-2017)

Updated manage templates button to say save to repository.
Updated form function form to detail upload security.

2.3.76 (06-Sep-2017)

Developer: Table Upload Modes - All records upload except errored records. Removed rollback. Will need to investigate rollback on inserts when child fails but next child passes and is inserted.

2.3.75 (06-Sep-2017)

Fixed colouring issue on the dependency builder form.

2.3.74 (05-Sep-2017)

The column label now appears in the message column for developer PL/SQL validation.

2.3.73 (31-Aug-2017)

Developers: Re-implemented fix for 72 as wrong module version was implemented.

2.3.72 (31-Aug-2017)

Developers: Fixed issue with defaulting SQL statement dependencies. Performance increase should be noticed on dependencies with SQL defaults.

2.3.71 (30-Aug-2017)

Added display only colouring for controls during validation.

2.3.70 (30-Aug-2017)

Added control colouring for display only fields.

2.3.69 (30-Aug-2017)

Fixed issue where child section parameters were not correctly return to the sheet for procedure modes.
Fixed issue where defaulting values from sheet were causing a VBA code error when defaulting invalid dates.

2.3.68 (29-Aug-2017)

Removed DBMS_SESSION.MODIFY_PACKAGE_STATE(DBMS_SESSION.REINITIALIZE); until a solution that explicitly resets the session is found. Packages must be bounced using an apache bounce.

2.3.67 (29-Aug-2017)

Changed 'saved template' message to describe the template name and database the XML is being saved to.

2.3.66 (28-Aug-2017)

Updated Downloader Modules.

2.3.65 (25-Aug-2017)

Fixed issue with numerical values for DFF fields erroring on Long List LOVs.

2.3.64 (25-Aug-2017)

Fixed issue with form controls when tabbing between list of value fields.

2.3.63 (23-Aug-2017)

Added message to remove parameters/sections from template during synchronize.

2.3.62 (22-Aug-2017)

Import Template now allows users to import templates with a warning. Manage templates still require system administration grants.

2.3.61 (18-Aug-2017)

Increased the size of the Key Flexfield Combinations form control dropdown.

2.3.60 (18-Aug-2017)

Developer: DBMS_OUTPUT buffer is now purged before writing to DBMS_OUTPUT for API calls.

2.3.59 (17-Aug-2017)

Edit By Sheet - template can now be saved during edit sheet click.

2.3.58 (16-Aug-2017)

Fixed multilingual messages.

2.3.57 (16-Aug-2017)

Fixed issue with dependent columns caused by version 2.3.56

2.3.56 (16-Aug-2017)

Fixed concurrent submissions for APIs - Submit Concurrent Request is now enabled.
Fixed issue where concurrent buttons would disable when loading a procedure API.

2.3.55 (16-Aug-2017)

Fixed issue with Concurrent Refresh - Application would error displaying Column not Found.

2.3.54 (14-Aug-2017)

Table Modes - Fixed DBMS output error occurring when returning pending table interface results and DBMS output sheet is enabled.

2.3.53 (14-Aug-2017)

Fixed return results for child section after an upload has occurred.

2.3.52 (11-Aug-2017)

Updated Key Flexfield form code to fix a VBA issue when opening the KFF form.

2.3.51 (10-Aug-2017)

Updated Downloader Modules.

2.3.50 (10-Aug-2017)

Fixed issue with uploading when multiple child sections are attached to a single header - data is not uploaded.
Fixed downloader to be load from file.

2.3.49 (10-Aug-2017)

Fixed VBA error that occurs when writing DBMS Output lines to the DBMS Output sheet during an API upload.

2.3.48 (10-Aug-2017)

Fixed synchronization issue with new columns and custom section names not being copied over.

2.3.47 (08-Aug-2017)

Fixed synchronization issue not pulling in new fields.

2.3.46 (08-Aug-2017)

Added debugging for queries being executed from the architecture.

2.3.45 (07-Aug-2017)

Removed "Did you mean to search for [column name]?" message box when tabbing/clicking through form fields.
Searches should explicitly be request by using the search button.
Concurrent searches - all concurrent programs are available that have the SRS flag <> 'N'.
Fixed issue with overloads causing a VBA error when OBJECTs are present in an API.
Rewrote synchronize to be more efficient.

2.3.44 (03-Aug-2017)

Added cardinality fix for SQL long list values.

2.3.43 (03-Aug-2017)

Fixed issue with PL/SQL on a column and a defaulter with a dependency. (Defaulter would refire).

2.3.42 (03-Aug-2017)

Updated Common 2.4 modules.

2.3.41 (02-Aug-2017)

Added DFF validation for required fields when columns are missing from the sheet.

2.3.40 (02-Aug-2017)

Added Key Flexfield form common fixes.
Added EBS concurrent setup support for procedure modes.
Added remove defaulter to concurrent overrides.

2.3.39 (01-Aug-2017)

Increased the size of the Key Flexfield segment form.

2.3.38 (31-Jul-2017)

Fixed VBA issue with PL/SQL column validation when switching between valid and invalid values.
Added rollbacks on table modes when PL/SQL table status is set to ERROR.

2.3.37 (28-Jul-2017)

Updated Downloader Modules.

2.3.36 (27-Jul-2017)

Fixed table uploads ORA: No Data Found when developing Pre PL/SQL for table upload modes.

2.3.35 (27-Jul-2017)

Fixed issue with long list LOVs showing ID in the dropdown when tabbing from field in the form.

2.3.34 (27-Jul-2017)

Fixed issue with combo box LOV dropdowns displaying the sheet value twice in the list.

2.3.33 (24-Jul-2017)

Updated the Common Architecture.

2.3.32 (22-Jul-2017)

Fixed concurrent report group security query - now includes application tied report groups.

2.3.31 (20-Jul-2017)

Fixed Submit Concurrent form issue erroring with a VBA error during button click.

2.3.30 (19-Jul-2017)

Fixed performance issue during large (10,000 line+) upload when printing colours to sheet.

2.3.29 (18-Jul-2017)

Fixed PL/SQL validation issue where column required was not being switched when value is blank.

2.3.28 (01-Dec-2017)

Fixed downloader URL on Setup page.

2.3.27 (17-Jul-2017)

Fixed issue when using PL/SQL validation on a column - column LOV would not populate.

2.3.26 (14-Jul-2017)

Added fix where DFF value set values wouldn't appear with a summary flag = 'Y'.

2.3.25 (12-Jul-2017)

Fixed KFF upload issue when using Segment mapping - if KFF was created on a SEGMENT field a VBA error would occur.
Fixed update/delete table modes where the code would blow up as the Row ID could not be found.

2.3.24 (11-Jul-2017)

Fixed issue with multiple DFFs on sheet (VBA error would occur when removing the second but not the first).

2.3.23 (10-Jul-2017)

Added validation to validate that the KFF View is used in the LOV FROM when a KFF Code is used.

2.3.22 (08-Jul-2017)

Fixed overflow error.
Concurrent tab in Manage Templates disabled if not on a M4A site.
Fixed duplicate processing form when downloading via sheet.
Fixed issue when attempting download in edit by sheet.
Web services mode is now hidden.

2.3.21 (03-Jun-2017)

New worksheet buttons are now disabled when creating a new worksheet.

2.3.20 (30-Jun-2017)

Fixed issue with concurrent parameters being assigned to the wrong argument.

2.3.19 (29-Jun-2017)

Updated common modules.

2.3.18 (27-Jun-2017)

Updated downloader to 1.0.79

2.3.17 (26-Jun-2017)

Fixed error caused by supported OBJECT data type in API.

2.3.16 (22-Jun-2017)

Fixed issue where downloader would stop downloading via sheet if download processing was cancelled.

2.3.15 (21-Jun-2016)

Fixed VBA issue when database record was not found.

2.3.14 (19-Jun-2017)

Added Web Service Response Mapping, Accepted Mapping and web services addin version to call.

2.3.13 (17-Jun-2017)

Fixed web service response. Now prints using the downloader.

2.3.12 (14-Jun-2017)

Fixed VBA error caused when a dependency was invalid for a long list of values.

2.3.11 (13-Jun-2017)

Updated DFF modules.

2.3.10 (12-Jun-2017)

Fixed issue where parameters of table types that were last in the query list.

2.3.09 (12-Jun-2017)

Fixed VBA error when loading procedure templates with multiple table types (Sections).

2.3.08 (09-Jun-2017)

WIP - Web Services. Functionality is currently hidden.

2.3.07 (09-Jun-2017)

Fixed issue with API templates not being derived correctly when the data level sequencing was out of order for record types.

2.3.06 (06-May-2017)

Fixed trial licence issue where data would be orphaned and prevent upload when trial limits were hit.

2.3.05 (02-May-2017)

Fixed Templating Downloader issue where downloader query set was being overwritten.
Query set now must be removed using "Remove Queryset" from template before another can be set.

2.3.04 (24-May-2017)

Fixed compile issue on Windows 10 32bit machines when Wizard is compile on a Windows 8 or less machine (XML Library issue).

2.3.03 (24-May-2017)

Updated DFF code to fix issue where a dependent value set could not be found for a different context with the same independent parent.

2.3.02 (22-May-2017)

Fixed concurrent DFF request parameters not adding SQL NULL for correct attribute ordering - The request would fail.

2.3.01 (22-May-2017)

Fixed controls on DFF form causing a VBA error when selecting a new context and clicking "Change".

2.3.00 (22-May-2017)

Updated to latest attachment modules.
Added DFF fix where required attributes would fail validation when not used in the current context.

2.2.99 (18-May-2017)

Fixed DFF issue where the required flag of a dependent field was not being toggled based on its dependency value.

2.2.98 (18-May-2017)

Fixed issue where dependent short list of values were not being correctly populated on initial validation.

2.2.97 (18-May-2017)

Updated the attachment modules.

2.2.96 (13-May-2017)

Added Downloader integration:
- Added Downloader tab to the Manage Template form for setting up a query set against a template
- Added Download Form and Download Sheet form buttons for downloading via a query set, set against a template

2.2.95 (11-May-2017)

Template Edit By Sheet - Load button: Processing form is only hidden if validation passes. The form will remain if there are any error messages present.
Fixed "Uninitialized Collection" issue with some APIs with TABLE TYPE parameters.
The TABLE TYPES are now initialized even when no data is present on the spreadsheet.
Added error message when deriving an API call with a parameter without an APICallArgument - this may either be a %TYPE or OBJECT. We currently cannot handle these parameter types.
Added DFF Dependent value set validation - when the parent column value is NULL then the required flag will be toggled off.

2.2.94 (09-May-2017)

Removed ribbon reset code when we lose the ribbon during VBA errors.

2.2.93 (05-May-2017)

Fixed issue when returning table interface data to the sheet (VBA error).

2.2.92 (03-May-2017)

Fixed issue where dates were being written incorrectly back to the sheet for OUT parameters.

2.2.91 (01-May-2017)

Fixes DBMS Output error when printing API results back to the debug sheet.

2.2.90 (29-Apr-2017)

Updated internal common modules.

2.2.89 (28-Apr-2017)

Updated key flexfield validation to support project/task segments for manufacturing key flexfields.

2.2.88 (27-Apr-2017)

Updated responsibility validation when importing templates to display message for invalid responsibilities.

2.2.87 (26-Apr-2017)

Fixed issue with KFFs on DFF attributes.

2.2.86 (24-Apr-2017)

Required columns are now set back correctly during PL/SQL validation if B_REQUIRED variable is set to false.

2.2.85 (24-Apr-2017)

Added KFF fix when Flex Number is blank.

2.2.84 (24-Apr-2017)

Application Calculation setting will now reset to automatic before each release.

2.2.83 (23-Apr-2017)

Fixed Synchronization on the Manage Template form to generate Status and Message columns for new sections when section is missing.
Simplified internal data storage - this should have a decent performance increase on most systems.

2.2.82 (22-Apr-2017)

Fixed issue when querying values with single quotes. Single quote would cause servlet XML error.
Added fix so extra overload parameters are not excluded from the overload form during procedure selection.

2.2.81 (19-Apr-2017)

Fixed VBA error during initialisation when creating a new sub section page for the form.

2.2.80 (19-Apr-2017)

Updated Downloader modules.

2.2.79 (13-Apr-2017)

Fixed DFF Keyflex Fields to use new DKFF code. Improvements include a performance increase and better robustness of KFF fields.

2.2.78 (12-Apr-2017)

Updated Downloader modules.

2.2.77 (11-Apr-2017)

Fixed concurrent issue where dependencies were invalid for LOV concurrent dependencies.

2.2.76 (10-Apr-2017)

Update Table templates now do not force Mandatory fields - ensure fields are read only if not mandatory.

2.2.75 (07-Apr-2017)

Updated attachments code in Core and Common 2.4

2.2.74 (06-Apr-2017)

Added KFF Dynamic Insertion Columns and KFF Segment Prefix columns for uploading new KFF concatenated segments into the database through an interface.
Fixed DBMS output sheet.

2.2.73 (05-Apr-2017)

Changed servlet 1.2.60 message to only appear once during wizard use (this will check for a blank template).

2.2.72 (04-Apr-2017)

Increased Excel stability during mass uploads (5000+ records).
Reduced Processing form locking during mass uploads.

2.2.71 (03-Apr-2017)

Fixed issue where required messages weren't being printed to the sheet correctly when clicking "OK" on the parent section form.

2.2.70 (01-Apr-2017)

Added message prompt when executing "Delete from Interface" prompting confirmation for deleting rows.
Improved grouping - now works with only Single group name in Sub Section or multiple names spread across columns.

2.2.69 (31-Mar-2017)

Added New Sub Section Name column.
Removed old section dividing via DFF Name and RecordTypes - use Sub Section Name column.

2.2.68 (30-Mar-2017)

Fixed Concurrent defaulting issue from MFG Org ID.

2.2.67 (30-Mar-2017)

Changed browser settings to suppress JavaScript errors during login.

2.2.66 (30-Mar-2017)

Changed extra instances of VBNewLine to vbLf Char(10) for 10.2 databases.

2.2.65 (29-Mar-2017)

Fixed VBA error in the Manage Template form when switching Action from New to Modify when exiting concurrent setup without saving.
Fixed DFF fields defaulting and overwriting when enabled.

2.2.64 (28-Mar-2017)

Added fix for carriage return.

2.2.63 (28-Mar-2017)

Fixed default profiles erroring when setting a dependency value (Descriptive Flexfields).

2.2.62 (28-Mar-2017)

Fixed issue with KFF fields on DFF columns - control would error as a text control is now created.

2.2.61 (24-Mar-2017)

Fixed error where DEFAULTED was blowing up as does not exist in 10g ALL_ARGUMENTS table.

2.2.60 (16-Mar-2017)

Fixed Concurrent issue on the Manage Template form when excluding the Concurrent Override parameter.
Fixed DFF fields where OR operator was used in the WHERE clause - this would cause the search to always return results.

2.2.59 (15-Mar-2017)

Changed X_MSG_COUNT default to 0 when variable is missing from API that uses X_MSG_DATA.

2.2.58 (15-Mar-2017)

Fixed issue where validation was broken on simple text fields.

2.2.57 (15-Mar-2017)

Updated common modules for 2.4

2.2.56 (14-Mar-2017)

Enabled XML page on Manage Template form even if not on M4A site - this is to allow importing/exporting templates.

2.2.55 (10-Mar-2017)

Updated DFF modules.

2.2.54 (07-Mar-2017)

Fixed DFF issue for downloading.
Fixed issue when modifying Template PL/SQL - new lines would be added between code.

2.2.53 (07-Mar-2017)

Fixed issue with KFFs on DFF attributes causing error with substitutions.

2.2.52 (07-Mar-2017)

Fixed an issue where DFF attributes with large prefixes e.g GLOBAL_ATTRIBUTE could cause a VBA error due to conflicts.

2.2.51 (07-Mar-2017)

Fixed issue where values would return invalid when single quotes were present in sheet value.

2.2.50 (07-Mar-2017)

Updated DFF modules.

2.2.49 (06-Mar-2017)

Updated downloader to 1.0.72

2.2.48 (01-Mar-2017)

Updated downloader to support large queries that are over 32767 bytes in size.

2.2.47 (28-Feb-2017)

Fixed issue with template attributes not being set initially.
Fixed issue with read only columns having their values overwritten.

2.2.46 (23-Feb-2017)

Fixed VBA issue with licencing - when records weren't being loaded (trial limit reached) an error would appear when loading more records.

2.2.45 (22-Feb-2017)

Updated section data to display rows being initialized on processing form.
Added downloader fix when query was too large - would blow out the downloader describe.

2.2.44 (20-Feb-2017)

Updated create sheet to put single quote in front of column name to preserve formatting for date headers.

2.2.43 (15-Feb-2017)

Updated common 2.4 refresh concurrent.

2.2.42 (14-Feb-2017)

Added fix for multi level record types (now need to handle errors for procedures with arrays within arrays).

2.2.41 (10-Feb-2017)

Fixed issue with PL/SQL validation with an LOV field - LOV wasn't being displayed.
Added web test on template change in manage template form.
Fixed grouping rule label.

2.2.40 (10-Feb-2017)

Allow access to the manage template form if not a designated user - user will still need system administrator access. This is to allow access to the about form and licence validation controls.

2.2.39 (10-Feb-2017)

If using SQL field on PLSQL defaulter - datatype will now always default to VARCHAR2.

2.2.38 (09-Feb-2017)

Added default value validation for when multiple columns are returned - SQL can only have one default column.
Added row 9 column header cell formatting to TEXT - Date headers are incorrectly written.
Dependency builder for PL/SQL now wraps TO_NUMBER or TO_DATE around function.

2.2.37 (09-Feb-2017)

Updated common 2.4 templating with fix for Edit By Sheet.

2.2.36 (09-Jan-2017)

Fixed VBA error when using PL/SQL validation on a column with dependencies and a LOV.
Fixed LOV Builder form not returning SQL or erroring on cmd_query click.
Added date/number examples for PL/SQL validation.

2.2.35 (08-Jan-2017)

Added support for TABLE type uploads (fixed initiation issue).

2.2.34 (08-Jan-2017)

Added support for TABLE types (Procedure query returns TABLE and PL/SQL TABLE types).

2.2.33 (07-Jan-2017)

Free Type LOV now respects single/multi row caching types.

2.2.32 (07-Jan-2017)

Fixed querying for APIs with record types.

2.2.31 (07-Jan-2017)

Removed R12 check around return parameters for table types.

2.2.30 (07-Jan-2017)

Fixed duplicate issue for label validation when labels were blank on Edit By Sheet.

2.2.29 (05-Jan-2017)

Removed validation for own column on dependency.

2.2.28 (05-Jan-2017)

Added column labels to edit by sheet form (only from current saved template).
Added validation for creating dependency on own column.
Free Type fields are now always searchable.
Fixed issue where VBA would error on (isSectionMandatory).
Fixed issue where query would error as SQL column was omitted.

2.2.27 (02-Jan-2017)

Fixed issue with Date columns and validatorText dependencies.

2.2.26 (02-Jan-2017)

Fixed carriage return when exporting template.
Fixed alias issue for display field causing XML parse error.
Disabled XML on manage template.
Load XML now merged with Upload XML.

2.2.25 (02-Jan-2017)

Fixed responsibilities button being overlapped by list box in Manage Templates form.
Fixed free type LOV dependencies/defaulting not correctly working.
Fixed carriage return formatting lost when exporting XML.

2.2.24 (01-Jan-2017)

Fixed dependency issue (2) on free type LOV.

2.2.23 (01-Jan-2017)

Fixed dependency issue on free type LOV.

2.2.22 (01-Jan-2017)

Added fix for duplicate template if clicking apply-close (Close button now disabled on apply).
Added substitution override for MFG_ORGANIZATION_ID - use concurrent setup to enable.

2.2.21 (21-Jan-2017)

Updated LOVs to substitute an alias when blank. Now uses regular expressions to build Validate/Upload column.
Fixed issue where alias wasn't applied to concatenated sheet LOV field.

2.2.20 (30-Jan-2017)

Fixed overwriting of EBS (Edit By Sheet) defaults when validating.
Added Date and Date/Time buttons to help with date defaults.

2.2.19 (27-Jan-2017)

Fixed PL/SQL validator tied to non-LOV field.

2.2.18 (27-Jan-2017)

Fixed issue where Apply/Ok in manage templates could be clicked multiple times creating duplicates in the database.

2.2.17 (26-Jan-2017)

Display only fields now overwrite default values.
Added download (Out Of Memory) fix when downloading too many records and writing to DW error log (DW 1.0.70).
Removed DFF-KFF search messages in DFF forms.
Fixed DFF-KFF issue with flex number not being defined when no flex clause in definition.
Fixed profile options not being resolved for DFF-KFF structures.

2.2.16 (25-Jan-2017)

Enabled the Run Query button for the PL/SQL validation builder.

2.2.15 (20-Jan-2017)

Added a PL/SQL validator. PL/SQL can be written to further validate an LOV/column (still need to do run query).
Added new templating columns:
- PLSQL Declare: Declare variables and dependencies for a PL/SQL validator
- PLSQL Body: PL/SQL code for validating sheet data
Cleaned up adding a new setting - can now all be done via UWSettingTypes.
Removed wrapped text from Edit By Sheet – template.
Added fix for PL/SQL booleans - will only be uploaded if upload value is TRUE or FALSE.
Added Date/Time Yes/No LOV for adding time to a date field (edit by sheet).

2.2.14 (19-Jan-2017)

Added 12c Fix for database issue - OOD didn't work using the user_ DD queries (couldn't find OOD packages).
Added examples for refresh/error/additional SQL for concurrent refresh.

2.2.13 (19-Jan-2017)

Patched core 212.0.1
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.
We have had problems with both new EBS Framework patches in 12.2+ and customer SSO setups.
EBS Framework patch problem: In EBS 12.2.6 a framework patch has stopped us from being able to select a language in the browser login page.
Note - It is a framework patch so it is not specific to and EBS version. We have only seen it in 12.2.6. But a customer could choose to install this patch against a 12.2.4 environment.
The framework patch has changed the languages list in the EBS browser login from to be displayed in a drop down box. The web browser control that VBA uses doesn’t work properly with this dropdown meaning you can’t select/change a language. It is a bit random on which language is selected. We are seeing customers being logged in with the wrong language and not being able to change this.
SSO Setup: Customers are being logged into with the wrong language. Not sure if it is because of the framework patch as detailed above.

2.2.12 (18-Jan-2017)

Updated dependencies to use new error message for better feedback.
Fixed 'Reset' button multilingual message.
Added LOV type to Validation SQL message.

2.2.11 (17-Jan-2017)

Fixed issue with error SQL (concurrent) causing VBA error if AcceptedSQL was set but not error SQL.
Added KFF WHERE clause error message when dependencies are on DFF KFFs.
Fixed support for DFF KFFs with SET columns.

2.2.10 (16-Jan-2017)

Fixed KFF combinations LOV issue - LOV values not appearing in the combinations LOV form.
Fixed request group issue where program tied to application was coming back invalid.
Fixed concurrent override validation error.

2.2.09 (13-Jan-2017)

Merged application queries. Now query is run on post-login.
Fixed KFF initialisation issues.
Fixed DFF dependency issue with date formatting.

2.2.08 (12-Jan-2017)

Concurrent program definition won't be able to find the application if not in the correct responsibility.
Enhanced concurrent application message to reflect this.
Fixed flexfield errors for invalid Application Codes.

2.2.07 (11-Jan-2017)

Updated Downloader modules.

2.2.06 (11-Jan-2017)

Added SQL validation success message when validation passes.

2.2.05 (10-Jan-2017)

Fixed Validate button on the Default Form Tab showing when not SQL.
Status/Message column warnings on EBS only display when form is open.

2.2.04 (09-Jan-2017)

Validate Only 'Edit By Sheet' - Fixed issue where after Validate Only changes couldn't be saved for template.

2.2.03 (06-Jan-2017)

SQL Validation - Fixed Query Run button issue causing error with dependencies.

2.2.02 (05-Jan-2017)

SQL Validation - error messages now correctly populate in the validation tab.
Added validate button for default SQL statements.

2.2.01 (04-Jan-2017)

Added SQL field validation.
Significantly improved validation for SQL statements - now won't continuously run.
Added processing form feedback when writing fields to sheet for 'Edit By Sheet'.

2.2.00 (22-Dec-2016)

Updated common 2.4 Fixed performance issue with caching.
Updated form functions to use multi form.
Updated to allow edit by sheet for loader lock - only display, mandatory, label, comment and read only editable.
Refactored validation code for edit by sheet.
Commonized edit by sheet and merged forms into one.
Note - Removed KFF upload. Now can set KFF form by specifying KFF App Name, Key Code, and Key Number.
First dependency in the LOV will be used as the structure dependency. [Common]
This will only work for EXISTING combinations. Please change LOV type to 'Free Type' and then add PL/SQL to upload segments. This is NOT backwards compatible.

2.1.02 (15-Dec-2016)

Fixed [BLANK] values not being uploaded.

2.1.01 (14-Dec-2016)

Updated Common 2.4 modules.

2.1.00 (14-Dec-2016)

Updated Downloader modules.

2.0.99 (13-Dec-2016)

Implemented downloader fix - an ID was being truncated from query for each query block.

2.0.98 (13-Dec-2016)

Added downloader fix (1.0.68 version).

2.0.97 (09-Dec-2016)

Fixed caching issue when using row 10 for dependencies.

2.0.96 (08-Dec-2016)

Updated common modules for compiling on Excel 2016.

2.0.95 (01-Dec-2016)

Updated Downloader modules.

2.0.94 (02-Dec-2016)

Updated common 2.4 modules.
Removed redundant Downloader right click menus as was not being used.

2.0.93 (02-Dec-2016)

Fixed downloader issue when clicking on ribbon.

2.0.92 (01-Dec-2016)

Updated Downloader modules.

2.0.91 (29-Nov-2016)

You must add 'p_row' to return ANY child output results.

2.0.90 (25-Nov-2016)

Implemented Refresh and extra column functionality and concurrent report group security.

2.0.89 (23-Nov-2016)

Added DFF code names to 'Create new sheet'. Does not resolve code yet.
Cleaned up DFF manage template code
- ID values now displayed on form. Meanings displayed in setup form
This was to clean up slow and nasty 'resolving' code at different points.
- Setup form now conforms to common standards
Updated Downloader Modules to 1.0.65
- Concurrent security still in development
- Refresh still in development

2.0.88 (22-Nov-2016)

Fixed issue where mode wasn't being correctly set after closing manage templates form
Added overriding for concurrent programs:
- Refresh still in development
- Concurrent security still in development

2.0.87 (18-Nov-2016)

Fixed issue with concurrent override, remove and PLSQL buttons not being disabled/enabled correctly:
- Overrides still in development
- Refresh still in development
- Concurrent security still in development

2.0.86 (17-Nov-2016)

Implemented concurrent setup functionality:
- Overrides still in development
- Refresh still in development
- Concurrent security still in development

2.0.85 (16-Nov-2016)

Implemented concurrent delete functionality.

2.0.84 (10-Nov-2016)

Began ribbon implementation of concurrent submissions.
Delete mode now displays 'Deleted' instead of 'Accepted'.
Added 'Free Type' to LOV Types.
Excel 2016 - fixed issue with Manage Template controls not being clickable.

2.0.83 (09-Nov-2016)

Updated Downloader modules.

2.0.82 (09-Nov-2016)

Updated Downloader modules.

2.0.81 (09-Nov-2016)

Fixed issue with loose dependencies.

2.0.80 (08-Nov-2016)

Updated Downloader modules.

2.0.79 (04-Nov-2016)

Fixed Table Return Results clearing out RowID in Table Modes.

2.0.78 (03-Nov-2016)

Fixed issue in Table Return Results after upload with 'SubScript out of Range'. Issue was caused by selecting multiple rows with gaps.

2.0.77 (01-Nov-2016)

Fixed unusual issue in Table Mode - if a Custom Column is your first column in your section, Table SQL is truncated.
Changed table mode to use 'p_error' for returning messages and 'p_status' for using the FND_API success/failure constants (custom PL/SQL).

2.0.76 (28-Oct-2016)

Fixed licencing info on 'Manage Loader Users' button on a cleaned Wizard.

2.0.75 (24-Oct-2016)

Added Licence information to about form. This includes a 'Full' or 'M4A' prefix to the Maintain Users button. Licence info is also displayed under the 'Close' button.
Enabled synchronize button for locked down templates (supported loaders).

2.0.74 (17-Oct-2016)

Updated common architecture to 2.3

2.0.73 (14-Oct-2016)

Moved validate licence button next to loader users.

2.0.72 (13-Oct-2016)

Updated common query object to check for 11i queries that will fail when passed up to the M4APS_XML package. The package checks for 'SELECT' as the initial SQL 'wording'.
Added check for status/message column to ensure we load them properly if they don't have API parameters.

2.0.71 (12-Oct-2016)

Manage Template Form - Procedure/Table field can now be selected and copied.
Added fix for parameters that are in the template but not part of the API/Table anymore.
Message will alert user and parameter will be disabled.
Added 11i fix for 'Bad Server Request' when saving templates.

2.0.70 (11-Oct-2016)

Fixed ‘Out of Memory’ VBA error when saving templates.

2.0.69 (10-Oct-2016)

Added developer notes column.
Last template used on 'Manage Templates' is now saved.
Removed message box from package search and warning color now displays if no results found.

2.0.68 (04-Oct-2016)

Fixed template name ordering issue.
Added 'Rename' button to the manage template form.
Added form function security enhancement.

2.0.67 (03-Oct-2016)

Added message pop up when decrypting an invalid licence key fails.
Added message for unsupported API nested setup.
Fixed 'No Data Found' issue with child records when uploading multiple headers at the same time. Implemented Default Type 'Incrementer' fix for grandchild sections. Incrementer was not reset properly between API calls.
Validation is now called when loading from sheet for Templates.

2.0.66 (19-Sep-2016)

Fixed VBA error when entering license key using about form (user template list was cleaned up but not re-initialized).

2.0.65 (15-Sep-2016)

Fixed issue with default directories for saving templates.

2.0.64 (12-Sep-2016)

Added p_error support for Table Mode Pre/Post PL/SQL. The table inserts will not run if this is not null.

2.0.63 (08-Sep-2016)

Added fix for text-based dependencies (non-LOV) causing error when validating cache size.

2.0.62 (07-Sep-2016)

Fixed Date Time parameters adding date wrapper to wrong parameters.

2.0.61 (01-Aug-2016)

Fixed issue when parameter is missing from the API call in a different instance - use the synchronize button in Manage Templates.

2.0.60 (31-Aug-2016)

Fixed Date/Time parameters for record types in API.

2.0.59 (31-Aug-2016)

Increased size of Manage Template parameter list box fields.

2.0.58 (31-Aug-2016)

Fixed end-to-end trace displaying 'Do you wish to close trace?' when trace was initially opened.
Improved End-To-End trace details by printing to the current worksheet when enabled.

2.0.57 (30-Aug-2016)

Fixed validation issue - 'Error' status was not being written to status column when text (sheet value) based dependency was set up.

2.0.56 (30-Aug-2016)

Added 'Copy Column' button to Custom Column form for quickly adding columns.

2.0.55 (30-Aug-2016)

Enabled Custom Column functionality.

2.0.54 (29-Aug-2016)

Fixed DateTime parameters not being parsed correctly for API/Table uploads.
Fixed ribbon VBA error when Setup tab was hidden.

2.0.53 (26-Aug-2016)

Fixed 12c issue where Owner was not being added to API call correctly.

2.0.52 (26-Aug-2016)

Fixed issue with Disable SaveData - Section Form values were not being written to sheet.
Fixed issue with LOV cache validation for ShortLists.

2.0.51 (25-Aug-2016)

Updated Downloader Modules.

2.0.50 (25-Aug-2016)

Added fix for defaulting from parent/SQL. If field is date you must select back SQL field as so:
SELECT sysDate FROM DUAL.
- Regular dates must not have a TO_CHAR around then select TO_CHAR(sysdate, 'YYYYMMDDHHMMSS') from dual - Date/Time MUST have a TO_CHAR around field in format 'YYYYMMDDHHMMSS'.

2.0.49 (24-Aug-2016)

Fixed issue where results were not being written back to the sheet for large uploads.

2.0.48 (24-Aug-2016)

Fixed validation cache type issue - parent dependency column can be MultiRow and child column can be SingleRow.
Added warning to SQL builder form to ensure that dependency caching matches.

2.0.47 (24-Aug-2016)

Added Save Data toggle - Enable will write colouring/Defaults to the sheet.
- Disable will only write status/messages back.

2.0.46 (20-Aug-2016)

Added Error handling in API return results - if section is not found in the data it will print keys/items to the common support sheet.

2.0.45 (19-Aug-2016)

Added Uppercase to Package/Table/Attachment selection form. Fixes issue with mixed case matches.
Changed 'Validate And Upload' mode to use direct SQL calls instead of stateStep for API modes.

2.0.44 (18-Aug-2016)

Fixed Excel error when 'Saving Data' with a sheet having greater than 65,000 records.

2.0.43 (17-Aug-2016)

Added Template manager check to 'Import Template' button in the ribbon.
Added column formatting when column dataType is 'Text' (Other columns still default to General) when creating a new sheet.

2.0.42 (17-Aug-2016)

Added ribbon fix for 'Error -2147221163 (Method 'accName' of object 'IAccessible' failed) in procedure GetAccessible of Module fndRibbonAccessibility'.

2.0.41 (15-Aug-2016)

Licencing details for More4Apps loaders now only reads the 'Loader Name' (not the supported checkbox).

2.0.40 (15-Aug-2016)

‘Loader Users' button is now available for 'Loader Name' loaders only (without supported check).
Template Manager now has access to all templates.

2.0.39 (12-Aug-2016)

Updated downloader to 1.0.53. Fixed issue where results were being duplicated.

2.0.38 (09-Aug-2016)

Licence key cache now resets when loading a new licence key into the wizard (full or loader specific).
Added download profile option "More4Apps: " & M4APS_APPS & "Download Manager".

2.0.37 (04-Aug-2016)

Fixed #N/A issue when printing messages to message column.
Fixed [BLANK] for API uploads - variables/record types can now be blanked out if the API supports it.
Added functionality to ignore mandatory check for entire section if removed from sheet (API mode only).

2.0.36 (03-Aug-2016)

Added "More4Apps: " & M4APS_APPS & "Template Manager" profile option to override sysAdmin check. For manage templates only.

2.0.35 (01-Jul-2016)

Fixed validation issue for template - Parent short lists are now valid for dependencies.

2.0.35 (01-Jul-2016)

Fixed validation issue for template - Parent short lists are now valid for dependencies.

2.0.34 (01-Jul-2016)

Added warnings for procedures with object type parameters. Templates can still be generated without them.

2.0.33 (29-Jul-2016)

Fixed dependency issue causing SQL errors for cached LOVs.

2.0.32 (28-Jul-2016)

Added support for DFF KFFs with dependencies.
Added validation for LOV caching - queryLimit and validator must be the same for dependencies.

2.0.31 (22-Jul-2016)

Manage Template Forms - fixed issue where extra line feeds were added on save.

2.0.30 (22-Jul-2016)

Added LOV ordering for DFFs in manage templates.
Fixed 'Export All' issue on manage templates.

2.0.29 (20-Jul-2016)

Fixed debug sheet not printing debug information.
Added critical warning when section hierarchy is not correct.

2.0.28 (19-Jul-2016)

Fixed issue where carriage return was being truncated from SQL statements.

2.0.27 (18-Jul-2016)

Fixed importing template through 'Import Template' or Manage Template forms to look at the global template collection for conflicts.
Fixed Dependency SQL error for eCache (VBA error).

2.0.26 (14-Jul-2016)

Check if section hierarchy have been loaded - display an error if not loaded correctly.
Fixed VBA error when changing responsibilities using the about form.

2.0.25 (13-Jul-2016)

Enabled dependencies on Additional Select and From LOV statements.
Added SQL validation for dependencies - maximum of 5 dependencies allowed.

2.0.24 (12-Jul-2016)

Added validate licence button to the More4Apps tab of the manage templating form.
Use this to validate a licence against the current product.

2.0.23 (11-Jul-2016)

Fixed requestCallBack issue when searching on the form.

2.0.22 (11-Jul-2016)

Fixed caching issue - cardinality has been properly assigned to caching. Query performance drastically improved.

2.0.21 (11-Jul-2016)

Fixed issue with template saving - created a new XML row in the database.

2.0.20 (07-Jul-2016)

Fixed attachment mode.
Added in package body/header versions for packages that support the VERSION procedure.
Fixed about form to use 'Application Interface Wizard'.
Fixed about form height.
Added XML printing to debug sheet as data is now cleared - XML can be uploaded from the debug sheet.

2.0.19 (05-Jun-2016)

Fixed 'setValRecWrapper' issue for table uploads.

2.0.18 (30-Jun-2016)

Updated Downloader modules.

2.0.17 (28-Jun-2016)

Exclude column labels from checksum.
Added check for 'Out of stackSpace error' caused by dependencies. Now pops a message detailing the issue (section hierarchy).
Added fix for 12c (12.1) databases - procedure query cannot run off owner anymore (Defaults to the process user).

2.0.16 (23-Jun-2016)

Added default type 'Incrementer' - increments the default value by 1 for each row.

2.0.15 (23-Jun-2016)

Fixed error when clicking 'Loader Licence' on the manager template form when entering new licenses.

2.0.14 (22-Jun-2016)

Added error handling on events (set the entry point).
Added dependency check for invalid SQL field dependencies (the field doesn't exist in the parent SQL).

2.0.13 (22-Jun-2016)

Added max size to the overload form (so it doesn't appear off screen) - Added scroll bar as well.
Added returnSQL for in/out parameters at the API level (param will now return to the sheet).
Added custom return status (M4A_RETURN_STATUS) variable when API is missing. 'X_RETURN_STATUS' param.
You can overwrite this with 'Error' in pre/post PL/SQL if you wish to error the wizard. This will default to 'Accepted'.
Added in better Wizard parsing to return PL/SQL errors to the sheet when the main PL/SQL block raises an exception.

2.0.12 (21-Jun-2016)

Added 'LOV Cache Type' and 'LOV Cache Row Limit' to templating.
Specify these on the templating form for 'Long List' LOV types.
If template not saved correctly, message will now pop up asking to reload the template XML.
Invalid templates in the database will be caught on login - may be cleared with message box control.

2.0.11 (20-Jun-2016)

Added date options for dependency validator (when running SQL in LOV builder).
Added column label translation to dependency validator.

2.0.10 (16-Jun-2016)

Added session check every 300 rows - to help prevent timeouts (also checks for 3minutes since last session check).
Added PL/SQL record scroll fix - for the Record Types tab in manage template (now adds scroll bar properly).
Added section check to ignore loading sections that aren't used.

2.0.09 (16-Jun-2016)

Changed DFF Name to DFF Title in the Descriptive Flexfield Setup form. This will be backwards compatible.

2.0.08 (15-Jun-2016)

Added check if package installed when importing template.

2.0.07 (15-Jun-2016)

Added validation for duplicate column labels on 'Edit By Sheet'.
Updated Downloader Modules to fix 64 Bit Excel Issues.

2.0.06 (13-Jun-2016)

Fixed issue with illegal sheet sheet-name characters in template name.

2.0.05 (09-Jun-2016)

Fixed issue on login.
Fixed issue when logging into an instance and inserting new wizard translations would cause a PL/SQL error.

2.0.04 (08-Jun-2016)

Added validation to 'Copy Template' to fix issue where duplicate templates could be created.

2.0.03 (03-Jun-2016)

Updated Downloader modules.

2.0.02 (26-May-2016)

Performance improvements and fixes.

2.0.01 (26-May-2016)

Added validation fix for numeric columns LOV and cancelling search (% would blow up =).
Fixed duplicate template names across different instances.
Fixed invalid sheet name characters.
Write licence details on template change to the Errorlog and Commonlog now.
Added AI Licence and Loader licence button to manage templates.

2.0.0 (25-May-2016)

Initial Release