Search 800 + Posts
Jul 2, 2017
SQL Error: ORA-38818: illegal reference to editioned object
SQL Error: ORA-38818: illegal reference to editioned object APPS.QP_LIST_HEADERS_ALL
38818. 00000 - "illegal reference to editioned object %s.%s"
*Cause: An attempt was made to violate the rule "A noneditioned object
may not depend on an editioned object."
*Action: Either make this object editioned; or do not make the illegal
A common reason for this error is missing ENABLE EDITIONS privilege to the user who was trying to run the SELECT statement . I granted the required privilege by executing below command
alter user <USER/SCHEMA_NAME> enable editions , and issue is resolved.