9.2.52 (07-Mar-2025)

Internal bug fix.

9.2.51 (25-Feb-2025)

Enhanced the Wizard - It will now function using the right-click-menu, when the More4apps ribbon tabs are unavailable.

9.2.50 (28-Jan-2025)

Fixed issue where Preparer Name fails More4apps Servlet Security S12.

9.2.49 (13-Dec-2024)

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

9.2.48 (15-Nov-2024)

Fixed bug where Tax Code loaded from the Wizard did not appear in the Oracle Transaction (Requisition).

9.2.47 (17-Oct-2024)

Internal update.

9.2.46 (15-Oct-2024)

Added Default Browser Login option.

9.2.45 (18-Dec-2023)

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

9.2.44 (01-Nov-2023)

Fix for bug where the End-to-End Trace might not return the SQL Statement's execution plan.

9.2.43 (03-Oct-2023)

Added new digital signature.

9.2.42 (01-Sep-2023)

Internal update.

9.2.41 (26-Jul-2023)

Internal update.

9.2.40 (25-Jul-2023)

Made Supplier Contact a free type field allowing a selection from the provided LOV of existing values or the entry of a new value.

9.2.39 (31-Mar-2023)

Improved the performance of the Line Num LOV query.

9.2.38 (24-Mar-2023)

Fixed issue where upload would incorrectly continue after encountering a quantity error.

9.2.37 (20-Mar-2023)

Fixed type mismatch error when attempting to update requisition lines with a quantity when database value was null.

9.2.36 (06-Mar-2023)

Internal update.

9.2.35 (28-Feb-2023)

Fixed further issues where the Exchange Rate column was triggering a 'Security Violation' error.

9.2.34 (24-Feb-2023)

Fixed issue where the Exchange Rate column was triggering a 'Security Violation' error.

9.2.33 (27-Jan-2023)

Fixed 11i Revision Error: "Error in XML processing ORA-00923: FROM keyword not found where expected".

