Thursday, October 21, 2010

Creating Customer Information using Java APIs

There are standard PL/SQL TCA APIs that can be used to create customer information as per following notes on metalink.oracle. or support.oracle.com


Using TCA API’s Including Examples [ID 201243.1]

How To Create A Customer Via TCA API [ID 159393.1]

Different uses of TCA API. [ID 230753.1]

How to create a cust_account via TCA API to an existing PARTY (PERSON Customer)? [ID 204545.1]


However when it comes to using Java APIs, there is no documentation on how to use them or where to find them.


Here’s a list of Java APIs that we have created to create Locations, Account and other related data that’s required when one queries for information in Customer Standard form.


Create Account :

HzCustAccountV2Pub.CustAccountRec : Model class for an Account, required by HzCustAccountV2Pub.createCustAccount

HzCustomerProfileV2Pub.CustomerProfileRec : Model class for customer profile. Required by HzCustAccountV2Pub.createCustAccount

HzCustAccountV2Pub.createCustAccount : Creates an Account. This API creates both Party and Account in Oracle.

HzCustAccountV2Pub.getCustAccountRec : Loads HzCustomerProfileV2Pub.CustomerProfileRec and HzCustAccountV2Pub.CustAccountRec objects based on account_id passed to the function.

HzLocationV2Pub.LocationRec : Model class for a Location, required by HzLocationV2Pub.createLocation.

HzLocationV2Pub.createLocation : Creates a Location in Oracle, represented by HzLocationV2Pub.LocationRec

HzPartySiteV2Pub.PartySiteRec: Model class for party site, required by HzPartySiteV2Pub.createPartySite. This links a Party and a Location.

HzPartySiteV2Pub.createPartySite : Creates party site represented by HzPartySiteV2Pub.PartySiteRec

HzCustAccountSiteV2Pub.CustAcctSiteRec : Model class for account site, required by HzCustAccountSiteV2Pub.createCustAcctSite. This links a party site and an account.

HzCustAccountSiteV2Pub.CustSiteUseRec: Model class foran account site use. This record has property for use_code. This allows to create bill to and ship to account site use. For, ship_to account site use we can specify bill_to account site use ID.

HzCustAccountSiteV2Pub.createCustSiteUse: Creates an account site use record in oracle represented by HzCustAccountSiteV2Pub.CustSiteUseRec.


Update Account:

HzPartyV2Pub.PersonRec : Model class for person.

HzPartyV2Pub.PartyRec : Model class for a party. Required by HzPartyV2Pub.PersonRec.

HzPartyV2Pub.updatePerson : Updates party of type person represented by HzPartyV2Pub.PersonRec.

HzLocationV2Pub.LocationRec : Model class for a location.

HzLocationV2Pub.updateLocation : Update a location, represented by HzLocationV2Pub.LocationRec.


Load:

HzLocationV2Pub.LocationRec : Model class for a location.

HzLocationV2Pub.getLocationRec : Loads a location in HzLocationV2Pub.LocationRec object.

HzCustAccountV2Pub.CustAccountRec : Model class for an Account, required by HzCustAccountV2Pub.createCustAccount

HzCustomerProfileV2Pub.CustomerProfileRec : Model class for customer profile. Required by HzCustAccountV2Pub.createCustAccount

HzCustAccountV2Pub.getCustAccountRec : Loads HzCustomerProfileV2Pub.CustomerProfileRec and HzCustAccountV2Pub.CustAccountRec objects based on account_id passed to the function

No comments:

Post a Comment