In Oracle E-Business Suite R12, administrators often query the table FND_PROFILE_OPTION_VALUES to check profile settings at the user, responsibility, or site level. However, many times the VALUE column displays a lookup code instead of a readable description — making it hard to interpret.
For example if you query "FND: Debug Log Level" for user or site level from backend, it shows some numeric value.
Let’s look at how to find the actual meaning behind those coded values.
🧩 Step 1: Identify the Lookup Type
-
Log in to EBS using the Application Developer responsibility.
-
Navigate to:
Profiles → System → Query the Profile Option -"AFLOG_LEVEL" (using its short name). -
In the results, note down the Lookup Type associated with that profile.
🧠 Step 2: Query the Lookup Meaning
Once you know the Lookup Type, use the following SQL query to decode the meaning:
SELECT lookup_code,
meaning,
description
FROM fnd_lookup_values
WHERE lookup_type = 'AFLOG_LEVELS';
🧾 Example
If a profile option value shows as ‘3’ or ‘4’ in FND_PROFILE_OPTION_VALUES, the above query helps you find out what those codes actually represent (for example, Statement or Exception).
✅ Summary
When you see cryptic values in FND_PROFILE_OPTION_VALUES, remember:
-
Use the Application Developer responsibility to find the Lookup Type.
-
Query FND_LOOKUP_VALUES to get the actual meaning.
This simple approach helps DBAs and support teams interpret configuration settings accurately — ensuring smoother troubleshooting and configuration validation.