Find Material Transaction With Include Logical Options Causes ORA-01789 "query block has incorrect number of result columns"
Last updated on MAY 29, 2018
Applies to:Oracle Inventory Management - Version 12.2.5 and later
Information in this document applies to any platform.
Find Material Transaction with Include Logical Transactions option causes ORA-01789
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms