Apps Complete Interview Questions

(1)

PURCHASE ORDER What are the main tables associated with Purchase Order? There are four main tables associated with Purchase Order.

1. PO_HEADERS_ALL 2. PO_LINES_ALL

3. PO_LINE_LOCATIONS_ALL 4. PO_DISTRIBUTIONS_ALL

1. It contains the Header information for the Purchasing documents. We require one row for each document we create.

Six types of documents that use PO_HEADERS_ALL are a. RFQ b. Quotation c. Standard PO d. Planned PO e. Blanket PO f. Contracts

Important data that are populated in this table are • Buyer Information

• Supplier Information • Brief Notes

• Terms and Conditions • Status of the document

PO number is Segment1 of PO_HEADERS_ALL Important columns: PO_HEADER_ID

2. It stores information about each PO lines. We need one row for each line we attach to a document.

Each row includes a. LINE NUMBER b. ITEM NUMBER c. UNIT d. PRICE e. U.O.M f. QUANTITY

3. It contains the information about PO shipment schedules and Blanket Agreement Price Breaks.

We need one row for each schedule or price break we attach to a document Each row includes

• Destination Type • Requestor Id

• Quantity Ordered and Delivered to Destination

 If the distribution corresponds to a Blanket PO release, PO_RELEASE_ID column identifies this release  We enter distribution information in distribution window accessible through PO window

CLOSING THE PURCHASE ORDER

The CLOSED_CODE column exists in the following three tables 1. PO_HEADERS_ALL

2. PO_LINES_ALL

(2)

IMPORTANT COLUMNS OF PURCHASING TABLES

PO_HEADERS_ALL PO_LINES_ALL PO_LINE_LOCATIONS_ALL

PO_HEADER_ID SEGMENT1 VENDOR_ID VENDOR_SITE_ID SHIP_TO_LOCATION_ID CURRENCY_CODE CLOSED CODE 1. OPEN 2. CLOSED 3. FINALLY CLOSED 4. HOLD 5. FREEZE PO_LINE_ID CATEGORY_ID ITEM_ID PO_HEADER_ID QUANTITY CLOSED_CODE 1. OPEN 2. CLOSED LINE_LOCATION_ID SHIP_TO_LOCATION_ID PO_HEADER_ID PO_LINE_ID QUANTITY_RECEIVED QUANTITY_ACCEPTED QUANTITY_REJECTED CLOSED_CODE 1. OPEN

2. CLOSED FOR INVOICE 3. CLOSED FOR

RECEIVING 4. FINALLY CLOSED

RECEIVING What are the different Purchasing modes in Receiving? There are three modes

1. ONLINE 2. IMMEDIATE 3. BATCH

1. ONLINE: Receipts are processed Online. If there are any errors, they are shown on the FORM itself, and don’t let you IGNORE and PROCEED.

2. IMMEDIATE: Receipts are processed immediately, but no errors are shown. Errors are recorded in REC_TRANSACTION_INTERFACE table.

3. BATCH: Receipts are processed in batch, but no errors are shown. Errors are recorded in REC_TRANSACTION_INTERFACE table.

Note: In all the above two cases, it requires Receiving Transaction Processor to be run periodically. When you SAVE a Received Data in FORM, which tables are UPDATED?

 RCV_SHIPMENT_HEADERS: It contains SUPPLIER shipment header data like Shipment Date, Supplier Name

 RCV_TRANSACTIONS_INTERFACE: It contains RECEIVED data like Item Name, Quantity, and Receiving location

 RCV_SHIPMENT_LINES

 MTL_MATERIAL_TRANSACTIONS_TEMP  PO_LINE_LOCATIONS_ALL

 PO_DISTRIBUTIONS_ALL

What are the major transactions in RECEIVING?  Purchase Order Receipts

 Internal Requisition Receipts

 Inventory Inter-Org Transfer Receipts  Customer Return Receipts

What are the different types of Receiving Routing?  Standard Receipt

 Inspection Required  Direct Delivery

(3)

Note: The Receipt form is used as Receiving materials against PO on Ordered receipts, Internal Requisitions, Inventory Inter-Org Transport and Customer Reports.

RECEIVING OPEN INTERFACE

 ROI is a gateway to IMPORT data from Oracle as well as Non-Oracle applications.  The Receipts done through ROI should be processed in Batch mode only.

 In ROI, the table which are updated are 1. RCV_HEADER_INTERFACE 2. RCV_TRANSACTION_INTERFACE Note: Transactions in ROI

Receipts can be done by Direct Delivery or by two steps namely RECEIVED and DELIVER. This can be determined through AUTO_TRANSACT_CODE_FLAG.

If the value is DELIVERED, the system does a direct delivery into Sub-Inventory and if the value is RECEIVED, the system only receives the material and the delivery is done by the Receiving Transaction Form.

IMPORTANT COLUMNS OF RECEIVING TABLES

RCV_HEADERS_INTERFACE RCV_TRANSACTIONS_INTERFACE RCV_SHIPMENT_HEADERS  HEADER_INTERFACE_ID  GROUP_ID  RECEIPT_SOURCE_CODE  PROCESSING_STATUS_CODE  TRANSACTION_TYPE  ASN_TYPE  INTERFACE_TRANSACTION_ID  GROUP_ID  PROCESSING_STATUS_CODE  TRANSACTION_STATUS_CODE  PROCESSING_MODE_CODE  HEADER-INTERFACE_ID  ASN_STATUS  ASN_TYPE  EDI_CONTROL_NUM

NON-SUPPORTED FEATURES OF ROI  Transactions with LOT controls

 Transactions with SERIAL controls  Internal Transfer & Sales order  Un-Ordered Receipts

Through which you will be able to see ERROR reports in ROI? Receiving Interface Errors Report

Data can be loaded into ROI either through flat files or direct SELECT statement. You can see details of errors from PO_INTERFACE_ERRORS table by joining with RCV_TRANSACTIONS_INTERFACE table using Interface_id.

What do you mean by PO requisition?

 PO requisition is a request to purchase materials for individual requirements. Normally Purchase requisitions are raised by employees or departments.

 Requisitions need approvals. It can be manually created or imported from other system like Inventory, WIP, MRP, OM etc

TABLES USED WITH REQUISITIONS PO_REQUISITIONS_HEADERS_ALL PO_REQUISITIONS_LINES_ALL PO_REQ_DISTRIBUTIONS_ALL The description is the same as PO

OTHER IMPORTANT TABLES USED WITH REQUISITIONS  PO_VENDORS

 PO_LOOKUP_CODES  PO_VENDOR_SITES_ALL

(4)

 PO_AGENTS

 PO_DOCUMENT_TYPES_ALL_B  PO_RESCHEDULE_INTERFACE  MTL_SUPPLY

IMPORTANT FIELDS OF REQUISITION  REQUISITION_TYPE

 PREPARE

 TOTAL_CURRENCY  LINE_TYPE

 CATEGORY

 SOURCE DESTINATION TYPE AND ORGANIZATION ACTIONS PERFORMED WITH REQUISITION

 SAVE  APPROVE

If you SAVE requisition, the above three tables are populated, while if you APPROVE a requisition, major tables updated are

 PO_REQUISITION_HEADER  PO_APPROVAL_LIST_HEADERS  PO_DOCUMENT_TYPES

CLOSING STATUS OF REQUISITION  CANCEL

 FINALLY CLOSED What do you mean by Auto Create?

Auto Create is a standard functionality provided by Oracle to create PO directly from Requisitions. REQUISITIONS IMPORT PROGRAM (RIP)

 It is a concurrent program, which is used to import requisition from Oracle or Non-Oracle system.  Data is first loaded in PO_REQUISITION_ALL table. The RIP can then be run, to import the

records from the interface table as requisition in Oracle Processing.

 RIP creates a requisition line and one or more requisition distribution for each row it finds in the interface table. It then groups these lines on Requisitions according to parameters defined. IMPORTANT TABLES

 PO_REQUISITION_INTERFACE_ALL  PO_REQ_DIST_INTERFACE_ALL  PO_INTERFACE_ERRORS

IMPORTANT PARAMETERS OF REQUISITION IMPORT PROCESS

a. Import Source

b. Import Batch Id

c. Group By

d. Initiate Approval after Import

REPORTS ASSOCIATED WITH REQUISITIONS IMPORT PROCESS a. REQUISITION IMPORT RUN REPORT

We are able to view number of requisitions created and number of records in error from this report.

b. REQUISITION IMPORT EXCEPTIONS REPORT We can see all rows that fail validation from this report What do we mean by Sourcing Rule?

(5)

 Sourcing rule is used to specify preferred Suppliers, Distributors and manufacturers.  Use allocation percentage and ranking for multiple sources.

INTERNAL REQUISITIONS

 It is used to obtain materials within the same Organization or different Organization but within the same set of books.

INVENTORY MOVE ORDER

 It is a request for Sub-Inventory Transferor account issue.

 When using an account transfer, the actual movement is an issue (not physical transfer) from one Sub-Inventory to another Sub-Inventory.

What is the difference between Sub-Inventory transfer and Move Order?

In Sub-Inventory transfer, the material is directly transferred but Move Orders require a REQUEST and an APPROVAL.

How many types of Move Orders are there? Describe. There are 3 (three) types of Move Orders

1. Move Order Requisition 2. Replenishment Move Order 3. Pick Wave Move Order

1. Move Order Requisition: The requisition is a manually generated request for a move order. We must create a move order requisition. You can generate request for Sub-Inventory transfer or account transfers. The requisition can optionally go through an Oracle Workflow approval process before it becomes a Move Order. If no approval process is used, the requisition becomes a Move Order immediately.

2. Replenishment Move Order: These Move Order are generated by Kanban cards, where the Pull sequence calls for a Sub-Inventory transfer or by Min-Max planned items, where the item replacement source is another Sub-Inventory. In this case, the Min-Max or Replenishment Count Report automatically generates a Move Order. Replenishment Move Order are pre-approved and ready to be transacted.

3. The Pick release process generates Move Orders to bring the material from its Source location in stores to a Staging location, which you define as a Sub-Inventory in Oracle Inventory. This transaction is a Sub-Inventory Transfer.

What are the different steps in Movement Statistics? a. Define Movement Statistics Parameters

b. Enter Movement Statistics Information c. Link Movement Statistics to Invoice d. Report and Review Movement Statistics e. Freeze Movement Statistics

OVERVIEW OF INVENTORY TRANSACTIONS

a. A transaction is an Item movement, INTO, WITHIN or OUT OF Inventory b. A transaction changes the QUANTITY, LOCATION or COST of an Item

c. Oracle Inventory supports a number of pre-defined and User-defined transaction types d. Every material movement has a corresponding set of accounting transactions that Oracle

Inventory automatically generates

e. A transaction type requires transaction source type and transaction action What are different Inventory Transactions?

a. Receive Item INTO an Organization from a GL account number b. Issue Item FROM an Organization into a GL account number c. Transfer Items between Sub-Inventories in the same Organization

(6)

d. Transfer Items directly between Organizations e. Reservation of Items

USE OF MISCELLANEOUS TRANSACTIONS 1. MISCELLANEOUS ISSUE

2. MISCELLANEOUS RECEIPT

3. MISCELLANEOUS SUB-INVENTORY TRANSFER For all these transactions, no prior PO or REQUISITION is required.

INVENTORY PALNNING & REPLENISHMENT What are different Planning Methods?

1. Re-Order point Planning 2. Min-Max Planning

3. Sub-Inventory Replenishment Planning 4. Kanban Cards

When should you Order a material?

We should Order a material, when On-Hand quantity plus Supply minus Demand is less than Minimum Inventory level. The minimum Inventory level is nothing but a Safety Stock

[On-Hand quantity] + Supply - Demand < Minimum Inventory level

RE-ORDER POINT PLANNING

 It is a method of determining the size and timing of item replenishment orders.  It requires the following pieces of information

a. Safety Stock

b. Replenishment Lead Time c. Item Demand

d. Order Cost e. Carrying Cost

 We can perform Re-Order Point Planning for the Entire Organization. Also we can use Re-Order point planning for items under independent demand

 We can specify Re-Order point planning as the Inventory Planning method where we define an Item

Under what scenario Re-Order Point planning is used?

We can use Re-Order point planning for items that do not need to be controlled very tightly and are not very expensive to carry in Inventory.

MIN-MAX PLANNING

 It is a method of determining, when or how much to order based on user defined Min and Max levels

 We can perform Min-Max planning either at Organization level or Sub-Inventory level  MIN-MAX report is run to execute this planning.

(7)

INVENTORY ACCURACY CONTROL CYCLE COUNT & PHYSICAL INVENTORY

Cycle Counting

It is a periodic counting of individual items throughout the year. High value items are counted more frequently than the low value items

Initialization is a process of identifying the items in cycle count. STEPS IN CYCLE COUNTING

a. Define cycle count header b. Update cycle count items c. Schedule items to count d. Generate count request e. Enter cycle count f. Approve cycle counts

USE OF CYCLE COUNT IN ORACLE INVENTORY

a. To reconcile system On-Hand balances with actual counts in Inventory b. Maintain control over higher value items

c. We can perform cycle count for the entire organization or for a specific Sub-inventory inside that Organization

ABC Analysis

 It is a method of determining relative value of items in an Inventory

 ABC analysis involves ranking of items according to a criteria and then grouping them into classes  ABC refers to the ranking you assign to the items as a result of this analysis like items with ranking

‘A’ are more valuable than the ‘B’ items and so on. PHYSICAL INVENTORY

Physical Inventory is a periodic reconciliation of system On-Hand balances with Physical counts in Inventory.

You can perform Physical inventory whenever you choose to verify the accuracy of your system On-Hand quantities

