ITPub博客

首页 > 数据库 > Oracle > Illegal reference to editioned object

Illegal reference to editioned object

原创 Oracle 作者:dragon_88 时间:2015-04-08 10:03:30 0 删除 编辑
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

Click to add to Favorites Create And Register CUSTOM Schema On EBS 12.2 (Doc ID 1929668.1) To BottomTo 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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2011-03-10

  • 博文量
    137
  • 访问量
    161384