9.2.32 (20-Jan-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.

9.2.31 (09-Jan-2023)

Internal update.

9.2.30 (02-Dec-2022)

Internal update.

9.2.29 (06-Sep-2022)

Updating Licencing Modules.

9.2.28 (12-Jul-2022)

Internal update.

9.2.27 (08-Jun-2022)

Requisition and Update Requisition Modes: Undone and set-up back the implementation carried out in version 9.2.23

9.2.26 (08-Jun-2022)

Internal update.

9.2.25 (19-May-2022)

For Blanket download function fixed the issue where the item description was not downloading.

9.2.24 (17-May-2022)

Internal update to fix the issue where concurrent program parameters (ie 'Initiate Approval after ReqImport') were not defaulting correctly.

9.2.23 (27-Apr-2022)

Requisition and Update Requisition modes: Enhancement on validator queries for Accounts columns which check the first segment being valid according to the organization.

9.2.22 (19-Apr-2022)

Fixed issue where concurrent program parameters (ie 'Initiate Approval after ReqImport') were not defaulting correctly.

9.2.21 (11-Apr-2022)

Fixed the style of the Setup sheet follow the standards.

9.2.20 (01-Apr-2022)

Internal update.

9.2.19 (30-Mar-2022)

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

9.2.18 (25-Mar-2022)

Internal update.

9.2.17 (23-Mar-2022)

Requisition mode: Improved LOVs for Requestor and Requestor Number columns to fix an issue regarding values not found in the list.

9.2.16 (17-Mar-2022)

Internal update.

9.2.15 (25-Feb-2022)

Requisition mode: Improved Template Download mode which orders now the lines based on their number.
Iprocurement: Fixed issue on Template Download mode since it was downloading records of a different template from the template selected by the user. Lines ordering based on line number.

9.2.14 (23-Feb-2022)

Requisition mode: The accounts workflow validation is no longer called after uploading attachments. This was causing an accounts generation issue for already created requisitions.

9.2.13 (16-Feb-2022)

Standard mode: Fixed issue on Exchange Rate column which was ignoring the numeric environment (Windows) configuration e.g. European setup. This made to upload wrong values to Oracle.
Added 'Sheet Filter Batch Size' functionality via the Download Settings form.

9.2.12 (20-Jan-2022)

Custom Query update with SQL injection fixes.

9.2.11 (07-Dec-2021)

Update Mode - Fixed issue on Download Form when using the Status column as part of the criteria.

9.2.10 (29-Nov-2021)

Update Mode - Fixed issue when the following columns do not turn green after a successful upload: Exchange Rate, Need By Date and Charge Account.

9.2.9 (26-Nov-2021)

Fixed issue on Template Download mode since it it was downloading records of a different template from the templated selected by the user.

9.2.8 (15-Nov-2021)

Internal update.

9.2.7 (12-Nov-2021)

Internal update.

9.2.6 (10-Nov-2021)

Update Mode - Improved the warning message when Submit for Approval is Y but there is no header action. Remove Add action for lines and distributions.

9.2.5 (08-Nov-2021)

Fixed issue when common code does not default values for concurrent program window fields.

9.2.4 (05-Nov-2021)

Update Mode - Improved the API call which now allows to be called for approved requisitions. Added warning when Submit for Approval is Y but the header action is empty.

9.2.3 (28-Oct-2021)

Update Mode - Fixed Bulk for Submit for Approval, API error when a requisition is already Approved, Source Organization LOV refactored and the issue when defaulting the Preparer.

9.2.2 (26-Oct-2021)

Update Mode - Fixed issue when submitting for approval requisitions with multiple lines.

9.2.1 (21-Oct-2021)

Fixed issue on validation query for Expenditure Type column.

9.2.00 (21-Oct-2021)

Update Mode - Added Submit for Approval functionality.

9.1.16 (04-Oct-2021)

Fixed issue with auto-generation of distribution numbers when empty columns.

9.1.15 (04-Oct-2021)

Internal update.

9.1.14 (04-Oct-2021)

Internal update.

9.1.13 (23-Sep-2021)

Internal update.

9.1.12 (08-Sep-2021)

Fixed issue when Wizard prints a PL-SQL exception error on cells A1 and A2 of the sheet.

9.1.11 (08-Sep-2021)

Fixed issue in iProc mode when UOM is being defaulted for Fixed Price line types. Fixed issue on standard mode when the item revision does not belong to the Destination Organization.

9.1.10 (06-Sep-2021)

Fixed 'Price must be numeric' error when using "," as your Windows decimal symbol.

9.1.09 (31-Aug-2021)

Fixed upload error when using iProcurement mode and profile option 'More4apps RW: Default from Document Line' was set to 'Yes'.

9.1.08 (30-Aug-2021)

Fixed PLSQL errors when uploading in iProcurement mode.

9.1.07 (27-Aug-2021)

Unchecked 'Logging' by default. Extension Package Enabled now displays correctly in the 'About' form.

9.1.06 (26-Aug-2021)

Fixed minor performance issue when uploading.

9.1.05 (26-Aug-2021)

'Extension Package Enabled' now displays the correct value in the About form.

9.1.04 (26-Aug-2021)

Fixed 'Invalid Value for PROJECT_ACCOUNTING_CONTEXT' error when uploading Project information. Fixed ORA-06550 error when Extension Package is enabled.

9.1.03 (23-Aug-2021)

Fixed issue where Pending status was not written to the sheet during upload. Pending header status is no longer written as there is no associated interface table.

9.1.02 (20-Aug-2021)

Fixed ORA-06550:line 2 error when validating and calling account generator workflow.

9.1.01 (20-Aug-2021)

Added additional functionality to Extension Package.

9.1.00 (17-Aug-2021)

Added Extension Package functionality.

9.0.27 (11-Aug-2021)

Internal update.

9.0.26 (10-Aug-2021)

Update mode - Fixed line quantity validator to check if the distribution upload action column has a default value on row 10.

9.0.25 (05-Aug-2021)

Update mode - Validation when line quantity changes, then the upload action for its distributions is mandatory.

9.0.24 (28-Jul-2021)

Update mode - Improved the warning message when trying to update a distribution under an item-based line.

9.0.23 (22-Jul-2021)

Update mode - Added validation for matching quantity line columns with corresponding distribution columns. Removed not supported Autosource columns: Doc Type, Doc Number, Doc Line, Contact Info.

9.0.22 (09-Jul-2021)

Fixed bug when updating an Exchange Rate based on User defined type.

9.0.21 (06-Jul-2021)

Fixed the upload and download for Exchange Rate field. Now the Wizard uses the actual conversion rate rather than the sheet value, as it might be the inverse value, which is not correct.

9.0.20 (02-Jul-2021)

Update mode - Fixed download to restrict just Approved and Incomplete status. Quit Creation Date on header section.

9.0.19 (30-Jun-2021)

Fixed error with an invalid character when adding-updating. Fixed comments for Cancelled and Closed columns.

9.0.18 (28-Jun-2021)

Update mode - fixed the creation date download criteria on lines and validation for cancelled and finally closed lines.

9.0.17 (22-Jun-2021)

Added enhancements for 'Update Requisition' mode regarding validation and warning messages to the user.

9.0.16 (11-Jun-2021)

Removed incorrect validation that prevented from providing a 'Req Forward to Value' when the 'Status' was not 'Approved'.

9.0.15 (27-May-2021)

Fixed 'value not found error' for line and distribution number after adding line/distribution.

9.0.14 (26-May-2021)

Fixed validation that ensures Distributions of item-based lines must not update their Charge Account field.

9.0.13 (25-May-2021)

Fixed "unsupported character set" error when downloading.

9.0.12 (25-May-2021)

Fixed error when logging in - Error 9 (Subscript out of range in procedure ExecuteMultiCall of Module fndGeneric.
Fixed incorrect Template mode download results.
Added substitution for :SYSTEM.CURRENT_FORM.

9.0.11 (25-May-2021)

New mode implementation 'Update requisition', which allows to update a requisition and add new lines and distributions.

9.0.10 (13-May-2021)

Fixed out of stack space error when selecting a Template.

9.0.09 (06-Apr-2021)

Updated security.

9.0.08 (26-Mar-2021)

Updated security.

9.0.07 (19-Mar-2021)

Updated architecture to resolve issues with Templating.

9.0.06 (18-Mar-2021)

Fixed error when uploading long descriptions with special characters.

9.0.05 (04-Feb-2021)

Project information can now be entered irrespective of Destination Type.

9.0.04 (21-Jan-2021)

Corrected the minimum package versions.

9.0.03 (21-Jan-2021)

Requisition Import Parameter 'Initiate Approval after ReqImport' will now respect the default in the parameter Setup rather than defaulting to 'No'.

9.0.02 (11-Jan-2021)

Blanket and Quotation download will now populate an 'Incomplete; status to prevent orphan data issues.

9.0.01 (17-Dec-2020)

Purchase Order download will now populate an 'Incomplete' status to prevent orphan data issues.

9.0.00 (07-Dec-2020)

Internal update.

8.1.13 (12-Nov-2020)

Fixed error on refresh when Line Attachment columns were removed from the sheet.

8.1.12 (05-Nov-2020)

Fixed issue where multiple tasks on the sheet would not validate correctly.

8.1.11 (27-Oct-2020)

Extension package disabled as it requires a dependent architecture upgrade to function correctly.

8.1.10 (27-Oct-2020)

DFF Attribute values are now passed to the Account Generator workflow.

8.1.9 (01-Oct-2020)

Updated security.

8.1.8 (22-Sep-2020)

Fixed performance issues when validating certain fields ie Task.

8.1.7 (27-Aug-2020)

Interface download form now defaults the date to today.

8.1.6 (26-Aug-2020)

When using partial sourcing Site and PO information will no longer default values if the Supplier has been changed from the source default.

8.1.5 (25-Aug-2020)

Fixed validation of project fields - Can now enter project information with a Destination Type of Inventory if Project Reference is enabled in the configuration.

8.1.4 (18-Aug-2020)

Fixed error when uploading when a very large batch ID was on the sheet.

8.1.3 (18-Aug-2020)

Changed trial upload limit to five lines.

8.1.2 (06-Aug-2020)

Performance improvements.

8.1.1 (17-Jul-2020)

Fixed error 9999 when refresh when header attachment columns are not on the sheet.

8.1.0 (06-Jul-2020)

Added extension package functionality.

8.0.30 (01-Jul-2020)

Updated security.

8.0.29 (04-Jun-2020)

Updated security.

8.0.28 (03-Jun-2020)

Fixed error on upload when line number column was not on the sheet.

8.0.27 (21-Apr-2020)

The field 'Dist Context' is disabled on the form and can still validate LOVs showing corresponding error messages.

8.0.26 (20-Apr-2020)

Fixed issue where the Contact would not upload correctly.

8.0.25 (15-Apr-2020)

Fixed issue where line attachments would not upload if there were no header attachments on the row.

8.0.24 (02-Apr-2020)

Updated security.

8.0.23 (25-Mar-2020)

Source Organization is no longer required for Source Type 'Inventory' since the import program can derive this.

8.0.22 (20-Mar-2020)

Rebranding of Logo and color scheme.

8.0.21 (18-Feb-2020)

Fixed issue where distributions would remain 'Pending' when refreshing and the Line has errors, resulting in lines being uploaded without distributions when correcting the line.

8.0.20 (04-Feb-2020)

Fixed issue where distribution import error messages were not populating into the sheet when refreshing.

8.0.19 (03-Feb-2020)

Fixed issue where the Price would not default correctly for internal inventory items.

8.0.18 (14-Jan-2020)

Error 438 fixed using Custom Query download.

8.0.17 (10-Jan-2020)

SQL error when searching for Catalog Supplier Item.

8.0.16 (31-Dec-2019)

Corrected Document Line Number upload.

8.0.15 (30-Dec-2019)

Changed document line LOV to return correct data.

8.0.14 (11-Dec-2019)

Wizard is relying on requisition_line_id for joins. It is the wrong field to base our upload/download join between lines and distributions.

8.0.13 (06-Dec-2019)

Form fndLogin deleted.

8.0.12 (03-Dec-2019)

Updated security.

8.0.11 (22-Nov-2019)

Major update for Common, Core and Custom Query. Firewall compliant encoding added.

8.0.10 (12-Nov-2019)

In Distributions section, the Charge, Accrual and Variance Account combinations LOVs are not sorted in any order.

8.0.9 (07-Nov-2019)

Line type is not populated when downloading under the Interface Download Mode.

8.0.8 (06-Nov-2019)

Updated security.

8.0.7 (16-Oct-2019)

Website release of major upgrade:
- Improved with new colours.
- Improved performance.
- Added Modes: Requisition and iProcurement.
- Added ability to manage worksheets with template functionality.
- Sourcing Rule options previously available in ribbon, now replaced by a new column 'Autosource'. Sourcing tab available in the Requisition Line form.

7.3.14 (06-Dec-2018)

Fixed SQL errors when downloading via sheet using Requestor Number or Tax Code as criteria.

7.3.13 (05-Dec-2018)

Fixed closed requisition numbers not appears in the LOV in the Download form.
Fixed "column ambiguously defined" error when validating Catalog Supplier Item.
Fixed incorrect invalid Supplier Site in LOV.

7.3.12 (04-Dec-2018)

Fixed error when searching in the download form after clicking the "Stop Processing" button in the processing form.
Default row will now be part of the "Freeze Panes" when creating a new sheet via the "Customize Fields" form.

7.3.11 (03-Dec-2018)

Fixed error when downloading a requisition using 64bit Excel.

7.3.10 (30-Nov-2018)

Fixed 64bit freezing/crashing issue when loading a form.

7.3.09 (31-Oct-2018)

Fixed bug where download would return the employee number for ex-employees in the requestor number field, when it should be the NPW number.
Fixed bug where uploading a requestor name with multiple available numbers would always upload the first number, regardless of what was chosen.

7.3.08 (30-Oct-2018)

Fixed additional issues with Requestor Number.

7.3.07 (30-Oct-2018)

Fixed bug where Requestor Number would not be valid in certain cases e.g. with Requestor "15538, CASENUM" number "165".

7.3.06 (29-Oct-2018)

Fixed bug where Requestor Number would not default for contingent workers, also fixed search for contingent workers in Requestor Number column.

7.3.05 (17-Oct-2018)

Fixed bug where Requestor would error due to uniqueness when it was unique, but multiple users were assigned to the same employee.
Requestor will now trigger validation of Requestor Number and vice versa.

7.3.04 (10-Oct-2018)

Added 'Allow Pop Ups' to Login form.

7.3.03 (09-Oct-2018)

Updated security.

7.3.02 (08-Oct-2018)

Now allowing contingency workers as preparers for customer license name.

7.3.01 (03-Oct-2018)

Fixed error when the following columns were missing from the sheet: Category, Destination Organization, Destination Type, Source Type.

7.3.00 (05-Sep-2018)

Updated security.

7.2.99 (27-Aug-2018)

Added new profile option 'More4Apps: RW Disable Charge Account Overrides' which prevents accounts from being overridden by material account and workflow.

7.2.98 (24-Jul-2018)

Fixed error in Download Form when filtering Purchase orders by type or Requisitions by status.
Fixed error in Download Form when defining a filter for one mode, then switching to another and attempting to download.

7.2.97 (17-Jul-2018)

Requestor Number is no longer dependent on the Requestor columns.
Requestor will no longer default from the preparer if the Requestor Number has been populated.

7.2.96 (01-May-2018)

Updated security.

7.2.95 (27-Jun-2018)

Fixed a bug where requestors would be invalid if they were not users.

7.2.94 (01-May-2018)

Updated security.

7.2.93 (27-Apr-2018)

Added new profile option 'More4Apps: RW Skip Package Account Generation' which disables the call to the account generator workflow in the package.

7.2.92 (24-Apr-2018)

Fixed 'Object or block variable not set' error.
Fixed Destination Org and Location not validating when containing carriage return character (only activated for customer).

7.2.91 (10-Apr-2018)

Replaced 'Downloader' with 'Custom Query'.

7.2.90 (06-Apr-2018)

Customer customization - Added Requestor User Name to help identify the requestor.

7.2.89 (28-Mar-2018)

Added new column 'Requestor Number' to help identify requestors with non-unique names.

7.2.88 (21-Mar-2018)

Fixed bug where the Import Program form would incorrectly default the English value for 'Initiate Approval' regardless of language.

7.2.87 (05-Mar-2018)

Updated Downloader to 'Custom Query'.

7.2.86 (02-Mar-2018)

Updated security.

7.2.85 (26-Feb-2018)

Requestor LOV will now display requestors from multiple business groups.

7.2.84 (07-Feb-2018)

Implemented additional debugging around workflow validation/account generation.

7.2.83 (22-Jan-2018)

'Note to Approver' column length is now based on the length in the column in the database.

7.2.82 (04-Dec-2017)

Updated security.

7.2.81 (30-Nov-2017)

Workflow Generator now passes through header, lines and distribution DFF's.
Note - Requires Package versions: 4.0.8 Body, 4.0.3 Spec in order to use this change.

7.2.80 (08-Nov-2017)

Preparer default is now correctly applying RTRIM on Full_Name Column in SQL.

7.2.79 (07-Nov-2017)

Added ability to show contractors in Preparer SQL under license key check for customer. [Note - Oracle Trace SQL for Preparer column will supersede this customisation].

7.2.78 (12-Sep-2017)

Updated Security.

7.2.77 (01-Sep-2017)

Task LOV on distributions form now also shows 'Task Name'.

7.2.76 (25-Aug-2017)

Suppliers LOV will no longer show inactive Suppliers.

7.2.75 (18-Aug-2017)

Increased the column width of the Flex Combinations combo box to show longer string concatenations.

7.2.74 (16-Aug-2017)

Added Profile Option: 'More4Apps: RW Suppress Account Generation Warning Messages' - which prevents account warning messages showing.

7.2.73 (02-Aug-2017)

Fixed bug with date DFF values incorrectly uploading in the wrong format.

7.2.72 (26-Jul-2017)

Fixed bug where data on Lines Form was not being written to the sheet when Line DFF Context column was removed.
Fixed runtime error on refresh when Line Number column was removed

7.2.71 (26-Jul-2017)

Fixed multiple bugs around validating, sourcing and defaulting on UOM column.

7.2.70 (29-Jun-2017)

Updated Downloader Modules to version 1.0.79

7.2.69 (29-Jun-2017)

Fixed additional issue with new sheet image resizing.

7.2.68 (23-Jun-2017)

Fixed new sheet image resizing.

7.2.67 (20-Jun-2017)

Modified the display of Project Validation messages returned from Oracle workflow to be per distribution.

7.2.66 (19-Jun-2017)

Increased Document Line LOV size from 1000 to 5000.

7.2.65 (06-Jun-2017)

Applied same validation bug fix for Buyer column to Preparer and Requestor columns.

7.2.64 (31-May-2017)

Fixed validation bug between line and distribution quantity/amount totals when values had more than 2 decimal places.
Fixed more issues associated relating to Buyer LOV validation.

7.2.63 (26-May-2017)

Fixed validation bug with Buyer column not matching the sheet value to the database.
Fixed bug where UOM LOV was ignoring case sensitive values.

7.2.62 (26-Apr-2017)

Fixed bug where lines and distributions would not download if the record had a null unit of measure.

7.2.61 (03-Apr-2017)

Updated Security.

7.2.60 (09-Mar-2017)

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

7.2.59 (23-Feb-2017)

Changed the Unit of Measure LOV limit from 1000 to 5000.

7.2.58 (22-Feb-2017)

Changed how the fixes were implemented in versions 7.2.56 and 7.2.57 to be more consistent with following common code standards.

7.2.57 (22-Feb-2017)

Fixed more bugs around correctly default and validated price sheet values not being uploaded.

7.2.56 (20-Feb-2017)

Fixed bug where form validation would correctly default the price but sheet validation would not.
Price and Category columns now always upload the value on the sheet for internal inventory requisitions.
Fixed bug where the correctly defaulted and validated price sheet value was not being uploaded under particular instances.

7.2.55 (16-Feb-2017)

Added Note To Receiver Column.

7.2.54 (14-Feb-2017)

Customer modification.

7.2.53 (08-Feb-2017)

Updated Security.

7.2.52 (02-Jan-2017)

Updated DW Modules Version 1.0.71

7.2.51 (23-Jan-2017)

Fixed unhandled XML document due to patch checking SQL query.

7.2.50 (13-Jan-2017)

Distribution Number now correctly resets per line and not per header.

7.2.49 (13-Jan-2017)

Tax Codes with a percentage symbol in them now correctly validate.
Tax Code now correctly downloads from Oracle created requisitions.

7.2.48 (09-Jan-2017)

Tax Code now correctly downloads in R12.

7.2.47 (05-Jan-2017)

Changed Tax Code LOV to include Global Tax Codes.

7.2.46 (04-Jan-2017)

Updated Security.

7.2.45 (29-Nov-2016)

Customer modification.

7.2.44 (03-Nov-2016)

Fixed SQL Error for Source Organization in 11i.
Fixed bug where selected Validate Option was not registering after using Concurrent Forms.

7.2.43.7 (08-Mar-2017)

Fixed issue where users are being logged in with the wrong language.
Further Information: In EBS 12.2 a framework patch has stopped us from being able to select a language in the browser login page.
To work around this problem the language for the user is now being set from user's EBS preferences irrespective of what is chosen on the Browser Login page.

7.2.43 (12-Oct-2016)

Minor Wizard clean up in preparation for RW Release.

7.2.42 (10-Oct-2016)

Fixed performance issues when opening Lines and Distribution forms.
Fixed tabbing issue on Attachments form.

7.2.41 (07-Oct-2016)

Reverted V7.2.40 changes. Letting the error be recognized as an import error so the issue is understood to not be the Wizards fault.

7.2.40 (30-Sep-2016)

Added a patch check (Patch 19035538) for version 12.2 and higher.

7.2.39 (30-Sep-2016)

Fixed Price column validation bug which would allow any character values.
Fixed ambiguous table column name bug with the Prepare column download SQL.

7.2.38 (28-Sep-2016)

Fixed bugs around the absence of the Item column.

7.2.37 (26-Sep-2016)

Implemented licensing fixes.

7.2.36 (22-Sep-2016)

Minor bug fixes with Download form.
Document Line column now correctly downloads to the sheet.

7.2.35 (15-Sep-2016)

Description validation now correctly displays the appropriate message.

7.2.34 (14-Sep-2016)

Improved validation on Distribution Amount.
Implemented additional validation and bug fixes around using the 'M4APS_RW_DEFAULT_FROM_DOCUMENT' profile option.

7.2.33 (13-Sep-2016)

Added additional validation rules around Category.

7.2.32 (12-Sep-2016)

Minor bug fixes.

7.2.31 (05-Sep-2016)

Fixed minor bugs with the ribbon.

7.2.30 (02-Sep-2016)

Document Line LOV is now ordered by Line Number.

7.2.29 (31-Aug-2016)

Implemented additional validation and bug fixes around using the 'M4APS_RW_DEFAULT_FROM_DOCUMENT' profile option.

7.2.28 (25-Aug-2016)

Fixed download bugs.

7.2.27 (25-Aug-2016)

Fixed issues around Document Line during upload.

7.2.26 (22-Aug-2016)

Reverted performance changes from 7.2.19 as it introduced multiple new issues.

7.2.25 (18-Aug-2016)

Minor error logging adjustments.

7.2.24 (17-Aug-2016)

Minor bug fixes and UI changes on the Download form.
Implemented additional checks and bug fixes around downloading/uploading with absent mandatory columns.

7.2.23 (16-Aug-2016)

Minor bug fixes.

7.2.22 (11-Aug-2016)

Minor bug fixes.

7.2.21 (04-Aug-2016)

Minor ribbon bug fixes with dropdowns.

7.2.20 (03-Aug-2016)

Fixed bugs when using Download Interface.

7.2.19 (01-Aug-2016)

Implemented bug fixes around the profile option 'More4Apps: RW Allow Zero Quantity Upload'.
Increased upload performance, specifically when uploading bulk data.

7.2.18 (29-Jul-2016)

Fixed bug where Requisition numbers were not always being populated on the sheet after refresh.
Fixed bug where errored imported lines and distributions would show as Accepted on sheet.

7.2.17 (20-Jul-2016)

Fixed bug where downloading PO numbers were not bringing the correct values.

7.2.16 (19-Jul-2016)

Implement UI changes on the Customized Fields form.
Added bug fixes when using SPIT.

7.2.15 (15-Jul-2016)

Fixed multi-language issue on the Unit of Measure column. It now returns the correct language of the users’ environment.

7.2.14 (11-Jul-2016)

Fixed bugs and warning messages about uploading data with zero line quantity in specific situations.

7.2.13 (11-Jul-2016)

Improved error handling and implemented bug fixes when using SPIT.

7.2.12 (08-Jul-2016)

Fixed bug where having no lines with quantities would not upload - even if the line type didn't require a quantity (e.g. Fixed Price Services).

7.2.11 (07-Jul-2016)

Fixed bug where downloading records the Exchange Type column could sometimes be populated with ID's instead of Text values.

7.2.10 (06-Jul-2016)

Minor code refactoring changes.

7.2.09 (04-Jul-2016)

Fixed error where form controls on the download form would sometimes become active/enabled when should not be under particular conditions.

7.2.08 (01-Jul-2016)

Added an additional filter to the filter criteria on the download form to enable/disable downloading closed PO's.

7.2.07 (30-Jun-2016)

Expenditure Organization form field now uses LOV search controls.

7.2.06 (30-Jun-2016)

Downloading Purchase Orders via the download form now returns closed and finally closed PO's.

7.2.05 (27-Jun-2016)

Fixed hyperlinks on the Setup page to now correctly direct to RW resources.

7.2.04 (24-Jun-2016)

Further work to better handle failures when special information profile value is set to 'Yes' and there was a failure in the special information part of the upload.

7.2.03 (23-Jun-2016)

Changed upload to better handle failures when special information profile value is set to 'Yes' and there was a failure in the special information part of the upload.

7.2.02 (21-Jun-2016)

Fixed error message popup which occasionally occurred when changing between 'validation only' and 'validate and upload' on the ribbon.

7.2.01 (20-Jun-2016)

Fixed error message popup which occasionally occurred when refreshing the sheet after preforming a concurrent update.

7.2.00 (20-Jun-2016)

Fixed bug in returning Accounts information from the Account Generator Workflow.

7.1.99 (16-Jun-2016)

Fixed error uploading attachments and added new attachment columns.

7.1.98 (13-Jun-2016)

Fixed errors when uploading file attachments.

7.1.97 (10-Jun-2016)

Fixed error on upload when entering line number and patch 17267096 is NOT installed.
Fixed error when downloading from interface.

7.1.96 (09-Jun-2016)

Category and Price are now ignored on upload if the Requisition Type is INTERNAL and Destination or Source Type is INVENTORY.

7.1.95 (01-Jun-2016)

Implemented additional error handling for uploads.

7.1.94 (31-May-2016)

Added additional validation and bug fixes for downloader.

7.1.93 (31-May-2016)

Fixed downloader bugs.

7.1.92 (27-May-2016)

Fixed Wizard freezing and resulting in "Out of Stack Space" error when validating lines/line form.

7.1.91 (24-May-2016)

Fixed downloader bugs.

7.1.90 (20-May-2016)

Fixed SQL Error when validating Document Line.

7.1.89 (19-May-2016)

Line Type, UOM and Price can now be defaulted from the document line.
Fixed issue where PO lines were not being returned in the LOV when their item didn't exist in the inventory organization.

7.1.88 (18-May-2016)

Document Line is no longer required when the Document Type is Contract Purchase Agreement.

7.1.87 (17-May-2016)

Fixed problem where deliver to location would not default when "POR: Preferences - Deliver to Location" was not set and "More4Apps RW use POR: Preferences - Deliver to Location Default" was set.

7.1.86 (16-May-2016)

Fixed refresh bug where line number was always being written into the top row of the requisition. Resulting in the last line number being written into the first line number cell (top row of the requisition).

7.1.85 (13-May-2016)

Fixed Error 91 when validating with an invalid item and blank description.

7.1.84 (12-May-2016)

Fixed error 9999 when uploading foreign currency exchange rates.

7.1.83 (10-May-2016)

Fixed issue where Document Number and Document Line would error when Item wasn't entered.
Fixed Document Line LOV not displaying any values when item wasn't entered.
Added descriptions to Document Number and Document Line LOVs.

7.1.82 (10-May-2016)

Fixed SQL error when attempting to search for a Document Number without first entering the Document Type - The search will now just return nothing.

7.1.81 (09-May-2016)

Fixed bug where logging out would not retain the iProc application ID, causing the restrict iProc responsibilities to not work correctly.

7.1.80 (06-May-2016)

Fixed Error 91 when attempting to upload a requisition with no quantities in the line section.

7.1.79 (02-May-2016)

Added Setup ribbon tab dropdown "iProc Responsibility" to restrict responsibilities to iProc application ID when set Yes.

7.1.78 (27-Apr-2016)

Added profile "More4Apps: RW Skip Account Generation" to skip acct generator workflow call to improve performance.
Additional validation performance improvements.

7.1.77 (27-Apr-2016)

Added functionality to populate Req Number and Header Status on Header rows with no line upload (zero quantity option).

7.1.76 (22-Apr-2016)

Fixed bug where "req number already in use" error would occur when not loading the first line of the requisition.

7.1.75 (22-Apr-2016)

Removed ReqType as mandatory column (will default to Purchase if missing).

7.1.74 (21-Apr-2016)

Fixed upload when profile option "More4Apps: RW Allow Zero Quantity Upload" set to yes.

7.1.73 (20-Apr-2016)

Sped up PO Number LOV SQL for download form.

7.1.72 (15-Apr-2016)

Fixed issue where Itemless Requisitions with Profile option 'More4Apps: RW Enable Document Defaulting'set to N couldn’t determine PO line number.

7.1.71 (13-Apr-2016)

Fixed error where price used ',' as decimal delimiter.

7.1.70 (12-Apr-2016)

Fix to Upload where returned error errors.

7.1.69 (11-Apr-2016)

Fixed issue with Exchange rate date defaulting from Row 10.

7.1.68 (11-Apr-2016)

Check that description matches derived description from item (if flag enabled).

7.1.67 (09-Apr-2016)

Fix for Document Line being invalid when category entered and "More4Apps: RW Enable Document Defaulting" was set to Yes.

7.1.66 (08-Apr-2016)

Fixed Delete writing to header status where there was only line data.

7.1.65 (07-Apr-2016)

Added missing Column Comments to Customize Fields form.

7.1.64 (06-Apr-2016)

Added PO Line Number to standard PO Downloads.

7.1.63 (06-Apr-2016)

PO Line number now downloads correctly.
Destination Org now defaults correctly.
Made changes to Account Generator Workflow.

7.1.62 (05-Apr-2016)

Added profile option "More4Apps: RW Allow Zero Quantity Upload" which allows you to upload while ignoring zero quantity lines/distributions.
Added Customize LOV option for Exchange Types.

7.1.61 (04-Apr-2016)

Added customization for customer to remove Outside Operation line types from the LOV.
Line Type LOV is now language sensitive.
When the Destination Type is Inventory - The account information will be forced to the value returned by the account workflow.
User can now specify the Line Num when uploading.
Added a Customize LOV option for Preparers.

7.1.60 (31-Mar-2016)

Fixed bug where duplicate category segments (with different letter cases) was causing the incorrect category ID to upload in some cases.
Added profile option "More4Apps: RW Disable Category KFF Form" which changes it to an LOV.
Now when duplicate Category combinations exists - append the ID to the end.

7.1.59 (31-Mar-2016)

Fixed bug where Category was not being marked yellow in the form when required.

7.1.58 (31-Mar-2016)

Fixed XML Parse Error when downloading interface and certain columns were missing from the sheet.

7.1.57 (31-Mar-2016)

Fixed various errors and defaulting issues when Catalog Supplier Item was removed from the sheet.
Added Customize LOV option for Line Types.

7.1.56 (30-Mar-2016)

Fixed bug where the Destination Org would not default from the Location when first opening the form.

7.1.55 (30-Mar-2016)

Fixed error when opening lines form when certain dependent columns were missing from the sheet (e.g. Catalog Supplier Item).
Added a Customize LOV option for Source Types.

7.1.54 (24-Mar-2016)

Fixed errors when removing the "Catalog Supplier Item" column from the sheet.
Fixed bug where having multiple currency codes on the sheet would cause exchange type to default incorrectly (for base currency lines).

7.1.53 (22-Mar-2016)

Fixed Preparer LOV not showing end-dated buyers (who are still active employees).

7.1.52 (21-Mar-2016)

Minor bug fixes.

7.1.51 (18-Mar-2016)

Fixed error when validating distribution accounts when lines have multiple distributions.

7.1.50 (18-Mar-2016)

Added missing profile options "More4Apps: RW Remove Approved Status" and "More4Apps: RW Remove Pre-Approved Status".

7.1.49 (17-Mar-2016)

Fixed issue when calling Account Generator Workflow as was causing an error in 12.2.5.

7.1.48 (15-Mar-2016)

The Charge Account can now be defaulted from the Destination Subinventory Material Account when it has one.

7.1.47 (11-Mar-2016)

Fixed some issues with Catalog Supplier Items and implemented additional functionality in line with iProc.
Fixed "Subscript out of range" error when closing another excel session while Requisition Wizard is open.
Fixed DFF defaults not working.

7.1.46 (10-Mar-2016)

Removed restriction to 'Non-Catalog Request' on Smart Form LOV - all values should display now.

7.1.45 (08-Mar-2016)

Added profile option "More4Apps: RW Enable Document Defaulting" which allows item/category/description to be defaulted from the document line.

7.1.44 (01-Mar-2016)

Minor bug fixes.

7.1.43 (25-Feb-2016)

Updated Security.

7.1.42 (25-Feb-2016)

Dest org now defaulted from location of Requestor (Not Preparer).

7.1.41 (24-Feb-2016)

Fixed bug that only validated 1 document line per record and incorrectly marked others as invalid.
Fixed bug where searching the Document before validating it (or its dependents) would error with invalid SQL (no sql).
The Destination Organization can now be defaulted from the location of the preparer.

7.1.40 (23-Feb-2016)

Fixed bug where price would be blanked out when no item existed.

7.1.39 (15-Feb-2016)

Added Profile 'More4Apps: RW Allowed Sourcing Mode' which restricts users to 1 sourcing mode and hides the ribbon option.

7.1.38 (12-Feb-2016)

Minor bug fixes.

7.1.37 (12-Feb-2016)

Selecting Initiate Approval option in the Submit Requisition Import form will now remember the chosen option (in the workbook).

7.1.36 (05-Feb-2016)

Fixed whitespace error when uploading when values contain % and '.

7.1.35 (04-Feb-2016)

Added 240 Character limit for Item Long Description and Special Information Attribute.

7.1.34 (12-Jan-2016)

Fixed timeout when calling account generator workflow.

7.1.33 (22-Dec-2015)

Updated Security.

7.1.32 (21-Dec-2015)

Req number will now error if manually keyed when numbering options are set to automatic.

7.1.31 (15-Dec-2015)

Destination Org is now a search list in the form.

7.1.30 (07-Dec-2015)

Debug mode now works for file attachments.

7.1.29 (03-Dec-2015)

Fixed multiple issues when using Debug Mode.

7.1.28 (26-Nov-2015)

When clicking the "Generate Accounts" button on the distribution form, the page will now only change if the call is successful.

7.1.27 (24-Nov-2015)

Generated accounts are now written to the sheet on validate/upload.

7.1.26 (23-Nov-2015)

Change to project validation to remedy Project/Task validation error.

7.1.25 (20-Nov-2015)

Fixed Error 5 when opening the lines form without header data - line attachment status columns were being added to the header section

7.1.24 (13-Nov-2015)

Fixed bug where changing a single value in the distribution form then closing it would not save the changes to the sheet.

7.1.23 (04-Nov-2015)

Minor bug fixes.

7.1.22 (02-Nov-2015)

Improved performance of validating (loading data).
Account Workflow calls are now loaded in batches to prevent a timeout of very large uploads.

7.1.21 (30-Oct-2015)

Fixed rounding issue with distribution quantity where sum of distributions built incorrectly e.g. 1.449999 instead of 1.45 - force rounding to currency precision or 2.
Improved performance of validating the need by date - now caching the sysdate so we don't need to check the database as often.

7.1.20 (28-Oct-2015)

Updated Security.

7.1.19 (16-Oct-2015)

Improved performance of calling Account Generator Workflow.
Fixed error closing header form when distributions don't exist on the sheet.
Fixed Distribution quantity check rounding bug - now comparing values as strings instead of doubles.

7.1.18 (15-Oct-2015)

Attachment status columns will now be cleared when using "Clear Status Columns

7.1.17 (13-Oct-2015)

No longer prompting to upload attachments after uploading to interface.

7.1.16 (07-Oct-2015)

Minor code refactoring changes.

7.1.15 (02-Oct-2015)

Fixed error when clicking the "Source" button on the lines form. This was caused by missing columns on the sheet.

7.1.14 (24-Sep-2015)

Improved performance when Item LOV.

7.1.13 (18-Sep-2015)

Minor SQL improvements.

7.1.12 (18-Sep-2015)

Minor bug fixes.

7.1.11 (17-Sep-2015)

Requisition Number now respects the formatting options in the purchasing setup e.g. Enforce Numeric.

7.1.10 (08-Sep-2015)

Minor bug fixes.

7.1.09 (31-Aug-2015)

Improved licensing properties.

7.1.08 (13-Aug-2015)

Added max length validation for the Supplier Item.

7.1.07 (07-Jun-2015)

Refresh bug fix where if the first line of the requisition didn’t get imported but the requisition was created then the Requisition number wouldn’t be returned to the sheet.

7.1.06 (01-Jul-2015)

Fixed downloader bugs.

7.1.05 (26-Jun-2015)

Fixed bug where the distributions were using the line error messages.

7.1.04 (26-Jun-2015)

Fixed downloader bugs.

7.1.03 (26-Jun-2015)

Fixed bug where errors and error messages were not being written to the Wizard.

7.1.02 (19-Jun-2015)

Fixed downloader bugs.

7.1.01 (17-Jun-2015)

Multiple Bug fixes when using the Wizard as a Trial account.

7.1.00 (12-Jun-2015)

Download Wizard functionality added. Includes all the DW code and Ribbon/Toolbars.

7.0.51 (05-Jun-2015)

Changed UOMConversion to use po_uom_s.po_uom_convert as INV_CONVERT.INV_UM_CONVERT is not supported in 11i and 12.0.6.

7.0.50 (29-May-2015)

Now using the INV_CONVERT.INV_UM_CONVERT function in UOMConversion.

7.0.49 (25-May-2015)

Fixed UOMConversion query in ValidatorUnitPrice as a subquery was returning multiple rows for a customer.

7.0.48 (08-May-2015)

Reverted previous change as it was incorrect.

7.0.47 (28-Apr-2015)

Changed the way we pass line and distribution ids to the interface as distributions were not linking to the lines properly.

7.0.46.2 (18-Mar-2016)

Added missing Profile Options 'More4Apps: RW Remove Approved Status' and 'More4Apps: RW Remove Pre-Approved Status'

7.0.46.1 (19-Jun-2015)

Fixed bug where Wizard would continue uploading when trial count was exceeded. NB Only affects Trial Mode (ie no licence key) or Date Expired Licence Key.
1) When the trial was exceeded the Wizard would insert lines into the interface but would not insert the distributions
2) The last inserted distribution Id would be printed to the sheet for all the distributions that were not inserted ie so it would look like multiple distributions had been inserted with the same Id

