Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

TCA : Party Purge API

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

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

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.

dgreybarrow Usage

  1.  
  2.  
  3. <p>Parameters<br />
  4. p_init_msg_list IN VARCHAR:=FND_API.G_FALSE,<br />
  5. x_return_status OUT VARCHAR2,<br />
  6. x_msg_count OUT VARCHAR2,<br />
  7. x_msg_date OUT VARCHAR2,<br />
  8. p_party_id NUMBER</p>
  9.  

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.

Related Posts

Posted in Oracle TCA | No Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.