My Oracle Support Banner

Update or Change to the Country Name Error - ORA-01445: Cannot Select ROWID From, Or Sample, A Join View Without a Key-Preserved Table (Doc ID 1934037.1)

Last updated on JULY 21, 2022

Applies to:

Oracle Receivables - Version 12 and later
Oracle Trading Community - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

Release 12 version, Customers Module

Attempting to update or change the Country Name and receive the following error:

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

Steps to Reproduce:
Responsibility:  Receivables
Navigation: Setup > System > Countries

Changes

Upgraded from release 11.5.10 to 12.2.4 

Cause

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
Symptoms
Changes
Cause
Solution
References


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