QA - Disposition Actions Are Not Launched From QA Disposition Collection Plan

(Doc ID 1665351.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Quality - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, QA disposition actions (WIP_MOVE_SCRAP) are not launched from QA disposition collection plan. Check Periodic Alert ends with the following error in log:
ERROR
-----------------------
ERROR at line 5:
ORA-01858: a non-numeric character was found where a numeric was expected
ORA-06512: at "APPS.QLTDATE", line 77
ORA-06512: at "APPS.QA_SOLUTION_DISPOSITION_PKG", line 728
ORA-06512: at line 2
APP-ALR-04020: Oracle Alert was unable to execute "&VALUE".  Check that this file exists and that its read protection is set correctly. (ROUTINE=alssoa) (FILE=5244221/alr/lib/alspsa.c) (LINE=400)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. There are 4 QCP in cascade:
ONV_MASTER_GC1
  ONV_DETAIL_GC1
    ONV_DISPOZICE_GC1
       ONV_WIP_DISPOZICE_GC1

2. The disposition actions are launched from the ONV_WIP_DISPOZICE_GC1 collection plan.
3. Path: Quality->Results->Entry->Enter Quality Results
4. The disposition actions in QA Disposition plan end with error:


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