Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 222 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OTL Table to connect from HCM Common Lookups (value sets)

Hello,
We're trying to create an OTL BIP report with a column that uses value sets (HCM Common Lookups). The base table that we use is HWM_TM_REC. Per checking, we cannot find any columns to connect to FND_LOOKUP_VALUES table (table that stores the lookup values).
Can you please help find which OTL Table we can use to connect to the FND_LOOKUP_VALUES table?
Thank you.
Answers
-
Whatever column is using that lookup in HWM_TM_REC table, join that using lookup_code in fnd_lookup_values.
Thanks.
0 -
Hello, we can't find the column in HWM_TM_REC table to connect on the FND_LOOKUP Values table. Can you please help identify which column should we use or is it coming from a different OTL table?
For reference, here's the NSD Category column we're trying to extract in UI (Entry Details)
Config
Thank you.0