Order Management Functional Document

Order Management

1) Oracle Order Management Recommended Setup

Setup involves several phases, including setting up other integrated applications, which include Oracle General Ledger, Oracle Receivables, and Oracle Inventory.

Some setup steps are optional, depending on whether you have the integrating applications installed and whether you use the associated feature. For example, if your business supports drop shipments, you should also setup Oracle Purchasing.

If you are using a multiple organization structure, your system administrator must change the OM: Item Validation Organization parameter to be visible and updatable at the responsibility level. This change allows Order Management to default code and revenue account information accurately.

Step 1

Flexfields

Define key and descriptive flexfields to capture additional information about orders and transactions.

Accounting (Oracle General Ledger)

Defining your Accounting key flexfield is part of setting up your sets of books.

Item Catalogs (Oracle Inventory)

If you make entries for items in a standard industry catalog or if you want to group items according to certain descriptive elements, you need to configure this flexfield. Even if you do not use item cataloguing, you must enable at least one segment of this flexfield and compile it before you define your items.

Item Categories (Oracle Inventory)

You must set up this flexfield before you define items because all items must be assigned to categories.

Sales Orders (Oracle Inventory)

Use the Sales Orders key flexfield to differentiate sales order transactions that Order Management interfaces to Oracle Inventory. You must define this flexfield before placing demand or reservations in Order Management. The profile option OM:Source Code defaults the source code you use in the third flexfield segment.

Stock Locators (Oracle Inventory)

If you want to track items by a specific aisle or row, use this key flexfield to capture additional information about inventory stock locators. If you use this flexfield, you must set theOM: Inventory Stock Location profile option.

System Items (Oracle Inventory)

Before you define items, set up this flexfield in order to record and report item information. The OM: Item Flexfield profile option needs to be set.

Sales Tax Location (Oracle Receivables)

Use this flexfield to charge your customers for tax based on their shipping addresses.

Territory (Oracle Receivables)

The Territory flexfield can be associated with salespeople, invoices, and customer site addresses. Use it to record and report territory information.

Descriptive Flexfields

Additional Line Detail Information (Oracle Order Management)

This descriptive flexfield displays any additional line detail information at the time of order entry.

Industry Attribute (Oracle Order Management)

This descriptive flexfield records industry-specific information for items in your order.

Pricing Attributes (Oracle Order Management and Oracle Advanced Pricing)

Pricing attributes modify an item’s price without requiring that you create a new item. For example, you sell computer software and the price of the software is different depending on the number of users. You define a pricing attribute called

Number Of Users. When you enter an order line, the Pricing Attributes flexfield opens a window to capture the number of users. Order Management uses this information along with the item and unit of measure to derive the item list price.

The Pricing Attributes descriptive flexfield contains 15 user-definable flexfield segments to be used as pricing attributes. Once defined, the attributes can be used in the lines block of the Sales Orders window, the Line Options window, the Shipment Schedules window, the lines block of the Price Lists window, and the Item Groups window in Order Management; and in the Services and Renew Service windows in Oracle Service.

Step 2

Multiple Organizations

Define multiple organizations in Oracle Inventory.

Step 3

Inventory Organizations

Define inventory organizations (warehouses), organization parameters, sub-inventories, and picking rules in Oracle Inventory.

You must define at least one item validation organization and at least one organization that acts as an inventory source for orders fulfilled internally. If you plan to drop ship some orders, you must also define at least one logical organization for receiving purposes. Your item validation organization can be the

same as your inventory source or your logical receiving organization, but you cannot use one organization for all three purposes.

Step 4

Profile Options

Define profile options to specify certain implementation parameters, processing options, and system options.

Some of the profile options are

OM: Allow Negative Pricing

OM: Apply Automatic Attachments

OM: Auto schedule

OM: Customer

Step 6

Invoicing

Define invoicing information, including payment terms, invoicing and accounting rules, Auto Accounting parameters, territories, and invoice sources. See the following topics in the Oracle Receivables User’s Guide for more information: Payment terms, Invoice with Rules, Transaction Types, Auto Accounting, Territories, and Invoice Batch Sources.

