Unable To Classify Table As 'Detail Client Data Data Type' (Doc ID 414760.1)

Last updated on NOVEMBER 03, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10.2
Detail Client Data Loader
This problem can occur on any platform.

Symptoms

On 11.5.10.2 when attempting to classify a user defined table as 'Detail Client Data', the following errors occur:

ERROR

1. The following columns are enabled but do not map to an interface table column: AMOUNT

2. The interface column CREATION_ROW_SEQUENCE data type does not match the data type for column CREATION_ROW_SEQUENCE.

3. Processing Key must match a unique key defined for the interface table. Note that if CALENDAR_PERIOD_ID is part of the Processing Key, the interface table unique key must also include the following equivalent Calendar Period columns: CAL_PERIOD_NUMBER, CALP_DIM_GRP_DISPLAY_CODE, CAL_PERIOD_END_DATE

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