Category Archives: Dataload

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

xls4Oracle 4.0.1.59 just uploaded

Posted in Dataload, News, Revision History, xls4oracle | Comments Off on xls4Oracle 4.0.1.59 just uploaded

xls4Oracle – 4.0.1.48 just posted

This release has passed all test senarios. Dataload: Date handling has been streamlined. The dateformat is not nessesary anymore. A new algoritm based on julian date is being used. All excel dates is based on the 01-jan-1900 date and all oracle … Continue reading

Posted in Applications development, Dataload, News, Revision History, xls4oracle | Comments Off on xls4Oracle – 4.0.1.48 just posted

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

Load AR invoices – no data found

The "AR_INVOICE_API_PUB.create_single_invoice" api can return "No data found" without any explanation, when tax info is missing.

Posted in Dataload | Comments Off on Load AR invoices – no data found

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