OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Error creating customer- 'AR_NO_ROW_IN_SYSTEM

Home » Applications » Oracle Fusion Apps & E-Business Suite » Error creating customer- 'AR_NO_ROW_IN_SYSTEM_PARAMETERS'

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error creating customer- 'AR_NO_ROW_IN_SYSTEM_PARAMETERS' [message #178135]

Mon, 19 June 2006 09:35

frankel
Messages: 16
Registered: September 2005

Junior Member

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.

[Updated on: Mon, 19 June 2006 09:41]

Report message to a moderator