My Oracle Support Banner

Error When Trying To Edit A Note in the Lifecycle Tab - ORA-01445: cannot select ROWID (Doc ID 2700279.1)

Last updated on AUGUST 13, 2020

Applies to:

Oracle Advanced Collections - Version 12.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.


After adding a note in the Lifecycle tab and saving, the Note field remains active. But if the user tries to type anything, the following error occurs:

ORA-01445: cannot select ROWID from, or sample, a join view without a
key-preserved table

FRM-40501: ORACLE error: unable to reserve record for update or delete.

Steps to Reproduce:

Responsibility: Collections Agent
: Collections

1. Query a customer and click on the Lifecycle tab, and add something to the Notes field and save.
2. After saving, the Notes field remains active, and looks like you can edit the note.
3. Try to type in the Notes field, and receive the error.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Still Have Questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.