Customer Interface Issue: Bank Account is Incorrectly Assigned to Non-Bill-To Site Use When One Site has Multiple Usages (Doc ID 837136.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version 12.0.5 and later
Information in this document applies to any platform.
*** Checked for relevance 16-Oct-2013 ***


Symptoms

When running Customer Interface (RACUST) for loading customer bank ,the bank account is assigned to any site_use and instead of the bill-to site use, therefore the bank account is not seen on the screen.

The problem is that RACUST program does not assign the bank to the bill-to site, because it takes any site it retrieves first, that's why sometimes it is correctly assigned to the bill-to, sometimes to the sold-to or ship-to. If it is assigned to the sold-to or ship-to, there is no error in the interface program, but you don't see a bank account assignment in the screen, because it is wrongly assigned. In the ra_customer_banks_int_all you do reference the orig_system_address_ref, but there is no possibility to choose the site_use, this should be handled by the program itself.

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