Replicate a subset of R12 with GoldenGate...Challenges with APPS schema
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.