R12: "No ZX_PARTY_TAX_PROFILE was found for XX ID, THIRD_PARTY" error message displayed updating a Customer Name" in Oracle APPS

Some times we may get error while updating Customer Name in R12 as shown in below images.

There might be multiple reasons for this error, one of the reason is data does not exists in ZX_PARTY_TAX_PROFILE table. There must be one record for each customer in this table(Party_id from hz_parties). You can find more information about this issue in oracle documents 1156573.1, 601633.1.

After inserting data into ZX_PARTY_TAX_PROFILE table oaf page allowing to update Customer Name without any error.

Sample script:-

INSERT INTO zx_party_tax_profile (
  party_type_code
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
,party_tax_profile_id
,party_id
,object_version_number
)
 VALUES('THIRD_PARTY'
   ,p_user_id--fnd_global.user_id--Pass User ID
   ,SYSDATE
   ,p_user_id--fnd_global.user_id--Pass User ID
   ,SYSDATE
   ,1
   ,zx_party_tax_profile_s.NEXTVAL
   ,i.party_id --Pass Party_id from hz_parties table for given customer name
   ,1
);

Note: This post is just for information only, if you face same issue check with oracle, do proper testing in test instance before migrating to production instance.