R12: AP: XLA: When Trying To View Data From XLA Tables Received Error "ORA-01445 cannot select ROWID from, or sample, a join view without a key-preserved table" .
(Doc ID 3057289.1)
Last updated on NOVEMBER 08, 2024
Applies to:
Oracle Payables - Version 12.2 and laterInformation in this document applies to any platform.
Goal
When trying to view the XLA tables from SQL developer using the below query:
select ecg.rowid from XLA_EVENT_CLASS_GRPS_VL ECG, XLA_SUBLEDGERS_FVL XSL WHERE xsl.application_id = ecg.application_id AND ecg.EVENT_CLASS_GROUP_CODE = 'INVOICES';
Getting below error :
"ORA-01445 cannot select ROWID from, or sample, a join view without a key-preserved table"
Whereas the query works fine in R12.1.3 instance.
Solution
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
| Goal |
| Solution |