OE_TABLES [OM tables]

Order Management

Table Or View: Table

Description: 

Following are important OM tables

 

OE_ORDER_HEADERS_ALL
 

OE_ORDER_LINES_ALL

 

SALES CREDITS
OE_SALES_CREDITS

 

PRICE ADJUSTMENTS
 

OE_PRICE_ADJUSTMENTSThis entity stores Order and Line price adjustments information. It stores the benefits offered at header, line or group of lines. Benefits can be discounts on other items, item upgrade, terms substitution, coupons, discounts, surcharges etc.
This table has a lot more columns than SO_PRICE_ADJUSTMENTS to support the capabilities offered by Advanced Pricing. The entity also stores information for tax, freight and special charges.

 

PRICING ATTRIBUTES
 

OE_ORDER_PRICE_ATTRIBSWith Order Management, Order and Line pricing attributes are stored in a different entity. The Order and Line Pricing Attributes Descriptive Flex Definitions are based off this table. You now have 100 pricing attribute columns.
With Advanced Pricing you can use multiple descriptive flex contexts for a given Order Line. With Basic pricing, when entering an Order you can select only one Context (excluding the Item and Volume Contexts which have special meaning).

LOT AND SERIAL NUMBERS
 

OE_LOT_SERIAL_NUMBERSThis is a new entity in Order Management. It stores lot and serial number information for return lines. Order Management lets you create returns using the original serial number as a reference. If you create a return using the original
Order or Invoice as a reference and the item being returned was under serial number control, the application automatically pulls up serial number information from Oracle Inventory.

 

HISTORY
 

OE_ORDER_LINES_HISTORYYou are required to provide a cancellation reason only when you are canceling and the canceled quantity on the
line is incremented by the appropriate amount. A picture of the old record is
captured whenever a reason code is provided with a quantity change. This is
stored in .