ORDER MANAGEMENT:
1) What are the Base Tables and Interface
Tables for Order Management?
Interface Tables :
OE_HEADERS_IFACE_ALL,
OE_LINES_IFACE_ALL
OE_PRICE_ADJS_IFACE_ALL, OE_ACTIONS_IFACE_ALL
OE_CREDITS_IFACE_ALL (Order holds like credit
check holds etc)
Base Tables : OE_ORDER_HEADERS_ALL:
Order Header Information
OE_ORDER_LINES_ALL: Items Information
OE_PRICE_ADJUSTMENTS: Discounts Information
OE_SALES_CREDITS: Sales Representative
Credits.
Shipping Tables :WSH_NEW_DELIVERIES,
WSH_DELIVERY_DETAILS,
WSH_DELIVERY_ASSIGNMENTS, WSH_DELIVERIES.
2) What is Order Import and What are the
Setup's involved in Order Import?
A)
Order Import is an open interface that consists
of open interface tables and a set of API’s. It imports New, updated, or
changed sales orders from other applications such as Legacy systems. Order
Import features include validations, Defaulting, Processing Constraints checks,
Applying and releasing of order holds, scheduling of shipments, then ultimately
inserting, updating or deleting orders from the OM
base tables. Order management checks all the data during the import process to
ensure its validity with OM. Valid
Transactions are then converted into orders with lines, reservations ,price
adjustments, and sales credits in the OM base tables.
B)
Setups:
·
Setup every aspect of order management that we
want to use with imported orders, including customers, pricing, items, and
bills.
·
Define and enable the order import sources
using the order import source window.
3)
Explain
the Order Cycle?
i)
Enter the Sales Order
ii)
Book the Sales Order(SO will not be processed
until booked(Inventory confirmation))
iii)
Release sales order(Pickslip Report is
generated and Deliveries are created)
(Deliveries – details about the delivery.
Belongs to shipping module (wsh_deliveries, wsh_new_deliveries,
wsh_delivery_assignments etc) they
explain how many items are being shipped and such details.
iv)
Transaction Move Order (creates reservations
determines the source and transfers the inventory into the staging areas)
v)
Launch Pick Release (
vi)
Ship Confirm (Shipping Documents(Pickslip
report, Performa Invoice, Shipping Lables))
4) Explain the Order to Cash Flow?
I. Enter
the Sales Order
II. Book
the Sales Order(SO will not be processed until booked(Inventory confirmation))
III. Release
sales order(Pickslip Report is generated and Deliveries are created)
(Deliveries – details about the delivery. Belongs to shipping module
(wsh_deliveries, wsh_new_deliveries,
wsh_delivery_assignments etc) they
explain how many items are being shipped and such details.
IV. Transaction
Move Order (Selects the serial number of the product which has to be
moved/ shipped)
V. Launch
Pick Release
VI. Ship
Confirm (Shipping Documents(Pickslip report, Performa Invoice, Shipping
Lables))
VII. AutoInvoice (Creation of Invoice in Accounts Receivable
Module)
VIII. Autolockbox
( Appling Receipts to Invoices In AR)
IX. Transfer
to General Ledger ( Populates GL interface tables)
X. Journal
Import ( Populates GL base tables)
XI. Posting
( Account Balances Updated).
5. What are the Process Constraints?
A. Process Constraints prevent users from
adding updating, deleting, splitting lines and canceling order or return information beyond certain
points in the order cycle. Oracle has provided certain process constraints
which prevent data integrity violations.
Process
constraints are defined for entities and attributes. Entities include regions
on the sales order window such as order, line, order price adjustments, line price adjustments, order sales credits
and line sales credits. Attributes include individual fields (of a particular
entity) such as warehouse, shit to location, or agreement.
6. What are Validation Templates?
A) Validation Templates are
used to define the validation conditions in process constraints. A validation
template names a conditions and defines the semantic of how to validate that
condition. These are used in processing constraints framework to specify the
constraining conditions for a given constraint. These conditions are based on
- Where the entity
is in its work flow.
- The state of
attributes on an entity.
- Any other
validation condition that cannot be modeled using the above condition.
7. What are different types of Holds?
·
GSA(General Services Administration) Violation Hold(Ensures
that specific customers always get better pricing for example Govt. Customers)
·
Credit Checking Hold( Used for credit checking
feature Ex: Credit Limit)
·
Configurator Validation Hold ( Cause: If we
invalidate a configuration after booking)
8. What
is Document Sequence?
A) Document sequence is defined to
automatically generate numbers for your orders or returns as you enter them.
Single / multiple document sequences can be defined for different order types.
Document sequences can be defined as three
types Automatic (Does not ensure
that the numbers are contiguous), Gapless
(Ensures that the numbering is contiguous),
Manual Numbering. Order Management validates that the number specified is
unique for order type.
9. What
are Defaulting Rules?
A) A defaulting rule is a value that OM automatically places in an order field of the sales
order window. Defaulting rules reduce the amount of information one must enter.
A defaulting rule is a collection of defaulting sources for objects and their
attributes.
It involves the following steps
·
Defaulting Conditions - Conditions for Defaulting
·
Sequence – Priority for search
·
Source – Entity ,Attribute, Value
·
Defaulting source/Value
10. When
an order cannot be cancelled?
A) An order cannot be cancelled if,
·
It has been closed
·
It has already been cancelled
·
A work order is open for an ATO line
·
Any part of the line has been shipped or
invoiced
·
Any return line has been returned or credited.
11. When
an order cannot be deleted?
A) you cannot delete an order line until there
is a need for recording reason.
12. What
is order type?
A) An order type is the classification of
order. It controls the order work flow activity, order number sequence, credit
check point and transaction type. Order Type is associated to a work flow
process which drives the processing of the order.
13. What
are primary and secondary price lists?
A) Every order is associated to a price list as
each item on the order ought to have a price. A price list is contains basic
list information and one or more pricing lines, pricing attributes, qualifiers,
and secondary price lists. The price list that is primarily associated to an
order is termed as Primary price list.
The pricing engine uses a Secondary Price list if it cannot determine the price of the item
ordered in the Primary price list.
14. What
is pick slip? Types?
A) It is an internal shipping document that
pickers use to locate items to ship for an order.
·
Standard Pick Slip – Each order will have its
own pick slip with in each picking batch.
·
Consolidated Pickslip – Pick slip will have all
the orders released in the each picking batch.
15. What
is packing slip?
A) It is an external shipping document that
accompanies the shipment itemizing the contents of the shipment.
16. What
are picking rules?
A) Picking rules define the sources and
prioritization of sub inventories, lots, revisions and locators when the item
is pick released by order management. They are user defined set of rules to
define the priorities order management must use when picking items from
finished goods inventory to ship to a customer.
17.
Where do you find the order status column?
A) In the base tables,
Order Status is maintained both at the header and line level. The field that
maintains the Order status is FLOW_STATUS_CODE. This field is available in both
the OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL.
18. When the order
import program is run it validates and the errors occurred can be seen in?
A) Responsibility:
Order Management Super User
Navigation: Order, Returns > Import
Orders > Corrections
No comments:
Post a Comment