7.0.46 (23-Mar-2015)

Doc Line is now required if Doc Num is entered and Doc Num is now required if Doc Type is entered

7.0.45 (23-Mar-2015)

Added OverrideTable for Source Organizations so name and code can be swapped around

7.0.44 (20-Mar-2015)

Initialise the Document Columns after the Supplier as they are dependent on the supplier

7.0.43 (19-Mar-2015)

Rearranged the order of some column initialisations to improve the flow of the form

7.0.42 (19-Mar-2015)

The CostPrice API will now be called regardless of req type, when the source type is INVENTORY and will overwrite values
Price column now gets assigned ValidatorUnitPrice even when sub 12.1.3

7.0.41 (18-Mar-2015)

Added defaultCostPrice which retrieves the item cost price for internal requisitions using an API

7.0.40 (16-Mar-2015)

Check Line Amount and Quantity exist before attempting to validate them in checkDistTotals

7.0.39 (13-Mar-2015)

Fixed up preparer LOV SQL as it was incorrectly excluding non-buyers and null start dates

7.0.38 (09-Mar-2015)

Fixed bug where Need by Date would not error when blank and "required"

7.0.37 (09-Mar-2015)

Added new default preparer SQL from Oracle trace, if this returns nothing it will still use the old SQL

7.0.36 (05-Mar-2015)