Step 7

Salespersons

Define information on your sales representatives.

Step 8

Tax

Define tax features, such as codes, rates, exceptions, and exemptions.

Step 9

QuickCodes

Define QuickCodes that provide custom values for many lists of values throughout Order Management

Some of the quick codes are,

- Cancellation Codes

_ Credit Cards

_ Freight Terms

_ Hold Types

_ Note Usage Formats

_ Release Reasons

_ Sales Channels

_ Shipment Priorities

Step 10

Workflow

Define order and line processing flows to meet different order and line type requirements.

Step 11

Document Sequences (Order Numbering)

Define Document Sequences for automatic or manual numbering of orders.

Step 12

Order Import Sources

Define sources for importing orders into Order Management.

Step 13

Units of Measure

Define the units of measure in which you supply items.

Step 14

Item Information

Define item information, including item attribute controls, categories, and statuses. Defining Item Attribute Controls, Defining Categories, and Defining Item Status Codes.

Step 16

Configurations

Define the configurations that you sell. See: Creating a Bill of Material, Oracle Bills of Material User’s Guide.

Step 17

Customer Classes

Define customer profile classes. See: Defining Customer Profile Classes: page, Oracle Receivables User’s Guide

.

Step 18

Customers

Define information on your customers. See: Entering Customers, Oracle Receivables User’s Guide.

Step 19

Item Cross References

Define item cross references for ordering by customer part number, UPC, or any generic item number. See: Oracle Inventory’s User’s Guide.

Step 20

Sourcing

Define your sourcing rules for scheduling supply chain ATP functions. See: OracleAdvanced Supply Chain Planning User’s Guide.

Step 21

Transaction Types (Order and Line Types)

Define transaction types to classify orders and returns. For each order type, you can assign a default price list, defaulting rules, order lines, return lines, line types, workflow assignments, payment terms, and freight terms. See: Defining Transaction Types

Step 22

Cost of Goods Sold (COGS)

Set up your Cost of Goods Sold Accounting Flexfield combination (COGS Account) in Oracle Inventory. See: Oracle Inventory User’s Guide.

Step 23

Processing Constraints

Define processing constraints to prevent users from adding updating, deleting, splitting lines, and cancelling order or return information beyond certain points in your order cycles. Use the constraints Order Management provides, which prevent data integrity violations, or create your own. See: Defining Processing Constraints, Defining Validation Templates, and Defining Record Sets

Step 24

Defaulting Rules

Define defaulting rules to determine the source and prioritization for defaulting order information to reduce the amount of information you must enter manually in the Sales Orders window. See: Defining Defaulting Rules

Step 25

Credit Checking

Define your credit checking rules. See: Automatic Credit Checking of Orders, Defining Credit Check Rules, and Defining Sales Credit Types

Step 26

Holds

Define automatic holds to apply to orders and returns. See: Defining Holds

Step 27

Attachments

Define standard documents to attach automatically to orders and returns.

Step 28

Freight Charges and Carriers

Define freight charges and freight carriers to specify on orders. See: Defining

Freight Costs and Defining Freight Carriers, Oracle Shipping Execution User’s Guide.

Step 29

Pricing

Define price lists for each combination of item and unit of measure that you sell.

Optionally, you can define pricing rules and parameters to add flexibility.

Step 30

Shipping

Define shipping preferences in Oracle Shipping Execution. See: Oracle Shipping Execution User’s Guide.

Step 15

Items

Define the items that you sell, as well as container items.

2) Definitions

Account Generator

The Account Generator in Oracle Order Management utilizes Oracle Workflow. You can view and customize Account Generator processes through the Oracle Workflow Builder.

Order Management and Oracle Shipping Execution insert a Cost of Goods Sold Accounting Flexfield combination (COGS Account) for each inventory transaction line into Oracle Inventory via the Inventory Interface program. You can use the COGS Account as a basis for cost of goods sold analysis in Oracle Inventory. The Account Generator dynamically creates a COGS Account to transfer from

Order Management and Oracle Shipping Execution to Oracle Inventory for each order and return line when it completes the Inventory Interface cycle action. You can customize the default process to make your cost of goods sold analysis more meaningful.

