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, March 28, 2012

Order 2 Cash Flow


Enter the Sales Order: This part includes Entering the Header first.To enter the header we need the customer and it locations details. The order type and the sales rep details. In the others tab enter the tax code and Warehouse. Now in the lines tab - Enter the item Qty & Schedule ship date.

Book Order: Untill the order is booked the order cant be progressed. Booking Kicks off the workflow associated with the Order type and shipping process can be started now.

Pick Release: In the Release window we release the order to make sure it is ready for shippment. one Delivery document created in this process. This process performs a move order transaction in inventory and the items are moved to Stagging from sub inventory.

Ship Confirm: This part is moving the items from stagging to the customer. Three major program runs in this process.

a). Interface trip stop: Purpose of interface trip stop
b). Bill of Lading
c). Commercial invoice.

Interface Trip Stop –

Interface Trip stop plays very critical part in Oracle Order management application. It is concurrent program that you can triggered from Interface > Submit Request . Interface Trip Stop Or you can also trigger this concurrent program at the time of ship confirm by uncheck the ?Defer Interface? checkbox. By Default this check box is uncheck only.
Interface trip stop has 2 parts:

1. It process the data related to Order Management.
2. It Process data related to Inventory. (and we have separate CP for this too ?Inventory Interface?).

In First part it make update on oe_order_lines_all table as well as wsh-delivery_details and once this part executed successfully only then SECOND phase of It has triggered.

If FIRST part error out for some reason then 2nd part will not be triggered, and even if you try to submit ?Inventory Interface?, it will not pick up you data.

Reason -  It will validate and check if oe_interfaced_flag in wsh_delivery_details table is Y or not.
If it is N or X ?inventory Interface? will not pick that record for processing.

I have observed that in most of time user submit the interface trip stop while doing the ship confirm, but there are considerable cases when customer preferred to run this as a scheduled process without specifying the delivery# or Trip #, because their volume of order processing is very high and they want to run this process during some particular time of the day.

Please make a note that unless this process execute, workflow for Order line is remain at SHIP_LINE Notified and will not progress to Fulfill and finally Invoicing .So while deciding when to trigger this program you have to make sure that when you want to Invoice customer.

One piece of advice that I will give here is, Never try to stop execution of this program, unless you have a very valid reason. Any halt in ITS will result in piling of data in SHIP_LLINE notified workflow status and once you start executing again after a stop it will take a deep dive in terms of your performance.


Auto Invoice: Generate the invoice

Drop shipment:

Drop shipment is the process by which an organizatoin takes orders from their customer and gets it fulfilled by a 3rd party. The selling organizatoin places a purchase order to teh 3rd party (supplier) who ships the ordered products to the end customer directly. There are a large number of tables that contain data related to drop ship orders. For example:

oe_order_headers_all and lines_all (order info)
po_requisition_lines_all, headers_all etc.( req. info)
po_headers_all, lines_all (po info)

oe_drop_ship_sources_all (check exact name- this table contains the link between the req, po and the original order).

Drop shipments occur when our supplier ships the product directly to the customer.

Order Management sends information to the Purchasing Application to create a Purchase Order, and then, when that Purchase Order is received (to indicate shipment from the supplier to our customer), the order line is automatically updated to indicate that it was fulfilled.

In this process, the company running Order Management is modeled as the company to whom the end customer places the original order. We call this process Vendor Drop Shipment, to indicate that we are defining the process from this point of view.

The Source Type attribute on the order line, controls whether a line will be fulfilled.

Internally or drop shipped. A source type of External indicates Drop Ship. Only standard items may be drop shipped. Kits and models cannot be drop shipped at this time. You can define an order type that specifies all of its lines be sourced externally.

Drop shipping is a product delivery method in which the seller (retailer) accepts payment for an order, but the customer receives the product(s) directly from the manufacturer. In a drop shipping arrangement, the retailer acts as a middleman between the manufacturer and the customer. His profit in the transaction is the difference between the wholesale and retail price of the items sold.

Drop shipping is very beneficial to smaller retail shops, internet-only storefronts and those who primarily use catalogs for sales. Customers of these outlets don't always expect to walk out with their purchases, so a slight delay between ordering and drop shipping is not a drawback. A representative item may be displayed on the store's shelves or pictured in its catalog, but the actual product purchased may be sitting in a factory's warehouse 3000 miles away.

Drop shipping functionality enables you to take an order from your customer and fulfill it directly from your supplier's site. Order Management enables you to enter drop ship sales orders and lines for standard, model and kit, and configured items, although you currently cannot perform a drop shipment for Ship Model Complete (SMC) PTO’s.

You can receive orders for items that you do not stock or for which you lack sufficient inventory, and have a supplier provide the items directly to your customer. The benefits of drop shipping include:

