Customer Data Management >> Data Import >> Purge - Not Deleting Records In RA_CUSTOMER_BANKS_INT_ALL, RA_CUST_PAY_METHOD_INT_ALL, RA_CUSTOMER_PROFILES_INT_ALL (Doc ID 2115548.1)

Last updated on AUGUST 13, 2017

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Customer Data

AR Customer Import Purge not deleting associated batch records

After purging the customer data via the Data Import Batches screen, it does not delete any of the associated batch records in the following tables:
 
RA_CUSTOMER_BANKS_INT_ALL
RA_CUST_PAY_METHOD_INT_ALL
RA_CUSTOMER_PROFILES_INT_ALL
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Application

2. Navigate to Customer Data Management >> Data Import

3. Purge any of the existing batch which has date in RA_CUSTOMER_BANKS_INT_ALL, RA_CUST_PAY_METHOD_INT_ALL, RA_CUSTOMER_PROFILES_INT_ALL

4. The data in tables RA_CUSTOMER_BANKS_INT_ALL, RA_CUST_PAY_METHOD_INT_ALL and RA_CUSTOMER_PROFILES_INT_ALL is not deleted
 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue un-wanted data is sitting in tables

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