EXM_EXPENSE_REPORTS

SharedUsed in 1 subject areas16 reporting columns

Source object in the Oracle Fusion data model.

Primary key: EXPENSE_REPORT_ID

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.

Change a column here and these are the reports that move with it — the blast radius for any change to EXM_EXPENSE_REPORTS.

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.