Fusion Applications Transaction Database

Fusion Applications Transaction Database

In this post we shall cover on details related to Database Schema installation required for a Fusion Applications.As Fusion Applications is built on top of Fusion Middleware products it requires a significant amount of database schemas catering to the requirements of different Fusion Middleware products used.

Following is a brief snapshot on different schemas which will typically be installed in a Fusion Applications transaction database.

Out of all the schemas installed specific schemas for Fusion Applications functionality and business logic are the ones mentioned below

• FUSION
• FUSION_RUNTIME
• FUSION_DYNAMIC
• FUSION_AQ
• FUSION_BI
• FUSION_DQ
• FUSION_ODI_STAGE
• FUSION_SETUP

Rest of the other schemas are related to the specific Fusion Middleware related infrastructure components.

Let us look at the details of few of the schemas related to Fusion Applications

FUSION : This is the owner of all the objects that belong to Fusion Applications.All the corresponding rights and powers such as owning tables and objects, providing grants to FUSION_RUNTIME.  It is used for patching and has grants to many internal DBMS functions.

FUSION_RUNTIME : This is the runtime user.Used to run the Applications.Contains no DB objects.

FUSION_DYNAMIC : This is the schema that owns the objects that are dynamically created through ADM_DDL.ADM_DDL is a package that acts as a wrapper around the DDL statement. ADM_DDL support operations like truncate table, create index etc.

Looking at the schemas all application UI's related to Fusion Applications are run from FUSION_RUNTIME schema, so any development done has to be tested against runtime schema.

Now the specific details of other related technology schemas are 

AS Common Schemas	Includes:
Enterprise Scheduler Service	FUSION_ORA_ESS
Metadata Services	CRM_FUSION_MDS_SOA
	FIN_FUSION_MDS_SOA
	HCM_FUSION_MDS_SOA
	OIC_FUSION_MDS_SOA
	PRC_FUSION_MDS_SOA
	PRJ_FUSION_MDS_SOA
	SCM_FUSION_MDS_SOA
	SETUP_FUSION_MDS_SOA
	FUSION_MDS (complete MDS schema for Fusion Applications related customizations,ESS jobs etc which is related to Fusion Applications functionalities)
	FUSION_MDS_ESS
	FUSION_MDS_SPACES
Secure Enterprise Search	SEARCHSYS
Oracle Data Integrator	FUSION_ODI
Master and Work Repository
Enterprise Content Management	Includes:
Oracle Content Server 11g - Complete	FUSION_OCSERVER11G
Oracle Imaging and Process Management	FUSION_IPM
Oracle Business Intelligence (Platform)	FUSION_BIPLATFORM
Oracle BI Applications Schemas	Includes:
Oracle Transactional BI	FUSION_OTBI
WebLogic Server Communication Services	Includes:
SIP Infrastructure Location Service	FUSION_ORASDPLS
Presence	FUSION_ORASDPXDMS
SIP Infrastructure Subscriber Data Service	FUSION_ORASDPSDS
SOA and BPM Infrastructure	Includes:
User Messaging Service	FUSION_ORASDPM
SOA Infrastructure	CRM_FUSION_SOAINFRA
SOA Infrastructure	FIN_FUSION_SOAINFRA
SOA Infrastructure	HCM_FUSION_SOAINFRA
SOA Infrastructure	OIC_FUSION_SOAINFRA
SOA Infrastructure	PRC_FUSION_SOAINFRA
SOA Infrastructure	PRJ_FUSION_SOAINFRA
SOA Infrastructure	SCM_FUSION_SOAINFRA
SOA Infrastructure	SETUP_FUSION_SOAINFRA
WebCenter Suite	Includes:
WebCenter Spaces	FUSION_WEBCENTER
Portlet Producers	FUSION_PORTLET
Activity Graph and Analytics	FUSION_ACTIVITIES
Discussions	FUSION_DISCUSSIONS
	FUSION_DISCUSSIONS_CRAWLER
Audit	Includes:
	FUSION_IAU
	FUSION_IAU_APPEND
	FUSION_IAU_VIEWER
Oracle Social Network	Includes:
	FUSION_SOCIAL
	FUSION_SOCIAL_VIEWS
	FUSION_SOCIAL_CEF

Mostly the above mentioned are related to Fusion Middleware Infrastructure component related schemas whose features are used in Fusion Applications

 References : i) Fusion Applications Transaction Database

                      ii) Fusion Database Schemas