PUBLIC API CE_BANK_PUB.CHECK_BANK_EXIST WON'T FIND NEWLY CREATED BANK (Doc ID 1299199.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Cash Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms


When using public API CE_BANK_PUB.check_bank_exists to migrate existing banks from 11i to R12, program creates duplicated banks because this procedure cannot find existing bank numbers.

Changes

The c_bank_num cursor in CE_BANK_PUB API uses hz_parties.country column to identify the home country of the bank.
So changing to The c_bank_num cursor is modified to use hz_organization_profiles.home_country column to identify the home country of the bank.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms