Basic Oracle Fusion Financials Interview Questions

 

1. What exactly does Oracle mean by ‘Fusion’?

Oracle Fusion Applications is the name of new business software applications that generally came to be available in October 2011. The market started talking about fusion applications many years ago. Oracle also adopted the name fusion which is adopted by every Oracle application by simplifying all the media server layers for running functionality of varied kinds. The shift in the way people work needed to be reflected in enterprise application solutions. 

2. Why did Oracle decide to build a new product from scratch?

Oracle decided to start from zero where the one reason behind it is that Oracle needed to define a development roadmap for all of the ERP systems it owns. Well, this might not have been the most important reason; it was far from the only reason. Another is that today many organizations are embracing service-oriented applications and they want industry-standard application platforms and ERP systems needed to adapt to it.

Businesses are evolving into the new, more social network environments the company sees their employees are connected through chat, social networking sites, online communities, and also sort of capabilities that are used for our personal lives on a daily basis.

3. What are Oracle Fusion Apps Goals?

It has been significantly observed that it has been used in new standards for innovation, work, and adoption respectively. Building a product on an open standard allows the organizations to lower cost by having commonly available skills in the marketplace.

Lower the risk of integration with other applications which in turn makes it easier to configure, maintain, and protect all your configurations during the upgrades. Companies have to adapt to the challenges of the market and the configurations of the current systems that are hard to change in the fast environment.

If you want to enrich your career and become a professional in Oracle Fusion Financials, then enroll in "Oracle Fusion Financials Training" - This course will help you to achieve excellence in this domain.

4. What is Oracle Fusion Middleware?

Oracle Fusion Middleware is a foundation for innovation built to improve efficiency by providing agility. This seeks to provide help for carrying out the business on a digital platform significantly. The entire process ensures high performance, agility, longevity with reliability at any scale respectively.

This will also eventually help in lowering the cost of the organization to experience more productivity at work respectively. They dynamically provide a cutting-edge solution for the betterment of business growth in a significant way.

5. What Are Choices Recommended As Far As Adopting Fusion Applications?

The application helps to run and manage every program irrespective of software and hardware in an efficient way. To configure a business systematically and strategically the middleware act as a key driving component to a large extent considerably. Therefore, the key components include are Business Intelligence, User Interaction, Application Grid, Content Management, and many others in a wider spectrum respectively.

6. Are Oracle Fusion Applications Available for Purchase?

Oracle Fusion Application is highly available for the customer’s purchase in every marketplace respectively. The customers can easily buy and upgrade it on a specific time period according to its choice of preference. The entire process needs to be done under Oracle Authorized Certification for all such migration/purchasing programs. The Oracle authority will solely review and study the customer’s preferences in its initial release.

7. Did Anyone Deployed Fusion, And How Exactly Are They Doing?

It has been noted so far only one such successful incident was solely announced by Oracle Press Release.

8. What Is the Early Adopter Of Oracle Fusion Applications?

There are various services under the early adopter program which include:

• The Oracle solely handles service requests.
• They assemble meetings for a required project and also organized special training of system integrators.
• It also looks into the customer’s requirements and tries to figure out to meet their needs responsively.
• They also provide customer support both before and after go-live.

9. Are Oracle Fusion Applications A Replacement For The Existing Oracle Applications, Such As Oracle E-business Suite, Peoplesoft Enterprise, Oracle's Jd Edwards Applications, And Siebel CRM?

It is falsely and wrongly stated as it is a new set of applications in the Oracle Fusion apps. There are widely used in the previous application such as the Oracle E-Business Suite has given the Oracle Fusion concept. Likewise, Siebel has given the CRM concept.

10. What Are Different Available Deployment Options Are Available For Fusion?

The varied deployment options are as follows:

1. Private Cloud
2. On-Premise
3. Public Cloud
4. Hybrid Cloud

11. What Are The Licensing Requirement Of Oracle Fusion Applications?

