Oracle Fusion · Data dictionary
EXM_EXPENSE_REPORTS
SharedUsed in 1 subject areas16 reporting columns
Source object in the Oracle Fusion data model.
Primary key: EXPENSE_REPORT_ID
Joins (inferred from key columns): PAYMENT_METHOD_CODE → IBY_PAYMENT_METHODS_B
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AUDIT_CODE | ● | Code identifying the audit. | |
| AUDIT_RETURN_REASON_CODE | ● | Code identifying the audit return reason. | |
| CASH_EXPENSE_PAID_DATE | ● | Cash expense paid date. | |
| EXPENSE_REPORT_DATE | ● | Expense report date. | |
| EXPENSE_REPORT_ID | PK | ○ | Identifier for the expense report. |
| EXPENSE_REPORT_NUM | ● | Expense report number. | |
| EXPENSE_REPORT_TOTAL | ● | Expense report total. | |
| EXPENSE_STATUS_CODE | ● | Code identifying the expense status. | |
| FINAL_APPROVAL_DATE | ● | Final approval date. | |
| IMAGED_RECEIPTS_STATUS_CODE | ● | Code identifying the imaged receipts status. | |
| PAYMENT_METHOD_CODE | ● | Code identifying the payment method. | |
| PURPOSE | ● | Purpose. | |
| RECEIPTS_RECEIVED_DATE | ● | Receipts received date. | |
| RECEIPTS_STATUS_CODE | ● | Code identifying the receipts status. | |
| REIMBURSEMENT_CURRENCY_CODE | ● | Currency code for the reimbursement. | |
| REPORT_SUBMIT_DATE | ● | Report submit date. | |
| SHORTPAY_TYPE_CODE | ● | Code identifying the shortpay type. |
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 EXM_EXPENSE_REPORTS.
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_EXPENSE_REPORTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table