ESS Jobs Template

Version 1.32 (15-Jun-2020)

- Baseline

 

Version 1.33 (05-Jul-2020)

- Performance improvement

 

Version 1.33 (12-Jul-2020)

- Changed toolbar look and feel

- Changed toolbar option User Setup to User Preferences

 

Version 1.34 (27-Jul-2020)

- Lookup compatibility with Office 2019

 

Version 1.35 (23-Aug-2020)

- Improved SSO login

- SSO login: Retains session across multiple Simplified Loader templates

 

Version 1.36 (10-Sep-2020)

- Minor bug fixes

 

Version 1.37 (27-Sep-2020)

- Added the Help menu with hyperlinks to online user manuals.

 

Version 1.38 (12-Oct-2020)

- Added help notes for Trial templates.

 

Version 1.39 (20-Oct-2020)

- Updates to support 20D update. Customers upgrading to this version (or later) will need to follow the steps below
a. Delete existing BI reports. Take backup of customisations in BI Reports.
b. Recreate BI reports
c. Restore customisations.

- Changed preference format to match preference format used for mobile apps i.e. use [] instead of :

 

Version 1.40 (19-Nov-2020)

- Bug fixes in Mandatory check and Force Default functionality

 

Version 1.41 (09-Dec-2020)

- Enhanced Lookups functionality from Sheet based data selection to Forms based data selection.

 

Version 1.42 (24-Dec-2020)

- Changed Lookup from fixed format to flexible format based on Lookup SQL.

- Populate value Unspecified if parent value don't exist.

 

Version 1.43 (26-Dec-2020)

- Minor bug fixes in Lookups functionality

 

Version 1.44 (29-Dec-2020)

- Ability to define standalone setup for Mandatory or Force Default features

 

Version 1.45 (11-Feb-2021)

- Ability to setup for Mandatory fields independent of Force Default values

 

Version 1.46 (31-Mar-2021)

- Introduced progress bar

- Introduced auto-scroll as when multiple records are selected

 

Version 1.47 (05-Apr-2021)

- Provision to add custom message with 'LatestVersion' preference

- Added preference: PreventOperations

 

Version 1.48 (15-May-2021)

- Update for Release 21b

 

Version 1.49 (08-Jun-2021)

- Minor bug fixes

 

Version 1.50 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.51 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.52 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.53 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 1.54 (26-Apr-2022)

- Minor bug fixes

 

Version 1.55 (02-May-2022)

- Lookups data access security

 

Version 1.56 (10-May-2022)

- Support for 22A

 

Version 1.57 (17-May-2022)

- Support for 22B

 

Version 1.58 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.59 (13-Jun-2022)

- Data download performance improvements

 

Version 1.60 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.61 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.62 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.63 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.64 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.65 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.66 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.67 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.68 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.69 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.70 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.71 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.72 (14-Jun-2023)

-Improved error messages

 

Version 1.73 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 1.74 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.75 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.76 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.77 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 1.78 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.79 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

Version 1.80 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.81 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.82 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Lookups Template

Version 1.00 (21-Jun-2022)

- First release

 

Version 1.01 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.02 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.03 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.04 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.05 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.06 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.07 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.08 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.09 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.10 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.11 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.12 (14-Jun-2023)

-Improved error messages

 

Version 1.13 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 1.14 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.15 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.16 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.17 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 1.18 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.19 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

Version 1.20 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.21 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.22 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Users and Roles Template

Version 1.01 (30-May-2022)

- First release

 

Version 1.02 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.03 (13-Jun-2022)

- Data download performance improvements

 

Version 1.04 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.05 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.06 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.07 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.08 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.09 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.10 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.11 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.12 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.13 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.14 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.15 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.17 (14-Jun-2023)

-Improved error messages

 

Version 1.18 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 1.19 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.20 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.21 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.22 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 1.23 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.24 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

Version 1.25 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.26 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.27 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Enterprise Contract Template

Version 1.91 (15-Jun-2020)

- Baseline

 

Version 1.92 (05-Jul-2020)

- Performance improvement

 

Version 1.93 (12-Jul-2020)

- Changed toolbar look and feel

- Changed toolbar option User Setup to User Preferences

 

Version 1.94 (27-Jul-2020)

- Lookup compatibility with Office 2019

 

Version 1.95 (23-Aug-2020)

- Improved SSO login

- SSO login: Retains session across multiple Simplified Loader templates

 

Version 1.96 (10-Sep-2020)

- Minor bug fixes

 

Version 1.97 (27-Sep-2020)

- Added the Help menu with hyperlinks to online user manuals.

 

Version 1.98 (12-Oct-2020)

- Updates to support 20D update. Customers upgrading to this version (or later) will need to follow the steps below
a. Delete existing BI reports. Take backup of customisations in BI Reports.
b. Recreate BI reports
c. Restore customisations.

 

- Added help notes for Trial templates.

- Changed preference format to match preference format used for mobile apps i.e. use [] instead of :

 

Version 1.99 (19-Nov-2020)

- Bug fixes in Mandatory check and Force Default functionality

 

Version 2.00 (09-Dec-2020)

- Enhanced Lookups functionality from Sheet based data selection to Forms based data selection.

 

Version 2.01 (24-Dec-2020)

- Changed Lookup from fixed format to flexible format based on Lookup SQL.

- Populate value Unspecified if parent value don't exist.

 

Version 2.04 (26-Dec-2020)

- Minor bug fixes in Lookups functionality

 

Version 2.05 (29-Dec-2020)

- Ability to define standalone setup for Mandatory or Force Default features

 

Version 2.06 (11-Feb-2021)

- Ability to setup for Mandatory fields independent of Force Default values

 

Version 2.07 (31-Mar-2021)

- Introduced progress bar

- Introduced auto-scroll as when multiple records are selected

 

Version 2.08 (05-Apr-2021)

- Provision to add custom message with 'LatestVersion' preference

- Added preference: PreventOperations

 

Version 2.09 (15-May-2021)

- Update for Release 21b

 

Version 2.10 (08-Jun-2021)

- Minor bug fixes

 

Version 2.11 (24-Jun-2021)

- Data change to accommodate 21b updates

 

Version 2.12 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 2.13 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 2.14 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 2.15 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 2.16 (26-Apr-2022)

- Minor bug fixes

 

Version 2.17 (02-May-2022)

- Lookups data access security

 

Version 2.18 (10-May-2022)

- Support for 22A

 

Version 2.19 (16-May-2022)

- Built DFF functionality

 

Version 2.20 (16-May-2022)

- Added Amend Contract and Approve Contract operations

 

Version 2.21 (17-May-2022)

- Automated data download for DFFs

 

Version 2.22 (17-May-2022)

- Support for 22B

 

Version 2.23 (11-Jun-2022)

- Support hierarchical data download

 

Version 2.24 (13-Jun-2022)

- Data download performance improvements

 

Version 2.25 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 2.26, 2.27, 2.28, 2.29 (15-Jul-2022)

- Major update in download functionlaity.

 

Version 2.30 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 2.31 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 2.32 (07-Dec-2022)

- Support for Chinese characters.

 

Version 2.33 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 2.34 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 2.35 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 2.36 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 2.37 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 2.38 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 2.39 (25-Apr-2023)

- Minor bug fixes.

 

