APP_FND_01564: Oracle error 24347 in FDFGVD
Cause: FDFGVD faild due to ORA-24347: Warning of a NULL column in an aggregate function.
I am getting by below query:
SELECT NVL (SUM (pll.quantity), 0) di_qty, ----error line
pll.attribute1 di_num, pha.segment1,
pha.po_header_id, pha.comments po_desc,
pll.ship_to_organization_id
FROM po_lines_all pla,
po_line_locations_all pll,
po_headers_all pha
WHERE UPPER (pll.attribute15) IN ('APPROVED')
AND pha.po_header_id = pla.po_header_id
AND pla.po_line_id = pll.po_line_id
AND pla.line_type_id IN (1,1021)
AND --on 9 july by Priya sharma
pha.po_header_id = pll.po_header_id
GROUP BY pll.attribute1,
pha.segment1,
pha.po_header_id,
pha.comments,
pll.ship_to_organization_id
Resolved issue by below query:
SELECT SUM (NVL(pll.quantity, 0)) di_qty, --Resalvoe line
pll.attribute1 di_num, pha.segment1,
pha.po_header_id,
NVL (pha.comments, 'NULL') po_desc,
pll.ship_to_organization_id
FROM po_lines_all pla,
po_line_locations_all pll,
po_headers_all pha
WHERE UPPER (pll.attribute15) IN ('APPROVED')
AND pha.po_header_id = pla.po_header_id
AND pla.po_line_id = pll.po_line_id
AND pla.line_type_id IN (1)
AND --on 9 july by Priya sharma
pha.po_header_id = pll.po_header_id
--AND PLL.ATTRIBUTE9 IS NOT NULL
/*AND PLL.SHIP_TO_ORGANIZATION_ID = &P_ORG_ID AND
AND PHA.PO_HEADER_ID = &P_PO_NUM*/
GROUP BY pll.attribute1,
pha.segment1,
pha.po_header_id,
pha.comments,
pll.ship_to_organization_id
Cause: FDFGVD faild due to ORA-24347: Warning of a NULL column in an aggregate function.
I am getting by below query:
SELECT NVL (SUM (pll.quantity), 0) di_qty, ----error line
pll.attribute1 di_num, pha.segment1,
pha.po_header_id, pha.comments po_desc,
pll.ship_to_organization_id
FROM po_lines_all pla,
po_line_locations_all pll,
po_headers_all pha
WHERE UPPER (pll.attribute15) IN ('APPROVED')
AND pha.po_header_id = pla.po_header_id
AND pla.po_line_id = pll.po_line_id
AND pla.line_type_id IN (1,1021)
AND --on 9 july by Priya sharma
pha.po_header_id = pll.po_header_id
GROUP BY pll.attribute1,
pha.segment1,
pha.po_header_id,
pha.comments,
pll.ship_to_organization_id
Resolved issue by below query:
SELECT SUM (NVL(pll.quantity, 0)) di_qty, --Resalvoe line
pll.attribute1 di_num, pha.segment1,
pha.po_header_id,
NVL (pha.comments, 'NULL') po_desc,
pll.ship_to_organization_id
FROM po_lines_all pla,
po_line_locations_all pll,
po_headers_all pha
WHERE UPPER (pll.attribute15) IN ('APPROVED')
AND pha.po_header_id = pla.po_header_id
AND pla.po_line_id = pll.po_line_id
AND pla.line_type_id IN (1)
AND --on 9 july by Priya sharma
pha.po_header_id = pll.po_header_id
--AND PLL.ATTRIBUTE9 IS NOT NULL
/*AND PLL.SHIP_TO_ORGANIZATION_ID = &P_ORG_ID AND
AND PHA.PO_HEADER_ID = &P_PO_NUM*/
GROUP BY pll.attribute1,
pha.segment1,
pha.po_header_id,
pha.comments,
pll.ship_to_organization_id
No comments:
Post a Comment