R12: AP/OIE: How To Fix Expense Report With Duplicate Line Number, How To Delete An Expense Report Via SQL? (Doc ID 1970248.1)

Last updated on JANUARY 31, 2025

Applies to:

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

Unable to export an Expense Report(ER) via the Payables "Expense Report Export" program due to rejection code "Duplicate Line Number".

The ER has two lines in AP_EXPENSE_REPORT_LINES_ALL with the same DISTRIBUTION_LINE_NUMBER.

Is there a fix for this issue?

Can the ER be deleted completely from the system?

How to delete an Expense Report?

How to release Credit card transaction when Manager reject the Expense Report but Credit card transactions not released?

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Goal

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.