Fusion Reference
Foundation
Business units, the organization master, ledgers, account combinations, and the generic FND lookup table every module decodes through — the layer every ORG_ID and ORGANIZATION_ID resolves against
6 tables
Extraction map
The BICC extract data store (PVO) reaching each of this module’s tables — the bulk path out of the SaaS database. Full details, OTBI subject areas, and provenance links live on each table page.
| Table | BICC extract data store (PVO) |
|---|---|
| FUN_ALL_BUSINESS_UNITS_V | FscmTopModelAM.FinExtractAM.FunBiccExtractAM.BusinessUnitExtractPVO |
| GL_CODE_COMBINATIONS | FscmTopModelAM.FinExtractAM.GlBiccExtractAM.CodeCombinationExtractPVO |
| GL_LEDGERS | FscmTopModelAM.FinExtractAM.GlBiccExtractAM.LedgerExtractPVO |
| INV_ORG_PARAMETERS | FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.InventoryOrgParametersPVO |
| INV_ORG_PARAMETERS | FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.InvOrgParametersExtractPVO |
Tables
Master · 3
- GL_CODE_COMBINATIONSEvery chart-of-accounts segment combination (CCID) stored once — the account string behind each SEGMENTn set; accounting distributions and journal lines reference accounts through CODE_COMBINATION_IDProduct: GLmaster
- GL_LEDGERSOne row per ledger — currency, calendar, chart of accounts, and accounting convention; the ledger context business units and subledgers resolve toProduct: GLmaster
- HR_ALL_ORGANIZATION_UNITS_FThe date-effective master list of every organization unit — business units, inventory orgs, departments, and legal-entity org rows all resolve their ids here, one row per org per effectivity windowProduct: PERmaster
View · 2
- FND_LOOKUP_VALUESThe generic lookup view — every seeded and user-defined code list (lookup type + code) with its meaning and description, one row per code per installed language; the decode target for coded columns across every moduleProduct: FNDview
- FUN_ALL_BUSINESS_UNITS_VThe delivered view that enumerates business units — the BU domain later waves' documents stripe on — with the legal entity, primary ledger, and default set each BU resolves toProduct: FUNview