My Oracle Support Banner

Cannot Move Problem Workflow Status From Verification (Submit) Status to Closed (Released) Status ORA-00936: missing expression (Doc ID 2761480.1)

Last updated on MARCH 19, 2021

Applies to:

Oracle Agile Product Collaboration - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

When trying to move from Verification (Submit) status to Closed (Released) status the error message ORA-00936 missing expression is returned.

ERROR
ORA-00936: missing expression
 
The issue can be reproduced at will with the following steps:
1. Login to webclient
2. Create a new External Complaint; Create New > Events > External Events
    Type:  Issue-Complaint
3. Add 3 Suppliers
4. Add the same affected items that were found on the problem External Complaint
5. Move WF from Submit to Release
6. Move Release to Close receive error ORA-00936 missing expression

 

Changes

 

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