My Oracle Support Banner

R12: IBY: Build Payments Fail With 24381 / ORA-1400 (Doc ID 2012280.1)

Last updated on JULY 23, 2019

Applies to:

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

Symptoms

Build Payments program error: Unable to insert documents payable of the provided payment
Following is seen in the log with FND Debug enabled.
 

 

IBY_DISBURSE_SUBMIT_PUB_PKG.insert_payreq_documents:IBY_DISBURSE_SUBMIT_PUB_PKG.insert_payreq_documents:SQLCODE: -24381
IBY_DISBURSE_SUBMIT_PUB_PKG.insert_payreq_documents:IBY_DISBURSE_SUBMIT_PUB_PKG.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_PKG.insert_payreq_documents: While inserting document with Invoice Number : x with Invoice ID : x
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Could not insert documents payable for payment service request. Calling app id 200, calling app payment service request cd x



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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.