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.
Problems that run through this table