Oracle Apps Technical Questions – Part 1

By | September 27, 2014

Following is List of articles for Oracle Apps Technical Questions

Alternatively, Go through the following Top 10 Oracle Apps Technical Questions


 

List of Oracle Apps Technical Interview Questions – Part 1

1. Which is the most commonly used package in apps that uses Autonomous Transaction?
2. How to migrate Self Service personalization from one instance (say development instance) to other (say production) instance?
3. What are the main differences between Forms Personalization when compared to personalization done through CUSTOM.pll?
4. How does forms personalization work?
5. Why is CUSTOM.pLL needed when we already have forms personalization?
6. How to identify the form executable?
7. Please tell me the difference between Conversions and Interfaces?
8. How to submit concurrent program through pl/sql?
9. Why do we use data source as procedure in Oracle forms? What is the use of taking procedure as Data Source?
10. Can a Calculated item be stored in a database?

1. Which is the most commonly used package in apps that uses Autonomous Transaction?

FND_LOG, this is used for debugging. This has a procedure named string, which does a commit. Hence your debug messages are not lost in the event of rollback during unhanded exception.

Back to top

2. How to migrate Self Service personalization from one instance (say development instance) to other (say production) instance?

In R12, Using the Functional Administrator responsibility, you can export from Dev instance and then import in PROD instance.

Back to top

3. What are the main differences between Forms Personalization when compared to personalization done through CUSTOM.pll?

Forms Personalization

Difference Between Forms Vs Custom.pll Personalization

Forms Personalization

  • It is stored in tables
  • It can be restricted at site/responsibility/user level
  • It is easy to disable/enable with click of a button
  • It is applied once you create personalization and   re open the form.
  • Functional/ Technical consultant can do it.
  • It can be moved easily through FNDLOAD from one instance to other
  • It is stored in tables which contain who columns with which we have the ability to track who created/modified it

Personalization through Custom.pll

  • It is stored in files
  • It is complicated in it
  • In order to enable or disable, you need to change in custom.pll and recompile it
  • It needs recompilation of custom.pll which involves mostly DBA involvement.
  • It is migrated by migrating the custom.pll
  • No such option available for custom.pll

Back to top

4. How does forms personalization work?

Oracle forms have triggers that we trap to write our business logic. Oracle has a standard practice of calling a generic piece of code from each trigger(at form level).  In this generic piece of code Oracle checks in personalization tables to see if anything extra needs to be done for the events being executed. For details of example, see the article for forms personalizations.

Back to top

5. Why is CUSTOM.pLL needed when we already have forms personalization?

Just like any technology, forms personalization has its limitations. Limitation example  of forms personalizations:
For example you wish to prompt a message to user DO YOU WISH TO CREATE THIS PERSON AS SUPPLIER OR CUSTOMER OR EMPLOYEE. Lets say this message will prompt three options, create customer , create supplier or create vendor. Depending upon what user selects, you wish to navigate to one of relevant screens from the current TCA screen. For this, you have no choice but to use CUSTOM.pll

Back to top

6. How to identify the form executable?

Method1

Open the form to be customized in Oracle Apps from respective Responsibility/Menu
Next select menu /Help/About Oracle Application.
Here, scroll down within the subwindow and search for fmx. This is the executable that oracle application runs when specific form is invoked.

Method2

Query the responsibility definition which has the form attached to this. Note down the Menu which is attached to Responsibility. Go to the menu definition screen and find the form function attached to this menu. From this form function find the form attached to this function.

Back to top

7. Please tell me the difference between Conversions and Interfaces?

Conversion is an activity that is normally done when you are upgrading the system or migrating the system from legacy to Oracle.

Main characteristic of conversions are as follows

  • It is a program
  • It’s a onetime data transfer
  • Volume of data is already known at the start of activity
  • It is used in upgrading and migration of projects

Interface is to transfer data from one place to another on schedules basis. For example, Branches can submit their data to head office on daily basis. Such task is done through interfaces.

Main characteristic of interface are as follows

  • It is a program to transfer data from one location to another
  • It is schedules according to business requirement
  • Volume of data depended on business activities and hence not known in advance
  • All exception should be handled
  • It is used in enhancements/ customization projects or where third part software are operating and we need integration with oracle.

Back to top

8. How to submit concurrent program through pl/sql?

Function FND_REQUEST.SUBMIT_REQUEST

( application in varchar2 default null,
program in varchar2 default null,
description in varchar2 default null,
start-time in varchar2 default null,
sub_request in bookan default False,
argument1,
arguemnt2,
argument 100) return number;

* If this is submitted from oracle forms, all the arguments ( 1 to 100 ) must be specified

Back to top

9. Why do we use data source as procedure in Oracle forms? What is the use of taking procedure as Data Source?
To increase the control and security.
To specify a Query at runtime, Eg: in case of manager logs in he can see more info wherein if its employee he will be able to see less data
If you want to specify any complicated business rule to be executed before getting data, you can achieve through the server side procedure which will be much faster.

Back to top

10. Can a Calculated item be stored in a database?
No, It is not possible.

Prev Top 10 Oracle Apps Technical Interview Questions                                              Next Oracle Apps Technical Interview Questions – Part 2


Related Posts:

9 Steps to become Oracle Apps Consultant
Hierarchy of OLM Tables
How to create backend logging mechanism
Step to Register Discoverer Report
Steps for creating custom form in Oracle Apps
Clear Global Cache in Oracle Apps
Profile Values in Oracle Forms Personalization
2 simple Steps to make a responsibility read only

  • Ashraf Khan

    how we can made a complete assignment set, if Gl code is given with location & organisation detail.pls support.

  • fanni339

    We can create two types of assignment set INCLUDE / EXCLUDE based where we enter employee one by one.

    Second is criteria based. Where we can enter the name of organization and all employees in that organization will be picked as a result. In this assignment set, you can add many conditions using AND OR logic.

    Let me know if it answers your query

  • Ashraf Khan

    1)can give detail for second one…….(here create organization,location,define organization level & costing..then made assigment set..set criteria with one ore more org then generate)..
    final -PY_SRS_ASSET_RUN

    2)how we can make assigment set include/exclude based.
    is it more useful ?

  • Ashraf Khan

    Kindly request to share Joining query on report base
    in per_extra_people_info(contains Person EIT inforamtion and per_all_people_f (contains employee personal profile).

    my concern related to iqama,workpermit etc….

  • fanni339

    You can create in through AMENDMENT button on same page. About Usefulness, it depends on your need.

    Criteria based are used when you have different condition to make a criteria to select people

    Whereas INCLUDE / EXCLUDE options are less dynamic w.r.t selecting criteria.

  • fanni339

    select date_start join_date, ppf.employee_number, ppf.full_name, ppei.*

    from per_periods_of_service pps, PER_ALL_PEOPLE_F ppf, per_people_extra_info ppei

    where 1=1

    and date_start = (select max(date_start) from per_periods_of_service where person_id = ppf.person_id)

    and pps.person_id = ppf.person_id

    and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date

    and ppf.full_name = ‘Syed Farhan Ashraf’

    and ppf.employee_number = ‘339’

    and ppei.person_id = ppf.person_id

    and ppei.information_type = ‘XX_PASSPORT_DETAILS’

  • Ashraf Khan

    gotted thanks

  • Ashraf Khan

    select date_start join_date, ppf.employee_number, ppf.full_name, ppei.PEI_INFORMATION1

    from per_periods_of_service pps, PER_ALL_PEOPLE_F ppf, per_people_extra_info ppei

    where 1=1

    and date_start = (select max(date_start) from per_periods_of_service

    where person_id = ppf.person_id)

    and pps.person_id = ppf.person_id

    and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date

    –and ppf.full_name = ‘ASHRAF JAHANGIR KHAN’

    and ppf.employee_number = ‘129394’

    and ppei.person_id = ppf.person_id

    and ppei.information_type = ‘SA_PASSPORT’

    Comment:-Thanks it works.