1.

How Would You Know If The Purchase Order Xml Has Been Transmitted To Vendor, Looking At The Tables?

Answer»

The XML delivery status can be FOUND from a table named ecx_oxta_logmsg. Use the query below

SELECT edoc.document_number, DECODE(eol.result_code, 1000,'Success','Failure')AS status, eol. result_ text FROM ecx_oxta_ logmsg eol, ecx_ doclogs edoc, ecx_ outbound_ LOGS eog WHERE edoc. msgid = eol. sender_ message_ id AND eog. out_ msgid = edoc. msgid ORDER BY edoc. document_ number

The XML delivery status can be found from a table named ecx_oxta_logmsg. Use the query below


Discussion

No Comment Found

Related InterviewSolutions