Technology Stack - EBS (MOSC)

MOSC Banner

Replicate a subset of R12 with GoldenGate...Challenges with APPS schema

edited Aug 4, 2015 10:07AM in Technology Stack - EBS (MOSC) 1 commentAnswered

Hi,

has some been able to replicate APPS schema objects using Goldengate.

We are replicating 250 tables to which we have 4 views (yes I know GG does not support views).  We are finding difficult to replicate the following views:

apps.xla_pa_ei_ael_gl_v

apps.po_vendor_sites_all

apps.fnd_user_resp_groups_direct  (done and replicated)

apps.xxbge_pa_status_inquiry  (done and replicated)

Basically, we replicate the base tables and re-create the view at destination. The views highlited in bold are the ones we are struggling with  - We have a SR with Oracle on the same -and so far no answer.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center