APXXEER Form : Expense Report Data Not Deleted From Distribution Table When One of the Entered Line Is Deleted

(Doc ID 2114509.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.


On : 12.1.3 version, Expense Entry

When entering expense report in APXXEER form , after deleting one of the entered lines, data in expense report lines gets deleted but distribution table is not getting updated accordingly.

It should delete data from expense distributions table as well.

The issue can be reproduced at will with the following steps:
1) Create expense report with 2 lines and save
2) See data from backend in expense header (ap_expense_report_headers_all), lines (ap_expense_report_lines_all) and distribution (ap_exp_report_dists_all) table
3) From front end (using FROMS) delete one line and save
4) Query the expense header (ap_expense_report_headers_all), lines (ap_expense_report_lines_all) and distribution (ap_exp_report_dists_all) table
5) Line deleted from the expense lines table BUT it's not deleted from distribution table.

The issue has the following business impact:
Incorrect data in expense report tables


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