Interview Questions for Oracle 11i Apps (Manufacturing)


Hello Friends, here some of Inventory Questions , mostly in context on Item Setup. It has been long time i work on inventory module, it used to be one of my favorites and strongest modules sometime. still inventory bring lot of good challenging work. hope you will benefit from these Q & A.

 

Q. Once an item is assigned to an organization, is it possible to remove this association at a later time?
A. If you have assigned an item to an organization, it can only be deleted from that organization if the item has NOT been transacted. If it has been transacted against you cannot delete the item from the organization. You can, however, make the status of the item “inactive” on the main region of the Item Define form INVIDITM in ‘Item Status’ field. This will prevent users from transacting against the item although the item will continue to be included in LOV’s. 

Q. How do you setup Unit of Measure for an item?
A. When transacting an item, it will always default to the defined Primary Unit of Measure, so if you need to use another UOM, you must select it from the List of Values when you transact it. This implies that you want the Primary Unit of Measure to be that which is used most often and which is likely to be the smallest unit of that type of item. Once you have set the primary UOM for an item, it CANNOT be changed.

 

Q. How do I change an item’s locator control method once I have transacted against it, for example from No Control to Prespecified?
A. You cannot change this attribute if there is onhand quantity for the item. You must first perform a miscellaneous issue of all quantity. Then the attribute can be changed and once the locator(s) are set up, you can perform a miscellaneous receipt to receive the quantity back into a specified subinventory/locator.

 

Q. How do I change an item’s Unit of Measure?
A. You CANNOT change the UOM for an item once the UOM is assigned to the item. The suggested solution is as follows: If the item has not been transacted you can delete the item and then re-add it with the correct UOM. If the item has been transacted and has no outstanding orders, purchase orders or WIP jobs you can do the following if approved by your management.
1. Rename the existing item ‘123’ to ‘123-Bad UOM’ and save the item. Any prior history for item ‘123’ will now be associated with item ‘123-Bad UOM’.
2. Add a new item ‘123’ with the correct UOM.

 

Q. How do I delete an Item Template I no longer use?
A. Suggested steps to follow to delete unwanted Item Templates:
1. Navigate Setup: Items: Templates – Find Item Templates form appears.
2. Click on the LOV, and select the Item Template that is to be removed.
3. Click the [Find] button on the Find Item Templates form. The Item Templates Summary form appears, with the Item Template selected.
4. Click the [Open] button on the Item Templates Summary form, and the Item Templates form appears.
5. From the menu, select Edit | Delete Record, then select Action | Save and Proceed. 6. Close the Item Templates Summary form. Be careful not to delete Item Templates you may need again as they are not retrievable once deleted.

 

Q. Is there a way to create custom item attributes?
A. No but you can create and define the descriptive flexfield for this form. This will allows you to associate additional data with an item such as an attribute. See the Oracle System Administrators
Users Guide and the Oracle Flexfields Manual for information on creating Descriptive Flexfields.

 

Q. Why does the application prompt you for Organization when you enter the Master Item form for the very first time even though you have only one Master Organization.
A. Once you setup a Multi-Org environment and you enter the form for the first time, there is the possibility there can be more than one Master Organization. The application
therefore prompts you for an organization which is then used to determine the Master Organization associated with it. In other words, you are choosing the Master Organization by choosing one of the Orgs that belongs to it.

 

Q. How do you change the control level for item attributes from master level to organization level for example. When I try to change this in the Attribute Control Form, I get the message: frm-40200: field protected against update.
A. First change value of the field called “status” to “not used”. You should then be able to change the control level of the attribute from master level to org level. Make sure and change to status back to what it was before the change and save the record.

 

Q. How do I inactivate an item?
A. On the Master Item Form (Inventory->Items->Master Items), change the item status field to “Inactive” or any another defined status which disables all attributes that make an item usable (stockable, shippable, orderable, etc.). The “Inactivate” status comes pre-seeded with the Application and is for this purpose.

Q. What characters can I use in an item name (including special characters)?
A. The only hard fast rule is not to use the character designated in the segment delimiter for the System Item Flexfield. Also, you will not be able to enter any characters not allowed by the valueset associate with the flexfield. It is recommended that you avoid the use of any char that can be used as a delimiter to avoid future problems. It is best to not use special characters like #@%& if at all possible as these may have a negative impact down the road. Some characters, like percent (%), underscore (_), and pound(#), have special meaning when performing queries by form as do the query operator characters (=!><).

 

Q. Can you change the costing enabled and inventory asset flags on an item that has already been transacted against even if there is no on-hand quantities for the item?
A. Yes, you can change the flags. If you are changing the flags from checked to unchecked you will receive a warning that the associated cost records will be deleted alerting you that the Cost of Goods will not be calculated any longer for transactions of this item. In effect what you are doing is changing the item from an asset item to an expense item. If you are changing the flags from being unchecked to checked then a database
trigger will fire and cause cost records to be added for this item. There is no warning that is given.

 

Q. When I create a new item, and choose to assign to All orgs, the application allows me to even though some of those organizations are restricted to my responsibility. Is this the way it is supposed to work? If I assign in an Organization by Organization fashion, I am not allowed to assign to the restricted organizations.
A. The situation described is standard functionality. Even if a responsibility has limited access to a certain number of organizations, the “Assign to All Organizations” check box will assign the item to all orgs, not just the ones limited to the user’s responsibility.

 

