An Existing Batch Is Not Displayed In the Party Merge Form (Doc ID 2934403.1)

Last updated on MAY 20, 2024

Applies to:

Symptoms

A BATCH_NAME currently existing in the HZ_MERGE_PARTIES table can not be queried in the 'Party Merge Request' screen.

SCENARIO 1 - STEPS

1. The query below is executed,

        select T2.BATCH_NAME
        from HZ_MERGE_PARTIES  T1
        join HZ_MERGE_BATCH T2 on T1.batch_id = T2.batch_id
        where FROM_PARTY_ID = (
            select PARTY_ID
            from HZ_PARTIES
            where PARTY_NUMBER = '&from_party_number' ) --> when prompted the Registry Id of the from Party is entered
        and CREATED_BY_MODULE is NOT NULL;

2. Reported values for BATCH_NAME from the query are not displayed when following the steps below,

Responsibility: Receivables Manager
Navigation: Customers -> Party Merge Request
1. Query for Batch Name=BATCH_NAME coming from query executed in step 1
2. No results retrieved in the form

UNEXPECTED RESULT
No data displayed in the Party Merge form for a BATCH_NUMBER that exists in the HZ_MERGE_PARTIES table.

EXPECTED RESULT
All BATCH_NUMBER values from the HZ_MERGE_PARTIES table: should be displayed by the Party Merge form when queried.

SCENARIO 2 - STEPS

        Responsibility: Oracle Customers Online Data Librarian Superuser
        Navigation: DQM > Data Quality tab

1. Select Merge Requests sub tab
2. Create Request by Request Id
3. The ERROR below occurs
    You cannot select the party with Registry ID XXXX because it is already in Party Merge batch YYYYY.
4. In the same screen, a query is executed for Registry ID XXXX
5. No records reported even if Party Merge Batch YYYYY reported as preventing the creation of a new batch.

Changes

Cause

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