My Oracle Support Banner

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 APRIL 03, 2019

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

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.