Category Archives: News

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

xls4Oracle tool – Release 4.0.4.133

Readme: 4.0.4.133 09-dec-2014: Fixed issue with many responsibilities(>99) Pls. upgrade to 4.0.4.133

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

xls4Oracle tool – Release 4.0.4.131

Readme: 4.0.4.131 25-may-2014: sql: added clear buffer check: removed filedate check, because of DST issue sql: added multiline header formating Note: Revision 4.0.4.131 has an improtant fix for a bug in the sql function. The bug can result in wrong … Continue reading

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

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

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

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 – release 4.0.2.111

Bug fixes and improvements: Performance improvement on the sql function. Buffered sql rows is a parameter. Table format is performed after the fetch has completed. Table format is optional. Trace has been enabled Readme on the about form

Posted in News, Revision History | Comments Off on xls4Oracle – release 4.0.2.111