R12: IBY: Build Payments Fail With 24381 / ORA-1400
(Doc ID 2012280.1)
Last updated on JUNE 07, 2021
Applies to:
Oracle Payables - Version 12.1.1 and laterInformation 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
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 |