R12: FV: Performance Issue with SAM Data Processing (FVCCRDPP)
(Doc ID 2907402.1)
Last updated on NOVEMBER 19, 2022
Applies to:
Oracle U.S. Federal Financials - Version 12.2.10 and laterInformation in this document applies to any platform.
Performance Issue with SAM Data Processing (FVCCRDPP)
Symptoms
Performance Issue with "SAM Data Processing" (FVCCRDPP) concurrent program.
The below SQL is identified from a trace file which was taking long to execute.
SQL ID: fym6yt7d75gdk Plan Hash: 2197982067
SELECT fcv.ccr_id,fcv.enabled,fcv.extract_code,fcv.vendor_id,fcv.ccr_status,
fcv.duns,fcv.plus_four,fcv.legal_bus_name,fcv.country,fcv.taxpayer_id,
fcv.financial_institute,fcv.bank_acct_number,fcv.aba_routing,
fcv.payment_type,fco.pay_site_id,fco.main_address_site_id,
fco.bank_account_id,fco.org_id,fcvv.taxpayer_id,fcvv.vendor_id,
fcvv.legal_bus_name,fcv.last_import_date ,fco.main_address_site_flag,
fcv.ST_ADDRESS1,fcv.ST_ADDRESS2,fcv.CITY,fcv.STATE,
fcv.POSTAL_CODE||fcv.POSTAL_CODE_PLUS_4,fcv.COUNTRY,fcv.REMIT_POC,
fcv.REMIT_ADD1,fcv.REMIT_ADD2,fcv.REMIT_CITY,fcv.REMIT_STATE,
fcv.REMIT_POSTAL_CODE||fcv.REMIT_POSTAL_CODE_PLUS_4,fcv.REMIT_COUNTRY,
fcvv.country,fcv.bank_branch_id,fcv.social_security_number,
asp.base_currency_code,fcv.conc_request_status,fco.conc_request_status,
hou.name,fcv.organizational_type,fcv.MAIL_POC,fcv.AR_US_PHONE,fcv.AR_FAX,
fcv.AR_EMAIL,fcv.AR_NON_US_PHONE,fcv.AGENCY_LOCATION_CODE ,
fcv.UNIQUE_ENTITY_IDENTIFIER
FROM
fv_ccr_vendors fcv,fv_ccr_orgs fco,(SELECT taxpayer_id,duns,legal_bus_name,
vendor_id,country,unique_entity_identifier, social_security_number FROM
fv_ccr_vendors fcv WHERE plus_four IS NULL) fcvv,ap_system_parameters asp,
hr_operating_units hou WHERE fcv.ccr_id = fco.ccr_id AND
fcv.UNIQUE_ENTITY_IDENTIFIER = fcvv.UNIQUE_ENTITY_IDENTIFIER AND ccr_status
<> 'U' AND fcv.extract_code <> 'N'AND asp.org_id = fco.org_id AND
hou.organization_id = fco.org_id order by fcvv.taxpayer_id,
fcvv.social_security_number,fcv.unique_entity_identifier ,fcv.plus_four
nulls first
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.19 0.21 11 124 8 0
Execute 1 0.00 0.01 0 0 3 0
Fetch 2 144.20 529.77 1934682 4605040 0 20
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 144.41 529.99 1934693 4605164 11 20
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit SAM Data Processing
Changes
"SAM Data Processing" Performance after patch 33907404:R12.FV.C is applied.
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |