Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Wednesday, October 24, 2012

Oracle Inventory FAQS




1.
Item transactions are maintained in the system in

a) Primary UOM   b) Base UOM  c) Transacted UOM  d) None of the above.
2.
When a pending status of “Active” is implemented, its all 8 status attributes will be

a) Un-Checked  b) Checked  c) Randomly checked  d) Depends on its Item defining attributes.
3.
An Item can be stored in an Inventory org when

a)      Only when its “Inventory item” attribute is checked.
b)      Only when its “Inventory item” and “Stockable” attributes are checked.
c)      Only when its “Inventory item” , “Stockable” and “Transactable” attributes are checked.
d)     Only when none of the above are checked.
4.
When the display attribute radio button “Org” is selected in Master Item window, attributes controlled at Org level are

a) Grayed  b) Can be modified  c) Now controlled at master level.  d) Displayed
5.
If serial no. generation is at “Item Level” , changing any item attribute to “Generation At Receipt” at Master Item window after its org. assignment in a specific organisation will have 

a) No effect  b) Full effect  c) Depends whether it is a make item or a buy item  d)  Dependent on its Uniqueness.
6.
Status attributes are closely associated with,

a)      Item dependent attribute.  b) Item controlled attribute.
c)      Org dependent attribute.    d) Item defining attribute.
7.
If “Stockable” is not checked,

a)      “Inventory Item” can not be checked.    b) “Transactable” can not be checked.
b)      “Purchasable” cannot be checked.         d) It is an expense item.
8.
Attributes controlled at Org level 

a) Can have diff. values in various org   b) Should have same values in all org.  c) Will exhibit supremacy over the attributes controlled at master level.  D) None of the above.
9.
Which is not true.

a)  A location can be restricted to an organization.       b) Every item will have a primary UOM.
c) Every item must have a description.  d) Items cannot be restricted to a sub-inventory.
10.
The sum of all the “days on”  and “days off” of all the sequences should be equal to 

a) 5 days  b) 6 days  c) 7 days  d) 8 days.
11.
In a WDC shift timing, “15 min. Coffee Break” is 

a) Allowed only in General shift  b) Not allowed in night shift  c) Possible only on holidays  d) As per the discretion of the Client.
12.
Costing method, after committing the org parameters

a) Can be interchanged  b) Can be exchanged  c) cannot be changed  d) Can be changed
13.
If receiving parameters are not defined, materials

a) Can not be received  b) Will be waiting in a Queue at the receiving section.  c) Can still be received.  d) Costed materials can be received.
14.
A conversion defined between two UOMs of the same classes is known as

a) Inter Class Conversion  b) Intra Class Conversion.  c) Local Conversion  d) Standard conversion
15.
Sub Inventories are

a) Common for all organization  b) Locator specific   c) Item specific  d) Organisation specific.
16.
An Item can be restricted to

a) An Organisation  b) A Sub Inventory  c) Another Item  d) All of the above
17.
If Cost Manager is inactive,

a) Deputy Cost manager can be entrusted the job  b) Materials can be costed  c) It has to be activated thro’ Tools-launch Manager before running cost updates.  d) None of the above. 
18.
The benefits of implementing Oracle Inventory for material management are :

a)      The Inventory org which accounts for the bulk of working capital reqt., is efficiently managed by optimizing the supply against demand generated by various other modules resulting in minimising defects, degradation and obsolescence.
b)      Multiple replenishment methods reduces Inventory levels without compromising on customer satisfaction, meeting their demands on time.
c)      Real time updates provide accurate inv. visibility and movement statistics, increasing operational efficiency and provide better control in managing exceptions.
d)     All of above.
19.
Item Import in Oracle Inventory includes :

a) Converting Inventory items of other systems.
b) Migrating assembly and components items from legacy manufacturing systems.
c) Converting customer purchase items from their system.
d) All of above.
20.
Status codes provide

a) A prestigious status to an item.
b) Provide default values to 8 status attributes for providing specific functionality for the item.
c) Enable serial and lot control for the item.
d) Groups items of similar statuses.
21.
The interface tables in Oracle Inventory includes :

a) MTL_SYSTEM_ITEMS_INTERFACE             b) MTL_ITEM_REVISIONS_INTERFACE
c) MTL_ITEM_CATEGORIES_INTERFACE       d) All of above
22.
Category in Inventory means :

a)      It is a code used to group items with similar characteristics.
b)      It classifies high and medium demanded items into various categories.
c)      Grouping items based on on-hand quantities.
d)     Sorting the items for easy ABC analysis..
23.
While transfer to GL, the accounting distribution “Inv valuation” reflects

a)      High valued items
b)      The Mat, Mat OH, Res, Res OH costs as defined in item cost update.
c)      Indicates the “list price” of the item mentioned in the Purchasing tabbed region of item master.
d)     None of above.
24.
Which is true.

a) Lot controlled items can not be serial controlled.          b) Serial controlled items can not be lot controlled.
c) Lot and serial control are independent of each other.  d) Lot and serial control are mutually exclusive.
25.
The classifications in a org structure of a manufacturing unit should contain atleast

       a) One BG                                                     b) One BG & one LE
       c) One BG, One LE & One OU                     d) One BG, One LE, One OU and one INV.
26.
To convert a single structure to a multi org structure what we have to do is to :

a)      Create multiple operating Units under org definition.
b)      Mention a default OU at “MO: Operating Unit” profile in site level of the responsibility and run “ADADMIN” utility
c)      Create multiple LE and SOBs.
d)     Establish a new manufacturing facility.
27.
Inventory Base Tables includes :

a)      MTL_SYSTEM_ITEMS_B & MTL_ITEM_ATTRIBUTES
b)      MTL_ITEM_LOCATIONS, MTL_ITEM_REVISIONS & MTL_ITEM_STATUS
c)      MTL_ITEM_CATEGORIES & MTL_ITEM_SUB_INVENTORIES
d)     All of above.
28.
Templates are used for

