Receivables - EBS (MOSC)

MOSC Banner

Autoinvoice Import Program runs longer in R12

edited Mar 22, 2019 5:00AM in Receivables - EBS (MOSC) 19 commentsAnswered

We had 'slow' autoinvoice import issue in 11g and added some indexes to ra_interface_lines_all and to ra_customer_trx_lines_all, we also increased the max wait time for Autoinvoice Master Program from 60 to 90 sec and it did work well for 2 years until we upgraded to R12 , now after each backup - the first run is SLOOOOW and all following runs are (cached I assume) sufficient. I also see that the most slow routine is raaebt (tax validation?) but overall slowness after backups is noticeable as well.

Any suggestions are appreciated

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center