R12/CE: Country And Home_Country NULL in HZ_Parties For Newly Created Bank Branches
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms