Monthly Archives: February 2010

Updating descriptive flexfields and attribute category…

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

Posted in Applications development | Leave a comment

password is case sensitive in release 12…

Apparently the applications password is case sensitive in R12. You can test using this script: begin if apps.fnd_user_pkg.validatelogin(‘<username>’,'<password>’) 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 … Continue reading

Posted in Applications development | Leave a comment

Release 3.6.8.219 – requires new vstor.exe!!!

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.

Posted in Known Issues, installation, xls4oracle | Leave a comment

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

Trial Key

T42812.2944.3328.3220.3458.3728.3582.3601.3372 – 5-2-2010

Posted in Trial Keys | Leave a comment

Release 3.6.8.219 – ready for production

The dataload form is now completed. This enables validation of all parameters before dataload. Passwords are now encrypted and a new feature enables a lock on dataload and system sheet to prevent unintended updates of validated workbooks. The user manual … Continue reading

Posted in xls4oracle | Leave a comment

Trial key

T43579.3711.4095.3987.4225.4495.4349.4368.4577 – 4-2-2010

Posted in Trial Keys | Leave a comment