Purchase Order Vertex debug xml query in Oracle EBS

Purchase Order Vertex debug xml query in Oracle EBS
PO Vertex debug xml Oracle apps
Vertex debug Oracle R12

--PO Debug XML

SELECT poh.segment1     PO_NUMBER,
       poh.po_header_id po_header_id,
       pol.line_num,
       VT.REQUEST_ID,
       debug.REQUEST_NAME,
       debug.MESSAGE_TYPE,
       debug.xml
  FROM apps.po_headers_all        poh,
       apps.po_lines_all          pol,
       apps.po_line_locations_all pll,
       apps.vertex_txn_tax_resp   vt,
       apps.vertex_oic_debug_xml  debug
 WHERE     1 = 1
       AND poh.po_header_id = vt.transaction_id
       AND poh.po_header_id = pol.po_header_id
       AND pol.po_line_id = pll.po_line_id
       AND vt.transaction_line_id = pll.line_location_id
       AND poh.segment1 = '4334002898'
       AND pll.shipment_num = 1
       AND vt.request_id = debug.request_id(+);
       
       --
Related posts: Upload your own post and refer it anywhere anytime:

Leave a Reply

%d bloggers like this: