Oracle Apps Functional All About Oracle Apps functional & Technical FAQs, Tutorials

List of tables in Oracle Apps order management 12.1.1

These are all tables present in Order Management modules

How to Cancel an Order Line that been pick released ?

It is not possible to cancel a pick released order line if there are processing constraint which have been enabled to prevent this from happening.

There are two methods that can be used to.

How are cancellations handled in drop ship orders?

A new functionality for Cancelling Drop Ship Orders is added in OE with
the fix for bug 1380679.

How are over/under shipments handled in drop shipment?

If part of a drop-ship line ships and you do not wish to fulfill the
remaining quantity, cancel the line. Over-shipments must also be handled
manually. If the supplier ships more than the ordered quantity, you can bill
your customer for the additional quantity or request that they return the
item.
Use the 'Sales Order and Purchase Order Discrepancy Report' to view differences between your
drop-ship sales orders and their associated purchase requisitions and orders.
Refer to Order Entry/Shipping User's Guide, R11 Volume 1, page 2-1

What are the Item Attributes that affect Drop Ship orders?

The following item attributes affect drop ship orders and they  should be set to respective values as below:

Simple Drop Ship across Set of Books

Key Setups

1.  System Administrator - The person entering and executing Requisition Import must be setup as a 'Buyer' and 'Approver'.  See Note: 295070.1 - Setup Buyer and Approver for Drop Ships.

What are Validation Templates?

Validation Templates are used to define the validation conditions in process constraints.

What is Order Import and What are the Setup’s involved in Order Import?

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.