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 laterInformation 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 |