How To Pull Lable Name Of All Fields In The Objects Based On OTBI Query

(Doc ID 2407697.1)

Last updated on JUNE 06, 2018

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.12.1.0.0 version,

The query below is used to find the column mapping between interface and base table.


SELECT
D.OBJECT_NAME AS OBJECT_NAME,
D.BASE_TABLE_NAME AS TABLE_NAME,
D.TXN_VO_PRIMARY_KEY_ATTR AS OBJ_PRIMARY_KEY,
D.TXN_VO_NAME,
D.CREATION_DATE AS OBJ_CREATION_DATE,
D.CREATED_BY AS OBJ_CREATED_BY,
OBJECT_ATTR_NAME AS COL_API_NAME,
OBJECT_ATTR_COL AS COL_NAME,
OBJECT_ATTR_LEN AS COL_LENGTH,
SUBSTR(OBJECT_ATTR_TYPE, - INSTR(REVERSE(OBJECT_ATTR_TYPE), '.') + 1) AS DATA_TYPE,
TXN_VO_ATTR_TABLE,
TXN_VO_ATTR_COL,
A.CREATION_DATE AS COL_CREATED_DATE,
A.CREATED_BY AS COL_CREATED_BY,
A.LAST_UPDATE_DATE AS COL_LAST_UPD_DATE,
A.LAST_UPDATED_BY AS COL_LAST_UPD_BY
FROM FUSION.MKT_IMP_OBJECT_DETAILS D,
FUSION.MKT_IMP_OBJECT_ATTRS A
WHERE
D.OBJECT_DETAIL_ID=A.OBJECT_DETAIL_ID
AND OBJECT_NAME =>OBJECT>

 

How to pull the Label Name of all fields in the objects based on OTBI query?
 

Solution

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