Upload option "Validate Commit" renamed to "Validate and Upload"

7.0.35 (03-Mar-2015)

Corrected the Source Org SQL as it was over-restricting the LOV

7.0.34 (23-Feb-2015)

Added toolbar checks so ribbon code would not be run in Excel 2003 on login

7.0.33 (20-Feb-2015)

Set isInitialise True when validating the record in the SPIT form so validators don't expect controls
Re-ordered the toolbar
Changed the tooltip for Download Selected to say "Download Requisitions using sheet data"
Added Customize LOVs button to the setup tab on the ribbon

7.0.32 (19-Feb-2015)

Changed set status C_PROCESSED to C_ACCEPTED in the refresh
Fixed syntax error in Template SQL
Fixed problem where ribbon code would try to compile and error in Excel 2003

7.0.31 (17-Feb-2015)

DefaultPreparer - Added NVL sysdate to start_date_active as this is nullable in 12.0.6 and 12.1.3

7.0.30 (17-Feb-2015)

Added a SQL column for currency code so it can be used for download selected

7.0.29 (27-Jan-2015)

Added isValidType check to ValidatorItemDescription as it was allowing values over 240 characters to get into the interface

7.0.28 (23-Jan-2015)

Show_Wizard_Toolbars now unhides the Setup tab of the ribbon

7.0.27 (23-Jan-2015)

Uncommented show/hide login functionality

7.0.26 (22-Jan-2015)

ImplementationLine - Item Column SQL - Join on cached category set id instead of hardcoded 2
Also Added segments 11-20 to sql for R12

7.0.25 (19-Jan-2015)

Updated frmFlex for segment alias fix

7.0.24 (19-Jan-2015)

Updated the common code

7.0.23 (16-Jan-2015)

Added buttons for each of the forms to the toolbar and right click menu
Fixed up showing/hiding the SPIT button on both the ribbon and toolbar/rightclick menu

7.0.22 (12-Jan-2015)

Simplified the Req Number comment

7.0.21 (08-Jan-2015)

Increased size of Line DFF value control from 50 to 120
Removed the add-ins toolbar when ribbon is active

7.0.20 (24-Dec-2014)

Added UPC Refresh Line Renumber Customisation

7.0.19 (19-Dec-2014)

Added customer customisations
Remove proxy SPIT section from parents children after download

7.0.18 (18-Dec-2014)

Package body updated to 4.0.6 to fix SPIT upload issue
Implemented Ribbon

7.0.17 (16-Dec-2014)

Fixed ValidatorCategory so category is derived from the item on the sheet as well as form

7.0.16 (10-Dec-2014)

Corrected double click message from "row 10 or below" to "row 11 or below"

7.0.15 (27-Nov-2014)

Renamed Special Information Status to "" Messages
Added alias to dummy :P1 in project SQL as it was causing an XML error

7.0.14 (26-Nov-2014)

Replaced all [not 12.1.3] checks to [not > 12.1.2] checks
Fixed spelling mistake in SPIT error message

7.0.13 (21-Nov-2014)

Fixed Account Generator Workflow bug caused by expenditure date format in Santiago (R12.2.4)
Fixed version check for enabling the smart form column (was only working for 12.1.3)

7.0.12 (18-Nov-2014)

Updated Core 210
Fixed some problems with the Interface Download SQL
Added a new generic SPIT example sheet

7.0.11 (13-Nov-2014)

Changed Preparer LOV to exclude inactive workers
Added order by full_name to preparer SQL

7.0.10 (11-Nov-2014)

Added Profile M4APS_RW_ENABLE_SPIT to turn Special Information Templates on/off in this Wizard

7.0.09 (06-Nov-2014)

Added Profile M4APS_RW_SHOW_ALL_BATCHES which controls the checkbox on the Submit Batches form

7.0.08 (31-Oct-2014)

Check that we have Line data before opening the SPIT forms
Source type is now a required column

7.0.07 (30-Oct-2014)

Changed the Quantity variable in ValidatorDistQuantity from Long to Double to prevent rounding

7.0.06 (30-Oct-2014)

Changed the wording of 'Customize Mandatory Fields' to 'Customize Fields'
Made Dist Quantity and Amount variables Double in ValidateDistributionColumns to prevent rounding
Updated Form Initialise Code
Request LOV is now sorted by full_name
Partially generated accounts will no longer overwrite user entered values and more appropriate message is given
Refresh can now be used to load attachments for PROCESSED records

7.0.05 (29-Oct-2014)

Check SPIT message column exists before writing messages to it

7.0.04 (29-Oct-2014)

Implemented SPIT (Special Information Templates)

7.0.03 (14-Oct-2014)

Implemented Override Tables for certain columns
Form data is now initialised correctly when using the 'Open Form' button
Fixed bug where you couldn't enter the Req Number on the form
Fixed error when calling autosource in 11i
Currency Code now downloads from PO_REQUISITION_LINES_INQ_V
Line Type is now a required column
Errored distributions are no longer set valid by following lines
Updated WColumn so that defaulted are fired whenever the control is blank in the form
Implemented Row 10 Defaults

7.0.02 (07-Oct-2014)

Added validation to check that each line has corresponding distribution

7.0.01 (06-Oct-2014)

ValidatorDistQuantity will now check that quantity or percent is entered for each distribution
Autosource button tooltip now reads "Preview Autosource for Lines based on current selection"

7.0.00 (01-Oct-2014)

Sourcing will no longer return Site ID to the sheet when it cannot be converted to the value
Updated template header comments
Updated version to 7.0.00 so that it's greater than the old Wizard

5.4.82.3 (21-Nov-2014)

Fix for handling long columns in EBS 12.1

5.4.82.1 (10-Jul-2014)

Fix for Descriptive Flexfield for 12.2

5.4.82 (06-Mar-2014)

Fix for case. Release issue. Line Attachments Issue – ‘Run-time error ‘13’: Type mismatch

5.4.81 (25-Feb-2014)

attAttachment.Startup. Allowed form to open when the record didn’t exist in database

5.4.80 (21-Jan-2014)

Fixed bug in Lines form.
Error 381 (Could not get the Column property. Invalid property array index.) in procedure Do_Revisions of Module frmLines.
Line Number: 120.
Line Number: 3750. Module: frmLines. Procedure: Startup

5.4.79 (21-Jan-2014)

Wizard core updated to version 206

5.4.78 (20-Jan-2014)

Fixed bug where Approval logic was not being set properly. ‘Can change forward to’ and ‘Default Approval Path’ were not being populated

5.4.77 (13-Jan-2014)

Fix bug in lines form: Error message was – “Could not default Supplier Site from Supplier Site ID = ???”

5.4.76 (23-Oct-2013)

Changed distributions functionality:
Wizard no longer defaults Accounts from Project Details.
If both Account Details and Project Details are provided validation will fail with the following message:
“There are too many Accounting Sources for this Distribution.Please either Provide Account Details or Project Details – Not both.”
Fixed validation colouring of column ‘Expenditure Date’ on upload

5.4.75 (11-Oct-2013)

Added functionality to default Line and Distributions values from row 7 into the current row.
The defaulting occurs before opening forms and on validation/upload.
The functionality is enabled by ‘profile option ‘M4APS_RW_ENABLE_ROW7_DEFAULTING] (user profile option [More4Apps: RW Enable Defaulting From Row Seven]

5.4.74 (08-Oct-2013)

Fixed problem with Category and Price not writing back to sheet.
Disabling ‘Outside Services’ Tab on Lines form when the ‘Outside Services’ columns are removed from the sheet (Job and Job Sequence).
Fixed bug in ‘Lines Form’=>’Outside Services Tab’=>’Job search button’ was enabled when the ‘Job combo box’ was disabled. ‘Job search button’ is now disabled when ‘Job search button’ is disabled.
Added the ability to disable the ‘iProcurement Tab’ on the ‘Lines Form’ through profile option [M4APS_RW_DISABLE_IPROCUREMENT_TAB]. User profile option name [More4Apps: RW Disable Iprocurement Tab].
Changed ‘Not for User Consumption’ subs to functions so they won’t show in the macro menu

5.4.73 (30-Sep-2013)

Lines form: fixed bug where form would error if the Item column header was removed from row9.
Fixed bug that caused interface errors:
1) You cannot approve this requisition. The sum of the distribution quantity should match the line quantity.
2) There is no distribution information for this Requisition. Ensure that there is a corresponding row in the requisition distribution interface table.
NB In some cases the interface may accept scenario 1 above. Which results in a requisition being created that can not be approved. A typical error message in this scenario would be: Error: Line #1 quantity (40) does not match distribution quantity (42). Additionally to the message you may also receive: Error: Line # 1 Lines that are internally sourced can only have one distribution

5.4.72 (08-Jul-2013)

Fixed coloring of Source Document fields in Lines form.
Fixed bug where iproc form couldn’t be closed.
Changed Line Level GL Date to allow blanks even when encumbrance is turned on. The interface will default it to sysdate. This will error if sysdate is not an open period

5.4.71 (24-Jun-2013)

Added (YES/NO) Profile Option to allow the user to remove header attachment functionality.
Now allowing currency details to be provided for functional currency
Changed validation to require Project number if any other project details are provided.

5.4.70 (08-May-2013)

Changed downloads and ‘Document Type Defaulting’ to use ‘Source Document Type’ rather than ‘Document Type’

5.4.69 (07-May-2013)

Internal enhancement

5.4.68 (03-May-2013)

Removed download restriction of 500 lines.
Fix for download counter in status bar showing wrong information.
Wizard now only works against latest package 4.0.5.
Changed Document Type Requisition Line Download to match the value the upload is looking for ie It used to download ‘Blanket Purchase Agreement’ but the uploadLOV would look for ‘Blanket’ and invalidate the upload

5.4.67 (30-Apr-2013)

Fix for header form problems

5.4.66 (18-Apr-2013)

Attachment code enhancements

5.4.65 (12-Apr-2013)

Fix for inconsistent Sourcing behavior. Important fix for sites using sourcing rules.
Cosmetic fix to Lines form for Source Sub Inventory field colour

5.4.64 (11-Apr-2013)

Lines form changes:
- AutoSource was not running if Source Org column was missing
- Call AutoSource after changes to Destination Organization and Location

5.4.63 (09-Apr-2013)

Changed default price for internally sourced Items to Average Cost rather than Item Master price.
Moved Revision validation to after Source Org validation as Source Org is an input into this.
Fix batches form crash when loaded and the active sheet does not have the Batch ID column

5.4.62 (03-Apr-2013)

Added ‘More4Apps: RW My Batches Only’ profile option to allow control over the checkbox option on the Batches form.
Cosmetic changes to Distributions form to fix colour changes in Project fields

5.4.61 (15-Mar-2013)

Fix for Build_Line_Detail error caused by emtpy tax code array.
Fix for – Error 13 (Typen komen niet met elkaar overeen) in procedure Build_Line_Detail of Module appMain Line Number: 3910

5.4.60 (07-Mar-2013)

Fixed bug caused by empty tax code array. Error 381 (Kan de eigenschap Column niet instellen. Ongeldige index voor eigenschappenmatrix.) in procedure Startup of Module frmLines Line Number: 3010

5.4.59 (19-Feb-2013)

Fix for no value in Need-by-date column causing validation to reject Line.
Fix for where the Wizard was only loading the 1st Distribution for each Line when there were multiple Distributions on the Line

5.4.58 (18-Feb-2013)

Fix bug where it was not initialising project details before processing distributions.
Added ‘Line GL Date’ column. Changed existing distributions column title ‘GL Date’ to ‘Dist GL Date’

5.4.57 (15-Feb-2013)

When the Lines form loaded, any existing value on the sheet in Source Organization was cleared for no good reason. Stopped this from occurring.
Added Unit of Measure and Unit Price to fields not available for change on the Lines form when Full Sourcing is selected.
Added profile option “More4Apps: RW Allowed Sourcing Mode” to restrict available Sourcing modes.
Fix to Distributions form to prevent form error when using Generate Accounts button and any of the account columns are missing.
Added validation to prevent Need By dates prior to today’s date.
Load “N” instead of null when not Urgent.

5.4.56 (11-Feb-2013)

Modified uploader to use Requisition Line sequence instead of Interface Line sequence. Has a number of advantages over the past method.
Fixes for faults in Line and Distribution delete procedures where wrong IDs were used.

5.4.55 (18-Jan-2013)

Updated common modules version to 203.3
Fixed bug in Category Code combinations SQL – ORA-00918: column ambiguously defined.

5.4.54 (04-Jan-2013)

