Payables and Cash Management - EBS (MOSC)

MOSC Banner

aprevupd.sql running long

edited Aug 3, 2020 11:23AM in Payables and Cash Management - EBS (MOSC) 20 commentsAnswered

Hi,

We are in the process of upgrading our 11i instance to 12.2.5 and while applying the 12.2 patch we see that aprevupd.sql is running for more than 30 hours. We did run stats on the three tables before starting the upgrade.

exec stats.gather_table_stats('AP','AP_CHRG_ALLOCATIONS_ALL',dbms_stats.auto_sample_size) ;

exec fnd_stats.gather_table_stats('AP','AP_INVOICES_ALL',dbms_stats.auto_sample_size) ;

exec fnd_stats.gather_table_stats('AP','AP_INVOICE_DISTS_ARCH',dbms_stats.auto_sample_size) ;


This sql updates two columns in ap_inv_dists_source.


Thanks in advance

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