R12: Oracle Payables: In a PPR Header Row, Click: +Show, and see Error Page and Exception Details including JBO-27122, ORA-01422, ORA-06512 (Doc ID 1322094.1)

Last updated on SEPTEMBER 23, 2016

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 and get the reported generic error: You have encountered an unexpected error.

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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Create PPR batch and process through Formatting.
Click +SHOW on the PPR to check sub-status and process to print.
Error is thrown.

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