R12 : AP : Unable to Merge the Supplier due to "Unexpected error: ORA-01400: cannot insert NULL into ("IBY"."IBY_PMT_INSTR_USES_ALL"."EXT_PMT_PARTY_ID")iby.plsql.IBY_SUPP_BANK_MERGE_PUB.BANK_ACCOUNTS_MERGE(MERGE_BANKS)
(Doc ID 2945367.1)
Last updated on MAY 02, 2023
Applies to:
Oracle Payables - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
Supplier Merge program completes with the following error:
Calling IBY API - Start
In IBY merge call, p_last_site_flag:Y
Unexpected error: ORA-01400: cannot insert NULL into ("IBY"."IBY_PMT_INSTR_USES_ALL"."EXT_PMT_PARTY_ID")iby.plsql.IBY_SUPP_BANK_MERGE_PUB.BANK_ACCOUNTS_MERGE(MERGE_BANKS)
In IBY merge call, l_return_status:U
In IBY merge call, p_last_site_flag:Y
Unexpected error: ORA-01400: cannot insert NULL into ("IBY"."IBY_PMT_INSTR_USES_ALL"."EXT_PMT_PARTY_ID")iby.plsql.IBY_SUPP_BANK_MERGE_PUB.BANK_ACCOUNTS_MERGE(MERGE_BANKS)
In IBY merge call, l_return_status:U
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |