E-Business Essentials

The company has two local administrators in separate locations. They need to ensure that only a relevant set of users is visible to each of these local administrators. Which action will meet the requirement?
Create a separate role for each local administrator

Which tier(s) in Oracle E-Business Suite is responsible for storing application data?
Application tier only

If the scenario is:
* X is a legal entity defined in a multilevel company structure.
*There are three Operating Units A, B, and C rolled into it.
*Paul, an assigned user of Oracle Payables, logs in from the Oracle Payables
responsibility and is able to see information that is relevant to Operating unit A.
* The MO:Operating Unit profile option has been set.

All transactions created by Paul are automatically assigned to Operating Unit A.
The Oracle Payables responsibility is associated with an organization classified as Operating Unit A.
The Oracle Payables responsibility is linked to the Operating Unit A by the MO: Operating Unit profile option.

Actions to be taken after defining a structure but before entering values.
1. Select the "Freeze Flexfield Definition" check box.
2. Save your changes before freezing the flexfield definition.
3. Submit a request to build the structure view by selecting the "Compile" button.

A Balancing entity is a:
1. A Legal Entity may comprise one or more than one balancing segments.
2. It is represented as a balancing segment value in the accounting flexfield structure.


Flexfields in 11iOracle Applications:
1. Flexfields consist of segments.
2. Flexfields are used only in Oracle Financials suite of products.

ASC Corp decides to implement Oracle Receivables, Oracle Payables, and Oracle
Purchasing. To access any of these applications, a user must be given access to a
responsibility associated with which type of organization?
An Operating Unit

Shared entities:
1. Enable one-time definition of objects
2. Are referenced by several Oracle Application modules
3. Are owned by a single Oracle Application module for table purposes only
Explanation: Shared Entities are not formally defined as such within any single products user's guide. You will find as you implement multiple products that the same entity is referenced by multiple products

Can a menu be copied?
No

The accounting flexfield of ABC Corp is: Company.Department.Account.Cost Center. Then-
1. Company is a segment in the combination.
2. The account code combination is a key flexfield.
3. The account code combination is a key flexfield as well as a descriptive flexfield.
4. Existing values for the accounting flexfield appear as a concatenated value having
segment separators.


If a user profile option value were to be changed, when would the change take
effect?

1. as soon as the user logs in
2. as soon as the user changes responsibility
3. when the Administration server is restarted
4. as soon as the system administrator exits the instance


As a system administrator, you need to provide additional reporting and summarized information to some of your application users. How would you do this?

1. by using Menus
2. by using Data Groups.
3. by using Request Groups


Can a defined profile value be referenced anywhere in Oracle Applications?
Yes



Event Manager enables you to register subscriptions for events that are significant to an 11iOracle Application instance.


To run reports across organizations in a multi-org environment, the MO: Top Reporting Level profile option should be set at which level?
Legal Entity level or Set of Books level


ASC is in the business of manufacturing cosmetics. It obtains and pays for raw
materials. Which business flow in Oracle E-Business Suite would map to the above activities?
Demand to Build
Explanation: Procure to Pay, since in other options making payments are not covered


Demand to Build: Advanced Supply Chain Planning (ASCP)/Material Requirements Planning (MRP) Create constraint-based or optimized plans, create requisitions (purchase or internal) to
replenish Inventory
Cost Management: Supply cost information for optimized planning
WIP: Use discrete, project, repetitive, assemble-to-order, work order-less, or a combination of
manufacturing methods. Inquiries and reports give you a complete picture of
transactions, materials, resources, costs, and job and schedule progress.
Capacity: Calculate your capacity load ratio by resource or production line. Ensure that you have sufficient capacity to meet your production requirements.
BOM: Store lists of items that are associated with a parent item and information about how each
item is related to its parent


Ownership of shared entities?

1. Set of books is owned by Oracle General Ledger; Locations is owned by Oracle Human
Resources.
2. Suppliers is owned by Oracle Purchasing; Units of Measure is owned by Oracle
Inventory.

ASC has set up the Asset Category key flexfield. It has also set up a descriptive flexfield to store vehicle information associated with the asset category "Vehicle." Identify two correct statements.

The Asset Category flexfield is owned by the Oracle Assets module.
The descriptive flexfield is associated with tables in the Oracle Assets module.

Explanation: While most Oracle Applications products require that you set up
particular key flexfields, many descriptive flexfields are optional.


