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

Last updated on MARCH 08, 2017

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  IND22741651 .  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 from AP_EXPENSE_REPORT_HEADERS_ALL

where invoice_num like '%IND22741651%';

select * from from AP_EXPENSE_REPORT_HEADERS_ALL
where report_header_id like '%22741651%';

select * from from AP_EXPENSE_REPORT_HEADERS_ALL
where  invoice_num like '%22741651%';
 

Solution

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