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博客

Illegal reference to editioned object

Applies to:

Goal

Solution

最新文章