Wednesday, November 12, 2025

Query to get the list of contexts for each formula type in Oracle Fusion HCM

select t.base_formula_type_name
,      ttl.formula_type_name
,      ttl.description
,      c.base_context_name
from   ff_formula_types_b t
,      ff_formula_types_tl ttl
,      ff_ftype_context_usages u
,      ff_contexts_b c
where  t.formula_type_id = u.formula_type_id
and    ttl.formula_type_id = t.formula_type_id
and    ttl.language = userenv('LANG')
and    ttl.formula_type_name like 'Performance Rating Calculation'--'Oracle%Payroll%'
and    c.context_id = u.context_id

1 comment:

  1. Honestly, I was just exploring random database topics and somehow ended up on TPointTech — and I couldn’t stop reading. The way they’ve explained Oracle Database concepts like SQL, PL/SQL, indexing, normalization, and performance tuning is actually beginner-friendly without being too basic. Most platforms either dive too deep too quickly or stay too superficial, but here the balance is just right. From understanding database architecture to writing complex queries, everything is structured in a very clear and practical way. If you're serious about mastering Oracle Database, this is genuinely a goldmine.

    ReplyDelete

APEX$TASK_PK

  APEX$TASK_PK is a substitution string holding the primary key value of the system of records