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.


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.

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

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.




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

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