Event Based Alert Error
Anyone have an idea about the error mentioned below? Why ROWID is coming as Zero?
Following is the log from Alert Concurrent Request.
*************************************************************************
Performing alert "On Receipt"
Connecting to "APPS (124)"
Performing action set "SEND_ALERT_SET"
SQL error ORA-01410: invalid ROWID
occurred while executing the user-defined SQL statement for this alert (STMT=SELECT poh.segment1, pol.line_num, rcvsh.receipt_num FROM po_headers_all poh,
po_lines_all pol,
po_distributions_all pod,
rcv_transactions rcvt,
rcv_shipment_headers rcvsh
WHERE poh.po_header_id = pod.po_header_id
AND poh.po_header_id = pol.po_header_id