Wednesday, February 25, 2015

Order to Cash Flow.

Order to cash (OTC or O2C) is a set of business processes that involve receiving and fulfilling customer requests for goods or services.

Flow
------

1#.Order Entry - at this stage it create record in Header table and lines table.

Header Table: OE_Orders_Headers_All;(stores header information of the sales order)

Imp columns: Header_id(unique system genarated id)

ORG_ID,ORDER_NUMBER,SHIP_FROM_ORG_ID,SHIP_TO_ORG_ID and FLOW_STATUS_CODE(is 'Entered' at the time of entry).

Lines Table: OE_ORDERS_LINES_ALL(This table stores the Line Information of the Sales Order)

Imp Columns: Line_id:(unique system genarated id)

Header_id: it is the link between oe_orders_headers_all and oe_orders_lines_all

Ordered_item,invetory_item_id,pricing_quantity,ordered_quantity,flow_status_code and unit_selling_price_per_qty.

FAQs

What are the various order management processes supported by oracle OM
           Standard orders: This method supports Make to Stock business model where the products are made and kept in stock. The products are then shipped to the customer based on his order.
·   Configure to orders: this method supports Assemble to Order business model. The product configuration is chosen at the time of sales order entry. WIP job is created based on the requirement of the sales order
·      Drop ship orders: In this method, your supplier will ship the goods to   your customer on your behalf
·        Internal sales orders: Internal sales orders are created across two    different organizations of the same business group. Internal requisition is raised first and is converted to an internal sales order where the items are shipped based on the quantity specified in the internal sales order.

2#Order Booking: it is the final stage in the order entry.by clicking the book order button,the order is booked.

Now the flow_status_code of the order in different tables are below

OE_ORDERS_HEADERS_ALL - Booked.

OE_ORDERS_LINES_ALL - 'Awaiting Shipping'

WSH_DELIVERY_DETAILS - 'R'(Means Ready to Release)

Important columns of WSH_DELIVERY_DETAILS table:

DELIVERY_DETAIL_ID: Unique system generated id with reference to SOURCE_HEADER_ID (it is the HEADER_ID from OE_ORDER_HEADERS_ALL)
SOURCE_HEADER_ID: It is the HEADER_ID generated from OE_ORDER_HEADERS_ALL
SOURCE_LINE_ID: It is the LINE_ID generated from OE_ORDER_LINES_ALL
RELEASED_STATUS, SOURCE_CODE, CUSTOMER_ID, INVENTORY_ITEM_ID, SHIP_FROM_LOCATION_ID, SHIP_TO_LOCATION_ID, MOVE_ORDER_LINE_ID, REQUESTED_QUANTITY, SHIPPED_QUANTITY,

SUBINVENTORY, SHIP_METHOD_CODE etc.


3#Launch Pick Release:Pick release is the process by which the items on the sales order are taken out from inventory.This process allocates on-hand inventory to your order and inform the warehouse personnel to move the item from inventory to the shipping staging area.Once your item is in the shipping staging area, it is ready to be shipped.

Now the flow_status_code of the order in different tables are below

OE_ORDER_LINES_ALL:  Here the FLOW_STATUS_CODE should be ‘PICKED’ or ‘AWAITING_SHIPPING’ depending on Auto Pick Confirm (set to No or Yes).

WSH_DELIVERY_DETAILS: Here RELEASED_STATUS should be ‘S’ (Submitted for Release) or ‘Y’ (Pick Confirmed). These values again depend on the parameters given at Auto

Pick Confirm (set to No or Yes)

WSH_DELIVERY_ASSIGNMENTS: DELIVERY_ID is populated here (from DELIVERY_DETAIL_ID with reference to WSH_DELIVERY_DETAILS table)

4#Ship Confirm the Order:It is a process of sending the Items from shipping staging area to the Customer site. By ship confirming you will notify EBS that the shipment is complete and thereby updating the on-hand Inventory.  Ships confirm process will kick off the following Concurrent Programs:

Interface Trip stop, Packing slip Report, Bill of Lading, Commercial Invoice

OE_ORDER_LINES_ALL:  Here the FLOW_STATUS_CODE should be ‘SHIPPED’
WSH_DELIVERY_DETAILS:  Here RELEASED_STATUS should be ‘C’ (Shipped)

5#Creating Invoices in Receivables:

Here the invoices are created based on the goods sold. We need to run the 'Workflow Background Process' where it picks up the shipping records and transfer to Receivables interface.

Workflow Background Process Insert new records in ra_interface_lines_all

