What is the primary key of HRG_GOAL_ALIGNMENTS?

GOAL_ALIGNMENT_ID (likely, inferred from column markers)

Where is HRG_GOAL_ALIGNMENTS used in reporting?

It appears in 0 OTBI subject areas.

Oracle Fusion · Data dictionary

SharedUsed in 0 subject areas10 reporting columnsBICC incremental-ready

Source object in the Oracle Fusion data model.

Likely primary key: GOAL_ALIGNMENT_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE

Joins (inferred from key columns): GOAL_ID → HRG_GOALS

Column	Key	In reports	Description (inferred)
ALIGNED_GOAL_ID		●	Identifier for the aligned goal.
BUSINESS_GROUP_ID		●	Identifier for the business group.
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
GOAL_ALIGNMENT_ID	PK?	●	Identifier for the goal alignment.
GOAL_ID		●	Identifier for the goal.
LAST_UPDATED_BY		●	User who last updated the row.
LAST_UPDATE_DATE	INCR	●	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.
OBJECT_VERSION_NUMBER		●	Optimistic-locking version number, incremented on each update.

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

Need the extract + dbt staging for HRG_GOAL_ALIGNMENTS?

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

Problems that run through this table