Release Notes for Upload Wizard

Package Body Version - This is the product packages included in the current version of the wizard. The Minimum version (shown in brackets) is the lowest version of the package required to enable the wizard to function.

Wizard Version	6.0.0 (15-Nov-2011)
Package Body Version	3.1.2 (Minimum 1.0.1)

New Setup toolbar option for use when ROWID not required when inserting records. This prevents multiple unique hits on the SGA.
Requires package body 3.1.2 to work

Version 5.2.8 (26-Oct-2011)

Fix for Table owner prefix incorrectly used in web connection
Fix for not initializing table owner prefix affecting use of sub queries for downloading

Version 5.2.7 (26-Apr-2011)

Dates were not correctly downloading using R11i EBS connection. Added to instructions for downloading Dates
Update for non-ascii character problem

Version 5.2.6 (22-Apr-2011)

Trial version download using EBS connection required a fix
When retrieving column headings existing 'DATE' settings were not being cleared
Update Insert Template function

Version 5.2.5 (08-Apr-2011)

Error messages from the upload were not being written into the 'Upload Error' column.
ASCII(), TO_DATE(), and TO_CHAR() functions are now available.
Sample sheet improved to show correct use of DATE column header in Row 8.
Re-ordered fields on Table/View form.
Selecting separated rows using Ctrl-Click was not working properly.
Changing table form mode selection was altering upload mode. Fixed to make them independent.

Version 5.2.4 (05-Apr-2011)

Download using web connection required fixes
Table selection form was not remembering last used mode selection

Version 5.2.3 (02-Dec-2010)

Remove error on login using ODBC method

Version 5.2.2 (16-Feb-2009)

Updated common modules. Fixes context setting problem in R12

Version 5.2.1 (8-Feb-2009)

Fixed Type Mismatch message when no data found in END download

Removed ASCIISTR sample sheet as non-ASCII character workaround is no longer required

Version 5.2.0 (12-Dec-2009)

New simpler connection method

Mod to Reinstall_ProfileOptions macro to allow run by non-named user

Version 5.1.1 (9-Dec-2009)

Add handler for FND_GLOBAL

Version 5.1.0 (19-Nov-2009)

Non-Named Users are no longer allowed to use any function except the About form

Version 5.0.0 (4-Sep-2009)

Add callout to custom package M4APS_UW_CUSTOM to allow pre and post processing for INSERT / DELETE / UPDATE statements

Values that can be used in the pre and post validation are ROWID(except on pre-insert), Table name, DML Operation, SQL command

Version 4.0.2 (23-Jul-2009)

In Update mode the ROWID was being cleared

In Table/View form the field entry is now uppercase

Last SQL statement was not being stored in Update and Delete modes using EBS connection

Version 4.0.0 (1-Jun-2009)

Major performance improvement when using EBS connection. Approx 20 times faster due to application of batching technique used in our other EBS tools

Version 3.1.3 (28-Apr-2009)

Fix required for downloading ROWID values in Oracle EBS release R12

Version 3.1.2 (26-Feb-2009)

Last column was not being retrieved by "Get Columns" button on form

Upgraded standard connection modules

Version 3.1.1 (30-Jan-2009)

Upgraded standard connection modules

Wednesday, 3 September 2008

Version 3.1.0 (3-Sep-2008)

Improvements to Named User maintenance form

Changed names of Login options. SSO method is now Standard

Upgrade to About form to accommodate new Activation Key

Version 3.0.1 (6-Jul-2008)

Clear paste buffer after download button clicked to prevent Excel copying buffer value into all empty cells

Added Release Notes and On-line Documentation links to ODBC mode Login and About forms

Version 3.0.0 (26-Apr-2008)

Added web connection option for Oracle EBS instances

Range upload now used for all modes. Upload All option removed

Version 2.7.9 (15-Apr-2008)

Add support for FND_PROFILE in the upload

Version 2.7.8 (10-Apr-2008)

Allow Sub Queries in place of table/view names

Only constraints are you cannot use the "Get Columns" and RowID features for Sub Queries.

Version 2.7.7 (9-Apr-2008)

Change to package to use execute immediate for inserting rows

Version 2.7.6 (8-Apr-2008)

The SQL in the download form could not be edited. Unlocked field

Version 2.7.5 (21-Dec-2005)

Upload was removing timestamp data from Dates

New DATE indicator on row 8 for Dates

Stop using IsDate() for deciding if data is a date - was catching values like 1/4

Version 2.7.4 (15-Sep-2005)

Allowed Licence Key to be replaced

Version 2.7.3 (2-Jun-2005)

Fix if spaces used in value

Version 2.7.2 (1-Jun-2005)

Correction if Ascii and non Ascii characters used in a single value

Was not converting negative AscW() values

Version 2.7.1 (27-May-2005)

Support non-Ascii characters in upload

Version 2.6 (3-Jun-2004)

Added feature to refine selection of table/view based on granted permissions

Checks INSERT permission before calling insert package

Version 2.5 (21-May-2004)

Added code to be able to select views

Version 2.4 (28-Nov-2003)

Enhanced About form to show logged in user

Version 2.3 (8-Oct-2003)

Added feature to lock user name

Version 2.2 (1-Oct-2003)

Removed constraint for MUST have privileges

Uppercase for Table form, Upper case for Keywords in SQL

Added message if no columns selected

Added logout button

Version 2.1 (21-Sep-2003)

Added toolbar code and provided button for package setup

About our company
Enter a succinct description of your company here

Contact Us
Enter your company contact details here