Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Friday, December 21, 2012

AR Customer Interface R12




The Customer Interface Data flows to Receivables as shown in the above figure.

To import the Customer information, following Interface Tables have to be populated with mentioned Mandatory columns.

RA_CUSTOMERS_INTERFACE

To import a customer, address, or business purpose, populate the following mandatory columns of RA_CUSTOMERS_INTERFACE:
    • ORIG_SYSTEM_CUSTOMER_REF
    • INSERT_UPDATE_FLAG
    • CUSTOMER_NAME
    • CUSTOMER_NUMBER (if you are not using Automatic Customer Numbering)
    • CUSTOMER_STATUS
    • LAST_UPDATED_BY
    • LAST_UPDATE_DATE
    • CREATED_BY
    • CREATION_DATE
If you are importing an address and a business purpose, you must also populate the following tables:
    • PRIMARY_SITE_USE_FLAG (if you are inserting an address)
    • LOCATION (if you are not using Automatic Site Numbering)
    • SITE_USE_CODE (if you are inserting an address)
    • ADDRESS1
Receivable requires that you separate your city, state, and postal codes, whereas your current system may not. To save time, separate these components in your current system before importing customers into Receivables.
    • ORIG_SYSTEM_ADDRESS_REF
You must enter values for the columns you reference in your Tax Location Flexfield if you are calculating sales tax and your Address Validation option is set to 'Error.' (You define this option in the System Options window, Tax alternative region.)
    • COUNTRY

RA_CUSTOMER_PROFILES_INTERFACE

A customer level profile must exist in RA_CUSTOMER_PROFILES_INTERFACE for new customers and each Bill-To Business Purpose.
    • ORIG_SYSTEM_CUSTOMER_REF
    • INSERT_UPDATE_FLAG
    • CUSTOMER_PROFILE_CLASS_NAME
If you did not pass a value in this column, you must enter values in the following columns:
      • COLLECTOR_NAME
      • CREDIT_BALANCE_STATEMENTS
      • CREDIT_CHECKING
      • AUTO_REC_INCL_DISPUTED_FLAG
      • DISCOUNT_TERMS
      • DUNNING_LETTERS (if 'Y,' you must also enter a value in DUNNING_LETTER_SET_NAME)
      • INTEREST_CHARGES (if 'Y,' you must also enter values in INTEREST_PERIOD_DAYS and CHARGE_ON_FINANCE_CHARGE_FLAG
      • STATEMENTS (if 'Y,' you must also enter a value in STATEMENT_CYCLE_NAME)
      • TOLERANCE
      • TAX_PRINTING_OPTION
      • OVERRIDE_TERMS
      • GROUPING_RULE_NAME
    • CREDIT_HOLD
    • LAST_UPDATED_BY
    • LAST_UPDATE_DATE
    • CREATED_BY
    • CREATION_DATE
If you are entering a profile for a customer address, you must also enter a Bill-To site in ORIG_SYSTEM_ADDRESS_REF.

RA_CONTACT_PHONES_INTERFACE

To import telephone numbers for customers, addresses, and contacts, populate the following mandatory columns of RA_CONTACT_PHONES_INTERFACE:
    • ORIG_SYSTEM_CUSTOMER_REF
    • ORIG_SYSTEM_TELEPHONE_REF
    • INSERT_UPDATE_FLAG
    • TELEPHONE
    • TELEPHONE_TYPE
    • LAST_UPDATED_BY
    • LAST_UPDATE_DATE
    • CREATED_BY
    • CREATION_DATE
If you are entering a telephone number for an address, you must also enter a value in ORIG_SYSTEM_ADDRESS_REF.
If you are entering a telephone number for a contact, you must also enter a value in ORIG_SYSTEM_CONTACT_REF and CONTACT_LAST_NAME.
RA_CUSTOMER_BANKS_INTERFACE
To import banks for customers and Bill-To business purposes, use the above table.
RA_CUST_PAY_METHOD_INTERFACE
To import payment methods for customers and Bill-To business purposes, use the above table.



--->:====================================================================
--->: SAMPLE TECHNICAL INPUTS TO RUN THE CUSTOMER INTERFACE.
--->:====================================================================

TRUNCATE TABLE ar.ra_customers_interface_all;

INSERT INTO ar.ra_customers_interface_all
  (
    orig_system_customer_ref,
    customer_name,
    orig_system_address_ref,
    address1,
    address2,
    address3,
    address4,
    city,
    county,
    state,
    province,
    country,
    postal_code,
    site_use_code,
    primary_site_use_flag,
    customer_status,
    insert_update_flag,
    last_updated_by,
    last_update_date,
    created_by,
    creation_date,
    customer_number,
    customer_name_phonetic,
    customer_category_code,
    location,
    org_id
  )
  VALUES
  (
    '01-00-01',      --->: orig_system_reference
    'CUSTOMERNAME0', --->: customer_name
    '01-00-01',      --->: orig_system_address_ref, change it if you put another address
    'ADDRESS0',      --->: address1
    NULL,            --->: address2
    NULL,            --->: address3
    NULL,            --->: address4
    'San Mateo',     --->: city
    'San Mateo',     --->: county
    'CA',            --->: state
    NULL,            --->: provice
    'US',            --->: country
    '94401',         --->: postal_code
    'BILL_TO',       --->: SITE USE
    'Y',             --->: primary_site_use_flag
    'A',             --->: customer_staus
    'I',             --->: insert_update_flag
    -1,              --->: last_updated_by
    sysdate,         --->: last_update_date
    -1,              --->: created_by
    sysdate,         --->: creation_date
    NULL,            --->: customer_number if automatic customer number is no
    'CUSTOMERNAME0', --->: customer_name_phonetic
    'CUSTOMER',      --->: customer_category_code
    NULL,            --->: location if autositenumber is no
    204              --->: org_id
  );

--->:====================================================================
--->: INSERT THE CUSTOMER PROFILE INFORMATION
--->:====================================================================

TRUNCATE TABLE ar.ra_customer_profiles_int_all;

INSERT INTO ar.ra_customer_profiles_int_all
  (
    orig_system_customer_ref,
    insert_update_flag,
    customer_profile_class_name,
    credit_hold,
    last_updated_by,
    last_update_date,
    created_by,
    creation_date,
    org_id
  )
  VALUES
  (
    '01-00-01', --->: orig_system_customer_ref
    'I',        --->: insert_update_flag
    'DEFAULT',  --->: Should be valid profile class
    'N',        --->: This can be 'Y','N' not null.
    -1,         --->: last_updated_by
    sysdate,    --->: last_update_date
    -1,         --->: created_by
    sysdate,    --->: created_by
    204         --->: org_id
  );


--->:====================================================================
--->: INSERT THE CUSTOMER PHONES & CONTACT INFORMATION
--->:====================================================================
INSERT
INTO
  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_updated_by,
    last_update_date,
    created_by,
    creation_date,
    last_update_login,
    sex_code,
    salutation,
    email_address,
    mail_stop,
    contact_key,
    org_id,
    contact_job_title_code,
    contact_point_type
  )
  VALUES
  (
    '01-00-01',--->:orig_system_contact_ref,
    '01-00-01',--->:orig_system_telephone_ref,
    '01-00-01',--->:orig_system_customer_ref,
    '01-00-01',--->:orig_system_address_ref,
    'I',
    'CUSTOMERFirstNAME0', --->:contact_first_name,
    'CUSTOMERlastNAME0',  --->:contact_last_name,
    NULL,                 --->:contact_title,
    NULL,                 --->:contact_job_title,
    40986341,             --->:telephone,
    6341,                 --->:telephone_extension,
    Land line,            --->:telephone_type,
    91-80,                --->:telephone_area_code,
    fnd_global.user_id,
    SYSDATE,
    fnd_global.user_id,
    SYSDATE,
    fnd_global.login_id,
    Male,                    --->:sex_code,
    NULL,                    --->:salutation,
    Customername@company.com,--->:email_address,
    NULL,                    --->:mail_stop,
    NULL,                    --->:contact_key,
    v_org_id,
    Customer,    --->:contact_job_title_code,
    Email/Phone ,--->:contact_point_type
  );

 commit;

