My Oracle Support Banner

No Rows in HZ_MATCHED_PARTIES_GT after successful call to the Hz_party_search.Find_parties (Doc ID 1387441.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for Relevance 11-Jun-2013***

Symptoms

In 11.5.10.2, the table HZ_MATCHED_PARTIES_GT does not have any matched rows even after the successful call to the Hz_party_search.Find_parties.

Steps to reproduce:

1. Run the following TCA API Hz_party_search.Find_parties:

/* Formatted on Nov/15/2011 11:06:58 AM (QP5 v5.163.1008.3004) */

DECLARE
L_rule_id NUMBER;
L_party_search_rec Apps.Hz_party_search.Party_search_rec_type;
L_party_site_list Apps.Hz_party_search.Party_site_list;
L_contact_list Apps.Hz_party_search.Contact_list;
L_contact_point_list Apps.Hz_party_search.Contact_point_list;
L_restrict_sql VARCHAR2 (2000);
L_match_type VARCHAR2 (2000);
L_search_merged VARCHAR2 (2000);

X_search_ctx_id NUMBER;
X_num_matches NUMBER;
X_return_status VARCHAR2 (2000);
X_msg_count NUMBER;
X_msg_data VARCHAR2 (2000);
BEGIN
Fnd_global.Apps_initialize (11919, 50191, 222);

-- Fnd_msg_pub.Initialize;
-- Fnd_msg_pub.Reset;

L_party_search_rec.Party_name := 'KEVIN BAILY';
L_party_search_rec.Party_type := 'Person';
L_party_site_list (1).Postal_code := '897021735';
--l_party_search_rec.category_code := 'OTHER';
L_match_type := 'AND';
L_search_merged := 'N';
Apps.Hz_party_search.Find_parties (Fnd_api.G_true, -- change to G_TRUE during testing
34, --l_rule_id from apps.HZ_MATCH_RULES_VL
L_party_search_rec,
L_party_site_list,
L_contact_list,
L_contact_point_list,
L_restrict_sql,
L_match_type, -- AND/OR
L_search_merged, -- Y/N/A/I
X_search_ctx_id,
X_num_matches,
X_return_status,
X_msg_count,
X_msg_data);
DBMS_OUTPUT.Put_line ('Search_ctx_id: ' || X_search_ctx_id);
DBMS_OUTPUT.Put_line ('Total Results: ' || X_num_matches);
DBMS_OUTPUT.Put_line ('Return status: ' || X_return_status);

DBMS_OUTPUT.Put_line ('Error Total: ' || X_msg_count);
DBMS_OUTPUT.Put_line ('Error Message: ' || X_msg_data);

IF X_msg_count > 1 THEN
FOR I IN 1 .. X_msg_count LOOP
DBMS_OUTPUT.Put_line (
I
|| '.'
|| SUBSTR (Fnd_msg_pub.Get (P_encoded => Fnd_api.G_false), 1, 255));
END LOOP;
END IF;
END;

/*
commit

 
*/

2. Output of the script showing:

Search_ctx_id: 10040
Total Results: 1
Return status: S
Error Total: 0
Error Message:

3. Then perform the following query on the table HZ_MATCHED_PARTIES_GT. It is empty.

select * from HZ_MATCHED_PARTIES_GT
--where search_context_id = 10024

 

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
Cause
Solution
 Still Have Questions?


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