Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 52 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 288 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 111 Oracle Analytics and AI Trainings
- 21 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
