My Oracle Support Banner

How To Pull Label Name Of All Fields In The Objects Based On OTBI Query (Doc ID 2407697.1)

Last updated on JULY 31, 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

To view full details, 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 a vibrant support community of peers and Oracle experts.