My Oracle Support Banner

Min-max Planning Report (XML) ERROR: Java.sql.SQLSyntaxErrorException: ORA-00920: Invalid Relational (Doc ID 2583083.1)

Last updated on SEPTEMBER 06, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, Replenish

When users attempts to run Min-max planning report XML (INVISMMX_XML) for any categories in the parameters, the program completes in Error.
But when running the same program without the categories in parameters, the program completes successfully.

Also If we run the Min-max planning report (TXT) manually (Inventory > Planning > Min-max planning report) the program also runs successfully.
The only scenario that fails if when running the Min-max planning report XML (INVISMMX_XML) for any categories in parameters.


ERROR
-----------------------
Min-max planning report (XML) ERROR: java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to: Inventory
2. Navigate to: View > Requests
3. Choose Min-max planning report
4. Submit report and monitor for completion.
5. It is going to Error.

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


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