Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Wednesday, March 13, 2013

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 customeraccounts
HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT
Load customeraccount bill to sites
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE
Load customeraccount ship-to sites
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE
Load customeraccount bill-to site uses
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE
Load customeraccount ship-to site uses
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE
Load customerprofiles
HZ_CUSTOMER_PROFILE_V2PUB.CREATE_CUSTOMER_PROFILE
Load customeraccount profile amounts
HZ_CUSTOMER_PROFILE_V2PUB.CREATE_CUST_PROFILE_AMT
Load customeraccount roles
HZ_CUST_ACCOUNT_ROLE_V2PUB.CREATE_CUST_ACCOUNT_ROLE
Load customeraccount role responsibilities
HZ_CUST_ACCOUNT_ROLE_V2PUB.CREATE_ROLE_RESPONSIBILITY
Load customeraccount paymentmethods
HZ_PAYMENT_METHOD_PUB.CREATE_PAYMENT_METHOD
Load customeraccount relations
HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCT_RELATE


Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)