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