Error in Creating Payables Payment ORA-01400: cannot insert NULL into (IBY.IBY_DOCS_PAYABLE_ALL.DOCUMENT_CURRENCY_CODE)

(Doc ID 2012678.1)

Last updated on JANUARY 04, 2018

Applies to:

Oracle Payables - Version 12.2.4 and later
Information in this document applies to any platform.


On : 12.2.4 version, Pmt PayReports PBatch & Prepay

Getting error: "Documents payable of single payment request could not be inserted into database", when a payment is created from Payment workbench

As per the FND debug LOG:

IBY_DISBURSE_SUBMIT_PUB_PKG.insert_payreq_documents : 1N
G.insert_payreq_documents:SQLCODE: -24381
KG.insert_payreq_documents:SQLERRM: ORA-24381: error(s) in array DML
ORA-01400: cannot insert NULL into
G.insert_payreq_documents: While inserting document with Invoice Number :
LCM2 with Invoice ID : 11001
IBY_DISBURSE_SINGLE_PMT_PKG.submit_single_payment : Could not insert
documents payable for payment service request. Calling app id 200, calling
IBY_DISBURSE_SINGLE_PMT_PKG.submit_single_payment : Single payment
request cannot be processed further. Exiting ..

Issue is for all payment methods

The issue can be reproduced at will with the following steps:
1. Payables responsibility
2. Pay the invoice
3. Get an error.

The issue has the following business impact:
Due to this issue, users cannot pay the supplier.


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