Category Archives: Dataload
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”…
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
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
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
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
The "AR_INVOICE_API_PUB.create_single_invoice" api can return "No data found" without any explanation, when tax info is missing.
New template added to load AP Invoices into the AP invoice interface tables.
The "Load Customer Contacts" template will create customer phone and email contacts on customer level. Load Customer Contacts
A new template to load Brazilian Fiscal Classifications is added. Load BR Fiscal Classifications