SEARCH
 

Release Notes for Upload Wizard

Release 6.0.0 (15-Nov-2011)

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