
E-4 Oracle Application Management Pack for Oracle E-Business Suite Guide
Issue Recommendation for Release 11i
The database is missing
user xxcust
Create database user xxcust
Give appropriate grants to the user by running the necessary SQL
statements:
•
grant create session, alter session to xxcust
•
grant create type to xxcust
•
grant create database link to xxcust
•
grant create any outline, alter any outline, drop any outline to
xxcust
•
grant analyze any to xxcust
•
grant create sequence, create table to xxcust
•
grant create cluster to xxcust
•
grant CREATE TRIGGER to xxcust
•
grant create materialized view, query rewrite to xxcust
•
grant unlimited quota on all tablespaces with which user
xxcust is associated.
Please use APPS_TS_TX_DATA as the main tablespace for user
xxcust
Please use APPS_TS_TX_IDX as the index tablespace for user
xxcust
The entry for product
xxcust is missing from
FND_ORACLE_USERID
Insert entry for the product xxcust in FND_ORACLE_USERID
with the SQL:
INSERT INTO FND_ORACLE_USERID
(ORACLE_ID,ORACLE_USERNAME,LAST_UPDATE_DATE,
LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPD
ATE_LOGIN,DESCRIPTION,
ENABLED_FLAG,READ_ONLY_FLAG,ENCRYPTED_ORACLE_PASS
WORD,
CONCURRENT_BATCH_QUEUE_ID,INSTALL_GROUP_NUM)
VALUES (50001, 'XXCUST', sysdate,
1000, sysdate, 1000, 1000, 'XXCUST Account' ,
'N', 'A', NULL, NULL, 0 );
Comentarios a estos manuales