Top 31 Oracle E-bussiness Suite Interview Questions
Q1. E-enterprise Suite Architecture Has Many Other Components Aside From The Primary Components, What Are Some Of The Other Components Which Is Part Of The E-enterprise Suite Architecture?
Some of the opposite additives are:
network infrastructure,
servers,
routers, and
load balancing devices.
Q2. A Concurrent Program Starts To Run Based On What Criteria?
A concurrent application begins to run based on when the run is absolutely scheduled to begin, whether or not or no longer the concurrent software has been placed on hold, depending on whether this system is compatible to run with other packages or now not, and the priority of the request.
Q3. The :block.Discipline Mechanism Is Used For? What Happens If This Mechanism Is Used In Your Value Sets?
This mechanism is best used for backward compatibility; in case you use the :block.Discipline mechanism in your fee units, your value units will not be well matched with destiny releases of Oracle Applications.
Q4. What Is Oam, And What Does This Application Provide?
OAM stands for Oracle Applications Manager, and presents help with patch control.
Q5. If After Cloning, All Of The Concurrent Managers Did Not Start, How Would You Resolve The Issue?
To solve this problem, you would need to prevent all the middle tier services to encompass the concurrent managers. Then you would need to prevent and restart the database, last however not least you would join SQLPLUS as APPS user and run EXEC FND_CONC_CLONE.SETUP_CLEAN; COMMIT; EXIT;
Q6. How Many Access Control Layers Do You Have Within Oracle Applications?
There are six access manage layers, the first three layers of the stack are referred to as core security; the first layer is function security, that's the base layer of the security stack, the second one layer is records protection, and the 0.33 layer is position-based totally get entry to control (RBAC). Layer four-6 is known as the administrative capabilities; the fourth layer is called delegated administration, the fifth layer is provisioning capabilities and the sixth layer is known as self-service and approvals.
Q7. When The Priority Of A Concurrent Request Is Set; Who Is Responsible For Setting Up The Concurrent Request, And By Using What User Profile Option?
The device administrator is the only liable for putting the concern of a concurrent request. The Concurrent:Priority user profile alternative is what is used when placing the priority of a concurrent request.
Q8. Why Does Oracle Use Advanced Shipment Notice (asn)?
ASN is what's utilized in Oracle, which facts the traction that has been obtained into inventory. Once that happens a logical shipping traction happens, then the trfer of titles happens, and the clients bill is generated. The providers’ invoice can then be processed once the invoice for the client has been generated.
Q9. Which Three Oem Components Must Be Installed, To Manage The Forms Server?
The three OEM additives, which have to be established, are:
The OEM Management Server,
The OEM Console and
The OEM Agent.
Q10. What Is Oracle Alert?
Oracle Alert, allows you to view the critical activities in your database right now.
Q11. There Are Six Types Of Sql Statements, Name Them.
The SQL Statements are:
Data Definition Language (DDL) Statements,
Data Manipulation Language (DML) Statements,
Traction Control Statements,
Session Control Statements,
System Control Statements and
Embedded SQL Statements.
Q12. What Is Atp? What Support Does The Atp Provide?
ATP me Available to Promise; and has the potential to distribute from an present inventory or backorder, to the brand new stock. Once every order object has been ordered, then an expected availability time is given.
Q13. What Is The Default Structure Name For All Descriptive Flexfields (dffs)?
The call for the default structure is called Global Data Elements.
Q14. What Configuration Takes Place When The Concurrent Processing Nodes Are Load Balanced?
This kind of configuration, which takes vicinity while the Concurrent Processing Nodes are load balanced, is referred to as Parallel Concurrent Processing.
Q15. Why Does Oracle Recommend Running The Concurrent Processing Node On The Application Tier?
Because of fast community connectivity between the Concurrent Processing Node, and the Database Node, Oracle shows the Concurrent Processing Node run on the utility tier, while earlier than Oracle cautioned the Concurrent Processing Node run at the equal tier as the database node.
Q16. How Many Program Library Types? Name The Library Types?
There are two program library sorts, which might be concurrent library and traction library.
Q17. How Many Primary Components Make Up The E-commercial enterprise Suite And Name Them?
There are five primary components which make up the E-Business Suite. The additives are:
the patron,
bureaucracy server,
net server,
concurrent processor and
The Oracle database.
Q18. Recommended By Oracle, What Is The Suggested Number Of Tiers The Architecture Should Have And Why?
Two-tier structure is the encouraged wide variety of levels at a minimum to be ran on Oracle Applications, because with single tier architecture, contention can appear among the utility and database processing, causing performance degradation.
Q19. What Are The Key Flexfields That Are Only Used In Oracle Applications By The Accounting Flexfield And No Other Flexfield?
The key flexfields are
discern,
rollup group,
hierarchy stage, and
section qualifier facts.10
Q20. Name The Products In The Oracle E-enterprise Suite Technology Layer?
The merchandise in the era layer are:
Oracle Application Object Library (FND),
Oracle Applications DBA (AD),
Oracle Common Modules (AK),
Oracle Applications Utilities (AU),
Oracle Workflow (WF),
Oracle Alerts (ALR), and
Oracle Applications Framework (FWK).
Q21. When Setting Up A Profile Option, Most Profiles Use The Security Hierarchy Type. What Are The Four Levels At Which These Profile Options Can Be Set At Going From The Lowest Level, To The Highest Level
The four ranges are:
Site which is the bottom stage,
Application
Responsibility
User (maximum degree).
Q22. Name The Pre-described Type Alerts?
There are pre-described kind signals. Their names are periodic signals, and event indicators.
Q23. How Would You Define Edi?
EDI stands for Electronic Data Interchange; EDI lets in enterprise documents to be trferred electronically between companies computers structures, over a conversation community.
Q24. What Is The Purpose Of Purging Trient Data, Which Is Stored In An Oracle E-commercial enterprise Suite System?
When you purge facts which isn't always wished periodically, it helps lower backup instances, reduces downtime when machine enhancements are wished, as well as enhance machine performance and increases garage performance.
Q25. Difference Between Appl_top Directory And The Common_top Directory?
The COMMON_TOP Directory consists of all documents and directories used by all software products, while, the APPL_TOP directory consists of all product files and directories, to encompass all middle era files and directories, and the utility context file and environment documents.
Q26. What Are The Seeded Business Events In The General Ledger?
The seeded enterprise activities are:
Period Re-opened,
Journal Import Completed,
Account Disabled,
Period Opened,
Period Closed,
Journal Import Started,
Posting Completed,
Secondary Ledger Deleted,
Reporting Currency Deleted, and
Accounting Setup Completed.
Q27. What Are The Steps To Enable The Shorthand Entry Feature?
First you would go to the shorthand aliases window, you would then choose the call and shape of the important thing flexfield, and thirdly you would want to test the enabled check field located inside the shorthand area after which input a activate for the shorthand window. After you whole those steps, you would enter the most alias length, after which shop your adjustments.
Q28. The Startup Threshold For Concurrent Managers Is Defined By Which Two Profile Options?
The two profile options, which outline the startup threshold for concurrent managers are:
CONC:Manager Startup Threshold Limit and the
CONC:Manager Startup Threshold Time (minutes).
Q29. In Oracle There Are Background Processes, Which Processes Are The Most Important?
The heritage strategies in Oracle which might be maximum crucial are:
SMON (System Monitor Process),
PMON (Process Monitor Process),
DBWR (Database Writer or Dirty Buffer Writer Process),
LGWR (Log Writer procedure), and
ARCH (non-compulsory archive process).
Q30. How Many Life Cycle Stages Or Phases Does A Concurrent Request Have? Name The Stages?
The lifestyles cycle tiers or stages that a concurrent request goes through is 3, but might be as many as four. The lifestyles cycle degrees, also referred to as levels are:
pending,
strolling,
completed, and
inactive
Q31. What Is The Scope Of Oracle E-business Suite?
The scope of Oracle E-Business Suites is to offer their customers with an off the shelf solution, which permits companies to manipulate all factors of business.
