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.
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-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
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