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 MAY 31, 2018

Applies to:

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

Symptoms

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

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

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!


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