Oracle Fusion · Data dictionary
EXM_OTBI_STATS_SUMMARY
SharedUsed in 1 subject areas21 reporting columns
summary / aggregate.
Primary key: not yet catalogued for EXM_OTBI_STATS_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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
Need the extract + dbt staging for EXM_OTBI_STATS_SUMMARY?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table