Illegal reference to editioned object

R12.2环境中，在xxcust下compile package时，碰到如下错误，

PLS-00754:illegal reference to editioned object APPS.FND_PROFILE

当用下列语句查询时，EDITIONS_ENABLED的标记为'N'
SELECT EDITIONS_ENABLED FROM DBA_USERS
WHERE USERNAME IN ('APPS','XXCUST');

Solution: Doc ID 1929668.1

Create And Register CUSTOM Schema On EBS 12.2 (Doc ID 1929668.1)

To Bottom

---

In this Document

Goal

Solution

---

Applies to:

Oracle Applications Technology Stack - Version 12.2 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Goal

 How to create and register a custom / read-only schema on EBS 12.2?

Solution

A custom / read-only schema can be created in 12.2.x the same way as it has been done so far for the previous releases (11i / R12).

The only difference in 12.2 is that the custom schema should also be registered with EBS or it has to be manually enabled for editions. 

Else, ORA-38818 will be encountered.

For example:

create synonym [CUSTOM_SCHEMA].[ OBJECT_NAME] for APPS.[OBJECT_NAME]
*
ERROR at line 1:
ORA-38818: illegal reference to editioned object APPS.[ OBJECT_NAME]

 

The custom schema can be registered by the following APIs:

1. If Online Patching Enablement is not yet enabled (as suggested in ADZDPCUST.sql):

SQL> exec FND_ORACLE_USER_PKG.LOAD_ROW(' CUSTOM_SCHEMA', 'CUSTOM', 'INVALID', NULL, 'N', 'B');

 

2. If Online Patching Enablement has already been enabled:

sqlplus SYSTEM
SQL> alter session set current_schema=APPS;
SQL> exec AD_ZD_PREP.ENABLE_CUSTOM_USER('CUSTOM_SCHEMA'); 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10951282/viewspace-1543317/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10951282/viewspace-1543317/