详解EBS接口开发之供应商导入（补充）--错误信息处理-优快云博客

本文提供了一种通过SQL查询检查不同供应商记录中拒绝详情的方法，包括供应商信息、站点信息及联系人信息等。这些查询有助于了解被拒绝的具体原因及其描述。

check reject details on records of AP_SUPPLIER_INT

SELECT s.parent_table,s.reject_lookup_code,S.LAST_UPDATE_DATE,F.MESSAGE_TEXT,F.DESCRIPTION 
FROM ap_supplier_int_rejections s, fnd_new_messages f 
WHERE s.reject_lookup_code = f.message_name 
AND s.parent_table = 'AP_SUPPLIER_INT' AND f.language_code='ZHS';

check reject details on records of AP_SUPPLIER_SITES_INT

SELECT s.parent_table,s.reject_lookup_code,S.LAST_UPDATE_DATE,F.MESSAGE_TEXT,F.DESCRIPTION 
FROM ap_supplier_int_rejections s, fnd_new_messages f 
WHERE s.reject_lookup_code = f.message_name 
AND s.parent_table = 'AP_SUPPLIER_SITES_INT' AND f.language_code='ZHS';

check reject details on records of AP_SUP_SITE_CONTACT_INT

SELECT s.parent_table,s.reject_lookup_code,S.LAST_UPDATE_DATE,F.MESSAGE_TEXT,F.DESCRIPTION 
FROM ap_supplier_int_rejections s, fnd_new_messages f 
WHERE s.reject_lookup_code = f.message_name 
AND s.parent_table = 'AP_SUP_SITE_CONTACT_INT' AND f.language_code='ZHS';

转载于:https://www.cnblogs.com/wanghang/p/6299459.html