Accounting rules

Auto Invoice uses to specify revenue recognition schedules for transactions. You can define an accounting rule where revenue is recognized over a fixed or variable period of time. For example, you can define a fixed duration accounting rule with monthly revenue recognition for a period of 12 months.

AutoInvoice

A program that imports invoices, credit memos, and on account credits from other systems to Oracle Receivables.

Available To Promise (ATP)

The quantity of current on-hand stock, outstanding receipts and planned production which has not been committed through a reservation or placing demand.

backorder

An unfulfilled customer order or commitment. Oracle Order Management allows you to create backorders automatically or manually from released order lines.

Base Price

The original price for an item obtained from the Price List; the price before any price adjustments are applied. Also known as List Price.

bill of lading

A carrier’s contract and receipt of goods transported from one location to another.

bill of material

A list of component items associated with a parent item and information about how each item relates to the parent item.

carriers code (SCAC)

The Standard Carrier Alpha Code is required on carrier supplied bills of lading.

category

Code used to group items with similar characteristics, such as plastics, metals, or glass items.

category set

A feature in Inventory where users may define their own group of categories. Typical category sets include purchasing, materials, costing, and planning.

credit check rule

A rule that defines the components used to calculate a customer’s outstanding credit balance. Components include open receivables, uninvoiced orders, and orders on hold. You can include or exclude components in the equation to derive credit balances consistent with your company’s credit policies.

credit memo

A document that partially or fully reverses an original invoice amount.

cumulative discounts

Discounts whose percentages are summed up before applying the discount are referred to as Cumulative Discounts.

customer class

A method to classify and group your customers. For example, you could group them by their business type, size, or location. You can create an unlimited number of customer classes.

customer profile

A method used to categorize customers based on credit information. Oracle Receivables uses credit profiles to assign statement cycles, dunning letter cycles, salespersons, and collectors to your customers. You can also decide whether you want to charge your customers interest. Oracle Order Management uses the order

and total order limits when performing credit checking.

customer profile class

These allow for grouping of customers with similar credit worthiness, business volume, and payment cycles. For each profile class you can define information such as credit limits, payment terms, statement cycles, invoicing, and discount information. The customer profile class when assigned to a customer provides the default values for this information.

defaulting rules

Information Oracle Order Management automatically enters depending on other information you enter.

demand class

A demand class may represent a particular grouping of customers, such as government and commercial customers. Demand classes may also represent different sources of demand, such as retail, mail order, and wholesale.

discount amount

This is the difference between the list price and the selling price for the item. If the discount was specified as an “amount” discount, then this value will not change even if the price list changes. For example, if Item A’s list price is $10, and we have a 20% discount, then the discount amount is $2. If we then change price lists, and Item A will cost $20 on the new price list, the discount amount for that same 20% discount now becomes $4. If however, the discount was not a percentage and was an “amount” discount of $2, then whether the list price for the associated price list is $10, $20, or $5, the discount amount will always be $2.

discounts

Is a Modifier type in Oracle Pricing that creates Pricing Adjustments which allows Pricing Engine to extend a reduced price for an order, specific line item, or group of lines.

drop shipment

A method of fulfilling sales orders by selling products without handling, stocking, or delivering them. The selling company buys a product from a supplier and has the supplier ship the product directly to customers.

dropship item

An item which is going to be sourced externally from the vendor directly to our customer.

dunning letters

A letter you send to your customers to inform them of past due debit items. Oracle Receivables lets you specify the text and format of each letter. You can choose to include unapplied and on-account payments.

exchange rate type

A specification of the source of an exchange rate. For example, a user exchange rate or a corporate exchange rate. see corporate exchange rate, spot exchange rate.

extended price

The extended price is the cost of the line. This is computed by multiplying the selling price per unit by the number of units ordered on that line. Thus, if two of item A cost $10.00 each, the extended price is $20.00 for the line.

FIFO costing

Costing method where it is assumed that items that were received earliest are transacted first.

fixed price discount

