Issue with hz_cust_account_v2pub.update_cust_account API.
Hello,
I am facing a strange problem. I am updating oracle customers via hz_cust_account_v2pub.update_cust_account API. This is on 11.5.10.2
The problem is, when I pass NULL values to customer class, customer type and warehouse_id fields, The API does not apply the same in database. For e.g. If warehouse_id is 91 and I need to update that warehouse ID to NULL using this API, it does not work.
Even after applying a NULL update through API, the value 91 still remains un-updated. Same is the story with Customer Class and Customer Type fields.
All other updates are just working fine. Even if I pass other values to these fields in question, they work just fine. Only when you are passing NULL this problem arises.
I am facing a strange problem. I am updating oracle customers via hz_cust_account_v2pub.update_cust_account API. This is on 11.5.10.2
The problem is, when I pass NULL values to customer class, customer type and warehouse_id fields, The API does not apply the same in database. For e.g. If warehouse_id is 91 and I need to update that warehouse ID to NULL using this API, it does not work.
Even after applying a NULL update through API, the value 91 still remains un-updated. Same is the story with Customer Class and Customer Type fields.
All other updates are just working fine. Even if I pass other values to these fields in question, they work just fine. Only when you are passing NULL this problem arises.
0