Search This Blog

Wednesday, April 3, 2013

Customer Conversion: Loading Party data flowchart and API details


Loading Party Data:

There are lot of party related entities like party, addresses, address uses, code assignments, org contacts etc. Here we have tried describe the methodology to load different party related entites via oracle standard API’s.

Flowchart:




Oracle Standard API’s for each step:

Step
Oracle Standard API
Load organization party
HZ_PARTY_V2PUB.CREATE_ORGANIZATION
Load person type party
HZ_PARTY_V2PUB.CREATE_PERSON
Load organization classifications
HZ_CLASSIFICATION_V2PUB.CREATE_CODE_ASSIGNMENT
Load locations
HZ_LOCATION_V2PUB.CREATE_LOCATION
Load party sites
HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE
Load party site uses
HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE
Load org contacts
HZ_PARTY_CONTACT_V2PUB.CREATE_ORG_CONTACT
Load org contact roles
HZ_PARTY_CONTACT_V2PUB.CREATE_ORG_CONTACT_ROLE
Load contact points
HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT

No comments:

Post a Comment