Customer conversion

Customer conversion, AskHareesh.blogspot.com

Customer conversion

Customer Interface helps you create customers in Oracle Applications.

Interface tables:
  • RA_CUSTOMERS_INTERFACE_ALL
  • RA_CUSTOMER_PROFILES_INT_ALL
  • RA_CONTACT_PHONES_INT_ALL
  • RA_CUSTOMER_BANKS_INT_ALL
  • RA_CUST_PAY_METHOD_INT_ALL
Base tables:
  • RA_CUSTOMERS
  • RA_ADDRESSES_ALL
  • RA_CUSTOMER_RELATIONSHIPS_ALL
  • RA_SITE_USES_ALL
Concurrent program:
  • Customer Interface
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.
Important Columns:
Some important columns that need to be populated in the interface tables:
RA_CUSTOMERS_INTERFACE_ALL:
  • ORIG_SYSTEM_CUSTOMER_REF
  • SITE_USE_CODE
  • ORIG_SYSTEM_ADDRESS_REF
  • INSERT_UPDATE_FLAG (I = Insert, U = Update)
  • CUSTOMER_NAME
  • CUSTOMER_NUMBER
  • CUSTOMER_STATUS
  • PRIMARY_SITE_USE_FLAG
  • LOCATION
  • ADDRESS1
  • ADDRESS2
  • ADDRESS3
  • ADDRESS4
  • CITY
  • STATE
  • PROVINCE
  • COUNTY
  • POSTAL_CODE
  • COUNTRY
  • CUSTOMER_ATTRIBUTE1
  • CUSTOMER_ATTRIBUTE2
  • CUSTOMER_ATTRIBUTE3
  • CUSTOMER_ATTRIBUTE4
  • CUSTOMER_ATTRIBUTE5
  • LAST_UPDATED_BY
  • LAST_UPDATE_DATE
  • CREATED_BY
  • CREATION_DATE
  • ORG_ID
  • CUSTOMER_NAME_PHONETIC
RA_CUSTOMER_PROFILES_INT_ALL:
  • INSERT_UPDATE_FLAG
  • ORIG_SYSTEM_CUSTOMER_REF
  • ORIG_SYSTEM_ADDRESS_REF
  • CUSTOMER_PROFILE_CLASS_NAME
  • CREDIT_HOLD
  • LAST_UPDATED_BY
  • LAST_UPDATE_DATE
  • CREATION_DATE
  • CREATED_BY
  • ORG_ID
RA_CONTACT_PHONES_INT_ALL:
  • ORIG_SYSTEM_CONTACT_REF
  • ORIG_SYSTEM_TELEPHONE_REF
  • ORIG_SYSTEM_CUSTOMER_REF
  • ORIG_SYSTEM_ADDRESS_REF
  • INSERT_UPDATE_FLAG
  • CONTACT_FIRST_NAME
  • CONTACT_LAST_NAME
  • CONTACT_TITLE
  • CONTACT_JOB_TITLE
  • TELEPHONE
  • TELEPHONE_EXTENSION
  • TELEPHONE_TYPE
  • TELEPHONE_AREA_CODE
  • LAST_UPDATE_DATE
  • LAST_UPDATED_BY
  • LAST_UPDATE_LOGIN
  • CREATION_DATE
  • CREATED_BY
  • EMAIL_ADDRESS
  • ORG_ID


*/