EBS Customizations (MOSC)

MOSC Banner

Oracle Event Alert firing multiple times

Hi

I have an Event Alert which needs to fired when the PO gets "REJECTED"

but to my surprise it is firing multiple times for particular PO


Alert Type : Event

Table : PO_HEADERS_ALL

AFTER UPDATE


Code:


    SELECT

      pha.attribute13,

      nvl(pha.rate,1),

      ( pla.unit_price * pla.quantity ) po_price,

      pha.org_id,

      pha.po_header_id

    INTO

      &P_AFE_NUMBER,

    &P_RATE,

    &P_PO_PRICE,

    &P_ORGANIZATION_ID,

    &P_PO_HEADER_ID

    FROM

      po_headers_all pha,

      po_lines_all  pla

    WHERE

        pha.po_header_id = pla.po_header_id

      AND pha.authorization_status = 'REJECTED'

      AND TRUNC (pha.last_update_date) = TRUNC (SYSDATE)

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