new schema creation - R12.2.5

[satish]

Dear Erman,

We use EBS version R12.2.5.We understand the custom schema uses apps connection and so this should be registered and editions enabled using adsplice.

Our concern:

we have created a schema for giving access to obiee team and this schema will have only read only privileges to few synonyms that are existing apps chema.In this case,i think obiee schema should be editions enabled.But is it required to register this schema and run adsplice?

If we dont run adspilce then how can we enable editions for this schema?is there any specific commands like alter user username enable editions?

We just created schema in this way "create user obiee_readonly identified by **** default tablespace xxobi_data;"

Please suggest,

Thank you

[ErmanArslansOracleBlog]

Such a custom schema ( a custom schema used by another application outside the EBS) is not required to be registered to EBS using adsplice.
So the choice is yours.

However; if you will not use the adsplice, you should manually make that custom scheme edition-enabled in order to use those synonyms.

In order to do that, you can use -> alter user <YOUR_USER> enable editions;

[satish]

It worked.Many thanks for your updates