•No inventory is required.
•Reduced order fulfillment processing costs.
•Reduced flow times.
•Elimination of losses on non-sellable goods.
•Elimination of packing and shipping costs.
•Reduced inventory space requirements.
•Reduced shipping time to your customer.
•Enables you to offer a variety of products to your customers.


When processing drop shipments for orders, you can: Optionally receive and electronically process Advanced Shipping Notices (ASN).

•Automatically perform logical receipts upon notification of shipment.
•Perform Drop Ship for both make and buy items, and automatically default the source type of External for order lines which need to be drop shipped.

Table joins
oe_order_lines_all.line_id                                                           =            ra_customer_trx_lines_all.interface_line_attribute6
oe_order_headers_all.order_number                           =             ra_customer_trx_all.interface_header_attribute1
oe_transaction_types_tl.name                                       =            ra_customer_trx_all.interface_header_attribute2
oe_order_headers_all.salesorder_no                            =          ra_customer_trx_all.ct_reference
oe_order_headers_all.order_number                           =          wsh_delivery_details.source_header_id                                                                                   
oe_order_headers_all.header_id                                               =            wsh_delivery_details.source_header_number
oe_order_headers_all.line_id                                         =          wsh_delivery_details.source_line_id
wsh_delivery_assignments.delivery_detail_id                      =            wsh_delivery_details.delivery_detail_id
wsh_new_deliveries.delivery_id                                               =            wsh_delivery_assignments.delivery_id

Order Management Tables updated in Order to cash cycle:
Oredr Entered:

oe_order_headers_all                              record created in header table.
oe_order_lines_all                                   Lines for particular records
oe_price_adjustments                             When discount gets applied
oe_order_price_attribs                           If line has price attributes then populated
oe_order_holds_all                                  If any hold applied for order like credit check etc.

Booked

oe_order_headers_all                              Booked_flag=Y Order booked.
wsh_delivery_details                              Released_status Ready to release

Pick Released

wsh_delivery_details                              Released_status=Y Released to Warehouse (Line has been released to Inventory for processing).
wsh_picking_batches                              After batch is created for pick release.
mtl_reservations                           This is only soft reservations. No physical movement of stock

Full Transaction

mtl_material_transactions                    No records in mtl_material_transactions.
mtl_txn_request_headers
mtl_txn_request_lines

wsh_delivery_details                              Released to warehouse.
wsh_new_deliveries                                if Auto-Create is Yes then data populated.
wsh_delivery_assignments                   deliveries get assigned.
 
Pick Confirmed -

wsh_delivery_details                              Released_status=Y Hard Reservations. Picked the stock. Physical movement of stock.
 
Ship Confirmed –

wsh_delivery_details                  Released_status=C Y To C:Shipped ; Delivery Note get printed Delivery assigned to trip stop quantity will be decreased from staged.
mtl_material_transactions        On the ship confirm form, check Ship all box.
wsh_new_deliveries                    If Defer Interface is checked I.e its deferred then OM & inventory not updated. If Defer Interface is not checked.: Shipped
oe_order_lines_all                       Shipped_quantity get populated.
wsh_delivery_legs                       1 leg is called as 1 trip.1 Pickup & drop up stop for each trip.
oe_order_headers_all                  If all the lines get shipped then only flag N.

Autoinvoice

wsh_delivery_details                  Released_status=I Need to run workflow background process.
ra_interface_lines_all                 Data will be populated after wkfw process.
ra_customer_trx_all                     After running Autoinvoice Master Program for
ra_customer_trx_lines_all         specific  batch transaction tables get populated
ar_payment_schedules

Price Details

qp_list_headers_b                        To Get Item Price Details.
qp_list_lines

Items On Hand Qty

mtl_onhand_quantities                TO check On Hand Qty Items.

Payment Terms

ra_terms                               Payment terms.

AutoMatic Numbering System


ar_system_parametes_all                        you can chk Automactic Numbering is enabled/disabled.

Customer Information

hz_parties                            Get Customer information include name,contacts,Address and Phone.
hz_party_sites
hz_locations
hz_cust_accounts
hz_cust_account_sites_all
hz_cust_site_uses_all
ra_customers

Document Sequence

fnd_document_sequences                       Document Sequence Numbers.
fnd_doc_sequence_categories
fnd_doc_sequence_assignments

Default rules for Price List

oe_def_attr_def_rules                   Price List Default Rules.
oe_def_attr_condns
ak_object_attributes

End User Details

csi_t_party_details                        To capture End user Details

Sales Credit Sales Credit Information(How much credit can get)

oe_sales_credits

Attaching Documents

fnd_attached_documents                        Attched Documents and Text information
fnd_documents_tl
fnd_documents_short_text

Blanket Sales Order

oe_blanket_headers_all               
Blanket Sales Order Information.
oe_blanket_lines_all

Processing Constraints

