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.