Element Entry Wizard Version

Package Body Version

4.4.30 (09-Sep-2025)

1.0.11 (Minimum 1.0.11)

4.4.30 (09-Sep-2025)

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

4.4.29 (01-Sep-2025)

Internal Bug Fix.

4.4.28 (01-Sep-2025)

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

4.4.27 (20-May-2025)

Internal update.

4.4.26 (15-Apr-2025)

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

4.4.25 (17-Oct-2024)

Added Default Browser Login option.

4.4.24 (19-Mar-2024)

Fixed - Submit form errors when validate Batch Id provided.

4.4.23 (19-Mar-2024)

Fixed - When 'Validate only' the cells validated change to green whereas they should change to blue.

4.4.22 (23-Nov-2023)

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

4.4.21 (06-Sep-2023)

Internal update.

4.4.20 (21-Apr-2023)

Internal update.

4.4.19 (05-Apr-2023)

Internal update.

4.4.18 (17-Mar-2023)

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

4.4.17 (25-Jan-2023)

Fixed error when uploading batch lines: ORA-20001: PAY_6306_INPUT_VALUE_FORMAT: N, UNIT_OF_MEASURE, Date.

4.4.16 (19-Oct-2022)

Fixed form erroring when the table based value set has :$PROFILES$.PER_BUSINESS_GROUP_ID.

4.4.15 (20-Sep-2022)

Internal update.

4.4.14 (03-May-2022)

Internal update.

4.4.13 (20-Apr-2022)

Internal update.

4.4.12 (21-Feb-2022)

Custom Query SQL Injection update.

4.4.11 (03-Dec-0021)

Internal update.

4.4.10 (14-Jul-2021)

Updated security.

4.4.09 (23-Mar-2021)

Updated security.

4.4.08 (19-Mar-2021)

Ex-employees date filters were rejecting legitimately changed Employee names.

4.4.07 (08-Mar-2021)

Queries referencing FND_SESSIONS or views linked to FND_SESSIONS were not returning rows.

4.4.06 (05-Mar-2021)

Downloaded Assignments were generating replicated header information and superfluous empty rows.

4.4.05 (04-Mar-2021)

When a value set has blank meaning then the Wizard does not validate the value.
If a value set has fnd_session table then it does not bring back any value.

4.4.04 (17-Feb-2021)

On upload Employee name is returned for certain dates and not for all dates.
Just after login if we copy employee name (that has trailing spaces in Oracle), then the Wizard errors on upload 'Combination of Assignment Number and Employee Name not valid'.

4.4.03 (12-Feb-2021)

Wizard should download terminated employees and should not error if Employee name is not provided on the sheet.

4.4.02 (11-Feb-2021)

There is an inconsistency here between the download query and the upload query.

4.4.01 (10-Feb-2021)

Reverted back to version 4.3.07 and changed version number.

4.3.07 (10-Feb-2021)

Updated security.

4.3.06 (12-Oct-2020)

Fixed payroll search in the Download form where it was asking to enter criteria.

4.3.05 (06-Oct-2020)

Internal updates.

4.3.04 (02-Oct-2020)

Bug fixes in Download form.

4.3.03 (05-Jun-2020)

Internal update.

4.3.02 (17-Mar-2020)

Fixed Wizard crashing after creating new sheet and then exiting.

4.3.01 (13-Mar-2020)

Rebranding of logo and new color scheme.

4.3.00 (13-Mar-2020)

Rebranding of logo and new color scheme.

4.2.16 (19-Dec-2019)

Major update for core and Custom Query. Firewall compliant encoding added.

4.2.15 (06-Dec-2019)

Internal updates.

4.2.14 (13-Nov-2019)

Internal bug fixes.

4.2.13 (08-Nov-2019)

Sub-priority field on entry form should give error if user enters more than four digits.

4.2.12 (07-Nov-2019)

Assignment Number LOV clearing out Employee Name. Employee Name LOV does not populate Assignment Number LOV.

4.2.11 (10-Oct-2019)

Internal updates.

4.2.10 (19-Aug-2019)

Internal update.

4.2.09 (07-Jul-2019)

New colour scheme rollout.

4.2.08 (25-Mar-2019)

Fixed the issue of not writing input column name after Row 9 header values are entered on the sheeting using the form.

4.2.07 (22-Mar-2019)

