Category Archives: SQL

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

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

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

The insert_row APIs – is UNSUPPORTED APIs

If you think you can use any API with a procedure named ‘insert_row’ – pls. check this before you use it. The insert_row procedure is made for Orace Forms insert procedures. The insert_row is not a supported API, it will … Continue reading

Posted in API, Applications development, SQL | Comments Off on The insert_row APIs – is UNSUPPORTED APIs

How to find which SQL has been executed from EXCEL using V$SQL

select * from v$sql where module = ‘EXCEL.EXE’

Posted in Developer Scripts, SQL, Uncategorized, xls4oracle | Comments Off on How to find which SQL has been executed from EXCEL using V$SQL