--->:====================================================================
--->: RUN CUSTOMER INTERFACE PROGRAM FROM THE APPLICATION.
--->:====================================================================
V_REQUEST_ID := APPS.FND_REQUEST.SUBMIT_REQUEST
                                            ( 'AR'
                                              , 'RACUST'
                                              , ''
                                              , ''
                                              , FALSE
                                              , P_CREATE_RECIPROCAL_FLAG
                                              , P_ORG_ID
                                              , CHR(0)--->: End of parameters
                                            );
--->:====================================================================
 
Customer Interface transfers customer data from the interface tables into the following tables:
    • AR_CUSTOMER_PROFILES
    • AR_CUSTOMER_PROFILE_AMOUNTS
    • RA_ADDRESSES
    • RA_CONTACTS
    • RA_CUSTOMERS
    • RA_CUSTOMER_RELATIONSHIPS
    • RA_CUST_RECEIPT_METHODS
    • RA_PHONES
    • RA_SITE_USES
    • AP_BANK_ACCOUNT_USES
    • AP_BANK_ACCOUNTS
    • AP_BANK_BRANCHES
The Customer Interface program will not allow updates to the following tables:
    • RA_SITE_USES
    • RA_CUSTOMER_RELATIONSHIPS
    • RA_CUST_RECEIPT_METHODS
    • AP_BANK_BRANCHES
    • AP_BANK_ACCOUNTS
    • AP_BANK_ACCOUNT_USES
Caution: The Customer Interface Transfer Report will not display errors for records attempting to update these tables; the records will simply not be processed.
 

6 comments:

sandeep24410 said...

Hey why are not allowing to copy your code to us.

Raju Chinthapatla said...

Please send a mail to OracleApps88@Yahoo.com

Sudhakarreddy Nalamalapu said...

we are not able to copy the code

sandeep24410 said...

Use poket apps it's use to use copy this code

Unknown said...

RA AND AR TABLES ARE NOT R12 TABLES.. WE HAVE TO CHECK TCA (HZ TABLES FOR FINAL) BASE TABLES.

MY STORRY said...

thanks

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect