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:
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
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
188.8.131.52 09-dec-2014: Fixed issue with many responsibilities(>99)
Pls. upgrade to 184.108.40.206
select * from v$sql
where module = ‘EXCEL.EXE’
220.127.116.11 25-may-2014: sql: added clear buffer
check: removed filedate check, because of DST issue
sql: added multiline header formating
Note: Revision 18.104.22.168 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 22.214.171.124
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”…
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.
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.
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.
Added sql starting with “WITH”
Fixed issue with old encrypted password
Fixed SQL format issue: clear content with filter
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.
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