Oracle Fusion Data Intelligence Idea Lab

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

FDI Pipeline Failure and/or Delay notifications

Needs Votes
98
Views
4
Comments
Paresh M
Paresh M Rank 2 - Community Beginner

Hi

It will be good to get a pipeline failure or a pipeline delay notification.

Currently system sends a completion notification but in the unlikely event of a pipeline failure there doesn't seem to be a notification.

Also the refresh estimate notification is sent at the same time of the completion and is counter productive, it will be very helpful to get a delay notification in the unlikely event of a delay in the factory pipelines so support process can be formulated accordingly.

Thanks

Tagged:
27
27 votes

Needs Votes · Last Updated

Comments

  • JimF-UK
    JimF-UK Rank 1 - Community Starter

    Seems essential for a key live service like FDI to send information about any failures to allow support teams to identify the source of the problem quickly and deal with any impacts to the live service.

  • Johanna McGrath
    Johanna McGrath Rank 2 - Community Beginner

    This would be extremely helpful.

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Good Idea,Voted for the same.

  • ym-Oracle
    ym-Oracle Rank 3 - Community Apprentice

    I believe you can create notification using agent/analysis - direct DB SQL using Oracle_Data_Warehouse_Connection_Pool connection pool.

    select distinct WAREHOUSE_REFRESH_DATETIME from DW_WH_REFRESH_SUMMARY where PROCESS_NAME = 'WAREHOUSE_REFRESH_SCHEDULED' and WAREHOUSE_REFRESH_DATETIME > (SYSDATE-1)

    AND condition Percentage of Successful Jobs = 100

    Agent with condition report record count > 0

    Create Agent to run the schedule agent to run report after expected FDI load completed time from Pipeline.

    This will send email FDI load completed successfully.

    You can create another one with Percentage of Failed Jobs > 0 This will send email when FDI load failed