|
Table Name
|
Description
|
|
OE_ACTIONS_IFACE_ALL
|
This is the open interface table for Order Management action
requests. User can populate this table with data to perform a variety of
actions such as booking, hold application and removal, automatic attachments,
fulfillment set application and removal, match and reserve for Configured
items, get ship method and freight rates (both individually and together),
and the linking and delinking of Configured items.
|
|
OE_ACTION_PRE_REQS
|
A temporary table used during the WF upgrade into R11i.
|
|
OE_ADJ_ATTRIB_EBS_LOG
|
Log table for the Euro conversion of OE_PRICE_ADJ_ATTRIBS. Only
the Euro Customer Conversion concurrent program uses this table.
|
|
OE_AK_GEN_OBJECTS_CFG
|
No longer used
|
|
OE_AK_OBJECTS_EXT
|
Extension tables to AK_OBJECTS. Used to store additional data
(ex. can the object be defaulted or constrained) for the
defaulting/constraints framework.
|
|
OE_AK_OBJ_ATTR_EXT
|
Extension table to AK Object Attributes. Used to store
additional data, (eg. can the attribute be defaulted /constrained, security /
clear dependent APIs) for the defaulting or constraints framework.
|
|
OE_AK_OBJ_WF_ITEMS
|
Extension table to AK Object Attributes that is used to store
additional data
|
|
OE_APPROVER_LISTS
|
This table will be used with the OM Approvers List setup form to
setup the approvers list
|
|
OE_APPROVER_LIST_MEMBERS
|
This table will be used to manage all the approvers in the
approvers list
|
|
OE_APPROVER_TRANSACTIONS
|
This table will be used to manage the runtime transaction level
approvals and its statuses.
|
|
OE_ATTACHMENT_OBJECT_REFS
|
No longer used
|
|
OE_ATTACHMENT_OBJECT_REFS_TL
|
No longer used
|
|
OE_ATTACHMENT_RULES
|
OE_ATTACHMENT_RULES stores the entity to which an attachment
rule should be applied.
|
|
OE_ATTACHMENT_RULE_ELEMENTS
|
OE_ATTACHMENT_RULE_ELEMENTS stores the attributes and attribute values
that make up the attachment rule.
|
|
OE_AUDIT_ATTR_HISTORY
|
Audit Trail History Table
|
|
OE_BLANKET_HEADERS_ALL
|
Table to capture sales agreement header details..
|
|
OE_BLANKET_HEADERS_EXT
|
Table to capture sales agreement header details, specific to
sales agreement functionality.
|
|
OE_BLANKET_HEADERS_HIST
|
Table to capture sales agreement header history. Primary for
storing revisions.
|
|
OE_BLANKET_LINES_ALL
|
Table to capture sales agreement Line details.(Attributes common
between Sales Order and Sales Agreements).
|
|
OE_BLANKET_LINES_EXT
|
Table to capture sales agreement line details specific to sales
agreement functionality.
|
|
OE_BLANKET_LINES_HIST
|
Table to capture sales agreement lines history.
|
|
OE_BLANKET_ORG_ASSIGN
|
Not in use
|
|
OE_CC_TEMP
|
ONT.OE_CC_TEMP is a global temporary table. The current session
is able see data that it placed in the table but other sessions cannot. Data
in the table is temporary. It has a data duration of SYS$SESSION. Data is
removed at the end of this period.
|
|
OE_CONC_REQUEST_IFACE
|
Interface table for the retrobilling concurrent program
|
|
OE_CONFIG_DETAILS_TMP
|
ONT.OE_CONFIG_DETAILS_TMP is a global temporary table. The
current session is able see data that it placed in the table but other
sessions cannot. Data in the table is temporary. It has a data duration of
SYS$TRANSACTION. Data is removed at the end of this period.
|
|
OE_CREDITS_IFACE_ALL
|
This is a multi-org table for sales order/line credits open
interface.
|
|
OE_CREDIT_BALANCES_ALL
|
Stores the current credit exposure data for each individual
customer and site with credit limits. Each customer(or site)'s credit limit
(including default limits) will have one row for each valid credit rule in
the system.
|
|
OE_CREDIT_CHECK_RULES
|
This table stores information about the credit check rules.
|
|
OE_CREDIT_SUMMARIES
|
This summary table is used to implement Pre-Calculated Credit
Exposure
|
|
OE_CUSTOMER_INFO_IFACE_ALL
|
Interface table to add new customer, its address and contact
info.
|
|
OE_CUSTOM_ACTIONS
|
This table stores the information about all the actions that are
assigned to a folder.
|
|
OE_CUST_ITEM_SETTINGS
|
OE_CUST_ITEM_SETTINGS stores the shipment and return tolerances
for customer-item, item-site and item combinations
|
|
OE_CUST_MERGES_GTT
|
ONT.OE_CUST_MERGES_GTT is a global temporary table. The current
session is able see data that it placed in the table but other sessions
cannot. Data in the table is temporary. It has a data duration of
SYS$TRANSACTION. Data is removed at the end of this period.
|
|
OE_CUST_TOTAL_AMTS_ALL
|
Stores the accumulated order value for a customer over three
periods.
|
|
OE_DEFAULT_ACTIONS
|
This table stores the information about all the actions that are
applicable to the Sales Order.
|
|
OE_DEF_ATTR_CONDNS
|
Associates the defaulting condtion, 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. The
defaulting rules for attributes on this entity can be associated with these
conditions.
|
|
OE_DEF_CONDITIONS_TL
|
OE_DEF_CONDITIONS_TL stores the translated columns for
defaulting conditions.
|
|
OE_DEF_CONDN_ELEMS
|
This table stores elements (columns and column values) that
makeup the defaulting condition identified by condition_id.
|
|
OE_DOC_SEQUENCE_AUDIT
|
OE_DOC_SEQUENCE_AUDIT is the table used by the FND module for
audit purposes when the sequences used to generate the order numbers are
created.
|
|
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_EM_INFORMATION_ALL
|
This table maintains tracking information for Order Import and
Electronic Messaging (EDI & XML).
|
|
OE_EVENT_ATTRIBUTES
|
This table stores order header and line attributes that trigger
repricing, when modified, at various pricing events.
|
|
OE_EXPOSURE_INTERFACE
|
This table contains Credit Exposure Data to be imported into
Oracle Order Management.
|
|
OE_EXP_INTERFACE_ERRORS
|
This table contains error messages for each row of exposure data
in the OE_EXPOSURE_INTERFACE table that failed validation.
|
|
OE_FLOW_STATUS_AIA_SYNC
|
Stores the information about which flow status code raises an
O2C business event.
|
|
OE_FOLDER_EXTENSIONS
|
This table stores the information about Folder Extensions.
Each row includes the name of the objects in the folders, user identifier,
folder identifier, information about the tabs and line detail regions that
are displayed for the folder.
|
|
OE_HEADERS_EBS_LOG
|
Log table for the Euro conversion of OE_ORDER_LINES_ALL. This
table is used only by the Euro Customer Conversion concurrent program.
|
|
OE_HEADERS_EXT_IFACE_ALL
|
|
|
OE_HEADERS_IFACE_ALL
|
This is a multi-org table for sales order headers open
interface.
|
|
OE_HEADER_ACKS
|
This is the acknowledgment table for Order Management sales
order headers. This table contains sales order header information and is
populated by both EDI and XML transactions when acknowledgments are required.
|
|
OE_HOLD_AUTHORIZATIONS
|
Stores information about who has the authority to apply and
release holds.
|
|
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_HOLD_SOURCES_ALL
|
This table stores information of the hold source criteria.
|
|
OE_INIT_CREDIT_SUMM_GTT
|
ONT.OE_INIT_CREDIT_SUMM_GTT is a global temporary table. The
current session is able see data that it placed in the table but other
sessions cannot. Data in the table is temporary. It has a data duration of
SYS$TRANSACTION. Data is removed at the end of this period.
|
|
OE_INIT_SUMM_TMP
|
ONT.OE_INIT_SUMM_TMP is a global temporary table. The current
session is able see data that it placed in the table but other sessions
cannot. Data in the table is temporary. It has a data duration of
SYS$TRANSACTION. Data is removed at the end of this period.
|
|
OE_INVOICE_NUMBERS
|
This table is used for generating invoice numbers based on the
delivery name.
|
|
OE_ITEMS_MV
|
This table stores accumulated order quantity and value for an
item of a customer over three periods.
|
|
OE_ITEM_CUST_VOLS_ALL
|
|
|
OE_ITEM_ORDERABILITY
|
This tables stores information about the general Availability of
the items.
|
|
OE_ITEM_ORDERABILITY_RULES
|
This tables stores information about the Availability Rules Set
for the items.
|
|
OE_LINES_EBS_LOG
|
Log table for the Euro conversion of OE_ORDER_LINES_ALL. This
table is used only by the Euro Customer Conversion concurrent program.
|
|
OE_LINES_EXT_IFACE_ALL
|
|
|
OE_LINES_IFACE_ALL
|
This is a multi-org table for sales order lines open interface.
This table stores order lines information that is imported from a feeder
system into Oracle Order Management using Order Import.
|
|
OE_LINE_ACKS
|
This table stores information about the acknowledgements for
Order Lines.
|
|
OE_LINE_SETS
|
This table stores information about Sets.
|
|
OE_LINE_SPLIT_DETAILS
|
This table stores information about all the lines getting split.
|
|
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
and serial numbers for return lines.
|
|
OE_LOT_SERIAL_NUMBERS
|
This table stores customer reported lot serial numbers for lot
and / or serial number controlled return lines.
|
|
OE_NOTES_OBJECT_REFS
|
No longer used
|
|
OE_NOTES_OBJECT_REFS_TL
|
No longer used
|
|
OE_NOTES_RULES
|
ONT.OE_ORDERORG_GTT is a global temporary table. The current
session is able see data that it placed in the table but other sessions
cannot. Data in the table is temporary. It has a data duration of
SYS$TRANSACTION. Data is removed at the end of this period.
|
|
OE_NOTES_RULE_ELEMENTS
|
OE_ORDER_HEADERS_ALL stores header information for orders in
Order Management.
|
|
OE_ORDERORG_GTT
|
|
|
OE_ORDER_HEADERS_ALL
|
|
|
OE_ORDER_HEADERS_ALL_EFC
|
OE_ORDER_HEADERS_ALL_EFC holds data in the original set of books
currency prior to the switch to a set of books in euro.
|
|
OE_ORDER_HEADERS_ALL_EXT_B
|
Base table to store user defined attributes of
oe_order_headers_all
|
|
OE_ORDER_HEADERS_ALL_EXT_TL
|
TL table to store user defined attributes of
oe_order_headers_all
|
|
OE_ORDER_HEADER_HISTORY
|
Stores history of attribute change for Order Headers
|
|
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
|
OE_ORDER_LINES_ALL stores information for all order lines in
Oracle Order Management.
|
|
OE_ORDER_LINES_ALL_EXT_B
|
Base table to store user defined attributes of
oe_order_lines_all
|
|
OE_ORDER_LINES_ALL_EXT_TL
|
TL table to store user defined attributes of oe_order_lines_all
|
|
OE_ORDER_LINES_HISTORY
|
Stores history of attribute change for Order Lines.
|
|
OE_ORDER_NUMBER_SOURCES
|
No longer used
|
|
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_PAYMENTS
|
It holds the commitment payment information.
|
|
OE_PAYMENTS_HISTORY
|
Table to store payment audit trail.
|
|
OE_PAYMENTS_IFACE_ALL
|
This table is used to store Payments data to be imported into
OE_PAYMENTS table. This table will be used by Order Import Program.
|
|
OE_PAYMENT_TYPES_ALL
|
Multiorg table to store different payment types for each
Operating Unit
|
|
OE_PAYMENT_TYPES_TL
|
This table stores the name and description for each payment type
in different languages
|
|
OE_PC_ASSIGNMENTS
|
This table stores the responsibilities that are constrained by
the constraint identified by constraint_id.
|
|
OE_PC_CONDITIONS
|
This table stores the conditions associated with the constraints
identified by constraint_id.
|
|
OE_PC_CONDITIONS_TL
|
This table stores the translated conditions associated with the
constraints identified by constraint_id.
|
|
OE_PC_CONSTRAINTS
|
This table stores the constraints that prevent
create/update/delete of order entities.
|
|
OE_PC_EXCLUSIONS
|
This table stores the responsibilities that are not constrained
by a particular constraint.
|
|
OE_PC_RSETS
|
This table store the constraint record sets and the constraint
conditions can be built to validate against any or all the records in this
record set.
|
|
OE_PC_RSETS_TL
|
OE_PC_RSETS_TL stores the translated columns for record sets for
constraints.
|
|
OE_PC_RSET_SEL_COLS
|
This table stores columns to be matched for a constraint record
set.
|
|
OE_PC_VALIDATION_PKGS
|
This table stores the names of the dynamically generated
constraints validation packages.
|
|
OE_PC_VTMPLTS
|
This table stores the constraint validation templates that are
used in constraint conditions.
|
|
OE_PC_VTMPLTS_TL
|
OE_PC_VTMPLTS_TL stores the translated columns for validation
templates for constraints.
|
|
OE_PC_VTMPLT_COLS
|
This table stores the attribute validation pairs for validation
templates that are based on column values.
|
|
OE_PRICE_ADJS_HISTORY
|
Stores history of attribute changes of Entity Price
|
|
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. The column automatic flag indicates if the
adjustment was applied automatically or manually. Manual discouts are created
with applied_Flag = Y.
|
|
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 to that corresponding price adjustment line qualified for.
|
|
OE_PRICE_ADJ_EBS_LOG
|
Log table for the Euro conversion of OE_PRICE_ADJUSTMENTS. This
table is used only by the Euro Customer Conversion concurrent program.
|
|
OE_PRICE_ATTRIB_EBS_LOG
|
Log table for the Euro conversion of OE_ORDER_PRICE_ATTRIBS.
This table is used only by the Euro Customer Conversion concurrent program.
|
|
OE_PRICE_ATTS_IFACE_ALL
|
This is a multi-org Interface table to populate
OE_ORDER_PRICE_ATTRIBS.
|
|
OE_PROCESSING_MSGS
|
This table stores the context information of the processing
messages that will be generated during Order Entry concurrent program
execution or UI process.
|
|
OE_PROCESSING_MSGS_TL
|
This table stores the processing messages which will be
generated during Order Entry concurrent program execution or UI process. This
is a multi-lingual table.
|
|
OE_PURGE_ORDERS
|
OE_PURGE_ORDERS stores the order details for orders included in
a purge set.
|
|
OE_PURGE_SETS
|
OE_PURGE_SETS stores purge set information.
|
|
OE_REASONS
|
Table to store change reasons for entities inserted into history
tables.
|
|
OE_RESERVATION_SETS
|
This table is to store header information of reservation sets.
|
|
OE_RESERVTNS_IFACE_ALL
|
This is a multi-org table for inventory reservations open
interface. This table stores reservation details that is imported from a
feeder system into Oracle Order Management using Order Import.
|
|
OE_RETROBILL_REQUESTS
|
This table identifies a retrobill request and information used
to initiate the retrobilling request.
|
|
OE_RSV_SET_DETAILS
|
This table is to store line information of reservation sets.
|
|
OE_SALES_CREDITS
|
This table stores information about sales credits.
|
|
OE_SALES_CREDIT_HISTORY
|
Stores history of attribute changes of Entity Sales Credits.
|
|
OE_SALES_CREDIT_TYPES
|
This table stores information about sales credit types.
|
|
OE_SCHEDULE_LINES_TEMP
|
ONT.OE_SCHEDULE_LINES_TEMP is a global temporary table. The
current session is able see data that it placed in the table but other
sessions cannot. Data in the table is temporary. It has a data duration of
SYS$TRANSACTION. Data is removed at the end of this period.
|
|
OE_SCH_ID_LIST_TMP
|
ONT.OE_SCH_ID_LIST_TMP is a global temporary table. The current
session is able see data that it placed in the table but other sessions
cannot. Data in the table is temporary. It has a data duration of
SYS$SESSION. Data is removed at the end of this period.
|
|
OE_SELECTED_ITEMS
|
Stores the inventory items selected by users in the Advance Item
Search Window.
|
|
OE_SETS
|
OE_SETS stores information on line sets.
|
|
OE_SETS_HISTORY
|
Stores history of Set information
|
|
OE_SYSTEM_PARAMETERS_ALL
|
This table is used for storing all system parameter information.
|
|
OE_SYSTEM_PARAMS_UPG
|
OE_SYSTEM_PARAMS_UPG is an intermediate table used during
upgrade to 11
|
|
OE_SYS_PARAMETERS_ALL
|
This is a multi-org table for OM parameter setup information.
This table stores parameter values for the parameters defined in parameter
definition table.
|
|
OE_SYS_PARAMETER_DEF_B
|
This table stores OM parameter name and description. This is a
multi-lingual table.
|
|
OE_SYS_PARAMETER_DEF_TL
|
This table stores information about the order and line
transaction types. This is a multi-org table.
|
|
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_TRXN_TEMP
|
ONT.OE_TRXN_TEMP is a global temporary table. The current
session is able see data that it placed in the table but other sessions
cannot. Data in the table is temporary. It has a data duration of
SYS$TRANSACTION. Data is removed at the end of this period.
|
|
OE_UI_QUERIES_TL
|
This table stores the user defined queries that can be
administered in the Sales Order UI.
|
|
OE_UI_QUERY_COLUMNS
|
This table stores the column values for the user defined queries
that are stored in OE_UI_QUERIES_TL table.
|
|
OE_UPGRADE_DISTRIBUTION
|
Stores the Slabs or from and to header ids for parallel upgrade
processing.
|
|
OE_UPGRADE_ERRORS
|
Stores Errors trapped while Upgrading
|
|
OE_UPGRADE_LOG
|
Upgrade Control Information.
|
|
OE_UPGRADE_PC_ATTR_MAP
|
Processing constraints upgrade mapping table.
|
|
OE_UPGRADE_PC_CONDNS
|
Stores the Conditions to be upgraded to 11i.
|
|
OE_UPGRADE_PC_SCOPE
|
Processing constraints upgrade table.
|
|
OE_UPGRADE_PC_TEMP
|
Processing constraints upgrade table.
|
|
OE_UPGRADE_WF_ACT_MAP
|
Wofkflow upgrade mapping table.
|
|
OE_UPGRADE_WF_HIST_TEMP
|
This table is used during OM upgrade for cycles to workflow
conversion
|
|
OE_UPGRADE_WF_OBS_CODES
|
This table stores the Action names and Result names which are
obsoleted in R11i.
|
|
OE_UPGRADE_WF_VLD_CYC
|
Temporary table used by OM upgrade for cycles to workflow
upgrade.
|
|
OE_UPGRADE_WSH_IFACE
|
Sales Order upgrade table - Shipping integration.
|
|
OE_WORKFLOW_ASSIGNMENTS
|
This table associates assignments to order types and line types.
|
|
ONT_DBI_CHANGE_LOG
|
Event notification for DBI
|
|
ONT_PRT_MARGIN_ANALYSIS
|
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
|
|
ONT_PRT_MARGIN_ANA_ERR
|
ONT_PRT_MARGIN_ANA_ERR contains primary key values of the
failing record while building the ONT_PRT_MARGIN_ANALYSIS table.
|
|
ONT_WF_SKIP_LOG
|
OM WorkFlow Activity Skip Log.
|
