السلام عليكم ورحمة الله
ممكن حد من اخواني الكرام يساعدني في ايجاد API لتعديل بيانات العملاء لكثرة العملاء المسجلين على النظام
مع شرح مبسط لاجزاء ال API
وجزاكم الله خيرا

السلام عليكم ورحمة الله
ممكن حد من اخواني الكرام يساعدني في ايجاد API لتعديل بيانات العملاء لكثرة العملاء المسجلين على النظام
مع شرح مبسط لاجزاء ال API
وجزاكم الله خيرا

Customer API
Trading Community Architecture (TCA) is an architecture concept designed to support complex

trading communities. These APIs utilize the new TCA model, inserting directly to the HZ tables

.

API Details:

• 
  Set the organization id
  Exec dbms_application_info.set_client_info(’204′);
• 
  Create a party and an account
  HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT()
  HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE
  HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
  HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
• 
  Create a physical location
  HZ_LOCATION_V2PUB.CREATE_LOCATION()
  HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
• 
  Create a party site using party_id you get from step 2 and location_id from step 3.
  HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE()
  HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE
• 
  Create an account site using account_id you get from step 2 and party_site_id from step 4.
  HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE()
  HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE
• 
  Create an account site use using cust_acct_site_id you get from step 5 ans site_use_code = ‘BILL_TO’.
  HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE()
  HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE
  HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
  

Base table:

HZ_PARTIES

HZ_PARTY_SITES

HZ_LOCATIONS

HZ_CUST_ACCOUNTS

HZ_CUST_SITE_USES_ALL

HZ_CUST_ACCT_SITES_ALL

HZ_PARTY_SITE_USES

Validations:

Check if legacy values fetched are valid.

Check if customer address site is already created.

Check if customer site use is already created.

Check is customer header is already created.

Check whether the ship_to_site has associated bill_to_site

Check whether associated bill_to_site is created or not.

Profile amounts validation:

Validate cust_account_id, validate customer status.

Check if the location already exists in HZ_LOCATIONS. If does not exist, create new location.

المصدر :

http://erpschools.com/articles/interfaces-and-conversions

For detailed explanation refer to the below article:

http://www.erpschools.com/Apps/oracle-applications/articles/financials/Receivables/Customer-TCA-Architecture-and-API/index.aspx

والله المستعان

هااااااااااااااااااااااااااااااااااااااام
لو ممكن حد عنده شرح لطريقه رفع البيانات بإستخدام API
بس تكون بالتفصيل الممل