My Oracle Support Banner

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

Last updated on MARCH 22, 2019

Applies to:

Oracle Enterprise Performance Foundation - Version to [Release 11.5]
Information in this document applies to any platform.
Detail Client Data Loader
This problem can occur on any platform.


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


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




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

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