Parameters in a Daily Business Intelligence Report.

1. They are based on responsibilities.
2. The Primary Dimension parameter is different for each page in a Daily Business
Intelligence report.


Oracle Workflow.
1. each activity can be a PL/SQL function or a notification or a subprocess
2. can integrate business processes within an enterprise as well as between different organizations and different systems


"None" value set.
1. It has an approved list of values associated with it
2. Users can enter any value that they want even if it does not meet formatting
requirements.


Oracle E-Business Suite.
1. It can run entirely on the Internet.
2. A minimum of two modules need to be implemented for an organization.
3. It supports multi-directional flows of business information within an organization.


ASC is installing 11iOracleApplications on two nodes: A and B. On Node A, it has installed the Forms server, Web server, and Administration server. On Node B, it has installed the Concurrent Processing server. By default, on which node would the reports server be installed?
Node B


Oracle Workflow engine does not
1. generates a history of the items
2. is embedded in the Oracle database
3. maintains the state information for a workflow item


Explanation: The workflow engine is a set of tables and PL/SQL stored procedures that manages the execution of a workflow process and tracks work in process. It maintains the state information of a workflow item and generates a complete history for the item (including an audit trail). It executes workflow rules and functions (PL/SQL stored procedures) automatically


An activity in a workflow process can be a PL/SQL function, a notification, a subprocess, or a business event


Determining the size of a value set
1. Your value set size must be less than or equal to the size of the underlying segment
column in the flexfield table.
2. Choosing the maximum size for your value set depends on which flexfield you plan to
use with your value set.


Sequence for enabling multi-org:
1. Define Organization Structure
2. Convert to Multiorg
3. Perform Setups unique Operating Unit.


Explanation: Basic Steps to Enable Multi-Org : Define rganization structure Convert to Multi-Org Perform setups unique to each operating unit ie. Financials options, customer address setup, supplier site setup, bank accounts)


How are code combinations of a key flexfield stored?

1. There is one column for every key flexfield segment.
2. They are stored in a database table called a code combinations table.
3. Each unique combination of segment values is identified by a unique ID value stored in a
unique ID column.


Workflow Monitor

1. enables users to view their own workflows
2. displays status information for the process instance
3. enables administrators to perform control operations0
4. enables you to search for a workflow process instance


In Permanent Persistence values in Workflow purging : Items are deleted only when forced.


ASC has shipped goods against purchase orders to ASC. ASC now has to pay for the goods received, and also account for and reconcile the transaction. Which are the 11i Oracle Application modules involved in these activities for ASC?
1. Cash Managment
2. Order Management
3. Purchasing


Two required components of a responsibility.
1. Menu
2. Data Group


The organization classification that is a segment value in the Accounting flexfield
structure. : Balancing Entity


Exception is a specified condition found during an alert check.


ASC has implemented Oracle Manufacturing applications. How is the data in
these applications partitioned? - by Operating Unit


Identify three features of a value set.

1. The same value set can be shared between different flexfields.
2. Value sets control the values for many of the report parameters.
3. A value set is a definition of the values approved for entry by a particular flexfield
segment.


Can you create an application user with start and end dates that are earlier than the current date?

Yes, the login can be created, but it will not work.


Can you create an application user with start and end dates that are earlier than the current date?

No, the login cannot be created with start and end dates that are earlier than the current
date.

ASC is running on 11i Oracle Applications and wants to ensure that supply records of one supplier are not visible to another supplier. Which action will meet the requirement?

By assigning the same attribute value forVENDOR_CONTACT_ID


Subscription processing.
1. Sends event information to a workflow process
2. Include the task of executing custom code on the event information


A table-validated value set
1. A table-validated value set has no list of approved values associated with it.
2. Table-validated value sets obtain their lists of approved values from existing application tables.
3. A table-validated value set enables you to use your own application tables as value sets
for flexfield segments.


In order for organizations to post to the same set of books, at a minimum they must share the same accounting flexfield structure


Explanation: Those key flexfields that allow multiple structures may use different mechanisms to determine which structure a user sees. For example, the Accounting Flexfield uses multiple structures if you have multiple sets of books with differing charts of accounts. Your forms determine which Accounting Flexfield structure to display by using the value of the GL_SET_OF_BOOKS_ID profile option associated with your current responsibility


