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.