The official Oracle website contains much of the detailed information about the pricing information as well as the licensing requirements for the buyers. They have covered various areas of the application process such as human capital management, CRM, project portfolio management, and many others in a wider spectrum.

12. How is security for Oracle Fusion Application?

The application is highly secured with widely known features such as:

1. Data Security
2. RBAC
3. Privacy
4. Function Security

Access provisioning and identity management: Eventually for the initial setup the application creates an initial user which is highly recommended and necessary for the entire setup thing. The Oracle Fusion Middleware is integrated through Oracle Fusion Application to make the Oracle IM available. The various possibilities include are user account linking, user identities are managed and programmed, user control is managed, OIM workflow is also managed during the entire procedure significantly. 

Segregation of duties policies: The program is solely responsible for the activity of processing, approving, recording in identifying or prevents the various programming error over data transformation, tools, technologies to access everything in a free-flowing process respectively.

13. How about the data model for Fusion?

1. The global organization required a flexible enterprise structure with the help of logical stripping data.
2. The various bunnies units look after and manage the transaction data respectively.
3. Sets of codes can be used for various business units.
4. It solely uses a hierarchy model to offer flexibility in carrying out the business process in an organized way.

14. Does Fusion Application have flex field features?

It is absolutely stated rightly that Fusion Application does have flex field feature which generally features three types:

1. Key Flex fields
2. Descriptive Flex Fields
3. Extensible Flex Fields

These three types of flex fields help in the process of configuring the application for the implementers with the sole support of the Oracle Fusion Applications respectively.

15. What is so special about Fusion User Interface?

The Fusion User Interface is the best of its kind compared to other applications in the market. It is widely used by the customers in the most convenient way which eventually gains huge productivity profit significantly. 

Some of its good features include:

1. The business needs are significantly fulfilled with a role-based dashboard respectively.
2. Bind together the entire worklist significantly.
3. It provides reference information with contextual help.
4. The search experience option with relevant data.
5. Associate keyboard with tagging feature.
6. Person contact information related to your work or task respectively.

Oracle Fusion Technical Interview Questions

16. Is this application is available for download?

The Oracle E-delivery offers to provide only the Beta Version of the application which can be downloaded in general by all users.

17. What is different about Oracle Fusion Applications?

The application is solely used for usability compared to most other applications in the market. It is widely used not for functionality but its key feature is its usability to a large extent significantly. The testing session is done by the great usability team under the Oracle authority. They work as a whole team and emphasis the design pattern, guideline, and scheduling of the work respectively.

Thus, the application could easily carry forward the entire work process with the intelligent user experience.

18. How about the approval Management in the Fusion Application?

In the Fusion Applications, the human workflow is solely managed by the AMX which acts as an assignment manager to model down approval patter based on your work needs and preferences respectively.

19. How about the audit feature in the Fusion Application?

To handle all kinds of work-related tasks the Fusion Application applies the Oracle Fusion Middleware Audit Framework respectively. The accountability of any work process is solely handled by the audit feature significantly.

20. What Are The Other Replacement Feature In Fusion That Makes A Difference To Ebs User?

Some of the few optional features include:

1. OICM is replaced by the Access Control Governor.
2. Date Track is replaced by Date Effectivity.
3. The operating Unit is replaced by the Business Unit.
4. FND User is replaced by the Identity Manager. 

21. What Is Replacement Of Processing Like Concurrent Program Or Concurrent Manager Similar To Ebs In Fusion?

The entire process is built up for scheduling, defining, and running varied kinds of jobs that are eventually run on high demand or run to schedule them for the future.

22. What are the major footprints in Fusion Financial Management?

The Oracle Fusion Application suite consists of an element named Fusion Financial Management. The application helps to access information with real-time intelligence. There are various features that describe Fusion Financial Management are:

1. Asset Management
2. Payments and collection
3. Accounts Payable
4. Cash and Expense Management
5. General Leader
6. Accounts Receivable

23. What are the Major benefits for Ebs Financial Users?

There are several user benefits for Ebs Financial Users that are highly recommended are:

