My Oracle Support Banner

Deleted Plan Element remains in the table CN_QUOTAS_ALL (Doc ID 945472.1)

Last updated on MARCH 22, 2019

Applies to:

Oracle Incentive Compensation - Version 12.0.4 and later
Information in this document applies to any platform.

Goal

After deleting a duplication of an existing plan element, it does not appear in the Plan Element LOV anymore but remains in table CN_QUOTAS_ALL

This can be reproduced with the following steps:

(R) Plan Administrator
(N) Maintain Components Library
Plan Elements
Query back the Plan Elements
Note that there are two Plan Elements with the same name
Delete the Plan Element which was created as a duplicate
It's no longer available in the screen, but is still showing in the CN_QUOTAS_ALL table

Solution

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
Goal
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.