Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
bia 11.1.1.10.2 standard loadplan siebel - missing siebel tables (s_etl_prd_rel..)

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