Oracle Apps( EBS) Interview Questions and Answers Part 5

Oracle Apps( EBS) Interview Questions and Answers Part 5:--

QUESTION 49. Define ERP( Enterprise Resource Planning)?


Solution: ERP is a software system that's available as a package and can be helpful in automating as well as integrating utmost of the processes


associated with the business.


QUESTION 50. What's a datalink?


Solution: Datalink can be made habituated for the purpose of relating the Solution:s that are associated with colorful different queries.


QUESTION 51. Define Database links?


Solution: A pointer defining a one-way communication connection between an Oracle Database garçon and another database garçon is called a database link. In reality, a data wordbook table item defines a link pointer. You have to be linked to the original database in order to break the link,includes the wordbook entry for the data.


QUESTION 52. Why Database Links?( case urls)


Solution: The great advantage of database links is that they allow druggies to pierce another stoner's objects in a remote database so that they're bounded by the honor set of the object proprietor. In other words, a original stoner can pierce a link to a remote database without having to be a stoner on the remote database


QUESTION 53. How can the value of a parameter be obtained based on the first parameter?


Solution: Alternate parameter can be attained by making use of the first parameter by making use of the command$ flex$ value set name.


QUESTION 54.How to produce a link to a General Ledger database?


Solution:


creating a General Ledger database link


1. Open the Define Database Links dialog box.


2. Type in the linked database's name and optional description.


Additionally, you need to provide the FSG Transfer software with the Database Name.


The following query can be run in the source database to obtain the database name.


SELECT value FROM v$ parameter


WHERE UPPER( name) = 'DB_NAME';


3. Enter the following fresh information for the database.However, ask your System director, If you don't know what to enter.


Link the String The General Ledger database is referenced by the network connect string. sphere Name: This connection relates to the sphere of the remote General Ledger database.


You can find the sphere name by executing the following query in the source database


SELECT value FROM v$ parameter


WHERE UPPER( name) = 'DB_DOMAIN';


APPS Username The name of the Oracle Applications regard that has read access to the General Ledger database tables. Note that this isn't the username you enter to login to Oracle Applications.


APPS word The word for the below username. Note that, for security reasons, when you enter the word General Ledger will display asterisks rather of the factual characters in the word.


See Creating Database Links( Oracle 7 Garçon SQL Reference, Release7.3)


4. Save your work.


QUESTION 55:How to cancel a database link?


Solution:


To cancel a database link


1. Navigate to the Define Database Links window.


2. Query the database name you want to cancel.


3. Choose cancel Record from the Edit menu.


4. Choose Yes to cancel the database link.


QUESTION 56. Define data group?


Solution: An Oracle Applications list with the ORACLE usernames linked to each action is called a data group. A customized function be created and it can be registered with Oracle Applications, given an ORACLE username, and added to a data group using Oracle operation Object Library.


QUESTION 57. Explain about security attributes?


Solution: Security attributes can be made used by Oracle for allowing the particular rows containing data visible to the druggies.


QUESTION 58. Define about Profile Option?


Solution: Profile option comprises of set of options that are helpful in defining the appearance as well as geste


of the operation.


QUESTION 59. Explain about operation?


Solution: operation can be defined as the set of menus, forms and functions.


QUESTION 60. Where do we useCustom.pll?


Solution:Custom.pll can be used during the process of making customized or new mystic forms.


QUESTION 61. Where are tables created?


Solution: Tables can be created at custom schema.


QUESTION 62. Define multi org?


Solution: This is a kind of functionality for data security.


QUESTION 63. Define Request Group?


Solution: Request group is assigned with a set of liabilities.


QUESTION 64. What's the operation of the spawned object?


Solution: spawned object is used for process associated with executable field.


QUESTION 65. HOW DO THEY DIFFER APPS SCHEMA IN CONNECTION WITH OTHER SCHEMAS?


Solution: Apps schema is the bone


that comprises of only antonyms and there's no possibility of creating tables in it. Other schema comprises of


tables and objects in it and allows the creation of tables as well as for furnishing subventions to tables.


Apps is a universal schema, it has antonyms to all base product tables and sequences. This also has law objects for all products


triggers, views, packages, antonyms etc).


APPS SCHEMA DOESN'T CONTAIN DATABASE OBJECTS, IT CONTAINS ONLY SYNONYMSAND THIS SCHEMA WILL HAVE THE RIGHTS TO ACCESS OTHER SCHEMA DATABASE OBJECTS.


QUESTION 66. HOW TO ISSUE COMMIT INSIDE OF A CONTROL train?


Solution: WE CANN'T ISSUE THE COMMIT INSIDE OF THE CONTROL train, rather OF THAT WE WILL USE AUTO COMMIT in USING' ROWS COMMAND'. IF WE SPECIFY ROWS


FOR EVERY RECORDS COMMIT WILL BE EECUTED.