A discount that fixes the final selling price of the item so it is not affected by changes to the list price of the item. It is a method of implementing discounts to the list price where the final price is contractually fixed regardless of changes to the list price, as is the case with GSA prices. For example, if Item A has a list price of $100, a fixed price discount specifying a selling price of $90 results in a selling price of $90 even if the list price later increases to $110.

freight on board (FOB)

The point or location where the ownership title of goods is transferred from the seller to the buyer.

freight charges

A shipment-related charge added during ship confirmation and billed to your customer.

freight terms

An agreement indicating who pays the freight costs of an order and when they are to be paid. Freight terms do not affect accounting freight charges.

GRN (Goods Received Note)

Goods Received Note. Synonym for receipt or material receipt.

gross weight

The weight of the fully loaded vehicle, container, or item, including packed items and packaging material.

GSA (General Services Administration)

GSA (General Services Administration): a customer classification that indicates the customer is a U.S. government customer. For products on the GSA price list, a fixed price must be used, defined on the GSA contract. The items contained on the GSA price list cannot be sold to commercial customers for the same or less price than the government price. In other terms, the price offered to the government must be the

minimum in the market.

GSA Discounts

Discounts that can be specifically defined for giving the lowest selling price to some or all of the GSA customers. A customer classification that indicates the customer is a U.S. government customer and pricing for products on the GSA price sheet should reflect the fixed pricing of the GSA contract. Whenever a product is on the GSA price sheet, it cannot be sold to commercial customers for the same or less price than the government customer.

guarantee

A contractual obligation to purchase a specified amount of goods or services over a predefined period of time.

Inbound/Outbound Lines

In the Order Management schema, lines on a header are either ALL outbound; meaning sales order lines, in which material on the header is leaving the warehouse to go to a customer, or they are ALL inbound; meaning return lines, in which material on the header is arriving at the warehouse to be credited back to the

customer. In Order Management, headers can be ‘RETURN’ (all inbound), ‘ORDER’ (all outbound), or ‘MIXED’ (both inbound and outbound lines).

Inbound Purchase Order

Inbound Purchase Order refers to the action of receiving purchasing information from customers and creating valid sales orders within Oracle Order Management.

intangible item

A non-physical item sold to your customers such as consulting services or a warranty. Intangible items are non-shippable and do not appear on pick slips and pack slips.

intermediate ship-to

The delivery point for a shipment prior to an ultimate destination.

inventory organization

An organization that tracks inventory transactions and balances, and/or that manufactures or distributes products.

invoicing rules

Rules that Oracle Receivables uses to determine when you bill your invoices. You can bill In Advance or In Arrears.

LIFO costing

Costing method where it is assumed that items that were received most recently are transacted first.

loading order

Determines the order in which items are loaded on a truck for delivery in the requested production sequence. The loading order can be forward, reverse - inverted, or non-inverted.

locator

Physical area within a subinventory where you store material, such as a row, aisle, bin, or shelf.

lockbox

A service commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing. Lockbox processors set up special postal codes to receive payments, deposit funds and provide electronic account receivable input to corporate customers. A lockbox operation can process millions of transactions a month.

logical organization

A business unit that tracks items for accounting purposes but does not physically exist.

LOOKUP

Attributes are validated by a lookup type. The lookup code is stored in the attribute, but the code’s translated meaning will be displayed whenever the attribute value is viewed by an end user.

lookup code

The internal name of a value defined in an Oracle Workflow lookup type.

lookup type

An Oracle Workflow predefined list of values. Each value in a lookup type has an internal and a display name.

modifier

Defines the terms of how Oracle Pricing will make adjustments. For example, a modifier can take the form of: discounts, or surcharges. In Oracle Pricing, when you setup modifiers, you define the adjustments your customers may receive. You control the application of modifiers by the pricing engine by also setting up rules that specify qualifiers and attributes governing their use.

modifier list

A grouping of modifiers in Oracle Pricing.

order category

