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.
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 Labels)
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