Category Archives: Applications development

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 →

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 →