OAC Data Replication REPLICATE FROM functionality — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OAC Data Replication REPLICATE FROM functionality

Received Response
51
Views
8
Comments
Attilio
Attilio Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Hi all,

durign a creation of new Data Replication under OAC I want to use the "replicate from" field in order to limit data extraction/replication.

Unfortunately, even if I populate correclty the field, it seem that it was ignored by the replica.

An oracle SR was opened without solutions.

Can someone help me in this?

Thx,

Attilio

image.png

Answers

  • SteveF-Oracle
    SteveF-Oracle Mod

    @Attilio

    Please follow-up with your Service Request, that is the best path forward as no one on this forum can review internal details of the service.

  • Attilio
    Attilio Rank 2 - Community Beginner

    @SteveF

    Oracle SR suggest me to ask in this community :-)

  • SteveF-Oracle
    SteveF-Oracle Mod

    Strange..

    Please post the SR# for follow-up.

  • Attilio
    Attilio Rank 2 - Community Beginner
    edited Apr 8, 2024 8:17AM

    Hi Steve,

    this is the SR: SR 3-35987406181

    BR,

    Attilio

  • SteveF-Oracle
    SteveF-Oracle Mod

    Hi @Attilio,

    Thanks for sharing the SR. I can see that the SR is with the Fusion Procurement team (OTBI team) not the Analytics Cloud team.

    If you have not already, double-check through the OAC document here to ensure all the criteria is met. Check the Overview section as well (I have assumed you have since it sounds like it is working, in general, just not honoring the limiting filter).

    Replicate Your Data

    The Replicate From option only applies to tables that have at least one incremental identifier column defined.

    If you select Incremental, you replicate all data on the first run and on subsequent runs you replicate only new data. Incremental updates require tables with a primary key and at least one incremental identifier column.

    Top FAQs for Data Replication.

    If you are still unable to resolve the issue, then a deeper look into the OAC instance or the logs may be required.
    In that case, you have two options. You can request the Fusion SR contact to open a collaboration SR with the OAC team, or you can open an SR directly with the OAC team

  • Attilio
    Attilio Rank 2 - Community Beginner

    Hi Steve,

    very appreciated you interesting.

    Yes, all the requiremnts are meet.

    Can you help me on how to open a SR with OAC Team?

    Thx,

    Attilio

  • SteveF-Oracle
    SteveF-Oracle Mod

    You can log a service request via MyOracle Support (https://support.oracle.com), or via your Oracle Cloud Infrastructure console (menu > Governance & Administration > Support Center)

  • GayathriAnand-Oracle
    GayathriAnand-Oracle Mod

    Hi

    We had a similar issue reported by a customer for OAC (not sure if its you) and in this case customer was populating the From field to a specific date because they only wanted data replicated for past 2 months.

    When we analyzed the logs in OAC backend, we noticed that OAC is sending the extract from date field to fusion but for whatever reason fusion was not honoring this from field and extracting all data.

    The recommendation from OAC team was to engage with fusion team to see why the from field was being ignored. I think it would be best if you can ask the fusion SR owner to open a collaboration ticket with OAC so OAC team can check our backend logs to verify if the from field is being sent to the fusion request. If yes this should be fusion team to assist further on why the extract does not honor this.

    Thanks

    Gayathri