Top 30 Oracle Apps Interview Questions and Answers
Q1. Structure Development Process?
Open layout structure
Save as .fmb
Change the structure module name as structure name.
Erase the default blocks, window, and material
Make a window.
Appoint the window property class to window
Make a material (subclass data)
Dole out material property class to the material
dole out the window to the endlessly material to the window
Make an information block
Adjust the structure level properties. (sub class thing Text thing)
Alter the app_custom bundle. In the program unit.
Alter the pre-structure trigger (structure level)
Alter the module level properties ((console window, First route
Save and aggregate the structure.
Place the .fmx in the server registry.
Q2. What Is Autonomous Traction?
Independent foothold me a foothold that is implanted in another foothold, however works freely.
Q3. Might We at any point Have Custom Schema When It Required?
indeed, we can have custom composition, when we need to make another table we required custom outline.
Q4. What Is An Open Interface In Oracle Applications?
Open Interface, otherwise called the Application Programmer Interface (API), is a cycle by which the Oracle Applications are connected with outer or inheritance frameworks. Open Interface functions as an impermanent organizing region to stack the outside data into Oracle Applications tables. When the information is approved, it sends the data to the long-lasting tables. Dismissed footings can be revised and resubmitted.
Q5. What Is A Request Set?
A solicitation set is an assortment of reports or projects gathered together. When you present a solicitation set work, it executes every one of the projects in a report set successively or in an equal way as characterized in the solicitation set.
Q6. What Is Concurrent Processing?
Simultaneous handling is a cycle that at the same time runs programs behind the scenes (normally on the server instead of your workstation) while working on the web.
Q7. What Is A Descriptive Flex Field?
A DFF allows you to characterize the custom fields into Oracle Application structures without tweaking the program code. DFFs in structures are addressed by a "brew mug" field (a solitary space field encased by sections) that seems to be the accompanying image: [ ]. They are typically put away in ATTRIBUTE 1...ATTRIBUTE n data set sections. DFFs can likewise be utilized to acknowledge report boundaries.
Q8. What Is Formula Column?
An equation segment plays out a client characterized calculation on another column(s) information, including placeholder sections.
Q9. What Is Tca (exchanging Community Architecture)?
Prophet Trading Community Architecture (TCA) is an information model that permits you to oversee complex data about the gatherings, or clients, who have a place with your business local area, including associations, areas, and the organization of various leveled connections among them. This data is kept up with in the TCA Registry, which is the single wellspring of exchanging local area data for Oracle E-Business Suite applications.
Q10. Do I Need To Have Who Column Information In Custom Forms?
Indeed. It is emphatically prescribed to add WHO segments to the custom tables and call standard API, FND_STANDARD.SET_WHO in PRE-INSERT, and PRE-UPDATE triggers in each block of the structure. Additionally, determine these fields as concealed in each block of the structure.
Q11. What number of Validation Types Are There?
Six approval types exist:
none, reliant, free, table, extraordinary, and match.
Q12. What Is A Key Flexfield?
A Key Flexfield is a novel identifier that is comprised of significant sections to distinguish GL account numbers and thing numbers. Key Flexfields are typically put away in SEGMENT1...SEGMENTn data set sections.
A few models would be Item No 34H-AFR-223-112.G and GL Account No:
100-00-1000-324-11100.
For a model GL Account, portions could be distinguished as Organization, Cost Center, Account, Product, Product Line.
Q13. Where Do You Maintain Database Customizations?
You can keep up with all your table changes by making another construction. You can utilize your custom application short name (like XXPO) as your Oracle blueprint name for simple recognizable proof. The new pattern should be enlisted in the Oracle AOL.
Q14. What Is A Concurrent Manager?
A Concurrent Manager is a part of simultaneous handling that screens and runs demands while you work on the web. When the client presents a solicitation to run the work, the data is put away in the solicitation table. A simultaneous chief gets the data from the solicitation table and executes the predefined simultaneous work.
Q15. How Do You Make Your Own Query When You Are In Forms Query Mode?
You can utilize a placeholder to accomplish this. In the event that you enter a solitary colon ( : ) in one of your question fields during the Enter Query mode, Oracle Forms Run Query will provoke you to enter the text of SQL Where statement.
Q16. How Would You Identify The Results Of The Request In The Concurrent View Requests Window?
At the point when a simultaneous occupation is submitted, Applications makes a Request ID. You can utilize this Request ID to see the outcomes.
Q17. What Is A Document Sequence?
A report grouping doles out interesting numbers to the records (footings) produced by Oracle Applications. For instance, each receipt has its own novel receipt number and each buying archive has its own one of a kind buy request (PO) number.
Q18. What Is Token?
Use to trfer values to report developer and it isn't case delicate.
Q19. When Do You Use The Custom Library?
You can involve the CUSTOM library in an assortment of cases. You can utilize it to consolidate Zoom rationale, rationale for conventional occasions, rationale for item unambiguous occasions, and to add sections for the extraordinary menu.
Q20. Could You at any point Create Extensions To Oracle Applications Without Modifying The Standard Form Code?
Indeed. This should be possible utilizing the CUSTOM library, which is an Oracle Forms PL/SQL library. You can coordinate your custom code straightforwardly with Oracle Applications without making changes to your Oracle Applications structures code. The CUSTOM library is situated in the $AU_TOP/res/plsql registry. When you compose the code, you arrange and create the CUSTOM methodology to roll out your improvements.
Q21. What Is Us Folder In The Custom Top?
It is a language explicit organizer used to store the G.U.I like reports and structures.
Q22. Which Schema Has Complete Access To The Oracle Applications Data Model?
The APPS composition. AutoInstall naturally sets the FNDNAM climate variable to the name of the APPS construction.
Q23. Characterize Request Group?
A solicitation security bunch is the assortment of solicitations, demand sets, and simultaneous projects that a client, working under a given liability, can choose from the Submit Requests window.
Q24. What Is Meant By Concurrent Program?
It is only Instance of the execution alongside boundaries and Incompatables. Here Incompatables only assuming we are submiting cc projects on the off chance that any one can be execute in those program , which programs r not pixie yet this time we will specify those projects in incompatables tab.
Q25. What Is Meant By Custom Top And What Is The Purpose?
Custom Top is only Customer Top, which is made for client as it were. we can have numerous custom tops in light of client prerequisite. It is utilized to store created and altered parts. at the point when prophet corp applying patches it will supersede on every one of the modules aside from custom top. that is the reason we will utilize custom top.
Q26. What Are The Main Prerequisites For Creating A Custom Application Or Responsibility?
Set up an index structure for a custom application, and characterize a climate variable that trlates to your application base way.
Q27. Where Did U Find The Application Short Name And Basepath Names?
select basepath,application_short_name from fnd_application from the backend. From the from end we can get it Navigation Application Developer.- - - - - > Application- - - - >Register The application name we will get from FND_APPLICATION_TL
Q28. Contrariness In Report Registration And Run Alone?
Recognize programs that shouldn't run all the while with your simultaneous program since they could disrupt its execution.You can determine your program as being incongruent with itself.
Application: Although the default for this field is the utilization of your simultaneous program, you can enter any legitimate application name.
Name: The program name and application you determine should interestingly recognize a simultaneous program. Your rundown shows the easy to understand name of the program, the short name, and the depiction of the program.
Scope: Enter Set or Program Only to determine whether your simultaneous program is zincompatible with this program and all its kid demands (Set) or just with this program (Program Only).
Run Alone: Indicate whether your program ought to run alone comparative with any remaining projects in a similar consistent data set. Assuming that the execution of your program disrupts the execution of any remaining projects in a similar consistent data set (at the end of the day, assuming that your program is contradictory with all projects in its legitimate data set, including itself), it ought to run alone.
Q29. What Are The Required And Optional Steps For Setting Up Flexfields?
The expected advances are as per the following: characterize the worth sets, characterize the designs, and characterize the qualities, if necessary. The discretionary advances are as per the following: characterize the security rules, characterize the cross-approval leads, and characterize the shorthand false names, if vital.
Q30. What Is The Diff Between Apps Schema And Other Schemas?
Applications diagram contains just Synonyms we can't make tables in that frame of mind as other blueprint s contains tables, and every one of the items. Here just we will make the tables and giving awards on made tables. Practically all every time we will associate with applications pattern as it were.

