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

How does the data get restored into a useable format so that reports can be generated?

Accepted answer
22
Views
2
Comments
Vbhat_19
Vbhat_19 Rank 1 - Community Starter
edited Jul 24, 2025 2:51PM in Oracle Analytics Cloud and Server

Hi Team,

Could you please help with the following query.

  1. Client is running SaaS Fusion ERP, HCM, SCM, and a few others.
  2. Client is dissolving and going out of business
  3. Client needs to archive all of their Fusion SaaS data.  (Most modules, but not all)
  4. Client has to keep the data for 7 years
  5. There may be a request(s) for this data to be retrieved by a 3rd party (Gov’t agency, or other)

How does the data get restored into a useable format so that reports can be generated?  (The type of report and frequency of the report is unknown at this point in time, and the request may come in at any time over the next seven years)

Tagged:

Best Answers

  • Gianni Ceresa
    Gianni Ceresa Mod
    Answer ✓

    Hi,

    Welcome to the Oracle Analytics community an forum.

    Your question is related to the Fusion data, therefore you are in the wrong forum.

    Fusion products are covered by a parallel and independent forum: https://community.oracle.com/customerconnect

    You may use Publisher in Fusion for reporting, but Publisher is just a technical tool, coming with no data. Data is owned by Fusion, that's why you should ask this question in the forum covering Fusion applications to get a valid reply.

    Once you have the data somehow, the format and database you can restore it to will drive your final question of how reports can be generated on it. Your data will drive this question, maybe even requiring you to rewrite fully your reports if the restore format and solution is not Fusion itself.

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist
    Answer ✓
    https://community.oracle.com/products/oracleanalytics/discussion/26572/how-does-the-data-get-restored-into-a-useable-format-so-that-reports-can-be-generated

    Hi,

    In addition to above response from Gianni, please work with your CSM to see if data can be archived somewhere. Normally, for my customers, we have taken a dump of all required data using custom BIPs and dumped them into an ADP DB and then created custom reports to pull any specific data.

    Thanks.