1. Centralized inter-unite setup and processing
2. Shared reference data
3. Flexible cash positioning with multi-level access
4. AP matching with rules-based engine
5. Cash advances and travel authorization
6. Open item reconciliation processing
7. Comprehensive budgetary controls
8. They can see Graphical hierarchies

24. What are the major benefits for Psft Financial Users?

There are several user benefits for Psft Financial Users that are highly recommended are:

1. Advanced Collection
2. Bill Presentment Architecture
3. Cash basis accounting
4. Credit card processor integration
5. Advanced Collection

25. What Is Re-sequencing And Dynamic Routing In Mediator?

It is a process of reordering messages to prevent them from going in the wrong format in the Oracle Mediator. Therefore, it widely acts as a re-sequencing of the jumbled data or message in a sequential way for a better understanding of the work process respectively. Hence, the entire process requires the re-sequencing of the message widely. This entire process is applicable for all operations or a preferable specific operation.

Dynamic Routing act as a running technique to detect the exact routing path to solve the arising problem by re-routing to various other paths or directions.

26. What is Echo in Oracle Mediator?

To make it act or respond to a callable service the echo option is used for such a purpose. It widely helps in the smooth functioning of the Oracle Mediator without the need of a specific route to run the service. The Oracle Mediator is responsible carry out the different functions such as assignment, transformation, scheduling, and many others. This will eventually help to echo the Oracle Mediator back to the application.

27. What is Schematron Validation?

An inbound message can be validated by Schematron Validation. It largely supports Schematron version 1.5 respectively for validating the messages. To validate the XML the Schema language is used considerably.

28. What is File De Batching?

When multiple messages can be found in a single file the user can select to publish its choice of message in a specified number of batches respectively. This entire process is considerably named as de-batching. The files such as native format and XML are supported for de-batching.

Explore Oracle Fusion Financials Sample Resumes! Download & Edit for Free!

29) What is the role of the Oracle Mediator?

Oracle Mediator carries out the key features which act as a key component to deal with callbacks, returned responses, and faults or error issues respectively. The Oracle Mediator works as an intermediator between various services and events for a significant service invocation. Thus, the Oracle Mediator provides services on validation, evaluating, routing rules, and many others. Therefore, the key features of the Oracle Mediator are:

1. Synchronous and Asynchronous Interactions
2. Transformations
3. Header-Based Routing
4. Validation
5. Error Handling
6. Event Handling
7. Dynamic Routing
8. Multiple Part Message Support
9. Java Callouts
10. Oracle Mediator Echo Support

30) What is the foundation for Fusion Application?

The application is basically built on the open standard platform which tends to be very strongly powerful for industrial-leading growth. The application seeks to provide business intelligence, security, searching capability, user interface framework, collaboration, and various others based on the Oracle Fusion Application.

Oracle Apps Technical Interview Questions for Freshers

 

Oracle Apps Technical Interview Questions for Freshers

1. What is Set-of-Books?

Ans: Collection of Chat of Accounts and Currency and Calendars is called SO.

If you want to enrich your career and become a professional in Oracle Apps Technical, then enroll in "Oracle Apps Technical Online Training" - This course will help you to achieve excellence in this domain.

2. How can u call a standard interface program from SQL or pl/SQL code?

Ans:

FND_REQUEST.SUBMIT_REQUEST („PO?,?EXECUTABLE NAME?,,,,PARAMETERS)

3. API for Customer Interface?

Ans:

HZ_CUST_A/C_VZPUB.UPDATE_CUST_A/C
HZ_CUST_A/C_VZPUB.CREATE_CUST_A/C
FND_PROFILES
FND_APPLICATIONS
FND_GLOBAL
FND-FILE
FND_CONCSUB

(can submit conc program in host environment)

4. PL/SQL stored procedure parameters? or what are the two parameters that are mandatory for pl/sql type concurrent program?

Ans: Procedure/function (ERRBUF OUT RETCODE OUT ………………….)

• ERRBUF: Used to write the error message to log or request file.
• RETCODE: Populate log request file with program submission details info.

5. What is a Value Set?

Ans: The value set is a collection (or) container of values.

• Whenever the value set associated with any report parameters. It provides a list of values to the end-user to accept one of the values as the report parameter value.
• If the list of values needed to be dynamic and ever-changing and define a table based values set.

6. What are the validation types?

Ans:

• None: validation is minimal.
• Independent: input must exist on a previously defined list of values
• Dependent: input is checked against a subset of values based on a prior value.
• Table: input is checked against values in an application table
• Special: values set uses a flex field itself.
• Pair: two flex fields together specify a range of valid values.
• Translatable independent: input must exist on a previously defined list of values; translated values can be used.
• Translatable dependent: input is checked against a subset of values based on prior values; the translated value can be used.

7. What is a template?

Ans:

• The TEMPLATE form is the required starting point for all development of new Forms.
• The TEMPLATE form includes platform-independent attachments of several Libraries.

APP SCORE: It contains packages and procedures that are required of all forms to support the MENUS, TOOLBARS.

APPSDAYPK: It contains packages that control the Oracle application's CALENDAR FEATURES.

FNDSQF: it contains packages and procedures for MESSAGE DICTIONARY, FLEX FIELDS, PROFILES, AND CONCURRENT PROCESSING.

CUSTOM: it allows extension of Oracle Applications forms without modification of Oracle application code, you can use the custom library for customization such as zoom ( such as moving to another form and querying up specific records)

8. What are ad-hoc reports?

Ans: Ad - hoc Report is made to meet one-time reporting needs. Concerned with or formed for a particular purpose. For example, ad hoc tax codes or an ad hoc database query

9. What is responsibility?

Ans: Is a collection of menus, request security groups and data groups

• Menus: a collection of forms is nothing but menus
• Request security groups: a collection of programs.
• Data groups: is a group of modules to be made accessible by the user through Responsibility System admin

10. What is Oracle E-Business Suite?

Ans: Oracle apps + analytical components software. (Oracle discover) (Oracle sales analyzer) (Oracle financial analyzer) (Oracle marketing analyzer)

Read these latest Oracle EBS Interview Questions and Answers that help you grab high-paying jobs

11. What is multi-org?

Ans: “Legal entity has more than one operating unit is called as multi-org”

• Business group: Human resources information is secured by the Business group
• Legal entity: inter-company and fiscal/tax reporting, operating unit.
• Operating unit: secures AR, OE, AP, PA, and PO Information.
• Organizations: is a specialized unit of work at a particular locations

12. What is ERP? The architecture of apps?

Ans: A packaged business software system that lets a company automate and integrate the majority of its business processes; share common data and practices across the enterprise; [and] produce and access information in a real-time environment.

13. What is Data Link?

Ans:

• Data links relate to the results of multiple queries.
• A data link (Parent-Child Relation Ship) causes the child query to be executed once for each instance of its parent group.

14. In which tables FF are stored?

Ans:

• FND – ID – FLEX
• FND-ID-FLEX-STRUCTURES 5

15. What is Oracle Applications Architecture?

Ans: Internet computing Architecture is a framework for 3-tired, distributed computing that supports Oracle Applications products.

The Three tiers are

• Database Tier: The database tier manages the Oracle 8i database.
• Application Tier: The application tier manages Oracle Applications and other tools.
• Desk Top Tier: The desktop tier provides the user interface displace.

With internet computing architecture, only the presentation layer of Oracle Applications is on the Desk Top tier in the form of a plug-in to a standard internet brows

Oracle Apps Techno-Functional Interview Questions

16. List of some APIs?

Ans:

FND_PROGRAM.EXECUTABLE
FND_PROGRAM.REGISTER
FND_PROGRAM.PARAMETER
FND_PROGRAM.ADD_TO_GROUP
FND_REQUEST.SUBMIT_REQUEST
FND_PROFILE.VALUE
FND_PROFILE.GET

17. How to get the second parameter value based on the first parameter?