An Order Transaction Type can be for any of the following Order Categories: ‘ORDER’, ‘RETURN’ or ‘MIXED’. Line Transaction Types can be for any of the categories: ‘ORDER’ or ‘RETURN’. When an Order is created with a particular Transaction Type, the Order Category code determines which lines are permitted for that order. If the category code is ‘ORDER’, then the order can have only regular Lines. If the category code is ‘RETURN’, then the order can have only return lines. If the category code is ‘MIXED’, then the order can have both kinds of lines.

order cycle

A sequence of actions you or Order Management perform on an order to complete the order. An order cycle lets you define the activity an order follows from initial entry through closing. You can define as many order cycles as your business requires. Order cycles are assigned to order types.

Order Import

Order Import is an Oracle Order Management’s Open Interface that imports orders from an internal or external source, Oracle or Non-Oracle system, which performs all the validations before importing the order.

Order Processing Cycle

A sequence of actions you or Order Management performs on an order to complete the order. An order cycle lets you define the activity an order follows from initial entry through closing. Each order line goes through a cycle appropriate to the order type, line type (standard, return or internal) and item type (standard, model, shippable, transactable, etc.) of that line.

payment terms

The due date and discount date for payment of an invoice. For example, the payment term ’2% 10, Net 30’ lets a customer take a two percent discount if payment is received within 10 days, with the balance due within 30 days of the invoice date.

pick release

An order cycle action to notify warehouse personnel that orders are ready for picking.

pick release rule

A user-defined set of criteria to define what order lines should be selected during pick release.

pick slip

Internal shipping document pickers use to locate items to ship for an order. If you use standard pick slips, each order will have its own pick slip within each picking batch. If you use the consolidated pick slip, the pick slip contains all orders released in that picking batch.

pick slip grouping rule

Criterion for grouping together various types of pick slips. The rule dictates how the Pick Slip Report program groups released lines into different pick slips.

pick-to-order

A configure-to-order environment where the options and included items in a model appear on pick slips and order pickers gather the options when they ship the order. Alternative to manufacturing the parent item on a work order and then shipping it. Pick-to-order is also an item attribute that you can apply to standard, model, and option class items.

picking rule

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.

PO Change Request Vs. Sales Order

The term ‘sales order’ refers to the sales order data as stored in the base Oracle Order Entry tables. The term ‘PO Change Request’ or ‘PO Change Request process’ refers to the pending sales order data as stored and processed in this new change order process. Accepted PO Change Request result in an updated Sales Order in the base Oracle Order Management tables. There may be more than one pending change order request in the process for a given purchase order.

price adjustment

The difference between the list price of an item and its actual selling price. Price adjustments can have a positive or negative impact on the list price. Price adjustments that lower the list price are also commonly aknown as discounts. Price adjustments can be for an order line or the entire order.

price breaks

Discounts for buying large quantities or values of a particular item of a particular UOM, item category or any enabled pricing attribute.

price list

A list containing the base selling price per unit for a group of items, item categories or service offered. All prices in a price list are for the same currency.

pricing components

Combinations of pricing parameters you use when defining pricing rules. Pricing components can be made up of one or multiple pricing parameters.

pricing contracts

Used to setup a contract with associated contract lines which specifies the items that customer will purchase. Using the contract lines users will be able to setup items , their price, effective dates and price breaks for that item. Users will be able to have multiple versions of the contract and contract lines with different effective dates.

pricing information

Information that pricing calculation is based on such as pricing date, price list and unit price.

pricing parameters

A parameter you use to create components to be used in a pricing rule. Valid pricing parameters include segments of your item flexfield or Pricing Attributes descriptive flexfield.

pricing rule

A mathematical formula used to define item pricing. You create a pricing rule by combining pricing components and assigning a value to the components. Oracle Order Management automatically creates list prices based on formulas you define.

profile option

A set of changeable options that affect the way your applications run. In general, profile options can be set at one or more of the following levels: site, application, responsibility, and user.

proof of delivery

A document that the customers receiving dock signs to show how much they received. It may be used as the basis of billing by a haulage company.

QuickCodes

Codes that you define for the activities and terminology you use in your business. For example, you can define QuickCodes for personal titles, (for example, ‘Sales Manager’) so you can refer to people using these titles. You can define QuickCodes for sales channels so that you can specify the various sales channels used for different kinds of orders. An Oracle Assets feature that allows you to enter standard

