The insert_row APIs – is UNSUPPORTED APIs

If you think you can use any API with a procedure named ‘insert_row’ – pls. check this before you use it.

The insert_row procedure is made for Orace Forms insert procedures.

The insert_row is not a supported API, it will not do any validation, just insert the row and the risk of of getting corrupted data into you system is very high.

A supported public API can have different syntax. Most common is the ones with a return_status and return_message, but some is just raising an exception, using sql error message.

Try google “oracle API insert_row” – and see how many “good” advises there are for using an insert_row API.

There is very little difference between just using the insert statement and using the insert_row – there is no validationin either. If you are forced to use the unsupported api, make sure your organizations is accpting this approach. It will require extensive testing and validation. Finally your system can end up without support from Oracle.

One way to identify these forms APIs is that they all might have:

  • insert_row
  • update_row
  • delete_row
  • lock_row

Check for yourself by looking into the procedure, it is always quit simple. Then take a look at a supported API – it is a very very long story.

You will find a sql to extract all supported API in this post: R12 – Complete list of supported API’s

DO NOT USE UNSUPPORTED APIs

Posted in API, Applications development, SQL | Comments Off on The insert_row APIs – is UNSUPPORTED APIs

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 in categories, this might be customized. Download: Load Blanket Sales Agreements – posted 10-12-2014


Load FND Profile/4.0.2

Load FND Profile values using FND_PROFILE.SAVE API. Load SITE, APPL, RESP, SERVER and ORG types. Download: Load FND Profile – posted 10-12-2014


All templates

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

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

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 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 output. The “Dayligth Saving Time” bug has now been fixed.

Pls. upgrade to 4.0.4.131

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

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

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 extract commands for sqlplus, fndload and wfload.

xls4Oracle SQL

How to use: mark a cell, and press the xls4Oracle SQL button. You can now execute the sql stored in the comment field, with the option to add or update the where clause.

This excel sheet has one macro: “Clear Sheets” – the macro will remove all sheets except the default sheets.

pls. download:

Download
Posted in Applications development, Developer Scripts, News, xls4oracle | Comments Off on xls4Oracle SQL – the BIG sql sheet

xls4Oracle tool – Release 4.0.4.129

Readme:

4.0.4.129 27-oct-2013:

Added sql starting with “WITH”
Fixed issue with old encrypted password
Fixed SQL format issue: clear content with filter

 

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

New Free Excel Download – R12 Table Links

This excel has all established table links in the R12 views. You can use this excel to figure out how to link between tables or figure out how customer_id is used.

Download

The excel is generated by reading view source on a R12 and extracting table and where clauses.

Pls. make a donation if you find this useful

Posted in Applications development | Comments Off on New Free Excel Download – R12 Table Links