Category Archives: SQL

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

the @ext script

The @ext script will first give you a filtered list of all objects. Use the sqlplus copy paste to select the objects you want to extract.

Posted in SQL | Comments Off on the @ext script

the @obj script

The obj script gives youthe fastpath to the all_objects system view. You can find all database objects in the all_objects view. So if you folow good naming standards you can ask about all objects where object_name like ‘XX%’ and you … Continue reading

Posted in SQL | Comments Off on the @obj script

How to setup readonly database users in Oracle E-Business Suite

Create the readonly role Grant select on all tables and views, selectable from apps, to the readonly role Create the readonly users For each readonly user: Grant the readonly role and create logon triggers to alter schema to apps. Use policy … Continue reading

Posted in Applications development, SQL | Comments Off on How to setup readonly database users in Oracle E-Business Suite

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

xls4Oracle User Guide 4.0 just uploaded

download id="114" format="7" autop="false"]

Posted in News, SQL, xls4oracle | Comments Off on xls4Oracle User Guide 4.0 just uploaded

xls4Oracle – 4.0.1.52 – Just posted

Added new feature to refresh a sql sheet. The refresh will use the comment in the A1 cell to generate a new extract. When you press the xls4Oracle/sql button and the cursor is in a cell with an xls4Oracle comment … Continue reading

Posted in News, Revision History, SQL, xls4oracle | Comments Off on xls4Oracle – 4.0.1.52 – Just posted

Convert date to client timezone

We have a need for validating timecards agains deadlines and needed a function to convert database dates to local time. The database is in CET timezone and client is in PST timezone. First we used a profile value with the … Continue reading

Posted in Applications development, SQL | Comments Off on Convert date to client timezone