Added checks for status columns that caused the upload to fail when they were missing ie Line ID, Line Status, Line Error, Dist ID, Dist Status, Dist Error

5.4.53 (04-Jan-2013)

Internal Enhancement

5.4.52 (28-Dec-2012)

Internal Enhancement

5.4.51 (28-Dec-2012)

Fixed bug caused by errored cells being saved to caching sheet.

5.4.50 (21-Dec-2012)

Changed form functionality so data doesn’t get removed when line type is changed

5.4.49 (21-Dec-2012)

Internal Enhancement

5.4.48 (20-Dec-2012)

Turned off Trace in attachments load for r12

5.4.47 (14-Dec-2012)

Fixed bug in attachments load.

5.4.46 (14-Dec-2012)

Flexfield enhancements

5.4.45 (10-Dec-2012)

Download fix. Some dates were being downloaded with ~d attached to the end

5.4.44 (06-Dec-2012)

Internal enhancement

5.4.43 (20-Nov-2012)

Attachment code enhancements

5.4.42 (19-Nov-2012)

Internal enhancements

5.4.41 (04-Oct-2012)

Internal enhancements

5.4.40 (04-Oct-2012)

Internal enhancements

5.1.39 (25-Sep-2012)

Fixed Special Information Template bug.  Attribute insert sql was not handling apostrophes in the data.  Added Prepare_string
Fixed bug introduced in version 5.1.38 where requisitions were created without distributions

5.1.38 (22-Sep-2012)

Internal enhancements

5.1.37 (20-Sep-2012)

Added in a search on the description for the category flexfield, so the user can now search the category on its description.

5.1.36 (19-Sep-2012)

Line level ‘Note to Approver’ now gets uploaded to the interface

5.1.35 (12-Sep-2012)

Standard Login (SSO Bypass) method added to setup toolbar

5.1.34 (06-Sep-2012)

Added Expenditure_Type to substitutions for distributions DFF context defaulting
Fixed DFF so it works for context form field references and substitutions
Updated new attachment code with fix

5.1.33 (03-Sep-2012)

Updated ‘UploadAllAttachments’ to fix error when ‘upload all attachments’ button is clicked and the wizard is not logged in.
Fixed issue where the login screen would pop up again if the user cancelled from the login screen, this was getting caused by the new attachment code.

5.1.32 (30-Aug-2012)

Added in two new profile options:
1) More4Apps: RW Remove Approved Status    (M4APS_RW_REMOVE_APPROVED_STATUS), which removes the ‘Approved’ status from the status LOV
2) More4Apps: RW Remove Pre-Approved Status (M4APS_RW_REMOVE_PRE_APPROVED_STATUS), which removes the ‘Pre-Approved’ status from the status LOV

5.1.31 (29-Aug-2012)

Header Level Attachments added
Fixed bug where the user couldn’t close the distributions form after they have opened it for a blank requisition line.

5.1.30 (27-Aug-2012)

DFF Validation – Stopped defaulting of Translatable Dependent and Dependent attributes.

5.1.29 (21-Aug-2012)

Fixed bug retrieving Category Flexfield delimiter. Default Line Type ID was being used as the structure ID

5.1.28 (08-Aug-2012)

Fix for Flexfield validation from Ok button on the flex form. Caused when delimiter is not 1 character
Fixed bug finding end row in a record
Fix for Key Flexfield LOVs showing end dated values
Fix for Key Flexfield Concatenated Segments error when downloading a PO. Again caused when a delimiter is not 1 character.
Special Information Templates implemented

5.0.27 (25-Jul-2012)

Added error handling to destination ID and callers to help track down error

5.0.26 (23-Jul-2012)

Fixed problem with expenditure_date download
Fixed problem with UOM list of values showing disabled units
Start date and Completion date now displayed for the projects list of values

5.0.25 (18-Apr-2012)

Added test for fixed lot multiplier controlled by profile ‘M4APS_RW_VAL_FIXED_LOT_MULTIPLIER’

5.0.24 (16-Apr-2012)

Fixed autosource bug – missing destination org was causing the m4aps_reqwizard.autosourc call to fail

5.0.23 (29-Mar-2012)

Internal Enhancements

5.0.22 (21-Jan-2012)

Added contracts document type to source details selection
Fixed bug where GL Structure ID was being set to PO Structure

5.0.21 (16-Jan-2012)

Fixed bug where Wizard would error if profile value for MRP_DEFAULT_ASSIGNMENT_SET was not set

5.0.20 (13-Jan-2012)

Not Released

5.0.19 (11-Jan-2012)

Changed download to download Document Type rather than document type code

5.0.18 (22-Dec-2011)

Added Order By clause to Requisition and Template download SQL

5.0.17 (25-Jan-2012)

Fix for login not working for SysAdmin responsibilities when there is no Set of Books

5.0.16 (01-Dec-2011)

Fix for some Projects not validating correctly due to cross-charge projects not being included

5.0.15 (07-Nov-2011)

Provide for alternative reserved Line DFF segment (than 15) for storing Interface Line ID

5.0.14 (22-Sep-2011)

Allow ‘Source Organization’ column to be deleted when Full or Partial Sourcing and default available

5.0.13 (30-Aug-2011)

Fix for R12 Attachments bug in 5.0.12
Updates to DFF module, KFF module, common modules

5.0.12 (27-Jul-2011)

Upgraded attachments module for R1

5.0.11 (04-Jul-2011)

Fixed bug in price update from UOM when item sourced from inventory – In partial sourcing mode. The value was coming from the item price rather than the GL view.
Added extra UOM conversion code. Now working on a heirarchy. First does intra-class item specific conversion if no item specific it will default
intra-class generic(no item dependency). There is an inter-class conversion but as yet haven’t added this
NoSourceRuleSourceDefaulting was erroring – put an escape into code when no results are being returned

5.0.10 (01-Jul-2011)

Added Outside Services columns: Job and Job Sequence

5.0.09 (21-Jun-2011)

Override of price when source is inventory now respects the UOM

5.0.08 (20-May-2011)

Stop overriding user selection of Unit of Measure in Full Sourcing mode
Previously the price would ignore the UOM and provide the price for the primary UOM for the item.
GL Date column added to distributions section

5.0.07 (13-May-2011)

Fix for error caching PO_DIRECT_DELIVERY_TO_SHOPFLOOR profile option

5.0.06 (09-May-2011)

Update for non-ascii character handling

5.0.05 (12-Apr-2011)

Fixed Subscript out of Range message in recent DFF module changes

5.0.04 (12-Apr-2011)

Fix for File Attachment uploads not working on Windows 7
Login performance enhancements added

5.0.03 (10-Dec-2010)

Fix for Document Number clearing on validation when Full Sourcing mode used

5.0.02 (01-Dec-2010)

Fix for Blanket Line downloads not returning rows for Non-Item based lines.
Fix to Lines form. Was showing no entries in Source Type LOV when there is no Item but a value exists on the spreadsheet.
Minor change to behaviour of the Project LOV in the Distributions form.

5.0.01 (24-Nov-2010)

Fix for messaging problem in 5.0.00 redesign

5.0.00 (11-Nov-2010)

Internal performance enhancement to reduce load on the SGA (Shared Pool). Requires package upgrade to version 3.0.00 on v5 XML package.
Counter in Batches form was showing incorrect number of Distributions in certain circumstances.
Fixed bug where Expenditure Org and Expenditure Item Date were not being initialised for Lines with Destination Type of Inventory

4.4.19 (28-Sep-2010)

Fixed bug where Source Organization wasn’t uploaded on first upload

4.4.18 (24-Sep-2010)

Fixed tax validation when you have multiple taxes with the same name – Start and End Date controlled

4.4.17 (27-Aug-2010)

Fixed bug where Source Type and Source Organization were being removed by the wizard. And, the controls were greyed out on the form.
Changed validation messages to all be “Error” – some were “Rejected” and others were “Error”

4.4.16 (18-Aug-2010)

Modified Lines form to stop automation errors when users click on Ok or cancel instantly after opening the form

4.4.15 (17-Aug-2010)

Added fix for Currency code/Exchange Date validation error. The line would fail validation with this error “Currency Code is required where there is an Exchange Date.” even though no Exchange Date was provided

4.4.14 (21-Jul-2010)

Added standard Menu/Dropdown logic

4.4.13 (08-Jul-2010)

Support Added for DFF Translatable Independent Value Sets

4.4.12 (02-Jul-2010)

Change to R12 iProc search sql. 12.0.6 was not returning any records

4.4.11 (30-Jun-2010)

Partial Accounts returned from Accounting workflow now written to worksheet but only by ‘Validate only’ upload and ‘Generate Default Accounts’ button on Distributions form
Accounting Workflow was being called during upload by spreadsheet. This is inefficient as the package can also perform this call

4.4.10 (21-Jun-2010)

Upgraded for R12

4.4.09 (14-Jun-2010)

Added Description Search to Item KFF

4.4.08 (08-Jun-2010)

Fixed bug in Get_Distribution_ProjectID

4.4.07 (20-May-2010)

Improvements to messages should workflow defaults differ from provided account values

4.4.06 (19-May-2010)

Accounting workflow call changed to allow existing accounts as inputs. Output values do NOT override input values
Requires updated Req Wizard package 2.0.00 to work. The old package will still function, but the new inputs will be ignored

4.4.05 (03-May-2010)

Custom line renumbering procedure added for (customer)

4.4.04 (05-Mar-2010)

Fixes for R12 Org Context issues
Revert button on Header form was restoring incorrect row to row 6

4.4.03 (05-Feb-2010)

Set PROJECT_ACCOUNTING_CONTEXT = ‘Y’ whenever a project is uploaded

4.4.02 (03-Feb-2010)

Only validating the project transaction information if destination type is ‘EXPENSE’ – involves a package change

4.4.01 (26-Jan-2010)

Records without Items were not being downloaded
It was downloading both Request_id and Requestor into the Requestor column
If the downloaded value of requestor was null (ie in the case of a PO) then the request_id would end up in the cell
Attribute2 was being set to the attribute1 column reference. Causing attribute2 to be populated with the wrong data

4.4.00 (07-Jan-2010)

New simpler connection method
Mod to Reinstall_ProfileOptions macro to allow run by non-named user

4.3.02 (08-Dec-2009)

Fixed error message writing problem
Multiple Template sheets supported. Users can now define unlimited Template sheets. 2 sample Templates provided

4.3.01 (24-Nov-2009)

Fixed fault in Get_Aliases procedure

4.3.00 (19-Nov-2009)

Non-Named Users are no longer allowed to use any functions in the tool except the About form
View my Requests form added
Upgraded DFF module to current standard
Updated Flexfield form to handle 15 segments

4.2.08 (14-Aug-2009)

Upgraded DFF module to current standard
Added custom Expenditure Type validation for a specific customer

4.2.07 (31-Jul-2009)

Fix for Security rules in Key Flexfield form not applying if the logged in Application is different to the standard Oracle module

4.2.06 (27-Mar-2009)

Fixed file size explosion problems caused by Excel 2007
Fixed bug in download form. Selecting a requisition/quotation/purchase order number would cause the sql to error if a non-numeric number/segment1 was returned

4.2.05 (27-Jan-2009)

Upgraded forms to new licence key model

4.2.04 (13-Jan-2009)

Fixed bug in requisition lines sql that stopped data from being downloaded if there was no item on the line

4.2.03 (28-Oct-2008)

Added sub to call the custom downloader without using the form
Upgraded connection module for R12 logging
Bug fix for Invalid Type message when no users on right side
Activation Key update added
Bug fix for Header DFF button on toolbar disappearing
Multi-language fix for defaults on Batch Header form
Change Approval Paths from caching on login to search on request for performance reasons

4.2.02 (17-Oct-2008)

Multi-language fix for Source Types

4.2.01 (11-Sep-2008)

Correct inefficient DFF segment validation on upload
Internal improvements to DFF module and form

4.2.00 (28-Aug-2008)

Upgrade to About form to accommodate new Activation Key

4.1.31 (13-Aug-2008)

Item Long Description was not completed for Downloads

4.1.30 (11-Aug-2008)

Improvements to Named User maintenance form
Changed names of Login options. SSO method is now Standard
Item Long Description added (for Red Roof)

4.1.29 (18-Jul-2008)

Display description on Flexfield form

4.1.28 (09-May-2008)

R12 Changes including E-Business Tax change

4.1.27 (26-Apr-2008)

Upgraded DFF module to current standard
Support F type segment defaults
Stop DFF form from writing default Context to cell if not displayed
New debugging information button added to XML/Oracle error form

4.1.26 (02-Apr-2008)

Correct tab order in Distributions form
Lines form was erroring if Source Subinventory column was missing

4.1.25 (01-Apr-2008)

Updated for R12 rules re MOAC Org in Multi-Org tables and Concurrent Requests
Updated R12 Orgs, About, and Named User Maintenance forms

4.1.24 (15-Mar-2008)

Updated templates to read destination subinventory not just subinventory

4.1.23 (05-Mar-2008)

Fix to download. Was writing incorrect Source Document Type Name

4.1.22 (04-Mar-2008)

Support :PO_REQ_HEADER.PREPARER_NAME form field in DFF segments

4.1.21 (28-Feb-2008)

Date re-formatting stopped on upload

4.1.20 (17-Jan-2008)

Date format on download made consistent with forms

4.1.19 (16-Jan-2008)

Document Number field was left red on s/s by form if no value entered
Source Type field was red on form when Supplier defaults and nothing in LOV

4.1.18 (14-Jan-2008)

Attachments upload was not working. Upgraded module to support URL attachments
Upgraded About, Login, and URL setup forms

4.1.17 (20-Dec-2007)

Correct upload defaulting behavior for new Source Org functionality

4.1.16 (17-Dec-2007)

Non auto source sourcing – Upload and Form defaulting added for Source Org and Source Sub inventory
Fixed several form behavior issues with defaulting

4.1.15 (11-Dec-2007)

Was not writing default Source Org to spreadsheet if default used
The Destination type was not defaulting correctly if left blank on upload

