LAST_UDPATE_DATE, EXPENSE_LAST_STATUS_DATE Are Not Updated When Expense Report Invoice is Paid
Last updated on FEBRUARY 19, 2013
Applies to:Oracle Internet Expenses - Version 12.0.6 and later
Information in this document applies to any platform.
ltHE ast_update_date, expense_last_status_date and expense_status_code are updated in the AP_EXPENSE_REPORT_HEADERS_ALL table when an expense report is invoiced (via Expense Report Import in 11i, Expense Report Export in R12) however when the expense report related invoices is paid in Payables, only the expense_status_code is updated and set to 'Paid'. The other two fieldswere last updated after expense report was INVOICED, however, the Payables Payment process is not updating these two fields.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms