R12/AP: Supplier Bank Country Code Details Mismatch Between Application and Database (Doc ID 2820483.1)

Last updated on MARCH 23, 2023

Applies to:

Goal

There is a mismatch between the Supplier Bank Country Code details in the application and in database.

In this example,

The HOME_COUNTRY column in IBY_EXT_BANK_BRANCHES_V for the BRANCH_PARTY_ID=xxxxx  is null.
However, the COUNTRY_CODE for Branch_id xxxxx in  IBY_EXT_BANK_ACCOUNTS has a value.

The Supplier Bank Country Code details in the application show the value from IBY_EXT_BANK_ACCOUNTS.

How can you populate the correct value in IBY_EXT_BANK_BRANCHES_V?

Solution

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