My Oracle Support Banner

R12: CE: CE_BANK_PUB API is Missing Columns For CE_BANK_ACCOUNTS (Doc ID 2760003.1)

Last updated on JANUARY 30, 2023

Applies to:

Oracle Cash Management - Version 12.2.8 and later
Oracle Payables - Version 12.2.8 and later
Information in this document applies to any platform.

Goal

The latest code level for ce_bank_pub API patch 27632365 is already applied.
But ce_bank_pub.create_bank_acct and update_bank_acct does not populate / update following columns in CE_Bank_Accounts.


 ACCOUNT_HOLDER_ID
 POOL_PAYMENT_METHOD_CODE
 POOL_BANK_CHARGE_BEARER_CODE
 POOL_PAYMENT_REASON_CODE
 POOL_PAYMENT_REASON_COMMENTS
 POOL_REMITTANCE_MESSAGE1
 POOL_REMITTANCE_MESSAGE2
 POOL_REMITTANCE_MESSAGE3
 FX_CHARGE_CCID
 MANUAL_RECON_AMOUNT_TOLERANCE
 MANUAL_RECON_PERCENT_TOLERANCE
 RECON_CE_FOREIGN_DIFF_HANDLING
 RECON_CE_TOLERANCE_DIFF_ACCT
 GAIN_CODE_COMBINATION_ID
 LOSS_CODE_COMBINATION_ID
 FED_DUNS_NUM
 FED_DO_SYMBOL

Solution

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
Goal
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.