Category Archives: Applications development

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

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 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

Load Stock Locators R12 template added

This template has been struggling – and today I realized what the problem was: There is a flag on the KFF “Stock Locators” “allow dynamic insert” – if unchecked – you get: “Can not create Locator”…  

Posted in Applications development, Dataload, Known Issues, News, R12, Revision History, Templates, Templates Development, xls4oracle | Comments Off on Load Stock Locators R12 template added

The xls4Oracle Profit package, with FIFO calculation, is ready for download

The xls4Oracle Profit package enable you to do FIFO calculation on Oracle database objects. Pls. visit the The xls4Oracle Profit package with FIFO calculation page for further info and download.

Posted in Applications development, FIFO calculation, R12, SQL | Comments Off on The xls4Oracle Profit package, with FIFO calculation, is ready for download

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