Description of Problem:
Company Name field on the "Create a Corporate Account" page is not a required
field. This *should* be a required field and should be indicated as such with
an "*" asterisk - similar to First Name and Last Name fields.
We are running into issues on this end with OAI due to the following:
PIN_CUSTOMER_NAME: RICHARD CRANDALL
) was not written to the database.
java.sql.SQLException: ORA-01400: cannot insert NULL into
ORA-06512: at "APPS.XXRH_OAI", line 1547
ORA-06512: at "APPS.XXRH_OAI_CUSTOMER", line 349
So....we've had to create a work around to get these particular types of entries
Steps to Reproduce:
1. Go to link listed above.
2. Enter all required information (fields with asterisk). Do not enter anything
for the Company Name field.
3. Hit "Create Login"
Completes login creation with completed Company Name field. Customer name in
Oracle ends up being "Valued Customer". This will create many duplicate entries
in Oracle. Need to clean up before upgrade to 11i.
Should be a required field. Should not complete login creation without it.
Changes for the bug are in head, and aligned to the 2/19/03 release.
Looks good on the RHN side, but www still allows corporate account creation with
a blank field. Do we care?
Over to Lisa to adjudicate.
Looks great on webdev (hope that's where I was supposed to test). Just
double-checked www as well.....interesting. I think it should be handled the
same on www, but I can work with the web guys to get that done. You can close
this bug if you like....(not sure if you guys keep track of who closes/resolves,
so I'll let you guys take credit)
Works on dev and QA, closing.