These steps will enable you to evaluate the xls4oracle tool:
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Feb | ||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| 29 | 30 | 31 | ||||
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.
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 on its way!!!
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.
Extract scripts is included.
T42812.2944.3328.3220.3458.3728.3582.3601.3372 – 5-2-2010
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 is also updated. A new chapter is added with an excercise in creating a template from scratch.
T43579.3711.4095.3987.4225.4495.4349.4368.4577 – 4-2-2010
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.
A workshop is now planned to intruduce new users for the xls4oracle tool.
The agenda for this workshop is:
Pls. get a quote for a workshop at your site – pls. contact: ThomasLundqvist@hotmail.com
If you experience this pls verify all your tnsnames and if that does not work pls. re-install the Oracle 10G client.
Somehow the client installation can be messed up – you can tnsping and use sqlplus, toad and so on – but the 0040 connection is not working. Pls. uninstall / install the Oracle 10G Client software.
Recent Comments