FND_LOOKUPS

Common / FoundationUsed in 58 subject areas14 reporting columns

Foundation (FND) — system lookups (status codes, types, classifications).

Primary key: LOOKUP_TYPE, LOOKUP_CODE

Columns

Column	Key	In reports	Description (inferred)
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
DESCRIPTION		●	Description.
DISPLAY_SEQUENCE		●	Display sequence.
ENABLED_FLAG		●	Indicator (Y/N) for the enabled.
END_DATE_ACTIVE		●	End date active.
LAST_UPDATED_BY		●	User who last updated the row.
LAST_UPDATE_DATE		●	Date and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGIN		●	Session login of the user who last updated the row.
LOOKUP_CODE	PK	●	Code identifying the lookup.
LOOKUP_TYPE	PK	●	Type of lookup.
MEANING		●	Meaning.
START_DATE_ACTIVE		●	Start date active.
TAG		●	Tag.

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for FND_LOOKUPS?

We ship parameterized SQL, BICC config, and dbt models you own.