oe_pc_assignments                        Sales order Shipment schedule Processing Constratins
oe_pc_exclusions

Sales Order Holds

oe_hold_definitions                      
Order Hold and Managing Details.
oe_hold_authorizations
oe_hold_sources_all
oe_order_holds_all

Hold Relaese

oe_hold_releases_all                    
Hold released Sales Order.

Credit Chk Details

oe_credit_check_rules                 
To get the Credit Check Againt Customer.

Cancel Orders

oe_order_lines_all                         Cancel Order Details.


Order Management Super User-> Order Returns -> Sales Order
Create a Sales Order
a. Order Header -> Main Tab
B .Order Header -> Others Tab

Verify that the default values will be populated automatically at the Order Header Level

c. Click on the Lines Tab
d. Enter the following details:
Ordered Item: AS54888
Quantity: 14

The price and other details will be populated automatically. Click on each tab to verify the default values that are populated.

e. Book the Order. (B) -> Book Order
f. Note the Order# at the Order Header level.

At this stage Order has been created with one line and the order is in Booked state. The header information is stored in OE_ORDER_HEADERS_ALL and line information is stored in OE_ORDER_LINES_ALL table.

g. Examine the order to get the header id as per the screen shot below
h. Use the following query to get Order details:

SELECT ooha.*
FROM oe_order_headers_all ooha
oe_order_lines_all oola
WHERE 1 1
AND ooha.header_id oola.header_id
AND ooha.header_id 94219

I. (N)->Shipping->Transactions
Enter the Order number and click on Find Button

J. You will find the line status as Ready to Release that means that the next step is to release the sales order
As the order is booked the order record is also stored in WSH_DELIVERY_DETAILS table. The above screen shot uses this table. Use the following query

SELECT *
FROM wsh_delivery_details
WHERE source_header_id 94219

L. Now we are ready to release the order

(N)-> Shipping->Release Sales Orders-> Release Sales Orders
Enter the Order# that you want to release as shown the screen shot below
Based on the picking rule the Auto Create Delivery Auto Pick confirm would be set.

(T)-> Shipping
(T)-> Inventory The inventory org from which the Quantity will be shipped

Click on (B) -> Concurrent to invoke the Pick Release program. It will submit a new request as shown in the screen shot below.
View the output of the Pick Slip report. It gives all the details about the subinventory i.e. from FG to Staging etc.
Pick Slip Output
Once the order has been released it populates the WSH_PICKING_BATCHES table. Also verify the order status on the shipping transactions form.

(N)->Shipping-> Transactions

The above screen shot shows there are two delivery lines. The reason is if you look at the pick slip report it has picked up the quantity from two subinventories. Since there are two delivery lines you will find two records in WSH_DELIVERY_DETAILS table. Note that the screen shot shows that the next step is to ship confirm the order. That means the order is now ready to ship.
Click on Delivery Tab and select ship confirm from Actions combo box
And hit the (B) Go Button.

Check the Create Bill of Lading check box and click on Ok Button to ship confirm.
The above message indicates that the product has been delivered successfully. After that you will find the status as Closed .

At this moment you find records in the following tables:
WSH_TRIPS
WSH_TRIP_STOPS
WSH_DELIVERY_ASSIGNMENTS
WSH_DELIVERY_LEGS
WSH_NEW_DELIVERIES

Query on the Order number on the shipping transactions form to find the order status:
It shows the status as Interfaced .

(N)->Orders Returns -> Sales Orders and query the order. Go to Tools menu and open the workflow status menu

Click on View Diagram button to view the order status
Run the workflow background process to move the order records from OM to AR interface tables.

(N)->System Administrator ->Requests->Run
Select Workflow Background Process and submit the request with the following parameters
Once the request completes normal then all the order records will be moved to
RA_INTERFACE_LINES_ALL table.
There is a column called sales_order in this table. Query with your sales order number to find the records in this table.
To create AR invoice we need to pull the records from RA_INTERFACE_LINES_ALL table to AR invoice base tables. Run the Auto Invoice Master program from Receivables Vision Operations (USA) responsibility.

(N)->Receivables Vision Operations (USA) ->Interfaces-> AutoInvoice
This in turn invokes the Auto Invoice Import Program to create AR invoice.
Verify the AR invoice has been created against this order.

(N)->Transactions->Transactions

Enter the Order number in the reference field as shown in the screen shot below:
Invoice Header:
Invoice line:
Verify the Invoice amount freight charges Tax charges etc. This total should match with the amount that was populated on Order Header.

The AR invoice information is available in
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL

This completes the Order to Cash cycle. This is the Oracle standard process from booking to invoicing. This document doesn t cover in detail about the setups involved picking rules etc. The purpose of this document is to give an overview of the order cycle. See the workflow status of the order now.

1 comment:

uday from vizayawada said...

thanks for this kind of information its nice

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