Search Results ahl_di_requested_by_party

Overview

APPS.AHL_PARTY_MERGE_PKG is a PL/SQL package in the Oracle E-Business Suite Advanced Service (Advanced Service Online) module that performs party merge processing for duplicate trading parties and contacts. The package is declared AUTHID CURRENT_USER and was authored to consolidate references to a duplicate party into a single surviving party record across the Advanced Service tables. The header comments state the package purpose as merging duplicate parties in Advanced Service Online tables, and the entity list explicitly identifies the tables that must be considered during a party merge operation: AHL_DOCUMENTS_B, AHL_SUPPLIER_DOCUMENTS, AHL_RECIPIENT_DOCUMENTS, AHL_SUBSCRIPTIONS_B, AHL_DOC_REVISIONS_B, AHL_DOC_REVISION_COPIES, AHL_OPERATIONS_B, AHL_OPERATIONS_H_B, AHL_ROUTES_B, and AHL_ROUTES_H_B. Because the package is registered with the Trading Community Architecture (TCA) party merge framework, it is invoked as part of the standard Oracle Customers Online / HZ_MERGE_BATCH driven party merge process rather than being called directly by end users.

Key Procedures and Functions

The package exposes twelve documented procedures, each conforming to the standard party merge handler signature (entity name, from ID, to ID, foreign key IDs, parent entity name, batch identifiers, and a return status). The procedures are organized by the entity they reconcile:

• AHL_DI_SOURCE_PARTY — merges the source party reference on documents and related source entities.
• AHL_DI_SUPPLIER — merges supplier party references on supplier document records.
• AHL_DI_RECIPIENT_PARTY — merges recipient party references on recipient document records.
• AHL_DI_REQUESTED_BY_PARTY — merges the requested-by party on documents.
• AHL_DI_SUBSCRIBED_FRM_PARTY — merges the subscribed-from party on subscription records.
• AHL_DI_APPROVED_BY_PARTY — merges the approved-by party reference.
• AHL_DI_RECEIVED_BY_PARTY — merges the received-by party reference.
• AHL_RM_OPER_OPERATOR_PARTY — merges the operator party on operation records (relationships/route management).
• AHL_RM_OPER_H_OPERATOR_PARTY — merges the operator party on operation history records; this is the procedure most closely associated with the search term ahl_rm_oper_h_operator_party, as it resolves the operator party on AHL_OPERATIONS_H_B.
• AHL_RM_ROUTE_OPERATOR_PARTY — merges the operator party on route records.
• AHL_RM_ROUTE_H_OPERATOR_PARTY — merges the operator party on route history records.
• AHL_OSP_CUSTOMER — reconciles the customer party for On-Site Purchasing (OSP) order records.

Tables Accessed

The documented tables accessed through APPS synonyms include AHL_DOCUMENTS_B and AHL_DOC_REVISIONS_B (source, requested-by, approved-by, and received-by party references on documents and revisions), AHL_DOC_REVISION_COPIES (copied revision party references), AHL_SUPPLIER_DOCUMENTS and AHL_RECIPIENT_DOCUMENTS (supplier and recipient party references), AHL_SUBSCRIPTIONS_B (subscribed-from party), AHL_ROUTES_B (route operator party), AHL_OSP_ORDERS_B (OSP customer party), and HZ_MERGE_BATCH (the TCA merge batch driving the operation). The history comments note the addition of relationship-management (RM) entities on 12-20-2001 and the commenting out of an operation party ID following route enhancements, which aligns with the separate operator-party routines now handling AHL_OPERATIONS_H_B.

Usage Notes

This package is invoked by the TCA party merge framework during execution of the Party Merge concurrent program. It is not typically called directly from forms or custom code; instead it is registered as a handler against bug #1539248's party merge registration details, so the framework calls each procedure as it encounters the corresponding entity during a merge batch. Developers troubleshooting post-merge data inconsistencies between duplicate parties in Advanced Service should verify that a merge batch completed successfully and inspect AHL_OPE_RATIONS_H_B and AHL_ROUTES_B/H tables for references to the obsolete (from) party.