Expenses
This section provides details about Oracle Fusion ERP Analytics Expenses subject area metrics.
Financials - EXM Employee Expenses
These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder, Document Currency (DC) fact folder and Reimbursement Currency fact folder in Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Transaction Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.
| Metric | Metric Definition |
|---|---|
| Audit Adjustment Amount | This metric is supported only in reimbursement Currency, and is calculated as follows: original reimbursement amount - expense amount. |
| Auto Audit Percentage | Shows the percentage of expense reports with audit type equal to automatic approval. |
| Average Days Late | This metric is calculated as follows: days late/ expense reports count where days late is the number of days between expense report Submission date and transaction date. |
| Average Expense Amount | This metric is calculated as follows: total expense amount/expense reports count. |
| Cash Expense Amount | Shows the expense amount for lines with expense source as cash. |
| Cash Expense Reimbursement Cycle Time (Days) | This metric is calculated as follows: total cash expense days/ expense distribution count where total cash expense days is the number of days between cash expense report paid date and Submission date. |
| Credit Card Expense Amount | Shows the expense amount for lines with expense source as credit card. |
| Expense Approval Cycle Time (Days) | This metric is calculated as follows: total approval days/ expense distribution count where total approval days is the number of days between expense report final approval date and Submission date. |
| Expense Distribution Count | This metric shows count of distinct expense report distributions. |
| Expense Filing Cycle Time (Days) | This metric is calculated as follows: total Filing days/ expense distribution count where total Filing days is the number of days between expense report Submission date and creation date. |
| Expense Lines Count | This metric shows count of distinct expense report lines. |
| Expense Reports Count | This metric shows count of distinct expense reports. |
| Manual Audit Percentage | Shows the percentage of expense reports with audit type not equal to automatic approval. |
| Per Diem Amount | This metric displays the Per Diem Amount in Document Currency. |
| Receipt Amount | This metric displays the Receipt Amount in Document Currency. |
| Reimbursement Amount | This metric displays the Reimbursement Amount in Document and Reimbursement currency. |
| Total Expense Amount | Shows the expense amount. |