Choosing Approval Assignments Form From Menu - Nothing Happens - Form Does Not Open

(Doc ID 1063223.1)

Last updated on FEBRUARY 05, 2017

Applies to:

Oracle Purchasing - Version 12.0 to 12.1 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

Users are not able to launch the standard approval groups and approval assignments forms from Purchasing Super User responsibility.

Steps to Reproduce:
1. Log into Purchasing super user responsibility
2. Select approval groups and approval assignments
3. Form refuses to launch

Other:
The following errors are seen as well when entering the purchase order summary screen and also the purchasing document types screens.

APP_PO_14142 : get_Po_parameters-10:ORA-01422 :exact fetch returns more than requested number of rows

 

Opening the Core Purchasing Form - the error is as follows:

APP-PO-14142: get_po_parameters-10: ORA-01422: exact fetch returns more than requested number of rows
Cause: A SQL error has occurred in  get_po_parameters.
The SQL error is ORA-01422: exact fetch returns more than requested number of rows

Changes

The instance was cloned.

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