Error creating customer- 'AR_NO_ROW_IN_SYSTEM_PARAMETERS'
To create an employee as a customer in oracle, I call the API
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
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?