"APP-FND-01934 " Error When Try To End Date For An Existing "Relationship Plan" (Doc ID 2243295.1)

Last updated on MARCH 16, 2017

Applies to:

Oracle Teleservice - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

When attempting to create relationship plan,
the following error occurs.

ERROR
-----------------------
APP-FND-01934: ORA-01445 : Cannot select ROWID from, or sample ,as join view without a key-preserved table in package CSC_RELATIONSHIP_PLAN_PVT procedure Update_Plan_Header


(R) Service
(N) Setup > Relationship Plan > Define relationship Plan

Query for "Expiring Contracts" plan name and add an "End Date"
Tried to save the modification but the following error is raised
"APP-FND-01934: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table in Package CSC_RELATIONSHIP_PLANS_PVT Procedure Update_plan_header

Cause

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 hundreds of Community platforms