Tuesday, May 6, 2008

Custom objects in Apps

Creating custom object causes major confusion as we need to know whether the object should be create in custom schema or apps schema. The following needs to be followed for this->
All the custom table, index and sequence should be created in custom schema.
grants should be given on that object from custom schema to apps schema
synonym should be created for those object in apps schema
All the other database objects->views,packages,etc should be created in apps schema.

1 comment:

Anonymous said...

This is very helpful..Thanks