R12: Oracle Payables: In a PPR Header Row, Click: +Show, and see Error Page and Exception Details including JBO-27122, ORA-01422, ORA-06512
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.
Payment Process Request (PPR) is in Formatting status, Terminate enabled. Click +SHOW and get the reported generic error: You have encountered an unexpected error.
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms