Oracle Fusion · Data dictionary
FUN_ALL_BUSINESS_UNITS_V
IntercompanyUsed in 132 subject areas18 reporting columns
Federation (FUN), business unit master across the enterprise.
Primary key: BU_ID
Joins (inferred from key columns): LEGAL_ENTITY_ID → XLE_ENTITY_PROFILES
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BUSINESS_GROUP_ID | ● | Identifier for the business group. | |
| BU_ID | PK | ● | Identifier for the business unit. |
| BU_NAME | ● | Name of the business unit. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DATE_FROM | ● | Date from. | |
| DATE_TO | ● | Date to. | |
| DEFAULT_CURRENCY_CODE | ● | Currency code for the default. | |
| DEFAULT_SET_ID | ● | Identifier for the default set. | |
| ENABLED_FOR_HR_FLAG | ● | Indicator (Y/N) for the enabled for hr. | |
| FIN_BUSINESS_UNIT_ID | ● | Identifier for the fin business unit. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LEGAL_ENTITY_ID | ● | Identifier of the legal entity. | |
| LOCATION_ID | ● | Identifier for the location. | |
| MANAGER_ID | ● | Identifier for the manager. | |
| PRIMARY_LEDGER_ID | ● | Identifier for the primary ledger. | |
| SHORT_CODE | ● | Code identifying the short. | |
| STATUS | ● | Status. |
5 reports read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to FUN_ALL_BUSINESS_UNITS_V.
- AP Financial System Parameters Report
- AP System Parameters Report
- Lease BU Configurations Report
- Golden Tax Reconciliation Report
- Balancing Segment Value Assignments Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Budgetary Control - Transactions Real Time
- Costing - COGS and Gross Margin Real Time
- Costing - Cost Accounting Period Close Real Time
- Costing - Cost Accounting Real Time
- Costing - Cost Rollup Details Real Time
- Costing - Inventory Valuation Real Time
- Costing - Landed Costs Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Costing - Overhead Rates Real Time
- Costing - Period Intransit Inventory Valuation Real Time
- Costing - Period Inventory Valuation Real Time
- Costing - Receipt Accounting Period Close Real Time
- Costing - Receipt Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
- Costing - Standard Cost Real Time
- Costing - Supply Chain Cost Rollup Real Time
- Costing - Transaction Cost Real Time
- Costing - Transfer Order Receipt Landed Cost Charges Real Time
- Costing - Where Used Details Real Time
- Costing - Work Order Costs Real Time
Need the extract + dbt staging for FUN_ALL_BUSINESS_UNITS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table