R12: OIE: Paid Expense Reports Are Showing with an Incorrect Negative Value on the OIE Home Page

(Doc ID 2314089.1)

Last updated on OCTOBER 04, 2017

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
OIE Home Page
Amount Paid
AMOUNT_DUE_EMPLOYEE
AP_EXPENSE_REPORT_HEADERS_ALL
TOTAL
AMOUNT_DUE_CCARD_COMPANY
ORA-2001: in Package IBY_DISBURSE_UI_API_PUB_PKG Procedure IBY_DISBURSE_UI_API_PUB_PKG.perform_check_print

Symptoms

On : 12.1.3 version, Expense Entry

ACTUAL BEHAVIOR
---------------
Expense report paid is showing in negative value in the Amount Paid on the OIE Home Page under Track Submitted Expense Reports even though a different positive amount was actually paid to the employee.

EXPECTED BEHAVIOR
-----------------------
Expect the actual Amount Paid to be reflected on the Expense Report.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit an Expense Report with an offsetting negative expense line, for example a report that totals 1045.26:


Cash:
Date Receipt Amount Expense Type Justification Merchant Name Original Receipt Required Receipt Missing Reimbursable Amount (USD) Details
18-07-2017 12.00 USD MealsDinner12.00
19-07-2017 13.00 US DMealsLunch13.00
19-07-2017 18.50 USD MealsDinner18.50
20-07-2017 12.00 USD MealsLunch12.00
20-07-2017 21.00 USD MealsDinner21.00
21-07-2017 9.00 USD MealsLunch9.00
21-07-2017 16.00 USD MealsDinner16.00
21-07-2017 530.67 USD HotelLodgingtest530.67
21-07-2017 191.43 USD Car RentalAuto Rental191.43
22-07-2017 140.00 USD MiscellaneousParking140.00
18-07-2017 3.50 USD MiscellaneousOther3.50
22-07-2017 7.00 USD MiscellaneousOther7.00
21-07-2017 23.00 USD MiscellaneousOther23.00
18-07-2017 695.00 USD AirfareAirfare695.00
18-07-2017 -695.00 USD MiscellaneousLess: Company Paid


Mileage:
Start Date End Date Expense Type Trip Distance Mileage Rate
18-07-2017 18-07-2017 Mileage 2(Miles) 2 24.08
22-07-2017 22-07-2017 Mileage 12(Miles) 2 24.08
------------------------------------------------------
                                                Total:  1045.26

2. Approve the report via workflow and Export to Payables.
3. Within the Payables responsibility use the Payment Process Request to Pay the resulting invoice. 
4. Notice that the Build Payments process completes in error however the payment has been made.
5. Review the report on the OIE Home Page and see status Paid with Amount $354.00 even though the report actually totals $1045.26
6. Check the back end and see AMOUNT_DUE_EMPLOYEE in the AP_EXPENSE_REPORT_HEADERS_ALL table shows as -$511.84 even though the TOTAL field shows $1045.26 and AMOUNT_DUE_CCARD_COMPANY is NULL.


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