ORACLE HCM · FUSIONLENS DESKTOP ONLY BETA SSO SUPPORTED

See What Every Fast Formula
Actually Does — Then Fix It.

FusionLens Desktop shows you a Fast Formula's full text, lets you correct it, and shows you exactly what every Value Set and Database Item inside it resolves to right now — live, without leaving the editor.

Requires a FusionLens Desktop license — delivered as a desktop application. This feature is in beta and is being actively developed. Also works with your company's SSO login.
See Premium Plans Create Free Account
Fast Formula Editor — LEAVE_ENTITLEMENT_CALC Connected 
1  /* Annual leave remaining, after approved absences */
2  l_annual_entitlement = 22
3  l_absence_days = GET_ABSENCE_DAYS('ANNUAL', l_person_id)
4
5  IF l_absence_days > 0 THEN
6    (l_remaining_days = l_annual_entitlement - l_absence_days)
7  ELSE
8    (l_remaining_days = l_annual_entitlement)
9
10 l_grade_ceiling = GET_VALUE_SET('XX_LEAVE_CAP_BY_GRADE', l_grade)
HOVERING: l_remaining_days
= 19
l_absence_days resolved to 3 → IF branch taken → 22 − 3
Illustrative — runs live against a real formula.

How it works

From search to compile, in one editor.

1

Search for a formula and open it

Search by name, type, effective date, or legislative data group. FusionLens opens the formula's full text right in the editor - through your connected Oracle Fusion environment.

Full formula text
2

Correct the text directly

Edit the description or the formula text right inside FusionLens's own editor - without navigating Oracle's Setup and Maintenance screens to get there.

Edit in place
3

Ctrl+Click any Value Set or Database Item

Ctrl+Click (or press F4 on) a GET_VALUE_SET(...) call or a Database Item mentioned in the formula - see its definition, the SQL it implies, and run it directly against your connected environment.

Live SQL run
4

Hover a variable to see what it resolves to

Hover a variable you never looked up directly - FusionLens traces IF/ELSE branches and simple arithmetic to work out its current value.

Variable tracing
5

Save, Submit, Compile

Oracle's own lifecycle: Save keeps your draft, Submit sends it into the approval/compile pipeline, Compile builds it, Refresh confirms the status. All from within FusionLens.

Oracle's own pipeline

Reading a formula stops being a guessing game.

Two capabilities, in the same screen: understanding context and tracing value.

Value Sets and Database Items, in Context

A formula can reference dozens of Value Sets and Database Items. Instead of looking each one up separately in Setup and Maintenance, Ctrl+Click it right inside the formula to see its definition and run the real query.

  • Open with Ctrl+Click or F4
  • Auto-built, runnable SQL
  • Input fields for detected parameters
  • Hover shows the result of your last run
-- GET_VALUE_SET('XX_LEAVE_CAP_BY_GRADE', l_grade)
SELECT vs.value, vs.description
  FROM fnd_vs_value_sets vs
 WHERE vs.value_set_code = 'XX_LEAVE_CAP_BY_GRADE'
   AND vs.value = :l_grade   -- detected parameter

What Does a Variable Equal? Just Hover

FusionLens evaluates IF/THEN/ELSE branches and traces basic arithmetic (+, -, ||, and a small set of functions like TO_NUMBER and ROUND) to work out what a variable you never ran directly equals, at that exact point in the formula text.

  • Correctly picks the right IF/ELSE branch
  • Follows chained variables
  • Resolves as of that point in the text
  • Shows nothing rather than guess when unsure
l_remaining_days = 22 - l_absence_days
-- hover shows: 19 (l_absence_days resolved to 3)

Simulate: Run the Whole Formula With Your Own Inputs

Fill in every parameter in the formula - DEFAULT FOR values, Value Sets, Database Items, and contexts - and see the RETURN result along with a step-by-step trace of how every variable was computed. Inputs recompute live as you type, and are remembered separately for each formula, so you don't retype the same values next time.

  • RETURN result and a step-by-step trace
  • Live recompute as you type
  • Inputs remembered separately per formula
  • Run a Value Set's SQL directly from Simulate
-- Formula Parameters
PERSON_ID           = 300000012345678
L_ABSENCE_DAYS      = 3

-- Result
RETURN l_remaining_days = 19

Oracle's own edit lifecycle, from inside FusionLens.

Correct (edit in place) and Update (new effective-dated version) — both supported.

Save
Keeps your draft, stays in edit mode
Submit
Sends it into Oracle's approval/compile pipeline
Compile
Builds executable code from what's saved
Refresh
Re-checks the compiled/invalid status

Frequently Asked Questions

Does this replace Oracle's own Manage Fast Formulas screen?
No — it works against the same Oracle data and the same approval/compile pipeline. FusionLens just lets you see the formula's text, correct it, and understand its references without navigating Oracle's own screens to do it.
Does variable tracing (hover) work on every formula?
It covers simple IF/ELSE branching and basic arithmetic (addition, subtraction, concatenation, a small set of functions). This is not a full Fast Formula interpreter - it doesn't support loops or more complex expressions, and it shows nothing rather than guess when it isn't confident.
Can I simulate a Fast Formula with my own inputs?
Yes - the Simulate screen lets you fill in every parameter in the formula (DEFAULT FOR values, Value Sets, Database Items, and contexts), then see the RETURN result and a step-by-step trace of how every variable was computed. Inputs recompute live as you type, and are remembered separately for each formula.
My company uses single sign-on (SSO) - does this still work?
Yes - users who connect via SSO can use formula search, viewing, and editing as well.
How do I get FusionLens Desktop?
The Fast Formula editor is part of FusionLens Desktop, included with Premium, Premium AI, and Enterprise subscriptions - no separate purchase required. See the Pricing page for details.

Stop guessing what a Fast Formula does.

Read, trace, and fix formulas with FusionLens Desktop — all from one place.

See Premium Plans Get Started Free