R12: AP/IBY/CE: Payment Process Request Stuck in Assembled Payments Status and ORA-20001 is Returned in the Debug Log

(Doc ID 2086877.1)

Last updated on JUNE 26, 2017

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle Payments - Version 12.0.0 and later
Oracle Cash Management - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

 The Payment Process Request (PPR) always get stuck in "Assembled Payments" status
although Create Payment Instruction = Automatically Initiate When Payment Process Request is Complete

Steps used to submit the PPR:

1. Navigation: Payables Manager ->Payment:Entry -> Payments Manager

2. Payment Processing Tab -> Submit Single Request

3.  Under Payment Attributes tab, without using the list of value (flashlight icon),  but rather use a combination of keys to activate a menu to copy and paste the values for the following fields:

Disbursement Bank Account

Payment Document

Payment Process Profile

4.  Under Processing Tab, set Create Payment Instruction = Automatically Initiate When Payment Process Request is Complete

5.  After Invoice Selection, the PPR will be stuck in "Assembled Payments" status.

FND Debug log shows the following error:
sid:64793107: IBY_PAYINSTR_PUB.createPaymentInstructions:Payment document id AND Internal Bank Account id are not related Aborting program ..
IBY_PAYINSTR_PUB.createPaymentInstructions:Payment document id AND Internal Bank Account id are not related Aborting program ..
sid:64793107: 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 150898
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 150898
sid:64793107: IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -20001
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -20001
sid:64793107: IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-20001:
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-20001:
sid:64793107: Build program error: Exception occured when attempting to create payment instructions from the payments of the provided payment service request.
sid:64793107: IBY_DISBURSE_UI_API_PUB_PKG.unlock_pmt_entity:ENTER

 But the payment document belongs to the Bank Account that you are using.

Similar issue occur when submitting a Bank Account Transfer for Cash Management.

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