Category Archives: Uncategorized

xls4OracleSQL – release 4.0.5.138 12-apr-2015

The sql4OracleSQL tool is developed for distributed reporting. Reports developed is “frozen” to the sql.  If sql is changed, the excrypted database password is reset. This enables restricted access to the database and forces the distributed xls4OracleSQL report only to be … Continue reading

Posted in Uncategorized | Comments Off on xls4OracleSQL – release 4.0.5.138 12-apr-2015

3 new Oracle API Excel loads

3 New Oracle API Excel loads: Load Approved Supplier List/4.0.1 Load ASL using the PO_ASL_API_PUB.CREATE_UPDATE_ASL API. Download: Load Approved Supplier List – posted 10-12-2014 Load Blanket Sales Agreements/4.0.1 Load BSA using the OE_BLANKET_PUB.PROCESS_BLANKET API. NB: This template handles 5 segments … Continue reading

Posted in API, Templates, Uncategorized | Comments Off on 3 new Oracle API Excel loads

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

Added new Template to load FND_USER’s

Pls. visit the PL/SQL Templates page.

Posted in Uncategorized | Comments Off on Added new Template to load FND_USER’s

xls4Oracle 4.0.4.124 readme

4.0.1.372 09-dec-2011: (development) 4.0.1.38 10-dec-2011: (development) 4.0.1.40 10-dec-2011: (development) 4.0.1.44 20-dec-2011: (development) 4.0.1.47 27-dec-2011: (development) 4.0.1.52 03-jan-2012: (development) 4.0.1.53 07-jan-2012: (development) 4.0.1.54 11-jan-2012: (development) 4.0.1.55 13-jan-2012: (development) 4.0.1.56 27-jan-2012: (development) 4.0.1.59 12-feb-2012: (development) 4.0.1.60 12-feb-2012: (development) 4.0.1.61 20-apr-2012: (development) 4.0.1.66 … Continue reading

Posted in Applications development, Revision History, Uncategorized, xls4oracle | Comments Off on xls4Oracle 4.0.4.124 readme

R11 – Complete list of supported API’s

NB: This info is related to Release 11 – for a complete list of R12 API’s goto R12 API In R11 you could get the list from http://irep.oracle.com/index.html – but that is gone now. These extracts where made based on the old info: … Continue reading

Posted in API, Applications development, Templates Development, Uncategorized | Comments Off on R11 – Complete list of supported API’s