My Oracle Support Banner

Customer Interface Program throws "The customer reference specified does not exist in the HZ_CUST_ACCOUNTS table or the RA_CUSTOMERS_INTERFACE table. The customer reference could also be in error in the RA_CUSTOMERS_INTERFACE table" error (Doc ID 2773092.1)

Last updated on MAY 11, 2021

Applies to:

Oracle Trading Community - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

Customer Interface program when run for multiple accounts and sites throws below error.

The customer reference specified does not exist in the HZ_CUST_ACCOUNTS table or the RA_CUSTOMERS_INTERFACE table.  The customer reference could also be in error in the RA_CUSTOMERS_INTERFACE table

Steps to Reproduce:

1. Insert Data into interface tables ra_customers_interface_all and ra_customer_profiles_int_all
2. Responsibility: Receivables Manager
    Navigation: Control > Request > Run

 Run Customer Interface Program

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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