Find Material Transaction With Include Logical Options Causes ORA-01789 "query block has incorrect number of result columns"
(Doc ID 2189976.1)
Last updated on JUNE 01, 2023
Applies to:
Oracle Inventory Management - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
Problem
Find Material Transaction with Include Logical Transactions option causes ORA-01789
Error
Steps
The issue can be reproduced at will with the following steps:
1. INV(N)Transactions > Material Transactions
2. Check Include Logical Transactions and click Find
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 |