Category Archives: Developer Scripts

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

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

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

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

The xls4Oracle objects view

This view contains most objects in Oracle Applications. Use if for searching for customizations, forms, personalizations, workflow, value sets, profiles. If you can use FNDLOAD or WFLOAD the download and upload commands is generated for you.

Posted in Applications development, Developer Scripts, News, SQL, xls4oracle | Comments Off on The xls4Oracle objects view

R11 – Complete list of supported API’s

4566 is the number of supported API’s in oracle applications as of today (according to www.irep.oracle.com 20-apr-2011). Prototype scripts and xls4oracle template scripts is now available in 2 zip files. Pls. goto Prototypes and Scripts for xls4oracle templates For R12 … Continue reading

Posted in API, Applications development, Dataload, Developer Scripts, News, Templates, Templates Development, xls4oracle | Comments Off on R11 – Complete list of supported API’s