My Oracle Support Banner

TDATAMAP Extraction Through Non Consolidation Report (Doc ID 2960779.1)

Last updated on JULY 17, 2023

Applies to:

Oracle Financial Consolidation and Close Cloud Service - Version 23.05.56 and later
Information in this document applies to any platform.

Goal

While extracting TDATAMAP table data via a Non Consolidation report using SQL query, the extract for Multi dimension mapping is successful but the source key and target key columns contain the Object key number.

Query being used: 

Select * from AIF_TARGET_APPL_MEMBERS where tdatamaptype = ‘MULTIDIM’

The goal is to also get a table name, as it would be helpful to extract the object key along with the member name.

Solution

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


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