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
           reference.

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.

3 comments:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  2. Great! Thank you very much for sharing! Very helpful!

    ReplyDelete
  3. I think there is a need to provide some more information about SQL and stored procedures. These are actually very important tools to look for.

    SQL Server Load Soap API

    ReplyDelete