Data & Intelligence

Restoring Aging Snapshot Data in Finance Analytics

shutterstock_282922880

Whenever a Full load is executed, all target tables are truncated and reloaded. This can result in missing historical data in Aggregate or Snapshot tables. Once erased, such historical data cannot easily be replaced.

In order to preserve Account Payables (AP) and Account Receivables (AR) Snapshot data from aging invoice tables W_AP_AGING_INVOICE_A and W_AR_AGING_INVOICE_A, OOTB mappings have been created that will copy data to temporary tables at the beginning of a Full load and then restore copied data back into the Snapshot tables once Full load is completed. These mappings will only execute during a Full load.

To enable copy and restore process, the associated parameter RESTORE_AGING_IN_FULL must be set to Y. If you do NOT wish to copy and restore data from the AP or AR invoice Snapshot tables during a Full load, then set the value for this parameter to N (or any value other than Y).

Process to set value of RESTORE_AGING_IN_FULL parameter:

Login to http://<hostname>:9704/biacm and click on manage load plans under tasks

Data Intelligence - The Future of Big Data
The Future of Big Data

With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.

Get the Guide

31

Click on Load Plan

32

After selecting the load plan click on Data load Parameters tab below

33

Scroll down in the data load parameters to find parameter RESTORE_AGING_IN_FULL option

33

Select RESTORE_AGING_IN_FULL parameter assigned to Group Name AP Transaction and click on pencil icon to edit.

Change value to ‘Y’ to enable copy and restore process or ‘N’ to disable.

Similarly change RESTORE_AGING_IN_FULL parameter assigned to Group Name AR Transaction.

About the Author

10 years of experience doing analysis, design, development and implementation of Oracle Business Intelligence applications and ETL solutions using Informatica, DAC, ODI. Worked extensively on Oracle BIAPPS Implementations, SQL querying and Stored Procedures using PL/SQL. Worked on Functional Areas - HR, Finance, Service and Marketing Analytics, Procurement and Spend Analytics, Supply Chain and Order Management Analytics, Enterprise Healthcare Analytics (EHA) and OHADI (Oracle Healthcare Analytics Data Integration)

More from this Author

Thoughts on “Restoring Aging Snapshot Data in Finance Analytics”

  1. Hi Ashwin,
    Could you please confirm if this
    RESTORE_AGING_IN_FULL is set to Y in BIACM but still during full load we are unable to retain the history snapshot.. is it because of the OBIA version?
    Oracle Business Intelligence 11.1.1.7.131017

  2. Ashwin Pittampally Post author

    Hi Viresh,

    In rare cases value might not be refreshed in a variable even after updating in BIACM.

    Set the default value of RESTORE_AGING_IN_FULL variable to ‘Y’ in ODI studio, Check the ‘Overwrite’ and ‘Refresh’ options for
    RESTORE_AGING_IN_FULL variable in a root step of a load plan.

    Thanks,
    Ashwin.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up