Hello Friends, here i am posting some of basic oracle applications questions , will try to collect more and put in future posts, here i am putting quite easy and basic questions. If you like to know Questions of any specific area or modules, plz communicate so i will post those as well.

What are Oracle Apps API?

Where APIs are physically store? n What is the latest version of API?

They are Application Program Interfaces, which are standard stored procedure, package or functions created for performing specific activities in the Oracle Apps E-Business Suite.

Ex: The Order Import API when called would create orders corresponding to the record in the Order Interface tables.

How to attach reports in Oracle Applications?

The steps are as follows:

1.          Design your report.

2.          Generate the executable file of the report.

3.          Move the executable as well as source file to the appropriate product’s folder.

4.          Register the report as concurrent executable.

5.          Define the concurrent program for the executable registered.

6.          Add the concurrent program to the request group of the responsibility.

How to attach Forms in Oracle Applications

1. Develop the form in Developer 2000.

2. Save the FORM and move it to UNIX. [Form to be moved to $CUSTOM_TOP/forms/US]

3. Define the FORM in Application Developer

4. Define FORM as FUNCTION.

5. Identify MENU, where the FORM to be attached. [SysadminResponsibilityDefine]

6.Copy the above MENU and go to Application Developer and query on MENU tab

What is the difference between Customization and Personalization?

Customization is done by making the changes in the cutom.pll whereas the Form Personalization is done through the Front End in Oracle Apps.

Difference between Key and Descriptive Flexfield?

key flex fields are used to identify particular entity like(accounts,objects) supoose take debit cards each debit card contain unique number to identify them. eg; 100-023-323 key flex fields are used to store this number along with description.

Unique Identifier

Key Flexfield are stored in segment

For key flexfield there are flexfield Qualifier and segment Qualifier

DFF’s are used to capture additional informtion required for our organization without any programming.

To capture extra information
Stored in attributes
Context-sensitive flexfield is a feature of DFF. (descriptive flexfield)

What is the difference between data conversion and data migration?

Data Migration is upgrading from one version to another version fro e.g. from 11.5.9 to 11.5.10.. Data Conversion is receiving data from a legacy system or receiving data from another module ( e.g. PA), validating it and converting it to ur our the target module using the standard import program.

What is the difference between Organization_id and Org_id ?

OrgId: Org Id is an unique ID for the Operating Unit.Organisation Id: The Organisation Id is an ID for the Inventory Organisation which is under an Operating Unit.

What are _ALL tables in Oracle Apps?

_all tables will store information about multiple oraganizations. these table contain ORG_ID column that  picks particular organizations from multiple organizations. _all tables will be created when we install multiorg.

What is one full life cycle implementation?

Full Life Cycle means implementing a project from the begining to the production and maintenance stage.

(1) System Planning:

(Scope & Budget of the Project)

(2) Business Analysis:

(Business Requirements, Mapping & GAP Analysis)

(3) System Analysis & Design

(Design Conceptual & Functional Data Models)

(4) System Development

(Programming & System/Integration/Validation Testing)

(5) System Implementation

(Data Conversions, Interfaces, Extensions,User Manuals & User Training)

(6) System Maintenance & Support

Thanks – Shivmohan Purohit

8 thoughts

  1. Ketan,

    do you have access to the Oracle Support Communities? when Oracle releases new functionality, the development teams release ppt recordings that explain the new functionality, its business need, setup etc. You can find the Oracle support pages by going to http://www.oracle.com and navigate to support.

    Alternatively, look at the OAUG.org website, this user group community also posts regular ppt’s and white papers that can help understand this area.

    Good luck!


  2. Hi Shivmohan
    your blogs are very help full thanks for that.
    Our company is implementing Oracle EBS . i want to learn it but not able figure out from where shall i start. I am a techno functional guy . pls advise from which topics shall i start with.


  3. Neelam,

    In my experience, the duties would be:

    Stage 1: What reports for example are required for when you go live. What custom reports do you have that need to be replaced. These are the types of input that need to be identified upfront in the planing stages.

    Stage 4: The functional person will be required to test various stages of the report or customization design. In addition, they may be providing information to the developer such as answering any questions that may need clarity to progress with the design.

    Stage 6: This is typically around support the solution and ensuring that users understand how to use the feature and what it means within the overall business process. This could be in the form of training programs. In addition, the functional resource should track any feedback from users and prioritize how the solution needs to be enhanced (if any) for feedback to the relevant teams.

    Hope that helps!



  4. Hi Shivmohan,

    First of all, thank you for being so generous to share your knowledge with newbies like me. I am learning a lot from the documents on this site.

    One quick question on the topic above:
    What are the duties of Functional person in each stage of Full Life Cycle? It is very clear in Stage 2 and 3. I can imagine certain duties in Stage 4 and 5 but how about Stage 1 and 6?

    Is the any good document that can guide me with this?



Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s