My Oracle Support Banner

Local Customer Dimension accessing through BI layer throwing ODBC error (Doc ID 3034840.1)

Last updated on JULY 19, 2024

Applies to:

Oracle Financial Services Accounting Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

While accessing any columns from the local customer ID dimension under any Subject Area users are getting ODBC error
Local customer ID is a custom dimension

From the UI it is throwing ODBC error, from the DIS logs we see the exception message: ORA-00904: "N_CUSTO0470": invalid identifier

Changes

SOP applied to map the extended custom attributes to the BI dimension place holder attribute

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