Oracle Fusion · Data dictionary
EXM_OTBI_STATS_BASE_SUMMARY
SharedUsed in 1 subject areas21 reporting columns
summary / aggregate.
Primary key: not yet catalogued for EXM_OTBI_STATS_BASE_SUMMARY, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| COMPANY | ● | Company. | |
| COST_CENTER | ● | Cost center. | |
| EXPENSE_CATEGORY_CODE | ● | Code identifying the expense category. | |
| EXPENSE_LOCATION_CITY | ● | Expense location city. | |
| EXPENSE_LOCATION_COUNTRY | ● | Expense location country. | |
| EXPENSE_LOCATION_STATE | ● | Expense location state. | |
| EXPENSE_STATUS_CODE | ● | Code identifying the expense status. | |
| EXPENSE_TOTAL | ● | Expense total. | |
| EXPENSE_TYPE_CATEGORY_CODE | ● | Code identifying the expense type category. | |
| EXPENSE_VIOLATION_TOTAL | ● | Expense violation total. | |
| MERCHANT_NAME | ● | Name of the merchant. | |
| NUM_AGING_BUCKET_1 | ● | Number aging bucket 1. | |
| NUM_AGING_BUCKET_2 | ● | Number aging bucket 2. | |
| NUM_AGING_BUCKET_3 | ● | Number aging bucket 3. | |
| NUM_EXPENSES | ● | Number expenses. | |
| NUM_EXPENSE_REPORTS | ● | Number expense reports. | |
| NUM_EXPENSE_VIOLATIONS | ● | Number expense violations. | |
| TOTAL_AGING_BUCKET_1 | ● | Total aging bucket 1. | |
| TOTAL_AGING_BUCKET_2 | ● | Total aging bucket 2. | |
| TOTAL_AGING_BUCKET_3 | ● | Total aging bucket 3. | |
| VIOLATION_TYPE_CODE | ● | Code identifying the violation type. |
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.
Need the extract + dbt staging for EXM_OTBI_STATS_BASE_SUMMARY?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table