R12 Web ADI: Errors With 'Required upload column was not in upload and no default value was generated' When Queue Name Is Left Blank (Doc ID 1062064.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Assets - Version 12.1.1 to 12.1.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms


When loading multiple lines from Web ADI, if the 'Queue Name' is left blank, there is an error:

'Required upload column was not in upload and no default value was generated'

for the odd rows such as 1, 3, 5 but it skips the 2, 4, 6 rows and uploads the dual rows to the prepare mass additions form. And the record which is loaded to the mass addition form errors with:

'APP-OFA-48289: Unknown error. Please contact your system administrator.'

and cannot be modified.

EXPECTED BEHAVIOR
-----------------------
Expect the second mass addition line to get the same error in Web ADI, to avoid creating the wrong record on the mass addition form.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create three assets CYTEST1, CYTEST2, CYTEST3 in additions integrator and leave queue name blank
2. Upload these three lines, system shows error "Required upload column was not in upload and no default value was generated" for line 1 and 3, but no error shows for line2.
3. Check prepare mass addition, find CYTEST2 has been successfully uploaded
4. Open mass addition form for CYTEST2, select any value for 'queue' field, error "APP-OFA-48289: Unknown error. Please contact your system administrator." and the value can't be saved.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms