My Oracle Support Banner

R12: OIE: Duplicate Detection Warning Showing Non-Existent Report (Doc ID 2177047.1)

Last updated on DECEMBER 03, 2020

Applies to:

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

Symptoms

Duplicate Detection has been set up to attempt to detect duplicate internet expense reports.

When report is entered,
Policy Violation indicates that a duplicate claim has been detected.

However one of the expense reports listed does not exist.

Example:

Cash and Other Expenses: Details for Line 1
Credit Card Expenses: Details for Line 1
Policy Violation
A duplicate claim has been detected. This expense is not allowed as per the current policy setup in the application. Please review this expense claim information as well as the referenced report details mentioned below to check if this is a duplicate expense claim.

If you are sure this is a valid expense claim and is allowed per company policies, then please contact your Manager or Accounts Payables representative or System Administrator for assistance.

1. Expense Report # EXP26243 - Line # 7 (Refer Credit Card Expenses)
2. Expense Report # EXP26477 - Line # 7 (Refer cash and Other Expenses)

******************************

However, table level data shows EXP26477 does not exist:

Output from:

select *
from ap_expense_report_headers_all
where report_header_id in (26243,26477);

Highlights:

REPORT_HEADER_ID INVOICE_NUM
26243 EXP26243
26477 EXP26243.1

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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