Q. How do you tell that an item is an expense item or asset item?
A. Navigate to the Organization Items form: Inventory->Items->Organization Items. Query up the item in question. Change to the “Costing” alternative region. The value of the “Inventory Asset Value” flag determines this. If checked, the item is an asset item.

 

Q. Is there a way to delete or disable an item revision once entered?
A. There is no way to delete a revision nor is there a way to disable it. It must remain there for historical data. The suggested workaround is to create a new item, transfer any Quantity on-hand from the old item to new item and delete the old item. The only down side is you will lose some transaction history.

For more interview Question click here https://knoworacle.wordpress.com/2008/06/26/oracle-applications-technical-interview-questions/

 Thanks – Shivmohan Purohit

 

11i Manufacturing Expert – Devendra Gulve


Name

Devendra Gulve

Expertise

Module: INV, BOM, OM, Depot Repair

 skill area: Manufacturing and Distribution

Organization

Current: Zensar Technologies, Pune, India

Past: Mahindra & Mahindra Nashik, Valley Gauges, Pune.

Contacts

Email:devendragulve@gmail.com                        

blog/site: http://functionalguy.blogspot.com/

 

1.      Tell something about you, your professional experience/ background, past assignment, Interests.

Ans: I was in Manhindra and Mahindra, Nashik for some days as a Trainee Engineer. After Engineering I joined Valley Gauges in Pune. In 2005 I joined Symbiosis for doing full time MBA in IT. After MBA I joined Zensar Technologies, Pune. In Zensar I am working as a Oracle Apps Associate Consultant. The project I am working in has only one Functional person and that’s me, so I need to handle all the issues irrespective of the module or domain. I am getting very wide exposure to the system in this project.

2.      If any professional want to become functional consultant (either in manufacturing or financials), how she/he should take it and go ahead?

Ans: Anybody who wants to be a functional consultant in any domain has to have the knowledge of the processes followed in that particular domain. For example a Finance consultant has to know the accounting entries, details of P/L, Balance sheet etc and a Manufacturing consultant must know how material flows on the shop floor, how material is managed, classified, located, controlled as well as process to fulfill the order etc. The list of things one must know is unlimited but to start one shall know the basic standard processes followed in the particular functional area.

3.      Give some commonly used Functional Concepts/ Questions in Oracle Applications’ Manufacturing Modules.

Ans: I do not a great experience of taking / giving interviews, still I can try list down some points. But the questions definitely flow on the basis of past experience and the requirement of the client.

·        Types of transactions, actions associated with the transaction.

o       E.g. Sub-inventory transfer, Sales order issue, PO receipt, etc

o       Actions associated will the accounting entries, change in on-hand, sub-inventory valuation, etc.

·        Order-to-cash cycle

·        Organization structure

·        What are the various intra-operation steps?

o       Queue, run, to move, reject, scrap

·        What are the different types of Bill of Material?

o       Standard, Model, Option class, Planning, Product Family

·        What are the item attributes for an item to enter the sales order?

o       Customer ordered, Customer order enabled, OE transactable.

·        What is a modifier?

o       Modifiers enable you to set up price adjustments (for example, discounts and surcharges), benefits (for example, free goods, coupons) and freight and special charges that the pricing engine applies immediately to pricing requests or accrues for later disbursement.

·        MRP, MPS, MDS

·        Use of Bill of Material.

I will try to list down more questions modules / process wise at add it to my blog i.e. http://functionalguy.blogspot.com/

4.      What Oracle Configurator module does what the general feature and how it used in Oracle Applications.

Ans:  Oracle Configurator is the product from Oracle which gives you the flexibility to configure the BOM at the time of entering as order as per the customer requirement. You don’t need to defined deferent combination of your offerings prior the order. It saves times, maintenance cost etc. To use this in Oracle Apps you need to do some setups which are summarized at http://functionalguy.blogspot.com/2008/04/setup-for-oracle-configurator.html if one needs to use complex logic to define the dependencies of the option selected then he/she can go for Oracle Configurator Developer for the complex logic.

5.      What is Kanban method, how it used and implement in Oracle Inventory. What are the other related concepts with kanban and oracle inventory?

Ans: Kanban is a material control / management system, which is a part of Lean manufacturing. In this kanban cards are used to show status (Empty / Full) of the bin carries components. Once the bin become empty the process to fulfill it starts. For more details please visit http://functionalguy.blogspot.com/2007/04/kanban-introduction-and-benefits.html

6.      Your advice/ Suggestion for Oracle Technical and Functional Professions

Ans: I can’t give suggestions just like that. Improvement comes with time and combination of success and failure.

7.      Your feedback on Knoworacle.wordpress.com

Ans: I really appreciate your efforts towards this blog. It is well manages and in the easy language to understand. You are also planning to start free on-demand training through your blog is appreciable. One more thing which I liked is you are coming-up with the T-shirt with your blog’s logo and name. Great work, please keep-up and let me know in case I can help you.

here you can find his contribution here– click here

Thanks – Shivmohan Purohit ( knoworacle.wordpress.com )