Ans:

$fle x $ value set name.

18. How to call WHO columns into the form?

Ans:

• By using FND_STANDARD API?
• FND_STANDARD.FORM_INFO 6
• Provides information about the form.
• Should be called form when_new_form – instance – instance trigger.
• FND_standard.set_who
• loads WHO columns with proper user information.
• Should be called from PRE_UPDTE and PRE_INSERT
• Triggers for each block with WHO fields
• If this is used FND-GLOBAL need not be called. (FND_GLOBAL.WHO)

FND_STANDARD.SYSTEM_DATE

This is a function that returns a date.

Behave exactly like SYSDATE built-in.

FNID_STANDARD.USER

This is a function that returns varchar2

Behaves exactly like a built-in USER.

19. What are APPCORE API?

Ans:

• APP_COMBO
• APP_DATE
• APP_EXCEPTION
• APP_FIELD
• APP_FIND
• APP_ITEM
• APP_ITEM_PROPERTY
• APP_NAVIGATE
• APP_RECORD
• APP_REGION 7
• APP_STANDARD
• APP_WINDOW

20. what are FNDSQF API?

Ans:

• FND_CURRENCY
• FND_DATE
• FND_GLOBAL
• FND_ORG
• FND_STANDARD
• FND_UTILITIES.OPEN_URL
• FND_UTILITIES. PARAM_EXISTS

21. How to register a table and columns through the back end?

Ans:

• by using the AD_DD package for registering a table
• AD_DD BPI doesn't?t check for the existence of the registered table or column in the database schema, but only updates the required SQL tables.
• It should be ensured that all the tables and columns registered exist actually and have the same format as that defined using AD_DD API.
• Views need not be registered.

22. How to write Function FND_REQUEST.SUBMIT_REQUEST?

Ans:

( 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.

23. What is the reason for not getting any data when a multi-org view is quired?

Ans:

• To get the data correctly, the xxx-ALL must be referenced and the ORG_ID value should be specified to extract portioned data.
• Multiorgan views are partitioned by using ORG_ID.
• So access through multi-org views will not return any roes, as the CLIENT_INFO Value is not set
• Use HR_OPERATING UNITS to identify the organization _id of the OU on which query is based.
• Use FND_CLIENT_INFO package to set the value in CLIENT INPO using set_org_contest.
• Execute fnd_client_info. Set_org_context („?);
• Now querying of multi-org views can be done.

24. How do you find that multiorgan is installed?

Ans:

• Multi-organization architecture is meant to allow multiple companies or subsidiaries to store their records within a single database.
• Multiple organization Architecture allows this by partitioning data through views in APPS schema.
• Implementation of Multi org generally includes more than one business group.
  To know whether multi-org is existing or not
  select multi_org_flag
  form fnd_product_groups)
• If the result is „Y? means the database is the group for multi org

25. What are Handlers?

Ans:

A handler is a group of packaged procedures that are used by Oracle Applications to organize. PL/SQL code in forms.

1. Handlers provide a way to centralize the code so that it becomes easier to develop, maintain, and debug.
2. The packaged procedures available in a handler are called from the triggers by passing the name of the trigger as an argument for the procedure to process.

Handlers are types:

• Item Handlers
• Event Handlers
• Table Handlers
• Business Rules

     3. Handlers reside in program units in the form or in stored packed in the database.

26. What is a Data Group?

Ans:

• A data group is a group of Oracle applications and the Oracle ID's of each application
• Oracle ID grants access privileges to tables in an Oracle Database
• Data group determines which Oracle Database accounts a responsibilities forms, concurrent programs and reports connect to.

27. What is Responsibility?

Ans:

• Responsibility defines Applications Privileges
• Responsibility is a level of authority in Oracle Applications that lets users only those Oracle Applications functions and data appropriate to their roles in an organization.
• Each user has a list of one or more responsibilities and several users can share the same responsibility 22
• A specific application or a set of applications.
• A set of books
• A restricted list of windows that a user can navigate
• Reports in a specific application.

