Collection Import Worker completes with Warning - Critical Error (Doc ID 816855.1)

Last updated on OCTOBER 10, 2016

Applies to:

Oracle Quality - Version 12.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 11-Jun-2014***


Symptoms

On 12.0.6 in Production:
When trying to update quality results Through the API. When running the Collection Import Manager,
the program ends with a Warning. The log files have no information. In the Collection Import
form - the records all have an Error = "Critical Error" but no other information
the following error occurs:

ERROR: Critical Error

The issue can be reproduced at will with the following steps:
1. Insert data into results API using Import View:

insert into q_rsta_fl_ncr_header_plan_iv (insert_type, nonconformance_number,
nonconformance_status, process_status, organization_code, plan_name)
values (2, 'NCR10060', 'CLOSED', 1, 'FLA', 'RSTA FL NCR HEADER PLAN');
commit;

2. Run the Collection Import program.

3. View log files and import results form


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