xls4oracle.com

New template to load Brazilian Fiscal Classifications

tlu — Tue, 27 Jul 2010 22:00:05 +0000

A new template to load Brazilian Fiscal Classifications is added.

Load BR Fiscal Classifications

New template to Load Pricelist

tlu — Thu, 15 Jul 2010 21:02:40 +0000

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 you enter start date and item list price already exists, the existing list price will be end dated – otherwise list price will be updated.

the Load Pricelist Template

Template for Brazilian Tax Exemptions

tlu — Tue, 18 May 2010 13:33:31 +0000

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. We have now loaded to test environment and is waiting for validation.

Data is loaded into:

JL_ZZ_AR_TX_EXC_FSC_ALL
JL_ZZ_AR_TX_LGL_MSG_ALL

If you need this template now, pls. request one by mailing: info@xls4oracle.com.

New template for updating People

tlu — Wed, 28 Apr 2010 10:38:06 +0000

Pls. chk: Update People

Start Concurrent Requests: Added sql for extract

tlu — Sat, 17 Apr 2010 09:07:21 +0000

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.

Open for Comments

tlu — Mon, 29 Mar 2010 09:24:04 +0000

Pls. use comment…

Updating descriptive flexfields and attribute category…

tlu — Tue, 23 Feb 2010 10:21:14 +0000

Remember to fill in the attribute_category, when updating descriptive flexfields defined with context.

If you omit the attribute_category, the api will successed and database will be updated, but no value will be shown…

We just had a case where HZ_CUST_ACCOUNT_SITE_V2PUB.UPDATE_CUST_ACCT_SITE where completed successfully, but not value where shown and database was updated. We forgot to fill in the org_id in attribute_category and the DFF was setup with reference to $PROFILES$.ORG_ID.

password is case sensitive in release 12…

tlu — Mon, 15 Feb 2010 21:00:51 +0000

Apparently the applications password is case sensitive in R12.

You can test using this script:

begin
if apps.fnd_user_pkg.validatelogin('','') then
dbms_output.put_line('ok');
else
dbms_output.put_line('failed');
end if;
end;
/

This is an issue for the xls4oracle tool o R12. A new release is on its way!!!

Updated 26-may-2010: New release 3.6.10.223 – fixed to handle R12 passwords.

Release 3.6.8.219 – requires new vstor.exe!!!

tlu — Sat, 06 Feb 2010 09:54:55 +0000

The 3.6.8.219 release is checking for existense of this vstor.exe:

Microsoft Visual Studio 2005 Tools for Office Second Edition Runtime (build 8.0.50727.940) (x86)

Pls. install this vstor.exe before installing xls4oracle 3.6.8.219.

6 new customer templates added

tlu — Thu, 04 Feb 2010 23:54:17 +0000

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 included.

load customers