FUSIONLENS DESKTOP ONLY BETA SSO SUPPORTED

See Exactly What a Value Set
Is Actually Built On.

Search Oracle Fusion Value Sets, see their real values, and for Table-validated sets, see the SQL actually behind them — without ever opening Setup and Maintenance.

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

Value Set Explorer Connected

XX_COST%

XX_COST_CENTER_LIST

XX_COST_ALLOC_TABLE

XX_COST_TYPE_LOV

MODULE: Project Costing
VALIDATION TYPE: Table
FROM CLAUSE: XX_COST_ALLOCATION_B
VALUE COLUMN NAME: ALLOC_CODE

Run SQL

Illustrative — runs against a real Value Set.

How it works

From search to understanding, in one screen.

Search by Value Set code

Type your own search pattern (e.g. XX_COST%). Oracle itself rejects a search that begins with a wildcard, for performance reasons - that's Oracle's own rule, not a limitation here.

Your own search pattern

Select a result

For an Independent-type Value Set, you see the actual list of values. For other types like Table, there's no discrete value list, so you see the Value Set's own definition instead.

Adapts to the type

See and run the SQL for Table-type sets

See a runnable SQL statement auto-built from the FROM Clause and Value Column Name - with detected parameters, run directly against your connected environment.

Auto-built SQL

Switch between Value Sets

Selecting the next Value Set returns cleanly to the search screen - without starting over from the beginning.

Keeps your place

A Value Set's structure, finally visible.

Not a generic message — the real definition.

The Real Definition, Not a Generic Message

When you select a Table-type Value Set, you see the real definition data - Module, Validation Type, FROM Clause, Value Column Name - the same information you'd see on Oracle's own Edit Value Set screen.

Module and Validation Type
FROM Clause and WHERE condition
Value / Description / ID column names

-- Module: Project Costing | Validation Type: Table
FROM XX_COST_ALLOCATION_B
VALUE COLUMN ALLOC_CODE

Run the SQL the Definition Implies

See a SQL statement auto-built from the FROM Clause and Value Column Name, fill in detected parameters, and run it directly against your connected environment - without opening a separate SQL editor.

Monaco-based SQL viewer
Detected bind parameters
Run against your live environment

SELECT alloc_code, description
  FROM xx_cost_allocation_b
 WHERE enabled_flag = 'Y'

Oracle doesn't treat every Value Set type the same way.

Neither does FusionLens - each type is shown the way it actually works.

Independent

Has its own standalone list of values - with codes, descriptions, and dates. FusionLens shows that list directly.

View values directly

Table

Has no separate value list - values come from another table. FusionLens shows the Value Set's definition and the SQL behind it instead.

View definition and SQL

Frequently Asked Questions

Can I add or edit individual values inside a Value Set?

Not yet. Searching Value Sets, viewing their real values, and viewing a Table-type set's definition and SQL are all fully supported today - adding and editing individual values is on our roadmap.

What's the difference between an Independent and a Table Value Set?

Independent has its own list of values (code + description). Table gets its values from another table entirely - there's no separate list, so you see that table's definition (FROM Clause, Value Column Name) instead.

Can I use my own wildcard in my search?

Yes - you control your own search pattern (e.g. XX_COST%). Just make sure your search doesn't start with a wildcard.

See Exactly What a Value Set Is Actually Built On.