LAST_UDPATE_DATE, EXPENSE_LAST_STATUS_DATE Are Not Updated When Expense Report Invoice is Paid (Doc ID 1189368.1)

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.
LAST_UDPATE_DATE
EXPENSE_LAST_STATUS_DATE
AP_EXPENSE_REPORT_HEADERS_ALL

Symptoms


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.

Cause

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