Daily Archives: May 5, 2010

Extra Tips – Things to remember while you are driving


Aside

Hello Friends, here is the second set of Questions on Application Developers , more of general questions, i am not digging in particular areas , only trying to put question which i normally ask with candidates. If you want help … Continue reading

Aside

Overview of Concurrent Programs and Requests A concurrent program is an executable file that runs simultaneously with other concurrent programs and with online operations, fully utilizing your hardware capacity. Typically, a concurrent program is a long-running, data-intensive task, such as … Continue reading

Oracle Alerts – FAQ for Beginners


1. What are Oracle Alerts?

Answer

Oracle Alerts are used to monitor unusual or critical activity within a designated database. The flexibility of ALERTS allows a database administrator the ability to monitor activities from tablespace sizing to activities associated with particular applications (i.e. AP, GL, FA). Alerts can be created to monitor a process in the database and to notify a specific individual of the status of the process.

2. What types of Oracle Alerts are there?

Answer

There are 2 types of alerts: Event Alerts and Periodic Alerts

a) EVENT ALERTS are triggered when an event or change is made to a table in the database.

b) PERIODIC ALERTS are activated on a scheduled basis to monitor database activities or changes.

3. What types of actions can be generated when an Alert is triggered?

Answer

When an alert is triggered or the event is true, the alert can Email, send or print a message. Alerts also have the ability to execute a SQL script to perform an action. Using Response Processing, Oracle Alerts can solicit a response from a specific individual and perform an action based on the response that it receives.

4. Can I build an Alert to run with my custom applications or tables?

Answer

Event or Periodic Alerts can work with any custom application, as long as the application is properly registered within the Oracle Applications package.

5. Which Email packages work with Alerts?

Answer

Oracle Alert is designed to work with Oracle Office, Oracle Interoffice, UNIX Sendmail, and VMS Mail.

6. Can Alerts be triggered by other Tools?

(i.e. other than Oracle Forms and concurrent programs)

Answer

Oracle Alerts can only be triggered from an application that has been registered in Oracle Applications. Alerts cannot be triggered via SQL updates or deletes to an Alert activated trigger.

7. What is Response Processing?

Answer

Response processing is a component of Alerts which allows the recipients of an alert to reply with a message and have the applications take some action based on the response. Response Processing only works with Oracle Mail products.

8. Do I need Oracle Applications to use Alerts?

Answer

Yes. Oracle Applications is required to create and run Alerts.

Extra Tips – Desk Exercises and stretches


KnowOracle – Top Documents – Most Read articles