4.1.14 (10-Dec-2007)

Fixed bug in Load_Default_Source_Type

4.1.13 (12-Dec-2007)

Stopped 555 errors being thrown in SourcingAttempt2 module

4.1.12 (23-Nov-2007)

Dave fixed auto sourcing. Needs to go in conjunction with new latest riw package – 1.0.14 22 Nov 2007

4.1.11 (14-Nov-2007)

Sourcing Document tidy up

4.1.10 (09-Nov-2007)

Sourcing Document Stuff attempt2

4.1.9 (06-Nov-2007)

Document Number was validating false when blank
Messaging changed for Document Number Search

4.1.8 (23-Oct-2007)

Various Lines form bugs fixed
Blank lines counter changed from 5000 to 15000 in Upload
Blank lines counter changed from 100 to 15000 in Refresh
Batch form was not retrieving column header positions
Fix made to Set Status for Excel 2007

4.1.7 (07-Oct-2007)

Update Lines form to read any Subinventory setting from the spreadsheet
Changes to help prevent toolbars locking
Stop Quantity defaulting to 1 for client customisation
Client wants the Source Type to default to Inventory for Items

4.1.6 (26-Oct-2007)

Blanket download had error in SQL
Further work on Auto Sourcing
Fixed bug where Organization Code was running some non related SQL in some cases

4.1.5 (19-Oct-2007)

Other downloads failed due to extra columns in requisition download
Function ResolveDocNumFromID was crashing when a blank value was passed as the POHeaderID

4.1.4 (28-Sep-2007)

Add columns Document Type, Document Number and Document Line
Hiding sourcing option on the toolbar for client customisation
Override tables form references to settings123 changed. An extra row inserted into the settings sheet caused it to be out of whack
The form was over writing the Deliver to Location with the Default Deliver to Location
Download was requiring to start at row 11 instead of 10
Customisation to force Expense as default Dest Type for client customisation in Item form and Upload
Form was not resetting default Dest Type on load to Expense
Added sourcing columns to requisition download

4.1.3 (20-Sep-2007)

Removed caching of Destination_Locations. Changed Location on lines form to long list of values
Header DFFs were not writing to row 6
Stopped Lines and Dist DFF forms from loading on rows prior to row 10
Customisations added for client customisation
Fix for Excel formatting numerics > 11 in length in scientific format
Double-clicking in row 10 did not load forms

4.1.2 (10-Sep-2007)

Fixed shading issue with enforces sourcing in the requisition lines

4.1.1 (10-Sep-2007)

Fix for DFF Context validation failing if invalid. Invalid Contexts should be ignored

4.1.0 (09-Sep-2007)

Updated version to 4.1 due to huge change in functionality with internal req’s now supported
Fixed bug when sourcing from supplier only returning the supplier code, not the source document

4.0.9 (23-Aug-2007)

Fixed issue in uploader, where source type was not the correct format. Updated type mismatch issue when collecting data from a cell. Fixed issue when checking source organization_id > 0 to <> “”

4.0.8 (23-Aug-2007)

Updated code around default source type, now use load_default_source type in form and in upload code
Added internal order functionality

4.0.7 (06-Aug-2007)

DFF fix for Profile options embedded in Value Set SQL
Key Flexfield form was not handling Profile Options in Value Set SQL
Autosource now returns Currency and Unit of Measure. Requires Package Body version 1.2.6
Right trim values for free form text DFF segments

4.0.6 (24-Jul-2007)

Changed Load Counter method so Profile option is only written to for trial version customers
Enforce 150 character maximum on DFF segments with no value set
Apply licence key control to Validate function

4.0.5 (10-Jul-2007)

Fix for DFF functionality not properly initialised

4.0.4 (09-Jul-2007)

VBA Protection entirely automated. Use Excel Protection from Excel menu – Tools / Protection

4.0.3 (05-Jul-2007)

Flexfield form was not enabling Ok button in certain circumstances
Flexfield form was not indicating when search required once criteria entered

4.0.2 (20-Jun-2007)

Fix for Dependent value sets in Key Flexfield form
DFF form fields are now disabled where columns are not available on the spreadsheet

4.0.1 (18-Jun-2007)

Fix for Language issue in LOV SQL for Attachment Categories
Further DFF and Flex form improvements – Fix for SSO login bug in 4.0.0

4.0.0 (11-Jun-2007)

Single Sign-On support added

3.5.0 (05-Jun-2007)

DFF and Flex modules upgraded
This and future versions will NOT operate in Excel 97
Minor enhancement to About form to show logged in Responsibility

3.4.08 (27-Apr-2007)

Distributions form LOV for Tasks was not showing Task Name

3.4.07 (20-Apr-2007)

Minor fix to Header form where no Forward-to change allowed
URL Encoding added to handle special characters passed in SQL bind parameters

3.4.06 (12-Apr-2007)

Fix to Item validation issue introduced in 3.4.05

3.4.05 (28-Mar-2007)

Multi language fix for SQL Bind variable technique. Requires M4APS_XML package body 3.0.08

3.4.04 (27-Mar-2007)

Bug in download of quotations, where it was not selecting the correct lines
Bug in download of quotations, where missing categories segments
Bug in download, incorrect category alias
Fix for timeout problem caused by Internet Explorer 7
Added search button to forward to person – it used to be cached

3.4.03 (06-Mar-2007)

AutoSource check in Lines form was unnecessarily clearing Supplier and Tax Code LOVs
Tolerate missing port number in login URL (for 8000 default)
Better error handling for invalid URL setup
Some minor DFF form settings were not complete
Added SQL Bind variable technique to improve performance of Item validation

3.4.02 (13-Feb-2007)

Performance issue for Approved Supplier List. Tightened up query to use more than 1 index
Fixed issue where returning values from iproc cleared out the supplier site
Changed download to verify if document exists, so the user doesn’t have to press the button to check to the document number

3.4.01 (12-Feb-2007)

Made change to iproc download to verify the Approved supplier list supplier is ‘approved’

3.4.00 (10-Feb-2007)

Added in functionality to download quotations and planned purchase orders

3.3.03 (30-Jan-2007)

Fixes for no value sets in Key Flexfield segments

3.3.02 (23-Jan-2007)

Fix for Flex form not behaving properly for non validated value sets like Item since 3.0.00
Multi-language fix in DFF module
Fix for DFF validation bug introduced in 3.0.01

3.3.01 (18-Jan-2007)

Lines form was not refreshing Source Org LOV after change to Inventory Source
Minor tidy up on the form fields for Source Type, Source Org, and Supplier LOVs
Distributions DFF column 2 was incorrectly mapped to column 1 on the spreadsheet
Use Line Attribute15 for linking to Spreadsheet Interface ID as Oracle does not provide a working reference back to the interface table
Was using Reference Num field for this purpose but users now wish to upload this column

3.3.00 (11-Jan-2007)

Major updates to DFF and Flex module
Minor fix to Show/Hide Template sheet form
Added Line level “Reference Num” column

3.2.51 (10-Jan-2007)

In the lines form, added check box to only return lines from approved suppliers
Added Suggested Vendor/Site/Contact and Buyer columns for Template Download
Number of blank lines tested changed from 500 to 5000

3.2.50 (25-Dec-2006)

10g database was not being detected properly for non-ASCII character handling

3.2.49 (18-Dec-2006)

Handler added for errors caused by apostrophe character in filename
AutoSource was not called for Category based Lines
Stop closed Req Lines from being downloaded
Stop ‘CLOSED’ and ‘FINALLY CLOSED’ P.O. Lines from being downloaded

3.2.48 (15-Dec-2006)

Batch Submit form now remembers last settings for Grouping, List My Batches, Initiate Approval
Was not loading Supplier Item for Category based Lines
Was not downloading Suggested Supplier/Contact and Supplier Item details

3.2.47 (13-Dec-2006)

Call to Price Break procedure updated for changes in 11.5.10

3.2.46 (13-Dec-2006)

New Protection feature requires regular resetting otherwise it changes into Excel protection which stops the forms/upload operating

3.2.45 (12-Dec-2006)

Auto/Same feature was case sensitive. Changed to make it case insensitive
New AutoSource caching feature was not checking array size limit

3.2.44 (08-Dec-2006)

Fix for Invalid Type message when uploading or running form on non-Item Lines

3.2.43 (06-Dec-2006)

Added need-by-date parameter to AutoSource, required where Price Breaks depend on date
Requires package body version 1.2.3 but will still function as before with old package
Bug fix in AutoSource where form was passing Dest Org ID, not Dest Location ID
AutoSource results now cached to help form and upload performance (minor improvement)
Wrong value used for Inventory Org in form – Item validation was only working for Deliver-To Locations attached to a specific Org
Fixes for missing optional columns not handled in some cases
iProc search form was returning UOM code to Lines form, not user value
Added Protection form to RW Setup Toolbar

3.2.42 (29-Nov-2006)

Upgraded DFF module
Removed loop technique from create_toolbars

3.2.41 (17-Nov-2006)

Performance improvement to Item validation

3.2.40 (11-Oct-2006)

Fixed further problem with Forward-To LOV if no Req Type populated on form load

3.2.39 (10-Oct-2006)

Upgraded Descriptive Flexfield module
Added support for Table validated Value sets to Flex module
Added Profile Option install for Oracle on Demand sites
Forward to LOV was not populating on first load of Requisition Header form

3.2.38 (02-Oct-2006)

Destination Subinventory column was not being loaded
Allowed Lines with no Quantity to be ignored rather than cause an upload error

3.2.37 (21-Sep-2006)

Source Subinventory column added. No form or upload validation at this stage

3.2.36 (19-Sep-2006)

Added sourcing by Category

3.2.35 (15-Sep-2006)

Approver LOV was not loading in Header form when no supervisor hierarchies used

3.2.34 (26-Aug-2006)

Inactive Templates excluded from LOV in download form

3.2.33 (25-Aug-2006)

Changes to Approval and Forwarding to cope with no position hierarchy defined

3.2.32 (16-Aug-2006)

Was not loading Suggested Vendor for Non-Item based Lines<
Item Source defaults were writing over any existing values on form load

3.2.31 (28-Jul-2006)

Flex form was not loading properly for missing or empty value sets
Was not resetting Flexfield config values before validating Item on form load

3.2.30 (21-Jul-2006)

Change to Approval Paths LOV SQL
Flex Combinations form fixed to allow for apostrophes in segment values
Stop Item validation from running when no Destination Organization selected
Attachment Categories LOV changed to multi-language view

3.2.29 (19-Jul-2006)

Handle configurations not using a Value Set for any Key Flexfield Segment
Note to Approver added to header and line
Calendar form changed to fix backspace bug
Two template sheets added – one for multi req sheets and on for single reqs per sheet
New form added for showing/hiding template sheets. Last setting cached for creating new sheets from template sheets
Fix to Replace97 procedure in case string being replaced has no length

3.2.28 (23-Jun-2006)

Handle configurations not using a Value Set for Items
Use standard search instead of Combinations button where there is only one Key Flexfield segment
Line level attachments added
Approval Path and Forward To Person added

3.2.27 (25-May-2006)

Allow for missing profile option PO: Legal Requisition Type
Allow for no default Line Type set in Purchasing Options
New user functionality to allow some columns to be set as mandatory/optional by the user
Special character handling function added to modXMLHTTP for 11.5.10CU2

3.2.26 (20-Apr-2006)

Changes to Sourcing to include Document Line number. Clear details if Supplier changed
Login change to allow space character in password
Enhancement to login form to better show HTML error messages
Distributions form was not writing Expenditure Item Date to sheet since Calendar change

3.2.25 (10-Apr-2006)

Login enhanced to allow non alphanumeric characters in password

3.2.24 (24-Mar-2006)

Missing Price column was not properly tolerated
Distribution Error Status was not being recorded when Project number Invalid

3.2.23 (15-Mar-2006)

Fix to Calendar positioning for Excel 97

3.2.22 (28-Jan-2006)

MS-Office Calendar replaced with VBA calendar

3.2.21 (25-Jan-2006)

Fix to new Blanket P.O. download SQL for generated flexfield columns
Loop added to counter intermittant failure to show toolbars on startup
Minor tidy-up to Line and Distribution defaulting
Package was not compiling in releases prior to 11.5.9

3.2.20 (24-Jan-2006)

Changed lines form to always default qty to 1
Updated bug with sourcing rules where supplier not clearing and partial sourcing option causing supplier site error

3.2.19 (18-Jan-2006)

Exclude Releases from P.O. download

3.2.18 (17-Jan-2006)

Was erroring line where no default Inventory Item price even if price is on datasheet
Handle blank lines between distributions
Was not recognising subsequent partial Lines when looping through Distributions
Was not writing error messages to error columns for failures in ‘Build’ procedures
Build Lines procedure was not handling “CALC” auto-calc feature

3.2.17 (06-Jan-2006)

Errored Location Codes were being overwritten with the default after failure
Allow Destination Org to default from Location during Upload if value missing

3.2.16 (23-Nov-2005)

Further fix in download form for numeric to value conversion error
Flexfield format was not swapping properly between Item and Category

3.2.15 (19-Nov-2005)

Fix in download form for numeric to value conversion error

3.2.14 (18-Nov-2005)

Price defaulting in form required fix as a result of the UOM conversion changes
Calendar object switched to late binding method
Fix for 9th Segment on Flexfield form not working
Stop Login procedure from looping if M4APS_XML not installed

3.2.13 (10-Nov-2005)

Stop UOM conversion call when Item is changed

3.2.12 (05-Nov-2005)

Stop UOM conversion call when there is no change in UOM or no item id
Lines form now getting an updated UOM (based on class and inter item uom conv) from item when item is selected
Additionally allow all UOMS when no inventory item is selected when first opening lines form
Stop Quantity from clearing – fix error colour not clearing for UOM

3.2.11 (21-Oct-2005)

Fix to price treatment during upload

3.2.10 (18-Oct-2005)

