R12: AP: IBY: Payment Process Request Stuck in Assembled Status, Build Payment Program in Error: "CANNOT COMPLETE PAYMENT" Or "Either Payment document id AND Internal Bank Account id are not related or Payment document is end-dated Aborting program"
(Doc ID 2969502.1)
Last updated on AUGUST 24, 2023
Applies to:
Oracle Payables - Version 12.1.3 and laterOracle Payments - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
Payment Process Request is stuck in Assembled status.
Build Payment program has ended with below error in log file.
Enter: iby.scheduler.BuildPayments.runBuildPayments()
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 COMPLETE PAYMENT INSTRUCTION CREATION
Error Message:BUILD PROGRAM ERROR - CANNOT COMPLETE PAYMENT INSTRUCTION CREATION
An error occurred. Roll back any changes.
Done roll back changes.
Request completed in error.
CP main completed runProgram for oracle.apps.iby.scheduler.BuildPayments
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 COMPLETE PAYMENT INSTRUCTION CREATION
Error Message:BUILD PROGRAM ERROR - CANNOT COMPLETE PAYMENT INSTRUCTION CREATION
An error occurred. Roll back any changes.
Done roll back changes.
Request completed in error.
CP main completed runProgram for oracle.apps.iby.scheduler.BuildPayments
From FND Debug log
IBY_PAYINSTR_PUB.createPaymentInstructions:Either Payment document id AND Internal Bank Account id are not related or Payment document is end-dated Aborting program ..
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when creating payment instructions. Payment instruction creation will be aborted and no instructions will be committed for payment request XXXX
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -20001
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-20001:
Build program error: Exception occured when attempting to create payment instructions from the payments of the provided payment service request.
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when creating payment instructions. Payment instruction creation will be aborted and no instructions will be committed for payment request XXXX
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -20001
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-20001:
Build program error: Exception occured when attempting to create payment instructions from the payments of the provided payment service request.
The issue can be reproduced at will with the following steps:
1. Responsibility > Payables Manager
2. Navigation: Payments > Payments Manager > Create a Payment Process request
3. Go to Other > Requests > Run > Check Build payment program request, it ends in error
Changes
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 |