Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

How long does ERP data gets committed to Oracle database

Received Response
11
Views
1
Comments
mikaromo
mikaromo Rank 1 - Community Starter
in Oracle Business Intelligence Applications

Hi,

This question is raised due to a production issue we had when extracting reports from the ff table:

  • AP_HOLDS_ALL
  • PO_DISTRIBUTIONS_ALL

These are 2 out of 34 tables that we are extracting hourly. Since 24A, we've found missing records and whenever we re-extract we got to pick all the rows that we are expecting.

We are suspecting if the upgrade introduce a longer running process when data is getting committed to database. Now, question is how long does it usually take? Do we have any documentations about this? I've raised an SR regarding this concern but never got a clear answer of the root-cause.

Can anyone help please?

Tagged:

Answers

  • Rajesh L-Oracle
    Rajesh L-Oracle Mod

    Hi User_RCULI,

    Thank you for visiting and posting in Oracle Business Intelligence Applications.

    This forum is for OBIA product and looks like your question is for Fusion Applications tables and BICC extract.

    Please note Question for Fusion Apps should be posted in our sister community, which can be found at : Oracle Fusion Cloud Customer Connect ( https://community.oracle.com/customerconnect ).

    Please make a note of the above URL and visit above Fusion Apps forums to submit ideas, receive support from our FA Cloud experts and check out the resources they have available for you.

    Thank you,
    -Rajesh