a)      Item copying.
b)      Defining set of attributes that can be used over and over to create / modify similar item.
c)      Assigning items to various child organizations.  d) Creating a set of items in one stroke.
29.
Which is true

a) Items can be restricted to locators.      b) Locators can be restricted to items.
c) Sub-Inventory can be restricted to items  d) Sub-Inventory and Locator restriction cannot be applied together on a item
30.
A Sub-Inventory is a

a)      Physical area to store materials and stocks and they are logically grouped based on their functionality.
b)      Branch of the main inventory organization.
c)      Functional unit, offloading the jobs of the inv. Org.
d)     Small Inventory which can store only a limited stock.
31.
Which option is more appropriate

a)      Stockable must be set to “NO” if Inv. Item is set to NO.
b)      Transactable must be set to NO if Stockable is set to NO.
c)      Purchasable must be set to NO if Purchased is set to NO.
d)     All the above are fully appropriate.
32.
If Locator control is set to NONE at Org parameters level, then

a)      Locator control can be set to “Dynamic Entry” at Sub-Inv Level.
b)      Locator control can be set as Determined at  Item Level in the Sub-Inv
c)      Locator control can be set to Prespecified only.
d)     Locator Control is disabled at Sub-Inv and Item levels.
33.
Receipt routings are

a)  Direct, Standard and In-Transit       b) Direct, Inspection and In-Transit
c)  Direct, Standard and Inspection      d) Standard , Inspection and In-Transit.
34.
The pre-requisite for Inter org transfer is

a)      The shipping methods must be set
b)      The shipping network must be set.
c)      Item to be restricted to Sub-Inventory
d)     The shortage parameters must be defined, which initiates a inter org transfer.
35.
In a direct org transfer

a)      Cost and time of transfer are negligible.
b)      Cost and time of transfer are appreciable.
c)      We can use our employees to transfer goods between org.
d)     Material will be routed through our intermediate sub-inventory.
36.
In the Inv tabbed region of the Org items, Locator control cannot be set to “Dynamic Entry” if

a)  SI is restricted.                                   b) Locator is restricted.
c) Serial and Lot control are enabled.     d) There are no restrictions.
37.
In a non-tracked sub inventory which is true

a)      On-hand quantities can be maintained in the system.
b)      Only useless items will be stored in this sub-inventory.
c)      They are replenished by Replenishment counting for stock maintenance.
d)     Materials can be quickly transferred .
38.
The check box “Reservable” is checked in sub-inventory definition to

a)      Facilitate Order management to reserve items for a sales order.
b)      Facilitate last minute reservation using the Tatkal system also.
c)      To reserve item for purchasing.
d)     Reserve supplies by WIP for an assured supply to manufacturing Organization.
39.
While defining Inv. Org the following are mandatory in the “Others” region

a)      Acct. info, Sup / Cust. Association and Inv info.
b)      Sup / Cust Info, Inv info and receiving info
c)      Acct. info, Inv. Info and Receiving info
d)     Any of above
40.
Costing method once defined and saved is

a) Non-updatable  b) Updatable  c) Dynamically changed during SI creation.  d) None of above.
41.
While replenishing, Inventory will search for item sourcing (either from SI, Inv or supplier) in the following order

a)      Org parameters, Item master, SI and finally in Item-Sub Inv.
b)      Item-Sub Inv, SI, Item master and finally in Org parameters.
c)      First in Sub-Inventory, and if not available, in Item master.
d)     Nearest point of material availability.
42.
Item attributes are

a)  Independent of each other                                                                           b) Interdependent of each other.
c) Some are related as Required, Interdependent and Updatable attributes.  d) None of above
43.
Which of the following Key Flex field structure is updatable

a) Item catalogues                                          b) Item categories
c) Sales Orders                                               d) System Items
44.
 Misc. transactions can be performed if

a) GL period is opened b) GL and Inv period of the org are opened. c) Purchasing period are opened d) No need to open periods
45.
Which is true

a)      Every functional area has a default category set.
b)      Every responsibility has a default category set.
c)      Every user has a default category set.
d)     Every employee is assigned a default category set.
46.
Which is true

a)      Organisations are assigned to items
b)      Some attributes are only assigned to various org, which take diff values.
c)      Items are assigned to organizations
d)     Status attributes need not be assigned, as they get self-assigned.
47.
Inv. Org code is a

a) 2 letter AN code  b) 3 letter AN code  c) 4 letter AN code   d) IMO code
48.
In a physical Inventory

d)     Sequences are generated for counting b) ABC classes are associated for grouping. c) Tags are generated for counting d) A snap shot photograph is taken on items & enlarged so that counting can take place easily by seeing photos.
49.
Cyclic counting is for

a) Counting the no. of persons coming in cycles.  b) Establishing the Inventory accuracy.
c) Utilising the excess man power.                        d) Increasing customer satisfaction.
50.
 A Kanban pull sequence will

a)      Specify the supply source, location and the kanban size for a kanban item.
b)      Pull the materials from wherever it is available.
c)      Replenish all shortages immediately. d) Have one Kanban card for every Kanban item.




1
a
2
B
3
b
4
d
5
a
6
d
7
b
8
a
9
d
10
c
11
d
12
c
13
a
14
b
15
d
16
b
17
c
18
d
19
d
20
b
21
d
22
a
23
b
24
c
25
d
26
b
27
d
28
b
29
a
30
a
31
d
32
d
33
c
34
b
35
a
36
b
37
c
38
a
39
c
40
a
41
b
42
c
43
b
44
b
45
a
46
c
47
b
48
c
49
b
50
a


No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect