Template Storage Requirement
In order to use the Criteria Templates, a custom database object is required to be installed on Oracle E-Business Suite Database. The database table can be created as part of the Oracle for Wands install process on the server. Please use the information below to create the database table should it not have been created as part of the install process.
To create the Criteria Templates 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_CRITERIA_TEMPLATES
CREATE TABLE APPS.XXE4A_CRITERIA_TEMPLATES
(
ID VARCHAR2(30 BYTE) NOT NULL ENABLE,
NAME VARCHAR2(2000 BYTE) NOT NULL ENABLE,
DESCRIPTION VARCHAR2(240 BYTE),
OWNER_USER_ID NUMBER(15,0) NOT NULL ENABLE,
TEMPLATE_TYPE VARCHAR2(50 BYTE) NOT NULL ENABLE,
CRITERIA_VALUE VARCHAR2(4000 BYTE) NOT NULL ENABLE,
PUBLIC_FLAG VARCHAR2(1 BYTE) NOT NULL ENABLE,
CREATION_DATE DATE NOT NULL ENABLE,
LAST_UPDATE_DATE DATE NOT NULL ENABLE,
LAST_UPDATED_BY NUMBER(15,0) NOT NULL ENABLE,
CONSTRAINT XXE4A_CRITERIA_TEMPLATES_PK PRIMARY KEY (ID)
)
LOGGING
TABLESPACE APPS_TS_MEDIA
PCTFREE 10
INITRANS 10
STORAGE
(
INITIAL 131072
NEXT 131072
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
);
/
Ensure you maintain sufficient free space in the selected Tablespace.