Important columns of this table:
INTERFACE_LINE_ID: It is the LINE_ID with reference to OE_ORDER_LINES_ALL
INTERFACE_LINE_CONTEXT : Order Entry
INTERFACE_LINE_ATTRIBUTE1 : Order Number
INTERFACE_LINE_ATTRIBUTE3 :Delivery ID.

RA_CUSTOMER_TRX_ALL: Stores Invoice header information.

INTERFACE_HEADER_ATTRIBUTE1 column will have the Order Number.
INTERFACE_HEADER_ATTRIBUTE2 column will have Order Type
TRX_NUMBER column is the Invoice Number

RA_CUSTOMER_TRX_LINES_ALL: Stores Invoice lines information.

INTERFACE_LINE_ATTRIBUTE1 column will have the Order Number.
INTERFACE_LINE_ATTRIBUTE2 column will have Order Type
INTERFACE_LINE_ATTRIBUTE3 column will have Delivery
INTERFACE_LINE_ATTRIBUTE4 column will have Waybill
INTERFACE_LINE_ATTRIBUTE5 column will have count

Creating Invoices in Recevables

6# Create Receipt either manually or using Auto Lockbox

Underlying tables:
AR_CASH_RECEIPTS_ALL
CASH_RECEIPT_ID is the unique system generated ID
FLOW_STATUS_CODE in OE_ORDER_LINES_ALL should be ‘CLOSED’

7#Transfer to Genaral Ledger

8#Journal Import

9#Posting


FAQS:

1.  What are the various order management processes supported by oracle OM
        Standard orders: This method supports Make to Stock business model where the products are made and kept in stock. The products are then shipped to the customer based on his order.
·       Configure to orders: this method supports Assemble to Order business model. The product configuration is chosen at the time of sales order entry. WIP job is created based on the requirement of the sales order
·      Drop ship orders: In this method, your supplier will ship the goods to   your customer on your behalf
·    Internal sales orders: Internal sales orders are created across two    different organizations of the same business group. Internal requisition is raised first and is converted to an internal sales order where the items are shipped based on the quantity specified in the internal sales order.
2.  Describe the order flow in Order to Cash life cycle
  • Enter the sales order
  • Book the sales order
  • Pick release
  • Ship confirm
  • Auto Invoice generation
  • Creating receipt
  • Transfer to GL
3.  Describe the processes involved after entering sales order?
  • The items specified on the order are validated in Oracle Inventory
  • The price of the items are calculated using the pricing engine
  • The availability of the items are checked and may be reserved
  • The items are then pick released and shipped to the customer.
4.  What are the different types of sales orders available?
  • Standard
  • Mixed
  • Return
5.  When is an item eligible for customer order?
When the attributes ‘Customer Ordered’ and ‘Customer order enabled’are checked in the order management tab of Master Items.
6.  Describe the Header status during the sales order process?
Entering the sales order                               Entered
Booking the sales order                                Booked
Pick release the order                                   Booked
Ship confirm the order                                 Booked
Running interface trip stop                          Booked

7.  Describe the line status during the sales order process?
Entering the sales order                               Entered
Booking the sales order                                Awaiting shipping (when  sufficient quantity is available)
Supply eligible (when sufficient quantity is not available)
Pick release the order                                    Picked
Ship confirm the order                                  Shipped
Running interface trip stop                          Closed
8.  Differentiate available quantity and on-hand quantity?
Available quantity + Reserved quantity = On-hand quantity
9.  Differentiate Supply Eligible Status and Supply Partial Status?
Supply Eligible
When there is no sufficient quantity available.
Example: When user tries to book a sales order for Item ‘TestItem’ for a quantity of 10 but the item contains zero quantity. Then the Sales Order Line Status change to ‘Supply Eligible’.
Supply Partial
when the quantity is partially available.
Example: When user tries to book a sales order for Item ‘TestItem’ for a quantity of 10 but the item contains only 4 quantities. Then the Sales Order Line Status changes to ‘Supply Partial’.
10.  Describe scheduling in sales order?
It is a process of communicating the balance between customer demand and a company’s ability to fulfill an order from current inventory and supply sources
11.  What are the various ways of scheduling the sales order?
  • Setting Profile option – OM:AutoSchedule to yes
  • From Tools Menu->Check Autoschedule Checkbox in Sales Order Screen.
  • Right Click on Sales Order Line ->Scheduling->Schedule.
  • Schedule Order Concurrent Program.
