1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle Receivables -No customer site use was found for ID xxx -- OAF R12

Discussion in 'Oracle Financials' started by miklagaard, May 6, 2013.

  1. miklagaard

    miklagaard Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi everyone,

    I was having a problem in oracle receivables. When I navigate to AR-->Customer-->Customer -->querry a customer -->adress details -->business purposes ı get the error;
    No account site use for ıd xxx. I get this error for random customer not spesific customer(maybe they are specific due to the problem ı do not know)

    The problem occurs from time to time and disappears by itself,

    I do not face the problem right now ,but ı have to know what causes it. The customer wants answers about it,and ı have nothing.I searched it on google and metalink ı couldnot find anything. There is a issue on metalink like this but it occurs when trying to update costumer details by API.

    What can cause this error, at least ı need to lower the possibilites.

    Thanks for your help

    Serkan
     
  2. ac.arijit

    ac.arijit Forum Advisor

    Messages:
    217
    Likes Received:
    22
    Trophy Points:
    280
    Location:
    Kolkata, India
    Hi Serkan,

    Plz confirm whether the problematic customers have any customer a/c defined for 'em or not.
     
  3. miklagaard

    miklagaard Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Ari,thanks for your reply


    Yes,they are defined , when ı querry for one of my problematic customers from toad; there are two data lines with CUST_ACCT_SITE_ID=our specific customer account site ıd(XXX in title) ;

    one for site use code=bill_to creation date 11:42:36 and
    one for site use code=ship_to creation date 12:17:41

    and ı get error when time is 12:06:xx
    Could these someway be related?

    When we do not define shipping site,could oracle give me this error?


    thanks for your help

    Serkan
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    No, defining shipping sites for customer is not mandatory setup..
     
  5. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Serkan,

    Is your problem solved ?