OIE - Auditor Count Is Off By One Expense Report Number (Doc ID 2056380.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Internet Expenses - Version 12.2.4 and later
Information in this document applies to any platform.
Auditor Setup
Audit Queue Count

Goal

On : 12.2.4 version, Audit Expense Reports

In the Expenses Audit=>Auditor Setup form the Auditor Count is off. For example for one of auditor the screen shows 19 expenses in her queue however when querying the expenses via the forms only 18 rows exist. Querying in sqlplus from the ap_aud_queue table 19 rows instead show (one 'extra for example TCMS438620').   Attempting to query this report via the Audit form returns 0 rows.   There is also no row in the ap_expense_report_headers_all for this report either.

 

Why does occur? Why are there more rows in the the ap_aud_queues than there are actual expense reports for the Auditor to Audit?

NOTE: To manually see rows at the table level:

select * from ap_aud_queues where auditor_id = <target auditor_id>;
select * from ap_expense_report_headers_all where report_header_id = <target expense report header it, example 438620 from above>'

 

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