This can be done for the entire Organization or for a specific Sub-Inventory PHYSICAL INVENTORY TAG

A tag is a tool for recording the On-Hand quantities of a specific item at a particular location. Usually a tag is a slip of paper posted on the items location. Oracle can automatically generate tag numbers that we can use to enter Physical inventory counts.

STEPS IN PHYSICAL INVENTORY a. Define your Physical Inventory

b. Take snap-shots of On-Hand quantities c. Generate Tags

d. Count Items e. Enter Counts f. Void Tags g. Approve Counts

(8)

i. Purge Physical inventory

ORACLE ORGANIZATION

Set of Books -> Legal Entities -> Operating Units ->Inventory Organizations

Set of Books

 It is composed of a chart of accounts, a calendar and functional currencies

 Legal Entities that share the chart of accounts, accounting calendar and functional currency can be accounted for the same set of books

 One set of books can contain one or more legal entities Legal Entities

 It is a company for which by law you must prepare fiscal or tax report including a balance sheet and a Profit and Loss report

 Legal entities comprise of one or more Operating Units Operating Units

 Operating unit represents buying or selling units within an Organization Inventory Organization

 It is a unit that has Inventory Transaction and Balances and possibly Manufactures and Distributes products

What are the basic things that you should consider when you plan your Enterprise Structure? a. Set of Books

You can tie a Set of Books to each Inventory Organization b. Costing Methods

You can choose standard or average costing methods only at Organization level c. Item Costs

Inventory keeps one cost per item per Inventory Organization d. Movement between Sites

In-transit inventory can be used for Inter Organization transfers e. Planning methods

 Re-Order point planning can be performed only at Organization level  Min-Max planning can be performed both at Organization and Sub-Inventory  Replenishment counting can be performed only at Sub-Inventory level. f. Forecasting

Inventory forecast item use at Organization level only g. Accuracy analysis

Physical Inventory, Cycle count and ABC classification can be performed both at Organization and Sub-Inventory level

Unit of Measurement (UOM)

 It is a term that must be used along with a numeric value to specify the quantity of an item UOM class

 This is a group of unit of measure with similar characteristics. For example Weight can be a UOM class with UOM such as gram, pound, ounce, kilogram etc

UOM conversion

(9)

Organization Calendar is also known as Working Day Calendar

ITEM STATUSES AND ATTRIBUTES Status attributes or Item attributes enable key functionality for each item

An item status is defined by selecting the value check boxes for the status attributes

Both Status attributes and item attributes can be controlled at the Item level and Organizational level ITEM STATUS ATTRIBUTES



STOCKABLE: The functional area is Oracle Inventory. You can stock the item in Inventory



TRANSACTABLE: You can transact the Item in Inventory, OM, Purchasing and WIP.



PURCHASEABLE: You can place an Item on PO



BUILD IN WIP: You can manufacture the Item



CUSTOMER ORDERS ENABLED: You can sell these Items



INTERNAL ORDERS ENABLED: You can create an Internal Sales Order for the Item



BOM ALLOWED: You can create a Bill of Material for this Item



INVOICE ENABLED: You can create an Invoice for this Item

Status Attribute can have MASTER LEVEL control or ORGANIZATIONAL LEVEL control. MASTER level control means an Item has Identical Attributes in all Organization that use it. ORGANIZATIONAL level control means an attribute that you maintain at Organizational level may have different values for an Item for different Organizations.

STEPS IN DEFINING ITEMS

1. Copy Template

2. Copy Items

3. Enter Attribute Values 4. Enable in Child Organization 5. Update Organization level attributes 6. Define Item Cost

What are the different kinds of relationships that you can define for an Item? 1. Item Cross-Reference

2. Substitute Items 3. Related Items

4. Manufacturer Part Number 5. Customer Item Numbers

Note: Items are always defined in the Master Organization and then enabled in as many child organizations as you want.

DELETION CONSTRAINT

These are specific business rules and custom checks to be done before Oracle Inventory allows deletion to be done

CATEGORY & CATEGORY SETS

 Categories are logical grouping of items of similar characteristics

 A category set is a distinct category grouping scheme & consists of categories Normally categories are used to group inventory items

(10)

You can also perform Min-Max or Re-Order point planning for a particular category of items

INVENTORY CONTROLS What are the different Inventory Controls available in Oracle?

a. LOCATOR CONTROL b. REVISION CONTROL c. LOT CONTROL

d. SERIAL NUMBER CONTROL MAIN TABLES USED FOR ITEMS MTL_SYSTEM_ITEM_B

 Columns which end with ‘_ID’ is a number for Identification  Columns which end with ‘_CODE’ contains meaningful information

In MSIB Inventory_Item_Id column contains Item_Id and Segment1 contains Item name MTL_PARAMETERS is the Organization table (Org Name, Org Code, etc)

For UOM, MTL_UNIT_OF_MEASURE

ORG_ID is the Operating unit id whereas ORGANIZATION_ID is the Inventory Organization Id MTL_ITEM_CATEGORIES_B for Item Categories

MTL_CATEGORY_SETS is for category sets IMPORTANT TABLES FOR PHYSICAL INVENTORY

 MTL_PHYSICAL INVENTORIES  MTL_PHYSICAL_INVENTORY_TAGS  MTL_PHYSICAL_ADJUSTMENTS IMPORTANT TABLES FOR ITEM RESERVATION

 MTL_RESERVATIONS

 MTL_RESERVATIONS_INTERFACE TABLE FOR MATERIAL TRANSACTION

 MTL_MATERIAL_TRANSACTIONS TABLE FOR ITEM CROSS-REFERENCES

 MTL_CROSS_REFERENCES TABLE FOR ITEM COST

 CST_ITEM_COST

 CST_ITEM_COST_DETAILS  CST_ITEM_COST_INTERFACE TABLE FOR ITEM INTERFACE

 MTL_SYSTEM_ITEMS_INTERFACE  MTL_SYSTEM_ERRORS

ORDER MANAGEMENT INTERNAL SALES ORDER

Internal Sales Order originates as requisitions in Oracle Purchasing. The process for Internal Orders is as follows

 An Employee enters a Requisition for an Item  The Requisition is sent for approval

(11)

 The Purchasing System issues an Internal Sales Order to OM

 Order management imports Internal Sales Order through Order Import Process  OM creates a Pick release when the item is available in the warehouse

 If the requisitioner is at another location, OM handles packing and shipping to that site  The Item is delivered

 OM handles the accounting for the release from the Inventory and Purchasing handles the accounting for the issue to the requisitioner.

RETURN MATERIAL AUTHORIZATION

The RMI flow basically reverses the Order Process. It includes getting the material back from the customer, putting it back into the stock and issuing the credit. There is also a corresponding return to a customer transaction for getting the needed repair or replacement back to the customer.

Oracle OM facilitates a link back to the original order through a reference source field on the return form that ties to a sales order. Once the link is established all the relevant information from the Original Order will be defaulted to the RMI. Returned receipts are handled by Inventory

Note: Returns are processed through Receiving forms.

Note: Setup and Testing have to ensure that RMI items are not taken as regular items.

What is Value set?

A value set is a set of values, which restricts the valid values that can be entered. The value set can be either numeric and alphanumeric.

It can be very sophisticated, incorporating SQL querying from several tables and able to populate the database with one column.

What is a concurrent program?

A concurrent program is an instance of an execution file along with parameter definations and incompatibilities.

What is concurrent manager?

Concurrent Managers are components of concurrent processing that monitor and run time consuming, non iteractive tasks without tying up your terminal.

OR

These are controllers of background processing for Oracle Applications. The main function of concurrent managers is to regulate and control process requests based upon a set of rules. It is a technique used to execute non interactive, data dependent programs simultaneously in the background.

Oracle Application comes with a predefined managers including 1. Internal Concurrent Manager ( ICM )

2. Standard Manager

3. Conflict Resolution Manager (CRM) and 4. Transaction Manager (TM)

Internal Concurrent Manager controls all the other concurrent managers that are operating system process that poll for requests.

We can also create concurrent managers to handle particular types of results or programs and specialize them for our business requirement.

(12)

What do you mean by document number? There are two types of documents. MD 70: Functional Document

This is provided by the customer, and is provided by the Functional Personnel. MD 50: Technical Document

This is done after the receipt of the MD 70 document. It contains all the technical know how as to where the data should be inserted or should be retrieved from and the logic and also the no and name of packages that will be used.

Types of Errors in Reports

Some of the errors are defined below

1. There Exists uncompiled unit : When the report is not compiled before loading in the Oracle Applications.

2. Report File not Found : When the rdf is not uploaded in proper directory 3. Width or margin is zero : When the repeating frame are not within proper frames 4. Not in proper group : When the repeating frame is not reffered to proper group What is the difference between Compile and Incremental Compile?

In compile all the PL/SQL within the reports are compiled but in incremental compile only the changed PL/SQL units are compiled.

When compiling the report for the first time, we should do the full compilation and not the Incremental compile.

API’s of Move Order

 INV_MOVE_PUB.PROCESS_MOVE_ORDER Used for move order creation

 INV_REPLENISH_DETAIL_PUB.LINE_DETAILS_PUB Move Order Allocation

 INV_PICK_WAVE_PICK_CONFIRM_PUB.PICK_CONFIRM Move Order or Sales Order confirm

 INV_RESERVATION_PUB.CREATE_RESERVATION Reservation Creation

 INV_RESERVATION_PUB.QUERY_RESERVATION Query Reservation

What are lexical Parameters?

Lexical Parameters enable you to link your report to any other Oracle product.

For example: When you are calling a report from a certain form, you can use the run product method and pass to it a parameter list, that has a parameter referring to a lexical parameter used in the report. System Parameters Used in Reports

BACKGROUND Is whether the report should run in the foreground or the background. COPIES Is the number of report copies that should be made when the report is printed. CURRENCY Is the symbol for the currency indicator (e.g., "$").

(13)

DESFORMAT Is the definition of the output device's format (e.g., landscape mode for a printer). This parameter is used when running a report in a character-mode environment, and when sending a bitmap report to a file (e.g. to create PDF or HTML output).

