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 AUGUST 14, 2017

Applies to:

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

Symptoms

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
IBY_DISBURSE_SUBMIT_PUB_PKG.insert_payreq_documents:IBY_DISBURSE_SUBMIT_PUB_PK
G.insert_payreq_documents:SQLCODE: -24381
"IBY_DISBURSE_SUBMIT_PUB_PKG.insert_payreq_documents:IBY_DISBURSE_SUBMIT_PUB_P
KG.insert_payreq_documents:SQLERRM: ORA-24381: error(s) in array DML
ORA-01400: cannot insert NULL into
(""IBY"".""IBY_DOCS_PAYABLE_ALL"".""DOCUMENT_CURRENCY_CODE"")"
IBY_DISBURSE_SUBMIT_PUB_PKG.insert_payreq_documents:IBY_DISBURSE_SUBMIT_PUB_PK
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



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

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

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