Version 2.40 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 2.43 (14-Jun-2023)

-Improved error messages

 

Version 2.44 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 2.45 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 2.46 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 2.47 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 2.48 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 2.49 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 2.50 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

Version 2.51 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 2.52 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 2.53 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Payable Invoice Template

Version 1.40 (15-Jun-2020)

- Baseline

 

Version 1.41 (25-Jun-2020)

- Added menu options to Calculate Tax, Validate Invoice, Cancel Invoice, and Cancel Invoice Lines

- Added framework to support Attachments

 

Version 1.42 (29-Jun-2020)

- Introduced operation: Get AP Invoice

 

Version 1.43 (05-Jul-2020)

- Performance improvement

 

Version 1.44 (12-Jul-2020)

- Changed toolbar look and feel

- Changed toolbar option User Setup to User Preferences

 

Version 1.45 (27-Jul-2020)

- Lookup compatibility with Office 2019

 

Version 1.46 (23-Aug-2020)

- Improved SSO login

- SSO login: Retains session across multiple Simplified Loader templates

 

Version 1.47 (10-Sep-2020)

- Minor bug fixes

 

Version 1.48 (27-Sep-2020)

- Added the Help menu with hyperlinks to online user manuals.

 

Version 1.49 (12-Oct-2020)

- Added help notes for Trial templates.

 

Version 1.50 (20-Oct-2020)

- Updates to support 20D update. Customers upgrading to this version (or later) will need to follow the steps below
a. Delete existing BI reports. Take backup of customisations in BI Reports.
b. Recreate BI reports
c. Restore customisations.

 

- Changed preference format to match preference format used for mobile apps i.e. use [] instead of :

 

Version 1.51 (19-Nov-2020)

- Bug fixes in Mandatory check and Force Default functionality

 

Version 1.52 (09-Dec-2020)

- Enhanced Lookups functionality from Sheet based data selection to Forms based data selection.

 

Version 1.53 (24-Dec-2020)

- Changed Lookup from fixed format to flexible format based on Lookup SQL.

- Populate value Unspecified if parent value don't exist.

 

Version 1.54 (24-Dec-2020)

- Minor bug fixes

 

Version 1.55 (26-Dec-2020)

- Minor bug fixes in Lookups functionality

 

Version 1.56 (29-Dec-2020)

- Minor bug fixes

 

Version 1.57 (11-Feb-2021)

- Ability to setup for Mandatory fields independent of Force Default values

 

Version 1.58 (04-Mar-2021)

- Corrected column definition for Cancelled Flag

 

Version 1.59 (11-Mar-2021)

- Minor bug fixes

 

Version 1.60 (31-Mar-2021)

- Introduced progress bar

- Introduced auto-scroll as when multiple records are selected

 

Version 1.61 (05-Apr-2021)

- Provision to add custom message with 'LatestVersion' preference

- Added preference: PreventOperations

 

Version 1.62 (15-May-2021)

- Update for Release 21b

 

Version 1.63 (08-Jun-2021)

- Minor bug fixes

 

Version 1.64 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.65 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.66 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.67 (22-Feb-2022)

- Introduced lookups for Distribution Set and Tax Classifications

 

Version 1.68 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 1.69 (07-Mar-2022)

- Changed column sequence

 

Version 1.70 (09-Mar-2022)

- Renamed column Attachment File Name to Attachment File

 

Version 1.71 (26-Apr-2022)

- Minor bug fixes

 

Version 1.72 (02-May-2022)

- Lookups data access security

 

Version 1.73 (10-May-2022)

- Support for 22A

 

Version 1.74 (17-May-2022)

- Support for 22B

 

Version 1.75 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.76 (13-Jun-2022)

- Data download performance improvements

 

Version 1.77 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.78 (15-Jul-2022)

- Minor bug fixes.

 

Version 1.79 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.80 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.81 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.82 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.83 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.84 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.85 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.86 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.87 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.88 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.89 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.93 (14-Jun-2023)

-Improved error messages

 

Version 1.94 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 1.95 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.96 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.97 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.98 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 1.99 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 2.00 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 2.01 (13-May-2024)

-Support to access templates on shared PC.

 

Version 2.02 (16-May-2024)

-Fix username containing single quote.

 

Version 2.03 (24-May-2024)

-Support for login using IDCS.

 

Version 2.04 (11-Aug-2024)

-Additional fields to display PO details.

 

Version 2.05 (14-Aug-2024)

-Additional fields to display PO details.

 

Version 2.06 (16-Aug-2024)

-Added operations Add Invoice Line, Add Invoice Distribution, Update Invoice Line, Update Invoice Distribution, Delete Invoice Line, and Delete Invoice Distribution.

 

Version 2.07 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 2.08 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

External Cash Template

Version 1.28 (15-Jun-2020)

- Baseline

 

Version 1.29 (05-Jul-2020)

- Performance improvement

 

Version 1.30 (12-Jul-2020)

- Changed toolbar look and feel

- Changed toolbar option User Setup to User Preferences

 

Version 1.31 (27-Jul-2020)

- Lookup compatibility with Office 2019

 

Version 1.32 (23-Aug-2020)

- Improved SSO login

- SSO login: Retains session across multiple Simplified Loader templates

 

Version 1.33 (10-Sep-2020)

- Minor bug fixes

 

Version 1.34 (27-Sep-2020)

- Added the Help menu with hyperlinks to online user manuals.

 

Version 1.35 (12-Oct-2020)

- Added help notes for Trial templates.

 

Version 1.36 (20-Oct-2020)

- Updates to support 20D update. Customers upgrading to this version (or later) will need to follow the steps below
a. Delete existing BI reports. Take backup of customisations in BI Reports.
b. Recreate BI reports
c. Restore customisations.

 

- Changed preference format to match preference format used for mobile apps i.e. use [] instead of :

 

Version 1.36 (19-Nov-2020)

- Bug fixes in Mandatory check and Force Default functionality

 

Version 1.37 (09-Dec-2020)

- Enhanced Lookups functionality from Sheet based data selection to Forms based data selection.

 

Version 1.39 (24-Dec-2020)

- Changed Lookup from fixed format to flexible format based on Lookup SQL.

- Populate value Unspecified if parent value don't exist.

 

Version 1.40 (26-Dec-2020)

- Minor bug fixes in Lookups functionality

 

Version 1.41 (29-Dec-2020)

- Ability to define standalone setup for Mandatory or Force Default features

 

Version 1.42 (11-Feb-2021)

- Ability to setup for Mandatory fields independent of Force Default values

 

Version 1.43 (31-Mar-2021)

- Introduced progress bar

- Introduced auto-scroll as when multiple records are selected

 

Version 1.44 (05-Apr-2021)

- Provision to add custom message with 'LatestVersion' preference

- Added preference: PreventOperations

 

Version 1.45 (15-May-2021)

- Update for Release 21b

 

Version 1.46 (08-Jun-2021)

- Minor bug fixes

 

Version 1.47 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.48 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.49 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.50 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 1.51 (26-Apr-2022)

- Minor bug fixes

 

Version 1.52 (02-May-2022)

- Lookups data access security

 

Version 1.53 (10-May-2022)

- Support for 22A

 

Version 1.54 (17-May-2022)

- Support for 22B

 