Oracle A.I.M. Methodology – template lis 8,384 More stats
How to insert & character or special 7,527 More stats
Data flow for Order-to-Cash cycle 7,305 More stats
Oracle Reports (Report 6i) – Technical – 7,140 More stats
Oracle PL/SQL – Calculating Weekdays bet 5,501 More stats
Oracle Applications – Interview Question 5,007 More stats
Oracle Forms Development (Developer 2000 4,172 More stats
Accounts Payable Trial Balance – Reconci 3,902 More stats
Oracle General Ledger – Functional Inter 3,888 More stats
Form Personalization in Oracle Applicati 3,710 More stats
Oracle Payables Useful Tables 3,560 More stats
Useful AR Tables Informations 3,153 More stats
Oracle Purchasing – Purchase Order FAQ 2,934 More stats
How to use attachments in Oracle Applica 2,874 More stats
AutoInvoice Program Overview in Oracle A 2,806 More stats
Oracle Application – Top useful SQL Quer 2,676 More stats
Shell Script Tutorial for Oracle Applica 2,511 More stats
Oracle Forms Development (Developer 2000 2,414 More stats
Trace a Concurrent Request And Generate 2,351 More stats
Oracle Financials Accounting – Interview 2,266 More stats
How to generate a delimiter in spool out 2,246 More stats
Oracle Applications – FNDLOAD Utility 1,981 More stats
Oracle Technical Interview Questions and 1,964 More stats
Interview Questions for Oracle 11i Apps 1,927 More stats
Variable Input file handling in Oracle S 1,896 More stats
Oracle SQL / PLSQL Developer – Technical 1,862 More stats
FAQ on Oracle Workflow Background Engine 1,806 More stats
AR Interview Questions – Technical and F 1,798 More stats
Oracle Fixed Assets Useful Tables 1,779 More stats
Excel output directly from Oracle Applic 1,768 More stats
Oracle General Ledger – Tables 1,672 More stats
Setting your Oracle Applications session 1,670 More stats
White Papers 1,615 More stats
UNIX / Shell Programming Basic – Beginne 1,612 More stats
Oracle HRMS Functional Questions 1,588 More stats
Oracle Applications – Technical Intervie 1,567 More stats
Oracle User Management – Password Reset 1,431 More stats
Oracle Application – General Interview ( 1,429 More stats
Oracle Alerts – FAQ for Beginners 1,419 More stats
Oracle Applications / Financials – Funct 1,417 More stats
Videos 1,415 More stats
Oracle 11i Application Developer – Techn 1,402 More stats
Oracle Order Management – Technical – Ta 1,343 More stats
Back-to-Back Order – How to 1,333 More stats
Setting up Invoice Approval Workflow 1,275 More stats
Oracle Applications Documentation AIM Me 1,226 More stats
Oracle & Iron Man – Great Combinatio 1,210 More stats
Oracle Receivables – FAQ , Interview Que 1,158 More stats
How do you find or delete duplicate rows 1,135 More stats
Oracle Timecard (OTL) Automation 1,133 More stats
Working with CONCSUB 1,127 More stats
Oracle Applications FND Useful Tables 1,108 More stats
Overview – Oracle Projects 1,085 More stats
Oracle Database – Technical Questions An 1,043 More stats
Oracle iExpense- What are the tables inv 1,030 More stats
Oracle AP – Payables Payment Selection C 1,003 More stats
To create a customized folder in Oracle 996 More stats
Tips For Personalizing The E-Business Su 959 More stats
Oracle Projects Billing Interface with O 949 More stats
Oracle iExpense – How To Enter Internet 943 More stats
Mostly asked questions in Account Payabl 941 More stats
Steps to change the Discoverer Session t 933 More stats
Very Common Oracle Apps DBA Questions 931 More stats
Video Tutorial : Oracle SOA Suite 925 More stats
Oracle Property Manager – Introduction - 897 More stats
Oracle Applications – Basics – Part 1 895 More stats
How to Review and Adjust Oracle Project 887 More stats
Oracle 11i Concept – Multi Org 881 More stats
Oracle Interview Questions With Answers 870 More stats
What is Oracle Apps (ERP)? 846 More stats
How To Identify Where An Expense Report 843 More stats
Oracle Projects – Revenue Generations an 842 More stats
Oracle Applications – Commonly Useful SQ 834

Extra Tips : Managing team conflict


Managing team conflict is one of the core competency area a manager should have. However, it is one of the most difficult skills sou should nurture as a manager. In order to resolve team conflict you need to ask yourself the following five questions.

  • What are the symptoms of the conflict: Conflict can be defined as a serious disagreement for the successful completion of the project. They include:
    • Not completing work in time
    • Not returning phone calls or e-mails
    • Not responding to requests for information
    • Finger Pointing
    • Complaints, verbal abuse and hostility
    • Not attending the meeting
  • Each behavior does not necessarily mean serious conflict unless they are extreme. The extreme behavior may be irreparable damage like poor performance or miss the deadline.

    On the contrary, a high performance team is a group of people who can understand roles and goals, and they are committed to achieve those goals together. An effective team uses their individual skills and support each other to work together to meet their goals, . They communicate and share information. They believe in team work.

    A high-performance team:

    * Works together to achieve mutual goals.
    * Accepts the fact that each member is responsible, a team player, and committed to achieving team goals.
    * Communicates with each other.
    * Shares the achievement and failure together.
    * Shares information, helps each other, and admits the fact that the success of the group is dependent on each individual.
    * They can handle conflict.

  • What are the reasons for the conflict: Conflict occurs when the goal is not very clear or unrealistic. The ability to resolve conflict effectively is an important team skill. The reason of conflict includes:
    • Poor or no communication.
    • Lack of problem solving skills
    • Lack of clarity in purpose, goals, objectives, team and individual roles
    • Not sure about resources and sources for help support
    • Bad time management
    • Bad leadership and management
    • Job is not challenging
    • Lack of skill set in team members
    • Personal problems
  • How to address the conflict:
    • You need to define the problem first: Most people jump to resolve the problem first without knowing what the problem is all about. We should initially focus to define the problem together. Problem definition may change while gathering the data or may be further refined during problem solving.
    • Gather Data:  The next step is to gather data on what is actually happening. This means collecting facts that that are actual,
      observable, and measurable. It also means observing through meetings, teleconferencing, or video conferencing.We need to know about individual performances, who’s meeting deadlines and goals, who works independently,  who comes up with good ideas, who initiates, who takes on extra work and performs it etc.
    • Analyze the data: Analyzing the data means we can address what is going on with the team itself, and figure out the role the manager is playing. To diagnose the performance we should consider a> Lack of Communications, b> lack of problem solving skills c> Lack of clarity of goal, team and individual roles d> Poor time management e> lack of leadership f> Personality Conflicts etc.
  • Choose the Best solution: As we analyze our data, we have to separate it into small areas such as communications, turnover, etc.We have to look into “root causes” versus symptoms. If we get answers to questions in each area, we can focus in on distinct areas of the problem.We can work on solutions and then find out the best solution.
  • Implement the solution: After we analyze the data
    and develop solutions, we select the best solution for our problem areas and begin to construct a plan. This plan will include actions to address each problem area, and will include a schedule for implementation with measurements. Work on one or two areas versus trying to fix everything at once