Category Archives: xls4oracle

xls4Oracle SQL – the BIG sql sheet

The BIG xls4Oracle SQL sheet has many key selects. Like the customer sql that reteives from parties, accounts, sites, site uses and profiles – and locks and kill to solve deadlocks – and many dba sql’s. The download_upload sql has … Continue reading

Posted in Applications development, Developer Scripts, News, xls4oracle | Comments Off on xls4Oracle SQL – the BIG sql sheet

xls4Oracle tool – Release 4.0.4.129

Readme: 4.0.4.129 27-oct-2013: Added sql starting with “WITH” Fixed issue with old encrypted password Fixed SQL format issue: clear content with filter  

Posted in Revision History, xls4oracle | Comments Off on xls4Oracle tool – Release 4.0.4.129

Issue with apps initialize – fnd_global.org_id = -1

We are using the xls4Oracle, to update customer data, and it has been working fine in 11i and R12 (until last week…) I have identified the issue: –          After apps initialize – the fnd_global.org_id = -1 The workaround for the … Continue reading

Posted in Applications development, Templates, Templates Development, xls4oracle | Comments Off on Issue with apps initialize – fnd_global.org_id = -1

xls4Oracle tool – Release 4.0.4.127

Added new functionality to check and inform of new release. If new release exists, you will get one message a day, informing you that a new release exists. Readme: 4.0.1.372 09-dec-2011: (development) 4.0.1.38 10-dec-2011: (development) 4.0.1.40 10-dec-2011: (development) 4.0.1.44 20-dec-2011: (development) 4.0.1.47 … Continue reading

Posted in Revision History, xls4oracle | Comments Off on xls4Oracle tool – Release 4.0.4.127

Oracle dates in Excel

In Excel, the earliest date allowed for calculation is 1. january 1900. In Oracle database, the earliest date is 1. junuary 4712 BC. In Oracle E-Bussines Suite some dates is seeded with dates around 2000 years old… – valid but not very … Continue reading

Posted in Known Issues, xls4oracle | Comments Off on Oracle dates in Excel

xls4Oracle 4.0.4.124 readme

4.0.1.372 09-dec-2011: (development) 4.0.1.38 10-dec-2011: (development) 4.0.1.40 10-dec-2011: (development) 4.0.1.44 20-dec-2011: (development) 4.0.1.47 27-dec-2011: (development) 4.0.1.52 03-jan-2012: (development) 4.0.1.53 07-jan-2012: (development) 4.0.1.54 11-jan-2012: (development) 4.0.1.55 13-jan-2012: (development) 4.0.1.56 27-jan-2012: (development) 4.0.1.59 12-feb-2012: (development) 4.0.1.60 12-feb-2012: (development) 4.0.1.61 20-apr-2012: (development) 4.0.1.66 … Continue reading

Posted in Applications development, Revision History, Uncategorized, xls4oracle | Comments Off on xls4Oracle 4.0.4.124 readme

New features xls4Oracle tool 4.0.3.121

The xls4Oracle tool version 4.0.3.121 has just been released. It has some new features you want to look at: buffer load sql format sql email new setup button The buffer load feature is speeding up the sql fetch 3-10 times. … Continue reading

Posted in News, Revision History, xls4oracle | Comments Off on New features xls4Oracle tool 4.0.3.121

xls4Oracle 4.0.1.104 released

Toolbar buttons updated – Is now: SQL, PLSQL & Setup. The icon navigates to the about tab on the about form New tab on the About form: Setup – that navigates to a new tab with new settings. The SQL … Continue reading

Posted in News, Revision History, xls4oracle | Comments Off on xls4Oracle 4.0.1.104 released

xls4Oracle 4.0.1.92 released

The xls4Oracle 4.0.1.92 includes the following changes: – The xlam file is now in an installation package with certificate. NSIS used for creaton of the exe file. – sql function updated. A show hide columns function is added. Fetch into … Continue reading

Posted in News, xls4oracle | Comments Off on xls4Oracle 4.0.1.92 released

The xls4Oracle objects view

This view contains most objects in Oracle Applications. Use if for searching for customizations, forms, personalizations, workflow, value sets, profiles. If you can use FNDLOAD or WFLOAD the download and upload commands is generated for you.

Posted in Applications development, Developer Scripts, News, SQL, xls4oracle | Comments Off on The xls4Oracle objects view