APILNUPG.SQL peformance during upgrade to R12.1.1
Hi,
Already implemented solutions in many of the notes found in MOS.
Still takes 4 hours to complete. Customer would like to have it complete in 2 hours.
R12.1.1 APILNUPG.SQL Is Taking Long Time To Run(Note: 863825.1)
Performance Issue With apilnupg.Sql Script During R12.1.1 Upgrade(Note: 1437659.1)
R12 : Performance Issue While Runing apilnupg.sql (Upgrade to 12.1.1)(Note: 942694.1)
Versions of files are
$Header ap_tax_alloc_amount_gt.xdf 120.3.12010000.2 2009/06/25 22:04:25 gkarampu ship $
$Header aplnupgb.pls 120.23.12010000.27 2012/03/16 05:34:04 mkmeda ship $
$Header apsin.odf 120.49.12010000.7 2009/03/11 19:34:10 bgoyal ship $
We have 30 workers running in 3 servers(distributed AD)
-----------------
If you don't have the index, AP_INVOICE_DISTRIBUTIONS_N25, please do create it.
Already implemented solutions in many of the notes found in MOS.
Still takes 4 hours to complete. Customer would like to have it complete in 2 hours.
R12.1.1 APILNUPG.SQL Is Taking Long Time To Run(Note: 863825.1)
Performance Issue With apilnupg.Sql Script During R12.1.1 Upgrade(Note: 1437659.1)
R12 : Performance Issue While Runing apilnupg.sql (Upgrade to 12.1.1)(Note: 942694.1)
Versions of files are
$Header ap_tax_alloc_amount_gt.xdf 120.3.12010000.2 2009/06/25 22:04:25 gkarampu ship $
$Header aplnupgb.pls 120.23.12010000.27 2012/03/16 05:34:04 mkmeda ship $
$Header apsin.odf 120.49.12010000.7 2009/03/11 19:34:10 bgoyal ship $
We have 30 workers running in 3 servers(distributed AD)
-----------------
If you don't have the index, AP_INVOICE_DISTRIBUTIONS_N25, please do create it.
Tagged:
0