Three features of key flexfields.
1. They are used as identifiers for entities.v
2. The structure is comprised of segments.
3. Each segment of a key flexfield will usually contain meaningful information


ASC wants to track and analyze call volumes in its enterprise call centers. Which Daily Business Intelligence product can help achieve this objective?
Interaction Center Intelligence


Which three options are determined by a responsibility in Oracle Applications?
1. Accessible Reports
2. Accessible Applications
3. Associated Set of Books

Functions and menus.
1. Functions can be excluded at any level.
2. Excluding a menu excludes all its child functions
3. Excluding a menu excludes all the functions and menus nested in that menu.

Three types of regions in Daily Business Intelligence
1. Link
2. Parameter
3. Key performance indicator

Explanation: Region: A region is a container for a unique set of information on an dashboard. There are five different types of regions in Daily Business Intelligence: table, graph, parameter, KPI, and links.


A Global segment:
1. It is implemented in descriptive flexfields.
2. It uses the same column for all rows in the table.
3. It is a segment that always appears regardless of the context.


The interaction between the Notification System and the Workflow Engine?

1. The Workflow Engine sends information to the Notification Mailer program, and then informs the Notification System about this communication.
2. The Workflow Engine informs the Notification System to deliver notifications to a user if
an activity requires human intervention.


Prerequisites for viewing notifications through Oracle Workflow Web pages.

1. You must have a Web browser that supports frames and JavaScript.
2. Oracle HTTP Server should be installed as the Web server for workflow.

What would happen if you try saving an existing menu under a different name?
The new menu will overwrite the original menu.

Features of Multi-Org.
1. The data can be logically partitioned.
2. Users can be assigned to specific organizations.
3. It defines organizations and the relationships between them.
4. It enables at most two business units to use a single installation of Oracle Applications.


Four business process integration requirements that can be addressed by Oracle Workflow.
1. Point-to-point system integration
2. System integration messaging hub
3. Distributed applications messaging
4. Business event-based workflow processes

Three features of Oracle Workflow builder
1. Saves workflow definition as a flat file
2. Defines and customizes workflow definitions
3. Has Navigator tree and Process diagram as its components


Flexfield structure describes a group of segments.


As a system administrator, you have to set a profile option specific to an operating unit. Which Profile Hierarchy Level would you choose : Organization Level

Which three tasks do alerts perform?
1. Send an e-mail message.
2. Submit a concurrent request
3. Run an operating system script

Three features of Daily Business Intelligence
1. Provides a cross-enterprise reporting capability
2. Creates a separate subset of transactions in a new database
3. Provides planning, execution, and reporting capabilities to optimize business performance

A region is a container for a unique set of information on an Daily Business Intelligence
overview page.

Explanation: Region: A region is a container for a unique set of information on an dashboard. There are five different types of regions in Daily Business Intelligence: table, graph, parameter, KPI, and links.
Reports: You can drill to a report from any linked value in a dashboard. In general, reports
contain detailed information on one or more KPIs. Reports contain graphs and a table region and
they contain more parameters than a dashboard. Reports do not contain truncated values. You
can drill from some reports directly into the transactional system.
KPI: A KPI is a strategic business factor used for reporting. KPIs are designed for comparing and judging performance on strategic business factors such as Revenue or Operating Margin. Each dashboard contains a set of KPIs that the content of the dashboard is based on. For example, the Revenue and Expenses KPIs serve as the basis for the Revenue and Expense regions and reports.
Dashboard: A dashboard is a collection of content that is designed to meet the needs of a
particular responsibility. Dashboards contain parameters, regions, and Key Performance
Indicators (KPIs)

At which level can you exclude a function from a responsibility?
Menu level, submenu level or function level

Oracle Application Security layers from bottom to top: Function Security, Data Security, and Role Based Access Control

Oracle Workflow and/or Oracle Alerts:
1. Workflow can support complex conditional logic.
2. Alerts can wait for a user response either through email or through a Web page.

Securing Attributes:
1. Is defined at the responsibility level
2. Specifies access to database rows
3. Specifies the database column which the security would be based on in a Web inquiry

Explanation: You may assign any number of securing attributes to the responsibility.Securing attributes are used by Oracle HTML-based applications to allow rows (records) of data to be visible to specified users or responsibilities based on the specific data (attribute values) contained in the row.

Two descriptive flexfield components whose values are used to determine contexts.
1. Context field
2. The Reference field