Is it possible to create the MV Log and Publication Table under the different schema then the source table schema while using TIBCO Adapter for Oracle Apps?

Is it possible to create the MV Log and Publication Table under the different schema then the source table schema while using TIBCO Adapter for Oracle Apps?

book

Article ID: KB0092339

calendar_today

Updated On:

Products Versions
TIBCO Adapter for Oracle Applications -
Not Applicable -

Description

Resolution:
The publication table can be created in a schema different from the source table schema. The adapter generated SQL script creates publication table in user schema which might be different than the schema the source table resides in.

But the MV Log cannot be created under a different schema from their master table, the main table for the business object selected. This is an Oracle restriction

Please refer Oracle Documentation for Oracle 10g, for complete details on the Materialized View Logs:-

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/schema.htm#CNCPT010

Issue/Introduction

Is it possible to create the MV Log and Publication Table under the different schema then the source table schema while using TIBCO Adapter for Oracle Apps?