My Oracle Support Banner

Is There A Way To Retrieve The Expense Report Which Have Been Deleted From OIE? (Doc ID 2007241.1)

Last updated on JULY 06, 2019

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
Rejected
APEXP
Deleted

Goal

An OIE user has created a specific expense report, for example  xxxx .  After a few days of submission and subsequent rejection during the Approval workflow the expense report was automatically deleted. The user he does not have copy of the receipts.  Is there any way to retrieve the expense report?   The following scripts returned no rows:

select * from AP_EXPENSE_REPORT_HEADERS_ALL where invoice_num like 'xxxx';

select * from AP_EXPENSE_REPORT_HEADERS_ALL
where report_header_id like 'yyyy';


 

Solution

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.