descriptions for your business. You can enter QuickCode values for your Property Types, Retirement Types, Asset Descriptions, Journal Entries, and Mass Additions Queue Names.

return material authorization (RMA)

Permission for a customer to return items. Receivables allows you to authorize the return of your sales orders as well as sales made by other dealers or suppliers, as long as the items are part of your item master and price list.

scheduling

Order scheduling includes assigning demand or reservations, warehouses, shipment dates, and lots or subinventories to an order line.

selling price

The selling price is the unit cost for a particular item. Thus, if two of item A cost $10.00 each, the selling price is $10.00 for each unit.

set of books

A financial reporting entity that partitions General Ledger information and uses a particular chart of accounts, functional currency, and accounting calendar. This concept is the same whether or not the Multi-organization support feature is implemented.

shippable item

An item with the Shippable inventory item attribute set to Yes, indicating that this item will appear on pick slips and pack slips.

shipping documents

Shipping related reports, such as the Bill of Lading, Commercial Invoice, Mailing Label, Pack Slip, Vehicle Load Sheet Summary, and Waybill.

territory flexfield

A key flexfield you can use to categorize customers and salespersons.

trip stop

A location at which the trip is due for a pick-up or drop-off.

Workflow

This determines the header flow for an order transaction type or line flows possible for a line transaction type. There can be only one header flow associated with an Order Transaction Type but a line Transaction Type can be coupled with different Order Types and Item Types and there can be different flow couplings for the permitted Transaction Type, Item Type combinations.

Workflow Engine

The Oracle Workflow component that implements a workflow process definition. The Workflow Engine manages the state of all activities, automatically executes functions, maintains a history of completed activities, and detects error conditions and starts error processes. The Workflow Engine is implemented in server PL/SQL and activated when a call to an engine API is made. See Account Generator, activity, function, item type.

Standard Order Flow

Create sales order

Schedule it

Book it

Pick release

Ship confirm

Scheduling – Auto/Manual.

Available – is the actual available

Qty on Hand – is the actual available + Reserved Items + unreserved Items

Reservable – is the reserved items

Order header Status – Entered, Booked

Order Line status – Entered, awaiting status, picked

Pick Release Order status – Unreleased, All, Back ordered

Ship Transaction Status – Staged, not staged, back ordered, Shipped, Not Shipped, Cancel

Public Table List

Table Name Description

AK_FOREIGN_KEYS Foreign keys for an object

AK_FOREIGN_KEY_COLUMNS Links an attribute to a foreign key

AK_OBJECTS Defines an object and the application id of the owner of the

object

AK_OBJECT_ATTRIBUTES Links an attribute to an object - Contain API packages

AK_UNIQUE_KEYS Unique keys for an object

AK_UNIQUE_KEY_COLUMNS Links an attribute to a unique key

BOM_INVENTORY_COMPONENTS Bill of material components

FND_APPLICATION Applications registered with Oracle Application Object Library

FND_CONCURRENT_REQUESTS Concurrent requests information

FND_CURRENCIES Currencies enabled for use at your site

FND_DOCUMENTS Documents

FND_DOCUMENT_SEQUENCES Document sequences registered with Oracle Application Object Library

FND_DOC_SEQUENCE_ASSIGNMENTS Assigns a sequence to a document

FND_LANGUAGES National dialects

FND_LOOKUP_VALUES Quick Code values

FND_RESPONSIBILITY Responsibilities

FND_USER Application users

GL_DAILY_CONVERSION_TYPES Foreign currency daily conversion rate

HR_ALL_ORGANIZATION_UNITS Organization unit definitions

HR_ORGANIZATION_INFORMATION Additional attributes of an organization, dependent on class

or organization information type

MTL_CUSTOMER_ITEMS Customer item Information

MTL_CUSTOMER_ITEM_XREFS Relationships between customer items and inventory items

MTL_LOT_NUMBERS Lot number definitions

MTL_RELATED_ITEMS Item relationships

