My Oracle Support Banner

Column "Preserve_credit_override_flag" Not Visible For Destination Column Mapping (Doc ID 1170765.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

1. Nav: Incentive Compensation Administrator -> Configuration Bench -> Collection ->
    Define Collection Sources and Mapping
2. Click 'Go' Button without giving any values in search criterion
3. Click 'Details' of any existing seeded transacion source like 'Order Booking'
4. Click tab 'Column Mapping'
5. Click button 'Add 5 Rows'
6. Give 'Y' in Source Column Field and enter 'Pres%' in Destination column and
    click on the lov icon of destination column .

    The column "PRESERVE_CREDIT_OVERRIDE_FLAG" does not exist.

7. You run the following SQL script and cannot see the column defined in the following tables :

- CN_COMMLINE_API_IMP_V
- CN_COMM_LINES_API

<<<-- list the tables where the column 'PRESERVE_CREDIT_OVERRIDE_FLAG' is defined

select name
from cn_objects_all
where org_id = &org_id
and object_id in
(select table_id
from cn_objects_all
where org_id = &org_id
and name in ('PRESERVE_CREDIT_OVERRIDE_FLAG')
);
================================================================================>>>>>

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
References


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