Fixed the issue of getting SQL error 'Missing Parameter' while downloading elements and Effective Date value is missing.
Fixed the issue of popup input missing columns msgbox after hitting cancel button.
Fixed the issue of Template123 sheet not opening on first click.

4.2.06 (22-Mar-2019)

Internal updates.

4.2.05 (22-Mar-2019)

Fixed the issue of fetching incorrect Employee Name while doing upload and not passing Employee Name on the sheet.

4.2.04 (21-Mar-2019)

Fixed the issue of opening the 'Submit' form while clicking on the View Concurrent Request ribbon.

4.2.03 (14-Mar-2019)

Fixed Employee number and Assignment ID incorrect formatting after row 84.

4.2.02 (14-Mar-2019)

New ribbon code.

4.2.01 (08-Mar-2019)

Changed Lookup Query which was returning multiple values.

4.2.00 (13-Feb-2019)

Defaults Row logic implemented.

4.1.26 (13-Feb-2019)

Download Selected enabled - Download via Sheet.

4.1.25 (06-Feb-2019)

Improved selection behaviour:
1. Relabelled the 'Remove' button to '<' to be consistent with other products.
2. When an Assignment is selected it is transferred to the 'Selected Assignments' column and removed from the 'Available Assignments' list.
3. When one is 'Removed' via the '<' button the opposite occurs, it is removed from the 'Selected Assignments' column and placed again at the bottom of the 'Available Assignments'.

4.1.24 (15-Jan-2019)

Improved column handling on Download form:
a) If input columns missing they are inserted, but those not missing are not replicated.
b) IntialiseColumns is called each time so any prior column reordering/removal is handled correctly.

4.1.23 (14-Jan-2019)

Fixed bug in effective date defaulting logic.
Fixed bug populating sheet after closing batch form: Entry Inputs and validation correctly handled.
Fixed download query to handle multiple entries per assignment. (Upload PGM flags these as errors, 'Assignment-Entries' form is happy to allow).
Fixed tab order in Download form.

4.1.22 (10-Jan-2019)

Download form records and restores settings.
Input Validation SQL handles Lookups defined for different Application Ids.

4.1.21 (03-Jan-2019)

Updated security.

4.1.20 (30-Dec-2018)

Refreshed Setup sheet for 2017 version - tidied up HTTPS references in links.

4.1.19 (01-Sep-2017)

Updated security and connectivity.

4.1.18 (01-Sep-2017)

Added handling for sporadic issue caused intermittently when the Batch name has been updated but the OVN and Batch ID is not cleared for the new load.

4.1.17 (01-Sep-2017)

Corrected tooltip text for Debug Mode control.

4.1.16 (01-Sep-2017)

Update to Set-up sheet format and links.
Deletions work correctly for whole sheet and for selected areas.

4.1.15 (31-Aug-2017)

Fixes to ensure missing columns don't throw exceptions.

4.1.14 (13-Jun-2017)

Internal release note changes.

4.1.13 (26-Jan-2016)

Updated Security.

4.1.12 (12-Jul-2016)

Updated Security.

4.1.11 (13-Oct-2015)

Fixed behaviour of Payroll Name List in batch header form.

4.1.10 (21-Apr-2015)

Updated View concurrent Request form.

4.1.09 (29-Sep-2014)

Fixed bug where NewCodeConversion.SetA_VarValue was causing a compile error.
Compile error in hidden module: NewCodeConversion.

4.1.08 (29-Jul-2014)

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

4.1.07 (28-Jul-2014)

Core code version 209 imported.

4.1.06 (12-Jun-2014)

Added check for PAY_33240_BTH_STATUS_CHANGED to provide advice on how to get around the issue.

4.1.05 (12-Jun-2014)

Added a ribbon/menu control to allow the Bulk Row Upload to be controlled by the user.

4.1.04 (11-Jun-2014)

Fixed error reporting on multirow uploads.

4.1.03 (10-Jun-2014)

Fixed download error where caching prevented new values from being returned.

4.1.02 (04-Jun-2014)

Stopped Entry form from validating fields when opened.
Other than in-field on_change() code, validation now only occurs when clicking accept.

4.1.01 (04-Jun-2014)

Major performance upgrade, multirow (cached) validation and bulk uploads.

4.0.10 (24-Apr-2014)

Added caching to all queries.
Assignment Id and Employee Number now (optional) fields for performance improvements.

4.0.09 (07-Apr-2014)