Version 1.55 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.56 (13-Jun-2022)

- Data download performance improvements

 

Version 1.57 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.58 (15-Jul-2022)

- Minor bug fixes.

 

Version 1.59 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.60 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.61 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.62 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.63 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.64 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.65 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.66 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.67 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.68 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.69 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.7 (14-Jun-2023)

-Improved error messages

 

Version 1.71 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 1.72 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.73 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.74 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.75 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 1.76 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.77 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 1.78 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.79 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.80 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Receivable Invoices Template

Version 1.06 (06-May-2021)

- Baseline

 

Version 1.07 (15-May-2021)

- Update for Release 21b

 

Version 1.08 (08-Jun-2021)

- Minor bug fixes

 

Version 1.09 (17-Jun-2021)

- Added test data

 

Version 1.10 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.11 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.12 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.13 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

Version 1.14 (26-Apr-2022)

 

- Minor bug fixes

 

Version 1.15 (02-May-2022)

- Lookups data access security

 

Version 1.16 (10-May-2022)

- Support for 22A

 

Version 1.17 (17-May-2022)

- Support for 22B

 

Version 1.18 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.19 (13-Jun-2022)

- Data download performance improvements

 

Version 1.20 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.21 (15-Jul-2022)

- Minor bug fixes.

 

Version 1.22 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.23 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.24 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.25 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.26 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.27 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.28 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.29 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.30 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.31 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.32 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.34 (14-Jun-2023)

-Improved error messages

 

Version 1.35 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 1.36 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.37 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.38 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.39 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 1.40 (02-Jan-2024)

-Improvements when downloading data.

 

Version 1.41 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

 

Version 1.42 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

Version 1.43 (05-Apr-2024)

-Added sample data.

 

Version 1.44 (06-May-2024)

-Added Credit Memo operations.

 

Version 1.45 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.46 (06-Sep-2024)

-Added operation to apply or unapply Invoice to On Account Credit Memo.

 

Version 1.47 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.48 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Receivable Receipts Template

Version 1.02 (07-Jun-2021)

- Baseline

 

Version 1.03 (25-Jun-2021)

- Added operation to download Invoice

 

Version 1.04 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.05 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.06 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.07 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 1.08 (26-Apr-2022)

- Minor bug fixes

 

Version 1.09 (02-May-2022)

- Lookups data access security

 

Version 1.10 (10-May-2022)

- Support for 22A

 

Version 1.11 (17-May-2022)

- Support for 22B

 

Version 1.12 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.13 (13-Jun-2022)

- Data download performance improvements

 

Version 1.14 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.15 (15-Jul-2022)

- Minor bug fixes.

 

Version 1.16 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.17 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.18 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.19 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.20 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.21 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.22 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.23 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.24 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.25 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.26 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.27 (14-Jun-2023)

-Improved error messages

 

Version 1.28 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 1.29 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.30 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.31 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.32 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 1.33 (06-Feb-2024)

-Improvements when downloading data.

 