DESNAME Is the name of the output device (e.g., the file name, printer's name, mail userid).

DESTYPE Is the type of device to which to send the report output (screen, file, mail, printer, or screen using PostScript format).

MODE Is whether the report should run in character mode or bitmap.

ORIENTATION Is the print direction for the report (landscape, portrait, default). PRINTJOB Is whether the Print Job dialog box should appear before the report is run. THOUSANDS Is the symbol for the thousand's indicator (e.g., ",").

DESNAME DESTYPE DESFORMAT COPIES OPTIMIZER

The Oracle optimizer has two primary modes of operation 1. Cost Based (CHOOSE)

2. Rule Based (RULE) Cursor Attributes

FOUND NOTFOUND ISOPEN ROWCOUNT What are views?

Views are database objects whose contents are derived from another table. A view contains no data of its own.

What are the PL/SQL data types? 1. Scalar types

2. Composite types 3. LOB types

What is Varying array (varray) ?

A varying array allows you to store repeating attributes of a record in a single row. Process: First create a TYPE of VARRAY and then define in the table.

Step 1: Create or Replace TYPE TOOLS_VA as VARRAY(5) of varchar2(2); Step 2: Create table BORROWER

(

Name varchar2(25), Tools TOOLS_VA,

Constraint BORROWER_PK primary key (Name) );

What are collectors?

Collectors are used to accurately represent relationships between datatypes in your database objects. Collectors such as varray allow you to repeat only those column values that change, potentially saving storage space.

(14)

There are two types of collectors 1. Nested Tables

2. Varying Arrays

How do you compile Procedures and Packages? ALTER <proc/package> <name>COMPILE;

Give one report customization that you have done. On hand report customization

There was no item locator and I had to add it Item Quantities

On hand balances Item Locator

Difference between Org_Id and Organization_Id? Org_Id : Operating Unit Id

Organization_Id : Inventory organization Id

Mapping Rule

It is not necessary that values available in legacy system will be valid values in Oracle Apps. So the rules to change legacy values to valid Oracle Apps values is called mapping rule.

Flex Field

It is an extension to standard functionality of a form

We cannot change the structure of a KFF whereas we can define the structure of a DFF of our own. KFF : Segment 1 n

DFF : Attribute 1 n

What do you mean by Multi-Org? The key component of multi org are

1. Provides Secure access to the different organizations of the enterprise

2. Supports multiple organizations of the enterprise structure in a single database.

Application Object Library

User Profiles & Responsibility

Questions & Answers

User Profiles

1. What are the different profile levels available to set values for your profile options.

Ans:

Site, Application, Responsibility and User levels.

2. Which level has the highest priority, and overrides values entered at other levels.

Ans:

User level has the highest priority.

(15)

3. Which are the forms through which profile options can be entered as default.

Ans:

Concurrent Programs, Request sets, Key Flex field segments and Descriptive Flex field

segments.

4. Any user can view and change any profile value set at any level.

a. TRUE

b. FALSE

Ans:

FALSE

5. What are the two different types of predefined profile options?

Ans:

Database profile options and Internally generated profile options.

6. Name the API package which is used in the PL/SQL procedures to manipulate and view profile

option values.

Ans:

FND_PROFILE

7. Any changes you make to a profile option value using API routines affect only the run-time

environment, that is these settings ends when the program ends.

a. TRUE

b. FALSE

Ans:

TRUE

8. Using API’s you can set profile values at all levels.

a. TRUE

b. FALSE

Ans:

FALSE

Responsibility

9. Define responsibility.

Ans:

A responsibility is a level of authority in Oracle Applications that lets users access only those

Oracle Applications functions and data appropriate to their roles in an organization.

10. What are the four components of a responsibility?

Ans:

Data Group, Request Security Group, Menu and Functions & Menu Exclusions.

11. List the required components of a responsibility.

Ans:

Data Group and Menu are the two required components of Responsibility.

12. Define the roles played by each components in a responsibility.

Ans:

Data Group: A Data Group defines the mapping between Oracle Applications

products and ORACLE IDs. A Data Group determines which Oracle database accounts a

responsibility’s forms, concurrent programs, and reports connect to.

Request Security Group: A request security group defines the concurrent programs, including

requests and request sets, that may be run by an application user under a particular

responsibility.

Menu: A menu is a hierarchical arrangement of application functions (forms) that displays in the

Navigate window. Menus can also point to non form functions (sub functions) that do not display

in the Navigate window, but that define the range of application functionality available for a

responsibility. Each responsibility is associated with a menu.

Functions & Menu Exclusions: A menu is a hierarchical arrangement of application functions

(forms) that displays in the Navigate window. Menus can also point to non form functions (sub

(16)

functions) that do not display in the Navigate window, but that define the range of application

functionality available for a responsibility. Each responsibility is associated with a menu.

13. What is the difference between Request Group and a Request Security Group.

Ans:

When a request group is assigned to a responsibility, it becomes a request security group.

From a standard submission form, such as the Submit Requests form, users can run only the

reports, concurrent programs, and request sets

that are in their responsibility’s request security group.

14. A responsibility can have more than one menu attached.

a. TRUE

b. FALSE

Ans:

FALSE

15. Reports, Report Sets and Concurrent programs within a request group can be submitted

through submit request forms only if the corresponding request group is attached to a

responsibility.

a. TRUE

b. FALSE

Ans:

TRUE

16. Responsibilities can be deleted.

a. TRUE

b. FLASE

Ans:

FALSE

17. The application name entered while creation of the responsibility prevents the user from

accessing other applications forms and functions through the menu.

a. TRUE

b. FALSE

Ans:

FALSE

18. Data group defines the pairing of which two usernames.

Ans:

Data group defines the pairing of Application and Oracle username.

19. What are the two application systems with which a responsibility can be associated

Ans:

Oracle Applications and Oracle Self – Service Web Applications.

20. More than one responsibility can be attached to a user

a. TRUE

b. FALSE

Ans:

TRUE

21. What is function security.

Ans:

Function security is the mechanism by which user access to applications functionality is

controlled.

22. What is a function.

Ans:

A function is a part of an application’s functionality that is registered under a unique name

for the purpose of assigning it to, or excluding it from, a responsibility.

23. Define the two different types of function.

Ans:

Form ( Form Function) : A form function (form) invokes an Oracle Forms form. Form

functions have the unique property that you may navigate to them using the

(17)

Navigate window.

Sub function (Non Form Function): A non form function (sub function) is a securable subset of a

form’s functionality: in other words, a function executed from within a form.

24. Which are the menu entry types that are not displayed by the navigate window.

Ans:

Sub functions, Menus without entries and Menu entries without a prompt.

25. What are the two entities which uniquely identifies a responsibility.

Ans:

Responsibility name and Application Name.

26. Even though a Request Group is not assigned to a Responsibility, the user to whom this

responsibility has been assigned can run request sets owned by him from a submit request

window.

a. TRUE

b. FALSE

Ans:

TRUE

27. What is the role of a attribute in the area of Self – Service Web applications.

Ans:

Attributes are used to define what information users can access

through Oracle Self - Service Web Applications. They uses columns, rows and values in

database tables to define what information users can access

28. Attributes are defined in .

a. Web Server

b. Data Dictionary

c. Web Application Dictionary

Ans:

Web Application Dictionary

29. What are the tow different types of attributes which can be assigned to a responsibility.

Ans:

Securing Attributes and Excluded Attributes.

Application Programming Interfaces – QA

1. What is API?

Ans:

API stands for Application Programming Interfaces.

2.What is the difference between Client Side API’s and Server Side API’s?

Ans:

APIs those are all stored in the ORACLE database are called Server side API’s. APIs those

are in front end libraries are called Client Side APIs.

3.What is the use of FND_GLOBAL.APPS_INITIALIZE procedure?

Ans:

Usage of FND_GLOBAL.APPS_INITIALIZE procedure are

· It sets the global values & Profile Values in the database session.

· You can use it for routines such as java , PL/SQL or other programs which are not

integrated with the Oracle application concurrent processing or Oracle Forms ( Both of which

already do similar initialization for database session ) .

(18)

4.Brief the usage of FND_GLOBAL Package?

Ans:

Usage of FND_GLOBAL package

It is a server–side package returns the values of system global, such as the login/sign on or

“session” type of values. You can use the values to set who columns for inserts and updates from

stored procedures.

5.How can you find the application user id in Oracle Application?

Ans:

FND_GLOBAL.USER_ID API is used to find the application user id.

6.What are all the WHO columns provided by Oracle? Which API used to update the WHO

Columns?

Ans:

Created_by, Created_date, Last_modified_by, Last_modified_date are the WHO columns in

all transaction table provided by Oracle to find who has created or modified the row of the

transaction tables.

FND_STANDARD.SET_WHO API is used to Update WHO columns.

7.How can you retrieve system date from database? Which API having the same functionality in

Oracle Apps?

Ans:

SELECT sysdate FROM DUAL used to find the system date in Oracle Database.

FND_STANDARD.SYSTEM_DATE API having the similar functionality.

8.Can you invoke web browser through any API’s? If so Which API can do this?

Ans:

Yes, you can invoke web browser through API. FND_UTILITIES.OPER_URL API can do

this.

9.What is the use of FND_UTILITIES.PARAM_EXISTS API?

Ans:

FND_UTILITIES.PARAM_EXISTS API is used to check the given parameter is Exist in the

Open Oracle Form or not . If exists it will return True other wise it will return False.

10.FND_FILE support maximum buffer line size _____KB.

Ans:

FND_FILE support maximum buffer line size 32 KB.

11.Shall we use FND_FILE.PUT_NAME & FND_FILE.CLOSE in concurrent programs? If not

Why ?

Ans:

We should not use FND_FILE.PUT_NAME & FND_FILE.CLOSE in concurrent programs.

Because these two operations are automatically done by Oracle Apps we should not override this

default operations.

12.What is the difference between FND_FILE.PUT & FND_FILE.PUT_LINE?

Ans:

FND_FILE.PUT API is used to write text to a file (without a new line character). Multiple calls

to FND_FILE.PUT will produce concatenated text.

FND_FILE.PUT_LINE API is used to write a line of text to a file (followed by a new line

character).

13.What are the two types of files we can deliver with the help of FND_FILE Package?

Ans:

FND_FILE.OUT – Oracle Apps Output File.

FND_FILE.LOG – Oracle Apps Log File.

14.How can you see the status of the concurrent program through backend?

Ans:

With the help of FND_CONCURRENT.GET_REQUEST_STATUS API we can see the

status of the concurrent program through backend.

(19)

Ans:

FND_CONCURRENT.WAIT_FOR_REQUEST API is used to implement the parent-child

concurrent programs. Waits for request completion, then returns the request phase/status and

completion message to the caller. Goes to sleep between checks for request completion.

16.What is the usage of FND_PROGRAM package?

Ans:

FND_PROGRAM package Usage:

The FND_PROGRAM package includes procedures for creating concurrent program

executables, concurrent programs with parameters and incompatibility rules, request sets, and

request groups.

The FND_PROGRAM package also contains functions you can use to check for the existence of

concurrent programs, executables, parameters, and incompatibility rules.

17.What is the usage of FND_CURRENCY Package?

Ans:

FND_CURRENCY Package Usage :

This package is used to format the currency . We can use it in Client side as well as Server Side .

18.Is it possible to Delete Executable through FND_PROGRAM API’s?

Ans:

Yes , It is Possible to delete executable through FND_PROGRAM.DELETE_EXECUTABLE

if it is not attached to the Concurrent program Otherwise not possible to delete.

19.What is the usage of FND_PROGRAM.ENABLE_PROGRAM API?

Ans:

FND_PROGRAM.ENABLE_PROGRAM API Usage:

Use this procedure to enable or disable a concurrent program.

Syntax is:

Procedure FND_PROGRAM.ENABLE_PROGRAM

(Short name IN VARCHAR2,

Application IN VARCHAR2,

ENABLED IN VARCHAR2)

20.Can you submit the request from Backend triggers? Which API helps to do that?

Ans:

Yes, You can summit the request with in the backend triggers. Before submitting the request

you have to use the FND_REQUEST.SET_MODE API to set the mode. With out using

FND_REQUEST.SET_MODE we can’t submit the request from Database Triggers.

21.How can you submit a request from Backend?

Ans:

With the help of FND_REQUEST.SUBMIT_REQUEST API we can submit the request in

Backend.

22.Why we have to register the tables & columns in AOL?

Ans:

You have to register the table & columns in AOL before you create new flex field or alert on

a table. Otherwise not possible to create flex field or alert on it .

23.How can you register a table in AOL?

Ans:

With the help of AD_DD.REGISTER_TABLE API we can register the table in Application

Object Library.

24.How can you launch a workflow through backend?

Ans:

With the help of WF_ENGINE.STARTPROCESS we can launch the workflow from

backend .

25.What are the two default parameters you have to give when you create stored procedures &

functions as a concurrent program?

(20)

Ans:

errbuf - VARCHAR2

retcode – NUMBER - 0 for success

1 for success with warning

2 for error

CONCURRENT PROCESSING

1. What is a Concurrent program?

Ans:

A concurrent program is an instance of an execution file, along with parameter definitions

and incompatibilities.

2. What is concurrent Manager?

Ans:

Concurrent Managers are components of Concurrent Processing that monitor and run

time-consuming, non-interactive tasks without tying up your terminal.

3. What is Internal Concurrent Manager?

Ans:

It is the boss of all the other managers. It starts up, verifies the status of , resets and

shutdowns the individual managers.

4. What is Concurrent program Executable?

Ans:

A concurrent program executable links an execution file or and the method used to Execute

it with a defined concurrent program.

5. What is Concurrent Program Executable file?

Ans:

A concurrent program execution file is an operating system file or database stored

procedure which contains your application logic and can be executed by either invoking it directly

on the command line or by invoking a program which acts upon it. It also enforces

incompatibilities.

6. What is execution method?

Ans:

The execution method identifies the concurrent program executable type and the method

Oracle Application Object Library uses to execute it.

7. What is Spawned Process?

Ans:

A Concurrent process that runs as a separated process than that of the concurrent manager

that starts it.

8. What method can be used for C or Pro*C executables?

Ans:

Spawned

9. What is a Child Request?

Ans:

A child request is a concurrent request submitted by another concurrent request.

10. What setting to make to make the concurrent program to appear in the SRS window?

Ans:

Enable the option ‘Use in SRS’.

11. Brief the steps to Run a concurrent Program?

Ans:

i. Create the executable file

ii. Define Executable in Apps

(21)

iv. Attach the concurrent program to the Request Group

v. Ensure the Request group is attached to the specified User

12. What is request set?

Ans:

Request allows you to submit several requests together using multiple execution path.

13. Inside Stage in Request, how the individual request process?(Choose One)

a. Parallel

b. Sequential

c. Manager chooses the method

d. Depends on the setting in Concurrent Program

Ans:

a. Parallel

14. Which user profile option is used to set the Priority?

Ans:

Concurrent:Priotity

15. What is Session Control?

Ans:

This is option for the database session, which includes Consumer Group, Rollback segment,

Optimizer Mode.

16. What are the Optimizer Modes available in Concurrent Program session control?

Ans:

All Rows, First Rows, Rules and Choose

17. When you go for best throughput which mode you prefer? Choose one

i. All Rows

ii. Choose

iii.First Rows

iv. Rules

Ans:

i. First Rows

18. What is Incompatibilities?

Ans:

Identifies program that should not run simultaneously with your concurrent program because

they might interfere with its execution.

19. What is Conflict Domain?

Ans:

It is the one, which identifies the data where two incompatible programs cannot run

simultaneously.

20. Which Manager will take care of Conflicts in Concurrent Processing?

Ans:

Conflict Internal Manager

21. What is Token in Concurrent Program?

Ans:

For a parameter in an Oracle Reports program, the keyword or parameter appears here.

22. What are the valid types of Default Type?

Ans:

a. Constant

b. Profile

c. SQL Statement

d. Segment

(22)

23. What are types of Execution Methods?

Ans:

SQL*Plus Programs

PL/SQL Stored Programs

SQL*Loader

Oracle Reports

Host

Immediate

Request Set Stage Function

24. Where is the Output file Generated?

Ans:

<prod_top>/out/

25. Where is the Log file Generated?

Ans:

<prod_top>/log/

26. What is the limit for the number of arguments for a concurrent program? (Choose One)

a.100

b.240

c.32

d.500

Ans:

100 27. What are Concurrent Process Life Cycle Phases?

Ans:

a. Pending

b. Running

c. Completed

d. Inactive

28. What does Pending- Normal denote?

Ans:

Request is waiting for the next available manager.

29. What are the various statuses of Running Phase of a concurrent process?

Ans:

a. Normal

b. Paused

c. Resuming

d. Terminating

30. Using SRS, can you schedule a single request or a set or request to run automatically?

True / False

Ans:

True

31. What is the Use of Completion Options in SRS?

Ans:

It allows you to deliver request output to others and specify which printer, and how many

copies of output you want to produce.

32. When can you put on Hold a request?

Ans:

We can hold only if the request is pending or Inactive phase.

33. What are the various completion status of Stage function?

Ans:

Success, Warning, and Error

(23)

FORMS CUSTOMIZATION

1. What is custom development?

Ans:

Custom development is new development, In order to provide new functionality , which is

not available in Oracle Application, we are going for custom development.

2. What is customization?

Ans:

Customization is not a new development. The existing form will be modified as per our

requirement. This may be cosmetic change or navigation change or functionality change.

3. Compare Custom development & customization. When they are used and Why?

Ans:

Custom development.

a. New development

b. Template form has to use

c. The required functionality is not provided by oracle in that case we have to go for

custom development.

Customization.

a. Tailoring the existing application

b. Same source file has to use

c. The existing functionality is not fully satisfy our requirement, Then we are going for

customization.

4. What are step you have to follow to register a custom application?

Ans:

a. Register your Application

b. Create directory structure

c. Set the Environment variable for directory

d. Create the schema

e. Attach your application & Schema with standard data group

f. Create the table, views, and trigger in your schema.

g. Create synonym for table to APPS schema

h. Built the form

i. Register the form

j. Create form function

k. Create the menu

l. Attach the menu to the responsibility

m. Attach the responsibility to the user

5. How do you find out the FMB name?

Ans:

Select menu bar Help menu of the form, then select About Oracle Application menu, that will

show the FMB of the form.

6. Name the directory having the FORMS source codes ( FMB files ) ?

Ans:

AU_TOP forms directory.

7. What is template form?

Ans:

Template form is a form, which have standard functionality of the oracle application, like

menu bar, tool bar action and some standard trigger. All forms in oracle application will be

developed using this form, To get standard appearance oracle application provide this form.

8. What are step you have to follow to register a Form?

Ans:

a. Create the function.

(24)

c. Attach the form function to menu.

9. What is a Form function?

Ans:

Form function is nothing but form. Oracle Apps treats all the forms as function.

10. What is Form sub function?

Ans:

Sub function is a non-form function. Sub function will created based on form function. By

using this we can restrict functionality of the form.

11. How the form sub function is implemented?

Ans:

By using parameter and profiles.

12. What is folder form?

Ans:

Folder form is a special form, here the user allow changing the appearance of the form as

he/she like. The user can rearrange the fields, resize the fields. This changes will be permanent

belongs to the user.

13. Name the directories where you have to copy your Fmb and Fmx files?

Ans:

All FMB files will be coped in AU_TOP form directory. FMX will be copied to corresponding

Prod_Top form directory.

e.x all GL forms fmx will be coped in GL_Top form directory.

14. Why we have to maintain the file names in Capital Letter? ( Library/FMB)

Ans:

Some of operation system will have case sensitivity, those OS may not able to get the

correct file, for avoiding case sensitivity problem we have to maintain the file name in UPPER

case.

15. What is naming convention for Data base trigger?

Ans:

Tablename_Ti. ( “i” = 1,2,3…..)

16. What is naming convention for unique Constraint?

Ans:

Tablename_Ui (“i” = 1,2,3….)

17. What is naming convention for Primary Constraint?

Ans:

Tablename_PK

18. Can we put all the logic in the trigger?

Ans:

No, Create a package, put all the logic in package. Call the package from the trigger.

19. What is item handler package?

Ans:

Item handler package is a package. This package will take care of the item validation,

navigation. Each block can have one package with the name of block name.

20. What is event handler package?

Ans:

Event handler package is a package. This package will take care of the various event of the

form, like post query, pre query, when new record instance etc. Each form has event handler

package with the name of form name.

21. What is table handler package?

Ans:

Table handler package is a package. This package will take care of the insert, update and

delete operation of view-based block. Each form can have one package with the name of form

name.

(25)

22. What are the standard libraries available in template form?

Ans:

a. APPCORE

b. APPDAYPK

c. FNDSQF

d. CUSTOM

23. What is who column and how can you set the values?

Ans:

Who columns are database columns, which gives the history of the record. ( it will gives

created user name with date and last modified user name with date of the record).

By using fnd_standard.set_who procedure we can set the value.

24. What is use of custom library?

Ans:

By using this library we have to do cosmetic and navigation change in form customization.

25. How can you change the default menu bar action?

Ans:

By using APPCORE library

26. What is use of APPDAYPK library?

Ans:

By using this library you can change the functionality of menu action and tool bar actions,

and you can add custom help files in the application.

27. What is a reference trigger? Can we modify a reference trigger?

Ans:

Reference trigger is a trigger, definition of the trigger will be in some other file.

We can, But Oracle Application advise against modifying the reference trigger. Because this

change will affect the whole application.

28. Why we have to create packages instead of procedure / function?

Ans:

If we create procedure/function, this will be compiled every call of the procedure/function,

But if you create package it will not complied every call, It will increase performance of the

application.

29. Can you comment your form? How?

Ans:

Yes.

a. You can give comment of the from in Form module “comment window”.

b. By using FND_Standard.Form_info procedure you can comment your form, this is in Pre_Form

trigger.

30. Which form objects we should not use?

Ans:

a. Activex, Vbx, Ocx, Ole

b. Timer

c. Mouse Trigger

d. Open_Form

e. Combo Box

f. Test_io, Host built-in

(26)

Ans:

By using this library you can display calendar window in date field LOV.

32. What is use of FNDSQF library?

Ans:

This library will tack care of concurrent program, profile options and flex filed behavior.

33. Can we change the profile value? How?

Ans:

Yes.

By using FNDSQF library we can change the profile values.

34. Shall we modify all the triggers?

Ans:

No, we should not do any modification in certain form level trigger.

35. What are the triggers we should not modify?

Ans:

a. Close_this_window.

b. Close_window

c. Export

d. Folder_Action

e. Key-Commit

f. Key-Edit

g. Key-Exit

h. Key-Help

i. Lastrecord

j. Menu_to_Appcore

k. Standard_Attachment

l. When_window_closed

m. When_form_navigate

n. Zoom

36. Shall we delete exiting triggers?

Ans:

We should not delete any form level trigger. But Oracle application not encouraging deletion

of any trigger.

ORACLE ALERT

1. Oracle Alert is a Complete exception control solution

True/False

Ans:

True

2. What are the types of Oracle Alert

Ans:

Periodic and Event alert

3. An Alert can be

a. Disabled only

b. Disabled or Deleted

c. Deleted only

Ans:

(b)

4. What does an Exception mean?

Ans:

Row returned by the select statement written in SQL statement definition for a specified

condition

(27)

5. Choose the events that can be monitored using event alert (any one)

a. After Insert and Delete

b. Before Insert, Update and Delete

c. After Insert and Update

d. Before Delete and Update

Ans:

(c)

6. Periodic alert immediately notifies the activity in the database as it happens

True/False

Ans:

False

7. If the frequency for periodic alert is On Demand, then the alert has to be run through

a. Standard Request Submission window

b. Alert Run Window

c. Alert Submission window

d. Request Periodic alert check window

Ans:

(d)

8. What is the purpose of “Keep_Days” field ?

Ans:

To maintain history

9. PL/SQL statements can be used in the SQL statement definition

True/False

Ans:

False

10. When the button “Verify” is pressed

a. SQL statement is parsed and executed

b. SQL statement is parsed

c. SQL statement is executed

d. Alert is initialized

Ans:

(b)

11. Event alert can be defined on a View also

True/False

Ans:

False

12. Event alert should not be defined on one of the following table

a. FND_USERS

b. FND_CONCURRENT_REQUESTS

c. FND_ALERTS

d. FND_CONCURRENT_PROGRAMS

Ans:

(b)

13. Input and Output variables has to be specified by prefixing

a. $ and %

b. : and ?

c. & and ?

d. : and &

Ans:

(d)

14. Of the following which one is not an Implicit input variable

a. MAILID

(28)

c. ROWID

d. ORGANIZATION_ID

Ans:

(d)

15. For duplicate checking there is no need for maintaining history

True/False

Ans:

False

16. “Check for Duplicates” option has to be specified in

a. Inputs tab

b. Outputs tab

c. Installations tab

d. Alert Definition window

Ans:

(b)

17. What are the types of actions that can be performed when an alert is triggered

Ans:

Message, Concurrent Program, SQL script, OS Script

18. It is not mandatory to attach an action to an action set

True/False

Ans:

False

19. What are the different action levels available ?

Ans:

Detail and Summary

20. Choose from the following that can be included to an action set

a. Escalation group

b. Threshold group

c. Actions

d. All the above

Ans:

(d)

21. What is the purpose of “Summary Threshold” option ?

Ans:

To make the Oracle alert switch between detail and summary actions automatically

22. “On Error” what are the possible actions that can be performed (All applicable options)

a. Abort

b. Move to another action set member

c. Move to another action set

d. Disable the action set

Ans:

a,b and c

23. What does a Distribution list mean

Ans:

Distribution list helps to group a list of mail ids.

24. One Detail and One Summary action has to be attached to a Threshold Group

True/False

Ans:

True

25. Types of actions that are attached to a Threshold group can be of different types

True/False

Ans:

False

26. In a Self-Referencing Alert which one of the following Implicit Input variable is used

a. ROWID

(29)

b. REFERENCE_ID

c. DATE_LAST_CHECKED

d. USER_ID

Ans:

c

27. Each periodic alert attached to a periodic set continues to run according to its individually

defined frequency.

True/False

Ans:

True

28. For performing Action Escalation, history has to be saved for at least

a. One day longer than the number of days between alert checks

b. Two days longer that the number of days between alert checks

c. Three days longer that the number of days between alert checks

d. One week longer that the number of days between alert checks

Ans:

a

29. For Action Escalation, both Detail level and Summary level actions can be performed

True/False

Ans:

False

30. In Action Escalation Group members we can have

a. Any combination of action types

b. Actions of same type as that of escalation group type.

c. Only Script action type

d. Only Program action type

Ans:

b

31. An Escalation group need not be included in an Action set

True/False

Ans:

False

MULTIPLE ORGANIZATIONS IN ORACLE APPLICATIONS 11i

Q. What is multi org architecture?

Ans: The multiorg architecture is meant to allow multiple companies or subsidiaries to store their

records within a single database. The multiple Organization architecture allows this by partitioning

data through views in the APPS schema. Multiorg also allows you to maintain multiple sets of

books. Implementation of multiorg generally includes defining more than one Business Group.

Q. How can I know if I am using multi org?

Ans: Run the SQL statement:

SELECT multi_org_flag FROM fnd_product_groups;

The result 'Y' means your database is setup for multiorg.

Q. What are the relationships I can define in a multi org environment?

Ans: You define the relationships among inventory organizations,

operating units, legal entities, Business Groups, and sets of books to

create a multilevel company structure:

. Business Groups separate major segments of a business. Each can have

it's own set of books. Each Group will also have a structure of other

organizations classifications assigned to it.

· Legal Entities post to a Set of Books

· Operating Units are part of a Legal Entity

(30)

· Inventory Organizations define and maintain items used by other

manufacturing modules (Order Entry, Purchasing, MRP, etc.). They also

collect and pass data to the Financials modules.

Q. I want to setup additional organizations, do I have to setup multiorg?

Ans: No, you do not need to setup multiorg. You do not have to be

multi-org to have multiple organizations only if you intend to have multiple

sets of books.

1) List the multi-org features supported by Oracle Applications 11i

