Error creating customer- 'AR_NO_ROW_IN_SYSTEM_PARAMETERS'
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Error creating customer- 'AR_NO_ROW_IN_SYSTEM_PARAMETERS'

  1. #1
    Join Date
    Mar 2006
    Posts
    7

    Error creating customer- 'AR_NO_ROW_IN_SYSTEM_PARAMETERS'

    To create an employee as a customer in oracle, I call the API
    APPS.HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT()


    This API then calls HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_account()
    and it errors out without creating a customer.

    The error is on the sql statement

    SELECT GENERATE_CUSTOMER_NUMBER INTO l_profile
    FROM AR_SYSTEM_PARAMETERS;
    And the error is...'AR_NO_ROW_IN_SYSTEM_PARAMETERS'

    Why does this happen? my AR_SYSTEM_PARAMETERS table is empty...is this incorrect?

    I thought customer numbers were created via a sequence. Can anyone help?

    Thanks.

  2. #2
    Join Date
    Nov 2001
    Location
    The Netherlands
    Posts
    19
    Hi,

    you have to enter the AR system options, before you can enter customers. (If you run multi-org, you'll have to enter them for every OU).

    Go to /Receivables Manager/setup/system/system options
    and fill in all the required fields.

    Regards,

    Arian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width