2.3.37 (10-Sep-2025)

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

2.3.36 (01-Sep-2025)

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

2.3.35 (10-Apr-2025)

Default Browser Login - Fixed bug where the browser would not navigate away from the homepage. This stopped the login process from completing.

2.3.34 (13-Dec-2024)

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

2.3.33 (04-Oct-2024)

Added Default Browser Login option.

2.3.32 (06-May-2024)

Internal updates.

2.3.31 (16-Apr-2024)

Agreement Context substitution fix.

2.3.30 (15-Apr-2024)

Agreement context substitution fix.

2.3.29 (22-Mar-2024)

"Funding Reference" and "Agreement Reference" should be optional fields.

2.3.28 (04-Mar-2024)

Fixed Manage Template error.

2.3.27 (18-Dec-2023)

Fixed error when trying to copy a previously copied template that hadn't been saved yet.

2.3.26 (23-Nov-2023)

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

2.3.25 (30-Apr-2023)

Internal update.

2.3.24 (28-Mar-2023)

Internal updates.

2.3.23 (28-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

2.3.22 (19-Sep-2022)

Internal update.

2.3.21 (19-Sep-2022)

Internal update.

2.3.20 (18-Jul-2022)

Internal update.

2.3.19 (20-May-2022)

Fixed - When Funding level errors but the Agreement is created. Agreements cannot be downloaded back to the sheet.

2.3.18 (28-Apr-2022)

Internal update.

2.3.17 (26-Apr-2022)

DFF form reference issue fixed.

2.3.16 (22-Apr-2022)

Added 'Sheet Filter Batch Size' functionality via the Download Settings form.

2.3.15 (20-Apr-2022)

Internal update.

2.3.14 (21-Feb-2022)

Custom Query update with SQL injection fixes.

2.3.13 (18-Oct-2021)

Add read only columns in Funding section.

2.3.12 (12-Oct-2021)

Add read only columns in Agreement section.

2.3.11 (02-Sep-2021)

Delete Edit Links from Data tab.

2.3.10 (14-Jul-2021)

Internal update.

2.3.09 (01-Jun-2021)

Fixed error in SQL query when downloading from form.

2.3.08 (17-May-2021)

Updated security.

2.3.07 (03-May-2021)

Updated security.

2.3.06 (05-Mar-2021)

Updated security.

2.3.05 (03-Nov-2020)

Updated security.

2.3.04 (08-Jul-2020)

Product code does not get created in EBS.

2.3.03 (02-Jul-2020)

Security updated.

2.3.02 (10-Mar-2020)

Internal updates.

2.3.01 (03-Mar-2020)

Fixed - Funding Form filters Task Name/Number based on Project Name/Number.

2.3.00 (02-Mar-2020)

Rebranding Logo and colors.

2.2.15 (16-Dec-2019)

Error in SQL query when uploading all.

2.2.14 (12-Dec-2019)

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

2.2.13 (09-Aug-2019)

Internal update.

2.2.12 (29-Jul-2019)

Internal update.

2.2.11 (10-Jul-2019)

Updated security.

2.2.10 (10-Jul-2019)

Fixed Create Baseline.

2.2.09 (27-Jun-2019)

Fixed the issue of not clearing the error message while doing the bulk upload.

2.2.08 (25-Jun-2019)

Added Profile Option (More4Apps: AFW Enable Extension Pkg) to enable Extension package.

2.2.07 (25-Jun-2019)

Fixed the issue of getting VBA error 1001 (Key SEC not found in WDOMRow) while bulk upload.

2.2.06 (25-Jun-2019)

Fixed the issue funding section disabled on r11.

2.2.05 (21-Jun-2019)

Rewrote the extension package for the wizard as C3 standard to validate Agreement.

2.2.04 (14-Jun-2019)

Disable the delete functionality for Agreement and Funding section.

2.2.03 (07-Jun-2019)

Fixed the issue of not defaulting reference Column for Agreement and Funding section while doing update.
Fixed the issue of not validating all required/mandatory columns when using Validate All option.
Fixed the issue of not erroring on parent section when child section errors.

2.2.02 (06-Jun-2019)

Internal updates.

2.2.01 (04-Jun-2019)

Fixed the issue of Creating/Updating Funding when baseline funding fails.

2.2.00 (30-May-2019)

Fixed the issue not downloading all Agreements using download form and passing Creation Date to and from.
Renamed columns: Start Date, Source Template, Project Organization, Funding Category, Funding Classification, Project Type, Project Status to Project Start Date, Project Source Template, Project Organization, Project Category, Project Classification, Project Type, Project Status.
Correct Setup Trial Sheet text by removing Party, Customer and Site and changing to Agreements and Funding.
Moved column 'Budget Type Code' to the right-hand side of 'Create Baseline' column.

2.1.08 (30-May-2019)

Fixed the issue of not uploading the Funding Descriptive Flexfields into Oracle.

2.1.07 (27-May-2019)

Internal update.

2.1.06 (27-May-2019)

Fixed the issue of getting SQL error while creating Agreements and Passing advance amount.

2.1.05 (27-May-2019)

Internal updates.

2.1.04 (21-May-2019)

Fixed issue - Baseline a project funding while funding is not Create/Update.
Added Example Sheet.

2.1.03 (17-May-2019)

Fixed the issue of getting SQL error while creating the funding and baseline it.
Fixed the issue of creating funding records which do not have Agreement Action column and Agreement ID and attaching it to another parent agreement.

2.1.02 (13-May-2019)

Fixed the issue of not validating Start Date From/To on the Download Form.
Fixed the issue of searching the Project Number when required column Customer and Currency are missing.

2.1.01 (10-May-2019)

Fixed the issue of missing mandatory/required field not set in the Wizard.
Fixed the issue of not getting error message when no 'Action Mode' values specified for an entire record.

2.1.00 (09-May-2019)

Internal updates.

2.0.05 (03-May-2019)

Rewrote the Upload Procedure as per common architecture Version 3 standards.

2.0.04 (22-Mar-2019)

Fixed the issue of getting SQL error while download Agreement and Funding using Project Status as a filter on the Download form.

2.0.03 (20-Mar-2019)

Fixed the issue of getting SQL error while using Download via sheet option.

2.0.02 (18-Mar-2019)

Added tooltip to Download via sheet includes columns (Agreement ID, Agreement Number, Customer Number, Customer Name, Type, Administrator, Organization, Currency Code, Expiration Date, Funding ID, Project Number, Project Name, Task Number, Task Name, Budget Type Code, Date Allocated).
Added Funding Category and Funding Classification column into Download Form.
Fixed the issue of getting SQL parse error while downloading Agreement and Funding.

2.0.01 (25-Feb-2019)

Download Form: Changed the Customer Order field to searchable.
Fixed the issue of getting SQL error while deleting funding.
Fix the issue of getting SQL error while download Agreements using Project and Start Date as criteria.

2.0.00 (16-Aug-2018)

Converted to common architecture Version 3.6.06

1.3.85 (04-Oct-2018)

Enabled missing End to End Trace functionality on right click menu.

1.3.84 (03-Oct-2018)

Enabled the End to End Trace functionality.

1.3.83 (02-Oct-2018)

Fixed issue getting SQL error invalid identifier while downloading Agreement using Download form and passing date range.

1.3.82 (01-Oct-2018)

Fixed issue of not validating Date in form and while loading Agreements and Funding.

1.3.81 (01-Oct-2018)

Updated Security.

1.3.80 (03-Aug-2018)

Implemented Summary Download functionality to download Summary columns.

1.3.79 (04-May-2018)

Internal update.

1.3.78 (04-May-2018)

Fixed the issue of downloading Duplicate Funding Summary Amounts and Incorrect Summary Agreement Amounts.

1.3.77 (26-Apr-2018)

Fixed the issue of not downloading data Funding Revenue Amount column on the sheet.
Added new column Project Functional Net Revenue column (read only) into the Wizard.

1.3.76 (18-Apr-2018)

Internal fix.

1.3.75 (18-Apr-2018)

Internal fix.

1.3.74 (17-Apr-2018)

Internal fix.

1.3.73 (17-Apr-2018)

Internal fix.

1.3.72 (09-Apr-2018)

Added new columns Agreement (Summary Amount, Allocated, Baselined, Allocated, Not Baselined, Net Revenue, Invoiced Amount, Revenue Write-Off, Not Allocated) and Funding (Funding Unbaselined, Funding Baselined, Funding Revenue, Funding Invoiced, Funding Revenue, Writeoff, Balance Available).
Added new Profile Option 'More4Apps: AFW Enable Summary Funding Download' to enable the Funding Summary download.

1.3.71 (12-Feb-2018)

Internal update.

1.3.70 (12-Feb-2018)

Added 'Custom Query' option to the right click menu.

1.3.69 (12-Feb-2018)

Internal Update.

1.3.68 (12-Feb-2018)

Internal update.

1.3.67 (01-Feb-2018)

Updated security.

1.3.66 (03-Oct-2017)

Updated security.

1.3.65 (27-Jun-2017)

Internal update.

1.3.64 (21-Jun-2017)

Internal update.

1.3.63 (19-Jun-2017)

Bug fix.

1.3.62 (13-Jun-2017)

Fix the issue of getting VBA while downloading Agreement using 'Download via Sheet' and passing agreement ID.

1.3.61 (22-May-2017)

Internal update.

1.3.60 (06-Mar-2017)

Updated Security.

1.3.59 (01-Mar-2017)

Internal fix.

1.3.58 (02-Feb-2017)

Updated Security.

1.3.57 (27-Jan-2017)

Internal update.

1.3.56 (27-Jan-2017)

Updated Security.

1.3.55 (27-Jan-2017)

Removed the Disclaimer notice from the Setup sheet.

1.3.54 (10-Jan-2017)

Internal fix.

1.3.53 (10-Jan-2017)

Fixed Agreement & Funding Wizard Setup tab not showing on Ribbon.

1.3.52 (10-Jan-2017)

Added client Customization to download agreements using DffAttribute4 and DffAttribute19.

1.3.51 (05-Jan-2017)

Added Agreement Organization as a criteria on Download form.
Added Downloader functionality to Wizard.

1.3.50 (07-Jul-2016)

Updated security.

1.3.49 (18-Jul-2016)

Updated Security.

1.3.48 (03-Jun-2016)

Wizard Password updated.

1.3.47 (16-May-2016)

Re-fix the issue of getting error "PL/SQL: numeric or value error: character to number conversion error" while creating agreements.

1.3.46 (13-May-2016)

Re-fix the issue of getting error "PL/SQL: numeric or value error: character to number conversion error" while creating agreements.

1.3.45 (07-Apr-2016)

Fix the issue of getting error "PL/SQL: numeric or value error: character to number conversion error" while creating agreements.

1.3.44 (17-Mar-2016)

Fix the SQL error while creating baseline funding.

1.3.43 (16-Mar-2016)

Removed load_counter profile option.

1.3.42 (04-Mar-2016)

Re-enable the profile for Override the Call for Public API with Private.
Re-enable the functionality to create baseline funding using private API.

1.3.41 (02-Mar-2016)

Updated security.

1.3.40 (03-Feb-2016)

Added Create Baseline to Wizard toolbars for Excel 2003

1.3.39 (02-Feb-2016)

Updated Security

1.3.38 (26-Jan-2016)

Tidy up error message for "No Agreement Number Found" while downloading Agreements & Funding.
Fix the issue of getting incorrect message while downloading agreements.
Trim the error message while creating baseline funding using the wizard.

1.3.37 (18-Jan-2016)

Commented out the call to set the profile More4Apps AFW: Baseline Funding API Override.
Cleaned up the messages while downloading Agreements & Funding.
Fix the issue of getting not helpful while baselining a project using Agreements & Funding.
Fix the issue of not getting confirmation of download complete.
Fix the issue of getting weird information on the left status bar while downloading Agreements & Funding.
Fix the issue of not getting any message while using Create Baseline Functionality.

1.3.36 (22-Dec-2015)

Change the security message while downloading Agreements & Funding

1.3.35 (01-Dec-2015)

Added a check for Download limited while download agreements using download from sheet

1.3.34 (10-Nov-2015)

Core 212 imported

1.3.33 (04-Oct-2015)

Internal Improvement

1.3.32 (21-Oct-2015)

Internal Improvements

1.3.31 (03-Sep-2015)

Removed "Project Name" from the Error Message for incorrect Project Number

1.3.30 (13-Aug-2015)

Updated Security

1.3.29 (26-Jun-2015)

Fixed the issue of not stopping the agreement download if user enters incorrect AgreementID in the download form

1.3.28 (16-Jun-2015)

Removed Project Name as a criteria for upload

1.3.27 (02-Apr-2015)

Fixed the issue of getting incorrect error message while creating baseline funding

1.3.26 (31-Mar-2015)

Fixed the issue of getting error message "Msg1: Your current responsibility does not have access to this function"

1.3.25 (24-Mar-2015)

Fix for error message using Project ID

1.3.24 (24-Mar-2015)

Fix for getting duplicate error message while creating baseline

1.3.23 (13-Mar-2015)

Added a check for Profile 'M4APS_AFW_BASELINE_FUNDING_API_OVERRIDE'.
Added a call to create baseline funding using private API call.

1.3.22 (13-Mar-2015)

Added a profile to override call Baseline Funding

1.3.21 (12-Mar-2015)

Fix the issue of not handling user exception errors while creating baseline funding

1.3.20 (10-Mar-2015)

Added a check to find out baseline funding patch is applied or not

1.3.19 (24-Feb-2015)

Used ‘'Rejection Reason' column to display Baseline funding error message

1.3.18 (20-Feb-2015)

Added checkbox 'Create Baseline' in main ribbon/toolbar.
New functionality added to create baseline funding without budget using Agreement and Funding Wizard.

1.3.17 (17-Dec-2014)

Updated Security

1.3.16 (04-Dec-2014)

Added afwMain.GetDownloadLimit uploaddownlimit varaible in the function and changed call processproceduredata to processBlockData to fix error

1.3.15 (18-Nov-2014)

Changed procedure DFFForm.Get_segments_LOV
Values are being returned that are out of the search criteria
Affects - Table based validation sets with 'OR' operators in the WHERE clause
Changed the way the filter is added to the sql. SQL is now surrounded by an outer select and our filter is applied to the outer select eg [Select * from (sql) where b ="Smith%"]
Changed procedure DFFmod.Convert_ID2Value
Multiple values are being brought back. Most of these values do not match the ID being converted. Only one value should be returned
If multiple values are returned they should at least match the ID being converted
The code is choosing the first value - which doesn’t necessarily correspond with the right value
Affects - table based validation sets with 'OR' operators in the WHERE clause

1.3.14 (18-Nov-2014)

Core code Version 210 imported

1.3.13 (15-Oct-2014)

Added the changes in AFWSectiondata.validate for Dff and updated the version

1.3.12 (14-Oct-2014)

Fixed the Validation procedure to display the DFF validation errors in the Rejection Reason/Status cols

1.3.11 (08-Oct-2014)

Added check under AFWSectiondata.Download by comparing it with default table and Override view for download table to display error msg if No Agreement ID is found if downloading from the sheet
Added a Check for Agreement ID exist on the view based on profile option 'UPDATE_OVERRIDE_VIEW' under AFWSectiondata.Upload
Added check under AFWAgreement.AgreementGenericSQL for Agreement ID exists based on the 'DOWNLOAD_OVERRIDE_VIEW' Profile
Create Custom Profile UPDATE_OVERRIDE_VIEW & DOWNLOAD_OVERRIDE_VIEW under AFWSetup.Custom_Install

1.3.10 (02-Oct-2014)

Fixed wording changes for display message for 'Agreement ID ' field reference.
Added Ellipse button and change the txtCustomerOrderNumber to CboCustomerOrderNumnber in Download form.
Change AgreementID single text to From and To (Agreement ID field in Download form should have a range) in download form.
Added check for OverrideTable in DownloadSelected and Download in AFWDownload to display override table if user enters using CustomizeLOV.

1.3.09 (12-Aug-2014)

Added a check for single agreement download message under AFWDownload.DownloadSelected and AFWDowload.Download

1.3.08 (07-Aug-2014)

Download DFF wasn't converting the first segment so added a forced conversion in AFWSectionData.SSPopulate

1.3.07 (29-Jul-2014)

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

1.3.06 (28-Jul-2014)

Core code Version 209 imported

1.3.05 (19-Jun-2014)

Added Agreement ID Criteria to the Download form

1.3.04 (19-Jun-2014)

Added Customer Order Number criteria to the Download

1.3.03 (17-Jun-2014)

m4aps_afw_extension package call for Rollback to savepoint if extension returns error else continue

1.3.02 (16-Jun-2014)

Change P_Commit value to 'F' under AddNonSectionAPIParameter

1.3.01 (16-Jun-2014)

Added Customize LOV Form used to Override Tables

1.3.00 (09-Jun-2014)

Changes to support the return of warning messages from the m4aps_afw_extension package

1.2.28 (07-Apr-2014)

Migrated to core code 205.32

1.2.27 (03-Mar-2014)

Download via Sheet enabled

1.2.26 (28-Feb-2014)

ADVANCE_REQUIRED, START_DATE, BILLING_SEQUENCE, ADVANCE_AMOUNT are not present in some patch levels.
Added handling to restrict their use to when is appropriate.
Fixed validation reporting error which was causing bad formatted return messages in ‘Rejection Message’ column.

1.2.25 (19-Feb-2014)

Download via Project query makes use of PA_PROJECTS all and the PA_PROJ_FUND_VALID_V_M4A view

1.2.24 (19-Feb-2014)

Created view PA_PROJ_FUND_VALID_V_M4A (in the wizard) because the view pa_proj_fund_valid_v is unreliable
since pa_multi_currency_billing.is_funding_across_ou_allowed returns NULL so I have wrapped that part of the qry in nvl()

1.2.23 (19-Feb-2014)

Fixed the download via Project LOV to be independent of Customer

1.2.22 (11-Feb-2014)

Added Project and Project Functional Currency Exchange Rate support
Refresh of Core code to version 205.27

1.2.21 (23-Jan-2014)

Corrected error messages which referred to Employees rather than Agreements

1.2.20 (19-Nov-2013)

Re-added Project-Customer Number link validation rule (Customer must exist to select Project)

1.2.19 (08-Nov-2013)

Correct the format of start date in download SQL and restored the order for agreement reference

1.2.18 (07-Nov-2013)

Added columns Start Date, Billing Sequence, Advance Required and Advance Amount (only for download)

1.2.17 (06-Nov-2013)

Fixed the download form which was caching Agreement numbers and not adding newly created Agreements to the search list

1.2.16 (23-Oct-2013)

Removed reference to European characters when defining ColumnsWidth property on forms controls
“pt” is dropped and “;” is replaced with Application.International(xlRowSeparator)

1.2.15 (30-Jul-2013)

Improvements for Time Efficiency

1.2.14 (23-Jul-2013)

Common code refresh (Version 205)

1.2.13 (22-Jul-2013)

Fixed the Prepare_String()logic around the LOVs and search LOVs

1.2.12 (19-Jul-2013)

Project Name LOV query fixed for Case 5333

1.2.11 (04-Jul-2013)

DFF correctly cleared out now on logout.  Agreement DFF fields correctly initialised

1.2.10 (04-Jul-2013)

Funding DFF button was invisible on new Agreement edit form (when opened on empty row).  This has been fixed

1.2.09 (07-Jun-2013)

Removed duplicate funding upload issue (p_StateBlock=Empty)

1.2.08 (31-May-2013)

Added the checks for Agreement.Customer_Order_Number and Agreement.Attribute 11 instead of relying on r12 as trigger for column inclusion

1.2.07 (30-Apr-2013)

Added Common Code version 203 from CORE

1.2.06 (02-Apr-2013)

Conversion method change for 1.2.05 change (see AFWValidation.ConvertNumberForm)

1.2.05 (21-Mar-2013)

Core Ribbon, Generic and connection code refresh and fix for 11.5.7 versions with no pa_agreements_v.customer_order_number column.
Added Convert Num to US format for French customers experiencing numeric conversion errors.
Package Header version required:  1.0.1

1.2.02 (18-Oct-2012)

Ribbon code enabled
SSO Bypass enabled as login method
Switched R12-only columns on/off at init and download
Removed bug which forced Project Name to be present in DB Validations (even though it is non mandatory)

1.1.16 (28-Jun-2012)

Agreement and Funding DFFs enabled
Customer Order Number now supported at Agreement Level
Bug removed in Download by Project Filter
API Log enabled in toolbar

1.1.12 (03-Oct-2011)

Updated common modules (common code) to Version 177

1.0.06 (21-Dec-2010)

First Release