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

Last updated on MAY 15, 2017

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.

Symptoms

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.

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