My Oracle Support Banner

APP-FND-01934: ORA-01445: cannot select ROWID When Create/Update/End Date profile in "Service > Setup > Customer Management > Customer Profiles > Profile Check" Form (Doc ID 2403319.1)

Last updated on MAY 29, 2018

Applies to:

Oracle Teleservice - Version 12.2.7 and later
Oracle Customer Care - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Setup flow

In "Service > Setup > Customer Management > Customer Profiles > Profile Check" Form
When attempting to create profile checks and save or try to end date the and existing profile check, the following error occurs:

ERROR
-----------------------
APP-FND-01934: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table in Package CSC_PROFILE_CHECK_PVT. Procedure Update_Profile_Check
the following error occurs.



STEPS
-----------------------
(R) Service
(Nav) Setup > Customer Management > Customer Profiles > Profile Check
Create/Update/End Date profile


Changes

 

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!


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