5.03.30 (02-May-2025)

Fixed Logging button showing the wrong label.

5.03.29 (14-Apr-2025)

Fixed issue where branch was updated with an incorrect BIC when assigning a bank account.

5.03.28 (28-Mar-2025)

Allow searching by Taxpayer Id for Individual Org Type suppliers in the Download form.

5.03.27 (26-Mar-2025)

Default Browser Login - Fixed bug where the browser would not navigate away from the homepage.

5.03.26 (26-Mar-2025)

Fixed Taxpayer Id not uploading correctly, resulting in it not downloading for Individual Org types.

5.03.25 (15-Oct-2024)

Added Default Browser Login option.

5.03.24 (02-May-2024)

Fixed ORA-00936: missing expression on some DFF configurations.

5.03.23 (14-Feb-2024)

Fixed ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

5.03.22 (20-Nov-2023)

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

5.03.21 (13-Nov-2023)

Fixed Language issue around employee types when updating Supplier Site details.

5.03.20 (02-Nov-2023)

Fixed issues around Updating Supplier Bank Details.

5.03.19 (03-Oct-2023)

Added new digital signature.

5.03.18 (27-Sep-2023)

Fixed CustomLogo error when creating a new sheet.

5.03.17 (19-Sep-2023)

Restored formatting of Template123 and New Sheet.

5.03.16 (14-Sep-2023)

Fixed error when attempting to Create a supplier with an Enabled Customer.
Fixed issue where Complete supplier validation was not running when Enabled Customer fields were on the sheet.

5.03.15 (01-Sep-2023)

Internal update.

5.03.14 (26-Jul-2023)

Internal update.

5.03.13 (17-Jul-2023)

Internal update.

5.03.12 (06-Mar-2023)

Correct the minimum package version.

5.03.11 (09-Jan-2023)

Internal update.

5.03.10 (08-Dec-2022)

Fixed issue which 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.

5.03.09 (02-Dec-2022)

Internal update.

5.03.08 (21-Nov-2022)

Fixed Error 438 when uploading bulk suppliers.

5.03.07 (29-Sep-2022)

Added new ribbon button 'Validation Messages' to disable pop-up messages when Validating and Uploading.

5.03.06 (06-Sep-2022)

Internal update.

5.03.05 (29-Aug-2022)

Allow Tax Applicability will no longer download 'No' when null in the database.

5.03.04 (12-Jul-2022)

Internal update.

5.03.03 (11-Jul-2022)

'Site Name for Assignment' LOV will now display the address name and address details within the LOV to the right.

5.03.02 (05-Jul-2022)

Fixed error when using "Export Setup".

5.03.01 (28-Jun-2022)

Fixed Error 457 when validating sites if both standard and global DFFs were being used.

5.03.00 (16-Jun-2022)

Fixed the issue where attachment description was corrupted when it has multip-bytes characters, for example Japanese characters. Added support uploading long text attachment.

5.02.99 (10-Jun-2022)

Fixed the issue where attachment description was corrupted when it has multip-bytes characters, for example Japanese characters. Added support uploading long text attachment.

5.02.98 (09-Jun-2022)

Fixed the issue where attachment name or attachment content could be broken when they have multip-bytes characters, for example Japanese characters. Added support uploading long text Attachment.

5.02.97 (08-Jun-2022)

Internal update.

5.02.96 (08-Jun-2022)

Taxpayer Id will now download from the supplier table if not avaialable in the parties table.

5.02.95 (31-May-2022)

Improved performance when download Site Bank Accounts.

5.02.94 (05-May-2022)

Internal update.

5.02.93 (20-Apr-2022)

Fixed error when logging in if "MO: Operating Unit" Profile value was not set at Site level.

5.02.92 (01-Apr-2022)

Internal update.

5.02.91 (30-Mar-2022)

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

5.02.90 (07-Mar-2022)

Corrected tooltips for several ribbon buttons.

5.02.89 (04-Mar-2022)

Fixed error when opening the Site Attachment form on a row that only had Header Attachment data.

5.02.88 (03-Mar-2022)

Fixed error when opening the Attachment form on a completely blank row.

5.02.87 (21-Feb-2022)

'Include Inactive Suppliers' is now checked by default in the Download form.

5.02.86 (20-Jan-2022)

Internal upgrade.

5.02.85 (20-Jan-2022)

Fixed invalid 'Customer XXX does not exist' error.

5.02.84 (18-Jan-2022)

Internal update.

5.02.83 (14-Jan-2022)

Enabled use of the extension package when enabling the Profile Option: More4apps: SW Enable Extension Pkg

5.02.82 (20-Dec-2021)

Fixed minor spelling errors.

5.02.81 (31-Aug-2021)

Fixed 'No Object Version Number found' error when attempting to Assign a Bank Account that has a future start date.

5.02.80 (06-Aug-2021)

Fixed issue where 'Download via sheet' would download using criteria beyond the selected rows.

5.02.79 (05-Jul-2021)

Updated security.

5.02.78 (16-Jun-2021)

Fixed performance issue and timeout when caching validation data for Supplier.

5.02.77 (10-Jun-2021)

Wizard now correctly rejects account creation for inactive branches.

5.02.76 (09-Jun-2021)

Fixed issue where a branch could not be uniquely identified if its bank shared a bank number with an inactive bank (it should only consider the active bank to determine uniqueness).

5.02.75 (08-Jun-2021)

Fixed another bug where Banks and Branches could be considered inactive when only providing one identifier (e.g. only Name or only Number).

5.02.74 (04-Jun-2021)

Fixed bug where Banks and Branches could be considered inactive when only providing one identifier (e.g. only Name or only Number).

5.02.73 (31-May-2021)

Inactive Banks and Branches will no longer be considered when determining uniqueness of Banks and Branches.

5.02.72 (12-May-2021)

Improved error messaging when attempting to crate an account against an inactive Branch.

5.02.71 (10-May-2021)

Inactive Banks and Branches will now error when attempting to create an Account against them.

5.02.70 (03-May-2021)

Fixed XML Parse error when entering [BLANK] into the Distribution Set Id field in the Download form. The [BLANK] value will now be ignored.

5.02.69 (30-Apr-2021)

Now provides a better message if R12Temple123 is deleted or renamed.

5.02.68 (01-Apr-2021)

Updated security.

5.02.67 (04-Mar-2021)

Fixed issue where the bank account Id was marked invalid when updating if the currency wasn't on the sheet.

5.02.66 (01-Mar-2021)

Updated security.

5.02.65 (17-Feb-2021)

Fixed issue where address_style was not being populated when creating Supplier Sites.

5.02.64 (17-Feb-2021)

Fixed error in City LOVs when using a customized flexfield.

5.02.63 (02-Feb-0021)

Updated security.

5.02.62 (13-Jan-2021)

Updated security.

5.02.61 (02-Dec-0020)

Updated security.

5.02.60 (02-Nov-2020)

Updated security.

5.02.59 (03-Jul-2020)

Fixed server error when updating a site with supplier id "[BLANK]".

5.02.58 (06-Jun-2020)

Fixed error when downloading (ORA-0147: single-row subquery returns more than one row)

5.02.57 (04-Jun-2020)

Fixed links on the Setup page and internal upgrade.

5.02.56 (12-May-2020)

Fixed download of external payee information (Deliver Method and Delivery Email in particular) when multiple party sites exist.

5.02.55 (19-Mar-2020)

Updated color scheme.

5.02.54 (17-Mar-2020)

Added skipping the More4apps servlet error message if servlet checking returns 400 (bad request) as in a small chance it returned 400 error with properly installed servlet.

5.02.53 (04-Feb-2020)

Fixed issue where site Bank Account DFFs were not downloading correctly when assigned at address level.

5.02.52 (02-Feb-2020)

Updated security.

5.02.51 (09-Jan-2020)

Fixed infinite loop when attempting to download an invalid supplier.

5.02.50 (08-Jan-2020)

Download via Sheet will no longer leave blank rows between records.

5.02.49 (15-Nov-2019)

Download form will now remember your selection for 'Ignore Case'.

5.02.48 (14-Oct-2019)

Internal update.

5.02.47 (11-Oct-2019)

Fixed HTTP 500 internal server error when downloading with Base64 servlet installed.

5.02.46 (10-Oct-2019)

Internal upgrade.

5.02.45 (09-Oct-2019)

Fixed Download error when downloading Site Bank Acc Owners.

5.02.44 (09-Oct-2019)

Fixed issue where only the first Bank Acc Owner would be returned on Download.

5.02.43 (07-Oct-2019)

Fixed issue where Site Bank Account DFFs and Intermediary Site Account information was not downloading correctly.

5.02.42 (04-Oct-2019)

Fixed issue where ribbon "Session" info would not update when logging in, unless using the login button.

