Oracle E-Business Suite Database
Shared Templates allows you to use the Oracle E-Business Suite Database as your file storage Drive.
Requirements and Setup
When you select the Oracle E-Business Suite Database as the preferred Shared Templates Drive type, a database table must be created to store the Shared Templates files.
- To create the Shared Templates Drive database table, execute the following script on your Oracle E-Business Suite database:
The following changes can be made to the script:
- You can modify the script to change the ownership of the table. If you choose to do so, ensure the APPS database user has SELECT, UPDATE and DELETE privileges on the table and create the required synonym to allow the APPS user to access the table without having to fully qualify the table name using the table owner.
- The tablespace (APPS_TS_MEDIA) used in the script can be modified to suit your system.
APPS.XXE4A_SHARED_TEMPLATES
CREATE TABLE APPS.XXE4A_SHARED_TEMPLATES ( FILE_ID NUMBER NOT NULL , FILE_NAME VARCHAR2(256 BYTE) , FILE_CONTENT_TYPE VARCHAR2(256 BYTE) NOT NULL , FILE_DATA BLOB , UPLOAD_DATE DATE , LANGUAGE VARCHAR2(4 BYTE) DEFAULT (userenv('LANG')) , ORACLE_CHARSET VARCHAR2(30 BYTE) DEFAULT (substr(userenv('LANGUAGE'), instr (userenv ('LANGUAGE') , '.') +1 )), CONSTRAINT XXE4A_SHARED_TEMPLATES_PK PRIMARY KEY (FILE_ID) ) LOGGING TABLESPACE APPS_TS_MEDIA PCTFREE 10 INITRANS 10 STORAGE ( INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) NOCOMPRESS LOB (FILE_DATA) STORE AS XXE4A_SHARED_TEMPLATES_LOB ( ENABLE STORAGE IN ROW CHUNK 32768 PCTVERSION 0 NOCACHE LOGGING ); /
Ensure you maintain sufficient free space in the selected Tablespace.