Interview Questions Answers in Oracle Apps SCM, Oracle Apps Financial

Questions / { gaurav arora }

Questions Answers Category Views Company eMail

At Present Gate entry entered in manual register, Should be enter in ERP on line at the main gate against PO. How we can achieve this? (India Localization)

1 Oracle Apps SCM 2501

Which documents in Purchasing can be autocreated?

1 Oracle Apps SCM 3128

What are the types of Calender? Where we are define it?

1 Oracle Apps SCM 2993

For what purpose we assign qualifiers to our segments?

1 Oracle Apps Financial 2865

Q- How system calculate the average cost? Initial Onhand = 34 Initial Unit Cost = 11.75 Transaction Onhand = 10 Transaction Unit Cost = 10

1 Oracle Apps SCM 2607

Can a Requisition be amended?

1 Oracle Apps SCM 2978

At what stage an order can not be cancelled?

2 Oracle Apps SCM 3649

Can you update the sales order once it is booked?

2 Oracle Apps SCM 3623

Answers / { gaurav arora }

Question { 28477 }

What is meant by Position Hierarchy and Supervisor Hierarchy
????

Answer

1) Employee/Supervisor Hierarchy :- If an employee/ Supervisor relationship is used, the approval routing structures are defined as you enter employees using the Enter person window. In this case Positions are not required to be setup.

2) Position Hierarchy :- If you choose to use position hierarchies, you must setup both jobs and positions.

Setup required for Position hierarchy in detail :-
 Enable the check box “Use Approval Hierarchies”

NAVIGATION :- Purchasing Responsibility > Setup > Organizations > Financial Options

 Define Employees
 Define Job
 Define Position
 Assign Job & Position to the employee
 Define Approval Groups
 Assign Approval groups to Position
 Define Position Hierarchy
 Define Document Type
 Run Report ‘Fill Employee Hierarchy’

Is This Answer Correct ?

3 Yes

0 No

Question { Deloitte, 20913 }

Explain the different levels of Inventory org structure ?
What is Operating Unit ?
What is Legal Entity ?
What is Inventory Organization ?
What is Set Of Books ?
In which setup you control the costing method ?
What is Item master organization ?
How many item master organization we can setup ?
What is Subinventory ?
What is Locator ?
Are Subinventory or Locators mandatory ?
Can you copy inventory org structure ?
What is shipping network ?
Explain UOM and UOM class ?
Explain Item status controls ?
How many Item attributes we can setup ?
How you can provide custom item attributes ?
What are status attributes ?
Explain the functionality of Item templates ?
How Item types are defined ?
Explain the use of cross-references ?
Explain Item categories ?
What is the difference between category and category set ?
How do you assign items to item categories ?
How do you load /import items ?
Explain the use of Item revisions ?
How do you search items ?
How do you delete items ?
What are deletion constraints ?
Can we have custom deletion constraints ?
What are different type of serial number uniqueness ?
How do you generate serial numbers ?
Can serial numbers and lot numbers co-exists for an item ?
Where do you enable or disable serial / lot number
capabilities for an item ?
What is material status ?
Explain the use of material status ?
List some of the seeded material transaction types ?
What are transaction sources ?
Can we have custom transaction sources / types ?
What are the benefits of account aliases ?
What is the difference between subinventory transfer and
move order ?
Can move orders support inter-organization transfer ?
What is miscellaneous transactions ?
Explain the use of shortage notifications ?
Where do you enable the shortage notifications ?
How do you do inter-org transfer ?
Is sales order mandatory for inter-org transfer ?
Explain the difference between direct transfer and
intransit transfer ?
Can we purge material transactions ?
Can we import material transactions through API ?
What is vendor managed Inventory (VMI) ?
What consigned Inventory ?
What is the difference between VMI & consigned inventory ?
Explain the life cycle of move orders ?
What are the different ways move orders are created ?
What forecasting methods oracle inventory supports ?
When do you generate forecast automatically and when do you
setup manually ?
Explain the min-max planning functionality ?
Explain the Re-Order Planning (ROP) process ?
What is the difference between Min-Max and ROP ?
What is safety stock ?
How safety stock is calculated ?
Explain replenishment counting ?
What is the purpose of ABC analysis ?
Explain the cycle counting process ?
Explain the physical inventory process ?
When do you recommend cycle counting Vs physical inventory ?
What are the key flex fields (KFF) in Oracle Inventory ?
What are the descriptive flex fields (DFF) in oracle
inventory ?

Answer

What is Legal Entity?

Ans. It is one of the level in multi org which is used to maintain the company legal information like PAN and TAN information.

In this level no one module is integrated.

Is This Answer Correct ?

2 Yes

0 No

Question { Deloitte, 20913 }

Answer

What is Operating Unit?

Ans. It is one of the level in multi org which is used to maintain the sales and purchase information of our client business.

In this level PO, OM, AP, AR, CM, FA etc. modules are integrated.

Is This Answer Correct ?

1 Yes

0 No

Question { Deloitte, 20913 }

Answer

What is Inventory Organization?

Ans => It is one of the level in multi org which is used to maintain the items information of our client business.

=> Item information like item qty, categories, transactions, catalogs, sub inventory etc.

=> In this level Inventory module is integrated.

Is This Answer Correct ?

0 Yes

0 No

Question { Deloitte, 20913 }

Answer

What is Set Of Books( Ledger)?

Ans => Ledger is used to maintain the financial accounting information of our client business.

=> It is a combination of 4C's & i.e Currency, Calender, Chart of Accounts and Sub ledger Accounting methods.

=> In this level GL module is integrated.

Is This Answer Correct ?

1 Yes

1 No

Question { 2501 }

At Present Gate entry entered in manual register,
Should be enter in ERP on line at the main gate against PO.
How we can achieve this? (India Localization)

Answer

Ans. We can create a simple custom form for the gate keeper where he can enter the details like gate entry number and bill details.
OR
we can create some fields in the Receipt header DFF, and we can also make those fields mandatory as per client requirement.

Is This Answer Correct ?

0 Yes

0 No

Question { 3128 }

Which documents in Purchasing can be autocreated?

Answer

Standard Purchase Orders
Planned Purchase Orders
Blanket Releases
and RFQ's can be autocreated.

Is This Answer Correct ?

1 Yes

0 No

Question { 2993 }

What are the types of Calender? Where we are define it?

Answer

There are three types of calender :-

1. Accounting Calender => Accounting Calender are in GL

It is used for the recording the transaction for the financial year and it will share across the application.

2. Transaction Calender => Transaction Calender are in GL

It is used for average balancing. it will stop the transaction on non working days. It can be used for defining the org calender in banking sector.

3. Workday Calender => Workday Calender in Inventory module

It is one of the manufacturing calender in which we define working days and non working days.

Is This Answer Correct ?

0 Yes

0 No

Question { 2865 }

For what purpose we assign qualifiers to our segments?

Answer

When you define segments like (Company, division, location, account etc.) in Accounting flexfield structure you can easily understand that it is a company, it is a location etc. by reading the names.

But how system know that this segment is a company, this segment is a location. If system is understand that this segment is a company then only it is clearly run the financial reports. Otherwise system does not understand which segment is a company, which segment is account & so on.
So for that purpose we need to assign the qualifiers.

Is This Answer Correct ?

1 Yes

0 No

Question { 2607 }

Q- How system calculate the average cost?

Initial Onhand = 34 Initial Unit Cost = 11.75

Transaction Onhand = 10 Transaction Unit Cost = 10

Answer

Ans. New Unit cost calculated by the system (Average) =

(Initial Onhand * Initial Unit Cost) + (Transaction Onhand * Transaction Unit Cost) / (Initial Onhand + Transaction Onhand)

= (34 * 11.75) + (10 * 10) / (34 + 10)

= 11.35228

Is This Answer Correct ?

0 Yes

0 No

Question { 2978 }

Can a Requisition be amended?

Answer

Ans. It can be updated before approval. It can not be updated after approval. It can be cancelled.

Is This Answer Correct ?

1 Yes

0 No

Question { 3649 }

At what stage an order can not be cancelled?

Answer

Ans. An order can not be cancelled when it is pick confirmed.

Is This Answer Correct ?

1 Yes

2 No

Question { 3623 }

Can you update the sales order once it is booked?

Answer

Ans. It depends on Processing Constraints setup in Order Management. Some of them are seeded and can not be modified but some you can configure on your own.

Is This Answer Correct ?

0 Yes

0 No