Oracle Fusion · Data dictionary
AR_LOOKUPS
ReceivablesUsed in 12 subject areas3 reporting columns
Receivables (AR) — configurable lookup values.
Primary key: not yet catalogued for AR_LOOKUPS — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ENABLED_FLAG | ● | Indicator (Y/N) for the enabled. | |
| LOOKUP_CODE | ● | Code identifying the lookup. | |
| MEANING | ● | Meaning. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
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.
- Receivables - Adjustments Real Time
- Receivables - Bills Receivable Real Time
- Receivables - Credit Memo Applications Real Time
- Receivables - Credit Memo Requests Real Time
- Receivables - Miscellaneous Receipts Real Time
- Receivables - Payment Schedules Real Time
- Receivables - Receipts Details Real Time
- Receivables - Revenue Adjustments Real Time
- Receivables - Standard Receipts Application Details Real Time
- Receivables - Transactions Real Time
- Subledger Accounting - Journals Real Time
- Subledger Accounting - Receivables Summary Reconciliation Real Time
Need the extract + dbt staging for AR_LOOKUPS?
We ship parameterized SQL, BICC config, and dbt models you own.