After Installing Patch 14383315 Purchase Order Approval Fails With APP-PO-14142 Start_WF_Process ORA-1422 Exact Fetch (Doc ID 1530673.1)

Last updated on JULY 14, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When submitting a Purchase Order (PO) for approval the following error occurs.

ERROR
-----------------------
  APP-PO-14142: In Exception of
  Start_WF_Process()-PO_REQAPPROVAL_INIT1.Start_WF_Process:In Exception
  handler: ORA-1422:exact fetch returns more than requested number of rows
  Cause: A SQL error has occurred in In Exception of Start_WF_Process(). The
  SQL error is ORA-1422: exact fetch returns more than requested number of
  rows
  Action: Take note of both this error number and the actions you were trying
  to perform. Contact your system administrator for further assistance.

Changes

 Application of Patch 14383315.

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