Search from 700 + 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.

Jun 24, 2017

Oracle CPQ Cloud

Oracle CPQ Cloud



May 26, 2017

How to Check version of Oracle EBS Form

How to Check version of Oracle EBS Form

1.Navigate to form and look for WHEN-NEW-FORM-INSTANCE
2.Search for command
FDRCSID('$Header: YOUR_FMB_NAME.fmb 120.0 2017/05/26 00:00  DEVELOPER-NAME ship  $');


Once you have FDRCSID done , Navigate to Shell (UNIX/LINUX) , and execute below command


adident Header  YOUR_FORM.fmb

<< make sure you type Header and not HEADER >>