AP invoice导入——获取导入错误信息

最新推荐文章于 2022-04-26 23:11:31 发布

qingtongqizhw

最新推荐文章于 2022-04-26 23:11:31 发布

阅读量3.2k

点赞数

文章标签： EBS ap invoice error interface

本文链接：https://blog.csdn.net/qingtongqizhw/article/details/17993217

版权

AP invoice接口导入的接口表包括：

ap_invoices_interface

ap_invoice_lines_interface

AP invoice接口导入的错误信息表如下：

ap_interface_rejections

获取ap_invoices_interface表中字段invoice_id的值为1的错误信息：
SELECT air.reject_lookup_code
  FROM ap_interface_rejections air, ap_invoices_interface aii
 WHERE air.parent_id = aii.invoice_id
   AND air.parent_table = 'AP_INVOICES_INTERFACE'
   AND aii.invoice_id = 1;
获取ap_invoice_lines_interface表中字段invoice_line_id的值为1的错误信息：
SELECT air.reject_lookup_code
  FROM ap_interface_rejections air, ap_invoice_lines_interface aili
 WHERE air.parent_id = aili.invoice_line_id
   AND air.parent_table = 'AP_INVOICE_LINES_INTERFACE'
   AND aili.invoice_line_id = 1;