EBS Customizations (MOSC)

MOSC Banner

Creating read only apps schema in R12.1.3

Hi All, I am using (attached) steps to create read only apps user, but it seems the steps are for creating read only apps schema in R12.2. Can you please help me with the steps to create the same in R12.1.3. I am getting below error while executing:

SQL> alter session set current_schema=APPS;

Session altered.

SQL> exec AD_ZD_PREP.REGISTER_CUSTOM_USER('APPS_SELECT');
BEGIN AD_ZD_PREP.REGISTER_CUSTOM_USER('APPS_SELECT'); END;

  *

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'AD_ZD_PREP.REGISTER_CUSTOM_USER' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center