1 Reply Latest reply: Jun 5, 2012 10:57 AM by Hussein Sawwan-Oracle RSS

    Customer Interface

    923413
      HI

      i'm using Oracle EBS Release 1, and been trying to insert customer into 'RA_CUSTOMERS_INTERFACE and ra_customer_profiles_interface' but when i run customer interface request it show exception error message:

      Customer Reference Address Reference Site Use Error Message
      --------------------------- --------------------------- ----------- ----------------------------------------------------------------
      INT-11 INT-22 DELIVER_TO
      Customer record for insert must have validated profile record de
      fined in the RA_CUSTOMER_PROFILES_INTERFACE table.



      Customer Reference Address Reference Currency Error Message
      --------------------------- --------------------------- ----------- ----------------------------------------------------------------
      INT-11 INT-22 USD
      The specified address either has an inactive bill-to, dunning, o
      r statements site defined, or has errors in the RA_CUSTOMERS_INT
      ERFACE table.

      Customer record for insert must have validated profile record de
      fined in the RA_CUSTOMER_PROFILES_INTERFACE table.



      INSERT INTO apps.RA_CUSTOMERS_INTERFACE
      (
      orig_system_customer_ref
      ,site_use_code
      ,orig_system_address_ref
      ,insert_update_flag
      ,customer_name
      ,customer_number
      ,customer_status
      ,primary_site_use_flag
      ,address1
      --,address2
      --,postal_code
      --,city
      ,state
      ,country
      ,last_updated_by
      ,last_update_date
      ,created_by
      ,creation_date
      --,customer_name_phonetic
      ,PERSON_FLAG
      ,org_id
      ,customer_category_code
      ,location
      --,bill_to_orig_address_ref
      )
      VALUES
      (
      1520011
      ,'SOLD_TO'
      ,'NEW007-ADD001'
      ,'I'
      ,'newSSSS ZAG'
      ,1520011
      ,'A'
      ,'Y'
      ,'YANKEEZSSSS ROAD'
      --,'ASDASF2334'
      --,'ds5555'
      --,'New York'
      ,'NY'
      ,'US'
      ,1318
      ,sysdate
      ,1318
      ,sysdate
      --,'new int'
      ,'N'
      ,7902
      ,'FOOD'
      ,'N. YORKERSSSSS LOC'
      --,'YANKEEZSS ROAD, NY'
      )

      Select
      *
      from
      APPS.AR_SITE_USES_V

      SELECT * FROM APPS.AR_LOCATION_VALUES

      insert into apps.ra_customer_profiles_interface
      (orig_system_customer_ref
      --,orig_system_address_ref
      ,insert_update_flag
      ,credit_hold
      ,last_updated_by
      ,last_update_date
      ,created_by
      ,creation_date
      ,org_id
      ,customer_profile_class_name
      ,CURRENCY_CODE
      )
      values
      (
      1520011
      --,'CUST0002-ADD0002'
      ,'I'
      ,'N'
      ,1318
      ,sysdate
      ,1318
      ,sysdate
      ,7902
      ,'INTERNAL'
      ,'USD'
      )

      usually the interface_status shows error code A1, B3 and S7
      its been few days i been trying to solve it, please assist me.

      Thank you
      Yaser
        • 1. Re: Customer Interface
          Hussein Sawwan-Oracle
          Please post the details of the application release, database version and OS.

          Please see these docs.

          CUSTOMER INTERFACE STATUS ERROR CODES [ID 1073634.6]
          Why do we get 'ORA-28115: policy with check option violation' Error while inserting records in Customer Interface tables? [ID 869370.1]
          Customer Interface: Error Messages and the Meanings [ID 1460677.1]
          Customer Interface Ends with Error: Customer Record For Insert Must Have Validated Profile Record Defined In The RA_CUSTOMER_PROFILES_INTERFACE table. [ID 566779.1]
          customer record for insert must have validated profile record defined [ID 140833.1]
          Interfacing Customer Ship-To To An Existing Customer Bill-To Gets Error: Customer Record For Insert Must Have Validated Profile Record Defined In The Ra_customer_profiles_interface Table [ID 267188.1]
          Customer Interface Exception: "Customer record for insert must have validated profile record defined in the RA_CUSTOMER_PROFILES_INTERFACE table" [ID 1319755.1]

          Thanks,
          Hussein