AP Supplier Open Interface Import - draft

➜ Back to Library
Description
Categories: BI Publisher
Application: Payables
Source: Supplier Open Interface Import (XML) - Not Supported: Reserved For Future Use
Short Name: APXSUIMP_XML
DB package: AP_APXSUIMP_XMLP_PKG
Run AP Supplier Open Interface Import - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT nvl(asi.segment1,' ') C_Reject_Supplier_Number,
           asi.vendor_name  C_Reject_Supplier_Name,
           fnm.message_text C_Rejection_Message
FROM   ap_supplier_int_rejections asir,
       ap_suppliers_int asi,
       fnd_new_messages fnm        
WHERE  asi.status = 'REJECTED'
AND    asi.import_request_id = :p_conc_request_id
AND    asir.parent_id=asi.vendor_interface_id
AND    asir.parent_table='AP_SUPPLIERS_INT'
AND    fnm.message_name=asir.reject_lookup_code
AND    fnm.language_code=userenv('LANG')
Parameter Name SQL text Validation
Import Options 
 
 LOV Oracle
Batch Size 
 
 Number
Print Exceptions Only 
 
 LOV Oracle
Debug Switch 
 
 LOV Oracle
Trace Switch 
 
 LOV Oracle
Download
Related Blitz Reports
AP Supplier Sites Open Interface Import - draft POS Integrated Supplier Import Rejections AP Accounted Invoice Aging GL Account Analysis 11g ECC Payables, AP Closing, SQL2 GL Account Analysis GL Account Analysis (Distributions) 11g ECC Payables, AP Closing, SQL1 PO Receiving Transactions Pipeline
Blitz Report™

Blitz Report™ provides multiple benefits: