4.5.85 (20-May-2025)

Order Entry mode: Prevented To Serial Numbers being auto-populated from Serial Number during upload and added To Serial Number.

4.5.84 (16-May-2025)

Order Entry mode: Corrected freetext Serial Numbers not being uploaded.

4.5.83 (09-May-2025)

Order Entry mode: Changed Serial Number to be freetype allowing new serial numbers as well asexisting to be entered.

4.5.82 (01-May-2025)

Improved validation of Line Ship To Location.

4.5.81 (30-Mar-2025)

Reservations mode: Changed Line Number to be a string to prevent excel converting 3 segment line numbers to a time.

4.5.80 (19-Mar-2025)

Internal update.

4.5.79 (11-Mar-2025)

Internal update.

4.5.78 (11-Mar-2025)

Internal update.

4.5.77 (11-Mar-2025)

Fixed DFF issue with case sensitive table query.

4.5.76 (05-Feb-2025)

Improved line level defaulting.

4.5.75 (13-Dec-2024)

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

4.5.74 (28-Nov-2024)

Improved usability of Contact# LOVs.

4.5.73 (12-Nov-2024)

Internal update.

4.5.72 (10-Oct-2024)

Added Default Browser Login option.

4.5.71 (27-Sep-2024)

Fixed Error 428 (Object doesn't support this property or method) in procedure chunkSQLToClob of Module XPROC.

4.5.70 (10-Sep-2024)

Added Form References for :ORDER.ORDERED_DATE and :ACCOUNTING_RULE

4.5.69 (12-Jul-2024)

Provided better feedback during Order creation when the Oracle API produces an error part way through.

4.5.68 (19-Mar-2024)

Fixed 'Clear Status Columns' not clearing status columns.

4.5.67 (18-Mar-2024)

Fixed 'Clear Status Columns' clearing column names with no data present.

4.5.66 (13-Mar-2024)

Prevented ORA-01426: numeric overflow in some Quote uploads by removing the 'Margin %' value being returned after upload.

4.5.65 (08-Mar-2024)

Internal update.

4.5.64 (05-Mar-2024)

Corrected "[Ship to Location] SQL Unique Error: Unable to uniquely identify value from SQL for SQL field [location]." Issue with related customers.

4.5.63 (29-Feb-2024)

Corrected issue validating Ship To Customer# for related customers.

4.5.62 (27-Feb-2024)

Internal update.

4.5.61 (15-Dec-2023)

Corrected 'Permission denied' error when making multiple templates.

4.5.60 (12-Dec-2023)

Order Entry and Quoting modes: Added Line Shipping instructions and Line Delivery instructions to download.

4.5.59 (01-Dec-2023)

Corrected issue where uploading attachments at the same time as creating an order failed when automatic order numbering was on.

4.5.58 (03-Nov-2023)

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

4.5.57 (16-Jun-2023)

Reservations mode: Corrected Order number uniqueness error.

4.5.56 (15-Jun-2023)

Removed the need for Order Type to be entered. Note that this column must still remain on the sheet.

4.5.55 (31-May-2023)

Reservations mode: Fixed non-unique Sales Order number error.

4.5.54 (10-May-2023)

Added Description as secondary column to LOV display for Internal Item.

4.5.53 (09-May-2023)

Corrected Customer Number to ensure Excel does not drop leading zeros.

4.5.52 (02-May-2023)

Corrected Error 1001 (Key customer_id not found in WDOMRow) in procedure SetDataRowID of Module WValidatorCache.

4.5.51 (01-May-2023)

Fixed error when validating Ship to Customer Number.

4.5.50 (27-Apr-2023)

Added "ORG_ID" DFF Substitution.

4.5.49 (19-Apr-2023)

Updated Line Request Data to be a Date/Time.

4.5.48 (04-Apr-2023)

Internal update.

4.5.47 (17-Mar-2023)

Order Entry mode: Prevented a default Pricing Date from being passed to the API, along with Pricing Qty and Pricing UOM data, when the Pricing Date column has been removed from the sheet.

4.5.46 (15-Mar-2023)

Added End Customer columns to Order section and prefixed Line section columns with 'Line'.

4.5.45 (14-Mar-2023)

Improved general validation performance.

4.5.44 (06-Mar-2023)

Order Entry mode: Added end Customer Contact and End Customer Contact # columns to Lines section. This data may be needed if updating a customer which would then make other related 'customer' fields invalid.

4.5.43 (02-Mar-2023)

Order Entry mode: Added non-unique Order Number capabilities.

4.5.42 (23-Feb-2023)

Order Entry mode: Corrected ORA-0094: "SITES'.'LOCATION': invalid identifier error in Ship To Location validation.

4.5.41 (04-Jan-2023)

Internal update.

4.5.40 (23-Dec-2022)

Order Entry/Quoting mode: Corrected error when attempting to enter [BLANK] as the Order Date/Quote Date.

4.5.39 (22-Dec-2022)

Quoting mode: Corrected dependency error.

4.5.38 (13-Dec-2022)

Order Entry mode: Corrected missing data from Ship To Location LOV.

4.5.37 (09-Dec-2022)

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

4.5.36 (06-Dec-2022)

Internal update.

4.5.35 (02-Dec-2022)

Internal update.

4.5.34 (29-Nov-2022)

Internal update.

4.5.33 (23-Nov-2022)

Corrected issues caused by DFF Attributes using custom functions.

4.5.32 (22-Nov-2022)

Corrected Error 457 (This key is already associated with an element of this collection) in procedure Initialise Table of Module WDOMDataStore.

4.5.31 (17-Nov-2022)

Corrected Error 13 (Type Mismatch) in procedure CreateDKFFValidation of Module cmDescFlexFields when attempting to use an invalid 'Special' DFF Validation type.

4.5.30 (17-Nov-2022)

Corrected Background upload.

4.5.29 (27-Oct-2022)

Order Entry mode: Added some additional Form References/Substitutions.

4.5.28 (26-Oct-2022)

Order Entry and Quoting modes: Corrected Subinventory LOV validation.

4.5.27 (20-Oct-2022)

Oder Entry and Adjustment modes: Added Line number as download criteria to both Download by Sheet and Download by Form.

4.5.26 (15-Oct-2022)

Order Entry mode: Added form reference for :ORDER.INVOICE_TO_LOCATION.

4.5.25 (14-Oct-2022)

Removed some validation no longer required around Holds.

4.5.24 (13-Oct-2022)

Order Entry mode: Order and Line Hold codes are now dependent on the Hold ID when attempting to Release Hold.

4.5.23 (13-Oct-2022)

Order Entry mode: Rewrote Hold Code validation at both Order and Line level to correct missing hold codes in the LOV.

4.5.22 (04-Oct-2022)

Internal update.

4.5.21 (14-Sep-2022)

Changed Subinventory to be a searchable field in all relevant modes.

4.5.20 (08-Sep-2022)

Order Entry mode: corrected download issue with previous update so date time columns download the time component correctly.

4.5.19 (07-Sep-2022)

Order Entry and Quoting modes: Changed several date fields at line level to reflect date and time.

4.5.18 (01-Sep-2022)

Internal update.

4.5.17 (25-Aug-2022)

Corrected download issue where specifying an exact date/time would not match any data. This issue impacted multiple modes.

4.5.16 (02-Aug-2022)

Internal update.

4.5.15 (14-Jul-2022)

Sales Agreement mode: Added Upload Attachments prompt when required.

4.5.14 (14-Jul-2022)

Order entry mode: Handled error generated during List Price defaulting if providing an invalid date.

4.5.13 (08-Jul-2022)

Internal update.

4.5.12 (08-Jul-2022)

Pricing Adjustment mode: Corrected error in Download by Form when using Order Type.

4.5.11 (08-Jul-2022)

Order Entry mode: corrected Download by form issue when using Line Hold Code.

4.5.10 (15-Jun-2022)

Order Entry mode: Modified Top Model Item logic to allow for updates to existing configurable items.

4.5.09 (25-May-2022)

Order Entry mode: Defaulted Line Return Reason to be header level Return Reason.
Made Line Cancelled Flag display only. This flag is controlled by action of cancelling an order.

4.5.08 (13-May-2022)

Order Entry mode: Added for reference ORDER:ORDER_CATEGORY_CODE.
Added form reference ORDER.SHIP_FORM_ORG_ID.
Enhanced Return Reason at header and line level. Previous Return Reason at line level now moved to header level and Line Return Reason implemented at line level. Note - The Line Return Reason is required when Line Type is in the RETURN category.

4.5.07 (20-Apr-2022)

Order Entry mode: Added form reference for :ORDER_SOURCE to accommodate when BLOCK has not been specified.

4.5.06 (07-Apr-2022)

Added form references for :ORDER_TYPE and :LINE_TYPE to accommodate when BLOCK has not been specified.

4.5.05 (05-Apr-2022)

Internal update.

4.5.04 (29-Mar-2022)

Fix for One Drive saving issue by removing code from the on-save event.

4.5.03 (02-Mar-2022)

Order Entry mode: Reactivated fulfillment Set.
Added header level Return Reason.

4.5.02 (26-Jan-2022)

Order Entry mode: Added Form References for :LINE.SHIPPING_METHOD_CODE, :LINES_DETAILS.SHIPPING_METHOD_CODE, :LINE.FREIGHT_TERMS_CODE, :LINES_DETAILS.FREIGHT_TERMS_CODE, :LINE.SHIP_TO_ORG_ID, and :LINES_DETAILS.SHIP_TO_ORG_ID

4.5.01 (21-Jan-2022)

Reservations mode: Made Sales Order Number, Line Number, Need by Date, and Quantity required values.
Added defaulting of Need by Date from Schedule Ship Date, and Quantity from line.

4.5.00 (20-Jan-2022)

Updated Custom Query including:
- Added Not Equals Operator on the Download Form.
- Values with single quotes will now download correctly on the sheet.
- Removed ability to free type into the query box within the Download Form.
- Removed functionality to save and default the Last used query parameters on the Download Form.

4.4.52 (20-Jan-2022)

Reservations mode: Updated validation of Sales Order number to allow for situations where previous alpha-numeric Order Numbers had been used.

4.4.51 (19-Jan-2022)

Reservations mode: Corrected issue with Sales Order number validation causing a SQL Error ORA-01722: Invalid number.

4.4.50 (07-Jan-2022)

Added LINE.LINE_TYPE_ID form reference.

4.4.49 (07-Jan-2022)

Updated security.

4.4.48 (07-Jan-2022)

Corrected issue when Calculate Price Flag was set to Partial Price. Using Partial Price now requires both Selling Price and List Price to be populated.

4.4.47 (05-Jan-2022)

Corrected line level join to sales rep table which sometimes prevented lines from downloading.

4.4.46 (05-Jan-2022)

Order Entry mode: Added Schedule Ship Date to Download Form.

4.4.45 (03-Dec-2021)

Removed the defaulting of 'Line Price List' as this caused issues when different line level price list were being used.

4.4.44 (03-Dec-2021)

Internal update.

4.4.43 (25-Nov-2021)

Order Entry mode: Added additional validation making Order number a required field when an action of Update, Update All, Book Order, Update & Book, Cancel, or Delete is selected.

4.4.42 (23-Nov-2021)

Corrected validation issue relating to Order Entry mode Service Sub Enabled column downloading as No for non-service lines.

4.4.41 (19-Nov-2021)

Corrected error 'Upload Column Create ID's cannot be blank'.

4.4.40 (19-Nov-2021)

List Price is no longer a Display Only column due to issues booking orders when using the Freeze Price option. Selling Price and List Price are now a required value when using the Freeze Price option. Due to performance issues around defaulting the List Price value, it is recommended NOT to include this column on your sheets unless you specifically require it. It appears that the API and process does not require the actual list price of an item, but does require 'a' value.

4.4.39 (16-Nov-2021)

Conditionally passes item_id to API to correct some API errors resulting from cross-referenced items, specifically the 'Item Validation Resulted in error(s)' message.

4.4.38 (03-Nov-2021)

Corrected bug falsely reporting the Extension Package status on the About form.

4.4.37 (22-Oct-2021)

corrected issue where Sales Agreement lines had the customer# uploaded instead of the customer ID.

4.4.36 (05-Oct-2021)

Internal update.

4.4.35 (01-Sep-2021)

Internal update.

4.4.34 (04-Aug-2021)

Internal update.

4.4.33 (06-Jul-2021)

Reservations mode - Corrected SQL error when using Status of Order as download by sheet criteria.

4.4.32 (02-Jul-2021)

Updated Background Upload process to reflect the Pending status of sections other than the Order Header.

4.4.31 (25-Jun-2021)

Resolved an issue in Order Entry mode around validation of custom Item Identifier types in relation to cross referenced items.

4.4.30 (20-Jun-2021)

Corrected Customer Name validation to account for blank First Name.

4.4.29 (26-May-2021)

Corrected missing Line Context upload in Order Entry mode.

4.4.28 (25-May-2021)

Removed Created By from the default template. If you wish to utilize this column, please add this to your templates.

4.4.27 (25-May-2021)

Added Created By column to Order Entry mode as display only and provided ability to download by sheet and form.

4.4.26 (24-May-2021)

Updated security.

4.4.25 (19-May-2021)

Updated security.

4.4.24 (09-Apr-2021)

Corrected 'PLS-00302: component /PRICING_QUANTITY_OUM/ must be declared' error.

4.4.23 (08-Apr-2021)

Updated security.

4.4.22 (08-Apr-2021)

Added six additional form references - :ORDER.SOLD_TO, :ORDER.ORDER_NUMBER, :LINE.ITEM_DESCRIPTION, :LINE.REFERENCE_HEADER_ID, :LINE.REFERENCE_LINE_ID & :LINE.CUST_MODEL_SERIAL_NUMBER_MIR

4.4.21 (29-Mar-2021)

Corrected incorrect Line level Customer Number form references that resulted in incorrect downloaded Returns Order Number and Line Number in certain scenarios.

4.4.20 (25-Mar-2021)

Corrected error -12000 (Automation error) in procedure CompareVersions.

4.4.19 (18-Mar-2021)

Added defaulting to Pricing Date - Defaults to Order Date from the Header section.

4.4.18 (01-Mar-2021)

Internal update.

4.4.17 (23-Feb-2021)

Quoting mode: Corrected API error generated when trying to update a non-existent line number.

4.4.16 (16-Feb-2021)

Quoting mode: Corrected issue when retrieving Unit Cost to use the Order Warehouse should the Line level Warehouse not be populated.

4.4.15 (09-Feb-2021)

Quoting mode: Flagged Quote Number and Line Number as 'ID' columns that will be cleared when using the 'Clear Status and ID columns' ribbon option. Also improved the defaulting of Unit Cost.

4.4.14 (05-Feb-2021)

Added DFF form references for :ORDER.INVOICE_TO_CUSTOMER_NUMBER and :ORDER.ORDER_SOURCE.

4.4.13 (03-Feb-2021)

Quoting mode: Added defaulting of Unit Cost.

4.4.12 (25-Jan-2021)

Resolved is calculating Margin on Quote download when unit_selling_price is 0.

4.4.11 (18-Jan-2021)

Order Entry mode: Added Demand Class at both header and line level. These new columns are not part of the default sheet and must be added via Templating.

4.4.10 (15-Dec-2020)

Order Entry mode - Implemented DFF Attribute form references for the Header DFF Attributes.

4.4.09 (07-Dec-2020)

Sales Agreement mode: Corrected Download by Form issue with Start Date.

4.4.08 (03-Dec-2020)

Fixed missing Line Shipping Method download data.

4.4.07 (03-Dec-2020)

Security update.

4.4.06 (16-Nov-2020)

Fixed API error relating to some item validation of Cross Referenced Items.

4.4.05 (01-Sep-2020)

Prevent NULL values being returned to the sheet from an API call which resulted in sheet data being replaced with the NULL.

4.4.04 (31-Jul-2020)

Performance improvements to Bill To Location columns

4.4.03 (21-Jul-2020)

Performance improvements for various validation queries.

4.4.02 (02-Jul-2020)

Fixed Download by Sheet error when using status as a filter.
Changed Download form Customer Number field to be From/To.
Corrected Download Form Quote Number search to return only Quotes.

4.4.01 (30-Jun-2020)

Added Quote Name and Expiration Date columns to Quoting and corrected Quote Date download issues.

4.4.00 (29-Jun-2020)

Quoting Mode added.
Order Entry Mode - Added optional quoting reference fields. Restricted to exclude records that are currently Quotes.
Performance update.

4.3.08 (16-Apr-2020)

Reservations mode: Prevented error when multiple 'on-hand' records exists during Lot validation.

4.3.07 (13-Mar-2020)

Fixed 11i upload issue PLS-00306: wrong number or types of arguments in call to 'PROCESS_ORDER'.

4.3.06 (03-Mar-2020)

Security updated.

4.3.05 (25-Feb-2020)

Added Display Only column Qty Shipped to Order Entry Lines.

4.3.04 (14-Feb-2020)

Extended Order Entry Task validation to exclude tasks with a past completion date.

4.3.03 (11-Feb-2020)

Rebranding of logo and new color scheme.

4.3.02 (07-Feb-2020)

Reservations Mode: Locators not returning correct data.

4.3.01 (28-Jan-2020)

Corrected issue where some columns would not show as valid due to the state of the Customer Relationships Flag profile setting being NULL. Added Locator defaulting.

4.3.00 (21-Jan-2020)

Reservations mode: Added Locator and included potential defaulting of Subinventory and Locator from Lot Number.

4.2.07 (03-Jan-2020)

Security updated.

4.2.06 (23-Dec-2019)

Security updated.

4.2.05 (20-Dec-2019)

Pricing Adjustment mode - Corrected SQL error relating to Order Number when % is left in the form field.

4.2.04 (20-Dec-2019)

Sales Agreement mode - Corrected default Line action when using Create All.
Reservation mode - Resolved issue when leaving a % in Reservation ID on the form.

4.2.03 (17-Dec-2019)

Corrected missing Internal Item in Sales Agreement downloads when no Warehouse has been specified.
Add Create action at Line level of Sales Agreements to distinguish between creating a new agreement and adding a new line to an existing agreement.
Resolved 'Form cannot be shown as not set up for column Order Number' when double-clicking in the Order Number column of Price Adjustments.

4.2.02 (13-Dec-2019)

Disabled Customer Contact columns in Sales Agreement mode pending further investigation.
Corrected validation of SO Number in Reservation mode that may have resulted in multiple records causing a validation failure.
Prevented [BLANK] from being entered in Sales Agreement Type column of Sales Agreement mode.
Corrected issue where Agreement uploads with no actions returning an 'Accepted' status.
Added Reservation ID to be cleared via 'Clear Status and ID Columns'.

4.2.01 (10-Dec-2019)

Corrected issue with Sales Agreement Download form showing incorrect fields.

4.1.24 (05-Dec-2019)

Resolved ORA-00932: inconsistent datatypes: expected CHAR got NUMBER when attempting to validate Line Shipping Method in Order Entry mode.

4.1.23 (28-Nov-2019)

Changed Project and Task columns to only be available from R12.
Added :LINE.DELIVER_TO_ORG_ID form reference.
Correct Trial Licence issue.

4.1.22 (21-Nov-2019)

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

4.1.21 (18-Nov-2019)

Corrected Exchange Type download providing incorrect data.

4.1.20 (11-Nov-2019)

Security update.

4.1.19 (29-Oct-2019)

Enforced Sales Order Number in Reservations mode to be numeric.

4.1.18 (24-Oct-2019)

Corrected substitution value for LINE.sold_to_org_id to reference Customer Number instead of account_id and added missing Return DFF data to downloads.

4.1.17 (18-Oct-2019)

Sales Agreement mode caused SQL error when using Activation Date in Download form.

4.1.16 (18-Oct-2019)

Fixed error when downloading by sheet has date criteria.

4.1.15 (15-Oct-2019)

Upload changes in Sales Agreement mode to allow 11i compatibility.

4.1.14 (14-Oct-2019)

Security update.

4.1.13 (14-Oct-2019)

Added ONT_OEXOEORD|Enter Sales Order security function to Order Entry and Pricing Adjustment modes.

4.1.12 (10-Oct-2019)

Removed future date restriction from Line Activation Date in Sales Agreements mode.

4.1.11 (03-Oct-2019)

Removed validation to ensure Sales Agreement activation date is a future date.

4.1.10 (01-Oct-2019)

Corrected issue of not being able to select Sales Agreement Types that had no corresponding Contract Template.

4.1.09 (26-Sep-2019)

Renamed Order Number column to Sales Order Number.
Added Status of Sales Order options to Download by form.
Added Line Number as Download by form criteria.
Removed Reservation ID from download criteria.

4.1.08 (24-Sep-2019)

Renamed Header Number column to Order Number.
Added ordering of Reservation download by reservation_id.

4.1.07 (23-Sep-2019)

Corrected Order header_id being passed to API.

4.1.06 (19-Sep-2019)

Added Disallow New Releases column to Sales Agreements mode.

4.1.05 (13-Sep-2019)

API Error: The reservation cannot be created because input ship_ready_flag is missing.
Reservations download form produces ORA-00918: column ambiguously defined.

4.1.04 (10-Sep-2019)

Security update.

4.1.03 (06-Sep-2019)

Added additional display only columns to Reservations mode.

4.1.02 (05-Sep-2019)

Corrected issues with Download by sheet.

4.1.01 (05-Sep-2019)

Performance improvement.

4.1.00 (05-Sep-2019)

Added Reservations mode.

4.0.10 (05-Sep-2019)

Corrected issue where template sub-headings were not appearing on the sheet.
User Status not validating correctly.
Fixed issue where Addins (ADFDi) would cause Jscript execution to fail.
Added templating ability to move Order by columns outside of specified section.
Added LINE.SUBINVENTORY to form references.
Added ORDER.SALESREP_ID form reference.

4.0.09 (09-Aug-2019)

Removed Order Date defaulting for new orders.

4.0.08 (06-Aug-2019)

Substitution DFF error: Attribute Line Number is missing from the template for resolving ATTRIBUTE16 substitutions.
Reviewed uploading of multiple orders.
Added functionality to use Qty Reserved column.

4.0.07 (08-Jan-2019)

Fixed issue where booking an order using action "Update & Book" would cause subsequent orders with action "Create" or "Update" to also be booked.

4.0.06 (08-Jan-2019)

Fixed issue where booking an order using action “Create & Book" would cause subsequent orders with action "Create" to also be booked.

4.0.05 (18-Jul-2019)

Added :ORDER.ship_to_address5 as a form reference.

4.0.04 (18-Jul-2019)

Resolved Hold Code SQL issues.

4.0.03 (15-Jul-2019)

Added Order Organizer security access.

4.0.02 (15-Jul-2019)

Updated Shipping Method validation to better reflect EBS.

4.0.01 (11-Jul-2019)

API Error: ORA-01403: no data found when updating lines.

4.0.00 (01-Jul-2019)

Major improvements in performance and memory management, allowing greater volumes of data processing.
Expanded Template functionality to enable you to customize worksheets to better meet your business needs.
Ability to process multiple actions (Create, Update, and Delete) in the same worksheet at the same time.
Enhanced Hold management at Order and Line level.
Support the integration of Sales Agreements at Order and Line levels.
Enhanced Pricing Adjustments management.
Modernized ribbon and colors to improve usability.

3.5.00 (11-Apr-2019)

Updated version number for release.

3.4.62 (11-Apr-2019)

Resolved issues when clicking Create on the Customize Fields form and the Template123 sheet no longer exists.

3.4.61 (11-Apr-2019)

Resolved issues when selecting Edit Template from Setup ribbon and the Template123 sheet no longer exists.

3.4.60 (10-Apr-2019)

Fixed issue where lines created in Single upload mode caused erroneous order numbers to be returned.

3.4.59 (10-Apr-2019)

Prevented download by sheet when a valid range below row 10 is not selected.
Resolved issues when first selecting Edit Template from Setup ribbon not performing correctly.

3.4.58 (06-Mar-2019)

Bill To Location and Ship To Location providing incorrect form references.

3.4.57 (05-Mar-2019)

Customer Item Cross Reference not defaulting correctly.

3.4.56 (01-Nov-2018)

Updated security.

3.4.55 (29-Oct-2018)

Error in download - Project causing multiple records.

3.4.54 (25-Oct-2018)

Error in downloading - No Project Number appearing.

3.4.53 (17-Oct-2018)

Added ORDER.CUSTOMER_NUMBER as a form reference.

3.4.52 (16-Oct-2018)

Added ORDER:SHIP_TO_ORG_ID as a form reference.

3.4.51 (09-Oct-2018)

Updated security.

3.4.50 (03-Sep-2018)

Updated security.

3.4.49 (13-Jul-2018)

DFF error when $:FLEX$ used in default values - currently unsupported.

3.4.48 (12-Jul-2018)

Cannot specify scheduled date without Order Date Type column.

3.4.47 (03-Jul-2018)

Internal enhancement.

3.4.46 (03-Jul-2018)

Updated security.

3.4.45 (29-Jun-2018)

Fixed issue with DFF sections having dependencies.

3.4.44 (15-Jun-2018)

Some holds not appearing in LOV.

3.4.43 (13-Jun-2018)

Added bill to customer number to upload.
Updated defaulting so that line bill to customer defaults to head bill to customer if present, otherwise remains as head customer.
Added form substitution ORDER.SOLD_TO_ORG_ID.

3.4.42 (31-May-2018)

DFF Attribute error while uploading Sales order lines.

3.4.41 (09-May-2018)

Update PO number error when More4Apps: SOW Disallow Used PO Numbers = Yes.

3.4.40 (03-May-2018)

Fixed issues when Customer Name and/or Item Identifier columns were removed from sheet.

3.4.39 (02-May-2018)

Fixed line number validation for orders with more than 1000 lines.

3.4.38 (30-Apr-2018)

Modified Customize Fields form.

3.4.37 (27-Apr-2018)

Added :LINE.line_id as a form reference.

3.4.36 (19-Apr-2018)

Internal update.

3.4.35 (18-Apr-2018)

Renamed Custom Query button from 'Load from Cell' to 'Load from File'.
Customer Contact column incorrectly identifying duplicates on download.

3.4.34 (16-Apr-2018)

Added Line level Price List to List Price API call - defaults to header level if not supplied.

3.4.33 (13-Apr-2018)

Corrected form substitution for Currency Code in Return DFF.

3.4.32 (09-Apr-2018)

Changed SQL for Hold Code LOV.

3.4.31 (06-Apr-2018)

Corrected date restrictions on Header level price list LOV.

3.4.30 (06-Apr-2018)

Improved performance issues on large data downloads.

3.4.29 (05-Apr-2018)

Renamed ribbon DFF Form labels.

3.4.28 (04-Apr-2018)

Ambiguous column in Download form.

3.4.27 (03-Apr-2018)

Added Trading Partner DFF columns at line level.

3.4.26 (12-Mar-2018)

Added profile option to prevent creation of Sales Orders when the specified PO Number has already been used.

3.4.25 (07-Mar-2018)

Resized 'Customize Fields' form in order to show the Create/Close buttons.

3.4.24 (02-Mar-2018)

Added form reference ORDER.SOURCE_DOCUMENT_ID.

3.4.23 (01-Mar-2018)

List Price not always being returned.

3.4.22 (22-Feb-2018)

Added Ship Address to be downloaded when column is added to sheet.

3.4.21 (14-Feb-2018)

Updated Download Wizard modules - profile options renamed.

3.4.20 (12-Feb-2018)

Updated Download Wizard modules - now called Custom Query.

3.4.19 (09-Feb-2018)

Corrected issues with applying and releasing holds.

3.4.18 (18-Jan-2018)

Attachments not allowing Long Text option.

3.4.17 (14-Dec-2017)

Attachment upload error with no reason.

3.4.16 (12-Dec-2017)

Add scheduled ship date by default unless Order Date Type is Arrival.

3.4.15 (28-Nov-2017)

Download form selecting incorrect line status.

3.4.14 (28-Nov-2017)

Line level filters restrict lines downloaded.

3.4.13 (21-Nov-2017)

Download Form now closes after download.

3.4.12 (20-Nov-2017)

Fix for unhandled VBA error: Run-time error '9999': fndRibbon.OpenWizardRibbon encountered a runtime error at line 80.

3.4.11 (14-Nov-2017)

Added check for non-existing parent Model for ATO/PTO items.

3.4.10 (13-Nov-2017)

Added access via Order Organizer.

3.4.09 (03-Oct-2017)

Updated Security.

3.4.08 (29-Sep-2017)

Corrected functionality relating to ATO/PTO items.

3.4.07 (21-Sep-2017)

DFF icon - Leaving [X] in worksheet.

3.4.06 (20-Sep-2017)

Downloading large Qty of data resulted in duplicate child record.

3.4.05 (20-Sep-2017)

Whitespace is not allowed in Downloader form.
Buttons not showing correctly in Customize Fields form.
Lines duplicating using download form.

3.4.04 (19-Sep-2017)

Download via Form excluding records when using a single date.
Error 5 (Invalid procedure call or argument) in procedure SetImplementation of Module SalesOrderLIneImp.

3.4.03 (15-Sep-2017)

Corrected issues with Customize Fields.

3.4.02 (15-Sep-2017)

Error 5 (Invalid procedure call or argument) in procedure validate of Module ValidatorListPrice.
Removed the 'More4Apps: SOW Concurrent' profile option.

3.4.01 (14-Sep-2017)

Updated example sheets.

3.4.00 (13-Sep-2017)

Return DFF columns not downloading all data.

3.3.99 (11-Sep-2017)

Contract Start/End Date incorrectly formatted.

3.3.98 (11-Sep-2017)

Fixed validation failures on subsequent order lines.

3.3.97 (08-Sep-2017)

Replaced in v3.4.01 - Contract columns Link Order Number and Link Line Number removed as unrequired and problematic.

3.3.96 (07-Sep-2017)

Corrected issue when updating an order that contained just the defaulted 'Service Sub Enabled' flag.

3.3.95 (07-Sep-2017)

API error requiring Service Reference Type Code when provided in sheet.

3.3.94 (05-Sep-2017)

Made Internal Item mandatory.

3.3.93 (06-Sep-2017)

Fix validation failure on multi line Service orders.
Corrected Order Type LOV.
Ordered header Warehouse and made name more visible in form.

3.3.92 (05-Sep-2017)

Correct Service Record uploads.

3.3.91 (04-Sep-2017)

Corrected line ordering in download.

3.3.90 (04-Sep-2017)

Fix for Error 5 (Invalid procedure call or argument) in procedure SetReturnResults of Module Main when some columns removed.

3.3.89 (01-Sep-2017)

Fix for missing Price Lists when Order Date column removed from sheet.

3.3.88 (29-Aug-2017)

Corrected issues when Service Dates are included.

3.3.87 (24-Aug-2017)

Resolved first time validation failure of Price List.

3.3.86 (23-Aug-2017)

Stopped Wizard from downloading data after it was uploaded.
Added profile option to enable downloading order data after upload.
Changed Adjustments validation to better handle auto applied adjustments when uploaded.

3.3.85 (21-Aug-2017)

RETURN order type not returning correct items.

3.3.84 (21-Aug-2017)

Added form substitution for Currency Code in Return DFF.

3.3.83 (21-Aug-2017)

Customer Item Number cross referencing returned additional items

3.3.82 (16-Aug-2017)

Package Exception: ORA-01422: exact fetch returns more than requested number of rows.

3.3.81 (15-Aug-2017)

Fix for CUST cross referenced items.

3.3.80 (14-Aug-2017)

Added Debug button to ribbon.

3.3.79 (14-Aug-2017)

Removed Item Validation options from ribbon as no longer utilized.

3.3.78 (14-Aug-2017)

Logo sizing incorrect on new sheet.

3.3.77 (14-Aug-2017)

Updated Security.

3.3.76 (10-Aug-2017)

Template not formatting correctly when Status columns removed.

3.3.75 (07-Aug-2017)

Customer Name/Number missing bind variable.

3.3.74 (03-Aug-2017)

Serial Numbers are no longer mandatory.

3.3.73 (07-Jul-2017)

Changed how Order Type is defaulted from Customer.

3.3.72 (07-Jul-2017)

Price List LOV issues resolved.

3.3.71 (04-Jul-2017)

API call modified to reflect changes in cross referenced items.

3.3.70 (03-Jul-2017)

Updated Security.

3.3.69 (03-Jul-2017)

Some cross referenced items not appearing in Internal Item LOV.

3.3.68 (28-Jun-2017)

Corrected issue where Price List LOV was not returning some entries.

3.3.67 (27-Jun-2017)

Corrected issue where orders with not exchange date or type was causing an incorrect validation message.

3.3.66 (26-Jun-2017)

Corrected issue where orders without an exchange date were failing without identifying error message.

3.3.65 (23-Jun-2017)

Corrected issue where orders with a conversion type but no conversion date failed validation.

3.3.64 (09-Jun-2017)

Error 5 (Invalid procedure call or argument) in procedure validate of Module ValidatorItem.

3.3.63 (09-Jun-2017)

Corrected issue where Ordered Date was not selecting all orders for that date.

3.3.62 (07-Jun-2017)

Column removals caused SQL errors.

3.3.61 (06-Jun-2017)

Ordered Date added to Download via Sheet options.

3.3.60 (06-Jun-2017)

Updated Security.

3.3.59 (22-May-2017)

Error: ORDER OR LINE FAILED: Item Validation Resulted in error(s).

3.3.58 (13-May-2017)

Extended error handling on ListPrice validation

3.3.57 (08-May-2017)

Order Types being excluded on future dated orders.

3.3.56 (26-Apr-2017)

'The picture is too large and will be truncated' error.

3.3.55 (24-Apr-2017)

Orders not downloading when Deliver To Location is blank.

3.3.54 (24-Apr-2017)

Error 5 (Invalid procedure call or argument) in procedure ReplaceFlexDefaultValue of Module modFlex.

3.3.53 (20-Apr-2017)

Added additional debugging information.

3.3.52 (06-Apr-2017)

Line level DeliverToContact downloading incorrect value.

3.3.51 (05-Apr-2017)

Line level ShipToContact returning incorrect LOV.

3.3.50 (04-Apr-2017)

Downloaded data not validating due to multiple potential data entries.

3.3.49 (04-Apr-2017)

SQL performance improvements to Contact and Address columns.

3.3.48 (04-Apr-2017)

Download via Sheet and Download via Form not download correctly.

3.3.47 (03-Apr-2017)

Addition of Qty Reserved column at line level (display only).

3.3.46 (03-Apr-2017)

Updated Security.

3.3.45 (09-Mar-2017)

Addition of Deliver To related columns at Header and Line level.

3.3.44 (09-Mar-2017)

Error 457 in procedure Create of module SQLParameters.

3.3.43 (06-Mar-2017)

Updated Security.

3.3.42 (23-Feb-2017)

Added Packing Instructions column at header level.

3.3.41 (23-Feb-2017)

Sales Order form throw Invalid procedure call or argument in procedure validate of Module SOWValidatorPaymentType.

3.3.40 (23-Feb-2017)

ORA-01403: no data found in Package OE_Order_GRP Procedure Automatic_Account_Creation

3.3.39 (08-Feb-2017)

Download form causing SQL error when using line based column criteria.

3.3.38 (08-Feb-2017)

Updated Download Wizard to v1.0.71

3.3.37 (08-Feb-2017)

Updated Security.

3.3.36 (07-Feb-2017)

SQL performance improvements.

3.3.35 (03-Feb-2017)

Changed line ordering on download to order the same way as displayed in the EBS forms.

3.3.34 (02-Feb-2017)

Fixed the issue of not loading PO Number if default value is passed as Formula.

3.3.33 (01-Feb-2017)

Changed browser settings to suppress JavaScript errors during login.

3.3.32 (15-Dec-2016)

Improved performance around header Subtotal, Tax, and Charges value columns.
Line level column List Price changed to Display Only.

3.3.31 (14-Dec-2016)

Removed summary_flag = 'N' criteria from DFF value selection.

3.3.30 (12-Dec-2016)

Added line breaks in upload SQL to prevent line length issues.

3.3.29 (26-Oct-2016)

Internal fixes.

3.3.28 (22-Oct-2016)

Changed the following form fields to long-list LOV's:
Header level Customer Contact, Payment Terms, Ship Contact, Bill Contact
Line level Payment Terms, Ship Contact, Bill Contact

3.3.27 (21-Oct-2016)

Corrected failure of invoice retrieval in Return DFF section.
Added some required defaulting:
Line level Bill To customer defaults to header level Bill To customer
Header level Bill To customer defaults to header level Customer Number
Header level Currency Code defaults to header level Price List currency code
Header level Price List defaults to header level Customer Number price list

3.3.26 (13-Oct-2016)

Extension package usability improvements.

3.3.25 (04-Oct-2017)

Updated Security.

3.3.24.7 (23-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.

3.3.24 (12-Sep-2016)

Updated Security.

3.3.23 (09-Sep-2016)

Validation fails requiring serial number when it has been provided.
Updated Downloader to v1.0.59.

3.3.22 (08-Sep-2016)

UOM LOV failed to populate.

3.3.21 (08-Sep-2016)

Shipping Method LOV failed when warehouse not assigned to ordertype.

3.3.20 (27-Aug-2016)

Added Extension Package functionality.

3.3.19 (27-Aug-2016)

Made: ORDER.header_id available to DFF value sets.
Updated Downloader to v1.0.57.

3.3.18 (25-Aug-2016)

Fixed Shipping Method API Validation at line level.

3.3.17 (23-Aug-2016)

Fixed Shipping Method API Validation at header level.

3.3.16 (12-Aug-2016)

Fixed Whitespace error on validation in 11i.

3.3.15 (10-Aug-2016)

Ship Method now linked to Order Type to obtain Warehouse ID.

3.3.14 (10-Aug-2016)

"Only one top level element is allowed in an XML document." when determining List Price.

3.3.13 (09-Aug-2016)

Ship Method not returning all entries.

3.3.12 (08-Aug-2016)

Fixed Order Type returning incorrect numbering method.

3.3.11 (05-Aug-2016)

Fixed Order Type not returning all possible values.

3.3.10 (04-Aug-2016)

Fixed automation error when trying to open the order form after closing via the [X].

3.3.09 (04-Aug-2016)

Fixed unable to create orders with manual order number.

3.3.08 (28-Jul-2016)

Addition of Line Request Date From and To fields on the Download Form.
Performance improvements in header download.

3.3.07 (22-Jul-2016)

Fixed List Price not validating line correctly.

3.3.06 (21-Jul-2016)

Updated Shipping Method SQL.

3.3.05 (15-Jul-2016)

Tightened validation surrounding ListPrice and Items.

3.3.04 (14-Jul-2016)

Added additional debugging abilities.
Added status bar message when retrieving list price.

3.3.03 (07-Jul-2016)

Handled incorrect API Error return when line placed on Credit Hold.

3.3.02 (06-Jul-2016)

Resolution of OrderedItem/InternalItem relationship and performance.

3.3.01 (29-Jun-2016)

Renamed Inventory Item back Internal Item.

3.3.00 (28-Jun-2016)

Rewrite of Line Item process - Column name changes to better reflect purpose: Item >> Ordered Item, Internal Item >> Inventory Item.
New form process: OrderedItem will restrict search of InventoryItem, selected InventoryItem will auto-populate ItemIdentifier and Description.
InventoryItem can be searched without having to enter any criteria as it is restricted by OrderedItem.
Changed Item Description to display only as text cannot be changed.

3.2.99 (23-Jun-2016)

Ignore validation of Adjustment Value when in Create Mode.
Prevented ListPrice calculation if OrderType not set.

3.2.98 (15-Jun-2016)

Handled Items that return a NULL item_id.

3.2.97 (13-Jun-2016)

Improved Item and Internal Item column validation to better handle multiple inventory items.

3.2.96 (02-Jun-2016)

Updated Wizard Password.

3.2.95 (31-May-2016)

No Data Found when performing ListPrice lookup.

3.2.94 (16-May-2016)

Added Line Schedule Arrival Date column with OrderDateType validation.
Corrected missing and inaccurate column comments.

3.2.90 (06-Apr-2016)

Removed maxRows feature from Download form as getting run-time error.
Fixed Line Status LOV on Download form not populating.

3.2.89 (30-Mar-2016)

Addition of Trading Partner DFF fields and Check Number/Amount.
Redesigned Order form.
Fixed issue when attempting to create a new order if order number is provided.

3.2.88 (22-Mar-2016)

Updated Security.
Fixed Error 14 (Out of string space) when downloading by form.
Fixed Order Warehouse not downloading.

3.2.87 (15-Mar-2016)

Fixed Download Wizard as was causing issues when downloading.

3.2.86 (09-Mar-2016)

Correct contacts LOV not matching duplicates correctly.

3.2.85 (08-Mar-2016)

Handled potential duplicate contact records.

3.2.84 (07-Mar-2016)

Removed CustomerContact uniqueness from LOV to match Oracle and provided Role as display column in LOV.

3.2.83 (03-Mar-2016)

Fixed Item Description not downloading.

3.2.82 (02-Mar-2016)

Added ability for DFF field with a Value Set validation type of Special

3.2.81 (29-Feb-2016)

Add Customer Contact column at Header level.
Fixed Ship_To and Bill_To Contacts as not working.

3.2.80 (23-Feb-2016)

Corrected image resizing issue on new sheet.

3.2.79 (22-Feb-2016)

Added Normalize and DeNormalize functions.
Made OrderNumber required in update mode.
Standardised PriceList retrieval between header and line.
Corrected Downloader disappearing from right click menu.

3.2.78 (22-Feb-2016)

Fixed Downloader right-click menu not appearing.

3.2.77 (04-Feb-2016)

Added Download Wizard functionality.

3.2.76 (02-Feb-2016)

ListPrice validation - added corrections/functionality to ensure that the form and multi-line orders both validate correctly.

3.2.75 (29-Jan-2016)

Implemented basic defaulting to ListPrice so that API works with minimum data.

3.2.74 (22-Jan-2016)

Added FOB column.

3.2.73 (15-Jan-2016)

CasePack validation - throw warning if line item qty is not a multiple of casepack qty (customer specific).

3.2.72 (14-Jan-2016)

Fixed bug where attribute values would be uploaded if they were in the sheet but didn’t belong to a context (ie these were attributes that hadn’t been enabled for any contexts not even Global Data Elements).

3.2.71 (29-Dec-2015)

Correct slashes and add missing http protocol so shell can send web page to default browser.

3.2.70 (23-Dec-2015)

Price Adjustments were being rounded due to incorrect column definition.

3.2.69 (22-Dec-2015)

Updated Security.

3.2.68 (22-Dec-2015)

Corrected ListPrice validation.

3.2.67 (21-Dec-2015)

Added retrieval of list price when blank and Calculate Price Flag set to Freeze Price.

3.2.66 (10-Dec-2015)

Fixed validation of set fields (ShipSet, ArrivalSet, and FulfillmentSet).

3.2.65 (04-Nov-2015)

Fix for: The item validation switches to use an internal item query when you load or validate a return. After the return is processed the item query is not switched back to the non-return item query. This explains the somewhat random behaviour ie if you log out and then try validating/uploading one of the failed items it will pass validation and uploads.

3.2.64 (23-Oct-2015)

Updated Security.

3.2.63 (14-Oct-2015)

EBS Context was not being set correctly for Order Entry. Context was being set correctly but it was broken in version 3.2.08.
Symptoms: Item query not returning some values. There is likely to be a number of other places that it causes problems.

3.2.62 (12-Oct-2015)

Added DFF Substitution for DFF Header Attribute6.

3.2.61 (07-Oct-2015)

Enforce defaulting/validation to always pick the last 'internal item' from the 'item' when the 'item' has multiple 'internal items'. Previously the first or last internal item could be chosen as the default. But the code would validate off the last internal item hence it would invalidate the internal item. Even worse the first or last internal item could change because there was no order by on the query.

3.2.60 (30-Sep-2015)

Fix the issue of getting Error 5 when uploading caused by missing Line ID column.

3.2.59 (23-Sep-2015)

Fix the issue of Command Search Button (ellipse) not enabled for Order Number Column in Update Mode.
Fix the position of the form.

3.2.58 (17-Sep-2015)

Full fix for getting error 'Invalid Identifier' if using Sales Person criteria on the download form.
SQL Error:com.more4apps.r12.servlet.ActionSqljava.sql.SQLSyntaxErrorException: ORA-00904: "REPS"."NAME": invalid identifier.
NB Partial fix was made in v3.2.54.

3.2.57 (07-Sep-2015)

Fix the issue of not creating orders if Exchange Type column is removed from Sales Header Section.
Added command search button (eclipse) for Header Ship Method and Line Ship Method Columns in the form.
Added eclipse button for header Shipping method and line shipping. Removed Message box pop up after download is complete as Processing form is Implemented for download also.

3.2.56 (31-Aug-2015)

Fix for xml error.

3.2.55 (25-Aug-2015)

Fix for the error 'Cannot run the macro 'ribLineDFF_onAction'.

3.2.54 (21-Aug-2015)

Fix for getting error 'Invalid Identifier' if using Sales Person criteria on the download form.

3.2.53 (19-Aug-2015)

Refix for bug introduced in 3.2.52 - "Oops. Item 'VFONT_VCONT14FM1' not cached. Please inform us at More4Apps."
Fix for Dff Form not opening using the form.

3.2.52 (18-Aug-2015)

Fix for bug introduced in 3.2.50 - "Oops. Item 'VFONT_VCONT14FM1' not cached. Please inform us at More4Apps."

3.2.51 (18-Aug-2015)

Upgraded support module to version 102. Core212 upgrade has broken the concurrent upload. Core212 needs Support Module version 101 upwards to work for Concurrent Uploads.

3.2.50 (14-Aug-2015)

Performance improvement.

3.2.49 (14-Aug-2015)

Added exception handling when loading header and there is no line.

3.2.48 (13-Aug-2015)

Updated to core 212. Missed some files in previous update 3.2.47

3.2.47 (13-Aug-2015)

Updated to core 212.
New core handles timeouts from 12.2.

3.2.46 (05-Aug-2015)

Check the lock for project viewing to fix the issue of VBA open while clicking debug.

3.2.45 (30-Jul-2015)

Pass the quantity as a decimal rather than a long to retain decimal placing.

3.2.44 (24-Jul-2015)

Added the ribbon.

3.2.43 (07-Jul-2015)

Ensure line status is identified as Display only.

3.2.42 (04-Jul-2015)

Corrected download sql for the Service Ref Cust Product.

3.2.41 (03-Jul-2015)

Fixed problem with the re-initialize after the Attachment Upload has been run

3.2.40 (02-Jul-2015)

Added columns Service Ref Cust Product, Service Billing Profile and Renewal Approval Flag
Ensure last Mode is set to 'Attachment' during Attachment Upload to ensure re-initialization kicks in
Added the Blanket Number column at the header level

3.2.39 (01-Jul-2015)

Ensure the DFF columns are not initialised if it is an Attachment Upload

3.2.38 (30-Jun-2015)

Ensure the dependence object is set even when the order date column is removed from the sheet

3.2.37 (30-Jun-2015)

Reset the rowsource for the Customise Field's list box to ensure saved changes are displayed to the user via the listbox

3.2.36 (30-Jun-2015)

Fixed initialisation error when the mode was changed to the delete

3.2.35 (29-Jun-2015)

Updated the CommonStubs to correct problem with the Attachment load for the Header

3.2.34 (29-Jun-2015)

Added Hold Comment as a download column

3.2.33 (25-Jun-2015)

Fixed problem when Upload Status column duplicated during sheet creation3.2.34
Added Hold Comment as a download column
Updated the CommonStubs to correct problem with the Attachment load for the Header

3.2.32 (24-Jun-2015)

Reinstated the order by against the order number on the download form

3.2.31 (24-Jun-2015)

Fixed problem with Location sql passing a second parameter that is no longer required

3.2.30 (23-Jun-2015)

Added Service Sub Enabled and Service Sub Template columns

3.2.29 (22-Jun-2015)

Excel 2013-64bit changes when the order of execution changes the way the code works in WRowDetails and dlDownload

3.2.28 (17-Jun-2015)

Added the Bill To Customer and Ship To Customer to the header section to support the CUSTOMER_RELATIONSHIPS_FLAG when set to All

3.2.27 (16-Jun-2015)

Allow order date to be blank during update. Removed the default based on the Order Number

3.2.26 (13-Jun-2015)

Changed the header location sql to use HZ_CUST_ACCOUNTS when the CUSTOMER_RELATIONSHIPS_FLAG set to ALL

3.2.25 (12-Jun-2015)

Updated the Status columns to use the fnd_lookup_values lookup_type FLOW_STATUS

3.2.24 (08-May-2015)

Removed the use of the Address during upload at line level as causing mismatch with location

3.2.23 (22-Apr-2015)

Added the Cancel Order Flag, Order Change Reason and Order Change Comment columns

3.2.22 (21-Apr-2015)

Updated the return results to use the C_ACCEPTED rather than C_LOADED

3.2.21 (20-Apr-2015)

Reorganised InitialiseColumns to incorporate the Attachment upload

3.2.20 (11-Apr-2015)

Added Pricing Modifiers. Requires Package Spec version 1.2.5

3.2.19 (14-Apr-2015)

Reset x_sob_id in the MainMultiCall from Get_Cached(CG_Set_Of_Books_ID). Fixes Base Currency being set incorrectly

3.2.18 (10-Apr-2015)

Removed Pricelist default

3.2.17 (01-Apr-2015)

Changed the header location sql to use the oe system parameter CUSTOMER_RELATIONSHIPS_FLAG to determine what customers should be available

3.2.16 (31-Mar-2015)

Use C_DECIMAL to parse the order number as C_LONG may error on big numbers

3.2.15 (30-Mar-2015)

When there are no lines pass the blank line table l_INL_Tbl Oe_Order_Pub.Line_Tbl_Type to the API

3.2.14 (26-Mar-2015)

Ensure lines exist before adding to procedure call

3.2.13 (19-Feb-2015)

Removed the use of the Address during upload as causing mismatch with location

3.2.12 (29-Jan-2015)

Made the sales person a restricted list

3.2.11 (16-Jan-2015)

Restrict the price lists to those where the list_type_code in ('PRL', 'AGR')

3.2.10 (04-Dec-2014)

Added the debug menu

3.2.09 (04-Dec-2014)

Corrected the Serial Number validation which was checking the wrong column in ValidatorItem
Fixed error on message return when the Order ID was removed from the sheet

3.2.08 (19-Nov-2014)

Updated to Common Code 011 - Implemented the CommonStubs
Fixed problem with the serial section return messages

3.2.07 (10-Nov-2014)

Added columns Line Shipping Instructions, Line Packing Instructions, Line Firm Demand Flag, Line Customer Production and Line Cust Serial Num
Updated to Core 210

3.2.06 (23-Oct-2014)

Fixed problem with price list with start date not being returned

3.2.05 (14-Oct-2014)

Added End Customer, End Cust Num and End Cust Location columns

3.2.04 (14-Oct-2014)

Fixed problem with Cross Reference verses Customer Items

3.2.03 (11-Sep-2014)

Added the Line Shipment Priority column

3.2.02 (07-Aug-2014)

Fixed problem with ValidatorExchange when the currency code was blank

3.2.01 (05-Aug-2014)

Allow the Exchange Date for USER exchange type

3.2.00 (28-Jul-2014)

Updated to Core 209 and updated to Common 003 to make 12.2 compatiable

3.1.99 (16-Jun-2014)

Changed the unique column for cItem back to ITEM_ID as it was incorrectly set to ITEM

3.1.98 (10-Apr-2014)

Added support for GTIN cross reference item numbers

3.1.97.3 (17-Dec-2014)

Fixes DFF issues - caters EBS 12.2 which has clob columns rather than long columns

3.1.97 (27-Mar-2014)

Changed screen updating to bookend disable with enable in all areas of the Wizard processing

3.1.96 (26-Mar-2014)

Made change for the processing form which was hanging on 2013
Changed screen updating to use a class to workaround issue on 2013

3.1.95 (20-Mar-2014)

Removed the status and message columns from the section by making them not data columns
Fixed problem with the dffType not being set against the section correctly

3.1.94 (12-Mar-2014)

Fixed a couple of errors in the service contract area to allow the creation of service contract records

3.1.93 (10-Feb-2014)

Corrected the return DFF upload which was passing the incorrect field name

3.1.92 (10-Feb-2014)

Added an order by to the drec on the Order Number column
Fixed duplicate line during creation caused by fix to 3.1.90

3.1.91 (10-Feb-2014)

Fixed the download of the serial lot id which was causing duplication during update

3.1.90 (10-Feb-2014)

Fixed the locator
Added conditional columns to the attachment initialization
Fixed problem with isFormReturn when form opening on incorrect row after download from sheet
Stopped the order creation if no line is specified as this creates an incomplete order
Did not load attachments during either of the delete modes

3.1.89 (23-Jan-2014)

Only allow serial numbers if a serialised product

3.1.88 (16-Jan-2014)

Ensure the DFF’s are implemented = vbTrue before they are deactivated by implemented = vbFalse

3.1.87 (15-Jan-2014)

Added Validation for the Serial Quantity to ensure that if a quantity specified then a lot/serial number has to be specified

3.1.86 (14-Jan-2014)

Ensure return messages are unique when parsing the return string

3.1.85 (03-Jan-2014)

Added columns Order Date Type and Agreement

3.1.84 (24-Dec-2013)

Included tax_value for download (column was there but download record not completed)

3.1.83 (23-Dec-2013)

Removed ” AND item_identifier_type = ‘INT’ ” from standard item validation as it was excluding cross referenced items

3.1.82 (20-Dec-2013)

Fixed problem with the use of dependence against DFF columns during download

3.1.81 (19-Dec-2013)

Added the return results for the serial/lot number section

3.1.80 (18-Dec-2013)

Fixed problem with the serial number table index not incrementing correctly

3.1.79 (09-Dec-2013)

Allow serial numbers that are not already in the system

3.1.78 (06-Dec-2013)

Ensure serial number quantities are reset between records

3.1.77 (05-Dec-2013)

Corrected problem with invalid line number in create mode
Also removed profile creation for LOAD_COUNTER which is no longer used

3.1.76 (03-Dec-2013)

Fixed validation of the serial number code

3.1.75 (21-Nov-2013)

Fixed problem with the update of the customer job

3.1.74 (20-Nov-2013)

Fixed problem with download using the form when using the line status
Fixed problem with return messages writing to the header

3.1.73 (14-Nov-2013)

Fixed problem with the DFF download where an ID based Attribute relies on a parent ID based Attribute

3.1.72 (04-Nov-2013)

Added new column customer job to the lines section
Added serial and lot location as a separate child section against the line section (requires change to package)

3.1.71 (10-Oct-2013)

Added a column form reference for customer number to be used in DFF substitutions

3.1.70 (09-Oct-2013)

Added some missing substitutions and increment the parameter number if the parameter already exists in the sql

3.1.69 (02-Oct-2013)

Added columns Line PO Line Number and Line PO Shipment Number

3.1.68 (12-Sep-2013)

Added the ability to download the attachment information

3.1.67 (10-Aug-2013)

Fixed problem when the DFF form was not saving updates to the form

3.1.66 (05-Aug-2013)

Changed the message return to use the original system document instead of the source document

3.1.65 (02-Aug-2013)

Added the ability to clear column statuses via the magic wand

3.1.64 (18-Jul-2013)

Added the Project Number and Task Number to the download

3.1.63 (15-Jul-2013)

Download the hold if one exists for the header and has not been released

3.1.62 (02-Jul-2013)

Ensure the existence of cModelLinkIndex before trying to link the model during upload

3.1.61 (29-Jun-2013)

Separated the project and task during the creation of the download sql

3.1.60 (27-Jun-2013)

Corrected the grid to set roe.item(C_STATUS)=C_VALID in setFrame to ensure records saved from Grid

3.1.59 (21-Jun-2013)

Fixed problem where an INVALID line was not stopped from uploading

3.1.58 (19-Jun-2013)

Used the currentRow for the header messages and not myrec.SOURCE_DOCUMENT_ID which appears to be invalidate between state steps calls

3.1.57 (18-Jun-2013)

Corrected tab order in Create mode

3.1.56 (13-Jun-2013)

Updated the control widths to ensure label displayed correctly

3.1.55 (10-Jun-2013)

Set the Task number to use the SearchDependentLOV
Fixed the download of the Project and Task

3.1.54 (31-May-2013)

Added the columns Ship Set and Arrival Set

3.1.53 (31-May-2013)

Core code upgrade

3.1.52 (30-May-2013)

Imported Common Attachment code, removed existing attachment code
Implemented Attachments at both header and line level

3.1.51 (28-May-2013)

Do not use the ‘begin dbms_session.reset_package;end;’ if running as concurrent program as will kill all orders regardless

3.1.50 (24-May-2013)

Changed hz_cust_acct_relate to haz_cust_acct_relate_allin Line sql for customer
If the upload errors then call ‘begin dbms_session.reset_package; end;

3.1.49 (23-May-2013)

Default price list from the Customer
Added CallOut module for customer validation extensions using the More4Apps CustomMacros sheet

3.1.48 (13-May-2013)

Set bStoreResults on call to ExecuteState and ProcessBlockDataList

3.1.47 (08-May-2013)

Fixed problem with the LineSourceDocType label not displaying

3.1.46 (07-May-2013)

Corrected issue with ProcessBlockDataList

3.1.45 (07-May-2013)

Updated the Core code to Version 204

3.1.44 (06-May-2013)

Fixed problem with DFF button when dffType note defined

3.1.43 (02-May-2013)

Found that the Convert during dff download no longer works when $FLEX in use – bypass ValidateDependence

3.1.42 (01-May-2013)

Added columns Exchange Rate, Exchange type and Exchange Date to the header

3.1.41 (26-Apr-2013)

Fixed the line status to use closed DECODE(deli.RELEASED_STATUS, ‘Y’, ‘PICKED’, ‘C’, ‘CLOSED’, line.flow_status_code)

3.1.40 (24-Apr-2013)

Fixed problem with the Order Type on the download form

3.1.39 (23-Apr-2013)

Restored downloadSelected functionality

3.1.38 (22-Apr-2013)

Added the DFF form substitutions for LINE.CANCELLED_FLAG and LINE_SUMMARY.CANCELLED_FLAG

3.1.37 (17-Apr-2013)

Fixed problem with the promise date From and To on the download form

3.1.36 (08-Apr-2013)

For R12 apply session variable fnd_client_info.set_org_context(org_id) to upload

3.1.35 (05-Apr-2013)

Added global variable traceOn to turn on the oe_order_debug

3.1.34 (19-Mar-2013)

Updated the Core infrastructure

3.1.33 (15-Mar-2013)

Now using oe_msg_pub which uses a record table which can be used to tie lines to the error in Batch mode

3.1.32 (06-Mar-2013)

Fixed problem with validation of customer items number

3.1.31 (25-Feb-2013)

Fixed problem with setup toolbar toggle between Batch and Single modes

3.1.30 (22-Feb-2013)

Fixed problem with large sales orders in 11i
Ensure dependence does not error if the columns are removed from the spreadsheet during UPDATE

3.1.29 (19-Feb-2013)

Updated Core to 203

3.1.28 (19-Feb-2013)

Fixed upload of header level dff

3.1.27 (13-Feb-2013)

Added line attributes 15 to 20

3.1.26 (07-Feb-2013)

Removed the requirement that Order Type is required

3.1.25 (18-Jan-2013)

Fixed problem where the row was not sent to parent record

3.1.24 (21-Dec-2012)

Removed trace from the attachment code

3.1.23 (12-Dec-2012)

Fixed problem with download lines

3.1.22 (28-Nov-2012)

Added organization ID to the procedure call when using R12

3.1.21 (10-Nov-2012)

Fixed problem with Automation Error caused by using the X to close form

3.1.20 (21-Nov-2012)

Added form substitutions:line.UNIT_SELLING_PRICE_DSP,:Line.INVOICE_TO_ORG_ID,:Line.SHIP_TO_CUSTOMER_ID,;Line.INVOICE_TO_CUSTOMER_ID

3.1.19 (10-Nov-2012)

Added status bar to download form

3.1.18 (09-Nov-2012)

Added override for FND_STANDARD_DATE

3.1.17 (26-Sep-2012)

Reactivated model creation

3.1.16 (13-Sep-2012)

Added check for the initialisation of service contract settings if service contract column exist

3.1.15 (03-Sep-2012)

Added support for substitution,:LINES_SUMMARY.SHIP_FROM_ORG_ID

3.1.14 (27-Aug-2012)

Fixed problem when using statestep and the MOGlobalInit was not being set correctly

3.1.13 (27-Aug-2012)

Updated generic code with fix for concurrent feedback

3.1.12 (10-Aug-2012)

Added Line Pricing Date

3.1.11 (08-Aug-2012)

Changed Wizard to only set MO_GLOBAL_INT prior to procedure call

3.1.10 (07-Aug-2012)

Added fix for the attachment 64bit compile error

3.1.09 (31-Jul-2012)

Updated generic code

3.1.08 (29-Jun-2012)

Ensure the download filter does not start with AND

3.1.07 (27-Jun-2012)

Fixed the pricing Dff

3.1.06 (26-Jun-2012)

Fixed the problem with the download form initialization

3.1.05 (22-Jun-2012)

Change the validation of columns to use a msgbox instead of an error throw

3.1.03 (10-May-2012)

Corrected a problem with booking an order

3.1.02 (23-Apr-2012)

Fixed problem with state step during large loads

3.1.00 (04-Apr-2012)

Added new data structure

2.9.36 (23-Mar-2012)

Added the Source Document, Source Document Type to both header and line
Added the Line Order Source, Line Order Source Ref and upload fields
Ensured the internal item is validated correctly when customer item in use

2.9.35 (16-Dec-2011)

Fixed problem if in Update mode and no valid lines are passed up

2.9.34 (06-Dec-2011)

Added hold and release functionality to the Wizard

2.9.33 (10-Nov-2011)

Ensure the default date time is set using Now and not System Date

2.9.32 (28-Oct-2011)

Log defaults but discontinue to show msgbox when defaulting value

2.9.31 (27-Oct-2011)

Added support for date time against the order date

2.9.30 (12-Oct-2011)

Changed the form behavior to Unload and not hide to minimize automation errors

2.9.29 (22-Sep-2011)

Updated the toolbar code to latest

2.9.28 (13-Sep-2011)

Made sure the Customize fields form displayed all columns

2.9.26 (06-Sep-2011)

Ensured the DFF was converting the defaults correctly

2.9.25 (01-Sep-2011)

Ensure the minimum columns for update are Quote Number, Customer Number and Order Date

2.9.24 (25-Aug-2011)

Added profile Required Version profile option

2.9.22 (06-Aug-2011)

Ensure form does not error when item dependent columns removed from spreadsheet

2.9.20 (06-Aug-2011)

Ensured removed dependent columns are checked in service contract section

2.9.19 (22-Jul-2011)

Added some splash to the wGrid

2.9.18 (20-Jul-2011)

Added support for multi form references against a column

2.9.17 (19-Jul-2011)

Added Attachments

2.9.16 (15-Jul-2011)

Latest Common code including new Customize column functionality

2.9.15 (14-Jul-2011)

Fixed problem with update mode when limited to Order Num and Line Num

2.9.14 (11-Jul-2011)

Added the download column Inventory_Item_Id to support the substitutions

2.9.13 (01-Jul-2011)

Added form substitutions for Line.inventory_item_id and Line.ship_to_mir

2.9.12 (24-Jun-2011)

Updated the cancelled quantity during line cancel

2.9.11 (21-Jun-2011)

Corrected the initialization of the download when columns on spreadsheet have changed

2.9.10 (16-Jun-2011)

Added Line Shipment Method and Line Freight Terms columns

2.9.09 (27-May-2011)

Corrected DFF download

2.9.08 (27-May-2011)

Added new Customize fields form

2.9.07 (24-May-2011)

Added Shipment Method and Freight Terms to the Header

2.9.05 (13-May-2011)

Added latest code to ensure DFF downloaded correctly

2.9.04 (04-May-2011)

Fixed problem with upload of Single Line

2.9.03 (09-Mar-2011)

Added a touch of splash

2.9.02 (09-Mar-2011)

Ensure the toolbar renders correctly if user is not logged in

2.9.00 (15-Feb-2011)

Introduced concurrent program processing if XML version allows

1.8.229 (04-May-2010)

Corrected line Address fields to work correctly when dependent columns removed

1.9.46 (17-Jan-2011)

Made the Header location field a searchable field

1.9.43 (10-Nov-2010)

New changes to the state step for large order loads

1.9.42 (27-Oct-2010)

Added Source Type to the lines

1.9.41 (24-Sep-2010)

Changed Header Address sql to match the Lines Address sql

1.9.40 (14-Sep-2010)

Added state step to accommodate the processing of large orders as individuals calls

1.8.39 (04-Sep-2010)

Added model group and line link to support models, classes and options

1.8.38 (11-Aug-2010)

Added cancel flag at the line level

1.8.37 (04-Aug-2010)

Corrected the status list of values on the download form

1.8.34 (02-Jul-2010)

Added p_application for Multi-Org compatibility under r12. Requires new servlet

1.8.33 (25-Jun-2010)

Changed MOAC_Org_id for r12

1.8.32 (21-Jun-2010)

Changed customer query to work with r12

1.8.31 (20-May-2010)

Added ability to process using single line api calls to allow individual line rejection and error handling

1.8.28 (28-Apr-2010)

Updated Price Lists to ensure they are restricted and that search on restricted works

1.8.25 (10-Apr-2010)

Fixed problem with UOM search

1.8.21 (30-Mar-2010)

Added the Order Source Reference field to the wizard

1.8.20 (30-Mar-2010)

Added Service Contracts to the wizard

1.7.101 (02-Mar-2010)

Added the Override ATP and Subinventory columns

1.7.100 (01-Mar-2010)

Changed caching to ensure certain queries are only run once per session

1.7.99 (05-Feb-2010)

Updated generic code for new license structure

1.7.98 (05-Dec-2009)

Fixed problem with substitution of the ORDER_TYPE

1.7.97 (21-Nov-2009)

Added Direct option for item to try and increase speed of query

1.7.96 (09-Nov-2009)

Changed Item query to remove join for UOM

1.7.95 (09-Nov-2009)

Changed Order Number query to work with release 9 or earlier

1.7.94 (27-Oct-2009)

Fixed problem with handling of Order Number when manual assignment in use

1.7.93 (21-Oct-2009)

Fixed problem with download selection removing selection cell and not entire row

1.7.92 (20-Oct-2009)

Reset the order header id between loads to ensure no carry over if new order errors

1.7.91 (15-Oct-2009)

Made Order form multipage

1.7.90 (12-Oct-2009)

Fixed error in download screen when search icon activated

1.7.89 (21-Sep-2009)

Fixed problem with download of promise date and line status

1.7.87 (08-Sep-2009)

Ensure download form reinitialized when downloading from spreadsheet

1.7.86 (19-Aug-2009)

Updated the login forms to work with version 5 packages

1.7.85 (28-Jul-2009)

Changed customer sql to use base table as view restricts ‘Customer Name’ to 50 characters

1.7.84 (22-Jul-2009)

Changed warehouse query to use view that oracle forms utilise

1.7.83 (21-Jul-2009)

Added rownum = 1 to dff attribute query for parent segments

1.7.82 (28-Jul-2009)

Fixed upload of standard date if not specified

1.7.81 (26-Jun-2009)

Updated dff to standard date and standard time. Added [BLANK] to clear a field on update

1.7.80 (24-Jun-2009)

Updated dff to cater for situations where context name different from context code

1.7.79 (19-Jun-2009)

Updated download to cater for hidden id form references in DFF module

1.7.77 (17-Jun-2009)

Change Override to use the yes_no_reverse lookup type

1.7.76 (15-Jun-2009)

Fixed the fulfillment validator

1.7.75 (12-Jun-2009)

Removed the join to oe_items_v during download

1.7.70 (12-May-2009)

Changed order by on download to use line.line_number

1.7.68 (27-Mar-2009)

Added line delete functionality

1.6.67 (16-Feb-2009)

Fixed problem with DFF not processing non global attributes on uploadVersion 1.4.60

1.6.66 (13-Feb-2009)

Updated wizard with latest generic forms

1.5.65 (30-Sep-2008)

Updated queries for R12

1.5.63 (23-Sep-2008)

Add shipping instructions

1.4.62 (05-Aug-2008)

Fixed problem with context download causing error when hidden id is being

1.4.61 (29-Aug-2008)

Fixed the profile substitution in dff code

1.4.60 (29-Aug-2008)

Fixed Context values if a value set is in use

1.4.59 (06-Jun-2008)

Changed the UOM to use the UOM sql from the form to include conversion UOM

1.4.58 (29-Jul-2008)

Removed context error messages when default is incorrect based on form field

1.4.57 (24-Jul-2008)

Fixed download sql for project number and task number

1.4.56 (21-Jul-2008)

Added Shipment Priority

1.4.55 (10-Jun-2008)

Added Order Warehouse to the header record

1.4.54 (10-Jun-2008)

Fixed problem with task sql LOV

1.4.52 (12-May-2008)

Fixed problems with order by on download, form references not returning a valid context value
>and with customer number failing to default based on customer name. Removed defaults for request, promise date and locations. Added support for attribute 16 to 20 in dff. Made the warehouse a restricted list.

1.4.42 (12-Mar-2008)

Fixed the upload of the change reason to work against a booked orders. Added order type to the context form references. Fixed the download to use parent fields when form substitution in use at the line level. Changed sort for line number from character to number. Added Fulfillment Sets

1.4.38 (22-Jan-2008)

Added new fields Line Type, Line Promise Date, Line Schedule Date. Also added support for price adjustments against new fields Change Reason and Comments. Added support for download of dff fields and added support for line context driven from the selected line type

1.4.38 (22-Jan-2008)

Added fields Line Type, Line Promise Date, Line Schedule Date
Added support for price adjustments using new fields Change Reason and Comments
Added support for download of dff fields
Added support for line context based on line type

1.3.38 (08-Jan-2008)

Reset last header id to ensure update results returned correctly

1.3.38 (08-Jan-2008)

Reset last header id to ensure update results returned correctly

1.3.37 (18-Dec-2007)

Set default value for Location LOV values

1.3.36 (23-Nov-2007)

Updated DF module to handle line level dffs

1.3.35 (15-Nov-2007)

Added request date, po number, project, task to lines
Modified the form to handle horizontal scroll
Modified mandatory fields to handle the removal of a column

1.2.34 (09-Nov-2007)

Added error handler where procedure error encountered
Added update functionality to wizard

1.2.33 (02-Nov-2007)

Fixed upload when big invoice follows big invoice

1.2.32 (10-Sep-2007)

Added org id substitution

1.2.31 (24-Aug-2007)

Added debug module

1.2.30 (23-Aug-2007)

Fixed bug when the order entered by automatic numbering in place

1.2.29 (03-Aug-2007)

Added tab to scroll control to ColumnEvents

1.1.28 (27-Jul-2007)

Added option to BOOK the order

1.1.27 (26-Jul-2007)

Latest dff code with support for form references
Single Sign On

1.1.26 (12-Jul-2007)

Added latest modFlex that uses either value set name or segment name for :$FLEX$

1.1.25 (27-Jun-2007)

Introduced latest flex code with RESTRICT and event handling

1.1.24 (27-Jun-2007)

Reintroduced changes lost in 1.0.8

1.1.23 (14-Jun-2007)

Added latest calendar support

1.1.22 (07-Jun-2007)

Added latest flex field code

1.1.21 (05-Jun-2007)

Added Header DFF

1.1.20 (28-May-2007)

Amended generic validation to remove excess sql calls

1.1.19 (23-May-2007)

Imported all new class files to reflect latest code

1.1.18 (22-May-2007)

Fixed bug with upload where columns not set throwing error

1.1.17 (23-Apr-2007)

Changed restricted lists to utilise a combined sql search
Incorporated bind variables into data loads

1.0.17 (20-Apr-2007)

Increased the blank search to 1000 before finding end row
Always run accumulate sql if asked to force

1.0.16 (19-Apr-2007)

Simplified price list to include all active within date range

1.0.15 (12-Apr-2007)

Fixed bug with loose dependence caused by 1.0.12

1.0.14 (12-Apr-2007)

Correctly form initialisation to create dummy control if column not set

1.0.13 (04-Apr-2007)

Fixed bug with download from-to parameter retrieval

1.0.12 (03-Apr-2007)

Fixed bug with validation of dependent fields

1.0.11 (29-Mar-2007)

Fixed error with upload of purchase order number

1.0.10 (27-Mar-2007)

Added a active row reference to child form quadrant Added order type dependence for order number and po number

1.0.9 (19-Mar-2007)

Changed executeQuery in order to overcome explorer 30 second timeout

1.0.8 (14-Mar-2007)

Adjusted price list sql in order to back port to 11.5.6

1.0.7 (14-Mar-2007)

Reintroduced price upload into the wizard using the change price override flag Fixed bug with item on tab event during search

1.0.6 (03-Mar-2007)

Fixed bug with download columns and returned max rows Removed the use of column definitions added after 11.5.7

1.0.5 (26-Feb-2007)

Fixed bug with initialisation of form caused by customer after update

1.0.4 (21-Feb-2007)

Fixed bug with About form

1.0.3 (29-Jan-2007)

Fixed bug with caching of security check on change of responsibility