PO Receiving Interface Errors

Description
Categories: BI Publisher, Toolkit - Setup & Support
Application: Purchasing
Source: Receiving Interface Errors Report (XML)
Short Name: RCVIERR_XML
DB package: PO_RCVIERR_XMLP_PKG
Run PO Receiving Interface Errors and other Oracle EBS reports with Blitz Report™ on our demo environment
select poi.column_name column_name2,poi.error_message,
	rti.interface_transaction_id,
	rti.vendor_name,
	rti.vendor_num,
	rti.shipment_num,
	rti.transaction_type,
	to_char(rti.transaction_date,'DD-MON-YYYY HH24:MI:SS') transaction_date,
	to_char(rti.creation_date,'DD-MON-YYYY HH24:MI:SS') creation_date,
	rti.created_by,
	rti.to_organization_code,
	rti.ship_to_location_code,
	rti.document_num,
	rti.release_num,
	rti.document_line_num,
	rti.document_shipment_line_num,
	rti.vendor_item_num,
	rti.item_num,
                rti.job_id,
                rti.timecard_id,
                rti.timecard_ovn,
	rti.substitute_item_num,
	rti.item_description,
	to_char(rti.expected_receipt_date,'DD-MON-YYYY HH24:MI:SS') expected_receipt_date,
	rti.quantity,
                rti.amount,
	rti.unit_of_measure,
	rti.quantity_invoiced
from po_interface_errors poi,rcv_transactions_interface rti
     where 
          ((poi.interface_line_id = rti.interface_transaction_id and
          poi.interface_type='RCV-856') or
          (poi.interface_transaction_id = rti.interface_transaction_id and
          poi.interface_type in ('RECEIVE','DELIVER'))) and 
                    ((trunc(to_date(to_char(poi.creation_date,'DD-MON-YYYY'),'DD-MON-YYYY')) between 
 nvl(:p_start_date,poi.creation_date) and 
 nvl(:p_end_date,sysdate) and
(:p_start_date is not null or :p_end_date is not null)) OR
        (:p_start_date is null and :p_end_date is null and rti.processing_status_code NOT IN ('PENDING')))
           order by rti.interface_transaction_id,rti.vendor_name
Parameter Name SQL text Validation
Start Date
 
DateTime
End Date
 
DateTime
P_Purge_Data
 
LOV Oracle
Blitz Report™