28. What are security Attributes?

Ans: Security Attributes are used by Oracle self-service web Applications to allow rows of data to be visible to specified users' responsibilities based on the specific data contained in the row.

29. What is a Profile Option?

Ans:

• Profile options are the set of changeable options that affect how the application looks and behaves.
• By setting profile options, the applications can be made to react in different ways for different users depending on the specific user attributes.

30. What are the steps involved in developing a flex field?

Ans:

• Designing the table structure
• Creating fields on the form (Visible/Hidden)
• Calling appropriate routines
• Registration of the flex field.
• Definition of the flex field. 

Oracle Technical Consultant Interview Questions

31. What is an application /Module?

Ans: Application is a collection of forms, function, and menus

32. What are the types of Concurrent Managers 25?

Ans: Three MASTER CONCURRENT MANAGERS:

• Internal Concurrent Manager (ICM): This is the one that monitors all other CMs
• Standard Manager (SM): This takes care of report running and batch jobs
• Conflict Resolution Manager (CRM): checks concurrent program definitions for compatibility checks.

We cannot delete a concurrent manager… but we can disable it… but it’s not recommended.

33. What is multi-org setup?

Ans:

Begin dbms_application_info.set_client_info(‘ORG_ID’);
end;

34. What is the relation between Responsibility, Menu, and Request Group?

Ans:

• Responsibility: A responsibility is a set of authority in Oracle Apps that lets users access only that functionality of the application appropriate to their roles.
• Menu: A menu is a hierarchical arrangement of functions and menus of functions that appears in the Navigator. Each responsibility has a menu assigned to it.
• Request Group: it is a collection of reports or concurrent programs. A System Administrator defines report groups in order to control user access to reports and concurrent programs.

Only a system administrator can create a request group.

35. What is a function, how to create one?

Ans: A function is a part of an application's functionality that is registered under a unique name for the purpose of assigning to it to or excluding it from, a menu (and by extension, responsibility). There are several types of functions: – Form Functions, SubFunctions, and Non-form functions. We often refer to a form function simply as a form.

36. What is meant by APPL_TOP?

Ans: An environment variable that denotes the installation directory for Oracle Application Object Library and your other Oracle applications. $APPL_TOP is usually one directory level above each of the product directories (which are often referred to as $PROD_TOP or $PRODUCT_TOP or $_TOP).

37. Explain briefly where are the Customs. all, Forms, Reports, SQL Loader Control files, Shell Script source code, and executables files kept?

Ans:

Custom.pll – $AU_TOP/resource
Forms – $PROD_TOP/Forms/US
Reports – $PROD_TOP/Reports/US
SQL Control Files – $PROD_TOP/Bin
Shell Scripts – $PROD_TOP/Bin

38. When is Custom. pll used?

Ans: Custom.pll is used while making new or customizing standard oracle forms in apps. It contains all the forms of libraries for apps.

39. What are profile options; at what levels can these be set?

Ans: A user profile is a set of changeable options that affect the way the applications run. Oracle Does applications object Library establish a value for each option in a user's profile when the user logs on or changes responsibility.

• System Profile: The profile option can be set for the user community.
• User Profile: Provide Oracle Apps with standard information that describes a user, Application, Responsibility, and site. At each profile level, user profile options can be set.

40. How can you know the form (FMB) name when you open a form in Apps?

Ans: Help

41. Where do you create a table and sequence in Apps? Is it an APPS schema?

Ans: In custom schema and then grant privileges on it to APPS schema.

42. Where are Views and Procedures created?

Ans:

• Views: Views are to be created only in APPS.
• Procedures: In custom schema and the grant it to APPS schema.

43. Can new profiles be created? If so how?

Ans: Yes. Application Developer.

44. What is the approach to create a new form to be used in Oracle Apps?

Ans: The TEMPLATE form is the required starting point of all development of new forms. Start Developing each new form by copying the TEMPLATE.FMB file, located in $AU_TOP/forms/US(or your language and platform equivalent), to a local directory and Rename it as appropriate.

