1 / 18

Oracle Alert - The Hidden Powerhouse

Oracle Alert - The Hidden Powerhouse. Presented by Rachel L. Biggins. Agenda. What is Oracle Alert Alert Definition Actions Response Processing Alert Examples in Oracle Applications Q & A. What is Oracle Alert. Oracle’s Exception Reporting Tool Focuses on Critical Information

swann
Download Presentation

Oracle Alert - The Hidden Powerhouse

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Alert - The Hidden Powerhouse Presented by Rachel L. Biggins

  2. Agenda • What is Oracle Alert • Alert Definition • Actions • Response Processing • Alert Examples in Oracle Applications • Q & A

  3. What is Oracle Alert • Oracle’s Exception Reporting Tool • Focuses on Critical Information • Shortens Reaction Time • Allows Application Data to be shared outside of the application

  4. What is Oracle Alert • Alert Definitions • Actions • Response Processing

  5. Alert Definition • Determine specific exception condition • Create SQL*Plus statement to report on exception condition • Determine Alert Type

  6. Alert Definition - Alert Types • Event Alerts • Periodic Alerts

  7. Alert Definition - Event Alerts • An alert that runs when an insert or update occurs in an Oracle Application table • Instantaneous results • Possible Concurrent Request bottleneck • Use Sparingly

  8. Alert Definition - Periodic Alerts • An Alert that check your database for exception conditions on a schedule you determine. • No Immediate notification • Can consolidate data into one message • Less contention for system resources

  9. Actions • Send Email Message - Detail or Summary • Start a Concurrent Request • Run an Operating System Script • Run a SQL*Plus or PL/SQL Script

  10. Actions • Action Sets allow you to group actions • You can have as many actions as you would like in a set

  11. Response Processing • Processes Replies from Alert Recipients • A message is sent that solicits a response from recipient as its alert action • Oracle Alert automatically takes predefined actions based on the reply that the user returns • Helps eliminate operator intervention for routine transactions

  12. Response Processing • Create Response Actions • Determine Actions for Valid Responses • Determine Actions for Invalid Responses • Determine Actions for No Response • Create Response Set

  13. Application Alert Examples General Ledger • Posting to Secure Accounts • Posting to Suspense Account • Journal Entries over a Dollar Threshold • Notification of Disabled Segments • Budget Vs. Actuals

  14. Application Alert Examples Payables • Invoice Due Date Problems • Invoice Date Problems • Payment Method Discrepancies • Invoices Over a Dollar Threshold • Direct Deposit Notifications

  15. Application Alert Examples Assets • Assets from AP • Posting to Asset Accounts • Assets Sold • Actuals Exceeding Capitol Budget

  16. Application Alert Examples Purchasing • Approver rejected requisition • Blanket PO about to expire • Vendor Delivery Late

  17. Conclusions • Big Bang for the Buck • Provides Visibility Beyond Oracle User Base • Exceptional Management Tool

  18. Q&A

More Related