Friday, September 7, 2012
Customer Conversion: Loading Customer Data - Flowchart/API's
Loading
Customer Account Data:
There are lot of customer account related entities
like customer accounts, customer account sites, customer account site uses,
customer profiles, customer profile amounts etc. Here we have tried describe
the methodology to load different customer account related entites via oracle
standard API’s.
Flowchart:
Oracle Standard API’s for each step:
|
Step
|
Oracle Standard API
|
|
Load customer accounts
|
HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT
|
|
Load customer account bill to sites
|
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE
|
|
Load customer account ship-to sites
|
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE
|
|
Load customer account bill-to site uses
|
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE
|
|
Load customer account ship-to site uses
|
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE
|
|
Load customer profiles
|
HZ_CUSTOMER_PROFILE_V2PUB.CREATE_CUSTOMER_PROFILE
|
|
Load customer account profile amounts
|
HZ_CUSTOMER_PROFILE_V2PUB.CREATE_CUST_PROFILE_AMT
|
|
Load customer account roles
|
HZ_CUST_ACCOUNT_ROLE_V2PUB.CREATE_CUST_ACCOUNT_ROLE
|
|
Load customer account role responsibilities
|
HZ_CUST_ACCOUNT_ROLE_V2PUB.CREATE_ROLE_RESPONSIBILITY
|
|
Load customer account payment methods
|
HZ_PAYMENT_METHOD_PUB.CREATE_PAYMENT_METHOD
|
|
Load customer account relations
|
HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCT_RELATE
|
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “Customer Conversion: Loading Customer Data - Flowchart/API's”
Post a Comment