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

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