In this blog I will try to share my experience, which I believe will help others and shorten the learning curve.
The posts will generally talk about lessons from my professional work, however it can contain content from life outside work also.

Monday, January 20, 2014

Oracle OPM Interview Questions

1) What
are the different types of manufacturing processes? And what are the primary
differences between them? OR

2)Select
b.RECIPE_DESCRIPTION,a.RECIPE_VALIDITY_RULE_ID,c.INVENTORY_ITEM_ID,d.description,decode(c.line_type,-1,’Ingredient’,'Product’)
Type,sum(e.TRANSACTION_QUANTITY) quantityfrom apps.GME_BATCH_HEADER a,apps.gmd_recipes
b,gmd_recipe_validity_rules grr,apps.gme_material_details
c,apps.mtl_system_items d,apps.mtl_material_transactions ewhere a.FORMULA_ID=b.FORMULA_IDand a.ROUTING_ID=b.ROUTING_IDand
a.RECIPE_VALIDITY_RULE_ID=grr.RECIPE_VALIDITY_RULE_IDand grr.RECIPE_ID=b.recipe_idand a.BATCH_ID=c.BATCH_IDand a.ORGANIZATION_ID=c.ORGANIZATION_IDand c.INVENTORY_ITEM_ID=d.INVENTORY_ITEM_IDand c.ORGANIZATION_ID=d.organization_idand a.batch_id=e.TRANSACTION_SOURCE_IDand a.ORGANIZATION_ID=e.ORGANIZATION_IDand c.INVENTORY_ITEM_ID=e.INVENTORY_ITEM_IDand a.batch_no in (select batch_no from
apps.GME_BATCH_HEADER where trunc(plan_start_date) between :from_date and
:to_date)and a.ORGANIZATION_ID=:your_org_idand trunc(e.transaction_date) between :from_date
and :to_dategroup by
b.RECIPE_DESCRIPTION,a.RECIPE_VALIDITY_RULE_ID,c.INVENTORY_ITEM_ID,d.description,c.line_typeorder by RECIPE_DESCRIPTION5) Explain what do you mean by Formula and Recipe?Formula is Ingredients and their proportionsReceipe is Formula + Routing.6) What are different kinds of losses?Fixed loss and Variable loss.Also, visit the following link for topics on which the interview questions can be asked for Oracle SQL, Database, Forms and Reporthttp://tenthsense.blogspot.in/2012/04/fresher-interview-for-oracle-database.html