Category Archives: Templates

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

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

New template uploaded: Load Item Costs

Load Item costs into the CST_ITEM_CST_DTLS_INTERFACE table. Here is a new xls4oracle template to load item costs. extract instructions: – pls. execute the "CST_COST_TYPES" sql (on the sql tab, sheetname = "CTS_COST_TYPES") – enter org_id and cost_code_type on the bind … Continue reading

Posted in Dataload, News, Templates | Comments Off on New template uploaded: Load Item Costs

New dataload template: Update Person v101

This template is using the HR_PERSON_API.UPDATE_PERSON API. Fully tested to update email addresses, but can easily be setup for any other of the API fields: P_COMMENTS P_DATE_EMPLOYEE_DATA_VERIFIED P_DATE_OF_BIRTH P_EMAIL_ADDRESS P_EMPLOYEE_NUMBER P_EXPENSE_CHECK_SEND_TO_ADDRES P_FIRST_NAME P_KNOWN_AS P_MARITAL_STATUS P_MIDDLE_NAMES P_NATIONALITY P_NATIONAL_IDENTIFIER P_PREVIOUS_LAST_NAME P_REGISTERED_DISABLED_FLAG P_SEX … Continue reading

Posted in Dataload, Templates, xls4oracle | Comments Off on New dataload template: Update Person v101

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

New Template: Load AP Invoices

New template added to load AP Invoices into the AP invoice interface tables.

Posted in Dataload, News, Templates, xls4oracle | Comments Off on New Template: Load AP Invoices

New template to load customer contacts

The "Load Customer Contacts" template will create customer phone and email contacts on customer level. Load Customer Contacts

Posted in Dataload, News, Templates, xls4oracle | Comments Off on New template to load customer contacts

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