45. Explain the Value Set? Difference between a Table Validated and Independent Value Set?

Ans: A set of values against which Oracle Application Object Library validates values your end-users enter when running your program. You define your value set by specifying validation 28 rules, format constraints, and other properties.

For example, you could define a value set to contain values that are character strings, validated from a table in your application. You can Specify that Oracle Application Object Library uses the same value set to validate different Report parameters. You can also use value sets that you use in your flex fields to validate Your report parameters.

Oracle Apps Technical Interview Questions For 10 Years Experienced

46. How do you create a table-validated value set dependent on another value set?

Ans: Use:

$FLEX$.

in the where condition.

47. How do you set the operating unit context in a report?

Ans:

Begin
Dbms_application_info.set-client-info();
End;

48. Can you submit a concurrent request from the operating system directly?

Ans:

Write a Shellscript.
login to database
Run the function FND_REQUEST.Submit()

49. Explain how to generate a trace file for a pl/SQL concurrent program for tuning?

Ans: Check the? Enable Trace? a checkbox in the concurrent program registration window.

50. How do you “write” to the concurrent request Log and Output file?

Ans:

FND_FILE.PUT(FND_FILE.LOG or FND_FILE.OUTPUT, );

51. What is the difference between the Operating Unit and Inventory Organization?

Ans: Operating Unit: An Organization that uses Oracle Cash Management, Order Management, and Shipping Execution, Oracle Payables, Oracle Purchasing, and Oracle Receivables. It may be a sales office, a division, or an adept.

An operating unit is associated with a legal entity. Information is secured by the operating unit for these applications. Each user sees information only for their operating unit. To run any of these applications, you choose a responsibility associated with an organization classified as an operating unit.

An organization for which you track inventory transactions and balances, and/or an organization that manufactures or distributes products. Examples include (but are not limited to) manufacturing plants, warehouses, distribution centers, and sales offices.

The following applications secure information by inventory organization: Oracle Inventory, Bills of Material, Engineering, and Work in Process, Master Scheduling/MRP, Capacity, and Purchasing receiving functions. To run any of these applications, you must choose an organization that has been classified as an inventory organization.

52. What is a Set of Books?

Ans: A financial reporting entity that uses a particular chart of accounts, functional currency, And accounting calendar. Oracle General Ledger secures transaction information (such as journal entries and balances) by a set of books. When you use Oracle General Ledger, you choose a responsibility that specifies a set of books. You then see information for that set of books only.

53. What is the Item Validation Organization?

Ans: The organization that contains your master list of items. You define it by setting the OM: Item Validation Organization parameter. You must define all items and bills in your Item Validation Organization, but you also need to maintain your items and bills in separate organizations if you want to ship them from other warehouses.

OE_System_

54. What is the difference between key flexfield and Descriptive flexfield?

Ans: Key Flexfield is used to describe unique identifiers that will have a better meaning than using number IDs. e.g a part number, a cost center, etc Dec Flex is used to just capture extra information.

Key Flexfields have qualifiers whereas Desc Flexfields do not. Dec Flexfields can have context-sensitive segments while Key flexfields cannot.
And one more difference that KFF displays like text items but DFF displays like [ ].

55. Which procedure should be called to enable a DFF in a form?

Ans:

ND_DESCR_FLEX.DEFINE (BLOCK => ‘BLOCK_NAME’ ,FIELD => ‘FORM_FIELD_NAME’ ,APPL_SHORT_NAME => ‘APP_NAME’ ,DESC_FLEX_NAME => ‘DFF_NAME’ );

56. Which procedure should be used to make the DFF read-only at run time?

Ans:

FND_DESCR_FLEX.UPDATE_DEFINITION()

57. What is the difference between the flexfield qualifier and the segment qualifier?

Ans: Flexfiled qualifier identifies segment in a flexfield and segment qualifier identifies value in a segment.
There are four types of flex field qualifier

