My Oracle Support Banner

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

Last updated on AUGUST 16, 2022

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


The last_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 fields were last updated after expense report was INVOICED, however, the Payables Payment process is not updating these two fields.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.