Hi All,
The below two update statements are goin in to infinite time and keep on running for hours.
Can these be modified to MERGE or what is wrong in the below statement. Few times, it ran fine but few times, its stuck in this statement for hours.
please advise.
UPDATE po_headers_all
SET j.channel_account_manager =
(SELECT ptnr.handle
FROM po_partner ptnr
WHERE LTRIM (ptnr.bp_link_id, '0') =
TO_CHAR (j.reseller_link_id));
UPDATE po_headers_all j
SET
(j.sales_org_cd,
j.disti_channel_cd
) =
(SELECT DISTINCT sales_org, distribution_channel
FROM po_sales c
WHERE TRIM (C.MATERIAL) = TRIM (j.material_cd)
AND c.sales_org IN
('MCA1', 'MGB1', 'MIE1', 'MSG1', 'MUS1')
AND c.GACT_ASGN IS NOT NULL
AND ROWNUM = 1) -- This statement returns multiple rows and am taking first row . will this cause any issue here
WHERE EXISTS
(SELECT 1
FROM po_doc_lkp ptr
WHERE ptr.profitcenter = j.profit_center_cd
AND ptr.flag = 'YES');
THankS
BK