5.02.41 (03-Oct-2019)

Fixed spreadsheet values above the selection being cleared when performing Download Selected on a row with no header information.

5.02.40 (03-Oct-2019)

Fixed issues when adding more than 600 columns to the sheet - limit changed from 600 to 1000.

5.02.39 (25-Sep-2019)

Fixed issue where row 10 defaults in the supplier attachment columns would be duplicated if multiple sites were on the sheet.

5.02.38 (19-Sep-2019)

Fixed incorrect "invalid supplier" message when assigning bank account owners when Supplier Name/Number Acc Owner column was not on the sheet.

5.02.37 (03-Sep-2019)

Updated security.

5.02.36 (07-Aug-2019)

Internal upgrade.

5.02.35 (19-Jul-2019)

Fixed issue where simultaneous Bank Account creation at Supplier and Site level would fail with "External bank account already exists" - this was due to incorrect capitalization of the update mode i.e. "CREATE" instead of "Create".

5.02.34 (10-Jul-2019)

Fixed error when doing bulk downloads with over 1000 bank accounts, resulting in no Intermediary Bank Accounts being downloaded.

5.02.33 (02-Jul-2019)

Updated security.

5.02.32 (30-May-2019)

Attachments will now default from row 10 if parent data is populated.

5.02.31 (24-May-2019)

Updated Change Log.

5.02.30 (23-May-2019)

Download via sheet when using % in the Supplier Name field will now be case insensitive.

5.02.29 (23-May-2019)

Fixed validation error showing an empty error message prompt if DFF values exist n the worksheet but the DFF is not defined.

5.02.28 (22-May-2019)

Added ability to download via sheet using a wildcard (%) in the Supplier Name criteria.

5.02.27 (16-May-2019)

Fixed errors when validating DFFs which use value set references containing ".VALUE".
Fixed incorrect handling of DFF value sets dependent on ID based value sets.

5.02.26 (16-Apr-2019)

Removed "Assign and Update" from the Supplier Bank Update Mode LOV as this only makes sense for Site level.

5.02.25 (09-Apr-2019)

When a site bank account update mode is create, the account already exists and "Auto Assign Account Ownership" is enabled - a message will be returned to the sheet "The existing account will be automatically assigned".
Added 'Assign and Update' update mode for bank sections.

5.02.24 (02-Apr-2019)

Fixed issue where the entire sheet would be unwrapped on unsuccessful download.

5.02.23 (25-Mar-2019)

Improved download performance for certain customers.

5.02.22 (22-Mar-2019)

Branch Name LOVs are now wider to allow viewing of larger values.
Fixed error when clicking 'Export URL' or 'Import URL'.
Fixed error when trying to 'Export Setup'.

5.02.21 (21-Mar-2019)

Improved download performance for certain customers.

5.02.20 (20-Mar-2019)

Changed datafield colour from "White" to "No Fill".

5.02.19 (18-Mar-2019)

Updated the colour scheme.

5.02.18 (01-Mar-2019)

Fixed issue where only the first record would be returned for certain sections.

5.02.17 (27-Feb-2019)

Fixed error when downloading mass amounts of suppliers "Error 14 (Out of string space) in procedure LoadXMLData of Module fndXMLHTTP".

5.02.16 (20-Feb-2019)

Duplicate Supplier Names are now allowed when one of the vendor types is employee. This validation will now be left to the API.

5.02.15 (12-Feb-2019)

Updated security.

5.02.14 (07-Feb-2019)

Fixed SQL error "single-row subquery returns more than one row" when downloading multiple suppliers.
Fixed VBA error when downloading when global DFF attributes have been registered to the standard DFF.

5.02.13 (23-Jan-2019)

The Approvals Settings form will no longer display at all when the "Approval Workflow is disabled" message appears.

5.02.12 (22-Jan-2019)

Disabled Approval Workflow functionality.

5.02.11 (17-Jan-2019)

Fixed issue where addresses with a duplicate address name could not have their details updated due to "Address Name is already in use" error.

5.02.10 (16-Jan-2019)

Setup sheet now links to the correct "Setup the Template" page in the documentation.

5.02.09 (15-Jan-2019)

Fixed issue where the ‘Deselect All’ button in the ‘Customize Fields’ form would not work correctly for sections with spaces in the name.

5.02.08 (15-Jan-2019)

Fixed error when creating a Bank Account when additional branch information profile option is enabled.

5.02.07 (07-Jan-2019)

Updated security.

5.02.06 (19-Dec-2018)

Fixed error when downloading Supplier in Database: 11.1.0.7.0
Error: ORA-01719: outer join operator (+) not allowed in operand of OR or IN.

5.02.05 (12-Dec-2018)

Added new Setup Ribbon Debug Upload option ‘End to End Trace Unlimited Size’.

5.02.04 (05-Dec-2018)

Added new profile option 'More4Apps: SW Update Colombian Third Party Information' which allows the Wizard to update JL_CO_GL_NITS when creating and updating Colombian suppliers.

5.02.03 (03-Dec-2018)

Updated security.

5.02.02 (30-Nov-2018)

Fixed address type returned by the selected country.

5.02.01 (29-Nov-2018)

Fixed issue where address level bank accounts would not be downloaded or identified during validation.

5.02.00 (26-Nov-2018)

Changed version number.

5.00.107 (22-Nov-2018)

Added Logging and Help buttons to the ribbon.
Ribbon buttons ‘Source bank from branch’, ‘Identify Bank,’ or ‘Identify Branch’ now correctly log you out so that the Wizard reinitialises.

5.00.106 (21-Nov-2018)

Upgraded ribbon infrastructure.

5.00.105 (16-Nov-2018)

Updated minimum package information.

5.00.104 (15-Nov-2018)

Fixed error when selecting a supplier bank account from "Select Bank Account".

5.00.103 (14-Nov-2018)

Increased the width of the Oracle login form to accommodate wider customized login pages.

5.00.102 (13-Nov-2018)

Fixed Excel 64Bit error when choosing an Attachment category.

5.00.101 (09-Nov-2018)

Fixed Bank ID search issue at supplier level.

5.00.100 (08-Nov-2018)

Fixed issue where Site Level Bank ID would display invalid when institute type was entered, and the filter would cause the Bank ID search to fail.

5.00.99 (12-Oct-2018)

Fixed error when searching Supplier Bank Institute Type in the edit form.
Fixed error when creating supplier bank account.

5.00.98 (12-Oct-2018)

Fixed API error when creating bank account with duplicate account number and different currency.

5.00.97 (09-Oct-2018)

Updated security.

5.00.96 (03-Oct-2018)

Fixed error ‘ORA-00904: "PS"."PARTY_SITE_ID": invalid identifier’ when downloading and ‘Include Employee Types’ setting is enabled.

5.00.95 (26-Sep-2018)

Customer updates.

5.00.94 (25-Sep-2018)

Fixed VBA error when selecting a supplier bank account at site level using the button in the edit form.
Fixed a problem where Bank searches in the edit form were filtered by the institution type code when it should have been the value.

5.00.93 (25-Sep-2018)

Previous change has populated the institute type code which was invalid, I have changed this to the meaning.

5.00.92 (10-Sep-2018)

‘Select Supplier Bank Account’ button will now default Bank Institute Type, Alternate Bank Name, Bank Short Name, AddressLine1, AddressLine2, AddressLine3, AddressLine4 and City.

5.00.91 (31-Aug-2018)

Fixed error with form mishandling the bank accounts if the data was populated by the 'Assign Accounts' button.

5.00.90 (17-Aug-2018)

Fixed bug where address purpose flags would be cleared when updating site if the columns weren't on the sheet.

5.00.89 (15-Aug-2018)

When using BIC as a branch filter, a wildcard is now automatically added to the end of the BIC filter for simpler searching
Updated error handling in data entry forms.

5.00.88 (09-Aug-2018)

Disabled controls now have black text and can be selected (but not changes) for better visibility.
Branch Type and BIC are now always editable since they can be used as search filters.
Increased the width of the certain bank/branch LOV fields to display more information.

5.00.87 (08-Aug-2018)

Branch controls now display the City and Address Line 1 instead of the Branch Party Id.

5.00.86 (30-Jul-2018)

Slow download of site acc data for specific client.

5.00.85 (30-Jul-2018)

Slow download of site acc data for specific client.

5.00.84 (24-Jul-2018)

Fixed ‘object or with block variable not set’ error when trying to update a bank account when ‘Identify Bank’ was set to ‘Bank Number’.

5.00.83 (18-Jul-2018)

Fixed bug where inactive date site would be disabled when ‘Include Employee Types’ was active in the ribbon for employee type suppliers.

5.00.82 (16-Jul-2018)

Fixed bug where automatic Intermediary Accounts would cause an error due to outdated packages.

