My Oracle Support Banner

R12: UPGRADE Relationship Between the Bank And Bank Branch Errors “Please provide a valid parent bank for the bank branch” (Doc ID 1668348.1)

Last updated on AUGUST 11, 2023

Applies to:

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


The issue is regarding the relationship between the bank and bank branch. Two rows exist for the relationship in the table "hz_relationships" where the column 'relationship_code' contains values such as 'BRANCH_OF' and 'HAS_BRANCH'. In the first row where relationship_code is 'BRANCH_OF', subject is branch and object is bank. In the second row where relationship_code is 'HAS_BRANCH', subject is bank and object is branch. This table has two columns 'start_date' and 'end_date'. These values for a particular example are both dates in the past. When you removed the 'inactive_date' through the application front end, it still retained these dates in "hz_relationships" table. What is the significance of the "end_date" column in this table when the bank and branch are still related.


“Please provide a valid parent bank for the bank branch”.




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.