PAXBUEBU: Attempt To Create Budget Or Update Existing Budget Fails With ORA-01422 Exact Fetch Returns More Than Requested Number Of Rows

(Doc ID 1941696.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Project Planning and Control - Version 12.0.1 and later
Information in this document applies to any platform.
Form:PAXBUEBU.FMB - Budgets

Symptoms

You attempt to update the budget for your project

  1. You select your Projects responsibility
  2. You navigate to the "Budgets" form
  3. You query back your budget
  4. You amend your budget
  5. You save your changes. If fails with the following error:
    ORA-01422 Exact Fetch Returns more than requested number of rows

Note: The same issue happens when you attempt to create a new budget

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