My Oracle Support Banner

Error In Periodic Alert - APP-ALR-04020: Oracle Alert was unable to execute "&VALUE". ORA-00936. (FROM QA_RESULTS_V WHERE PLAN_ID = <PLAN_ID>) (Doc ID 2554635.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Goal

ALECDC module: Check Periodic Alert ending with error:

Enter value for rep: old 4: FROM QA_RESULTS_V WHERE PLAN_ID = <PLAN_ID> AND <ELEMENT_COLUMN> = &<PARAMETER/TOKEN>
new 4:

ERROR at line 4:
ORA-00936: missing expression

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=/alr/lib/alspsa.c) (LINE=400)
 

Solution

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
Goal
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.