MTL_SYSTEM_ITEMS_B Inventory item definitions

MTL_UNITS_OF_MEASURE_TL Unit of measure definitions

OE_ACTIONS_IFACE_ALL This is a multi–org table for sales order actions (holds, booking etc.) open interface.

OE_ACTION_PRE_REQS A temporary table used during the WF upgrade into R11i.

OE_AGREEMENTS_B stores all information about pricing agreements.

OE_AGREEMENTS_TL stores the translatable column, i.e. name of the agreement, in each of the available languages in the database.

OE_ATTACHMENT_RULE_ELEMENTS stores the attributes and attribute values that make up the attachment rule.

OE_CREDITS_IFACE_ALL This is a multi–org table for sales order/line credits open interface

OE_CREDIT_CHECK_RULES This table stores information about the credit check rules.

OE_CUST_ITEM_SETTINGS OE_CUST_ITEM_SETTINGS stores the shipment and return tolerances for customer–item, item–site and item combinations

OE_CUST_TOTAL_AMTS_ALL Stores the accumulated order value for a customer over three periods

OE_DEF_ATTR_CONDNS Associates the defaulting condition, defined at the entity level , to a specific attribute

OE_DEF_ATTR_DEF_RULES Defaulting rules for an attribute for a defaulting condition.

OE_DEF_CONDITIONS This table stores defaulting conditions for an entity

OE_DROP_SHIP_SOURCES This table stores relationship between Order Lines in oe_order_lines_all table and associated oracle purchasing requisitions in PO_REQUISITIONS_ALL and Oracle purchasing purchase orders in PO_LINES_ALL.

OE_EVENT_ATTRIBUTES This table stores order header and line attributes which trigger repricing, when modified, at various pricing events.

OE_HEADERS_IFACE_ALL This is a multi–org table for sales order headers open interface. OE_HEADER_ACKS This tables stores information about the acknowledgements for Order Headers.

OE_HOLD_AUTHORIZATIONS Stores information about who has the authority to apply and release holds.– Retrofitted

OE_HOLD_DEFINITIONS This table stores information about hold name and its validity period. OE_HOLD_RELEASES This tables stores information about all the holds that has been released.

OE_INVOICE_NUMBERS This table is used for generating invoice numbers based on the delivery name.

OE_ITEM_CUST_VOLS_ALL This table stores accumulated order quantity and value for an item of a customer over three periods.

OE_LINES_IFACE_ALL This is a multi–org table for sales order lines open interface.

OE_LINE_ACKS This table stores information about the acknowledgements for Order Lines.

OE_LINE_SETS This table stores information about Sets.

OE_LOTSERIALS_IFACE_ALL This is a multi–org table for return line lot serials open interface. OE_LOTSERIAL_ACKS This table stores information about the acknowledgements for lot serials

OE_LOT_SERIAL_NUMBERS This table stores customer reported lot serial numbers for lot and / or serial number controlled return lines.

OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.

OE_ORDER_HOLDS_ALL This table stores information of all the orders and lines that are on hold and the link to hold sources and hold releases.

OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.

OE_ORDER_LINES_HISTORY stores history of quantity changes on order lines.

OE_ORDER_PRICE_ATTRIBS This table stores pricing attributes and asked for promotions, deals and coupon number entered by the user.

OE_ORDER_SOURCES Feeder System Names that create orders in Order Management tables.

OE_PRICE_ADJS_IFACE_ALL This is a multi–org open interface table for sales order/line price adjustments.

OE_PRICE_ADJUSTMENTS This table is used to store price adjustments that have been applied to an order or a line.

OE_PRICE_ADJ_ASSOCS This table stores the association between Order lines and price adjustments and also between price adjustments

OE_PRICE_ADJ_ATTRIBS This table stores information on qualifiers and pricing attributes, which the corresponding price adjustment line qualified for.

OE_PRICE_ATTS_IFACE_ALL This is a multi–org Interface table to populate OE_ORDER_PRICE_ATTRIBS.

OE_PURGE_ORDERS stores the order details for orders included in a purge set.

