Oracle Fusion · Data dictionary
XLE_ENTITY_PROFILES
SharedUsed in 161 subject areas73 reporting columnsBICC incremental-ready
Legal Entity (XLE) — the legal-entity master.
Primary key: LEGAL_ENTITY_ID · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTIVITY_CODE | ● | Code identifying the activity. | |
| ATTRIBUTE1 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE10 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE11 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE12 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE13 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE14 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE15 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE16 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE17 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE18 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE19 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE2 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE20 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE3 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE4 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE5 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE6 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE7 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE8 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE9 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_CATEGORY | ● | Descriptive flexfield context (structure definition). | |
| ATTRIBUTE_DATE1 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE2 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE3 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE4 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE5 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER1 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER2 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER3 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER4 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER5 | ● | Descriptive flexfield segment. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| EFFECTIVE_FROM | ● | Effective from. | |
| EFFECTIVE_TO | ● | Effective to. | |
| ENTERPRISE_ID | ● | Identifier for the enterprise. | |
| GEOGRAPHY_ID | ● | Identifier for the geography. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LEGAL_EMPLOYER_FLAG | ● | Indicator (Y/N) for the legal employer. | |
| LEGAL_ENTITY_ID | PK | ● | Identifier of the legal entity. |
| LEGAL_ENTITY_IDENTIFIER | ● | Legal entity identifier. | |
| LE_INFORMATION1 | ● | Legal entity information1. | |
| LE_INFORMATION10 | ● | Legal entity information10. | |
| LE_INFORMATION11 | ● | Legal entity information11. | |
| LE_INFORMATION12 | ● | Legal entity information12. | |
| LE_INFORMATION13 | ● | Legal entity information13. | |
| LE_INFORMATION14 | ● | Legal entity information14. | |
| LE_INFORMATION15 | ● | Legal entity information15. | |
| LE_INFORMATION16 | ● | Legal entity information16. | |
| LE_INFORMATION17 | ● | Legal entity information17. | |
| LE_INFORMATION18 | ● | Legal entity information18. | |
| LE_INFORMATION19 | ● | Legal entity information19. | |
| LE_INFORMATION2 | ● | Legal entity information2. | |
| LE_INFORMATION20 | ● | Legal entity information20. | |
| LE_INFORMATION3 | ● | Legal entity information3. | |
| LE_INFORMATION4 | ● | Legal entity information4. | |
| LE_INFORMATION5 | ● | Legal entity information5. | |
| LE_INFORMATION6 | ● | Legal entity information6. | |
| LE_INFORMATION7 | ● | Legal entity information7. | |
| LE_INFORMATION8 | ● | Legal entity information8. | |
| LE_INFORMATION9 | ● | Legal entity information9. | |
| LE_INFORMATION_CONTEXT | ● | Legal entity information context. | |
| NAME | ● | Name. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PARENT_PSU_ID | ● | Identifier for the parent psu. | |
| PARTY_ID | ● | Identifier for the party. | |
| PSU_FLAG | ● | Indicator (Y/N) for the psu. | |
| SUB_ACTIVITY_CODE | ● | Code identifying the sub activity. | |
| TRANSACTING_ENTITY_FLAG | ● | Indicator (Y/N) for the transacting entity. | |
| TYPE_OF_COMPANY | ● | Type of company. |
4 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 XLE_ENTITY_PROFILES.
- Transactions Available for Reconciliation Report
- Manual Subledger Journals Report
- General Ledger Trial Balance Monthly Movements Report
- AP Disbursements 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.
- Cash Management - External Cash 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 XLE_ENTITY_PROFILES?
We ship parameterized SQL, BICC config, and dbt models you own.