xls4oracle.com

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!!!

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