Technology Stack - EBS (MOSC)

MOSC Banner

Event Based Alert Error

edited Aug 20, 2021 11:25AM in Technology Stack - EBS (MOSC) 3 commentsAnswered
Hi

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center