How long does ERP data gets committed to Oracle database

Question

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?

Rajesh L-Oracle · Answer

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