Performance Issue In Mass Additions Create
(Doc ID 2353424.1)
Last updated on JULY 10, 2023
Applies to:
Oracle Assets - Version 12.0.1 and later Oracle Payables - Version 12.2.9 to 12.2.9 [Release 12.2] 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)
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!
