QA Collection Element Upload creates, updates and deletes Oracle Quality collection elements from Excel – the user-defined data characteristics (name, datatype, prompt, default value, decimal precision, UOM, validation and sequence configuration) that quality plans collect against.
When to use it
- Mass-create many new quality collection elements at once instead of one at a time in the Quality Elements form.
- Standardize collection elements across organizations by uploading a consistent set.
- Bulk-update prompts, default values, mandatory/enabled flags, UOMs, hints or validation strings on existing elements.
- Configure sequence-type elements (prefix/suffix/start/increment/length/zero-pad) consistently.
- Clean up obsolete elements no longer used on any plan.
- Migrate a defined element library between environments.
Before you start
- Blitz Report is installed and you are signed in to a responsibility that can maintain Oracle Quality collection elements.
- Element types, datatypes and units of measure already exist (selected from dropdowns).
- To delete an element, it must not be assigned to any collection plan.
Step 1 – Choose a mode, set the parameters and download
In Blitz Report, open QA Collection Element Upload, choose an Upload Mode (Create for an empty template, or Create, Update to download existing elements to edit), and optionally set the Collection Element From/To range. Run the upload to download and open the Excel file. Each element is automatically handled as a create or an update depending on whether the name already exists.
Step 2 – Enter the elements
On each row enter the Name, the Element Type and the Datatype, set Mandatory and Enabled, and fill the Prompt, Default Value, Decimal Precision (for Number), UOM Code and any sequence configuration as needed.
Step 3 – Delete elements (optional)
To remove an element, set Delete Record to Yes on its row. It is deleted only if it is not assigned to any collection plan.
Step 4 – Validate and Save
Click Validate and Save. This checks for missing required values and runs the upload’s validation, then saves the file. Correct anything it flags before continuing.
Step 5 – Upload and view the result
Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which creates, updates or deletes each element. When it finishes, a result report opens showing each row as success or error.
What’s produced
- Created, updated or deleted collection elements.
- A result report listing every row with a status (success or error) and a message.
Common questions
Can I change an element’s datatype after it’s created?
No. Datatype is fixed at creation; the upload rejects any attempt to change it. Create a new element instead.
Why can’t I delete an element?
Because it is still assigned to one or more collection plans. Remove it from every plan first, then delete it.
What happens to the prompt if I leave it blank on a new element?
It defaults to the element Name.
When is Decimal Precision required?
Only for Number datatype elements.
Does this upload manage the element’s allowed values, spec limits or actions?
No. Value lists, specification limits and actions are not handled by this upload (though deleting an element does clear its value list and element-level triggers).
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| Cannot change datatype for existing element | The row’s Datatype differs from the stored datatype. | Restore the original datatype, or create a new element with a different name. |
| Cannot delete – element is assigned to collection plans | The element is still used on at least one plan. | Remove it from all collection plans, then re-run the delete. |
| A collection element with a similar name already exists | Creating a new element whose name matches an existing one. | Choose a distinct name, or switch to Create, Update mode to update the existing element. |
| Decimal Precision is required for Number datatype | A Number row left Decimal Precision blank. | Enter a Decimal Precision value. |
| Name contains special characters / is a reserved name | The element name uses disallowed characters or a reserved word. | Use a plain name without special characters and avoid reserved words. |