5.00.81 (09-Jul-2018)

Added a new checkbox ‘Allow Pop-Ups’ to the Login form to enable the users to block or unblock the popped-up dialog.

5.00.80 (06-Jul-2018)

Bank Account Start and End dates are no longer validated for chronological order when using [BLANK] to clear the end date.

5.00.79 (20-Jun-2018)

Fixed VBA error when loading a single intermediary account at Site Level.

5.00.78 (19-Jun-2018)

When creating an external bank account, 2 empty Intermediary Accounts will also be created (If there are none manually entered on the sheet).
Expected Behaviour: Create Ext Bank Account, no Intermediary Accounts on sheet - 2 empty Intermediary Account records will be automatically created.
Create Ext Bank Account, 1 Create Intermediary Account on sheet - 1 Empty Intermediary Account record will be automatically created.
Create Ext Bank Account, 2 Create Intermediary Accounts on sheet - no Empty Intermediary Account records will be automatically created.

5.00.77 (18-Jun-2018)

Fixed ‘single-row subquery returns more than one row’ error when validating bank accounts where external payees are associated with multiple sites.
When creating an intermediary account, the Wizard will now create an additional account with null values as per Oracle solution.

5.00.76 (23-May-2018)

Modified Intermediary Account download so that it is no longer limited to 1 account per assignment.
Fixed bug where Inactive Date could not be cleared using [BLANK] when changing the Address Status to Active simultaneously.

5.00.75 (14-May-2018)

Fixed bug where Log API Call would sometimes not populate the ‘More4Apps’ log sheet on faster computers.

5.00.74 (07-May-2018)

Renamed the ribbon button ‘Create Banks/Branches’ to ‘Manage Banks/Branches’ as it also allows you to update.

5.00.73 (01-May-2018)

Fixed bug where all dates entered by the date picker would be in American format.

5.00.72 (11-Apr-2018)

Operating Unit can now be used as a filter for "Download Via Sheet".

5.00.71 (06-Apr-2018)

Fix from 5.00.69 is now disabled for earlier versions of the Wizard package.

5.00.70 (05-Apr-2018)

Multi-org environments will now return results for all available organizations in List of Values and when searching and downloading.

5.00.69 (03-Apr-2018)

Payment schedule updates are now done post upload so the order of bank account updates on the spreadsheet does not matter.

5.00.68 (01-Mar-2018)

‘Downloader’ ribbon tab has been renamed to ‘Custom Query’ and upgraded.

5.00.67 (01-Mar-2018)

Updated security.

5.00.66 (23-Feb-2018)

Customer update.

5.00.65 (20-Feb-2018)

Removed duplicates from Bank LOVs (name, ID and number).

5.00.64 (19-Feb-2018)

Bank and Branch searches are now filtered by the BIC.
Added Branch Start and End Dates to the Wizard.

5.00.63 (12-Feb-2018)

Alternate Branch Name and EFT Number will now default when choosing a branch at supplier and site level.

5.00.62 (02-Feb-2018)

Updated logging procedures.

5.00.61 (01-Feb-2018)

Fixed bug where searching the incorrect text case in an LOV, then searching the correct case would not return any results.
Fixed bug where bank account assignments would be incorrectly marked invalid.

5.00.60 (21-Jan-2018)

Fixed an issue with formulas in the Default row.

5.00.59 (13-Dec-2017)

Fixed problem in Customize Fields form where global DFF column settings were not saved.
Fixed ‘could not copy custom logo’ error when creating a new sheet from the Customize Fields form.

5.00.58 (07-Dec-2017)

Bank Account Number, Branch Number and Employee Number now have wider LOV columns to prevent values being cut short.

5.00.57 (04-Dec-2017)

Fixed problem where not all global DFF attributes were showing on the ‘Customize Fields’ form.
Fixed bug where [BLANK] Dates would not be reported in the XML when using Approvals Logic.

5.00.56 (04-Dec-2017)

Customer update.

5.00.55 (17-Nov-2017)

Fixed issue where bank accounts would not download in multi-org environments when no operating unit was selected.

5.00.54 (13-Nov-2017)

Fixed issue where default values were not being validated correctly.

5.00.53 (10-Nov-2017)

Formulas in ‘Defaults’ row now copied down correctly to allow their use in the data. Cell references correctly maintained.

5.00.52 (09-Nov-2017)

Fixed problem where some flags could not be cleared using [BLANK] when using public APIs.

5.00.51 (07-Nov-2017)

Added new profile option ‘More4Apps: SW Update Branch Details’ to enable branch detail updates (Requires package body 2.1.09).

5.00.50 (31-Oct-2017)

Bank address details will now also default.

5.00.49 (25-Oct-2017)

Bank details will now default in the form, regardless of the ‘Create Banks/Branches’ setting.

5.00.48 (18-Sep-2017)

Approvals process is now profile option controlled for specific customer.
Fixed non-numeric value API error when creating the same bank multiple times for 1 site.
Added BIC, EFT Number and Branch Type fields to the supplier bank accounts form.

5.00.47 (13-Sep-2017)

Fixed inconsistent font sizes in the form controls.
Fixed error on download "single-row subquery returns more than one row" when a tax group has multiple lines.

5.00.46 (07-Sep-2017)

Customer update.

5.00.45 (05-Sep-2017)

Implemented the Downloader Ribbon tab.
Implemented Procurement Card field at Site level.

5.00.44 (05-Sep-2017)

Intermediary Bank Downloads are now limited to the first account per assignment as per customer request.

5.00.43 (04-Sep-2017)

Package Body 2.1.05 required - Added Phone Extension column at Supplier Contact and Contact level.

5.00.42 (29-Aug-2017)

Added new profile ‘More4Apps: SW Update Mode only’ which will remove ‘Create’ mode from the update modes LOV.

5.00.41 (28-Aug-2017)

Fixed bug where intermediary bank accounts would all display as the children of 1 bank account ID even though they should be spread across assignments.

5.00.40 (25-Aug-2017)

Fixed bug where Site Bank DFFs would download incorrectly when the same account was assigned to multiple sites across operating units.

5.00.39 (24-Aug-2017)

Fixed numeric conversion error when trying to create supplier and site bank simultaneously while identifying bank by name.

5.00.38 (23-Aug-2017)

Added Sec Acc Ref (Secondary Account Reference) as Supplier Bank and Site Bank level.

5.00.37 (22-Aug-2017)

Customer fix.

5.00.36 (14-Aug-2017)

Selecting a Branch in the edit form will now default the address details.

5.00.35 (14-Aug-2017)

Fixed problem where Site Intermediary Accounts would not download if related to sites from different operating units.

5.00.34 (07-Aug-2017)

Customer fix.

5.00.33 (03-Aug-2017)

Customer fix.

5.00.32 (03-Aug-2017)

Fixed bug where address purpose flags would not download.

5.00.31 (03-Aug-2017)

Customer fix.

5.00.30 (01-Aug-2017)

Fixed issue where the copied cell would be pasted into every blank cell when downloading.

5.00.29 (28-Jul-2017)

Customer fix.

5.00.28 (28-Jul-2017)

Fixed Error 5 when updating sites when ‘Purchasing – Address’, ‘Pay – Address’, ‘RFQ – Address’ are missing from the sheet.

5.00.27 (27-Jul-2017)

Address Purpose Flags can now be updated independently using the new columns: ‘Purchasing – Address’, ‘Pay – Address’, ‘RFQ – Address’.

5.00.26 (25-Jul-2017)

Customer fix.

5.00.25 (21-Jul-2017)

Fixed bug where DFF attributes would not appear if assign to multiple context.
Fixed issue with three level hierarchical DFF value set dependencies when the middle attribute (Parent, Child, Grandchild) has a default value.

5.00.24 (19-Jul-2017)

corrected issue with Site Global DFF assignments.

5.00.23 (19-Jul-2017)

Fixed problem where a dependent DFF would be marked invalid if it had a default value, even when the parent wasn't entered.

5.00.22 (17-Jul-2017)

Fixed issue where Site level Intermediary Accounts created in a different Operating Unit would not download.

5.00.21 (17-Jul-2017)

Fixed another issue with global DFFs in the edit form, should be the final cut.

5.00.20 (14-Jul-2017)

Fixed bug where registered global DFF attributes could not be updated via the Edit form.

5.00.19 (13-Jul-2017)

Fixed Supplier/Site context overwriting the Global DFF context.

5.00.18 (07-Jul-2017)

Fixed "Run-time error '457'” when uploading suppliers with global DFF attributes registered with the standard DFF.

5.00.17 (27-Jun-2017)

Improved the performance of validating bank details

5.00.16 (26-Jun-2017)

Customer fix.

5.00.15 (22-Jun-2017)

