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?
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.
Click Here to Expand Forum to Full Width