Migrated to core code 205.32

4.0.08 (17-Mar-2014)

Fixed Overflow on DeleteBatchHeader for large Batch Id values.

4.0.07 (14-Mar-2014)

Fix for DFF values with special characters.

4.0.06 (12-Mar-2014)

Final changes to get Descriptive Flexfield support working.
Validation process for DFF segments (and context) corrected.

4.0.05 (06-Mar-2014)

Reflected Mandatory colour for Batch Name in form.

4.0.04 (17-Jan-2014)

Imported Current Core code (205.27)

4.0.03 (20-Jan-2014)

Element Inputs now populate (via form) if the Element is entered manually in the sheet Header Entry form defaults are the same now whether you double-click or use the form header button on the ribbon/toolbar/menu Fixed DFF validation and errors relating to missing DFF columns

4.0.02 (17-Jan-2014)

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

4.0.01 (31-Dec-2013)

Added DFF and Further Element Information DFF (Requires package header version 1.0.9 and package body version 1.0.11)

3.4.06 (18-Dec-2013)

Translated Element Name to Source language for Chinese Installations and filtered date by Bus Grp better against date validations

3.4.05 (06-Dec-2013)

Fix in AddFields for Duplicate key error for Date formats

3.4.04 (03-Dec-2013)

Date download formatting corrected for non-Standard date formats (especially China)

3.4.03 (29-Nov-2013)

Fixed form behaviour for validating the standard entry columns (date earned, entry reason etc).  Removed the controlsource dependency

3.4.02 (29-Nov-2013)

Added online form validations

3.4.01 (26-Nov-2013)

Formatting Input dates to allow for unknown date formats

3.4.00 (21-Nov-2013)

Added ‘Ignore Date Syntax option for Input validation (was causing some problems with China) Added caching of a number of regularly used queries. Could be extended further. Cleaned up form behaviour (red controls etc when loaded etc)

3.3.09 (15-Nov-2013)

Tidied up error messages when date not present or Element Name either empty or invalid

3.3.08 (14-Nov-2013)

Ribbon Labels changed to ‘Element Entry’ and ‘Batch Header’ (the word “Edit” was dropped)

3.3.07 (14-Nov-2013)

Cleaned up logout procedures where the cache wasn’t being cleared (added emptying calls to NewCodeConversion.init)

3.3.06 (13-Nov-2013)

Work with Date passed to m4aps_eewwizard.validation_sql (NewCodeConversion.GetInputValidations) Tidied up Effective Date error reporting

3.3.05 (31-Oct-2013)

Because of issues with date format YYYY.MM.DD as used by some chinese clients I replaced PrepareSQLDate (Format(Range(EffectiveDateCell), “dd-mmm-yyyy”)) with PrepareSQLDate(CDate(Range(EffectiveDateCell)) Specific error was in GetInputValidations but there were more than 100 cases. Refresh of Core code (v205)

3.3.04 (24-Oct-2012)

Removed references to SQLString (replaced with prepare_string) because of chinese character issues Set the form positionings correctly

3.3.03 (18-Sep-2012)

ProcessProcedureData removed from calls.  Chinese character conversion issues

3.3.02 (17-Sep-2012)

Generic, Menu and connection code updated

3.3.01 (24-Aug-2012)

Renamed ‘Reason’ to ‘Entry Reason’ for customer

3.3.00 (08-Aug-2012)

Ribbon enabled and generic refresh version 201.18

3.2.11 (02-Apr-2012)

Put the generic code in again and used it as a guinea pig for the URL form changes

3.2.10 (26-Nov-2011)

Common code updated to version 177

3.0.09 (29-Jun-2010)

Minor Change, ‘Set Up Worksheet’ has new wording and link

3.0.08 (03-Jun-2010)

Generic modules updated

3.0.07 (07-Apr-2010)

Several updates. Generic Modules updated, toolbar functionality improved, right-mouse-click toolbar options now available. Bug Fix: DateEffectiveChange in header now set to null if

3.0.03 (14-Dec-2009)

Several updates. Updated common modules moved into wizard. Calendar/date formatting corrected. Batch Source and Payroll are now optional in header form. Employee Name and Assignment search enhanced. Removed any validation if cancel is selected from Lines form

3.0.00 (17-Feb-2009)

Initial Release. Element Entry Wizard is based on our older tool, HR Element Wizard. It has been renamed and significantly upgraded