Category Archives: Templates

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 updating People

Pls. chk: Update People

Posted in Templates | Comments Off on New template for updating People

Start Concurrent Requests: Added sql for extract

You can now extract concurrent request from one environment and restart concurrent request on any environment, as many times as needed. Excellent for perfomance  or unit testing.

Posted in Templates | Comments Off on Start Concurrent Requests: Added sql for extract

6 new customer templates added

update organizations – posted 05-02-2010 update locations – posted 05-02-2010 update party site – posted 05-02-2010 update cust account site – posted 05-02-2010 update cust account site use – posted 05-02-2010 update cust account – posted 05-02-2010 Extract scripts is … Continue reading

Posted in Templates, xls4oracle | Comments Off on 6 new customer templates added

Two new customer templates added

The “update customer profile” and “update customer profile amounts” templates will enable you to extract profile and profile amounts (sql extracts included) – and do updates. The templates is using HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUST_PROFILE_AMT and HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUSTOMER_PROFILE procedures for update.

Posted in Templates | Comments Off on Two new customer templates added

The Update Customers template has been updated

The update customers template has conformed sql for extract and update. On the sql sheet you will find: $cust_addr_su and $cust_rel_addr_su The $cust_addr_su will extract customer, address and site use info. The $cust_rel_addr_su will also extract relations. Some mappings is … Continue reading

Posted in Templates | Comments Off on The Update Customers template has been updated

Updating customer profile class

We just had a task of updating 500+ customers with a new profile class. Here is the howto: Create new template Create Data sheet: – site number – profile class id  Create Dataload sheet with this code:  DECLARE  — 17-nov-2009 … Continue reading

Posted in Dataload, Templates, xls4oracle | Comments Off on Updating customer profile class