Version 1.34 (05-Mar-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.35 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 1.36 (14-Apr-2024)

-Added Receipt Application functionality.

 

Version 1.37 (17-Apr-2024)

-Added sample data for Receipt Application functionality.

 

Version 1.38 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.39 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.40 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Customer Template

 

Version 1.01 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.02 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.03 (20-Dec-2023)

-Introduced new function SL_Vlookup

-Introduced support to set NULL values for a field.

 

Version 1.04 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.05 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 1.06 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.07 (18-Jul-2024)

-Bug fixes in the download functionality.

 

Version 1.08 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.09 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Fixed Assets Template

Version 1.03 (01-May-2021)

- Baseline

 

Version 1.04 (15-May-2021)

- Update for Release 21b

 

Version 1.05 (08-Jun-2021)

- Minor bug fixes

 

Version 1.06 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.07 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.08 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.09 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 1.10 (26-Apr-2022)

- Minor bug fixes

 

Version 1.11 (02-May-2022)

- Lookups data access security

 

Version 1.12 (10-May-2022)

- Support for 22A

 

Version 1.13 (17-May-2022)

- Support for 22B

 

Version 1.14 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.15 (13-Jun-2022)

- Data download performance improvements

 

Version 1.16 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.17 (15-Jul-2022)

- Minor bug fixes.

 

Version 1.18 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.19 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.20 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.21 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.22 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.23 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.24 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.25 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.26 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.27 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.28 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.29 (14-Jun-2023)

-Improved error messages

 

Version 1.30 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 1.31 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.32 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.33 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.34 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 1.35 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.36 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 1.37 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.38 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.39 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

GL Journal Template

Version 1.04 (27-Jul-2020)

- Baseline

 

Version 1.05 (23-Aug-2020)

- Improved SSO login

- SSO login: Retains session across multiple Simplified Loader templates

 

Version 1.06 (10-Sep-2020)

- Minor bug fixes

 

Version 1.07 (27-Sep-2020)

- Added the Help menu with hyperlinks to online user manuals.

 

Version 1.08 (12-Oct-2020)

- Added support to validate segment values against CVR rules.

 

Version 1.09 (12-Oct-2020)

- Updates to support 20D update. Customers upgrading to this version (or later) will need to follow the steps below
a. Delete existing BI reports. Take backup of customisations in BI Reports.
b. Recreate BI reports
c. Restore customisations.

 

- Added help notes for Trial templates.

- Changed preference format to match preference format used for mobile apps i.e. use [] instead of :

 

Version 1.10 (19-Nov-2020)

- Bug fixes in Mandatory check and Force Default functionality

 

Version 1.11 (09-Dec-2020)

- Enhanced Lookups functionality from Sheet based data selection to Forms based data selection.

 

Version 1.12 (24-Dec-2020)

- Changed Lookup from fixed format to flexible format based on Lookup SQL.

- Populate value Unspecified if parent value don't exist.

 

Version 1.13 (24-Dec-2020)

- Minor bug fixes.

 

Version 1.14 (26-Dec-2020)

- Minor bug fixes in Lookups functionality

 

Version 1.15 (29-Dec-2020)

- Ability to define standalone setup for Mandatory or Force Default features

 

Version 1.16 (11-Feb-2021)

- Ability to setup for Mandatory fields independent of Force Default values

 

Version 1.17 (31-Mar-2021)

- Introduced progress bar

- Introduced auto-scroll as when multiple records are selected

 

Version 1.18 (05-Apr-2021)

- Provision to add custom message with 'LatestVersion' preference

- Added preference: PreventOperations

 

Version 1.19 (15-May-2021)

- Update for Release 21b

 

Version 1.20 (08-Jun-2021)

- Minor bug fixes

 

Version 1.21 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.22 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.23 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.24 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 1.25 (26-Apr-2022)

- Minor bug fixes

 

Version 1.26 (02-May-2022)

- Lookups data access security

 

Version 1.27 (10-May-2022)

- Support for 22A

 

Version 1.28 (17-May-2022)

- Support for 22B

 

Version 1.29 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.30 (13-Jun-2022)

- Data download performance improvements

 

Version 1.31 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.32 (15-Jul-2022)

- Minor bug fixes.

 

Version 1.33 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.34 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.35 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.36 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.37 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.38 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.39 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.40 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.41 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.42 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.43 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.50 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.52 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.53 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 1.54 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.55 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 1.56 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.57 (11-Jun-2024)

-Minor bug fixes.

 

Version 1.58 (17-Jul-2024)

-Bug fixes.

 

Version 1.59 (12-Aug-2024)

-Improved menus.

 

Version 1.60 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.61 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Element Entry Template

 

Version 1.07 (14-Jun-2023)

-Improved error messages

 

Version 1.08 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 1.09 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.10 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.11 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.12 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.13 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 1.14 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.15 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.16 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Learner Learning Template

 

Version 1.01 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.02 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.03 (20-Dec-2023)

-Introduced new function SL_Vlookup

-Introduced support to set NULL values for a field.

 

Version 1.04 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.05 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 1.06 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.07 (18-Jul-2024)

-Bug fixes in the download functionality.

 

Version 1.08 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.09 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

OTL Time Card Template

 

Version 0.37 (14-Jun-2023)

-Improved error messages

 

Version 0.38 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 1.01 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.02 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.03 (20-Dec-2023)

-Introduced new function SL_Vlookup

-Introduced support to set NULL values for a field.

 

Version 1.04 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.05 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 1.06 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.07 (18-Jul-2024)

-Bug fixes in the download functionality.

 

Version 1.08 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.09 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

HCM Person Template

Version 1.01 (15-Jun-2021)

- Baseline

 

Version 1.01 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.02 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.03 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.04 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 1.05 (26-Apr-2022)

- Minor bug fixes

 

Version 1.06 (02-May-2022)

- Lookups data access security

 

Version 1.07 (10-May-2022)

- Support for 22A

 

Version 1.08 (17-May-2022)

- Support for 22B

 

Version 1.09 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.10 (13-Jun-2022)

- Data download performance improvements

 

Version 1.11 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.12 (15-Jul-2022)

- Minor bug fixes.

 

Version 1.13 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.14 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.63 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.64 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.65 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.66 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.67 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.68 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.69 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.70 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.71 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.75 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.76 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.77 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 1.78 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.79 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 1.80 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.81 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.82 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Blanket Purchase Agreement (BPA) Template

 

Version 1.01 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.02 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.03 (20-Dec-2023)

-Introduced new function SL_Vlookup

-Introduced support to set NULL values for a field.

 

Version 1.04 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.05 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 1.06 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.07 (18-Jul-2024)

-Bug fixes in the download functionality.

 

Version 1.08 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.09 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Purchase Order Template

Version 1.35 (15-Jun-2020)

- Baseline

 

Version 1.36 (05-Jul-2020)

- Performance improvement

 

Version 1.37 (12-Jul-2020)

- Changed toolbar look and feel

- Changed toolbar option User Setup to User Preferences

 

Version 1.38 (27-Jul-2020)

- Improved SQLs

 

Version 1.39 (27-Jul-2020)

- Lookup compatibility with Office 2019

 

Version 1.40 (23-Aug-2020)

- Improved SSO login

- SSO login: Retains session across multiple Simplified Loader templates

 

Version 1.41 (10-Sep-2020)

- Minor bug fixes

 

Version 1.42 (19-Sep-2020)

- Added help topics for mobile apps.

 

Version 1.43 (27-Sep-2020)

- Added the Help menu with hyperlinks to online user manuals.

 

Version 1.44 (12-Oct-2020)

- Added help notes for Trial templates.

 

Version 1.45 (20-Oct-2020)

- Updates to support 20D update. Customers upgrading to this version (or later) will need to follow the steps below
a. Delete existing BI reports. Take backup of customisations in BI Reports.
b. Recreate BI reports
c. Restore customisations.

 

- Changed preference format to match preference format used for mobile apps i.e. use [] instead of :

 

Version 1.46 (19-Nov-2020)

- Bug fixes in Mandatory check and Force Default functionality

 

Version 1.47 (09-Dec-2020)

- Enhanced Lookups functionality from Sheet based data selection to Forms based data selection.

 

Version 1.48 (24-Dec-2020)

- Changed Lookup from fixed format to flexible format based on Lookup SQL.

- Populate value Unspecified if parent value don't exist.

 

Version 1.49 (26-Dec-2020)

- Minor bug fixes in Lookups functionality

 

Version 1.50 (29-Dec-2020)

- Ability to define standalone setup for Mandatory or Force Default features

 

Version 1.52 (11-Feb-2021)

- Ability to setup for Mandatory fields independent of Force Default values

 

Version 1.53 (31-Mar-2021)

- Introduced progress bar

- Introduced auto-scroll as when multiple records are selected

 

Version 1.54 (05-Apr-2021)

- Provision to add custom message with 'LatestVersion' preference

- Added preference: PreventOperations

 

Version 1.55 (05-Apr-2021)

- Added more fields

 

Version 1.56 (15-May-2021)

- Update for Release 21b

 

Version 1.57 (08-Jun-2021)

- Minor bug fixes

 

Version 1.58 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.59 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.60 (15-Oct-2021)

- Introduced Lookups for Requestor field

 

Version 1.61 (20-Oct-2021)

- Bug fix: The data upload process continues for Change Order load operation

 

Version 1.62 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.63 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 1.64 (26-Apr-2022)

- Minor bug fixes

 

Version 1.65 (02-May-2022)

- Lookups data access security

 

Version 1.66 (10-May-2022)

- Support for 22A

 

Version 1.67 (17-May-2022)

- Support for 22B

 

Version 1.68 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.69 (13-Jun-2022)

- Data download performance improvements

 

Version 1.70 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.71 (15-Jul-2022)

- Minor bug fixes.

 

Version 1.72 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.73 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.74 (06-Dec-2022)

- Added support for DFF.

 

Version 1.75 (07-Dec-2022)

- Minor bug fixes.

 

Version 1.76 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.77 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 3.00 (22-Dec-2022)

- 23A upgrade: Update template from SOAP API to REST API.

- Introduced 80 new fields.

 

Version 3.01 to 3.05 (5-Jan-2023 to 12-Jan-2023)

- Support for the Attachments functionality.

- DFF Support.

 

Version 3.06 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 3.07 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 3.08 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 3.09 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 3.10 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 3.11 (25-Apr-2023)

- Minor bug fixes.

 

Version 3.12 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 3.14 (14-Jun-2023)

-Improved error messages

 

Version 3.15 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 3.16 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 3.17 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 3.18 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 3.19 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 3.20 (02-Jan-2024)

-Improvements when downloading data.

 

Version 3.21 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 3.22 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 3.23 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 3.24 (11-Jun-2024)

-Minor bug fixes.

 

Version 3.25 (17-Jul-2024)

-Bug fixes.

 

Version 3.26 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 3.27 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Purchase Receipt Template

Version 1.57 (15-Jun-2020)

- Baseline

 

Version 1.58 (05-Jul-2020)

- Performance improvement

 

Version 1.59 (12-Jul-2020)

- Changed toolbar look and feel

- Changed toolbar option User Setup to User Preferences

 

Version 1.60 (27-Jul-2020)

- Lookup compatibility with Office 2019

 

Version 1.61 (23-Aug-2020)

- Improved SSO login

- SSO login: Retains session across multiple Simplified Loader templates

 

Version 1.62 (10-Sep-2020)

- Minor bug fixes

 

Version 1.63 (19-Sep-2020)

- Added help topics for mobile apps.

 

Version 1.64 (27-Sep-2020)

- Added the Help menu with hyperlinks to online user manuals.

 

Version 1.66 (12-Oct-2020)

- Added help notes for Trial templates.

 

Version 1.67 (20-Oct-2020)

- Updates to support 20D update. Customers upgrading to this version (or later) will need to follow the steps below
a. Delete existing BI reports. Take backup of customisations in BI Reports.
b. Recreate BI reports
c. Restore customisations.

 

- Changed preference format to match preference format used for mobile apps i.e. use [] instead of :

 

Version 1.68 (19-Nov-2020)

- Bug fixes in Mandatory check and Force Default functionality

 

Version 1.69 (09-Dec-2020)

- Enhanced Lookups functionality from Sheet based data selection to Forms based data selection.

 

Version 1.70 (24-Dec-2020)

- Changed Lookup from fixed format to flexible format based on Lookup SQL.

- Populate value Unspecified if parent value don't exist.

 

Version 1.71 (26-Dec-2020)

- Minor bug fixes in Lookups functionality

 

Version 1.72 (29-Dec-2020)

- Ability to define standalone setup for Mandatory or Force Default features

 

Version 1.73 (11-Feb-2021)

- Ability to setup for Mandatory fields independent of Force Default values

 

Version 1.74 (31-Mar-2021)

- Introduced progress bar

- Introduced auto-scroll as when multiple records are selected

 

Version 1.75 (05-Apr-2021)

- Provision to add custom message with 'LatestVersion' preference

- Added preference: PreventOperations

 

Version 1.76 (15-May-2021)

- Update for Release 21b

 

Version 1.77 (08-Jun-2021)

- Minor bug fixes

 

Version 1.78 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.79 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.80 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.81 (16-Jan-2022)

- Renamed columns to remove x prefix

 

Version 1.82 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 1.83 (26-Apr-2022)

- Minor bug fixes

 

Version 1.84 (02-May-2022)

- Lookups data access security

 

Version 1.85 (10-May-2022)

- Support for 22A

 

Version 1.86 (17-May-2022)

- Support for 22B

 

Version 1.87 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.88 (13-Jun-2022)

- Data download performance improvements

 

Version 1.89 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.90 (15-Jul-2022)

- Minor bug fixes.

 

Version 1.91 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.92 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.93 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.94 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.95 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.96 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.97 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.98 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.99 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 2.00 (25-Apr-2023)

- Minor bug fixes.

 

Version 2.01 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 2.03 (14-Jun-2023)

-Improved error messages

 

Version 2.04 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 2.05 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 2.06 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 2.07 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 2.08 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 2.09 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 2.10 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 2.11 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 2.12 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 2.13 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Purchase Requisition Template

Version 2.11 (15-Jun-2020)

- Baseline

 

Version 2.12 (05-Jul-2020)

- Performance improvement

 

Version 2.13 (12-Jul-2020)

- Changed toolbar look and feel

- Changed toolbar option User Setup to User Preferences

 

Version 2.15 (27-Jul-2020)

- Lookup compatibility with Office 2019

 

Version 2.16 (27-Jul-2020)

- Improved query to fetch data

 

Version 2.17 (23-Aug-2020)

- Improved SSO login

- SSO login: Retains session across multiple Simplified Loader templates

 

Version 2.18 (10-Sep-2020)

- Minor bug fixes

 

Version 2.19 (19-Sep-2020)

- Added help topics for mobile apps.

 

Version 2.20 (27-Sep-2020)

- Added the Help menu with hyperlinks to online user manuals.

 

Version 2.23 (12-Oct-2020)

- Added help notes for Trial templates.

 

Version 2.24 (20-Oct-2020)

- Updates to support 20D update. Customers upgrading to this version (or later) will need to follow the steps below
a. Delete existing BI reports. Take backup of customisations in BI Reports.
b. Recreate BI reports
c. Restore customisations.

 

- Changed preference format to match preference format used for mobile apps i.e. use [] instead of :

 

Version 2.25 (19-Nov-2020)

- Bug fixes in Mandatory check and Force Default functionality

 

Version 2.26 (09-Dec-2020)

- Enhanced Lookups functionality from Sheet based data selection to Forms based data selection.

 

Version 2.27 (24-Dec-2020)

- Changed Lookup from fixed format to flexible format based on Lookup SQL.

- Populate value Unspecified if parent value don't exist.

 

Version 2.28 (26-Dec-2020)

- Minor bug fixes in Lookups functionality

 

Version 2.29 (29-Dec-2020)

- Ability to define standalone setup for Mandatory or Force Default features

 

Version 2.30 (11-Feb-2021)

- Ability to setup for Mandatory fields independent of Force Default values

 

Version 2.31 (31-Mar-2021)

- Introduced progress bar

- Introduced auto-scroll as when multiple records are selected

 

Version 2.32 (05-Apr-2021)

- Provision to add custom message with 'LatestVersion' preference

- Added preference: PreventOperations

 

Version 2.33 (15-May-2021)

- Update for Release 21b

 

Version 2.34 (08-Jun-2021)

- Minor bug fixes

 

Version 2.35 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 2.36 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 2.37 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 2.38 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 2.39 (26-Apr-2022)

- Minor bug fixes

 

Version 2.40 (02-May-2022)

- Lookups data access security

 

Version 2.41 (10-May-2022)

- Support for 22A

 

Version 2.42 (17-May-2022)

- Support for 22B

 

Version 2.43 (11-Jun-2022)

- Support hierarchical data download

 

Version 2.44 (13-Jun-2022)

- Data download performance improvements

 

Version 2.45 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 2.46 (15-Jul-2022)

- Minor bug fixes.

 

Version 2.47 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 2.48 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 2.49 (07-Dec-2022)

- Support for Chinese characters.

 

Version 2.50 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 3.00 (18-Jan-2023)

- 23A upgrade - Move from SOAP API to REST API.

- Introduced 50+ fields.

 

Version 3.01 to 3.04 (22-Jan-2023 to 5-Feb-2023)

- 23A upgrade - Move from SOAP API to REST API.

- Introduced 50+ fields.

 

Version 3.05 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 3.06 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 3.07 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 3.08 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 3.09 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 3.10 (25-Apr-2023)

- Minor bug fixes.

 

Version 3.11 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 3.12 (14-Jun-2023)

-Improved error messages

 

Version 3.13 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 3.14 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 3.15 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 3.16 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 3.17 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 3.18 (04-Jan-2024)

-Performance improvement.

 

Version 3.19 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 3.20 (01-Mar-2024)

-Handle data download scenarios for all data types.

 

 

Version 3.21 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 3.22 (11-Jun-2024)

-Minor bug fixes.

 

Version 3.23 (17-Jul-2024)

-Bug fixes.

 

Version 3.24 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 3.25 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Suppliers Template

Version 1.13 (01-Mar-2022)

- First release (baseline)

 

Version 1.14 (26-Apr-2022)

- Minor bug fixes

 

Version 1.15 (02-May-2022)

- Lookups data access security

 

Version 1.16 (10-May-2022)

- Support for 22A

 

Version 1.17 (17-May-2022)

- Support for 22B

 

Version 1.18 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.19 (13-Jun-2022)

- Data download performance improvements

 

Version 1.20 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.21 (15-Jul-2022)

- Minor bug fixes.

 

Version 1.22 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.23 (09-Sep-2022)

- 22D: Added fields released in 22D.

 

Version 1.24 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.25 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.26 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.27 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.28 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.29 (10-Mar-2023)

- Added functionality to manage Bank details using Supplier template.

 

Version 1.30 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.31 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.32 (9-Apr-2023)

- Added field Bank Assignment Supplier Site Bu Assignments.

 

Version 1.33 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.34 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.35 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.38 (14-Jun-2023)

-Improved error messages

 

Version 1.39 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 1.40 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.41 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.42 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.43 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 1.44 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.45 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 1.46 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.47 (17-Jul-2024)

-Bug fixes.

 

Version 1.48 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.49 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Project Budget Template

Version 1.63 (15-Jun-2020)

- Baseline

 

Version 1.64 (05-Jul-2020)

- Performance improvement

 

Version 1.65 (12-Jul-2020)

- Changed toolbar look and feel

- Changed toolbar option User Setup to User Preferences

 

Version 1.66 (27-Jul-2020)

- Lookup compatibility with Office 2019

 

Version 1.67 (23-Aug-2020)

- Improved SSO login

- SSO login: Retains session across multiple Simplified Loader templates

 

Version 1.68 (10-Sep-2020)

- Minor bug fixes

 

Version 1.69 (27-Sep-2020)

- Added the Help menu with hyperlinks to online user manuals.

 

Version 1.70 (12-Oct-2020)

- Added help notes for Trial templates.

 

Version 1.71 (20-Oct-2020)

- Updates to support 20D update. Customers upgrading to this version (or later) will need to follow the steps below
a. Delete existing BI reports. Take backup of customisations in BI Reports.
b. Recreate BI reports
c. Restore customisations.

 

- Changed preference format to match preference format used for mobile apps i.e. use [] instead of :

 

Version 1.72 (19-Nov-2020)

- Bug fixes in Mandatory check and Force Default functionality

 

Version 1.73 (09-Dec-2020)

- Enhanced Lookups functionality from Sheet based data selection to Forms based data selection.

 

Version 1.74 (24-Dec-2020)

- Changed Lookup from fixed format to flexible format based on Lookup SQL.

- Populate value Unspecified if parent value don't exist.

 

Version 1.75 (26-Dec-2020)

- Minor bug fixes in Lookups functionality

 

Version 1.76 (29-Dec-2020)

- Ability to define standalone setup for Mandatory or Force Default features

 

Version 1.79 (11-Feb-2021)

- Ability to setup for Mandatory fields independent of Force Default values

 

Version 1.80 (31-Mar-2021)

- Introduced progress bar

- Introduced auto-scroll as when multiple records are selected

 

Version 1.81 (05-Apr-2021)

- Provision to add custom message with 'LatestVersion' preference

- Added preference: PreventOperations

 

Version 1.82 (15-May-2021)

- Update for Release 21b

 

Version 1.83 (08-Jun-2021)

- Minor bug fixes

 

Version 1.84 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.85 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.86 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.87 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 1.88 (26-Apr-2022)

- Minor bug fixes

 

Version 1.89 (02-May-2022)

- Lookups data access security

 

Version 1.90 (10-May-2022)

- Support for 22A

 

Version 1.91 (17-May-2022)

- Support for 22B

 

Version 1.92 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.93 (13-Jun-2022)

- Data download performance improvements

 

Version 1.94 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.95 (15-Jul-2022)

- Minor bug fixes.

 

Version 1.96 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.97 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.98 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.99 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 2.00 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 2.01 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 2.02 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 2.03 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 2.04 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 2.05 (25-Apr-2023)

- Minor bug fixes.

 

Version 2.06 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 2.09 (14-Jun-2023)

-Improved error messages

 

Version 2.10 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 2.11 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 2.12 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 2.13 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 2.14 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 2.15 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 2.16 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 2.17 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 2.18 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 2.19 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Project Cost Adjustments Template

Version 1.08 (30-Apr-2021)

- Baseline

 

Version 1.09 (15-May-2021)

- Update for Release 21b

 

Version 1.10 (08-Jun-2021)

- Minor bug fixes

 

Version 1.11 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.12 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.13 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.14 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.14 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 1.15 (26-Apr-2022)

- Minor bug fixes

 

Version 1.16 (02-May-2022)

- Lookups data access security

 

Version 1.17 (10-May-2022)

- Support for 22A

 

Version 1.18 (17-May-2022)

- Support for 22B

 

Version 1.19 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.20 (13-Jun-2022)

- Data download performance improvements

 

Version 1.21 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.22 (15-Jul-2022)

- Minor bug fixes.

 

Version 1.23 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.24 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.25 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.26 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.27 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.28 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.29 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.30 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.31 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.32 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.33 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.37 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.38 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.39 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.40 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 1.41 (02-Jan-2024)

-Improvements when downloading data.

 

Version 1.42 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.43 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 1.44 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.45 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.46 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Project Billing Event

Version 1.51 (15-Jun-2020)

- Baseline

 

Version 1.52 (05-Jul-2020)

- Performance improvement

 

Version 1.53 (12-Jul-2020)

- Changed toolbar look and feel

- Changed toolbar option User Setup to User Preferences

 

Version 1.54 (27-Jul-2020)

- Lookup compatibility with Office 2019

 

Version 1.55 (23-Aug-2020)

- Improved SSO login

- SSO login: Retains session across multiple Simplified Loader templates

 

Version 1.56 (10-Sep-2020)

- Minor bug fixes

 

Version 1.57 (27-Sep-2020)

- Added the Help menu with hyperlinks to online user manuals.

 

Version 1.58 (12-Oct-2020)

- Added help notes for Trial templates.

 

Version 1.59 (20-Oct-2020)

- Updates to support 20D update. Customers upgrading to this version (or later) will need to follow the steps below
a. Delete existing BI reports. Take backup of customisations in BI Reports.
b. Recreate BI reports
c. Restore customisations.

 

- Changed preference format to match preference format used for mobile apps i.e. use [] instead of :

 

Version 1.60 (19-Nov-2020)

- Bug fixes in Mandatory check and Force Default functionality

 

Version 1.61 (09-Dec-2020)

- Enhanced Lookups functionality from Sheet based data selection to Forms based data selection.

 

Version 1.62 (24-Dec-2020)

- Changed Lookup from fixed format to flexible format based on Lookup SQL.

- Populate value Unspecified if parent value don't exist.

 

Version 1.63 (26-Dec-2020)

- Minor bug fixes in Lookups functionality

 

Version 1.64 (29-Dec-2020)

- Ability to define standalone setup for Mandatory or Force Default features

 

Version 1.65 (11-Feb-2021)

- Ability to setup for Mandatory fields independent of Force Default values

 

Version 1.66 (31-Mar-2021)

- Introduced progress bar

- Introduced auto-scroll as when multiple records are selected

 

Version 1.67 (05-Apr-2021)

- Provision to add custom message with 'LatestVersion' preference

- Added preference: PreventOperations

 

Version 1.68 (15-May-2021)

- Update for Release 21b

 

Version 1.69 (08-Jun-2021)

- Minor bug fixes

 

Version 1.70 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.71 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.72 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.73 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 1.74 (26-Apr-2022)

- Minor bug fixes

 

Version 1.75 (02-May-2022)

- Lookups data access security

 

Version 1.76 (10-May-2022)

- Support for 22A

 

Version 1.77 (17-May-2022)

- Support for 22B

 

Version 1.78 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.79 (13-Jun-2022)

- Data download performance improvements

 

Version 1.80 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.81 (15-Jul-2022)

- Minor bug fixes.

 

Version 1.82 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.83 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.84 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.85 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.86 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.87 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.88 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.89 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.90 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.91 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.92 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.97 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.98 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 1.99 (04-Jan-2024)

-Performance improvement.

 

Version 2.00 (06-Feb-2024)

-Improvements when downloading data.

 

Version 2.01 (01-Mar-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 2.02 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 2.03 (23-Apr-2024)

-Support to download DFFs.

 

Version 2.04 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 2.05 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 2.06 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Project Forecast Template

Version 1.50 (15-Jun-2020)

- Baseline

 

Version 1.51 (05-Jul-2020)

- Performance improvement

 

Version 1.52 (12-Jul-2020)

- Changed toolbar look and feel

- Changed toolbar option User Setup to User Preferences

 

Version 1.53 (27-Jul-2020)

- Lookup compatibility with Office 2019

 

Version 1.54 (23-Aug-2020)

- Improved SSO login

- SSO login: Retains session across multiple Simplified Loader templates

 

Version 1.55 (10-Sep-2020)

- Minor bug fixes

 

Version 1.56 (27-Sep-2020)

- Added the Help menu with hyperlinks to online user manuals.

 

Version 1.57 (12-Oct-2020)

- Added help notes for Trial templates.

 

Version 1.58 (20-Oct-2020)

- Updates to support 20D update. Customers upgrading to this version (or later) will need to follow the steps below
a. Delete existing BI reports. Take backup of customisations in BI Reports.
b. Recreate BI reports
c. Restore customisations.

 

- Changed preference format to match preference format used for mobile apps i.e. use [] instead of :

 

Version 1.59 (19-Nov-2020)

- Bug fixes in Mandatory check and Force Default functionality

 

Version 1.60 (09-Dec-2020)

- Enhanced Lookups functionality from Sheet based data selection to Forms based data selection.

 

Version 1.61 (24-Dec-2020)

- Changed Lookup from fixed format to flexible format based on Lookup SQL.

- Populate value Unspecified if parent value don't exist.

 

Version 1.62 (26-Dec-2020)

- Minor bug fixes in Lookups functionality

 

Version 1.63 (29-Dec-2020)

- Ability to define standalone setup for Mandatory or Force Default features

 

Version 1.64 (11-Feb-2021)

- Ability to setup for Mandatory fields independent of Force Default values

 

Version 1.65 (31-Mar-2021)

- Introduced progress bar

- Introduced auto-scroll as when multiple records are selected

 

Version 1.66 (05-Apr-2021)

- Provision to add custom message with 'LatestVersion' preference

- Added preference: PreventOperations

 

Version 1.67 (15-May-2021)

- Update for Release 21b

 

Version 1.68 (08-Jun-2021)

- Minor bug fixes

 

Version 1.69 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.70 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.71 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.72 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 1.73 (26-Apr-2022)

- Minor bug fixes

 

Version 1.74 (02-May-2022)

- Lookups data access security

 

Version 1.75 (10-May-2022)

- Support for 22A

 

Version 1.76 (17-May-2022)

- Support for 22B

 

Version 1.77 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.78 (13-Jun-2022)

- Data download performance improvements

 

Version 1.79 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.80 (15-Jul-2022)

- Minor bug fixes.

 

Version 1.81 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 1.82 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 1.83 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.84 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.85 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.86 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.87 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.88 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.89 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.90 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.91 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.92 (14-Jun-2023)

-Improved error messages

 

Version 1.93 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 1.94 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.95 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.96 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 1.97 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 1.98 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.99 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 2.00 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 2.01 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 2.02 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Projects Template

Version 2.74 (15-Jun-2020)

- Baseline

 

Version 2.75 (05-Jul-2020)

- Performance improvement

 

Version 2.76 (12-Jul-2020)

- Changed toolbar look and feel

- Changed toolbar option User Setup to User Preferences

 

Version 2.77 (27-Jul-2020)

- Lookup compatibility with Office 2019

 

Version 2.78 (23-Aug-2020)

- Improved SSO login

- SSO login: Retains session across multiple Simplified Loader templates

 

Version 2.79 (10-Sep-2020)

- Minor bug fixes

 

Version 2.80 (27-Sep-2020)

- Added the Help menu with hyperlinks to online user manuals.

 

Version 2.81 (12-Oct-2020)

- Added help notes for Trial templates.

 

Version 2.82 (20-Oct-2020)

- Updates to support 20D update. Customers upgrading to this version (or later) will need to follow the steps below
a. Delete existing BI reports. Take backup of customisations in BI Reports.
b. Recreate BI reports
c. Restore customisations.

 

- Changed preference format to match preference format used for mobile apps i.e. use [] instead of :

 

Version 2.83 (19-Nov-2020)

- Bug fixes in Mandatory check and Force Default functionality

 

Version 2.84 (09-Dec-2020)

- Enhanced Lookups functionality from Sheet based data selection to Forms based data selection.

 

Version 2.85 (24-Dec-2020)

- Changed Lookup from fixed format to flexible format based on Lookup SQL.

- Populate value Unspecified if parent value don't exist.

 

Version 2.86 (26-Dec-2020)

- Minor bug fixes in Project download functionality

- Minor bug fixes in Lookups functionality

 

Version 2.87 (29-Dec-2020)

- Ability to define standalone setup for Mandatory or Force Default features

 

Version 2.88 (09-Feb-2021)

- Ability to add, update, or delete Team Members

 

Version 2.89 (11-Feb-2021)

- Ability to setup for Mandatory fields independent of Force Default values

 

Version 2.90 (31-Mar-2021)

- Introduced progress bar

- Introduced auto-scroll as when multiple records are selected

 

Version 2.91 (05-Apr-2021)

- Provision to add custom message with 'LatestVersion' preference

- Added preference: PreventOperations

 

Version 2.92 (15-May-2021)

- Update for Release 21b

 

Version 2.93 (08-Jun-2021)

- Minor bug fixes

 

Version 2.94 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 2.95 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 2.96 (15-Oct-2021)

- Arranged the sequence on lookup fields to display IDs fields at the end in the lookup popup

 

Version 2.97 (12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 2.98 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 2.99 (26-Apr-2022)

- Minor bug fixes

 

Version 3.00 (02-May-2022)

- Lookups data access security

 

Version 3.01 (10-May-2022)

- Support for 22A

 

Version 3.02 (15-May-2022)

- Replaced Download Criteria with DataSheet

 

Version 3.03 (17-May-2022)

- Support for 22B

 

Version 3.04 (11-Jun-2022)

- Support hierarchical data download

 

Version 3.05 (13-Jun-2022)

- Data download performance improvements

 

Version 3.06 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 3.07 - 3.11 (01-Aug-2022)

- Major update. Included Tasks and Transaction Control functionality within the Projects template

 

Version 3.12 (26-Aug-2022)

- Download operation intermittently miss processing records.

- Download dateTime is=n the right format.

 

Version 3.13 (09-Sep-2022)

- Support to process DFF Context values.

 

Version 3.14 (07-Dec-2022)

- Support for Chinese characters.

 

Version 3.15 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 3.16 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 3.17 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 3.18 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 3.19 (5-Apr-2023)

- Added Status change comment field.

 

Version 3.20 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 3.21 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 3.22 (25-Apr-2023)

- Minor bug fixes.

 

Version 3.23 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 3.24 (19-May-2023)

- Task DFF update did not show confirmation message.

 

Version 3.29 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 3.30 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 3.31 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 3.32 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 3.33 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 3.34 (02-Jan-2024)

-Improvements when downloading data.

 

Version 3.35 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 3.36 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 3.37 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 3.38 (17-Jul-2024)

-Bug fixes.

 

Version 3.39 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 3.40 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Project Template Config

Version 1.56 (15-Jun-2020)

- Baseline

 

Version 1.57 (05-Jul-2020)

- Performance improvement

 

Version 1.58 (12-Jul-2020)

- Changed toolbar look and feel

- Changed toolbar option User Setup to User Preferences

 

Version 1.59 (27-Jul-2020)

- Lookup compatibility with Office 2019

 

Version 1.60 (23-Aug-2020)

- Improved SSO login

- SSO login: Retains session across multiple Simplified Loader templates

 

Version 1.61 (10-Sep-2020)

- Minor bug fixes

 

Version 1.62 (27-Sep-2020)

- Added the Help menu with hyperlinks to online user manuals.

 

Version 1.63 (12-Oct-2020)

- Added help notes for Trial templates.

 

Version 1.64 (20-Oct-2020)

- Updates to support 20D update. Customers upgrading to this version (or later) will need to follow the steps below
a. Delete existing BI reports. Take backup of customisations in BI Reports.
b. Recreate BI reports
c. Restore customisations.

 

- Changed preference format to match preference format used for mobile apps i.e. use [] instead of :

 

Version 1.65 (19-Nov-2020)

- Bug fixes in Mandatory check and Force Default functionality

 

Version 1.66 (09-Dec-2020)

- Enhanced Lookups functionality from Sheet based data selection to Forms based data selection.

 

Version 1.67 (24-Dec-2020)

- Changed Lookup from fixed format to flexible format based on Lookup SQL.

- Populate value Unspecified if parent value don't exist.

 

Version 1.68 (26-Dec-2020)

- Minor bug fixes in Lookups functionality

 

Version 1.69 (29-Dec-2020)

- Ability to define standalone setup for Mandatory or Force Default features

 

Version 1.70 (11-Feb-2021)

- Ability to setup for Mandatory fields independent of Force Default values

 

Version 1.71 (31-Mar-2021)

- Introduced progress bar

- Introduced auto-scroll as when multiple records are selected

 

Version 1.72 (05-Apr-2021)

- Provision to add custom message with 'LatestVersion' preference

- Added preference: PreventOperations

 

Version 1.73 (15-May-2021)

- Update for Release 21b

 

Version 1.74 (08-Jun-2021)

- Minor bug fixes

 

Version 1.75 (01-Jul-2021)

- Validate relevant header values

- Cosmetic changes

 

Version 1.76 (13-Oct-2021)

- Introduced Highlight Relevant Fields menu option

 

Version 1.77(12-Dec-2021)

- The Template continues loading data even when the user navigates to another Excel window

 

Version 1.78 (01-Mar-2022)

- SSO login support for Oracle Fusion release 22A

 

Version 1.79 (26-Apr-2022)

- Minor bug fixes

 

Version 1.80 (02-May-2022)

- Lookups data access security

 

Version 1.81 (10-May-2022)

- Support for 22A

 

Version 1.82 (17-May-2022)

- Support for 22B

 

Version 1.83 (11-Jun-2022)

- Support hierarchical data download

 

Version 1.84 (13-Jun-2022)

- Data download performance improvements

 

Version 1.85 (21-Jun-2022)

- Restore Connection setup functionality

 

Version 1.86 (21-Jun-2022)

- Obselete: Functionality included in Projects template

 

Version 1.87 (07-Dec-2022)

- Support for Chinese characters.

 

Version 1.88 (12-Dec-2022)

- Update to support Oracle 22D quarterly patch.

 

Version 1.89 (10-Feb-2023)

- Add Display Default feature to autopopulate field values.

- Updates to support 23A quartely release.

 

Version 1.90 (19-Feb-2023)

- Hightlight Lookup up field green as soon as the fields are added to the DataSheet.

- Performance improvements.

- Minor bug fixes.

 

Version 1.91 (3-Apr-2023)

- Imporved Template Download operation.

 

Version 1.92 (3-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

- Changed DataSheet formatting.

 

Version 1.93 (7-Apr-2023)

- Technical changes to accommodate 23B quarterly updates.

 

Version 1.94 (15-Apr-2023)

- Resolved bug related to filter functionality.

- Improved messages in Excel status bar.

- Improved pop-up messages.

 

Version 1.95 (25-Apr-2023)

- Minor bug fixes.

 

Version 1.96 (10-May-2023)

- Added feature to format DataSheet.

- Added feature to Auto Save workbook after processing every n number of records.

- Setup DFF fields feature ask users to set up 'Display Default Values' field.

 

Version 1.97 (14-Jun-2023)

-Improved error messages

 

Version 1.98 (24-Jul-2023)

-Added Instructions section in the Admin panel

 

Version 1.99 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 20 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 2.01 (26-Nov-2023)

-Introduced new function SL_Vlookup

 

Version 2.02 (20-Dec-2023)

-Introduced support to set NULL values for a field.

 

Version 2.03 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 2.04 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 2.05 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 2.06 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 2.07 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Inventory Item Template

 

Version 1.01 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.02 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.03 (20-Dec-2023)

-Introduced new function SL_Vlookup

-Introduced support to set NULL values for a field.

 

Version 1.04 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.05 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 1.06 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.07 (18-Jul-2024)

-Bug fixes in the download functionality.

 

Version 1.08 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.09 (07-Oct-2024)

-Introduced dynamic dependent lookups

 

Physical Inventory Template

 

Version 1.01 (16-Aug-2023)

-Renamed PreventOperations to Disallowed

 

Version 1.02 (11-Sep-2023)

-Added support for Context Sensitive DFF

 

Version 1.03 (20-Dec-2023)

-Introduced new function SL_Vlookup

-Introduced support to set NULL values for a field.

 

Version 1.04 (06-Feb-2024)

-Improvements when downloading data.

-24B compatibility update for SSO login.

-Minor update in lookups.

 

Version 1.05 (02-Apr-2024)

-Handle data download scenarios for all data types.

 

 

Version 1.06 (24-May-2024)

-Support to access templates on shared PC.

-Support for login using IDCS.

 

Version 1.07 (18-Jul-2024)

-Bug fixes in the download functionality.

 

Version 1.08 (17-Sep-2024)

-Corrected URLs in help menu

-Reduced the number of default formatting rows from 500 to 50

 

Version 1.09 (07-Oct-2024)

-Introduced dynamic dependent lookups