Receivables - EBS (MOSC)

MOSC Banner

Purge of HZ_%_M tables

in Receivables - EBS (MOSC) Question

Hello

I'm interested in purging the following tables that get populated during the customer account merge process:

HZ_CUSTOMER_PROFILES_M

HZ_CUST_ACCOUNTS_M

HZ_CUST_ACCOUNT_ROLES_M

HZ_CUST_ACCT_RELATE_ALL_M

HZ_CUST_ACCT_SITES_ALL_M

HZ_CUST_PROFILE_AMTS_M

HZ_CUST_SITE_USES_ALL_M

I've tried searching support and find barely a mention of these tables and nothing about purging. We have no use case for looking back at the details of previous merges (ie like that provided by HZ_EXTRACT_MERGE_EVENT_PKG generating HZ_ACCT_MERGE_OBJ objects) and I can find no other substantive references to this information via database dependencies.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Receivables Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center