Categories
- All Categories
- Oracle Analytics Learning Hub
- 34 Sharing Center
- 22 Oracle Analytics Lounge
- 258 Oracle Analytics News
- 47 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 98 Oracle Analytics Trainings
- 16 Oracle Analytics and AI 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