Enabled the ‘Address Name’ filter on the Download form.

5.00.14 (15-Jun-2017)

Fixed error when opening the Customize fields and corrected missing DFF Attribute controls.

5.00.13 (13-Jun-2017)

Added handling for Global DFF Localization attributes which are assigned to the standard DFF section.

5.00.12 (07-Jun-2017)

Updated Security.

5.00.11 (26-May-2017)

Fixed bug where searching for branch in the Download form would not return results if the associated Bank Number or Bank Name was null.

5.00.10 (26-May-2017)

Added an ‘Export Settings’ button to the ribbon which can be used to export template, custom column and mandatory settings to a new workbook.

5.00.09 (24-May-2017)

Finished fixing source bank from branch functionality.
Branch BIC will now default on the form when searching for Branch even if ‘Create Banks/Branches’ is not enabled.
Branch BIC is no longer used as search criteria when searching for Branches.

5.00.08 (23-May-2017)

Fixed bug where you could not load bank branches without bank details even when the branch was unique.

5.00.07 (22-May-2017)

Fixed bug where multiple suppliers could not have their ‘Taxpayer Id’ updated to [BLANK].

5.00.06 (22-May-2017)

Approval Workflow Settings are now controlled by profile options rather than the form. Profile Option User Names:
- More4Apps: SW Invoke Approval Process
- More4Apps: SW Invoke Approval Workflow
- More4Apps: SW Approval Workflow Process Name
- More4Apps: SW Approval Workflow Process Item type

5.00.05 (18-May-2017)

Added ability to create duplicate addresses using profile option ‘More4Apps: SW Allow Duplicate Addresses’.
Added Bank and Branch Address detail columns for Supplier and Site.

5.00.04 (12-May-2017)

Implemented Intermediary Bank Account sections for Supplier and Site.

5.00.03 (08-May-2017)

Intermediary Bank Acct details supported at Supplier and Site level.
Fixed download queries for Bank Account owners at Supplier/Site level(s).

5.00.02 (08-May-2017)

Updated Security.

5.00.01 (25-Apr-2017)

Updated Security.

4.03.10 (24-Apr-2017)

Fixed a bug where the check for [BLANK] token was checking existing sheet data for values that didn't exist because they are sourced by validation (sPartySiteId).

4.03.09 (13-Apr-2017)

Fixed a bug where the Supplier contacts section was causing an issue for Site creations (Update address API).

4.03.08 (10-Apr-2017)

Added column ‘Services Tolerance’ in Site section.

4.03.07 (29-Mar-2017)

Creation now allows [BLANK] token.

4.03.06 (29-Mar-2017)

Cleaned up ribbon separators.

4.03.05 (28-Mar-2017)

Approvals logic now made available to all customers.
New control on setup ribbon to control this (Sysadmin access only).

4.03.04 (21-Mar-2017)

Changed browser settings to suppress JavaScript errors during login.

4.03.03 (20-Mar-2017)

Updated Security.

4.03.02 (14-Mar-2017)

Fix error where Formulas are returning bad values and throwing exceptions when initialising the sheet data.

4.03.01 (13-Mar-2017)

Customer approval logic.
Requires Package Header version 2.1.01
Requires Package Body version 2.1.01

4.02.17 (23-Feb-2017)

Fixes the issues where users are being logged in with the wrong language and not able to select a language from the EBS Browser Login page. Overrides the language selected on the Login Page to the user's EBS preferences default language. Caused by an EBS 12.2 framework patch. Note – Loss of Functionality. This now means users cannot change languages if they want to.

4.02.16 (22-Feb-2017)

Updated Security.

4.02.14 (22-Feb-2017)

Allowed [BLANK] token for download form for those controls where it makes sense.

4.02.13 (08-Feb-2017)

Updated Security.

4.02.12 (07-Feb-2017)

Download Employee Sites was returning duplicate records for Orgs in different languages.

4.02.11 (27-Jan-2017)

Updated Security.

4.02.10 (25-Jan-2017)

New Setup Sheet.

4.02.09 (12-Jan-2017)

Prevent Site updates allowing the renaming of addresses to clash with already existing addresses.

4.02.08 (10-Jan-2017)

Enabled Org Contact DFF.

4.02.07 (10-Jan-2017)

Enhanced attribute 'Required' validation for child attributes.
A child is only required when:
- The required flag is set to yes.
- All of its immediate parents have a value.
Previously the validation was only checking: required flag is set to yes.

4.02.06 (06-Jan-2017)

Fixed some issues with the supplier contact bulk validation and create mode updates (when creating in-line with the supplier create).

4.02.05 (05-Jan-2017)

Supplier Contacts now support UPDATE and CREATE mode (including all relevant columns).
Added support for Inactive Date in Supplier Contact section.

4.02.04 (21-Dec-2016)

Added support for Alternate Name in Contact section.

4.02.03 (21-Dec-2016)

Added extra validation checks for Employee mode to ensure Employee Type suppliers can't be passed Enabled Customer data.

4.02.02 (19-Dec-2016)

Added support for Contact DFF.

4.02.01 (15-Dec-2016)

