SEARCH
 

Release Notes for Sales Order Wizard

Version 2.9.34 (06-Dec-2011)

Added hold and release functionality to the wizard
 

Version 2.9.33 (10-Nov-2011)

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

Version 2.9.32 (28-Oct-2011)

Log defaults but discontinue to show msgbox when defaulting value

Version 2.9.31 (27-Oct-2011)

Added support for date time against the order date

Version 2.9.30 (12-Oct-2011)

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

Version 2.9.29 (22-Sep-11)

Updated the toolbar code to latest
 

Version 2.9.28 (13-Sep-11)

Made sure the Customize fields form displayed all columns
 

Version 2.9.26 (06-Sep-11)

Ensured the DFF was converting the defaults correctly
 

Version 2.9.25 (01-Sep-11)

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

Version 2.9.24 (25-Aug-11)

Added profile Required Version profile option
 

Version 2.9.22 (06-Aug-11)

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

Version 2.9.20 (06-Aug-11)

Ensured removed dependent columns are checked in service contract section
 

Version 2.9.19 (22-Jul-11)

Added some splash to the wGrid
 

Version 2.9.18 (20-Jul-11)

Added support for multi form references against a column
 

Version 2.9.17 (19-Jul-11)

Added Attachments
 

Version 2.9.16 (15-Jul-11)

Latest Common code including new Customize column functionality
 

Version 2.9.15 (14-Jul-11)

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

Version 2.9.14 (11-Jul-11)

Added the download column Inventory_Item_Id to support the substitutions
 

Version 2.9.13 (01-Jul-11)

Added form substitutions for Line.inventory_item_id and Line.ship_to_mir
 

Version 2.9.12 (24-Jun-11)

Updated the cancelled quantity during line cancel
 

Version 2.9.11 (21-Jun-11)

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

Version 2.9.10 (16-Jun-11)

Added Line Shipment Method and Line Freight Terms columns
 

Version 2.9.09   (27-May-2011) 

Corrected DFF download
 

Version 2.9.08   (27-May-2011) 

Added new Customize fields form

Version 2.9.07   (24-May-2011) 

Added Shipment Method and Freight Terms to the Header

Version 2.9.05   (13-May-2011) 

Added latest code to ensure DFF downloaded correctly

Version 2.9.04   (04-May-2011) 

Fixed problem with upload of Single Line

Version 2.9.03   (09-Mar-2011) 

Added a touch of splash

Version 2.9.02   (09-Mar-2011) 

Ensure the toolbar renders correctly if user is not logged in

Version 2.9.00   (15-Feb-2011) 

Introduced concurrent program processing if XML version allows

Version 1.9.46   (17-Jan-2011) 

Made the Header location field a searchable field

Version 1.9.43   (10-Nov-2010)

New changes to the state step for large order loads

Version 1.9.42   (27-Oct-2010) 

Added Source Type to the lines

Version 1.9.41   (24-Sep-2010) 

Changed Header Address sql to match the Lines Address sql

Version 1.9.40 (14-Sep-2010)

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

Version 1.8.39 (04-Sep-2010)

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

Version 1.8.38 (11-Aug-2010)

Added cancel flag at the line level
 

Version 1.8.37(04-Aug-2010)

Corrected the status list of values on the download form
 

Version 1.8.34 (02-Jul-2010)

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

Version 1.8.33 (25-Jun-2010)

Changed MOAC_Org_id for r12
 

Version 1.8.32 (21-Jun-2010)

Changed customer query to work with r12
 

Version 1.8.31 (20-May-2010)

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

Version 1.8.229 (04-May-2010)

Corrected line Address fields to work correctly when dependent columns removed
 

Version 1.8.28 (28-Apr-2010)

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

Version 1.8.25 (10-Apr-2010)

Fixed problem with UOM search
 

Version 1.8.21 (30-Mar-2010)

Added the Order Source Reference field to the wizard
 

Version 1.8.20 (30-Mar-2010)

Added Service Contracts to the wizard
 

Version 1.7.101 (02-Mar-2010)

Added the Override ATP and Subinventory columns
 

Version 1.7.100 (01-Mar-2010)

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

Version 1.7.99 (05-Feb-2010)

Updated generic code for new license structure
 

Version 1.7.98 (05-Dec-2009)

Fixed problem with substitution of the ORDER_TYPE
 

Version 1.7.97 (21-Nov-2009)

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

Version 1.7.96 (09-Nov-2009)

Changed Item query to remove join for UOM
 

Version 1.7.95 (09-Nov-2009)

Changed Order Number query to work with release 9 or earlier
 

Version 1.7.94 (27-Oct-2009)

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

Version 1.7.93 (21-Oct-2009)

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

Version 1.7.92 (20-Oct-2009)

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

Version 1.7.91 (15-Oct-2009)

Made Order form multipage
 

Version 1.7.90 (12-Oct-2009)

Fixed error in download screen when search icon activated
 

Version 1.7.89 (21-Sep-2009)

Fixed problem with download of promise date and line status
 

Version 1.7.87 (08-Sep-2009)

Ensure download form reinitialized when downloading from spreadsheet
 

Version 1.7.86 (19-Aug-2009)

Updated the login forms to work with version 5 packages
 

Version 1.7.85 (28-Jul-2009)

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