Form was not defaulting Price correctly. Remove redundant AutoSource calls in Lines form

3.2.09 (14-Oct-2005)

New DFF button and Override Tax profiles enhancements not working

3.2.08 (12-Oct-2005)

Fixed Get Buyer issue, re-enabled Autosource call in AfterItem
Use Tax: Allow Override of Tax Code profile option to control Tax code functionality

3.2.07 (10-Oct-2005)

Stop DFF buttons from displaying on toolbar if none configured

3.2.06 (10-Oct-2005)

Added price break functionality for unit prices and sourcing
Added sourcing functionality to allow no sourcing, full sourcing and partial sourcing
Partial sourcing defaults supplier, supplier site, supplier item and contact information. It also will default the unit price if the user has not entered one
Full sourcing will return values and replace those entered by the user
The interface does not use user entered values when sourcing = full sourcing (“Y”)

3.2.05 (06-Oct-2005)

Suggested Quantity column only exists from 11.5.10
Fix bug stopping download if Header Description cell missing
Improvements to text/number cell formatting for values with trailing zeros or decimals

3.2.04 (03-Oct-2005)

Improvements to text/number cell formatting for values with leading zeros
Change to icx_por_categories_vl from icx_cat_categories_tl in iProc Catalog search
Was not providing the usual Yes/No/Cancel options if Key Item/Category/Quantity values missing
Item validation Error message was not being written to the worksheet
Include Suggested Quantity in the Template Download

3.2.03 (23-Sep-2005)

Added option on download form to overwrite existing lines
Changed column naming convention for Line level DFFs
Minor performance improvement for download form

3.2.02 (19-Sep-2005)

Fix for Default inventory org not defaulting correctly
Updated frmlines LoadDestOrganization, now it will query the Inventory Org
Fix to stop new Batch ID being retrieved when in validate only mode or nothing to upload
Added search criteria to Named User maintenance form
Added error messages if Quantity populated but not mandatory Item or Category values

3.2.01 (19-Sep-2005)

Enhancements to iProc search for multi-language support<

3.2.00 (25-Aug-2005)

Added in iprocurement functionality. Updated Main Lines form to include iproc array and supplier item field
Created new tab in Lines form for iProc searching
Created new Search Results form to review iProcurement searches

3.1.02 (17-Aug-2005)

Added Header level Note to Buyer
Position of all header columns now flexible
New sample sheets

3.1.01 (12-Aug-2005)

Added User Override for Destination Types

3.1.00 (09-Aug-2005)

Further fix for Caching Org/Locations not working prior to 11.5.8
Was not using Session ID login method added in 3.0.25
Switched XML object from Fixed Reference to Late Binding

3.0.29 (04-Aug-2005)

Expired users removed from Named User form
Fix for issues in AUTO / SAME Req numbering feature
Minor change to Refresh feature to re-display Pending status
Refresh feature was missing last returned Req Number

3.0.28 (03-Aug-2005)

Fix for Caching Org/Locations not working prior to 11.5.6, plus a performance improvement
Fix for certain DFF Value sets containing $Profiles$: and IN statements

3.0.27 (27-Jul-2005)

Stop repeated DFF configuration caching when no columns define

3.0.26 (14-Jul-2005)

Note to Buyer field added

3.0.25 (07-Jul-2005)

Fix for MLS code change affecting procedure calls including apostrophe characters
Support new login validation method

3.0.24 (01-Jul-2005)

Added ‘List My Batches Only’ button to Batches form
Stopped word wrapping in Error columns
Refresh function enhanced to show Req Numbers for multiple Reqs per sheet
Added test for Concurrent Request status into Refresh function

3.0.23 (22-Jun-2005)

Fix Dff reference field issue
Tune Caching SQL for Organisations / Locations

3.0.22 (14-Jun-2005)

Fix bug in frmDFF using A_ValueSet instead of rsFlex array
Array counter fix to Get_Buyer_ID proc

3.0.21 (03-Jun-2005)

Fix to Refresh batches
Was not using Item Price default if column was missing from spreadsheet
Added feature allowing automatic Req numbering in the spreadsheet. New AUTO and SAME special values
MLS views used for multi-language Flex Value Sets
Support for all languages added
Updates to DFF module
Reference Number used to better display new Req numbers for Imported Lines in Refresh

3.0.20 (20-May-2005)

Change to Group By parameter passed to Req Import concurrent program

3.0.19 (17-May-2005)

Allow for HR_LOCATIONS_ALL_VL view not available until 11.5.9 or HR Family Pack E

3.0.18 (12-May-2005)

Download was duplicating Requisition Lines where multiple languages used

3.0.17 (09-May-2005)

Bug Fix in DFF module for non-validated value sets

3.0.16 (04-May-2005)

Translate Value set IDs to values for DFF

3.0.15 (29-Apr-2005)

Handle missing column errors in lines form and during upload
Fix Lines form to load defaults and disable columns when not on sheet
Re-design Delete Batch procedure
Fix for Destination Organisation not defaulting for first line uploaded
Stop Destination Organisation from clearing on form if Item on sheet

3.0.14 (26-Apr-2005)

Removed Batch ID join from Refresh function
Enhancements to Batch header form to describe existing batches
Fix Range selection for Delete and Upload
Add Delete Batch button on Batches form, handle ‘ character in DFF fields
Change from P to N for AUTOSOURCE_FLAG column
Clear AutoSource defaulted Supplier Site and Contact if user changes suggested supplier

3.0.13 (19-Apr-2005)

Support Profile Option in DFF Context Reference field
Move Flex sql procedure from server to VBA
Improvements to DFF module

3.0.12 (07-Apr-2005)

Fix to Requisition Number using correct request id

3.0.11 (31-Mar-2005)

Fix for problem retaining Digital Certificate

3.0.10 (29-Mar-2005)

Mods to precision for foreign currency price

3.0.09 (29-Mar-2005)

Allow DFF module to process or reference IDs when required

3.0.08 (24-Mar-2005)

Correction for local currency price calculation
Hide login configuration toolbar unless Setup toolbar shown
Stop rounding converted price to foreign currency precision. Allow 7 digits
Invert loaded exchange rate to be consistent with Requisition Summary form

3.0.07 (21-Mar-2005)

Allow Exchange Rate column to be deleted when not required

3.0.06 (18-Mar-2005)

Fix key flex bug and default rates when not in sheet during upload

3.0.05 (16-Mar-2005)

Support Profile defaults in Key Flexfield segments

3.0.04 (15-Mar-2005)

Complete foreign currency unit price calculation feature
Change to Override table feature
Cancelling upload after error was not stopping process

3.0.03 (14-Mar-2005)

Calculate currencies using rates from tables

3.0.02 (10-Mar-2005)

Correct error messages, check for for missing columns, do not re-validate line when already uploaded, Reject line if qty is zero
Make all distrib columns optional
Use mtl_system_items_b base table instead of view

3.0.01 (02-Mar-2005)

Add currency tab to Lines form, load org_id from location info for Item validation
Fix for European decimal point character not being handled properly
Removed constraint on non-ascii characters

3.0.00 (24-Feb-2005)

Add new dynamic DFF functionality, use ad_sessions_s.nextval for batch ID

2.1.28 (08-Feb-2005)

Fix bug: same sequence id in distrib table table id when subsequent block upload

2.1.27 (04-Feb-2005)

Remove prepare_string func for l_description,Category flexarray bug fix
move cursor with validate, delete, etc s/s scroll events

2.1.26 (02-Feb-2005)

Named user licence key model implemented

2.1.25 (29-Jan-2005)

Add Buyer column and use fnd_profile proc instead of m4aps_xml.get_apps_profile
Improve error messages

2.1.24 (21-Jan-2005)

Add get profile function to flex module, fix line type default error

2.1.23 (27-Jan-2005)

Added new Req Number column

2.1.22 (27-Jan-2005)

Add error msg when no item selected and item desc blank, error msg when no line amount but category or item exist
Added option on RW Setup toolbar to hide permanently

2.1.21 (26-Jan-2005)

Minor form bug fix

2.1.20 (24-Jan-2005)

Fix bug for incorrect total dist when first dist row is blank

2.1.19 (21-Jan-2005)

Req search for download was not picking up Reqs with a null description Allow INCOMPLETE Requisitions to be searched and downloaded Allow download if Number or Description criteria populated

2.1.18 (14-Jan-2005)

Add option to delete lines by selecting a range

2.1.17 (11-Jan-2005)

Bug fix for default Category from Item selection using same DB call
Clear Item Desc if update not allowed

2.1.16 (10-Jan-2005)

Remove calls in Description_Change(frmLines) proc, download tax_code and not tax_id
Fix destination type LOV bug where list not refreshed with Inventory
item after non-inventory selection on frmLines, Search criteria in frmFlex
Requisition Status override option
Cache Destination Org and Deliver to Location dependent LOVs
Add ability to search downloads by LOV columns available
Add default distribution qty
Recall download prior settings form
Add Supplier & Site for PO download
Improve no line amt message
Check if Exp Item date required during upload
Check if need by required during upload
Reduce DB calls and load into arrays where possible to further improve speed

2.1.15 (11-Nov-2004)

Added Billable flag to Workflow call for Capitalisable transactions

2.1.14 (10-Nov-2004)

Correction to Account defaulting for Source = Inventory

2.1.13 (01-Nov-2004)

Stop operation if user not setup with an employee

2.1.12 (21-Oct-2004)

First release. Built on R11i 11.5.8 and 11.5.9

1.0.64 (11-Sep-2014)

Added Contact Phone as a dependent column for Smart Form
Source button on form now has proper description

1.0.63 (09-Sep-2014)

Document Type and Number are now defaulted from the Smart Form when possible
The Source buttons will now retrieve the Exchange details from the Document number
No longer passing document details to the autosource call, this was causing incorrect return results

1.0.62 (08-Sep-2014)

Implemented Contact Name as Smart Column
Do not upload Currency details when currency is the base currency and sourcing mode is full sourcing
Refreshing over 1000 records will now use a batching technique

1.0.61 (02-Sep-2014)

Removed Contract column as it is not implemented. Will be added in next release Restricted SmartForm LOV to Non-Catalog Requests
Restrict Project Number download by Operating Unit to prevent multi-row error
Implemented Supplier and Supplier Site as Smart Columns

1.0.60 (29-Aug-2014)

Project number is now retrieved through a nested sql statement so reqs without projects are returned
Removed "Job" from the name of Operation Sequence and Resource Sequence
Changed CreateWorkFlowParams back to original validation method, seems to work fine now

1.0.59 (27-Aug-2014)

Updated Dependence/ValidateDependence to fix bug with missing columns
Fixed error from opening/closing section forms when DFF columns were not on the sheet
Fixed attAttachmentMod so that attachment indexes are reset when column headers change
Altered project number download record for when the project doesn't exist in pa_projects_all

1.0.58 (25-Aug-2014)

In ValidatorDestinationType, fixed validation logic around Outside Operation/Shop Floor Added columns Job Line and Resource Sequence. Renamed Job Sequence to Operation Sequence

1.0.57 (22-Aug-2014)

Updated ValidatorExchange, SQLParameter and ValidateDependence
Removed De/Normalise buttons for further investigation
In ValidatorProjectInfo, INV/SHOP SQL now has project_id as the third column to match the form control's bound column

1.0.56 (21-Aug-2014)

Added Document Type to the Quotation Download overrideSQL
Changed Exchange Rate SQL to include SHOW_CONVERSION_RATE for ValidatorExchange change
Changed Projects "OverrideTable" to pa_projects_expend_v
Retrieve the Document Type from the Base Table

1.0.55 (20-Aug-2014)

Made adjustments to Project LOV as per functional findings
Changed ValidatorUnitPrice - SourceFromDocument to return a Double instead of Long so we get decimal places

1.0.54 (12-Aug-2014)

Selecting Partial Sourcing mode will now pass 'N' for autosource_flag, Partial Sourcing is now only for controlling the Wizard "Source" buttons
Caching Profile Options POR_DEFAULT_DELIVER_TO_LOCATION_ID and POR_DAYS_NEEDED_BY for defaulting
In ValidatorSmart, call helper.setblank on blank values at the end to ensure required column are made invalid
Change Job SQL to match Oracle trace, correctly implemented Job Sequence Validator
Removed "Contract" from the Download Form PO Type LOV
Catalog Supplier Item SQL no longer joins to the PO Lines table
Added Line GL Date, Renamed GL Date (Dist Level) to Dist GL Date. Added Encumberance validation for both columns
Fixed bug where Refresh would write Req Number into the Header ID Column
Fixed error when opening Lines Form by double clicking a DFF Attribute cell

1.0.53 (05-Aug-2014)

Call InitialiseColumns in InitializeAttachmentSections so that we can set the WSection property

1.0.52 (04-Aug-2014)

Implemented De/Normalisation

1.0.51 (29-Jul-2014)

Fixed Download Form and Download Interface so they now use the new pa_search_results_temp instead of ak_loader_temp
Added ValidatorItemDescription which determines the requiredness of description based on the item

1.0.50 (25-Jul-2014)

Changed Exchange Rate data type on upload from C_TEXT to C_DECIMAL for EU decimal separator issue

1.0.49 (22-Jul-2014)

Closed toolbox for Lines Form
Header ID and Req Number will now be returned if the first line errors yet the Req is still created
Do not pass the form when using autosource from sheet
Sourcing Mode now dictates how the Source button works both on the sheet and in the form
ValidatorSmart will no longer overwrite smart values with a default

1.0.48 (14-Jul-2014)

