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