OE_RESERVTNS_IFACE_ALL This is a multi–org table for inventory reservations open interface. OE_SALES_CREDITS This table stores information about sales credits.

OE_SALES_CREDIT_TYPES This table stores information about sales credit types.

OE_SETS OE_SETS stores information on line sets.

OE_SYSTEM_PARAMETERS_ALL This table is used for storing all system parameter information.

OE_TRANSACTION_TYPES_ALL This table stores information about the order and line transaction types

OE_TRANSACTION_TYPES_TL This is a mult–lingual table for OE_TRANSACTION_TYPES_ALL table.

OE_WORKFLOW_ASSIGNMENTS This table associates assignments to order types and line types. ONT_PRT_MARGIN_ANALYSIS contains margin analysis information grouped by customer, item, territory, and sales person for three different time periods, last week, last 30 days, and last 90 days

PO_DISTRIBUTIONS_ALL Purchase order distributions

PO_HEADERS_ALL Document headers (for purchase orders, purchase agreements, quotations, RFQs)

PO_INTERFACE_ERRORS Requisition import interface errors

PO_LINES_ALL Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)

PO_LINE_LOCATIONS_ALL Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)

PO_REQUISITIONS_INTERFACE_ALL Requisition Import interface table

PO_REQUISITION_HEADERS_ALL Requisition headers

PO_REQUISITION_LINES_ALL Requisition lines

PO_REQ_DISTRIBUTIONS_ALL Requisition distributions

QP_LIST_HEADERS_B QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.

RA_BATCH_SOURCES_ALL Sources of invoice, credit memo and commitments

RA_CUSTOMER_TRX_LINES_ALL Invoice, debit memo, chargeback, credit memo and commitment lines

RA_CUST_TRX_TYPES_ALL Transaction type for invoices, commitments and credit memos

RA_RULES Invoicing and accounting rules

RA_SALESREPS_ALL Information about salespeople

RA_TERMS_B Payment Term information

RA_TERMS_TL Multi–lingual support (MLS) for Payment Terms

RCV_SHIPMENT_LINES Receiving shipment line information

WF_ITEM_TYPES Item type definition

WSH_FREIGHT_COSTS

WSH_NEW_DELIVERIES

Pricing

QP_ATTRIBUTE_DEFNS QP_ATTRIBUTE_DEFNS is the table on which the Qualifier

and Pricing Attribute Descriptive Flexfields are based. It is used for the entity and attribute definiton in attribute sourcing.

QP_COUPONS QP_COUPONS stores any Coupons which have been issued.

QP_EVENT_PHASES QP_EVENT_PHASES stores the mapping between pricing events and pricing phases.

QP_LIST_HEADERS_B QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount

QP_LIST_HEADERS_TL QP_LIST_HEADERS_TL stores the translatable columns, name and description of the list, in each of the available languages in the database.

QP_LIST_LINES QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. QP_PRICE_FORMULAS_B QP_PRICE_FORMULAS_B stores the pricing formula header information.

QP_PRICE_FORMULAS_TL This table stores the translatable columns, name & description of the pricing formulas, in each of the available languages in the database.

QP_PRICE_FORMULA_LINES QP_PRICE_FORMULA_LINES stores each component that makes up the formula.

QP_PRICE_REQ_SOURCES QP_PRICE_REQ_SOURCES stores the mapping between Pricing Request Types and Source Systems.

QP_PRICING_ATTRIBUTES QP_PRICING_ATTRIBUTES stores product information and pricing attributes.

QP_PRICING_PHASES QP_PRICING_PHASES stores all pricing phases.

QP_QUALIFIERS QP_QUALIFIERS stores qualifier attribute information.

QP_QUALIFIER_RULES QP_QUALIFIER_RULES stores the header information for all qualifier rules

QP_RLTD_MODIFIERS QP_RLTD_MODIFIERS stores the relationship between modifier lines. QP_UPGRADE_ERRORS QP_UPGRADE_ERRORS holds details of the errors which occured in upgrading pricing data.

RA_RULES Invoicing and accounting rules

RA_SALESREPS_ALL Information about salespeople

RA_TERMS_B Payment Term information