My Oracle Support Banner

Enterprise Command Center (ECC) Projects - Capital Dashboard Gives ORA-01422: Exact fetch returns more than requested number of rows, ORA-06512: at APPS.PA_MC_CURRENCY_PKG" when Trying to 'View/Assign Asset' or 'Reverse Asset' in the 'Asset' Sub-Tab. (Doc ID 2917158.1)

Last updated on MARCH 10, 2023

Applies to:

Oracle Project Costing - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

In the Capital Dashboard Summary form, under the 'Assets' sub-tab, when clicking on the 'View/Assign Asset' or 'Reverse Asset' icons, the following error is received while opening the forms based application:

ORA-01422: Exact fetch returns more than requested number of rows
ORA-06512: at APPS.PA_MC_CURRENCY_PKG", Line 185
ORA-06512: at APPS.PA_MC_CURRENCY_PKG", Line 187

 

Steps to Reproduce:

1.  Project Super User responsibility (or the responsibility where ECC is implemented and accessed)
2.  Project Command Center
3.  'Capital' tab
4.  'Summary' section | 'Assets' sub-tab
5.  Click on the 'View/Assign Asset' or 'Reverse Asset' icons and the error is returned

 

 

Changes

 New implementation

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.