My Oracle Support Banner

R12: AP: PPR Header Row, Click: +Show, and see Error ORA-01422 / IBY_UTILITY_PVT (Doc ID 1322094.1)

Last updated on FEBRUARY 01, 2019

Applies to:

Oracle Payments - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

Payment Process Request (PPR) is in Formatting status, Terminate enabled.
Click +SHOW on the PPR to check sub-status and process to print.
Error is thrown.

ERROR
-----------------------
Error Stack:

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT * FROM (SELECT I.payment_instruction_id, PMT.payment_service_request_id, I.pay_admin_assigned_ref_code, I.bank_assigned_ref_code, I.creation_date, I.payments_complete_code, I.org_id, IBY_FD_USER_API_PUB.Pmt_Instr_Action_Enabled(I.payment_instruction_status, I.org_id, I.payment_instruction_id, I.request_id) AS Action_Switcher, IBY_FD_USER_API_PUB.Payment_Instruction_Action(I.payment_instruction_status) AS Destination, IBY1.meaning status, I.payment_instruction_status,

Down a bit more:
## Detail 0 ##
java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.IBY_UTILITY_PVT", line 1284

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
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.