OTL Table to connect from HCM Common Lookups (value sets)

Question

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.

User_RD03L · Answer

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.

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/26231/otl-table-to-connect-from-hcm-common-lookups-value-sets

Whatever column is using that lookup in HWM_TM_REC table, join that using lookup_code in fnd_lookup_values.

Thanks.