14.9.1.7 Comparing _id and RESID in Duality View

Use RESID as an alternative document identifier for duality view updates and deletes.

Your attempted update failed before with the following error due to an ETAG mismatch:

ORA-42699: Cannot update JSON Relational Duality View 'ACTION_ITEMS_DV':
  The ETAG of document with ID 'FB03C13B00' in the database did not match
  the ETAG passed in.

The ID referenced in the error message is the resource id whose value you can retrieve using the RESID pseudo-column. This RAW-typed value is not included in the JSON document, so REST client applications aren't aware of it unless it is passed out of band in an HTTP header.

To use it as an alternative for the _id property in PL/SQL, query it along with the DATA column when retrieving the JSON document into a RAW(4000) variable. Then use the following predicate in your UPDATE or DELETE statement:

WHERE RESID = l_resid_var_raw

instead of:

WHERE JSON_VALUE(data,'$._id') = l_id_value