12.  Differentiate ship set and arrival set?
In the ship set process, the user would like to ship group of order lines from same warehouse to same location. If Order Lines are grouped under ship set, then until all lines in the ship set satisfy the demand, you cannot ship the goods to customer.
In the Arrival Set process, the customer requests specific order lines to arrive together
13.  What are the Process Constraints?
Processing Constraints allow Order Management users the ability to control changes to sales orders, at all stages of its order or line workflows to avoid data inconsistencies and audit problems.
14.  At what stage an order cannot be cancelled?
An order cannot be cancelled when it is Pick confirmed.
15.  What are picking rules?
A user-defined set of criteria to define the priorities Order Management uses when picking items out of finished goods inventory to ship to a customer. Picking rules are defined in Oracle Inventory.
16.  What are Defaulting Rules?
While creating the order, you can define defaulting rules so that the default values of the fields pop up automatically instead of typing all information.
17.  What are validation templates?
A validation template names a condition and defines the semantics of how to validate that condition. Validation templates can be used in the processing constraints framework to specify the constraining conditions for a given constraint.
18.  What is pick slip?
Pick slip is a shipping document that the pickers use to locate items in the warehouse/ inventory to ship for an order.
19.  What is packing slip?
It is a shipping document that is sent along with the shipment which details the contents that are sent in that shipment.
20.  What is shipping exceptions report?
Shipping exceptions report prints the exceptions messages during ship confirmation.
21  Explain Bill of Lading?
It is a legal document between the shipper of a particular item and the carrier detailing the type, quantity and destination of the good being carried
The bill of lading also serves as a receipt of shipment when the good is delivered to the predetermined destination. This document must accompany the shipped goods, no matter the form of transportation, and must be signed by an authorized representative from the carrier, shipper and receiver.
22.  What is Interface trip stop?
ITS is triggered at the time of shipping if the option ‘defer interface’ is not checked. When this report is run, it performs two main things:
Update the order management (OE_ORDER_LINES_ALL)
Trigger the inventory interface (TO UPDATE Inventory tables)
23.  When is drop ship order created?
  • Customer requires an item that is not stocked normally
  • Customer requires large quantities of the item that is not available with you
  • It is more economical when the supplier sends the item directly to the customer
24.  What is ASN?
It is an advanced Shipment Notice which is transmitted via Electronic Data Interchange (EDI) from a supplier to let the receiving organization know that the shipment is arriving.
The ASN contains the shipment date, time, identification number, packing slip data, freight information etc
25.  What is Autoinvoice?
It is a concurrent program which is used to perform the invoice processing. Once the order or lines are eligible for invoicing, the invoice interface workflow activity interfaces the data to reeivables
26.  Explain the difference between a credit memo and an invoice?
Credit memo is raised to partially or fully reverse an original invoice amount
An invoice is generated in receivables which show the amount owed by the customers for the purchase of goods or services. It may also contain tax and freight charges
27.  What is FOB?
The term FOB means Freight (or free) on Board is commonly used when shipping goods to indicate who pays loading and transportation costs, and/or the point at which the responsibility of the goods transfers from shipper to buyer.
“FOB shipping point” or “FOB origin” indicates the buyer pays shipping cost and takes responsibility for the goods when the goods leave the seller’s premises. “FOB destination” designates the seller will pay shipping costs and remain responsible for the goods until the buyer takes possession.
28.  What are the different RMA Order Types?
RMA with Credit is used when the customer returns the physical product and also receives credit as a result of the return.
RMA no Credit is used when the customer will return the product but will not be receiving a credit as a result of the return.
RMA Credit only is used when the customer will receive a credit, but the physical return of the product is not required.
29.  What are the necessary setups to perform Internal Sales Order?
  • Internal Order and Internal Ordered Enabled set to ‘Yes’.
  • Shipping Network(Intransit or Direct) must be defined.
  • Internal Customer must be defined
30.  What are Modifiers and Qualifiers?
Modifiers are discount, surcharge or special charge that may be applied to the base price and may alter the value of the item. It can be applied either at order level or at the line level.
A qualifier helps you define who is eligible for a price list or modifier. A qualifier can be a customer name, a customer class, an order type, or an order amount that can span orders.
31.  What are the possible reasons for Interface trip stop to complete with Error?
Few reasons may be
1) Order is on Hold
2) Tax is not applied properly
3) On-Hand qty is not available in the Inventory
4) Inventory Period is not open
5) Make sure Schedule Ship Date or Requested Date is within the range of order Date.

No comments: