My Oracle Support Banner

R12/CE: Country And Home_Country NULL in HZ_Parties For Newly Created Bank Branches (Doc ID 2266256.1)

Last updated on JULY 10, 2020

Applies to:

Oracle Cash Management - Version 12.0.0 to 12.2.6 [Release 12 to 12.2]
Information in this document applies to any platform.


Country and Home_Country is NULL/Blank in HZ_Parties for newly created Bank Branches in R12 (Created by Module = CE or CUST_INTERFACE).
For upgraded Bank Branches (Created by Module=CE_BANK_UPGRADE) , Country and Home_Country is populated in hz_parties HP.

Need to use and perform validations on Bank Branch Country in reports/programs, but we are not able to because the Bank Branch COUNTRY is NULL when we use standard view CE_BANK_BRANCHES_V.
This view is fetching COUNTRY column from HZ_Parties table for Bank Branch Party record.


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

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