How to check import errors from Order Import R12

Use the below Select statement to verify.

SELECT OPT.*

  FROM OE_PROCESSING_MSGS OPM,

       OE_PROCESSING_MSGS_TL OPT

WHERE OPM.TRANSACTION_ID = OPT.TRANSACTION_ID

   AND ORIGINAL_SYS_DOCUMENT_REF = '4347358'; -- This is Req Number

How to Download/Upload XML Data Template Definition

How to DOWNLOAD Data Template Definition in Oracle EBS

FNDLOAD apps/***** 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXEE_OKCTERM.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME="OKC" TEMPLATE_CODE="XXEE_OKCTERM"

How to UPLOAD Data Template Definition in Oracle EBS

FNDLOAD apps/***** 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXEE_OKCTERM.ldt