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

Last updated on MAY 01, 2019

Applies to:

Symptoms

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

ERROR
-----------------------
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

The issue can be reproduced at will with the following steps:
1. log into payable application
2. Payments --> entry--Payment manager
3. submit PPR

Cause

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