Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Setting Prune time for each and every PVO and Job Level in BICC

Declined
168
Views
5
Comments
Vivek Gautam
Vivek Gautam Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Idea Lab

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):


Description (Required):

As we need to extract data from fusion using the BICC we have the requirement of Prune time/days so that we don't miss any data but I don't see that feature in the BICC.

So think I would be a very good feature to be added at PVO and JOB level as we have this requirement in almost all the Data Warehouse projects

Use Case and Business Need (Required):


Enhancement Request / Service Request:

Tagged:
23
23 votes

Declined · Last Updated

Please post this idea into the Fusion Idea Lab on Customer Connect. (https://community.oracle.com/customerconnect/categories/erp-reporting-analytics-for-erp)

Comments

  • Rien Ottrman-Oracle
    Rien Ottrman-Oracle Rank 1 - Community Starter
    edited Dec 4, 2023 4:34PM

    Seems like a great Idea as different extracts might well need different prune times.

  • Binish George
    Binish George Rank 1 - Community Starter

    Is there a way to expedite this? Our organization is in need of this

  • Varun Jain-Oracle
    Varun Jain-Oracle Rank 2 - Community Beginner

    Agree.. PRUNE Time at each Job level should be there. System level can be used else Job level will take the precedence. Good Idea to be implemented.

  • User_WGKTP
    User_WGKTP Rank 1 - Community Starter

    i have the same requirement, if not possible to set at job or pvo level any soap service to set dynamically also helps

  • Praveen Thota
    Praveen Thota Rank 1 - Community Starter

    I have jobs scheduled at various intervals. Hourly / Daily. The current prune time can be set impacts all the jobs. Setting it to 60 minutes for the Daily Jobs will also impact Hourly jobs and send duplicated data for 2 hours.

    Its a good idea to have the Prune time set differently for each Schedule Job level / PVO level / Offering Level