Category Archives: Templates Development

Pls. comment on witch new templates you want.

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

Issue with apps initialize – fnd_global.org_id = -1

We are using the xls4Oracle, to update customer data, and it has been working fine in 11i and R12 (until last week…) I have identified the issue: –          After apps initialize – the fnd_global.org_id = -1 The workaround for the … Continue reading

Posted in Applications development, Templates, Templates Development, xls4oracle | Comments Off on Issue with apps initialize – fnd_global.org_id = -1

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

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

New template to load Brazilian Fiscal Classifications

A new template to load Brazilian Fiscal Classifications is added. Load BR Fiscal Classifications

Posted in Dataload, News, Templates, Templates Development, xls4oracle | Comments Off on New template to load Brazilian Fiscal Classifications

New template to Load Pricelist

New template added for extract existing pricelist, update existing or enddate existing and create new. Just enter pricelist name on the bind sheet and execute the sql. Data sheet only need: Pricelist name item no list price start date If … Continue reading

Posted in News, Templates, Templates Development, xls4oracle | Comments Off on New template to Load Pricelist

Template for Brazilian Tax Exemptions

A new template is on its way. The template will load tax exemptions and legal messages. There is no API for this, so data is loaded directly into base tables. The template is validating all codes and getting the id’s needed. … Continue reading

Posted in Dataload, Templates, Templates Development, xls4oracle | Comments Off on Template for Brazilian Tax Exemptions

New template for initiating Concurrent Requests

The new template will initiate concurrent requests defined in a excel sheet. This is very usefull for unit tests, where you want to run the same report with different parameters, over and over again between development updates, until the report … Continue reading

Posted in Templates Development | Comments Off on New template for initiating Concurrent Requests

The Process of Creating Pricelist Modifiers

This is the story of how to update the item category set on pricelist modifiers. In order to do that you must inactivate all modifiers, change the pointer to the new category set and create a new complete set of modifiers … Continue reading

Posted in Templates Development | Comments Off on The Process of Creating Pricelist Modifiers

The API script

The API script has been updated. It will now handle both ‘in’ and ‘in/out’ arguments. The F load_fa_adjustments template is build using the api.sql scripts.

Posted in Templates Development | Comments Off on The API script