This content has been marked as final. Show 6 replies
Oracle calculates the "Released" field based on the po releases when you query the form. It is not stored anywhere.
Hope this answers your question,
IF the release amount is not gettig stored any where, Then in case of Data Migration Activity, How we are going to get the amount extracted(or claculated)
Are you migrating out of Oracle OR in to Oracle?
If you are migrating data in to Oracle, you will create the Blanket PO and then you will create the Blanket Releases. Oracle will automatically calculated the released amount for displaying it whenever you open the PO on screen.
If you are migrating data out of Oracle to a different system, then you will have to write queries that do the calculation.
Yes we are migrating out to oracle
But not to a different system, but to another oracle Installation.
As per my assumpton the PO FORM internally calculate the total release amount , based on the number Standard POs released against the perticular BPA.
But not sure what exact calculation it does.
Can you please provide me the sample query, which actually does the calculation.
If not query, then if you can provide the logic also...will be helpful
You can start with the following
Add conditions to exclude unapproved POs, cancelled shipments etc.
SELECT pha.segment1 po#, SUM (price_override * quantity) released_amount FROM po_headers_all pha, po_line_locations_all plla WHERE plla.po_header_id = pha.po_header_id AND plla.po_release_id IS NOT NULL GROUP BY pha.segment1
Hope this helps,
For those who are trying to calculate the Blankets release Amount, I used the following query.
SELECT NVL(SUM (DECODE (POL.order_type_lookup_code,
'RATE', PLL.amount - NVL(PLL.amount_cancelled, 0),
'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0),
(NVL(PLL.quantity, 0) - NVL(PLL.quantity_cancelled, 0))
* NVL(PLL.price_override, 0))),0) AMT
FROM po.po_line_locations_all pll,
WHERE poh.po_header_id = POL.po_header_id
AND POL.po_line_id = PLL.po_line_id
AND pll.shipment_type NOT IN ('PRICE BREAK');
This is for my requirement only. You can include other conditions based upon your reqs.
Hope this helps.