OTBI_EXM: No data for Transaction/Billed/Posted Amount Columns on corporate card expense
When querying corporate card expenses that have not been added to an expense report, no data is populated for fact columns Transaction Amount, Billed Amount, and Posted Amount. All columns sourced from Subject Area Expenses - Expense Transactions Real Time
Is anyone able to pull data for any of the listed columns for a corporate card expense when it hasn't been added to an expense report? As soon I add the corporate card expense to a report then data for those columns can be pulled. The only column that will pull data for a corporate card expense that is still in a user's expense queue is the Reimbursable Amount column.