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


1 Responses to “Customer Conversion: Loading Customer Data - Flowchart/API's”

Sridevi K said...
October 8, 2016 at 12:33 AM

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.