EBS Customizations (MOSC)

MOSC Banner

Issue with hz_cust_account_v2pub.update_cust_account API.

edited Sep 15, 2012 7:41PM in EBS Customizations (MOSC) 1 commentAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center