Wands (Oracle) 5.10 : 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.

1. To create the Shared Templates Drive database table, execute the following script on your Oracle E-Business Suite database:

   Icon

   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  
   );
   /