Po price is not equal to RCV price and MT price

The issue occurs twice again, the problem shocould be a bug [Patch 5256307]. Solution: ----------------------------------------------------------------------------- Step 1> Update Po's unit price to the price that it has been used by grouping; Udate po_lines_all
Set unit_price = 766.99
Where po_linee_id = 413817;

Update po_line_locations_all
Set price_override = 766.99
Where po_linee_id = 413817; Step 2> return po Line; Step 3> Update Po's unit price to right price; It has been corrected on Purchase Order Form or updated by SQL; update po_lines_all
Set unit_price = 655.4615
Where po_line_id = 413817; update po_line_locations_all
Set price_override = 655.4615
Where po_linee_id = 413817; Step 4> re-receive; ---------------------------------------------------------------------------- The following SQL will be used to check this issue; ========================================================== ========================================== Select ph.org _ id,
Ph. segment1 po_number,
Pl. line_num,
MSI. segment1 item_number,
Rt. primary_quantity quantity_received,
PD. recovery_rate,
Pl. unit_price po_unit_price,
Rt. po_unit_price rcv_po_unit_price,
Ph. currency_code po_currency_code,
Rt. currency_code rcv_currency_code,
(Select pla1.unit _ price
From Po. po_lines_archive_all pla1
Where pl. po_line_id = pla1.po _ line_id
And pla1.latest _ external_flag <> 'y'
And pla1.last _ update_date in
(Select max (PLA. last_update_date) last_update_date_max
From Po. po_lines_archive_all PLA
Where pla1.po _ line_id = PLA. po_line_id
And PLA. latest_external_flag <> 'y') po_last_original_unit_price,
(Select pla1.unit _ price
From Po. po_lines_archive_all pla1
Where pl. po_line_id = pla1.po _ line_id
And pla1.latest _ external_flag = 'y') po_now_unit_price,
PV. vendor_name,
PV. segment1 vendor_number
From Po. po_headers_all pH,
Po. po_lines_all PL,
Po. rcv_transactions RT,
Po. po_line_locations_all PLL,
Po. po_distributions_all PD,
Inv. mtl_system_items_ B MSI,
Po. po_vendors PV
Where ph.org _ id = 211
And pH. po_header_id = pl. po_header_id
And pH. po_header_id = Rt. po_header_id
And Rt. po_line_id = pl. po_line_id
And pl. po_line_id = PLL. po_line_id
And PLL. line_location_id = Pd. line_location_id
And Rt. source_document_code = 'po'
And Rt. destination_type_code = 'grouping ing' and RT. organization_id = MSI. organization_id
And pl. item_id = MSI. inventory_item_id
And pv. vendor_id = Ph. vendor_id
And Rt. po_unit_price <> pl. unit_price
And Rt. transaction_date> = sysdate-30
And not exists
(Select 'T'
From Po. rcv_transactions rt1
Where rt1.po _ header_id = Rt. po_header_id
And rt1.destination _ type_code = Rt. destination_type_code
And Rt. transaction_id = rt1.parent _ transaction_id)
And not exists
(Select 'T'
From Po. rcv_transactions rt1
Where rt1.transaction _ id = Rt. parent_transaction_id
And rt1.po _ header_id = Rt. po_header_id
And rt1.destination _ type_code = Rt. destination_type_code)
Order by RT. transaction_date