Multiple organizations using different SOBs in a single installation.

Secure access to data, Users can see data relevant to their orgn.

Sell & ship products from different legal entities.

Purchase & receive products from different organizations.

2) Mention the roles / types / hierarchy of organization in Oracle Apps : Multi-org.

Business group

Set of Books

Legal Entity

Balancing Entity

Operating Unit

Inventory Organization

In HRMS

Internal

External

3) What is business group?

It is the consolidated enterprise. It represents the highest level.

4) What is Set of books?

It is the Financial Reporting Entity.

5) What is Legal entity?

It is an entity for which fiscal or tax reports are prepared.

6) What is Balancing entity?

It is an entity for which financial statements are prepared. It can be a part of a legal entity.

It is identified by a separate segment in the accounting flexfield.

7) What is Operating Unit?

It is an entity representing a sales office or division.

8) What is Inventory Organization?

It is an entity representing a manufacturing plant or a ware house.

9) How many operating units can be attached to a legal entity ?

There is no limit and this can be used depending on the reporting requirements.

10) What is the relationship between legal entity and balancing entity?

(31)

One to many.

One legal entity can have many balancing entities.

11) How many inventory organizations can be attached to an operating unit ?

There is no limit.

12) List the organization(s) required for defining an Inventory organization ?

Set of books, Legal entity and Operating Unit.

