11 Replies Latest reply on Mar 27, 2018 11:06 AM by Bommi

    APP-ALR-04106: Please correct the user-defined SQL statement for this alert.

    936921

      Good Day

       

      Am working on Oracle Application 12.1.3

      DB 11.2.0.3

      OS Linux RedHat 6

       

      since a week I faced this error message from the Alert "APP-ALR-04106: Please correct the user-defined SQL statement for this alert. "

       

      The alert was working fine before

       

      This is the alert statement

       

      SELECT msi.segment1, msi.description, msi.min_minmax_quantity,

      NVL (ROUND (onh.quantity, 0), 0) quantity,

      nvl((SELECT total

      FROM ebgh_items_ordered_med ord

      WHERE ord.item_id = msi.inventory_item_id),0)Ordered

      INTO &item, &description, &min_qty, &onhand &Ord

      FROM mtl_system_items_b msi, ebgh_items_onhand_qty_all_med onh

      WHERE msi.organization_id = 201

      AND msi.inventory_item_id = onh.inventory_item_id(+)

      AND msi.min_minmax_quantity > NVL (onh.quantity, 0)

      ORDER BY msi.min_minmax_quantity DESC