We are working on a reporting requirement in Oracle Fusion Data Intelligence (FDI) to add the Business Capability attribute to the Talent Profile/Skills subject area. We have been investigating both the HCM transactional tables (via BI Publisher) and the FDI ADW schema (OAX$OAC) but cannot locate where this field is stored.
Background:Business Capability is visible in the UI at: My Client Groups → Profiles → Item Catalog → Skills Library → Edit Skill → Business Capability field. The lookup type driving the values is ORA_HRT_BUSINESS_CAPABILITY.
What we checked in HCM transactional tables (via BI Publisher - ApplicationDB_HCM):
We queried HRT_CONTENT_ITEMS_B for a known skill "Analytical Thinking" that has Business Capability populated in the UI:
DOMAIN_CODE = NULLINFORMATION1 through INFORMATION30 = all NULLITEM_TEXT_1 through ITEM_TEXT_30 = all NULL (except ITEM_TEXT_1 = ORA_APPROVED)ATTRIBUTE1 through ATTRIBUTE30 = all NULL
We also checked HRT_CONTENT_ITEMS_TL — only contains NAME and description, no Business Capability.
What we checked in FDI ADW (OAX$OAC schema):
DW_CONTENT_ITEM_D — no Business Capability columnDW_CONTENT_ITEM_D_TL — only NAME, no Business CapabilityDW_SKILL_CONTENT_CF — does not exist in our instanceOur questions:
- Which HCM transactional table and column stores the Business Capability lookup code per content item/skill?
- Is Business Capability extracted into FDI ADW by default? If yes, which table?
- If it is NOT extracted by default into FDI ADW, what is the recommended approach — Data Augmentation from BIP, a custom pipeline, or another method?
