My Oracle Support Banner

Choosing Approval Assignments Form From Menu - Nothing Happens - Form Does Not Open - PDOI - PO_PDOI_PVT. Procedure init_sys_parameters.0;SQLERRM = ORA-01422 (Doc ID 1063223.1)

Last updated on MAY 11, 2020

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

 

PDOI - Import Standard Purchase Orders
It was also found that PDOI - Import Standard Purchase Orders was failing with the following.
po.plsql.PO_PDOI_PVT.init_startup_values.BEGIN Start of subprogram.
po.plsql.PO_PDOI_PVT.init_sys_parameters.BEGIN Start of subprogram.
po.plsql.po_message_s.get_po_parameters.10.EXCEPTION ;SQLERRM = ORA-01422: exact fetch returns more than requested number of rows "ORA-01422: exact fetch returns more than requested number of rows"
po.plsql.PO_PDOI_PVT..init_sys_parameters.0.EXCEPTION ORA-01422: exact fetch returns more than requested number of rows in Package po.plsql.PO_PDOI_PVT. Procedure init_sys_parameters.0;SQLERRM = ORA-01422: exact fetch returns more than requested number of rows "ORA-01422: exact fetch returns more than requested number of rows
po.plsql.PO_PDOI_PVT..init_startup_values.10.EXCEPTION ORA-01422: exact fetch returns more than requested number of rows in Package po.plsql.PO_PDOI_PVT. Procedure init_startup_values.10;SQLERRM = ORA-01422: exact fetch returns more than requested number of rows "ORA-01422: exact fetch returns more than requested number of rows
po.plsql.PO_PDOI_PVT..start_process.50.EXCEPTION ORA-01422: exact fetch returns more than requested number of rows in Package po.plsql.PO_PDOI_PVT. Procedure start_process.50;SQLERRM = ORA-01422: exact fetch returns more than requested number of rows "ORA-01422: exact fetch returns more than requested number of rows


po.plsql.PO_PDOI_PVT.wrap_up.BEGIN Start of subprogram.
po.plsql.PO_INTERFACE_ERRORS_UTL.flush_errors_tbl.BEGIN Start of subprogram.
po.plsql.PO_INTERFACE_ERRORS_UTL.init_errors_tbl.BEGIN Start of subprogram.
po.plsql.PO_INTERFACE_ERRORS_UTL.init_errors_tbl.END End of subprogram.
po.plsql.PO_INTERFACE_ERRORS_UTL.flush_errors_tbl.END End of subprogram.
po.plsql.PO_PDOI_PVT.wrap_up. Timing Stat: PDOI_ALL-1: Start=17:11:33.957, End=17:11:33.973, Duration=+00 00:00:00.015877 "ORA-01422: exact fetch returns more than requested number of rows
"
po.plsql.PO_PDOI_PVT.wrap_up.END End of subprogram.

Changes

The instance was cloned.

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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