Now excluding "TEMP_LABOR" Line types from the LOV
Fixed error when using "Source" button on lines form beyond the first line
When using the Preview Source button, processed rows will no longer be sourced
The Preview Source button will now source the selected rows rather than the entire sheet
Modified some multicall caching to ensure PO_PRICE_BREAK_GRP is cached, even if it's less than 0
When caching the HR table, check [owner = USER] rather than [owner = 'APPS'] as in some cases it is not 'APPS' i.e. 'APPS_APPL'
Updated common code
Updated Core 209 and updated modFlex for 12.2 fix. Non-standard modFlex
Changed the upload to use StateStep instead of AccumulateSQLBlock to eliminate orphan distribution issues
Added Equals Operators into the exchangeRate SQL due to new sqlParameter changes
Fixed up logic in LoadSourcingDataToRow to prevent validation error, also now validates the price column on the form after sourcing
Added Job and Job Sequence to download
Refresh will check AttachmentsNeedUploading before running UploadAllAttachments

1.0.47 (27-Jun-2014)

Implemented ValidatorParent for Unit of Measure when ENFORCE CATALOG is enabled
Changed Emergency PO Number form to Header and appended "_1" to the control name to retrieve the data
Updated Common Modules for KFF issue
Need by Date validation has been simplified to Require Need by Date when we have an Item as the Interface acts different to Oracle forms
ValidatorSmart now defaults the value if the field is blank OR ENFORCE CATALOG is enabled
Removed redundant smartform validators

1.0.46 (26-Jun-2014)

Fixed up order of initialise columns to reflect the recent dependency changes
Modified ValidatorCategory to overwrite values for ENFORCE CATALOG and also get the ID after defaulting

1.0.45 (26-Jun-2014)

Removed comments from Template123
Use the ValidatorParent for Catalog Supplier Item defaulted columns so we can overwrite when the profile option is set
Changed Implementation of various Line section Columns to cater for Catalog Supplier Item defaulting
Added Category to the smart form defaulting
Made Status a mandatory and required column

1.0.44 (25-Jun-2014)

Fixed bug where validator unit price would blow up when its defaulter was nothing
Changed download sql to look at pa_search_results_temp instead of ak_loader_temp due to common code change

1.0.43 (25-Jun-2014)

Updated Common Modules
Changed initialise columns so Dest Org is added before Item because of new dependency
Project LOV changed to look at the destination org and operating unit

1.0.42 (20-Jun-2014)

Added new column Catalog Supplier Item. This will default the Item, Category, Supplier Item, UOM and Price
Added Profile Option M4APS_RW_ENFORCE_CATALOG to enable/disable the defaulting of Catalog Supplier Item
Moved column "Emergency PO Number" to the header level
Modified ValidatorNeedBy to error when Need By is less than sysdate
Fixed UOM LOV SQL to allow a null uom_class
Rewrote the UOM LOV SQL so that selecting an item with a uom_class will now restrict the UOM LOV based on that class
Item SQL will now look at the destination org if there is one, else use the inventory org
Unit Price will now default to the default price from the Item if it has one, else it will default to the api get_item_cost*uom_conversion_rate

1.0.41 (12-Jun-2014)

Changed validatorSmart to use helper.setValid instead of validate = vbTrue so that errored colours are removed for the current control when closing the form
Updated modFlex to fix dff download issue
Changed Upload to pass SYSDATE to rate_date when the exchange type is USER to prevent interface error

1.0.40 (12-Jun-2014)

Calc button on line form now calculates the line quantity based on the sum of the distribution quantities
Made the ValidateDistributionColumns - TotalDistPercent a Double instead of a Long so it allows decimal values
Unit of Measure is now restricted by the Item and Line Type Value Basis

1.0.39 (10-Jun-2014)

ValidatorSmart will now only default when the column has been determined as "editable" and there is no "smartValue"

1.0.38 (05-Jun-2014)

Changed the SQL and dependency for Destination Subinventory to look at the Destination Type instead of using ValidatorDestination
Implemented SQLParameter changes (Soon to be added to Common Modules)

1.0.37 (27-May-2014)

Added Description and UOM defaults based on Item
In CreateWorkFlowParams - instead of checking the roe.item(C_STATUS) we will now validate each workflow column
Modified Refresh code. Should be much more efficient now
Check project reference enabled, post login. Cached with key C_PROJECT_REF_ENABLED. Used in ValidatorProjectInfo
Added ValidatorNeedyBy to determine whether Need By Date is required based on Item planning codes
Changed Item SQL and Need By Date Validator Implementation due to above change
Modified ImplementationLine to prevent errors when Item column is removed from the sheet
Changed SQL for Source Organization - Needs to be reviewed

1.0.36 (13-May-2014)

Pass true to isDownload param in frmDownload->InitialiseColumns->ValidateColumnHeaders due to common code update
ValidateDistributionColumns is now set false when the totals check fails so records are not uploaded
Added ValidatorProjectDetails that invalidates values when destination type in Inventory
ValidatorSmart will now only default if the isForcedBlank boolean is false
Added ValidatorDistQuantity which will default the dist quantity based on the line quantity - existing dist quantities
ValidatorDestinationType will now error when Outside Operation line type is selected and Inventory or Expense is selected
Modified perparer LOV sql to look at users in fnd_users table
Need By Date is now a required column
Updated Core and Common Modules

1.0.35 (07-May-2014)

No Longer using ValidatorReqNumber (AUTO/SAME)
Dist Quantity now has a default of 1
Account generation no longer error in the form (Check if status exists in row)
Group-By option no longer available on the submit batches form
Refresh no longer selects cells so will not cause the user to lose their place)
Refresh now looks at the last data row on the sheet for its range rather than looping for 1500 blank rows
InitialiseColumns now called in Refresh as the sections need to be set in order to set the statuscolumns
Added defaults for Requestor, Dest Org, Deliver to Location
ValidatorApproval now correctly updates the LOV for Req Forward To when changed
Made SmartForms available for 12.2.3 (12.1.3 onwards)
Now passing SUGGESTED_VENDOR_CONTACT (The vendor name) up to the interface as it seems to be required for contact

1.0.34 (06-May-2014)

Unit Price Will now default based on the Item (also works without UOM/Source Org)
Re-enabled account generation for sheet validation

1.0.33 (30-Apr-2014)

Fixed bug where required data was not found, blowing up ValidatorUnitPrice on form open

1.0.32 (29-Apr-2014)

Changed Req Approval Path LOV sql to match Oracle forms (Exclude values outside the effective date range)
Added ValidatorUnitPrice - handled the defaulting of the Price based on the Item/UOM/Source Org

1.0.31 (18-Mar-2014)

Updated Common Code
Fixed the refresh code to bring back status and messages for all distributions (was only returning the first one)
Wizard will no longer generate the charge/accrual/variance accounts unless the button is clicked on the form

1.0.30 (17-Mar-2014)

Fixed up Download from interface sql - removed ak_loader_temp clause and project clauses for distributions
Added ValidatorDestinationType - When SHOP FLOOR is selected and the item is not an outside operation then gives an error
ValidatorDestinationType Implemented for Destination Type; Now also a dependent column of Item so it revalidated on change
Removed "msub.quantity_tracked = 1" from subinventory sql as per functional request

1.0.29 (10-Mar-2014)

Removed Parent tables and joins from distribution download sql to increase speed. These are redundant with the use of DownloadFilter procedure

1.0.28 (04-Mar-2014)

Added getDependence property to validatorEitherOrBoth which points to extension.getDependence
Get cached inventory org id instead of the source org id for Item LOV and Download Join

1.0.27 (25-Feb-2014)

Added sourcing options 'Full Sourcing' - 'Y', 'Partial Sourcing' - 'P', 'No Sourcing' - 'N' to the toolbar and upload
Fixed call to setStatusColumn in Parse_Return_String as it was passing a reference instead of an ID
DeleteSelectedRows will only run sql when it finds interface ids on the sheet (It was blowing up with empty IN statement)
Added button to toolbar that runs "PerformSourcing" function. Add to sourcing call no longer passes a control to validate

1.0.26 (10-Oct-2013)

Corrected DeleteSelectedRows delete sql for distributions as they were not being deleted
Modified DeleteSelectedRows to delete using an IN statement to reduce the amount of queries being run and the size of the SQL text
Removed active status and sysdate clauses for frmDownload quotation sql

1.0.25 (01-Oct-2013)

Commented out ClearStatusColumns in Main as it is now in the Support module
Added some conditions in InitialiseColumns to ensure sections are correct after downloading

1.0.24 (12-Sep-2013)

Set the line_id and dist_id to the column indexs in DeleteBatch as they were not set up
Made use of col.index to replace col.isset and col.cellbound, calls to setStatusColumn now pass an index instead of a letter reference

1.0.23 (24-Jul-2014)

Changed form dRec for POs to use an outerTable as the temptable procedure was being built incorrectly
Added an outer join in the PO download sql for po_line_locations join as it was not returning lines with no locations

1.0.22 (22-Jul-2013)

Added aliases to description in the frmDownload LOV sql for Template and Requisition to prevent XML invalid tag name error

1.0.21 (16-Jul-2013)

Added call to overrideSQL in DownloadSelected so the sql and filter properties are set up for a requisition download

1.0.20 (15-Jul-2013)

Open Form button on the toolbar now opens the header form
Fixed ValidateDistributionColumns, it was not validating correctly when using multiple lines. Also added a private function to make code more readable.
Rebuilt Download Form, no longer using a range, now uses DownloadFilter download method and allows wildcard filters for downloads

1.0.19 (10-Jul-2013)

Updated Common and Core 205

1.0.18 (24-Jun-2013)

Implemented DownloadFilter download method in downloadSelected
Added functions isOverrideSQLInit, overrideSQLInit and overrideSQL to manually set the sqlInit and sql based on the mode e.g. PO, Quotation
Added ClearStatusColumns to toolbar - defined Req Number as a statusColumn so it is removed using this button
Added a downloadForm for downloading Reqs, POs, Templates and Quotes as requisitions

1.0.17 (30-May-2013)

Modified validateDistributionColumns to shade cells red and add error messages using new function setDistributionsInvalid
Modified validateDistributionColumns to determine which distributions are required based on parent columns and error accordingly
Changed lineSection page to "pgLines" as it was "pgLocator"
Removed Download Data via Form button as form is not ready

1.0.16 (29-May-2013)

Corrected dependency for Destination Subinventory column

1.0.15 (28-May-2013)

Removed smartform validation from ImplementationLine for 11i instances
Removed reqApprovalPath and ReqForwardTo dRecs from ImplementationHeader
Changed join for Item download in ImplementationLines from org_id to source_organization_id as org_id does not exist for 11i

1.0.14 (02-Apr-2013)

Changed Item LOV sql to return the primary category for each item
Added ValidatorCategory to set the category based on the item when the item is entered, otherwise set to required and make it searchable
Added category to the item dependent list so it is defaulted when the item is entered/changed
Modified ValidatorCategory to disable category controls when an item is entered

1.0.13 (28-Mar-2013)

Added ValidatorDestination based on ValidatorSource to correct validation for Destination Subinventory
Removed smartForm validation for Site column as it was causing the field to default with an invalid value

1.0.12 (05-Mar-2013)

Corrected the interface download to return the values rather than Id's

1.0.11 (01-Mar-2013)

Clicking generate default accounts now displays a message to let the user know something happened
Re-arranged wraptext in refresh code to ensure message cells are not wrapped after a refresh
Added message stating the amount of attachments loaded after a refresh and "upload all attachments"
Set text wrap to false for dist message cells in setWorkflowAccount in mainDefaultFunctions
Attachments now only upload if the attach status is not "Uploaded"
Now cannot upload a line if the line status is PENDING
Added valid check in createWorkflowParams to ensure data is valid before creating params
Added check to see if params have been created before starting workflow (startWorkflow)
Now using myMsgBox in startWorkflow instead of msgBox

1.0.10 (27-Feb-2013)

Added check in refresh code to ignore the line id when refreshing if it is not numeric
Corrected setInvalid in ValidatorSmart to pass in the correct control
Set NeedByDate to not required for any line type as it is not required in Oracle forms
Changed error message when deleting from interface to display the amount of lines and dists to be deleted
Generate default accounts now does not generate if oracle returns an error/message
Fixed yesno box for overwriting accounts
Added message prompting user to clear status and id's before uploading if the status is processed
Header status now changed to deleted after a delete from interface
Account controls now validate after generating default accounts
Changed refresh Concurrent Request is still running message to say click Yes rather than Continue

1.0.09 (26-Feb-2013)

Added validateElementHierarchy to ensure only the selected row is validated when opening a form
Added order by clauses to line and dist section
Removed line_num from downloadinterface linqsql as it does not exist in the interface table
Changed delete from interface message to detail the number of lines and dists to be deleted
Added check to see if row status is PROCESSED before uploading in UploadRow

1.0.08 (25-Feb-2013)

Made Req Type header column a mandatory column
Added validation to ensure a quantity, amount or percent distribution is entered
Added numeric check to ccid values when the expenditure type is not expense

1.0.07 (20-Feb-2013)

Added a distribution value check to ensure distributions total the line amount
Fixed smart form line type defaulting. Bound column was set wrong
Removed line level approval columns
Removed header level note to buyer
Added UploadAllAttachments call to the refresh code
Removed the existing spreadsheet accounts from workflow call
Refreshing now updates the status for each distribution for the line
Deleting from the interface now deletes IDs from the spreadsheet
Renamed Expenditure Date column to Expenditure Item Date
Added yesno message box for user to confirm overwriting existing accounts based on project information

1.0.06 (18-Feb-2013)

Fixed problem with deleting from interface table - no longer uses accumulate SQL
Fixed distribution generation
Added blank test for line type dependent columns

1.0.05 (14-Feb-2013)

Set destination type to required as is not nullable in interface table
Set the default preparer using class DefaultPreparer
Removed decimal type from contact phone
Implemented [BLANK] for use with smartform defaults

1.0.04 (14-Feb-2013)

Fixed forward to validation
Added post validation workflow call to generate accounts based on project information

1.0.03 (13-Feb-2013)

Set AlwaysDisplaySearchList to true as the default
Implemented header and line attachments

1.0.02 (11-Feb-2013)

Fixed header form where it was not setting the correct header row when blank line selected

1.0.01 (31-Jan-2013)

Fixed reqForwardTo sql for searching

1.0.00 (01-Jul-2012)

Base Line