Author Archives: tlu

Added new page with Excel Reports

New page with excel reports added: Excel Reports Pls. try !!!

Posted in Applications development, Excel Reports, Excel tools, SQL, xls4OracleSQL | Comments Off on Added new page with Excel Reports

xls4OracleSQL is in use as Excel Reporting tool in a validated environment

The xls4Oracle is now in use as a reporting tool. New features in xls4OracleSQL, is enabling the build of Excel Reports, using xls4OracleSQL. The Excel files is store in a SharePoint folder, with restricted access. The ProtectData parameter enables protection of both sql … Continue reading

Posted in Excel Reports, Excel tools, SQL, xls4OracleSQL | Comments Off on xls4OracleSQL is in use as Excel Reporting tool in a validated environment

New Excel tool sheet added for Google Earth Area calculations

A new Excel tool has been added – the xls4Oracle Google Earth Area. With the Excel tool you can copy / paste the polygon kml data from Google Earth into Excel. A macro will calculate the area and insert a line into the … Continue reading

Posted in Excel tools | Comments Off on New Excel tool sheet added for Google Earth Area calculations

Duplicates in a Query

Here is a way to find out why you have two rows in a select, when you only expect one. In good database design you expect that a unique ID is giving you only one record. But many tables Oracle … Continue reading

Posted in Applications development, SQL, xls4OracleSQL | Comments Off on Duplicates in a Query

Oracle ODAC: NLS_LANG in registry

The Oracle ODAC (11.2.0.3.20) installation is creating an NLS_LANG entry in here: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\NLS_LANG And that has no effeckt – it should be placed in an oracle_home – like: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1\NLS_LANG The result of having the NLS_LANG in the wrong place is special … Continue reading

Posted in Applications development, Installation, News, SQL, xls4oracle | Comments Off on Oracle ODAC: NLS_LANG in registry

mo_global.init raises insufficient privileges

To complete an apps_initialize from a readonly user, the readonly user needs this grant: grant select, insert, update, delete on mo_glob_org_access_tmp to ; This has been detected on an 12.1.36 installation with a readonly solution applied.

Posted in Applications development, Developer Scripts, News, R12, SQL | Comments Off on mo_global.init raises insufficient privileges

New features in xls4OracleSQL 5.0

The xls4OracleSQL 5.0is ready to be released soon and will include some new features: SmartFormat Clever formating of the SQL output. New parameter: MaxColWid enables control of how wide a column may be, before wrap is enabled. Heading width is … Continue reading

Posted in News, Revision History, SQL, xls4oracle | Comments Off on New features in xls4OracleSQL 5.0

xls4OracleSQL – release 4.0.5.138 12-apr-2015

The sql4OracleSQL tool is developed for distributed reporting. Reports developed is “frozen” to the sql.  If sql is changed, the excrypted database password is reset. This enables restricted access to the database and forces the distributed xls4OracleSQL report only to be … Continue reading

Posted in Uncategorized | Comments Off on xls4OracleSQL – release 4.0.5.138 12-apr-2015

New xls4OracleSQL tool released

The xls4OracleSQL tool enables distribution of reports. To enable this, some new fetures has been added: Password is protected and connected to the sql. Meaning: if the sql is changed, the password is being reset, and you have to enter the password … Continue reading

Posted in Applications development, News, SQL, xls4oracle | Comments Off on New xls4OracleSQL tool released

apps initialize needs fnd_global.bless_next_init

The ai.sql script was suddently not working anymore… – apparently after some patching. But if you add a fnd_global.bless_next_init statement – it will. I will soon update the ai.sql in the “sql script tools“

Posted in Applications development, R12, SQL | Comments Off on apps initialize needs fnd_global.bless_next_init