Oracle SCM functional interview FAQ: 1) Difference between physical and Cycle Count !) "hy can#t we do physical Count as Cycle count $) %ow to achieve Cross Doc& for partial 'uantity or Cross doc&in( for 1 Sales Order and not for other Sales order ) %ow to print label for different supplier durin( receivin( differently differently *) Difference between +lanned +O and ,+A -) Can we auto create standard +O fro. /,+A sa.e as release created fro. ,+A 0) %ow we can assi(n the tas&s to e.ployees auto.atically ) %ow to 'uery in "arehouse Control ,oard 2) Can we copy 3FQ on 'uotations 14) %ow .ails sent to supplier after approvin( +O 11) 5ypes of routin( in 3eceivin( 1!) Can we use ! way on inventory ite.s 1$) 6n 3eceivin( options7 what are the .a8or fields 1) Approval hierarchy9routin( based on si.ilar position9na.es 1*) %ow to Auto +rint "MS label for one ite. and not for other 1-) se of +O Forward Forward docu.ents in Mana(e.ent Mana(e.ent 10) Can we create standard +O by create release functionality 1) %ow ;M< label data sent to printer 6=e= its not printin( as shown in ;M< therefore so how printer print labels 12) 6 want to display all $ thin( say ite.7 <+> and Sub inventory in sa.e line= %ow to achieve that !4) %ow to use Advance pricin( in +urchasin( !1) 6te. attribute in M3+ and /eneral plannin( tabs in ite. setups !!) is it possible to send notification to all your supervisors in e.ployee supervisor hierarchy !$) "hat are basic setups to use MSCA or "MS !) "hy there is a need of two blan&et +O in AS< attributes attributes !*) %ow .achines assi(ned to a particular tas& is .achine is also a resource or only person is a resource if .achine is not a resource how we assi(n it to a person or tas& !-) 5ype of
6nterview ,S QuiB ,oo&s Foru. Others •
Short Stories
•
arn Fro. ,lo((in(
FAQs Openin(s Services Contact s
Thursday, July 3, 2014
Order Management Interview Questions Part 2 1 !hat are the various order management "ro#esses su""orted $y ora#le OM •
•
•
•
%tandard orders: orders : 5his .ethod supports Ma&e to Stoc& business .odel where the products are .ade and &ept in stoc&= 5he products are then shipped to the custo.er based on his order= &on'igure to orders: orders : this .ethod supports Asse.ble to Order business .odel= 5he product confi(uration is chosen at the ti.e of sales order entry= "6+ 8ob is created based on the re'uire.ent of the sales order (ro" shi" orders) 6n orders) 6n this .ethod7 your supplier supplier will will ship the (oods to your custo.er on your behalf Internal sales orders: orders : 6nternal 6nternal sales orders are created across two two different or(aniBations of the sa.e business (roup= 6nternal re'uisition is raised first and is converted to an internal sales order where the ite.s are shipped based on the 'uantity specified in the internal sales order=
2 (es#ri$e the order order 'low in Order Order to &ash li'e #y#le •
nter the sales order
•
,oo& the sales order
•
+ic& release
•
Ship confir.
•
Auto 6nvoice (eneration (eneration
•
Creatin( receipt
•
5ransfer to /< 3= (es#ri$e the "ro#esses involved a'ter entering sales order*
•
5he ite.s specified on the order are validated in Oracle 6nventory
•
5he price of the ite.s are calculated usin( the pricin( en(ine
•
5he availability of the ite.s are chec&ed and .ay be reserved
•
5he ite.s are then pic& released and shipped to the custo.er= 4 !hat are the di''erent ty"es o' sales orders availa$le*
•
Standard
•
Mi@ed
•
3eturn + !hen is an item eligi$le 'or #ustomer order*
"hen the attributes &ustomer Ordered- and &ustomer order ena$led-are ena$led- are chec&ed in the order .ana(e.ent tab of Master 6te.s= . (es#ri$e the /eader /eader status during the sales order "ro#ess* "ro#ess* nterin( the sales order
ntered
,oo&in( the sales order
,oo&ed
+ic& release the order
,oo&ed
Ship confir. the order
,oo&ed
3unnin( interface trip stop
,oo&ed
(es#ri$e the line line status during during the sales order "ro#ess* "ro#ess* nterin( the sales order
ntered
,oo&in( the sales order
Awaitin( Aw aitin( shippin( when sufficient 'uantity is available)
Supply eli(ible when sufficient 'uantity is not available) +ic& release the order
+ic&ed
Ship confir. the order
Shipped
3unnin( interface trip stop
Closed
(i''erentia (i''erentiate te availa$le uantity and onhand uantity* uantity* Available 'uantity 'uantity 3eserved 'uantity E Onhand 'uantity 'uantity (i''erentia (i''erentiate te %u""ly 5ligi$le %tatus and %u""ly Partial %tatus* %u""ly 5ligi$le "hen there is no sufficient 'uantity available= available= @a.ple: "hen user tries to boo& a sales order for 6te. G5est6t G5est6te.# e.# for a 'uantity of 14 but the ite. contains Bero 'uantity= 5hen the Sales Order < ine Status chan(e to GSupply li(ible#= %u""ly Partial when the 'uantity is partially available= @a.ple: "hen user tries to boo& a sales order for 6te. G5est6t G5est6te.# e.# for a 'uantity of 14 but the ite. contains only 'uantities= 5hen the Sales Order
Settin( +rofile option H OM:AutoSchedule to yes
•
Fro. 5ools 5ools MenuIChec& Autoschedule Chec&bo@ in Sales Order Screen=
•
3i(ht Clic& on Sales Order
•
Schedule Order Concurrent +ro(ra.= 12 (i''erentiat (i''erentiate e shi" set and and arrival set*
6n the shi" set "ro#ess7 "ro#ess 7 the user would li&e to ship (roup of order lines fro. sa.e warehouse to sa.e location= 6f Order
pdate the order .ana(e.ent OKO3D3K<6>SKA<<) 5ri((er the inventory interface 5O +DA5 6nventory tables) 23= !hen is dro" shi" order #reated* •
Custo.er re'uires an ite. that is not stoc&ed nor.ally
•
Custo.er re'uires lar(e 'uantities of the ite. that is not available with you
•
6t is .ore econo.ical when the supplier sends the ite. directly to the custo.er 24 !hat is 6%<* 6t is an advanced Ship.ent >otice which is trans.itted via lectronic Data 6nterchan(e D6) fro. a supplier to let the receivin( or(aniBation &now that the ship.ent is arrivin(= 5he AS> contains the ship.ent date7 ti.e7 identification nu.ber7 pac&in( slip data7 frei(ht infor.ation etc 2+= !hat is 6utoinvoi#e* 6t is a concurrent pro(ra. which is used to perfor. the invoice processin(= Once the order or lines are eli(ible for invoicin(7 the invoice interface wor&flow activity interfaces the data to reeivables 2.= 59"lain the di''eren#e $etween a #redit memo and an invoi#e* Credit .e.o is raised to partially or fully reverse an ori(inal invoice a.ount An invoice is (enerated in receivables which show the a.ount owed by the custo.ers for the purchase of (oods or services= 6t .ay also contain ta@ and frei(ht char(es 2= !hat is =O:* 5he ter. FO, .eans Frei(ht or free) on ,oard is co..only used when shippin( (oods to indicate who pays loadin( and transportation costs7 and9or the point at which the responsibility of the (oods transfers fro. shipper to buyer= LFO, shippin( point or LFO, ori(in indicates the buyer pays shippin( cost and ta&es responsibility for the (oods when the (oods leave the seller#s pre.ises= LFO, destination desi(nates the seller will pay shippin( costs and re.ain responsible for the (oods until the buyer ta&es possession= 2= !hat are the di''erent 8M6 Order Ty"es* 8M6 with &redit is used when the custo.er returns the physical product and also receives credit as a result of the return= 8M6 no &redit is used when the custo.er will return the product but will not be receivin( a credit as a result of the return= 8M6 &redit only is used when the custo.er will receive a credit7 but the physical return of the product is not re'uired= 2= !hat are the ne#essary setu"s to "er'orm Internal %ales Order*
•
6nternal Order and 6nternal Ordered nabled set to GNes#=
•
Shippin( >etwor&6ntransit or Direct) .ust be defined=
•
6nternal Custo.er .ust be defined
30 !hat are Modi'iers and Quali'iers* Modifiers are discount7 surchar(e or special char(e that .ay be applied to the base price and .ay alter the value of the ite.= 6t can be applied either at order level or at the line level= A 'ualifier helps you define who is eli(ible for a price list or .odifier= A 'ualifier can be a custo.er na.e7 a custo.er class7 an order type7 or an order a.ount that can span orders= 31= !hat are the "ossi$le reasons 'or Inter'a#e tri" sto" to #om"lete with 5rror* Few reasons .ay be 1) Order is on %old !) 5a@ is not applied properly $) On%and 'ty is not available in the 6nventory ) 6nventory +eriod is not open *) Ma&e sure Schedule Ship Date or 3e'uested Date is within the ran(e of order Date
6nterview ,S QuiB ,oo&s Foru. Others •
Short Stories
•
arn Fro. ,lo((in(
FAQs Openin(s Services Contact s
Monday, June 2, 2014
Order Management Interview Questions Followin( 'uestions 6 have ca.e across on various blo(s and sites and posted for your reference here also Q) !hat are the Pro#ess &onstraints* A: +rocessin( Constraints allow Order Mana(e.ent users the ability to allow or disallow chan(es to various Order Mana(e.ent docu.ents li&e Sales order7 Sales a(ree.ent etc to avoid data inconsistencies and audit proble.s= Nou can access it at OMIsetupI3ulesIsecurityI+rocessin( Constraints Q) !hat is a Pi#7 %li" 8e"ort* A: +ic& slip report is (enerated after release sales order and it is used by warehouse personnel to pic& ite. fro. various inventories for shippin( the. to a custo.er= Q) 6t what stage an order #annot $e #an#elled* A: 6f the order is +ic& Confir.ed7 it cannot be cancelled=
Q) !hen the order im"ort "rogram is run it validates and the errors o##urred #an $e seen in* A: Order Mana(e.ent 3esponsibility IOrders7 3eturns : 6.port OrdersI Corrections Q) !hat is the di''eren#e $etween "ur#hase order >PO? and sales order* A: +urchase Order: 5he docu.ent which is created and sent to supplier when we need to purchase so.ethin(= ,uyin() Sales Order: 5he docu.ent which is created when custo.er p laces an order to buy so.ethin(= Sellin() Q) !hat are "rimary and se#ondary "ri#e lists* A: +rice list contains infor.ation on ite.s and its prices= 5he pricin( en(ine uses secondary price lists when it cannot deter.ine the price for an ite. usin( the price list assi(ned to an order= Q) "KD<6J36S7 OKO3D3K%AD3SKA<<7 OKO3D3K<6>SKA<<7 M5SAC56O>S Q) /ow is move order generated* A: "hen the order is pic& released7 it (enerate a .ove order to to pic& .aterial fro. various subinventories= Nou can transact it .anually or auto.atically based on settin( in 3elease orders= Q) !hat is OA/M>5 Q) !hat does :a#7 ordered mean in OM* A: An unfulfilled custo.er order due to none@istence of the ordered ite.s in the 6nventory= Q) !hat are "i#7ing rules* A: A userdefined set of criteria to define the priorities which Order Mana(e.ent uses when pic&in( ite.s out of finished (oods inventory to ship to a custo.er= +ic&in( rules are defined in Oracle 6nventory= 6f "MS installed then you can d efine user (enerated +ic&in( rules and strate(ies= Q) !hat is dro" shi" in OM* A: 6ts a .ethod of directly shippin( product fro. your supplier to your Custo.ers= Q) !hat are (e'aulting 8ules* A: "hile creatin( the order7you can define defaultin( rules so that the default values of the fields pop up auto.atically instead of typin( all infor.ation= Q) !hat are validation tem"lates* A: A validation te.plate na.es a condition and defines the se.antics of how to validate that condition= Jalidation te.plates can be used in the processin( constraints fra.ewor& to specify the constrainin( conditions for a (iven constraint= Q) !hat are di''erent Order Ty"es* A: Order Only7 Mi@ed7 3MA Q) 59"lain the Order &y#le* A: ,oo& the order I +ic& 3elease I +ic& Confir. I Ship Confir. I Close the order Q) !hat is "a#7ing sli"* A: An e@ternal shippin( docu.ent that is sent alon( with a ship.ent ite.iBin( in detail the contents of that ship.ent= Q) !hen an order #annot $e deleted* A: 6f the Order is +ic& Confir.ed=
Si.plifyin( Oracle ,usiness Suite= 5his blo( is dedicated to share Oracle Apps Pnowled(e related to Oracle apps ,usiness Suite?s Order Mana(e.ent7 +rocure.ent7 6nventory7 "MS7 Supplier Schedulin(7 OS+7 Sys Ad.in7 seful SQ< Queries etc •
Home
•
Tutorials Order Mana(e.ent
o
Order Mana(e.ent
Advance +ricin(
D6 3
+rocure.ent
o
+rocure.ent
Supplier Schedulin(
o
6nventory
o
OS+
o
Syste. Ad.inistrator
o
5echnical
5echnical
seful Queries
For. +ersonaliBation
F>D 5ables
% +arties 5ables Account +ayables 5ables
"MS
o
6nterview ,S QuiB ,oo&s Foru. Others •
Short Stories
•
arn Fro. ,lo((in(
FAQs Openin(s Services Contact s
Monday, June 2, 2014
Order Management and %hi""ing &on#e"ts and interview Questions What is a Delivery?
A delivery consist of delivery lines that are scheduled to be shipped to customer ship to location. You can manually or automatically create a delivery and group lines. A delivery can have delivery lines from multiple sales order. You can control Auto create Delivery in Shipping Parameters Pick Release tab and Delivery Grouping criteria in delivery tab. What is a Pick Release?
A Pick Release is to release eligible delivery lines for picking material to full a customer order. When you pick release system find eligible delivery lines to be released for picking based on release rules and create a pick slip report !hich then handed over to operator for picking Picking rules" Specify !hich material to be picked based on picking rules defined i n oracle inventory. #his is used to help system determines Pick from Sub inventory$%ocator. Release se&uence Rules" #his specify the order in !hich eligible delivery lines are released on shop floor. #his is based on the follo!ing" •
'rder number
•
'utstanding invoice value
•
Scheduled date
•
Departure date
•
Shipment priority
What are the methods of Pick Release?
•
•
Online Mode: (t pick Release immediately !ithout !aiting for the order to process through the concurrent manager. You can see this option !hen releasing sales order from release sales order form. Concurrent : #his enable you to run pick release in background along !ith other re&uest.
•
•
Standard Report Submission" SRS you call it. You can schedule this program and it runs in the background several time in a day. Shippin !ransaction Windo": You can use action button in shipping transaction form to pick release.
!hat are Tri"s* >re'er ) Ora#leAB? A trip is an instance of a specific frei(ht carrier departin( fro. a particular location containin( deliveries= A trip is carrier specific and contains at least two stops such as a stop to pic& up (oods and another stop to drop off (oods7 and .ay include inter.ediate stops= 5rips can be created auto.atically or .anually= Auto.atic 6f your shippin( process does not re'uire advanced plannin(7 you .ay prefer to auto.atically create trips: Autocreatin( a trip for a delivery: Nou can find the delivery you want to ship7 and autocreate a trip and related trip stops= Autocreatin( a trip for containers and lines: Nou can find the lines and containers you want to ship and autocreate a trip which creates a trip7 related deliveries7 and trip stops= Manual Durin( transportation plannin(7 you can .anually create a trip and later assi(n delivery lines or find the delivery lines and create a trip= For [email protected] for a re(ular trip scheduled to depart every Friday7 you can .anually set up a trip ahead of ti.e and then assi(n delivery lines= "hen you .anually create a trip7 you can .anually assi(n stops7 deliveries7 and delivery lines to that trip=
!hat is Item &ross 8e'eren#e* 6te. cross reference is used to lin& our ite. with supplier or custo.er ite.= !hat is a Modi'ier and what are di''erent ty"es o' Modi'iers* A .odifier is used to ad8ust the price on sales order lines= 6t includes ad8ust.ents7 benefits7 Frei(ht and special char(es= @a.ples : Discount etable on %and 'uantity
Supply : +lanned Order7 Scheduled 3eceipts7 Discrete Robs De.and : Sales Orders7 Discrete Robs Nou can refer below lin&= there is e@cellent slide by apps learn http:99applearn=blo(spot=in9!44294$9availabletopro.iseatpinoracle=ht.l !hat is an 8M6* 3MA stands for 3eturn Material AuthoriBation= 6t used to receive .aterial bac& fro. custo.er if ther eis any defect= Nou can confi(ure approvals for 3MA= !hats is a #redit #he#7 'un#tionality in Ora#le Order Management* +lease refer http:99.andeeporacle=blo(spot=co.9!4194$9creditchec&functionalityinorder=ht.l
!hats is Over Pi#7ing* Over pic&in( is used to pic& .ore than what is ordered and you can define over pic& tolerances at ite. level in order .ana(e.ent tab or in profile option OM: Over Ship.ent 5olerance /ow to %hi" in 'astest way* Chec& the Autodetail option in +ic& 3elease= Set the profile 6>J: Detail Serial >u.bers to GNes#= 6nventory will then su((est serial nu.bers durin( the Detailin( process= Do not chec& the +ic& Confir.ation 3e'uired fla( in the Or(aniBation +ara.eters for.= there by a voidin( pic&in( confor.ation step &an you u"date the %ales Order on#e it is :oo7ed* 6t depends on processin( constraints set up in Order Mana(e.ent= So.e of the. are seeded and can not be .odified but so.e you can confi(ure on your own= !hat are the "rereuisites o' the %ales Order* Nou need to define Custo.ers7 +rice
Order
•
3eturn
•
Mi@ed
Si.plifyin( Oracle ,usiness Suite= 5his blo( is dedicated to share Oracle Apps Pnowled(e related to Oracle apps ,usiness Suite?s Order Mana(e.ent7 +rocure.ent7 6nventory7 "MS7 Supplier Schedulin(7 OS+7 Sys Ad.in7 seful SQ< Queries etc •
Home
•
Tutorials
o
Order Mana(e.ent
Order Mana(e.ent
Advance +ricin(
D6 3
+rocure.ent
o
+rocure.ent
Supplier Schedulin(
o
6nventory
o
OS+
o
Syste. Ad.inistrator
o
5echnical
5echnical
seful Queries
For. +ersonaliBation
F>D 5ables
% +arties 5ables Account +ayables 5ables
"MS
o
6nterview ,S QuiB ,oo&s Foru. Others •
Short Stories
•
arn Fro. ,lo((in(
FAQs Openin(s Services Contact s
Monday, June 2, 2014
Order Management and %hi""ing &on#e"ts and interview Questions What is a Delivery?
A delivery consist of delivery lines that are scheduled to be shipped to customer ship to location. You can manually or automatically create a delivery and group lines. A delivery can have delivery lines from multiple sales order. You can control Auto create Delivery in Shipping Parameters Pick Release tab and Delivery Grouping criteria in delivery tab. What is a Pick Release?
A Pick Release is to release eligible delivery lines for picking material to full a customer order. When you pick release system find eligible delivery lines to be released for picking based on release rules and create a pick slip report !hich then handed over to operator for picking Picking rules" Specify !hich material to be picked based on picking rules defined i n oracle inventory. #his is used to help system determines Pick from Sub inventory$%ocator. Release se&uence Rules" #his specify the order in !hich eligible delivery lines are released on shop floor. #his is based on the follo!ing" •
'rder number
•
'utstanding invoice value
•
Scheduled date
•
Departure date
•
Shipment priority
What are the methods of Pick Release?
•
Online Mode: (t pick Release immediately !ithout !aiting for the order to process through the concurrent manager. You can see this option !hen releasing sales order from release sales order form.
•
Concurrent : #his enable you to run pick release in background along !ith other re&uest.
•
•
Standard Report Submission" SRS you call it. You can schedule this program and it runs in the background several time in a day. Shippin !ransaction Windo": You can use action button in shipping transaction form to pick release.
!hat are Tri"s* >re'er ) Ora#leAB?
A trip is an instance of a specific frei(ht carrier departin( fro. a particular location containin( deliveries= A trip is carrier specific and contains at least two stops such as a stop to pic& up (oods and another stop to drop off (oods7 and .ay include inter.ediate stops= 5rips can be created auto.atically or .anually= Auto.atic 6f your shippin( process does not re'uire advanced plannin(7 you .ay prefer to auto.atically create trips: Autocreatin( a trip for a delivery: Nou can find the delivery you want to ship7 and autocreate a trip and related trip stops= Autocreatin( a trip for containers and lines: Nou can find the lines and containers you want to ship and autocreate a trip which creates a trip7 related deliveries7 and trip stops= Manual Durin( transportation plannin(7 you can .anually create a trip and later assi(n delivery lines or find the delivery lines and create a trip= For [email protected] for a re(ular trip scheduled to depart every Friday7 you can .anually set up a trip ahead of ti.e and then assi(n delivery lines= "hen you .anually create a trip7 you can .anually assi(n stops7 deliveries7 and delivery lines to that trip=
!hat is Item &ross 8e'eren#e* 6te. cross reference is used to lin& our ite. with supplier or custo.er ite.= !hat is a Modi'ier and what are di''erent ty"es o' Modi'iers* A .odifier is used to ad8ust the price on sales order lines= 6t includes ad8ust.ents7 benefits7 Frei(ht and special char(es= @a.ples : Discount etable on %and 'uantity Supply : +lanned Order7 Scheduled 3eceipts7 Discrete Robs De.and : Sales Orders7 Discrete Robs Nou can refer below lin&= there is e@cellent slide by apps learn http:99applearn=blo(spot=in9!44294$9availabletopro.iseatpinoracle=ht.l !hat is an 8M6*
3MA stands for 3eturn Material AuthoriBation= 6t used to receive .aterial bac& fro. custo.er if ther eis any defect= Nou can confi(ure approvals for 3MA= !hats is a #redit #he#7 'un#tionality in Ora#le Order Management* +lease refer http:99.andeeporacle=blo(spot=co.9!4194$9creditchec&functionalityinorder=ht.l
!hats is Over Pi#7ing* Over pic&in( is used to pic& .ore than what is ordered and you can define over pic& tolerances at ite. level in order .ana(e.ent tab or in profile option OM: Over Ship.ent 5olerance /ow to %hi" in 'astest way* Chec& the Autodetail option in +ic& 3elease= Set the profile 6>J: Detail Serial >u.bers to GNes#= 6nventory will then su((est serial nu.bers durin( the Detailin( process= Do not chec& the +ic& Confir.ation 3e'uired fla( in the Or(aniBation +ara.eters for.= there by a voidin( pic&in( confor.ation step &an you u"date the %ales Order on#e it is :oo7ed* 6t depends on processin( constraints set up in Order Mana(e.ent= So.e of the. are seeded and can not be .odified but so.e you can confi(ure on your own= !hat are the "rereuisites o' the %ales Order* Nou need to define Custo.ers7 +rice
Order
•
3eturn
•
Mi@ed
Ora#le 5 :usiness %uite %ello and "elco.e to Si.plifyin( Oracle ,usiness Suite= 5his blo( is dedicated to share Oracle Apps Pnowled(e related to Oracle apps ,usiness Suite?s Order Mana(e.ent7 +rocure.ent7 6nventory7 "MS7 Supplier Schedulin(7 OS+7 Sys Ad.in7 seful SQ< Queries etc •
Home
•
Tutorials
o
Order Mana(e.ent Order Mana(e.ent Advance +ricin(
D6 3
+rocure.ent
o
+rocure.ent
Supplier Schedulin(
o
6nventory
o
OS+
o
Syste. Ad.inistrator
o
5echnical
5echnical
seful Queries
For. +ersonaliBation
F>D 5ables
% +arties 5ables Account +ayables 5ables
"MS
o
6nterview ,S QuiB ,oo&s Foru. Others •
Short Stories
•
arn Fro. ,lo((in(
FAQs Openin(s Services Contact s
Thursday, July 3, 2014
Ora#le Inventory Interview Questions !hat is an item* Answer: An ite. is a part or services where you can +urchase7 Sell7 +lan7 Manufacture7 Stoc&7 Distribute and +rototype= 6te.s can also be containers for ite.s as well as co.ponents you build into other ite.s=
59"lain Item Master OrganiCation* Answer: An ite. .aster or(aniBation is a lo(ical entity where you define the ite.= After you define an ite. in the ite. .aster7 you can assi(n it to any nu.ber of other or(aniBations= (e'ine Inventory OrganiCation* Answer: 6t is a facility which will enable you to store and transact the ite.s= 6t can be a .anufacturin( unit7 ware house7 distribution center etc= !hat is a su$inventory* Answer: Subinventiries are uni'ue physical or lo(ical separations of .aterial inventory= 5hese can be raw .aterial7 finished (oods or defective .aterial subinventory= Nou .ust define at least one subinventory= Subinventories are of two types: Stora(e and 3eceivin(= %torage su$inventories are inter.ediate or final put away locations for .aterial= Material that resides in a stora(e subinventory appears in on hand 'uantity7 and is trac&ed by the syste.= 5he syste. can boo& orders a(ainst7 and use .anufacturin( processes on .aterial that resides in a stora(e subinventory= Nou .ust define at least one stora(e subinventory for your i.ple.entation= 8e#eiving ty"e su$inventory is only used for receivin( ite.s= 6te.s in this subinventories cannot be on hand or reserved In whi#h ta$le does the su$inventory related in'ormation 'or an item is stored* Answer: M5J>5O36S !hat is a sto#7 lo#ator* Answer:
Create an ite. in the ite. .aster for.=
•
Copy the te.plate fro. the tools .enu to assi(n specific attributes to the ite. and save it=
•
•
Assi(n the ite. to a cate(ory fro. tools .enu and save your wor& Select or(aniBation assi(n.ent fro. tools .enu and assi(n the ite. to different inventory or(aniBations by tic&in( the chec&bo@ ne@t to the inventory or(aniBations=
!hat are item attri$utes* Answer: 6te. attributes are the collection of infor.ation about an ite.= 5hese are used to store specific characteristics of an ite.7 such as ite. status7 unit of .easure7 revision control7 etc= these can be controlled at either the .aster or the or(aniBation level= 5hese attributes are stored in a table na.ed M5
!hat is the use o' item tem"late* Answer: An 6te. te.plate is a set of attributes that enable the user to 'uic&ly create an 6te.= Nou can use the e@istin( te.plates are you can create your custo. te.plate= !hat is an item #ategory and #ategory set* Answer: A cate(ory is a lo(ical classification of ite.s that have si.ilar characteristics= A cate(ory set is a distinct (roupin( sche.e and consists of .ultiple cate(ories= An ite. can belon( to any nu.ber of cate(ory sets= "e can assi(n ite. to one cate(ory within each cate(ory set= 5he cate(ories can be retrieved fro. the table GM5AOM? and AOM #lass* Answer: 5he unit of .easure OM) helps us count the nu.ber of ite.s involved in a transaction or the nu.ber of ite.s that are stored in a subinventory or a locator= OM classes let you (roup different MO#s into one cate(ory= (7 'uantitycould be a OM class under which each7 doBen7 lot etc are separate OM#s= 59"lain shi""ing method* Answer: Shippin( .ethods are the way you ship .aterial= "hen you create a shippin( .ethod7 you .ust enable it before you can use it in a shippin( networ&= 6f you disable a shippin( .ethod7 it cannot be used in a shippin( networ&= (es#ri$e InterorganiCation %hi""ing SAC56O>S M5SAC56O>SK6>53FAC M5SAC56O>SK5M+ M5SAC56O>KACCO>5S !hat is revision #ontrol in Ora#le Inventory* Answer: A revision is a particular version of an ite.7 bill of .aterial7 or routin(= 3evision control is nor.ally enabled for identifyin( a .odified ite.= 6te. can be placed under revision control by chec&in( the bo@ 3evision control in 6nventory tab while definin( new ite. or for e@istin( ite.= ,ase table for 6te. 3evision is M5S= !hat is Pi#7ing Order o' %u$inventory or ;o#ator* !here will you de'ine the order* Answer: 5he value indicates the priority with which we pic& ite.s fro. subinventory or
so on)= 5he subinventory order is d efined in the subinventory definition and the locator order is defined in the locator definition= 5he default order for both the subinventory and the locator are defined in the or(aniBation= !hat are the di''erent inventory transa#tions* Answer: A transaction is an ite. .ove.ent within7 into or out of inventory= A transaction chan(es the 'uantity and location of an ite. 5he followin( are the different inventory transactions: •
3eceive an ite. into an or(aniBation fro. /< account nu.ber
•
6ssue an ite. fro. an or(aniBation into a /< account nu.ber
•
5ransfer ite.s fro. one subinventory to other in the sa.e or(aniBation=
•
5ransfer of ite.s between various inventory or(aniBations
•
3eservation of ite.s
(es#ri$e various inventory transa#tions* Answer: Mis#ellaneous transa#tion: 5his transaction is used to do ad8ust.ents in stoc& due to da.a(e7 obsolescence7 issuin( ite.s for 3 T D or issuin( trac& able e@pense ite.s= %u$inventory trans'er : 5his transaction is used to transfer (oods fro. one subinventory to another within the sa.e inventory or(aniBation= InterO8B trans'er : 5his transaction is used to transfer (oods fro. one inventory or(aniBation to another= 8e#eiving transa#tion) 5his transaction is used to .ove (oods fro. receivin( doc& to specified subinventory and locator= %ales issue) 5his transaction is used to .ove (oods fro. pic& subinventory to sta(ed subinventory= !IP issue) 5his transaction is used to issue .aterials a(ainst production orders !hat is the di''eren#e $etween a su$inventory trans'er and a move order* Answer: ,oth these transactions are used for the .ove.ent of ite.s fro. one subinventory to the other= 5he difference is that .ove order (enerates a pic& slip and a subinventory transfer doesn#t= Move order re'uires Gapproval#= Also7 .ove orders create allocations= So you can place hold on the .aterial with the intention of pic&in( it up a little later= 6n subinventory transfer7 there is no reservation 9 allocation= !hat are the &om"onents used in &ustomiCing a Transa#tion* Answer: 5he followin( are the three co.ponents used in a transaction 5ransaction Source 5ype 5ransaction Action 5ransaction 5ype A 5ransaction Source 5ype and a 5ransaction Action co.e to(ether to for. a 5ransaction 5ype= !hat is a Transa#tion sour#e ty"e* Answer: A 5ransaction Source 5ype is defined as an entity a(ainst which Oracle 6nventory char(es a transaction= 5he followin( transaction source types co.e seeded with Oracle 6nventory: +urchase Order Account Alias Move Order 6nternal Order
Standard Cost pdate 6nternal 3e'uisition Sales Order Cycle Count +eriodic Cost pdate +hysical 6nventory Account 3MA 3eturn Material AuthoriBation) 6nventory Rob or Schedule !hat is a transa#tion ty"e* Answer: A transaction type is a co.bination of a transaction source type and a transaction action= 6t is used to classify a particular transaction for reportin( and 'ueryin( purposes= @: Sales order issue t@n type) issue fro. stores t@n action) E sales order t@n source type) Move order transfer t@n type) subinventory transfer t@n action) E .ove order t@n source type)
inventory carryin( costs for the custo.erU he does still incur costs related to storin( and .ana(in( the inventory !hat are the di''erent "lanning methods availa$le in Ora#le* Answer: 3eorder point plannin( MinMa@ plannin( Panban cards Subinventory replenish.ent plannin( !hen should the material $e ordered* Answer: "hen onhand 'uantity supply H de.and is less than safety stoc& safety stoc& is nothin( but .ini.u. inventory level) VOnhand 'uantityW VsupplyW H Vde.andW X V.in inventory levelW 59"lain reorder "oint "lanning* Answer: 3eorder point plannin( uses de.and forecasts to decide when to order a new 'uantity to replenish inventory= 3eorder point plannin( su((ests a ne w order for an ite. when the available 'uantity onhand 'uantity plus planned receipts) drops below the ite.#s safety stoc& level plus forecast de.and for the ite. durin( its replenish.ent leadti.e= 5he su((ested order 'uantity is an econo.ic order 'uantity that .ini.iBes the total cost of orderin( a nd carryin( inventory= Oracle 6nventory can auto.atically (enerate re'uisitions to infor. your purchasin( depart.ent that a replenish.ent order is re'uired to supply your or(aniBation= 6f the forecast is correct and the order arrives on ti.e7 the inventory level should be ri(ht at the safety stoc& level at the ti.e of receipt= 6n cases where the desired safety stoc& level chan(es durin( the order lead ti.e7 Oracle 6nventory uses the lar(est safety stoc& 'uantity durin( the leadti.e= "hen an order is tri((ered7 the OQ is the siBe of the tri((ered order= OQ E s'uare root of: V! ; annual de.and ; order cost) 9 carryin( cost percent ; nit cost)W Oracle 6nventory calculates annual de.and as the current de.and rate annualiBed by .ultiplyin( the current period de.and forecast by the nu.ber of periods per year ! or $)= 3eorder point plannin( can be perfor.ed at the or(aniBation level only= 59"lain minma9 "lanning te#hniue* Answer: MinMa@ plannin( is a tool for plannin( inventory that loo&s at userdefined .ini.u. and [email protected]. inventory levels= 6t does not consider lead ti.es= "e can perfor. this techni'ue at or( level or subinventory level= Clic& here for co.plete cycle (e'ine #y#le #ounting and e9"lain its use in ora#le inventory* Answer: Cycle Countin( is a process of periodic countin( of individual ite. 9 all the ite.s throu(hout the course of the year to ensure the accuracy of inventory 'uantities and values= "e can do the cycle countin( at Or(aniBation 9 Sub 6nventory
+ur(e physical inventory infor.ation
nventory 1
!hat are di''erent "lanning methods in Inventory
5here are * different plannin( .ethods in oracle 6nventory •
Subinv 3eplenish.ent +lannin(
•
Min Ma@ +lannin(
•
3eorder point plannin(
•
Panban +lannin(
•
+eriodic Auto.atic 3eplenish.ent
2
!hat are the setu"s 'or di''erent "lanning method >MinMa9?
•
Setup the ite. in .aster or( and assi(n the ite. to the or( for which MinMa@ plannin( is used
•
Attributes7 6nv +lannin( .ethod: MinMa@
•
MinMa@ Qty should have been defined
•
Safety Stoc& .ethod should be non M3+ +lanned
•
Deter.ine what should be the status of the 3e'uisitions created for the plannin(
Do this with profile option I
Sourcin( rules can be defined for this 5hen need to assi(n sourcin( rule to the ite. 6n 6nventory responsibility7 under +lannin( run the Min Ma@ plannin( report with re'uired para.eter •
3
!hat is the #on#urrent "rogram 'or the "lanning
•
Min Ma@ plannin( report under plannin( .enu in 6nventory responsibility
4
!hat are the setu"s 'or e9"ense item*
•
Should not be 6nventory 6te.
•
>o Stoc&able
•
>o 5ransactable
•
>o Costin(7 6nv Asset
+
/ow many 7ey 'le9'ields are there in Inventory*
Seven PFF are there in 6nventory •
Account Alias
•
6te.
•
6te. Cate(ory
•
6te. Catalo(ues
•
Stoc&
•
Sales Order
•
Service 6te.s
.
!hat is the use o' sales order D==*
•
5his is used durin( .aterial transaction when source is Sales Order
•
Se(.ents are Sales order >u.ber=Sales Order 5ype=Sales Order Source
/ow we #an have the item 7ey 'le9'ield with 2 segments, is it "ossi$le, i' yes then how, i' no then why* •
5his can be .odified usin( Fle@fieldIPeyI Se(.ents
•
Query the Syste. 6te.s7 then you can .odify the e@istin( structure7 or you can add a new one=
/ow will you ina#tivate the Inventory lo#ations
•
,y (ivin( 6nactive date in the
!hat all setu"s you have done in inventory organiCation im"lementation
•
•
Calendar
•
Or(aniBation
•
+ara.eter
•
Cost /roup
•
Subinventory
•
Stoc&
•
3eceivin( Options
•
Shippin( >etwor&s
•
6nterco.pany 5ransaction flows
•
Cost Subele.ents
1. •
Wha ta r et hev al ua t i onac c ount sus edi nI n ve nt or y Ma t e r i a l
Anas se tac countt hatt r ac k smat er i al c os t .Fora ver agec os t i ng,t hi sac c ount
hol d sy o uri n v ent or yandi nt r a ns i tv a l u es .Onc ey o uper f or mt r a ns ac t i on s,y o uc an no tc han ge t hi sac count . •
Ma t e r i a lOv e r he a d Anas s etac c ountt hatt r ac k smat e r i al o v er headc os t .
•
Resour ce Ana s se ta cc oun tt hatt r ac k sr es our c ec o st .
•
Over head Anas s eta cc ou ntt h att r a ck sr e sou r c ean do ut s i d ep r o c es s i ngo v er h ead s .
•
Out si depr ocessi ng Ana ss etac c ountt hatt r ac k sou t s i d epr o ces s i ngc os t .
•
Expense
Th ee x p e ns ea c c ou ntu s edwh ent r a c k i n gan on a s s eti t e m
Ot herAccount s •
Sa l e s
Thepr ofi tandl os s( i nc omes t at ement )ac countt hatt r ac kst hedef aul t
r e v e nu ea c c ou nt . •
CostofGoodsSol d Thepr ofi tandl o ss( i nc omes t at ement )ac c ountt h att r ac k st he def aul tc os to fgo od ss ol dac c ou nt .
•
Pur chasePr i ceVar i ance
Th ev a r i a nc ea c c ou ntu s edt or e c or dd i ff er e nc e sb et we en
pur c ha seor derpr i c eandst a ndar dco st .Thi sac c oun ti sno tus edwi t ht heav er ageco stme t hod. •
I nvent or yA/ PAccr ual
Thel i abi l i t yac countt hatr epr es ent sal l i nv ent or ypur c has e
o r d err ec ei pt sno tmat c he di nAc c ount sPa y abl e,s uc hast heun i n v oi c edr ec ei pt sac c ou nt . •
I nv oi c ePr i c eVa r i a nc e
Th ev a r i an cea c co un tu se dt or e co r dd i ff er e nc esbe t we en
pur c ha seor derpr i c eandi n v oi c ep r i c e.Th i sac c oun ti sus edb yAc c ount sPa y abl et or e cor d i nv oi c epr i c ev ar i anc e.
•
Encumbr anc e
Ane x pe ns ea cc ou ntu se dt or e co gni z et h er e se r v a t i ono ff un ds
wh enapu r c h as eor d eri sa pp r o v e d. •
Aver ageCostVar i ance
Un dera v er ag ec os t i ngwi t hne gat i v equant i t ybal anc es ,
t hi sac countr epr es ent st hei n vent or yv al uat i oner r orc aus edbyi s sui ngy ouri nv ent or ybef or e y ourr ec ei pt s .
2. •
Whati sABCAnal ysi sandwhyi ti sbei ngused ABCAnal y s i si sanI n vent or yc at egor i z at i onme t hodt oc at egor i z ei t emsi nt o3di ffer ent c l a s se sAb ei n gt h emo s tv a l u ab l ea ndCb ei n gt h el e as tv a l u abl eo ne s .
•
Us i ngt hi sAnal y si s ,i twi l l beeas yt omoni t orandk eepont r ac koft hev al uabl ei t emsl i k e f r equent l ydoi ngc y cl ec ount sonAc l as si t ems ,e t c .
3.
Whatar et hepr ocessofcycl ecount
•
Cr eat eac y c l ec oun theaderwi t hr equi r edda t a
•
As s i g nt h ei t e mst ob ec o un t ed
•
Thenr unt h er equi r edc y c l ec ou ntr e po r t
•
Us i ngt h er epor tdot hec y c l ec ount s
•
Th engoa ndAp pr o v et h ec y c l ec o un t
4.
Whati st hedi ffer enti nMO I ssueandMO Tr ansf er
•
MO I s s uewi l l mo v eo utt h es t o c kf r om i n v ent o r yag ai n sta na cc ou nt
•
MO t r a ns f e rwi l l mo v et hest oc kf r om on es ubi n v en t or yt oot he r
5. •
Wha ti st hePi c ki ngr ul ei nI nv ent or y Pi c ki ngRul ei sus edt odet er mi net hel i s tofi t emsf ors al esor der /s hi ppi ngbas edont he r e vi s i on,Lo t ,Subi nv ent or yandLoc at or .
•
6.
As s i g nt h er eq ui r e dPi c k i n gRul et ot h ei t e mi nOr d erMan age me ntt a b. Wha ta r et hecr i t e r i ai nCy cl ecount De pe nd i n go nt h er e qu i r e me nt ,wec ant r i g ge rc y c l ec ou nt . Wec ande fi ner e gul a rc y c l ec ou nto fh i g hv a l u esi t e ms . I fbac kor der edorpi c kdeni ed,wec ant r i ggerc y cl ec ountf ort hos ei t ems .
6.
Whatar et hedi ffi nLotandSer i al Lotc ont r ol i st oc ont r ol awhol eb at c hofi t ems .f ore xampl ei nd r ugi ndus t r yweh av eb at c h
n umb erwh i c h
c anb ec o n t r o l l e du si n gl o twh er ewec a nt r a c kt hec ompl e t eb at c hu s i n g
s pe ci fi cdat a. Ser i al c ont r ol i st omoni t orandt r ac ke v er ys i ngl eq t yofani t em l i k eel ec t r oni cdev i c eswher e wet r a ckb y
s e r i a ln umbe r .
6.
Wha ta r et hema t e r i a ls t a t usi nasubi nv ent or y
7.
Wha ti sPhy si c alI nv ent or y
1.Whati smoveor deri nOM Mo v eor d er sg en er a t e da spa r to fPi c kWa v ear et h eo ne sf r o m Sa l e sor d er 2.How aMO i sdi fff r om Subi nvt r ansf er An s:MO g en er a l l yar et h er eq ue s to fmo v emen to fi t e msi no neor g ani z a t i o n.I tma ybeo ff r o m3 s o ur c e s ,MO r e qu i s i t i o n,Re pl e ni s hMO,Pi c kWa v eMO.MO c a nb eMO I s s u ewh i c hwi l l i s s u et h e i t em f r om t hel oc at i onandMO t r ans f erwhi c hl l t r ans f ert hei t em t oano t herl oc at i on. 3.Wha ti sne t t a bl ei nSubi nv e nt or ys e t up Thi swi l l de t r r mi newhet hert oc ons i dert heonhandsoft hes ubi nv ent or yasav ai l abl ef orpl anni ng t a s k s . 4 .Wha ta r et hest a t usa t t r i but e si nI t e ma ndhow ma nyoft he m Wecande finedi ff er en ts t at usf orani t em c ombi nat i ont hes eat t r i bu t esaspe rt hebus i nes sne ed Fol l owi ngar et heat t r i but es B OM En a b l e d Bu i l di nWI P Cu s t o me ro r d e r e n a b l e d I n t e r n a l Or d e re n a b l e d I n v o i c a b l e Pu r c h a s a b l e St o c k a b l e T r a n s a c t a b l e
5 .Wha ti st heus eofs t a t usa t t r i but e Wecande finedi ff er en ts t at usf orani t em c ombi nat i ont hes eat t r i bu t esaspe rt hebus i nes sne ed 6.Whymast eror gi sr equi r ed
Sot h atwec a nh av eani t e m ma i n t a i n eda tma s t e rl e v e lwi t hc o mmo na t t r i b ut e sa ndt h enwec a nu s e t hes amei t em ac r os smul t i pl eor gani z at i oni ns t eadofdefi ni ngi tagai nandagai n. 7 .I n ve nt or yMa st e ror gi sma nda t or y ? Yes .I fy ouwi l l no tc r eat ean ys pec i fi cmas t eror g,t hens y st em wi l l c ons i dert hes amei n vor gasi t s ma s t e ror g . 8 .Wha ta r et heLotc ont r ols et ups Lotc ont r ol c anbes et upati t em at t r i but esator gani z at i onl ev el . Ei t herNoCont r ol orFul l Cont r ol 9.How l otnumbergener at es Yo uc a ng en er a t en ewL otn umb er sdu r i n gt r a ns a c t i o ns 1 0.Wha ti sse r i a lc ont r ol l e da ndwha ta r et hese t ups Ser i al c ont r ol c anbes et upati t em at t r i but esator gani z at i onl ev el . 11.How ser i alnumber sar egener at ed Ser i al c ont r ol c anbes et upati t em at t r i but esator gani z at i onl ev el . NoCont r ol ,AtRe cei p t ,AtSa l esOr deri s s ue,Pr edefi ne d 12.Whati st hepr edefinedl ocat ori nSubi nvent or yandhow i twor ksi nbusi ness Wec ans et upl o cat o rc o nt r ol i n4di ffwa y sf o re ac hs ubi n v ent or y None:Ther ewi l l notbeanyl oc at ori nf or mat i onr equi r eddur i ngan yt r ans ac t i on Pr especi fied:Sy s t em wi l l a sky out os el ec tl oc at orc ombi na t i onswhi c hal r eadybee nde finedi nt he s ubi nv ent or ydur i ngt het r ans ac t i on Dynami cEnt r y:Ei t hery ouc ansel ec tan yl oc at ordur i ngt r ans ac t i onory ouc anc r eat eanew c ombi nat i on I t em Level :Thi swi l l t ak et hel oc at orwhi c hhasbeendefi nedati t em at t r i but el ev el 13.Whatar et het r ansact i onmanager s T r ans ac t i o nman ag eri st hei ne t r f ac eman ag er swhi c hc ar r youtal l t r an sac t i ononc es ub mi t t edb yt h e u s e r s
14.Canwechanget hei t em nameaf t eri tcr eat ed? An s :Y eswec anc ha ng et h en amei nma s t e rl e v e l .
1 /ow !M% is hel"'ul #om"ared to Inventory 6ns) "arehouse Mana(e.ent "MS) enables co.panies to [email protected] their utiliBation of labor7 space and e'uip.ent invest.ents by coordinatin( and opti.iBin( resource usa(e and .aterial flows= Specifically desi(ned to support the needs of distribution7 .anufacturin(7 assetintensive7 and service businesses7 Oracle "MS provides a sin(leplatfor. across your entire (lobal supply chain= 2 !hat 'un#tionality in inventory uses the #alendar 3 !hat is the di'' in inv and wms 'rom a##ounting "ers"e#tive 4 !hat is the use o' !M% 8ules !or7$en#h 6ns) 5he 3ules wor&bench enables you to assi(n strate(ies7 rules and cost (roup values directly to any nu.ber of ob8ects in an assi(n.ent .atri@ + !hy strategy used 6ns) After you define your rules7 you .ust set up a strate(y and then associate the applicable rules= After you assi(n rules to a strate(y7 the rules en(ine can e@ecute the strate(ies on any ob8ects to which the strate(y applies= 5he rules en(ine e@ecutes each subse'uent rule in your strate(y until an allocation is co.pletely filled= . /ow many ty"es o' $ar #odes are there 6ns) Mainly ! types
Read more: http://www.learnoracle.in/2014/05/oracle-scm-functionalinterview_18.htmli!""#$0%&'(h)
1.
What is an item?
2.
Explain Item Master Organization?
#.
Defne Inventory Organization?
4.
What is a subinventory?
5.
In which table does the subinventory related inormation or an item is stored?
*.
What is a stoc! locator?
+.
What are the "ey #ex felds in oracle Inventory?
8.
What are the basic steps involved in defning an item?
,.
What are item attributes?
10.
What is the use o item template?
11.
What is an item category and category set?
12.
Explain unit o measure $%OM& and %OM class?
1#.
Explain shipping method?
14.
Describe Interorganization 'hipping (etwor!s
15.
In which tables are the transactional details are stored?
1*.
What is revision control in Oracle Inventory?
1+.
What is )ic!ing Order o 'ubinventory or *ocator? Where will you defne the order?
18.
What are the di+erent inventory transactions?
1,.
Describe various inventory transactions?
20.
What is the di+erence between a subinventory transer and a move order?
21.
What are the ,omponents used in ,ustomizing a -ransaction?
22.
What is a -ransaction source type?
2#.
What is a transaction type?
24.
(ame any our purposes where miscellaneous transaction can be used?
25.
Explain inventory control?
2*.
What are the ob.ectives o inventory control?
2+.
What are the actors that a+ect inventory control?
28.
Defne /0, analysis?
2,.
What is consignment inventory?
#0.
What are the di+erent planning methods available in Oracle?
#1.
When should the material be ordered?
#2.
Explain re1order point planning?
##.
Explain min1max planning techni2ue?
#4.
Defne cycle counting and explain its use in oracle inventory?
#5.
When do you perorm physical inventory and explain the steps involved in it? #$ What is an item?
An item is a part or services !here you can Purchase Sell Plan )anufacture Stock Distribute and Prototype. (tems can also be containers for items as !ell as co mponents you build into other items. %$ &'plain (tem Master Orani)ation?
An item master organi*ation is a logical entity !here you d efine the item. After you define an item in the item master you can assign it to any number of other organi*ations. *$ Define (nventory Orani)ation?
(t is a facility !hich !ill enable you to store and transact the items. (t can be a manufacturing unit !are house distribution center etc. +. What is a subinventory?
Subinventiries are uni&ue physical or logical separations of material inventory. #hese can be ra! material finished goods or defective material subinventory. You must define at least one subinventory. Subinventories are of t!o types" storae and receivin Storae subinventories are intermediate or final put a!ay locations for material. )aterial that
resides in a storage subinventory appears in on hand &uantity and is tracked by the system. #he system can book orders against and use manufacturing processes on material that resides in a storage subinventory. You must define at least one storage subinventory for your implementation. Receivin type subinventory is only used for receiving items. (tems in this subinventories cannot
be on+hand or reserved ,. (n "hich table does the subinventory related information for an item is stored? M!-.(!&M.S/0.(12&1!OR(&S 3$ What is a stock locator?
%ocators are structures !ithin subinventories. %ocators are the third level in the enterprise structuring scheme of 'racle (nventory. %ocators may represent ro!s racks or bins in !arehouses. You can transact items into and out of locators. You can restrict the life of locators
establish capacity of a specific locator in !eight or units as !ell as specify dimensions !hich define a locator,s capacity by volume. 4. What are the 5ey fle' fields in oracle (nventory?
'racle (nventory provides the follo!ing fle-fields" System (tems (tem atalogs (tem ategories Stock %ocators Account Alias and Sales 'rder 6. What are the basic steps involved in definin an item?
reate an item in the item master form opy the template from the tools menu to assign specific attributes to the item and save it. Assign the item to a category from tools menu a nd save your !ork Select organi*ation assignment from tools menu and assign the item to different inventory organi*ations by ticking the checkbo- ne-t to the inventory organi*ations. 7$ What are item attributes?
(tem attributes are the collection of information about an item. #hese are u sed to store specific characteristics of an item such as item status unit of measure revision control etc. these can be controlled at either the master or the organi*ation level. #hese attributes are stored in a table namedM!-.(!&M.8!!R(0/!&S #9. What is the use of item template?
An (tem template is a set of attributes that enable the user to &uickly create an (tem. You can use the e-isting templates are you can create your custom template. ##. What is an item cateory and cateory set?
A category is a logical classification of items that have similar characteristics. A category set is a distinct grouping scheme and consists of multiple categories. An item can belong to any number of category sets. We can assign item to one category !ithin each category
set. #he categories can be retrieved from the table /M!-.C8!&OR(&S.0/ and item category set from;M!-.C8!&OR<.S&!S.0,. #%. &'plain unit of measure =/OM> and /OM class?
#he unit of measure 01')2 helps us count the number of items involved in a transaction or the number of items that are stored in a subinventor y or a locator. 1') classes let you group different 1)',s into one category. 3g uantity could be a 1') class under !hich each@ do)en@ lot etc are separate 1'),s. #*. &'plain shippin method?
Shipping methods are the !ay you ship material. When you create a shipping method you must enable it before you can use it in a shipping net!ork. (f you disable a shipping method it cannot be used in a shipping net!ork. #+$ Describe (nterorani)ation Shippin 1et"orks
An inter+organi*ation shipping net!ork describes the relationships and accounting information bet!een a shipping organi*ation and a destination organi*ation. You must define a shipping net!ork bet!een t!o organi*ations before you can transfer material bet!een organi*ations. When you set up a shipping net!ork you must select a transfer type"(ntransit or Direct . (ntransit " 'racle (nventory moves material to an intermediary state before it reaches the
destination organi*ation. After the material arrives at the destination organi*ation you !ill need a receipt transaction to retrieve it. (f intransit is selected you can define" Shipping )ethods G% Accounts to use in transit )aterial o!nership during transfer Planning lead times and #ransfer harges Direct" 'racle (nventory moves the material directly to the destination organi*ation. 4o!ever
for both
transfer types you can determine default receipt routing and !hether internal orders
are re&uired to transfer material #,. (n "hich tables are the transactional details are stored?
)#%5)A#3R(A%5#RA6SA#('6S )#%5#RA6SA#('6S5(6#3R7A3 )#%5)A#3R(A%5#RA6SA#('6S5#3)P )#%5#RA6SA#('65A'16#S #3$ What is revision control in Oracle (nventory?
A revision is a particular version of an item bill of material or routing. Revision control is normally enabled for identifying a modified item. (tem can be placed under revision control by checking the bo- 8Revision control8 in (nventory tab !hile defining ne! item or for e -isting item. 9ase table for (tem Revision is M!-.(!&M.R&2(S(O1S . #4$ What is Pickin Order of Subinventory or -ocator? Where "ill you define the order?
#he value indicates the priority !ith !hich !e pick items from subinventory or %ocator relative to another subinventory or locator !here a given item resides. A picking order of : means that order entry functions pick items from the subinventory or locator before others !ith a higher number 0such as ;< and so on2. #he subinventory order is defined in the subinventory definition and the locator order is defined in the locator definition. #he default order for both the subinventory and the locator are defined in the organi*ation. #6$ What are the different inventory transactions?
A transaction is an item movement !ithin into or out of inventory. A transaction changes the &uantity and location of an item #he follo!ing are the different inventory transactions" Receive an item into an organi*ation from G% account number (ssue an item from an organi*ation into a G% account number #ransfer items from one subinventory to other in the same organi*ation. #ransfer of items bet!een various inventory o rgani*ations
Reservation of items #7$ Describe various inventory transaction types? Miscellaneous transaction: #his transaction is used to do ad=ustments in stock due to damage
obsolescence issuing items for R > D or issuing track able e-pense items. Subinventory transfer: #his transaction is used to transfer goods from one subinventory to
another !ithin the same inventory organi*ation. (nterOR transfer: #his transaction is used to transfer goods from one inventory organi*ation
to another. Receivin transaction: #his transaction is used to move goods from receiving dock to specified
subinventory and locator. Sales issue: #his transaction is used to move goods from pick subinventory to staged
subinventory. W(P issue: #his transaction is used to issue materials against production orders %9$ What is the difference bet"een a subinventory transfer and a move order?
9oth these transactions are used for the movement of items from one subinventory to the other. #he difference is that move order generates a pick slip and a subinventory transfer doesn,t. )ove order re&uires /approval,. Also move orders create allocations. So you can place hold on the material !ith the intention of picking it up a little later. (n subinventory transfer there is no reservation $ allocation.
21. hat are the omponents used in ustomi"in a ransaction #he follo!ing are the three components used in a transaction •
ransaction ource %pe
•
ransaction 3ction
•
ransaction %pe
A !ransaction Source !ype and a !ransaction 8ction come together to form a !ransaction !ype.
22. hat is a ransaction source t%pe A !ransaction Source !ype is defined as an entity against !hich 'racle (nventory charges a transaction. #he follo!ing transaction source types come seeded !ith 'racle (nventory" •
urchase (rder
•
3ccount 3lias
•
ove (rder
•
'nternal (rder
•
tandard ost 6pdate
•
'nternal Re7uisition
•
ales (rder
•
%cle ount
•
eriodic ost 6pdate
•
h%sical 'nventor%
•
3ccount
•
R3 Return aterial 3uthori"ation9
•
'nventor% o; or chedule
•
%*$ What is a transaction type?
A transaction type is a combination of a transaction source type and a transaction action. (t is used to classify a particular transaction for reporting and &uerying purposes. 3-" Sales order issue 0t-n type2 ? issue from stores 0t-n action2 @ sales order 0t-n source type2 )ove order transfer 0t-n type2 ? subinventory transfer 0t-n action2 @ move order 0t-n source type2 %+$ 1ame any four purposes "here miscellaneous transaction can be used?
ycle count ad=ustment Physical inventory ad=ustment ad=usting inventory &uantity !ithin an inventory organi*ation and decrementing on+hand balances from a subinvemtory %,. &'plain inventory control?
(nventory ontrol is the process by !hich inventory is measured and regulated according to predetermined norms such as economic lot si*e for order or production safety stock minimum level ma-imum level order level etc. %3$ What are the obAectives of inventory control? •
o meet unforeseen future demand due to variation in forecast <ures and actual <ures.
•
o averae out demand =uctuations due to seasonal or c%clic variations.
•
o meet the customer re7uirement timel%> e?ectivel%> e@cientl%> smoothl% and satisfactoril%.
•
o smoothen the production process.
•
o facilitate intermittent production of several products on the same facilit%.
•
o ain econom% of production or purchase in lots.
•
o reduce loss due to chanes in prices of inventor% items.
•
o meet the time la for transportation of oods.
•
o meet the technoloical constraints of production/process. %4$ What are the factors that affect inventory control?
•
%pe of product
•
%pe of manufacture
•
)olume of production %6$ Define 80C analysis?
A9 analysis determines the relative value of a group of inventory items based on a user specified valuation criterion. #his techni&ue divides inventory into three categories A 9 > based on their annual consumption value.
(t is also kno!n as Selective (nventory ontrol )ethod 0S()2 %7$ What is consinment inventory?
onsignment (nventory is inventory that is in the possession of the customer but is still o!ned by the supplier. (n other !ords the supplier places some of his inventory in his customer,s possession 0in their store or !arehouse2 and allo!s them to sell or consume directly from his stock. #he customer purchases the inventory only after he has resold or consumed it. #he key benefit to the customer should be obvious he does not have to tie up his capital in inventory. #his does not mean that there are no inventory carrying costs for the customer he does still incur costs related to storing and managing the inventory *9$ What are the different plannin methods available in Oracle? •
Re-order point plannin
•
in-a! plannin
•
Aan;an cards
•
u;inventor% replenishment plannin *#$ When should the material be ordered?
When on+hand &uantity ? supply B demand is less than safety stock 0safety stock is nothing but minimum inventory level2 C'n+hand &uantity ? Csupply B Cdemand E Cmin inventory level *%$ &'plain reBorder point plannin?
Reorder point planning uses demand forecasts to decide !hen to order a ne! &uantity to replenish inventory. Reorder point planning suggests a ne! order for an item !hen the available &uantity 0on+hand &uantity plus planned receipts2 drops b elo! the item,s safety stock level plus forecast demand for the item during its replenishment lead+time. #he suggested order &uantity is an economic order &uantity that minimi*es the total cost of ordering and carrying inventory. 'racle (nventory can automatically generate re&uisitions to inform your purchasing department that a replenishment order is re&uired to supply your organi*ation.
(f the forecast is correct and the order arrives on time the inventory level should be right at the safety stock level at the time of receipt. (n cases !here the desired safety stock level chang es during the order lead time 'racle (nventory uses the largest safety stock &uantity during the lead+time. When an order is triggered the 3'F is the si*e of the triggered order. 3'F @ s&uare root of" C0; annual demand order cost2 $ 0carrying cost percent 1nit cost2 'racle (nventory calculates annual demand as the current demand rate annuali*ed by multiplying the current period demand forecast by the number of periods per year 0:; or :<2. Reorder point planning can be performed at the organi*ation level only. **$ &'plain minBma' plannin techniue?
)in+)a- planning is a tool for planning inventor y that looks at user+defined minimum and ma-imum inventory levels. (t does not consider lead times. We can perform this techni&ue at org level or subinventory leve l *+$ Define cycle countin and e'plain its use in oracle inventory?
ycle ounting is a process of periodic counting of individual item $ all the items throughout the course of the year to ensure the accuracy of inventory &uantities and values. We can do the cycle counting at 'rgani*ation $ Sub (nventory %evel. ycle count is used to" #o reconcile system on+hand balances !ith actual counts in inventory )aintain control over the items that have higher value *,$ When do you perform physical inventory and e'plain the steps involved in it?
Physical inventory can be performed !henever there is a need to verify the accuracy of system on+hand &uantities. #his can be done for entire organi*ation or can be confined to a specific subinventory.
Steps to perform physical inventory" Be
•
aCe a snapshot of s%stem on-hand 7uantities
•
•
Denerate ph%sical inventor% tas
•
Enter counts
•
Bo ph%sical inventor% adFustments ;% approvin or reFectin
•
ost adFustments
•
ure ph%sical inventor% information
H omments 3non%mous eptem;er 21> 2014
1. Super 3+
)ali haiC Govem;er 21> 2014 2. 1. 2. 3. #. %. ). . -. . 1. 11. 12. 13. 1#. 1%. 1). 1. 1-. 1.
How can we create a normal order line and a return line in a single order How to change price in sales order line after booking without using any modifier. Is it
possible, if Yes how? d!anced "ricing $onfigurator &hat is Item !alidation org and how it is different from Item 'aster (rg Is it possible to do any transaction *recei!ing+ transaction in Item master org? &hat steps you will do to check if picking did not happen for an order after pick release? &hat is system parameter and what is its significance? &hat all setups re/uired for an 0( order? &hat all setups re/uired for ack to ack order? In an I, the price of the item, from where it populates? How can you change the price of the item in an I? How in!oice get generated for I? &hat is the accounting entry happens for an I in!oice? &hat is allocation means in sales order and in which step it happens? &hat is the difference between allocation and reser!ation? If an item is not allowed to enter in any sales order form, what is the setup behind this? &hat is the difference between customer ordered and customer order enabled flag? &hat are the drop shipment setups and e4plain the flow?