R12: AP/IBY/HRMS: The Build Program of a Payment Process Request Fails with Error : ORA-01427: Single-row Subquery Returns More Than One Row
(Doc ID 2964172.1)
Last updated on JULY 27, 2023
Applies to:
Oracle Payables - Version 12.0.0 and laterOracle Payments - Version 12.2 and later
Oracle Human Resources - Version 12.0 and later
Information in this document applies to any platform.
Symptoms
When processing a Payment Process Request (PPR) the following error appears in the log file of the build program:
Sql to be executed: BEGIN IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31); END;
BUILD PROGRAM ERROR - CANNOT CREATE PAYMENTS
Error Message:BUILD PROGRAM ERROR - CANNOT CREATE PAYMENTS
An error occurred. Roll back any changes.
....... (a lot of other messages)
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+--------------------------------------------------------------------------------------------------+
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:|STEP 6: Payment Creation :Timestamp:31-DEC-1950 12.30.01.038630000 AM -00:00|
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+--------------------------------------------------------------------------------------------------+
IBY_PAYGROUP_PUB.createPayments:SQL code: -1427
IBY_PAYGROUP_PUB.createPayments:SQL err msg: ORA-01427: single-row subquery returns more than one row
IBY_PAYGROUP_PUB.createPayments:IBY_PAYGROUP_PUB.createPayments:Exception while creating payments
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when building payments. Payment creation will be aborted and no payments will be committed for payment request 9999
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -1427
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-01427: single-row subquery returns more than one row
Build program error: Exception occured when attempting to create payments from the documents payable of the provided payment service request.
BUILD PROGRAM ERROR - CANNOT CREATE PAYMENTS
Error Message:BUILD PROGRAM ERROR - CANNOT CREATE PAYMENTS
An error occurred. Roll back any changes.
....... (a lot of other messages)
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+--------------------------------------------------------------------------------------------------+
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:|STEP 6: Payment Creation :Timestamp:31-DEC-1950 12.30.01.038630000 AM -00:00|
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+--------------------------------------------------------------------------------------------------+
IBY_PAYGROUP_PUB.createPayments:SQL code: -1427
IBY_PAYGROUP_PUB.createPayments:SQL err msg: ORA-01427: single-row subquery returns more than one row
IBY_PAYGROUP_PUB.createPayments:IBY_PAYGROUP_PUB.createPayments:Exception while creating payments
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when building payments. Payment creation will be aborted and no payments will be committed for payment request 9999
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -1427
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-01427: single-row subquery returns more than one row
Build program error: Exception occured when attempting to create payments from the documents payable of the provided payment service request.
To run a Payment Process Request (PPR):
- From a Payables Responsibility go to Payments -> Entry -> Payments Manager
- Click on "Submit a Single Payment Process Request"
- Fill out the information and click submit
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 |