How to Setup Schedule Ship date based on Schedule Arrival date and Transit Time

This is short post , supported with you tube demo about
1.How to Setup Transit Time
2.How system calculate Schedule Ship date based onTransit Time and Schedule Arrival Date if Order Date Type = 'Arrival'.
3.Impact of Change of Shipping Method on calculation of Schedule Ship Date.
4.Impact of Latest Acceptable date.
4.How we set System Parameter for Latest Acceptable date.

YouTube Demo

Behaviour of Scheduling of Included Items

Scheduling of Included Items

Below are few characteristic of scheduling during the scheduling of Included item (Source - Oracle Order Management User Guide).

1.  When the parent gets scheduled, the included items get scheduled.
2. When the parent gets reserved, included items get reserved.
3. If the parent is not a ship model complete PTO, then the included items get scheduled independently and will not necessarily come from the same warehouse as the parent.
4. A change in order quantity on the model will cascade to all the included items.
5. A change in reserved quantity is always independent.

Overview of Override ATP in Oracle Order Management

Overview of Override ATP

Overriding ATP makes demand visible to planning. It allows an authorized user to schedule a line even if no supply is available. This functionality is designed for exceptions, not normal scheduling. Any user who overrides ATP takes the responsibility to find supply manually.

The Override ATP value remains on the line until the authorized user decides to un-override or unschedule the line.

ATP Data Collections in Oracle Order Management .

ATP Data Collections

To check availability for items, you must specify the data sources that will be used for supply and demand ATP calculations. Oracle Order Management utilizes Oracle APS data collection routines to segregate and store data used in availability checking. Oracle APS data collection routines offer the flexibility to determine various entities to collect and the scheduling of collections by application instance.

Oracle Order Management Order line attribute that result in Re-Scheduling

Oracle Order Management Order line attribute that result in Re-Scheduling

If any of the following order line attributes are modified after the line has been Scheduled, the system attempts to automatically re-schedule the order line:

• Request date

• Schedule ship date

• Schedule arrival date

• Warehouse

• Ordered Quantity

Actions performed when a line is scheduled

Schedule Actions

Found some interesting information in Oracle Order management user guide  about actions  performed by Order Management when a line is scheduled.

Following actions are performed when a line is scheduled:

• Sourcing rules are applied to the order line to assign a ship-from location if the line does not already have one.

• The schedule ship date is calculated. Oracle Advanced Planing and Scheduling Global Order Promising schedules orders. Global Order Promising uses the transit lead time between the shipping warehouse and the receiving party. For an internal order, the receiving party is an internal warehouse.

Table level Data flow for Order to Cash Flow (Oracle Apps)

In this blog I have highlight some of the KEY tables involved in Order to Cash table. There are lot of database table involves in this flow , but I have highlighted the key table and link between these tables.It help you while desiging the reports &queries. These tables are
OE_ORDER_HEADERS_ALL                  OE_ORDER_LINES_ALL 
WSH_DELIVERY_DETAILS                    WSH_DELIVERY_ASSIGNMENTS
WSH_NEW-DELIVERIES                         WSH_DELIVERY_LEGS
WSH_TRIP_STOPS                                   WSH_TRIPS
M TL_TRX_REQUEST_LINES                MTL_MATERIAL_TRANSACTION_TEMP
OE_SETS                                                     OE_LINE_SETS                     
PO_LINES_ALL                                         MTL_RESERVATIONS
MTL_MATERIAL_TRANSACTIONS_ALL
Data Flow Diagram