My Oracle Support Banner

QA - Disposition Actions Are Not Launched From QA Disposition Collection Plan (Doc ID 1665351.1)

Last updated on APRIL 04, 2025

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:
xxx_PRIMARY_GC1
  xxx_DETAIL_GC1
    xxx_DISPOZICE_GC1
       xxx_WIP_DISPOZICE_GC1

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


Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.