My Oracle Support Banner

Add Labor Costing Rule To Organization Labor Costing Rule Form : ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 2403444.1)

Last updated on FEBRUARY 15, 2019

Applies to:

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


When attempting to add labor costing rule to organization labor costing rule form to upgraded 12.2.6 instance, the following error is displayed :

ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PA_CURRENCY", line 68
ORA-06512: at "APPS.PA_CURRENCY", line 145

1. Open the Organization Labor Costing Rules form.
2. Add a new rule
3. Error is thrown.


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

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