Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

bia 11.1.1.10.2 standard loadplan siebel - missing siebel tables (s_etl_prd_rel..)

Question
1
Views
0
Comments

After installation we generated and ran the standard load plan siebel_8_1_1... from biacm.

The Load Plan failed because the table s_etl_prd_rel was missing.


After some investigation we found in an comparable setup, we found out, that some s_etl tables were not defined in the siebel schema of the siebel db itself but in a Schema of the Siebel DB, we used in BIACM for the siebel source definition/access (in our case this user is called read_admin_obi).


These tables where s_etl_prd_rel, s_etl_prd_attr, sqs_s_audit_item_opty and sqs_s_audit_item_revn. Also, this user had several grants to update/delete and insert tables in the siebel schema.


Does someone know, if this user has to be created manually or if there is a script either in the siebel setup oder in the setup of bia to generate this user? I didn't find anything so far and attempt to create the user, the objects and the privs manually based on our comparable setup.


Thanks


Gerd