R12: FV: Performance Issue with SAM Data Processing (FVCCRDPP) (Doc ID 2907402.1)

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