Category Archives: R12

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

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

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

R12 – Complete list of supported API’s

In R11 api’s was found in irep – in R12 api’s are found in the database. The “7417 Prototype scripts for API’s – R12” zip file is generated using the proto sql scripts from the sql4oracle.zip file. Extract was generated using … Continue reading

Posted in API, Applications development, Developer Scripts, News, R12, SQL | Comments Off on R12 – Complete list of supported API’s

R12 migration procedure

For the migration of material statuses, we needed a procedure to update some of statuses. An Excel sheet with 13 status and all the flags and transaction types (allowed/disallowed) was base for the generation of a xls4Oracle generated load script. … Continue reading

Posted in Applications development, News, R12 | Comments Off on R12 migration procedure