Added Support for 'Enable as Supplier' functionality via Customer/Org column which is valid for creations (rejected at update if it doesn't match the party id of the supplier).
Added Support for Party DFF at Supplier level.
Change made to Select Supplier Address to allow non-assigned addresses to be used.

4.01.12 (21-Nov-2016)

Fixed support for Sharing Sites amongst Operating Units.

4.01.11 (11-Nov-2016)

Added support for Alternate Address Name.

4.01.10 (11-Nov-2016)

Updated Security.

4.01.09 (11-Nov-2016)

Fixed bank account validations to handle no bank and/or no branch correctly.
Simplified bank validation query when not in auto-assign mode.

4.01.08 (02-Nov-2016)

Duplicate Supplier name - check at validation.

4.01.07 (28-Oct-2016)

Bank validation - external bank account already exists validation.
Attempt to address bank/branch joins which don't work correctly for when changing bank or branch settings.

4.01.06 (28-Oct-2016)

Operating Unit text too long to distinguish OpUnit names in some customer instances. Edit form control enlarged.

4.01.05 (20-Oct-2016)

Small fix for address context error where countries with ' in the text not handled correctly.

4.01.04 (18-Oct-2016)

Bank accounts can be created with no bank or branch details or both (if branch is provided bank is required).

4.01.03 (18-Oct-2016)

Added Address Name as download filter.

4.01.02 (10-Oct-2016)

Changes to Validation queries to boost performance.
Small fix for allowing existing DB Account Id to be BLANK in bank validation query.
Bank accounts can be assigned at Address & Address-Op Unit level (as well as Supplier/Site as previously available).

4.01.01 (05-Oct-2016)

Auto Assignment of bank account ownership can be switched on if required. Account Id must be provided so account must exist not be pending creation.

4.01.00 (30-Sep-2016)

Added control for auto-assignment of bank accounts.
Fix for DFF validation of table-based validation sets.

4.00.45 (23-Sep-2016)

Added Support for URL in Supplier section.
Renamed column in Contact Section (Contact URL).
Fix for Supplier BULK Validation query causing too much time.

4.00.44 (15-Sep-2016)

Fixed Download Supplier Bank Account query to exclude Address-linked accounts.

4.00.43 (05-Sep-2016)

Fixed Pre-Validation process query to ignore rows with no Supplier Number value.

4.00.42 (05-Sep-2016)

Updated Security.

4.00.41 (26-Aug-2016)

Customer Specific flexmap substitution for DFF.

4.00.40 (11-Aug-2016)

Fix to prevent Site.InactiveDate being incorrectly set by update_vendor_site_public API when reactivating an inactive site address.

4.00.39 (10-Aug-2016)

Further validation fix for site tax classification, due to issues with update_site_public API the column is dropped from the call if the value is not changed.

4.00.38 (09-Aug-2016)

Fixed validation for Tax Classification Site.

4.00.37 (05-Aug-2016)

Pre-Validation only performed for a supplier if there is at least one section pending upload.
Removed Operating Unit dependency from Site columns when non MO Responsibility used, since we can rely on the session Org Id - Site KFFs others.

4.00.36 (28-Jul-2016)

Address DFF added (defined as Receivables.Party Site Information in Oracle EBS).
Fixed a download issue with the vendor site code being ambiguously referenced.
Supplier ID can be defaulted from Supplier Number (switched by Profile Option M4APS_SW_ALLOW_DERIVE_SUPPLIER_ID).
For non MO Responsibilities the Site Operating unit will default on uploads.

4.00.35 (15-Jul-2016)

Updated Security.

4.00.34 (20-Jun-2016)

For customer DFF, Context is mandatory for creations.

4.00.33 (03-Jun-2016)

Customer validation changes.

4.00.32 (02-Jun-2016)

Updated Wizard password.

4.00.31 (27-May-2016)

To reduce impact for IBY_EXTERNAL_PAYEES_ALL table, unchanged values from that table are not passed to API (Site & Supplier Section). Switched on/off via profile option M4APS_SW_OMIT_IBY_IF_NO_CHG.

4.00.30 (26-May-2016)

Start/End date Assignment now handles [BLANK] token correctly.

4.00.29 (26-May-2016)

Start/End date Assignment support added for Bank account sections.

4.00.28 (25-May-2016)

Updates to bank accounts allow bank and branch to be changed.

4.00.27 (20-May-2016)

Site name max-length check was being skipped in Emp-mode.

4.00.26.7 (07-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.

4.00.26 (18-May-2016)

Inactive bank accounts can be reactivated now by setting the end-date to [BLANK] or a future date.

4.00.25 (16-May-2016)

Fix to ensure the Category List is correctly set for uploading ALL Attachments.

4.00.24 (13-May-2016)

Updates for customer.

4.00.23 (11-May-2016)

Reduced complexity of Site validation query.

4.00.22 (05-May-2016)

Fixed validation query for Employee Site bank accounts.
Requires Package Body 2.0.02

4.00.21 (05-May-2016)

Updates for customer.

4.00.20 (29-Apr-2016)

Default Employee -> Supplier Name employed in CREATE mode to default Employee Name into Supplier Name if not provided.

4.00.19 (28-Apr-2016)

Fix for [BLANK] token in Address fields which weren't being respected on updates.

4.00.18 (26-Apr-2016)

Simplified Site validation query for cases when columns are not present in the worksheet.

4.00.17 (12-Apr-2016)

Simplified the DB Validation query for Site when not in 'Include Employee Types' mode.

4.00.16 (07-Apr-2016)

Allow Profile Option to suppress contact message: 'More4Apps: SW Patch 18455207 - Suppress Warning'.

4.00.15 (04-Apr-2016)

Alternate Pay Site now handles [BLANK] token correctly.

4.00.14 (30-Mar-2016)

Added support for Site column: 'Alternate Pay Site' (ap_vendor_pub_pkg.r_vendor_site_rec_type.default_pay_site_id)

4.00.13 (23-Mar-2016)

Updated Security.

4.00.12 (17-Mar-2016)

Status bar message handling improved to always provide feedback during bulk uploads.

4.00.11 (14-Mar-2016)

Send large Supplier blocks (more than say 50 rows) individually rather than in the block of 10 (to stop timeouts etc.).

4.00.10 (18-Mar-2016)

Updated Security.

4.00.09 (18-Feb-2016)

Reduced the number of characters per parameter block.
Removes issue with uploads hitting operational limits.

4.00.08 (12-Feb-2016)

Added control to switch back to old _update APIs (instead of _public APIs).
Setup ribbon only (not on context menus or toolbars).

4.00.07 (09-Feb-2016)

Call validate_vendor_contact prior to Contact creations to get a serviceable message when the create fails.

4.00.06 (28-Jan-2016)

Fix for Site Bank account section to remove mandatory column setting for Bank Id column when 'Source Bank from Branch' is active.

4.00.05 (22-Jan-2016)

No-Action description recorded to Rejection Reason comment when the Supplier has previously been loaded.

4.00.04 (21-Jan-2016)

Download form filters fixed for 'To' dates which weren't being handled properly (trunc() added to sql query).

4.00.03 (08-Jan-2016)

Changes to ensure results and counts are reported cleanly to sheet and the use for bulk upload.

4.00.02 (22-Dec-2015)

Removed some uncached (Masked) Bank Account Validation queries which were running for each Acct Update.

4.00.01 (22-Dec-2015)

Performance Upgrade: APIs called in Bulk to reduce data traffic. Significant improvements delivered.
Trial Limit is now enforced by Supplier (not each section API as was erroneously the case before) Trial users will get to upload the 10 they expect.
Small fix for customer, validation not reflecting the right column in error colouring (StartDate DBValidation was colouring the EndDate col wrongly).
Requires Package Header and Body Version 2.0.01

3.03.33 (04-Jan-2016)

Fixed site validation query for Employee suppliers

3.03.32 (04-Jan-2016)

Fix for NULL value defaulted character handling

3.03.31 (22-Dec-2015)

Updated Security

3.03.30 (14-Dec-2015)

Changed procedure kffSegmentSQL.TableBasedLovSQL. Fixed bug that stopped where clause being added to queries in table based validation sets.

3.03.29 (30-Nov-2015)

Fixed download Supplier Contacts Query to reflect the situation when supp contacts are created by API

3.03.28 (27-Nov-2015)

Added code to fix Excel 2013 Bug where ribbon and new sheet issues were occurring

3.03.27 (26-Nov-2015)

Cleanup of erroneous formatting styles to restore compatibility with Excel 2007 and 2003

3.03.26 (26-Nov-2015)

Renamed control "Search Branch independently of Bank"/"Independent Branch Search" to "Source bank from branch".
New logic to allow bank to be sourced from branch name/number for validation and upload.
Fixed an issue where Account-Number Masks which matched other accounts were rejecting updates erroneously.

3.03.25 (24-Nov-2015)

Stopped Defaulting values being populated into empty sections

3.03.24 (24-Nov-2015)

Added Check on Upload for Patch level if Contact Columns are active and _PUBLIC API patch for bug 18455207 has not been applied.
Added SWDataAudit for future usage during webex support.

3.03.23 (20-Nov-2015)

Fix for ‘Method 'Paste' of object'_Worksheet' failed error when placing Logos on Template sheet

3.03.22 (13-Nov-2015)

Allowed BLANK_TOKEN End-dating of Bank Acct (Supplier/Site)

3.03.21 (12-Nov-2015)

Context Menu item recording.
Removed duplicate uncached queries for Supplier numbering method and New API Functions Flag from the init phase.

3.03.20 (11-Nov-2015)

Added validation rule to reject [BLANK] token for Bank account start dates due to API populating FND_API.G_NULL_DATE as 01-JAN-4712 (which is nonsense).
Added "*Unnamed account NN" as label for Select Bank Account window to allow users to select bank accounts easier when the accounts aren't named.

3.03.19 (05-Nov-2015)

Fix for Initializing state prior to upload to ExecuteState being used erroneously

3.03.18 (04-Nov-2015)

Separated CustomLogoText from Image and remove its visibility in newly created worksheets

3.03.17 (03-Nov-2015)

Default Logo positioned correctly on New Sheet

3.03.16 (03-Nov-2015)

Change to check allowing/rejecting duplicate tax id/number based on profile option (for pending uploads)

3.03.15 (02-Nov-2015)

Changes to preserve dimensions of logos when creating a new sheet from the template

3.03.14 (02-Nov-2015)

Added Bulk validation logic to bank ownership sections for performance improvements

3.03.13 (30-Oct-2015)

Added check to ensure Inactive dates are not set to the past (to reflect HTML forms)

3.03.12 (30-Oct-2015)

The User can now add a logo to the Template sheet with the label 'CustomLogo' and it will be used on all new sheets

3.03.11 (29-Oct-2015)

Added control to reorder the Forms controls by either Column Order or Alphabetic Order

3.03.10 (28-Oct-2015)

Fixed issue where DFF validation error prompts were occurring twice

3.03.09 (28-Oct-2015)

Added check for Duplicate Tax Id/Reg Number and Supplier Name to Bulk Validation at Supplier level

3.03.08 (27-Oct-2015)

Fix for where DefaultPaymentMethodSupplier subquery was returning multiple rows if there existed records with party_site_id and no supplier_site_id

3.03.07 (26-Oct-2015)

Refreshed Core to version 212

3.03.06 (23-Oct-2015)

Changes to Site APIs to always run update Address API in order to support Address Communications fields. Requires Package Body version 1.2.42

3.03.05 (22-Oct-2015)

Changes to allow customers licenses which have junk text to the right

3.03.04 (16-Oct-2015)

Retuning of Bank Account Queries for customer issue- had to resort to nested query to remove cartesian join

3.03.03 (15-Oct-2015)

Correction of Bank Account Queries for customer issue.
Fix for InitFirstLast which wasn't stopping adding child data beyond the limits of the Supplier SD range.
Fix for validation being skipped if site being created simultaneously with the Supplier.

3.03.02 (14-Oct-2015)

Added Support for Contact.Department

3.03.01 (13-Oct-2015)

Fix for issue where SupplierR12.ParentSupplierXXX columns are not present in the worksheet

3.03.00 (13-Oct-2015)

Validation of Uploads now done in Bulk (10 suppliers at a time) to reduce queries.
Controls with Buttons for Validation now handled in the bulk DB Validation logic for their section.

3.02.06 (03-Sep-2015)

Set check_digits on bank account details to TYPE_TXT, ContentMaxLength:=30
Allowed mixedcase in License key text for Custom localizations

3.02.05 (02-Sep-2015)

WIP Validation caching work begins

3.02.04 (01-Sep-2015)

Changed Logic for customer’s enhancement, calling both UPDATE and INSERT APIs together (in sequence) in Update Mode.
Added code from Non Caching version 3.02.05 which reflects customer’s start/end date requirements.

3.02.03 (21-Aug-2015)

Added check against More4AppsInstance for development/demos where the package state may have been dropped and the cache hasn't updated

3.02.02 (21-Aug-2015)

Fixed caching issues caused by multi-org. NB when retrieving from the cache it wasn’t respecting the structureID

3.02.01 (21-Aug-2015)

Extended Local Customizations Logic to support customer FLAP 1042 changes. Requires Package Body Version 1.2.41

3.01.12 (19-Aug-2015)

Fix for IsLocalCustomizationSectionColumn causing 'Invalid procedure call or argument' in ReturnResults

3.01.11 (18-Aug-2015)

Change for 3.01.09 introduced a bug for Site update.
Now pass all parms into pos_supplier_address_pkg.update_supplier_address but not into pos_supp_contact_pkg.update_supplier_contact.

3.01.10 (18-Aug-2015)

Added a form for Clear ID/Status columns to provide greater flexibility

3.01.09 (14-Aug-2015)

Fixed the Update Supplier Contact API call to pass parameters only when required to pos_supp_contact_pkg.update_supplier_contact.
Added Supplier Number to ID/Status columns to be cleared by button when auto numbering is enabled for Supplier Number.

3.01.08 (13-Aug-2015)

Clear ID/Status Columns control added

3.01.07 (05-Aug-2015)

Better handling for Create-only fields for Supplier/Site Bank Account sections - toggled by BankBranchCreateLogicActive

3.01.06 (30-Jul-2015)

Attempt2 - Imported new attachment modules for customer

3.01.05 (30-Jul-2015)

Imported new attachment modules for customer

3.01.04 (24-Jul-2015)

Added Bank Account Active/Inactive to the download criteria

3.01.03 (20-Jul-2015)

Added ContentMaxLength definitions for most Supplier and Site TYPE_TXT columns to remove Value/Numeric error if values entered are too long

3.01.02 (17-Jul-2015)

Restricted user ability to change the text of the [BLANK] control on the edit form

3.01.01 (01-Jul-2015)

Added Masked Bank Account Number control and changed download and upload process accordingly

3.00.10 (30-Jun-2015)

Requires Package Body Version 1.2.39 because of error sourcing Internal Party Id in previous package version.
Added new version of fndBlocklist.

3.00.09 (23-Jun-2015)

GetExistingSiteDetails returns the Party Location address descriptive details to keep in line with the downloader.
Download error for Site customer number (ambiguous column name) issue resolved.
Payment Details LOVs for Delivery Channel and Bank Instruction were incorrectly filtering Inactive dates.
Removed reference to SIW in Tooltip for KFF button.

3.00.08 (23-Jun-2015)

Edit for Site Select Supplier Address button now returns the Address Name along with the address details. This is to allow re-use of the whole data hierarchy when people create sites for different operating units which share the same address and contacts etc.

3.00.07 (18-Jun-2015)

Optional validation check for cells which contain Double-byte characters.
No non-latin or other special characters are permitted if RejectDoubleByteCharacters=TRUE.

3.00.06 (18-Jun-2015)

Final Support changes for _PUBLIC APIs
If at the appropriate patch level (ad_bugs 17575099 is installed) the Supplier Wizard will use the new _PUBLIC APIs:
AP_VENDOR_PUB_PKG.UPDATE_VENDOR_PUBLIC
AP_VENDOR_PUB_PKG.UPDATE_VENDOR_SITE_PUBLIC
AP_VENDOR_PUB_PKG.UPDATE_VENDOR_CONTACT_PUBLIC
Requires Package Body 1.2.38

3.00.05 (17-Jun-2015)

Remove erroneous testing setting

3.00.04 (17-Jun-2015)

Added Contact Support for URL, Alt Phone Number and Alt Phone Area Code

3.00.03 (17-Jun-2015)

If at the appropriate patch level (ad_bugs 17575099 is installed) the Supplier Wizard will use the new _PUBLIC APIs:
AP_VENDOR_PUB_PKG.UPDATE_VENDOR_PUBLIC
AP_VENDOR_PUB_PKG.UPDATE_VENDOR_SITE_PUBLIC
AP_VENDOR_PUB_PKG.UPDATE_VENDOR_CONTACT_PUBLIC

3.00.02 (15-Jun-2015)

Support for Supplier Contact Assignments

3.00.01 (11-Jun-2015)

Support for _PUBLIC APIs
UPDATE_VENDOR_PUBLIC tested and working
UPDATE_VENDOR_SITE_PUBLIC tested and working
UPDATE_VENDOR_CONTACT_PUBLIC (pending)

2.10.11 (09-Jun-2015)

Added support for new column Site.CustomerNumber

2.10.10 (02-Jun-2015)

Added Site.Name as a sheet download filter
Changed default row colours

2.10.09 (28-May-2015)

Fix allow BLANK_TOKEN for Supplier.MatchApprovalLevel

2.10.08 (08-May-2015)

Added Profile Option switch to turn on/off Duplicate Taxpayer Id check

2.10.07 (07-May-2015)

Removed validation check in SWBank.ValidateBankBranchForCreate.
Customers have commented that they should be allowed to create Branches with no Branch-Number.

2.10.06 (06-May-2015)

Added Bank Account to Download filters

2.10.05 (05-May-2015)

Fix for Template form (DFF fields were not populating on Accept)

2.10.04 (30-Apr-2015)

Added Profile Options and logic to restrict bank account functionality:
M4APS_SW_RESTRICT_BANK_ACCESS (More4Apps: SW Restrict Bank Account Access)
M4APS_SW_RESTRICT_BANK_CREATE (More4Apps: SW Restrict Bank/Branch Creation)
Logic added to turn off Bank Sections when More4Apps: SW Restrict Bank Account Access is set to True.
Logic added to turn off Bank Create logic when More4Apps: SW Restrict Bank/Branch Creation is set to True.

2.10.03 (23-Apr-2015)

Small fix for Edit form stopping update of a LOV if no control LOV value is selected (or return to forms after Select Button is pressed)

2.10.02 (23-Apr-2015)

Introduced new defaulting logic to package for UPDATE BANK API so increased the min Package Body Number. Requires Package Body version 1.2.34

2.10.01 (23-Apr-2015)

New Attachments Logic implemented.
Added 2nd 'Code' column to wide LOV ctls on form to allow users to see that when the 'Meaning' is ambiguous.

2.9.05 (17-Apr-2015)

Small fix for Download form (Bank Account Creation 'To')

2.9.04 (17-Apr-2015)

Added Bank Account Display Priorities at both Supplier and Site Bank Account level.
Note - Due to API peculiarities the user is advised to use sequential priorities without gaps, (e.g. 1,2,3 and NOT 10,20,30) otherwise the HTML form increase/decrease priority buttons don't work properly. Requires Package Body version 1.2.33

2.9.03 (16-Apr-2015)

Added Bank Account Dates to filters on Download form

2.9.02 (15-Apr-2015)

Local Customizations ready for customer. Requires Package Body version 1.2.32

2.9.01 (15-Apr-2015)

Changed DFF to support Translatable independent value sets

2.9.00 (10-Apr-2015)

Created Local Customizations Logic

2.8.01 (23-Mar-2015)

Reinstated the Site.RoundingRule column for both Supplier and Employee types.
Renamed Previously Existing Site.RoundingRule to Site.DftRoundingRule.
Renamed Site.RoundingLevel to Site.DftRoundingLevel.
Added validation rules around Taxpayer Id and Tax Registration Number.
Form rules for Emp Mode (Supplier and Site).
New Validation rules to allow Employees with Identical names to be processed correctly as unique suppliers.

2.8.00 (20-Mar-2015)

Global DFF enabled at Supplier and Site level
Requires Package Header version 1.0.11
Requires Package Body version 1.2.30

2.7.24 (06-Mar-2015)

Check_Resp_Allowed_Function now uses SWMain.GetMainMultiCall to cache Function access for efficiency reasons

2.7.23 (27-Jan-2015)

Allowing duplicate Banks to be created if the Name/Number combinations are unique

2.7.22 (20-Jan-2015)

[BLANK] DFF token now accepted

2.7.21 (14-Jan-2015)

Fixed the Defaults Values Tooltext comment

2.7.20 (17-Dec-2014)

Added Prepare_String() to Employee Check

2.7.19 (18-Nov-2014)

Refreshed Core to Version 210

2.7.18 (17-Nov-2014)

Bank Account filters now reported on entry form
Removed call to upload_download_limit which was failing on this version of the common code

2.7.17 (05-Nov-2014)

Site Bank Account form now allows search for bank/Branch to be filtered using Bank Institute type, Branch Type & BIC(=eft swift code)
Fix for Dutch language LOV (Notification Method)
Fix for MAX_COLUMNS in dutch Excel 2003

2.7.16 (07-Nov-2014)

Changed Ribbon label from 'Select Fields' to 'Customize Fields'
Removed Show/Hide Login info from right click mouse menu

2.7.15 (05-Nov-2014)

Supplier Bank Account form now allows search for bank/Branch can now be filtered using Bank Institute type, Branch Type & BIC(=eft swift code)

2.7.14 (05-Nov-2014)

Cell Upload Validation now reports Length errors at same time as Content errors Enhanced message for Caps Alphanumeric check

2.7.13 (24-Oct-2014)

Upgraded Core to version 209
grant to function AP_APXVDMVD_VIEW now allows downloads and validate-only uploads (but no ACTUAL Uploads)

2.7.12 (22-Oct-2014)

Employee Site Rounding Rule handled correctly
Changes made to package to accommodate AP_SUPPLIERS being updated correctly to match the ZX_PARTY_TAX_PROFILE values
Available in Package Body 1.2.27 (That version is required to allow this to function correctly but is not mandatory for all clients as the call signature has not changed)

2.7.11 (20-Oct-2014)

Fixed type comparison error for when Profile Option M4APS_SW_VALIDATE_ONLY=Y

2.7.10 (17-Oct-2014)

Refreshed Ribbon Core/Menu code and added calls to SWRibbon to ensure LOV arrays are initialised prior to accessing in _getText functions
Fixed Template Behaviour for Custom Column Headings

2.7.09 (15-Oct-2014)

Downloaded message reflects pluralization correctly
Mandatory Colours reflected in forms for Custom Mandatory fields

2.7.08 (15-Oct-2014)

fndBlockList update for Mastercard

2.7.07 (03-Oct-2014)

Support added for Remaining Payment Details Attributes at Site Level

2.7.06 (03-Oct-2014)

Support added for Remaining Payment Details Attributes at Supplier Level
Requires Package Header version 1.0.9
Requires Package Body version 1.2.25

2.7.05 (02-Oct-2014)

Fix for backward compatibility with Excel 2003 (formatting and ribbon)

2.7.04 (23-Sep-2014)

Business Classification Form - mandatory and LOV rules correctly reflected for Classification Type/Minority Type

2.7.03 (20-Sep-2014)

Backed out: Download sites filters out 'I'nactive Party sites (Non Emp Supplier type) Reason: Misunderstanding

2.7.02 (20-Sep-2014)

Fix for date defaulting to ensure format is correctly enforced
Download sites filters out 'Inactive' Party sites (Non Emp Supplier type)

2.7.01 (20-Sep-2014)

Added call to SWValidation.ProductPackageInstallationError() on uploads to check the package level is as expected by the current version of the Wizard
This should prevent upload PLSQL errors related to incorrect package level

2.7.00 (18-Sep-2014)

Business Classification section created. Download and Validation added
Requires Package Header version 1.0.9
Requires Package Body version 1.2.24

2.6.04 (06-Sep-2014)

Fix for download filter where Site Bank Account Owner was failing because there was no link to a Site (filtered out)

2.6.03 (02-Sep-2014)

Added Profile Options and logic to add extra validation rules
ENFORCE_AWT_GROUP_PROFILE_OPTION (More4Apps: SW AWT Group Name Mandatory)
ENFORCE_US_BANK_ROUTING_PROFILE_OPTION (More4Apps: SW Enforce US Bank Routing Number)

2.6.02 (28-Aug-2014)

Fixed Delete button behaviour in the Account Owner subfile

2.6.01 (27-Aug-2014)

Download Filters added to form and download filter for Sites/Banks respects them (form download only)

2.5.15 (22-Aug-2014)

Rounding Level Support added to Site level and fixed the Rounding Rule uploads/downloads

2.5.14 (20-Aug-2014)

Added Address Status to ColumnSettings123 sheet

2.5.13 (19-Aug-2014)

Added Update support for Address Status
Requires Package body 1.1.22

2.5.12 (19-Aug-2014)

Added Address Status as a downloadable column

2.5.11 (14-Aug-2014)

Dft and Company Tax registration Number are now updated via hz_party_v2pub.update_organization()
and not as part of the m4aps_supplierwizard2.set_zx_tax_detail process

2.5.10 (09-Aug-2014)

Allowed more than 256 columns to be defined in later versions than Office 2003

2.5.09 (09-Aug-2014)

Removed ambiguity between Set Inclusive Tax flag (created DftSetTaxInclusive column and SetTaxInclusive)

2.5.08 (08-Aug-2014)

Fixed Custom Profile 'M4APS_SW_VALIDATE_ONLY' as it had a trailing space in the description

2.5.07 (08-Aug-2014)

Site Set Tax Inclusive makes use of m4aps_supplierwizard2.set_zx_tax_detail function now (and in download is pulled from zx_party_tax_profile)
Small download DFF fix for first segment conversion

2.5.06 (06-Aug-2014)

Added Custom Profile 'M4APS_SW_VALIDATE_ONLY' to limit selected users to Validate Only Functionality

2.5.05 (30-Jul-2014)

Valid Contexts but 'No attributes enabled' for the DFF causing DFF to fail]. Error was [Error 9999 (fndEntityList.getDataArray encountered a runtime error at line 100) in procedure ValidateDFF of Class Module DFF]
Changed procedure DFF.SetDFFDetails. No data in FlexInfo entity list was causing this to blow.Added Central Error Handler
Changed procedure DFF.showForm. Added Central Error Handler. Set Entry Point True - too busy to fully implement
Changed procedure DFF.ValidateDFF. Added Central Error Handler. Set Entry Point True - too busy to fully implement
Changed procedure DFF.downloaddff. Added Central Error Handler. Set Entry Point True - too busy to fully implement
Changed procedure DFFForm.SizeControlArrays. stop subscript out of range error when no attributes

2.5.04 (29-Jul-2014)

EBS 12.2 fix Long_to_char for long_to_char sql errors caused by table based validation sets.
DFFmod.Search_Value_Set_ID sql updated for 12.2
DFF.ValueSetsSQL sql updated for 12.2

2.5.03 (29-Jul-2014)

Core code version 209 imported

2.5.02 (16-Jul-2014)

Fixed DFF site Context error when Context field not present in sheet
Removed erroneous WebtestDb calls when user is already logged in
Added Application.StatusBar messages to all calls to LoadXMLData

2.5.01 (15-Jul-2014)

Custom Headings and Custom Mandatory logic added
Template Form behaviour improved for Ref Column Insertion
Fix for Download Row Insertion formatting
Custom Template Controls enabled/disabled based on Section Activity
Inserted all Mandatory Columns into Sheet after creating a template

2.4.15 (04-Jul-2014)

Set all Supplier/Site ID parameters to TYPE_NUM to avoid errors when uploading with [BLANK]

2.4.14 (02-Jul-2014)

Fixed incorrect separators provided to Control.ColumnWidths

2.4.13 (25-Jun-2014)

Download Site DFF now works for all Org sites
Site Creation allows duplication of existing sites for new Operating Units

2.4.12 (19-Jun-2014)

Site Tax Classification fix (needs Package Header Version 1.0.8 and Body Version 1.1.20)

2.4.11 (11-Jun-2014)

Custom change to attAttachmentMod.UploadAllAttachments() to check the category index column exists before processing it
This will need to be rolled out into the common (Core) code

2.4.10 (17-May-2014)

Download in Employee mode allows the bank Instructions, Remittance details and default payment to download for site level

2.4.09 (08-May-2014)

Added Debug and trace options to setup menu (this includes the temp fix in fndXMLHTTP for case)

2.4.08 (08-Apr-2014)

Migrated to core code 205.32

2.4.07 (26-Mar-2014)

SiteR12.InvoiceTolerance [BLANK] now handled properly. (Requires Package Body 1.1.18)

2.4.06 (06-Mar-2014)

Fixed a reporting error for DFF Status columns if missing

2.4.05 (05-Mar-2014)

Removed Mandatory nature of the Bank Account Name

2.4.04 (18-Feb-2014)

Bills Payable and Distribution Set support deployed at site level.
Defaults support on Row 10 added (Note - You cannot default an Attachment Section column)
Download Filters added (Supplier Type, Distribution Set, Payment method, Pay Group)

2.4.03 (11-Feb-2014)

Fixed a download bug in Site bank Account Owner which was causing multi org filters to fail in the form

2.4.02 (06-Feb-2014)

New Supplier and Site Level columns supported: Delivery Channel, Bank Instructions1, Bank Instructions2 and Bank Instruction Details
(Requires package body version 1.1.17)

2.4.01 (05-Feb-2014)

Attachments enabled (Supplier and Site levels)

2.3.01.3 (17-Nov-2014)

Fix for handling long columns in EBS 12.1

2.3.01.2 (29-Jul-2014)

Fix for Descriptive Flexfield for 12.2

2.3.01 (24-Jan-2014)

Imported Current Core code (205.27) and Core/Menu code

2.3.00 (23-Jan-2014)

Rebuilt template sheet to match documentation

2.2.58 (21-Jan-2014)

Fixed Reference columns insert for Supplier/Site Bank Account Owners for creating template sheet with Select Fields form Fixed Edit-form error on account owner subfile-record where form events weren’t being correctly referenced so controls didn’t work

2.2.57 (17-Jan-2014)

Imported Current Core code (205.24) for 30kb limit issue in 11i

2.2.56 (13-Dec-2013)

Fixed Bank Account DFF download and Bank Account Owner download Fixed Job Title Download error (take value from hz_org_contacts now, not hz_parties) Added catch validation to reject attempts to change an existing site’s Operating Unit

2.2.55 (12-Dec-2013)

Fixed download query for Employee Supplier Bank Accounts

2.2.54 (11-Dec-2013)

Site Name form control LOV switched off/on by Vendor Type and Mandatory colors handled

2.2.53 (05-Dec-2013)

Removed Debug.Assert statements for client Major rework for handling the Minority Owned/Small Business/Woman Owned flags which the API doesn’t correctly update

2.2.52 (04-Dec-2013)

Used IgnoreListForComboBox() to stop substitution of empty SiteName for non-employee type suppliers

2.2.51 (03-Dec-2013)

Relaxed validation on Auto-Create-Bank account to allow blank Bank Number

2.2.50 (02-Dec-2013)

BacktraceSetting option created for error logging within db package

2.2.49 (02-Dec-2013)

Fixed spelling of Installation on the About tooltip on the Ribbon

2.2.48 (14-Nov-2013)

Posted INVALID to Status Column when DFF validation fails Employee Name/Supplier Name mandatory colours handled correctly in Edit forms Fixed small bug with forms (checking Supplier Type) Added retry to Settings123

2.2.47 (13-Nov-2013)

Site Country Mandatory Colour correctly handled in edit forms

2.2.46 (08-Nov-2013)

Site download fields matched up with Employee Site restrictions

2.2.45 (05-Nov-2013)

Added further logic around Site Tax rules and corrected site download

2.2.44 (01-Nov-2013)

Supplier Tax Classification now solely sourced from ZX TAX PROFILE tables Validation added for preventing attempts to change Supplier Name for Existing Emp Type Suppliers

2.2.43 (30-Oct-2013)

Fixed download of suppliers where dft country was not present against the tax profile Employee type validation corrected to force Employee Name to be provided

2.2.42 (29-Oct-2013)

New Columns added: Supplier Dft Tax Reporting Country Site Dft Tax Reporting Country Site Dft Tax Registration Type Site Dft Tax Registration Number

2.2.41 (25-Oct-2013)

Generic Code Refresh (v205)

2.2.40 (25-Oct-2013)

Changed Employee LOVs and revamped the Employee Validations

2.2.39 (24-Oct-2013)

Removed Employees which are not Current (current_employee_flag = ‘Y’) from LOVs

2.2.38 (23-Oct-2013)

Removed reference to European characters when defining ColumnsWidth property on forms controls

2.2.37 (21-Oct-2013)

Employee Supplier types now allowed “pt” is dropped and”;” is replaced with Application.International(xlRowSeparator)

2.2.36 (16-Oct-2013)

Small fix for OU Unit getting set to 0 in kffLocal.PrepareLocalOUSettings

2.2.35 (20-Sep-2013)

Fix for bug introduced in 2.2.26. vs.contextName was not being set. Hence attributes were not being validated because context was not set.Hence ConvertedValues were not being set in the validationSet. So, no values would upload for NON-GLOBAL Data elements. This only affected Site address DFF>

2.2.34 (30-Aug-2013)

Fixed reference to ce_bank_branches_v.branch_name (should have been bank_branch_name)

2.2.33 (28-Aug-2013)

DFF context now passed by name and translated to code for upload and download because of 30char limit on APIs

2.2.32 (23-Jul-2013)

Download form filters out Employees

2.2.31 (15-Jul-2013)

Fixed a bug with the Bank Account Assignment button at site level where the query was blank and causing an XML error

2.2.30 (04-Jul-2013)

PAY_AWT_GROUP_ID field was missing from AP_SUPPLIER_SITES_ALL for some patch levels. So this field is tested prior to inclusion now

2.2.29 (04-Jul-2013)

Allowed Inactive Suppliers/Sites to be validated at Bank Owner Level so these records can be post-date inactivated

2.2.28 (26-Jun-2013)

Tax_Payer_Id field was missing from CE_BANKS_V for some patch levels. So this field is tested prior to inclusion now

2.2.27 (07-Jun-2013)

Fix to Upload to remove risk of potential duplicate API calls due to non initialisation of p_StateBlock

2.2.26 (31-May-2013)

Fix for Site Address DFF not showing any attributes when form is opened Also affected the Site Address DFF upload validation. Default context was being set to ContextCode instead of ContextName The bug only makes its presence felt when context code and name are different

2.2.25 (02-May-2013)

Alternate Acc Name added to Supplier and Site Account sections

2.2.24 (18-Apr-2013)

Ship-to and Bill-to Locations passed to Upload Parms as TYPE_NUM datatyped parameters

2.2.23 (12-Apr-2013)

Change to Site ShipTolocation and BillToLocation sourcing on Download query

2.2.22 (11-Mar-2013)

EDI ID Number and EDI Location support added at Site level

2.2.21 (05-Mar-2013)

Bank Account Assignment form selection button works now for Sites Accounts when the site has not yet been created

2.2.20 (01-Mar-2013)

Site Addressee support added

2.2.19 (27-Feb-2013)

Tax Reference field handled correctly now

2.2.18 (30-Jan-2013)

Changes for ribbon labels and preliminaries for Bank/Branch auto-creation Supplier and Site 1-1 tax classification and registration fields/flags enabled Added Site alternate Name Banks and Branches can now be created on the fly according to a setting Download now will exclude Employees Site Accounts with Status ‘Create’ can be switched to ‘Assign’ in the correct circumstances at upload time Income Tax Reporting Site now supported at site level Added support for SiteR12.Rounding Rule Added DFF support at Bank Account levels

2.2.08 (13-Sep-2012)

Match Approval Level added to Supplier Section Fix for Creating Sites for existing addresses, now will preserve the link (previously it was creating a new address location) Added check for Servlet Version when doing Multi-Org site updates Ribbon Controls Implemented SSO Bypass enabled Added the button and functionality for “Search Branch independently of Bank” Changed PAY_GROUP LOV to display MEANING rather than DESCRIPTION New filter: Download filtered by Operating Unit Default Payment method corrections

2.1.55 (09-Jul-2012)

Supplier Sites now Multi Org for upload Multi-Org can now be handled in one upload/download via a Setup-toolbar dropdown option. Added Download filter checkbox which allows restriction of suppliers available for download to those with Sites for the current Operating Unit(s) Download Supplier – query performance enhancements. Supplier id <-> Supplier Number Validation added for update mode Download Site – query performance enhancements Download-form Overflow problem removed Operating Unit Verified for Ship-To-location, Ship-Via and Liability/Prepayment KFF account fields. Taxpayer-Id added as a download filter on the down load form. Download-via-sheet functionality added. (4 filters available: Supplier Name, Supplier Number, Supplier Id, Taxpayer Id Download form widened to allow larger Supplier Numbers (up to 10 digits) Income Tax Type added to Supplier Section

2.1.41 (12-May-2012)

Create new sheet directly from Template Form Branch Name added as key identifier on Bank Account maintenance

2.1.25 (05-Dec-2011)

Includes several new fields (Notification Method & related fields, Pay On, Default Payment Method, Prepayment Account KFF, Pay Each Document Alone, Primary Pay Site) Updated common code Restricted balancing segment LOV/validation by setting the ledger Enabled (BLANK) functionality to set fields back to Null

2.1.10 (21-Sep-2011)

Enhanced to enable bank details (bank-branch-account combinations) to be created & updated against Suppliers and Supplier Sites. The Liability Account field is also now available against Supplier Sites

2.0.0 (13-Apr-2011)

First release of Supplier Wizard for Release 12+ of Oracle E-Business Suite