R12:CANNOT VIEW EXPENSES AND VIOLATIONS REPORTING (Doc ID 1062529.1)

Last updated on FEBRUARY 16, 2016

Applies to:

Oracle Internet Expenses - Version 12.0.6 and later
Information in this document applies to any platform.
apwxwkfb.pls
APPS.AP_WEB_AME_PKG


Symptoms


Comments
--------
=== ODM Issue Clarification ===
This issue occurs in all instances of Applications Release version 12.0.6.

Cannot view expenses and violations reports in Internet Expense Reporting and Administration.
The following errors are returned:
Getting oracle.apps.fnd.framework.OAException: java.sql.SQLException:
ORA-20001: APP-SQLAP-10000: ORA-20001: APP-SQLAP-10000: ORA-01422: exact fetch returns more than
requested number of rows occurred in AP_WEB_MANAGEMENT_REPORTS_PKG.GetBaseCurrencyInfo
with parameters ()
while performing the following operation:
ORA-01422: exact fetch returns more than requested number of rows occurred in
AP_WEB_MANAGEMENT_REPORTING_PKG.ManagerHierarchySearch
with parameters ()
while performing the following operation:
ORA-20001: APP-SQLAP-10000: ORA-01422: exact fetch returns more than requested numbe
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.AP_WEB_MANAGEMENT_REPORTS_PKG", line 827
ORA-06512: at line 1

RECENT CHANGES
----------------------
Applied unidentified patch to resolve the issue.

BUSINESS IMPACT
---------------------
Cannot review reports

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