Oracle 11i Application Developer – Technical FAQ – Part 2

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 in any specific areas , plz advise, i will try to do that.

Q11 ) What is SET-OF-BOOKS?
Collection of Chat of Accounts and Currency and Calendars is called SOB

Q12 ) What is the interface?
Interface Table is a table which is used as medium for transfer of data between two systems.

Q13 Tell me what is the procedure to develop an interface?
a. First we will get the Requirement document.
b. We will create control file based on that plot file.
c. Then the control files which loads the data into staging tables.
d. Through pl/sql programs we will mapping and validate the data and then dump into the interface tables.
e. Through the standard programs we will push the data from interface tables to Base tables.

Q14) What is multi org?
“Legal entity has more than one operating unit is called as multi org”
a) Business group — Human resources information is secured by Business group
b) Legal entity. — inter-company and fiscal/tax reporting.
c) Operating unit — secures AR, OE, AP, PA and PO Information.
d) Organizations — is a specialize unit of work at particular locations

Q15) What are the User PARAMETERS in the Reports?

FND SRWINIT sets your profile option values, multiple organizations and allows Oracle Application Object Library user exits to detect that they have been called by an Oracle Reports program.
FND SRWEXIT ensures that all the memory allocated for AOL user exits have been freed up properly.
FND FLEXIDVAL are used to display flex field information like prompt, value etc
FND FLEXSQL these user exits allow you to use flex fields in your reports
FND FORMAT_CURRENCY is used to print currency in various formats by using formula column

Q17) what are the two parameters that are mandatory for pl/sql type concurrent program?
Procedure/function (ERRBUF OUT
ERRBUF :- Used to write the error message to log or request file.
RETCODE :- Populate log request file with program submission details info.

Q18.) What is Value Set?
–The value set is a collection (or) container of values.
–When ever the value set associated with any report parameters. It provides list of values to the end user to accept one of the values as report parameter value.
n If the list of values needed to be dynamic and ever changing and define a table based values set.

Q19) What r the validation types in Value Set?
1) None ——– validation is minimal.
2) Independent ——input must exist on previously defined list of values
3) Dependent ——input is checked against a subset of values based on a
prior value.
3) Table —– input is checked against values in an application table
4) Special ——values set uses a flex field itself.
5) Pair —— two flex fields together specify a range of valid values.
6) Translatable independent —– input must exist on previously defined list
of values; translated values can be used.
7) Translatable dependent ——- input is checked against a subset of values
based on a prior values; translated value can be used.

Q20) Who information’s?
1) Created by
2) Creation date
3) Last _updated by
4) last_update_date

Thanks  — Shivmohan Purohit

Overview of Concurrent Programs and Requests

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 posting a journal or generating a report.

Request Groups and Request Sets

Reports and concurrent programs can be assembled into request groups and request sets.

o A request group is a collection of reports or concurrent programs. A System Administrator defines report groups in order to control user access to reports and concurrent programs. Only a System Administrator can create a request group.

o Request sets define run and print options, and possibly, parameter values, for a collection of reports or concurrent program. End users and System Administrators can define request sets. A System Administrator has request set privileges beyond those of an end user.

Standard Request Submission and Request Groups

Standard Request Submission is an Oracle Applications feature that allows you to select and run all your reports and other concurrent programs from a single, standard form. The standard submission form is called Submit Request, although it can be customized to display a different title.

o The reports and concurrent programs that may be selected from the Submit Requests form belong to a request security group, which is a request group assigned to a responsibility.

o The reports and concurrent programs that may be selected from a customized Submit Request form belong to a request group that uses a code.

As System Administrator you can limit the number of requests that may be active (status of Running) for an individual user. This ensures that a user cannot monopolize the request queue. For example, if a user with an Active Request Limit of 5 submits 20 requests, only 5 requests will be run at the same time. The remaining requests will be run when the number of active requests for the user drops below 5. Use the Profile Options window to set the Concurrent: Active Request Limit profile. To set a global limit for all users, set this option at the site level. You can then modify limits for individual users by setting this profile option at the User level.

do share you feedback and comments. thanks – shivmohan purohit

Oracle Alerts – FAQ for Beginners

1. What are Oracle Alerts?


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?


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?


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?


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?


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)


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?


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?


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

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