Receivables - EBS (MOSC)

MOSC Banner

hz_customer_profile_v2pub.update_cust_profile_amt returns error for object_version_number

edited May 1, 2015 4:04PM in Receivables - EBS (MOSC) 2 commentsAnswered ✓

I hope this is the correct community for TCA API question.  I'm using hz_customer_profile_v2pub.update_cust_profile_amt to mass update the profile amounts in TCA for a set of customers.  These are the specific customers that were loaded using customer conversion programs.  Now, the API needs object_version_number to lock the record, but the records created from conversion have null value for object_version_number in hz_cust_profile_amts table.  How can I fix this issue?  Any help is greatly appreciated.

Error from API:

This record in table hz_cust_profile_amts cannot be locked as it has been updated by another user.

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