Wednesday 9 November 2022

Oracle Fusion - SQL Query to check error message while Change Purchase Order Failed while send for and approval

--SQL to Check PO Detail--

SELECT *

FROM FUSION.PO_HEADERS_ALL

WHERE SEGMENT1 = '900001114637' --ENTER PO NUMBER


--SQL to Check PO Version Details--

SELECT  CO_NUM,

      VERSION_ID

FROM    FUSION.PO_VERSIONS

WHERE   PO_HEADER_ID IN

      (SELECT PO_HEADER_ID FROM FUSION.PO_HEADERS_ALL WHERE SEGMENT1 = '900001114637' --ENTER PO NUMBER

  )

ORDER BY CREATION_DATE DESC


--SQL to Check PO Approval Error--

SELECT  TEXT_LINE

FROM    FUSION.PO_ONLINE_REPORT_TEXT

WHERE   VERSION_ID = 300000225949043 --ENTER THE 1ST VERSION ID RECEIVED FROM ABOVE QUERY

ORDER BY CREATION_DATE DESC

No comments:

Post a Comment