13) Can we call a manufacturing plant as operating unit & Inventory organization ? When ?

Yes, when a location plays both manufacturing and selling.

14) The Database architecture is same for multi-org and Non-multi-org installation.

(TRUE/FALSE)

TRUE

15) What is the name of RDBMS global variable used from 10.7 version onwards w.r.t

multi-org ?

CLIENT_INFO

16) What is the significance of the RDBMS global variable used w.r.t multi-org ?

A global variable ‘Client_info’ exist, which is 64 bytes long. The first 10 bytes store

The org_id ( Operating Unit ID ). Organization context is derived using this.

17) Data partitioning in Oracle Apps database is physical : ( TRUE/FALSE )

FALSE

Logical partitioning.

18) Data partitioning is performed using database views. : ( TRUE/FALSE )

TRUE.

19) List the applications partitioned and the entities used for partitioning ?

Application

Partitioned by

Secured (Y/N)

GL

SOB

Y

Fixed Assets

Corp Book

N

HR

Business group

Y

OM / AR / PO / AP

Operating unit

Y

Inventory

Inventory organization Y

20) All the applications in Oracle Applications are secured w.r.t data access.( TRUE/FALSE )

FALSE

21) ‘Accounts Payable’ Module is partitioned using Set of Books. (TRUE/FALSE)

FALSE.

(32)