TCA : Party Purge API

Posted on January 30th, 2011 by Sanjit Anand | Print This Post | Email This Post

Looking for API which can delete desired party record completely.. use this API which can be used to Purge the Party Information from TCA Architecture.The name of the API is apps.hz_purge.purge_party.

Usage

 
 
<p>Parameters<br />
p_init_msg_list IN VARCHAR:=FND_API.G_FALSE,<br />
x_return_status OUT VARCHAR2,<br />
x_msg_count OUT VARCHAR2,<br />
x_msg_date OUT VARCHAR2,<br />
p_party_id NUMBER</p>
 

This API is removing the desired row from only two tables:

• hz_parties
• hz_party_sites

This API is not published by Oraclc for public use. You can check thIS post before using Oracle API's.

If you have Oracle Customers Online enabled , you can use seeded functionality to purge parties.

Navigation flow: --> Oracle Data Librarian Super User

• Data Quality
  • Purge Requests
    • Use Online purge if the request is to purge one party.

1. Its all about TCA API
2. Customer Interface Vs TCA API
3. Party Merge
4. TCA in EBS: Integration with HRMS
5. Oracle API Availability – Input/Output