My Oracle Support Banner

Documentation on Importing Internal and External Bank Account In R12: Bank API's And Q/A (Doc ID 948993.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Receivables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle Cash Management - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Oracle Receivables - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Symptoms

1. Documentation on Importing Internal and External Bank Account In R12: Bank API's
2. APIs used
3. Limitation
4. Oracle Financial Pre-Upgrade Patch
5. Other Latest Patches
6. API's Issues
7. FAQ

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
 (1). Documentation on Importing Internal and External Bank Account In R12: Bank API's
 (2). APIs used
 (3). Limitation
 (4). Oracle Financial Pre-Upgrade Patch
 (5). Other Latest Patches
 (6). API Issues
 Issue 1: CE_BANK_PUB.update_bank_branch API:
 Issue 2: API for HZ_PARTIES.COUNTRY: , the table HZ_PARTIES is missing the country
 Issue 3: The decimal precision of min_check_amount is getting lost
 Issue 4: HZ_BANK_INVALID_PARENT ERROR OCCURS WHILE EXECUTING CE_BANK_PUB.UPDATE_BANK_BRANCH
 Issue 5: check for existence of banks/bank branches through API was incorrect
 Issue 6: Error 'This record in table HZ_PARTIES cannot be locked as it has been updated by another user.'
 Issue 7: Error "This Record In Table HZ_PARTIES Cannot Be Locked As It Has Been Updated By Another User."
 Issue 8: API to create only bank,branch and account for parameter address with respect to branch and account. How to load the address of bank at the time of creating bank using  API?
 Issue 9: Is there an API to Update swift code at Bank Branch level?
 Issue 10: Internal bank account use import ce_bank_pub.create_bank_acct_use fails CE_API_CASH_CCID_REQUIRED
 Issue 11: Legal_Entity_Id is NULL in ce_bank_acct_uses_all table for upgraded bank account
 (7). FAQ
References

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