• Balancing segment qualifier
• cost center
• natural account and
• intercompany

segment qualifier:

• allow budgeting
• allow posting
• account type
• control account and
• reconciliation flag

58. Where do concurrent request log files and output files go?

Ans: The concurrent manager first looks for the environment variable $APPLCSF If this is set, it creates a path using two other environment variables:

$APPLLOG and $APPLOUT 

It places log files in

$APPLCSF/$APPLLOG 

Output files go in

$APPLCSF/$APPLOUT 

So for example, if you have this environment set:

$APPLCSF = /u01/appl/common $APPLLOG = log $APPLOUT = out 

The concurrent manager will place log files in /u01/appl/common/log, and output files in /u01/appl/common/out Note that $APPLCSF must be a full, absolute path, and the other two are directory names. If $APPLCSF is not set, it places the files under the product top of the application associated with the request.

So for example, a PO report would go under

$PO_TOP/$APPLLOG and $PO_TOP/$APPLOUT

Logfiles go to

/u01/appl/po/9.0/log

Output files to

/u01/appl/po/9.0/out

Of course, all these directories must exist and have the correct permissions. Note that all concurrent requests produce a log file, but not necessarily an output file.

59. How do I check if Multi-org is installed?

Ans:

SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS
If MULTI_ORG_FLAG is set to ‘Y’, Then its Multi Org.

60. Why does Help->Tools->Examine ask for a password?

Ans: Navigate to the Update System Profile Screen. ( navigate profile system)

• Select Level: Site
• Query up Utilities: Diagnostics in the User Profile Options Zone.
• If the profile option Utilities: Diagnostics is set to NO, people with access to the Utilities Menu must enter the password for the ORACLE ID of the current responsibility to use Examine. If set to Yes, a password will not be required.

61. How an API is initialized?

Ans:

apps.gems_public_apis_pkg.fnd_apps_initialize
( user_id => p_user_id , resp_id => p_resp_id , resp_appl_id => p_resp_appl_id)

62. How do u register a concurrent program from PL/SQL?

Ans:

apps.fnd_program.executable_exists -> To check if executable file exists
apps.fnd_program.executable -> To make executable file
fnd_program.program_exists -> To check if program is defined
apps.fnd_program.register -> To register/define the program
apps.fnd_program.parameter -> To add parameters
apps.fnd_program.request_group -> To add to a request group

63. How do you register a table & a column?

Ans:

EXECUTE ad_dd.register_table( ‘GEMSQA’, ‘gems_qa_iqa_lookup_codes’, ‘T’, 512, 10, 70);
EXECUTE ad_dd.register_column(‘GEMSQA’, ‘gems_qa_iqa_lookup_codes’, ‘LOOKUP_CODE’, 1, ‘VARCHAR2’, 25, ‘N’, ‘N’);

64. What are the supported versions of Forms and Reports used for developing Oracle Applications Release 11?

Ans: The following supported versions are provided in Developer/2000 Release 1.6.1:

• Forms 4.5
• Reports 2.5

65. What is the Responsibility / Request Group?

Ans: Responsibility is used for security reasons like which Responsibility can do what type of jobs etc. Set of Responsibility is attached with a Request group. When we attach the request group to a concurrent program, that can be performed using all the Responsibilities that are attached with the Request group.

66. What is DFF?

Ans: The Descriptive Flexi field is a field that we can customize to enter additional information for which Oracle Apps product has not provided a field.

Ex. ATP program calculates for those warehouses where Inventory Org Type is DC or Warehouse in DFF Attribute11 of MTL_PARAMETERS table.

67. What is multi-org?

Ans: It is data security functionality in Oracle 10.6 and above. Applicable User responsibilities are created and attached to a specific Operating Unit. Users can access the data that belongs to the Operating unit they log in under. 40

The benefit is it enables multiple operating units to use a single installation of various modules while keeping transaction data separate and secure by operating unit.

It has an effect on the following modules:

• Order Entry
• Receivable
• Payable
• Purchasing
• Project Accounting