You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Purpose of BICC Incremental Prune time in Minutes

edited Dec 4, 2019 9:42AM in Reporting and Analytics for ERP 3 comments

Summary

Look for real world advice, or best practice use of setting BICC Prune time

Content

Hi,

We are just starting to use BICC to extract incremental data from Fusion Financials. If I run an incremental extract every 2 hours, I am getting 24 hours worth of inserts and updates in every extract - not what I was hoping for. This is governed by the setting "Prune time in Minutes" mentioned here: https://www.ateam-oracle.com/set-up-oracle-fusion-saas-business-intelligence-cloud-connector-bicc-to-use-oracle-cloud-infrastructure-oci-object-storage and defaults to 1440 minutes (24 hours).

The obvious solution is to set this to zero - to eliminate overlap between subsequent extracts. I am wondering what the need for this setting is? Perhaps:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!