R12: AP: Using UNIPIVOT in a Query Against Some Editioned Tables May Cause an ORA-00904 Error
(Doc ID 2975035.1)
Last updated on SEPTEMBER 18, 2023
Applies to:Oracle Payables - Version 12.2 and later
Information in this document applies to any platform.
When attempting to use UNIPIVOT in a query against editioned an table the following error may occur depending on the current state of patching:
ORA-00904: "TABLE_NAME"."COLUMN_NAME": invalid identifier
For instance the following query
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