AX Error: “Update Patch of AX unable to find a record”
Article ID: KB0076550
Updated On:
| Products | Versions |
|---|---|
| TIBCO Cloud Integration - Connect ( Scribe ) | - |
Description
When updating the CustomerPostalAddress with details and using UpdatePatch block with the matching criteria(e.g AddresslocationId). Below error is encountered:
“Error in calling Operation Update Patch: Operation returned no results. Label: Update Patch CustomerPostalAddresses, Name: CustomerPostalAddressesUpdatePatch”
We could Query, Fetch and Lookup using the same criteria of AddressLocationId to retrieve records from CustomerPostalAddress but UpdatePatch fails
Resolution
If any DateTime field is a primary key for a entity then in matching criteria we have pass all the primary keys.
Here, we are using CustomerPostalAddress entity. Primary fields of this entity are:
AddressLocationId (String)
DataAreaId (String)
Effective (DateTime)
CustomerLegalEntityId (String)
CustomerAccountNumber (String)
So, in the Update Patch for CustomerPostalAddress we have to pass all these 5 fields for it successfully run the Update Operation.
Here, we are using CustomerPostalAddress entity. Primary fields of this entity are:
AddressLocationId (String)
DataAreaId (String)
Effective (DateTime)
CustomerLegalEntityId (String)
CustomerAccountNumber (String)
So, in the Update Patch for CustomerPostalAddress we have to pass all these 5 fields for it successfully run the Update Operation.
Issue/Introduction
Error in calling Operation Update Patch
Feedback
Yes
No
Powered by