Version 1.7.84 (22-Jul-2009)

Changed warehouse query to use view that oracle forms utilise
 

Version 1.7.83 (21-Jul-2009)

Added rownum = 1 to dff attribute query for parent segments
 

Version 1.7.82 (28-Jul-2009)

Fixed upload of standard date if not specified
 

Version 1.7.81 (26-Jun-2009)

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

Version 1.7.80 (24-Jun-2009)

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

Version 1.7.79 (19-Jun-2009)

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

Version 1.7.77 (17-Jun-2009)

Change Override to use the yes_no_reverse lookup type
 

Version 1.7.76 (15-Jun-2009)

Fixed the fulfillment validator
 

Version 1.7.75 (12-Jun-2009)

Removed the join to oe_items_v during download
 

Version 1.7.70 (12-May-2009)

Changed order by on download to use line.line_number
 

Version 1.7.68 (27-Mar-2009)

Added line delete functionality
 

Version 1.6.67 (16-Feb-2009)

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

Version 1.6.66 (13-Feb-2009)

Updated wizard with latest generic forms
 

Version 1.5.65 (30-Sep-2008)

Updated queries for R12
 

Version 1.5.63 (23-Sep-2008)

Add shipping instructions
 

Version 1.4.62 (05-Aug-2008)

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

Version 1.4.61 (29-Aug-2008)

Fixed the profile substitution in dff code
 

Version 1.4.60 (29-Aug-2008)

Fixed Context values if a value set is in use
 

Version 1.4.59 (06-Jun-2008)

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

Version 1.4.58 (29-Jul-2008)

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

Version 1.4.57 (24-Jul-2008)

Fixed download sql for project number and task number
 

Version 1.4.56 (21-Jul-2008)

Added Shipment Priority
 

Version 1.4.55 (10-Jun-2008)

Added Order Warehouse to the header record
 

Version 1.4.54 (10-Jun-2008)

Fixed problem with task sql LOV
 

Version 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.
 

Version 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
 

Version 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
 

Version 1.3.38 (08-Jan-2008)

Reset last header id to ensure update results returned correctly.
 

Version 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
 

Version 1.3.38 (08-Jan-2008)

Reset last header id to ensure update results returned correctly.
 

Version 1.3.37 (18-Dec-2007)

Set default value for Location LOV values
 

Version 1.3.36 (23-Nov-2007)

Updated DF module to handle line level dffs
 

Version 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
 

Version 1.2.34 (09-Nov-2007)

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

Version 1.2.33 (02-Nov-2007)

Fixed upload when big invoice follows big invoice
 

Version 1.2.32 (10-Sept-2007)

Added org id substitution
 

Version 1.2.31 (24-Aug-07)

Added debug module
 

Version 1.2.30 (23-Aug-2007)

Fixed bug when the order entered by automatic numbering in place
 

Version 1.2.29 (03-Aug-2007)

Added tab to scroll control to ColumnEvents
 

Version 1.1.28 (27-Jul-2007)

Added option to BOOK the order
 

Version 1.1.27 (26-Jul-2007)

Latest dff code with support for form references
Single Sign On
 

Version 1.1.26 (12-July-2007)

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

Version 1.1.25 (27-Jun-2007)

Introduced latest flex code with RESTRICT and event handling
 

Version 1.1.24 (27-Jun-2007)

Reintroduced changes lost in 1.0.8!!!
 

Version 1.1.23 (14-Jun-2007)

Added latest calendar support
 

Version 1.1.22 (07-Jun-2007)

Added latest flex field code
 

Version 1.1.21 (05-June-2007)

Added Header DFF
 

Version 1.1.20 (28-May-2007)

Amended generic validation to remove excess sql calls.
 

Version 1.1.19 (23-May-2007)

Imported all new class files to reflect latest code
 

Version 1.1.18 (22-May-2007)

Fixed bug with upload where columns not set throwing error
 

Version 1.1.17 (23-Apr-2007)

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

Version 1.0.17 (20-Apr-2007)

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

Version 1.0.16 (19-Apr-2007)

Simplified price list to include all active within date range
 

Version 1.0.15 (12-Apr-2007)

Fixed bug with loose dependence caused by 1.0.12
 

Version 1.0.14 (12-Apr-2007)

Correctly form initialisation to create dummy control if column not set
 

Version 1.0.13 (04-Apr-2007)

Fixed bug with download from-to parameter retrieval
 

Version 1.0.12 (03-Apr-2007)

Fixed bug with validation of dependent fields
 

Version 1.0.11 (29-Mar-2007)

Fixed error with upload of purchase order number
 

Version 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
 

Version 1.0.9 (19-Mar-2007)

Changed executeQuery in order to overcome explorer 30 second timeout
 

Version 1.0.8 (14-Mar-2007)

Adjusted price list sql in order to back port to 11.5.6
 

Version 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
 

Version 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
 

Version 1.0.5 (26-Feb-2007)

Fixed bug with initialisation of form caused by customer after update
 

Version 1.0.4 (21-Feb-2007)

Fixed bug with About form
 

Version 1.0.3 (29-Jan-2007)

Fixed bug with caching of security check on change of responsibility
About our company
Enter a succinct description of your company here
Contact Us
Enter your company contact details here