My Oracle Support Banner

Cannot Remove Custom Table from Configure Tables and Columns Page - Message CN_TBL_MAP_EXIST (Doc ID 1638669.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

In Release 12.1.3, when attempting to remove a user-defined, external table from the Configure Tables and Columns page, the following error occurs.


Row x Error - Message not found. Application: CN, Message Name: CN_TBL_MAP_EXIST.


The issue can be reproduced at will with the following steps:


1.  Create a custom table, ie TEST.

2.  Add "register" the table on the Configure Tables and Columns page.

3.  Create a custom collection source on the Define Collection Sources and Mapping page.

4.  Define column mapping for the custom collection using the custom table, ie TEST.

5.  Now, you change/add a column to the custom table TEST. 

6.  In order for the new column or changes to be visible to the OIC custom collection mapping, the custom table must be removed and entered again on the Configure Tables and Columns page.

7.  When you try to remove the custom table TEST from the Configure Tables and Columns page, the error occurs.


 

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
Cause
Solution


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