R12.2 Apps DBA. Powered by Blogger.

ORA-38818: illegal reference to editioned object APPS.[OBJECT_NAME] R12.2

No comments :
Create And Register CUSTOM Schema On EBS 12.2
Sol:
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:
select username, editions_enabled from dba_users where username='XXISV';
USERNAME          E
--------------------
XXISV             N
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');

No comments :

Post a Comment

Note: only a member of this blog may post a comment.