My Oracle Support Banner

Performance Issue In Mass Additions Create (Doc ID 2353424.1)

Last updated on JULY 22, 2018

Applies to:

Oracle Assets - Version 12.0.1 and later
Information in this document applies to any platform.

Symptoms

On : R12 version, Performance

ACTUAL BEHAVIOR
---------------
Mass Additions Create Program is taking long in R12

Performance issue when running mass additions create program.


 

TKPROF SHOWS EXPENSIVE QUERY AS:

 

UPDATE FA_MASS_ADDITIONS_GT GT SET SPLIT_MERGED_CODE = DECODE (NVL(:B3 ,'N'), 
 'N', 'MP',NULL), MERGED_CODE = DECODE (NVL(:B3 ,'N'), 'N', 'MP',NULL) 
WHERE 
MASS_ADDITION_ID = :B1 AND BOOK_TYPE_CODE = :B2 AND INVOICE_PAYMENT_ID IS 
 NULL AND LEDGER_CATEGORY_CODE = 'P' AND EXISTS (SELECT 1 FROM 
 FA_MASS_ADDITIONS_GT GT2 WHERE GT2.PARENT_INVOICE_DIST_ID = 
 GT.INVOICE_DISTRIBUTION_ID AND GT2.LEDGER_CATEGORY_CODE = 'P' AND GT2.ROWID 
 <> GT.ROWID) 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.