R12 AP: Query Ap_invoice_lines_v Gives Ora-01730 Invalid Number Of Column Name Specified
(Doc ID 452139.1)
Last updated on JANUARY 30, 2022
Applies to:Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
On 12.0.0 in Production:
When attempting to query the view QUERY AP_INVOICE_LINES_V
the following error occurs:
ORA-01730: Invalid number of column names specified
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Query the AP_INVOICE_LINES_V view using the following statement :
select * from AP_INVOICE_LINES_V ;
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