Oracle Fusion · Data dictionary
GL_LEDGER_SET_ASSIGNMENTS
General LedgerUsed in 38 subject areas2 reporting columns
General Ledger (GL).
Primary key: LEDGER_SET_ID, LEDGER_ID
Joins (inferred from key columns): LEDGER_ID → GL_LEDGERS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| END_DATE | ● | End date. | |
| LEDGER_ID | PK | ○ | Ledger identifier for the row. |
| LEDGER_SET_ID | PK | ○ | Identifier for the ledger set. |
| START_DATE | ● | Start date. |
2 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 GL_LEDGER_SET_ASSIGNMENTS.
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.
- Expenses - Employee Expense Overview Real Time
- Expenses - Expense Transactions Real Time
- Financials Common Module - Intercompany Transactions Real Time
- Fixed Assets - Asset Balances Real Time
- Fixed Assets - Asset Depreciation Real Time
- Fixed Assets - Asset Financial Information Real Time
- Fixed Assets - Asset Retirements and Reinstatements Real Time
- Fixed Assets - Asset Source Lines Real Time
- Fixed Assets - Asset Transactions Real Time
- Fixed Assets - Asset Transfer Real Time
- General Ledger - Journals Real Time
- General Ledger - Period Status Real Time
- General Ledger - Transactional Balances Real Time
- Payables Invoices - Holds Real Time
- Payables Invoices - Installments Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Payables Invoices - Trial Balance Real Time
- Payables Payments - Disbursements Real Time
- Payables Payments - Payment History Real Time
Need the extract + dbt staging for GL_LEDGER_SET_ASSIGNMENTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table