UPDATE_EXT_BANK_BRANCH-table hz_contact_points can't be locked as it has been updated by anotheruser
Hello Experts!
I am trying to use 'IBY_EXT_BANKACCT_PUB.UPDATE_EXT_BANK_BRANCH' API to update external bank branch but it keeps erroring out with the message: "The API call failed with error .This record in table hz_contact_points cannot be locked as it has been updated by another user.".
I am populating the right version numbers as per the recommendations found on Oracle support site but it still errors out,
bch_object_version_number -- hz_parties.object_version_number
typ_object_version_number -- hz_code_assignments.object_version_number (where class_category = 'BANK_BRANCH_TYPE' and owner_table_name = 'HZ_PARTIES')