Category Archives: Templates

New template to load Brazilian Fiscal Classifications

Posted on 28. July 2010 by tlu

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

Posted in Dataload, News, Templates, Templates Development, xls4oracle | Leave a comment

New template to Load Pricelist

Posted on 15. July 2010 by tlu

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 | Leave a comment

Template for Brazilian Tax Exemptions

Posted on 18. May 2010 by tlu

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 | Leave a comment

New template for updating People

Posted on 28. April 2010 by tlu

Pls. chk: Update People

Posted in Templates | Leave a comment

Start Concurrent Requests: Added sql for extract

Posted on 17. April 2010 by tlu

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 | Leave a comment

6 new customer templates added

Posted on 5. February 2010 by tlu

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 | Leave a comment

Two new customer templates added

Posted on 30. January 2010 by tlu

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 | Leave a comment

Updating customer profile class

Posted on 18. November 2009 by tlu

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  — … Continue reading →

Posted in Dataload, Templates, xls4oracle | Leave a comment

New template for initiating Concurrent Requests

Posted on 25. April 2009 by tlu

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 | Leave a comment

The Process of Creating Pricelist Modifiers

Posted on 2. March 2009 by tlu

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 | Leave a comment