ONT Tables (158)

ONT - Order Management — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
OE_ACTIONS_IFACE_ALL	47	This is a multi-org table for sales order actions holds, booking etc. open interface.
OE_ACTION_PRE_REQS	11	A temporary table used during the WF upgrade into R11i.
OE_ADJ_ATTRIB_EBS_LOG	16	Log table for the Euro conversion of OE_PRICE_ADJ_ATTRIBS. This table is used only by the Euro Customer Conversion concurrent program.
OE_AK_GEN_OBJECTS_CFG	4	No longer used
OE_AK_OBJECTS_EXT	36	Extension tables to AK_OBJECTS which is used to store additional data
OE_AK_OBJ_ATTR_EXT	43	Extension table to AK Object Attributes that is used to store additional data
OE_AK_OBJ_WF_ITEMS	14	Extension table to AK Object Attributes that is used to store additional data
OE_APPROVER_LISTS	28	This table will be used with the OM Approvers List setup form to setup the approver Lists.
OE_APPROVER_LIST_MEMBERS	25	This table will be used to manage all the approvers in approver lists.
OE_APPROVER_TRANSACTIONS	11	This table will be used to manage the runtime transaction level approvals and its statuses.
OE_ATTACHMENT_OBJECT_REFS	10	No longer used
OE_ATTACHMENT_OBJECT_REFS_TL	6	No longer used
OE_ATTACHMENT_RULES	25	OE_ATTACHMENT_RULES stores the entity to which an attachment rule should be applied.
OE_ATTACHMENT_RULE_ELEMENTS	28	OE_ATTACHMENT_RULE_ELEMENTS stores the attributes and attribute values that make up the attachment rule.
OE_AUDIT_ATTR_HISTORY	18	Audit Trail History Table
OE_BLANKET_HEADERS_ALL	167	Table to capture sales agreement header details..
OE_BLANKET_HEADERS_EXT	26	Table to capture sales agreement header details, specific to sales agreement functionality
OE_BLANKET_HEADERS_HIST	198	Table to capture sales agreement header history. Primary for storing revisions.
OE_BLANKET_LINES_ALL	327	Table to capture sales agreement Line details.(Attributes common between Sales Order and Sales Agreements).
OE_BLANKET_LINES_EXT	32	Table to capture sales agreement line details specific to sales agreement functionality.
OE_BLANKET_LINES_HIST	372	Table to capture sales agreement lines history.
OE_BLANKET_ORG_ASSIGN	2	Not in use,
OE_CC_TEMP	3
OE_CONC_REQUEST_IFACE	13	Interface table for the retrobilling concurrent program
OE_CONFIG_DETAILS_TMP	30
OE_CREDITS_IFACE_ALL	50	This is a multi-org table for sales order/line credits open interface.
OE_CREDIT_BALANCES_ALL	36	Stores the current credit exposure data for each individual customer and site with credit limits. Each customer(or site)'s credit limit (in
OE_CREDIT_CHECK_RULES	49	This table stores information about the credit check rules.
OE_CREDIT_SUMMARIES	19	This summary table is used to implement Pre-Calculated Credit Exposure.
OE_CUSTOMER_INFO_IFACE_ALL	100	Interface table to add new customer, its address and contact info.
OE_CUSTOM_ACTIONS	15	This table stores the information about all the actions that are assigned to a folder.
OE_CUST_ITEM_SETTINGS	30	OE_CUST_ITEM_SETTINGS stores the shipment and return tolerances for customer-item, item-site and item combinations
OE_CUST_MERGES_GTT	5
OE_CUST_TOTAL_AMTS_ALL	14	Stores the accumulated order value for a customer over three periods.
OE_DEFAULT_ACTIONS	11	This table stores the information about all the actions that are applicable to the Sales Order.
OE_DEF_ATTR_CONDNS	29	Associates the defaulting condtion, defined at the entity level , to a specific attribute.
OE_DEF_ATTR_DEF_RULES	40	Defaulting rules for an attribute for a defaulting condition.
OE_DEF_CONDITIONS	26	This table stores defaulting conditions for an entity
OE_DEF_CONDITIONS_TL	11	OE_DEF_CONDITIONS_TL stores the translated columns for defaulting conditions.
OE_DEF_CONDN_ELEMS	29	This table stores elements (columns and column values) that makeup the defaulting condition identified by condition_id.
OE_DOC_SEQUENCE_AUDIT	5	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 creat
OE_DROP_SHIP_SOURCES	17	This table stores relationship between order lines in oe_order_lines_all table and associated oracle purchasing requisitions in PO_REQUISIT
OE_EM_INFORMATION_ALL	27	This table maintains tracking information for Order Import and Electronic Messaging (EDI & XML)
OE_EVENT_ATTRIBUTES	4	This table stores order header and line attributes thattrigger repricing, when modified, at various pricing events.
OE_EXPOSURE_INTERFACE	33	This table contains Credit Exposure Data to be imported into Oracle Order Management
OE_EXP_INTERFACE_ERRORS	14	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	9	Stores the information about which flow status code raises an O2C business event
OE_FOLDER_EXTENSIONS	25	This table stores the information about Folder Extensions.
OE_HEADERS_EBS_LOG	20	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	34
OE_HEADERS_IFACE_ALL	333	This is a multi-org table for sales order headers open interface.
OE_HEADER_ACKS	342	This tables stores information about the acknowledgements for Order Headers.
OE_HOLD_AUTHORIZATIONS	27	Stores information about who has the authority to apply and release holds.
OE_HOLD_DEFINITIONS	33	This table stores information about hold name and its validity period.
OE_HOLD_RELEASES	32	This tables stores information about all the holds that has been released.
OE_HOLD_SOURCES_ALL	36	This table stores information of the hold source criteria.
OE_INIT_CREDIT_SUMM_GTT	26
OE_INIT_SUMM_TMP	9
OE_INVOICE_NUMBERS	12	This table is used for generating invoice numbers based on the delivery name.
OE_ITEM_CUST_VOLS_ALL	19	This table stores accumulated order quantity and value for an item of a customer over three periods.
OE_ITEM_ORDERABILITY	11	This tables stores information about the general Availability of the items.
OE_ITEM_ORDERABILITY_RULES	39	This tables stores information about the Availability Rules Set for the items.
OE_LINES_EBS_LOG	22	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	36
OE_LINES_IFACE_ALL	478	This is a multi-org table for sales order lines open interface.
OE_LINE_ACKS	522	This table stores information about the acknowledgements for Order Lines.
OE_LINE_SETS	4	This table stores information about Sets.
OE_LINE_SPLIT_DETAILS	11	This table stores information about all the lines getting split.
OE_LOTSERIALS_IFACE_ALL	46	This is a multi-org table for return line lot serials open interface.
OE_LOTSERIAL_ACKS	49	This table stores information about the acknowledgements for lot and serial numbers for return lines.
OE_LOT_SERIAL_NUMBERS	33	This table stores customer reported lot serial numbers for lot and / or serial number controlled return lines.
OE_NOTES_OBJECT_REFS	10	No longer used
OE_NOTES_OBJECT_REFS_TL	6	No longer used
OE_NOTES_RULES	24	No longer used
OE_NOTES_RULE_ELEMENTS	26	No longer used
OE_ORDERORG_GTT	1
OE_ORDER_HEADERS_ALL	178	OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.
OE_ORDER_HEADERS_ALL_EFC	4	Archive for Euro Project
OE_ORDER_HEADERS_ALL_EXT_B	108	Base table to store user defined attributes of oe_order_headers_all
OE_ORDER_HEADERS_ALL_EXT_TL	55	TL table to store user defined attributes of oe_order_headers_all
OE_ORDER_HEADER_HISTORY	183	Stores history of attribute change for Order Headers
OE_ORDER_HOLDS_ALL	34	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	362	OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.
OE_ORDER_LINES_ALL_EXT_B	108	Base table to store user defined attributes of oe_order_lines_all
OE_ORDER_LINES_ALL_EXT_TL	55	TL table to store user defined attributes of oe_order_lines_all
OE_ORDER_LINES_HISTORY	375	Stores history of attribute change for Order Lines.
OE_ORDER_NUMBER_SOURCES	27	No longer used
OE_ORDER_PRICE_ATTRIBS	134	This table stores pricing attributes and asked for promotions, deals, and coupon number entered by the user.
OE_ORDER_SOURCES	13	Feeder System Names that create orders in Order Management tables.
OE_PAYMENTS	53	It holds the commitment payment information.
OE_PAYMENTS_HISTORY	53	Table to store payment audit trail.
OE_PAYMENTS_IFACE_ALL	63	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	34	Multiorg table to store different payment types for each Operating Unit
OE_PAYMENT_TYPES_TL	16	This table stores the name and description for each payment type in different languages
OE_PC_ASSIGNMENTS	27	This table stores the responsibilities that are constrained by the constraint identified by constraint_id.
OE_PC_CONDITIONS	34	This table stores the conditions associated with the constraints identified by constraint_id.
OE_PC_CONDITIONS_TL	10	This table stores the translated conditions associated with the constraints identified by constraint_id.
OE_PC_CONSTRAINTS	33	This table stores the constraints that prevent create/update/delete of order entities.
OE_PC_EXCLUSIONS	24	This table stores the responsibilities that are not constrained by a particular constraint.
OE_PC_RSETS	27	This table store the constraint record sets and the constraint conditions can be built to validate against any or all the records in this re
OE_PC_RSETS_TL	11	OE_PC_RSETS_TL stores the translated columns for record sets for constraints.
OE_PC_RSET_SEL_COLS	8	This table stores columns to be matched for a constraint record set.
OE_PC_VALIDATION_PKGS	12	This table stores the names of the dynamically generated constraints validation packages.
OE_PC_VTMPLTS	33	This table stores the constraint validation templates that are used in constraint conditions.
OE_PC_VTMPLTS_TL	11	OE_PC_VTMPLTS_TL stores the translated columns for validation templates for constraints.
OE_PC_VTMPLT_COLS	11	This table stores the attribute validation pairs for validation templates that are based on column values.
OE_PRICE_ADJS_HISTORY	113	Stores history of attribute changes of Entity Price
OE_PRICE_ADJS_IFACE_ALL	94	This is a multi-org open interface table for sales order/line price adjustments.
OE_PRICE_ADJUSTMENTS	106	This table is used to store price adjustments that have been applied to an order or a line. It is also used to store the freight and special
OE_PRICE_ADJ_ASSOCS	15	This table stores the association between order lines and price adjustments and also between price adjustments
OE_PRICE_ADJ_ATTRIBS	19	This table stores information on qualifiers and pricing attributes, which to that corresponding price adjustment line qualified for.
OE_PRICE_ADJ_EBS_LOG	21	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	15	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	144	This is a multi-org Interface table to populate OE_ORDER_PRICE_ATTRIBS.
OE_PROCESSING_MSGS	35	This table stores the context information of the processing messages that will be generated during Order Entry concurrent program execution
OE_PROCESSING_MSGS_TL	10	This table stores the processing messages which will be generated during Order Entry concurrent program execution or UI process. This is a m
OE_PURGE_ORDERS	22	OE_PURGE_ORDERS stores the order details for orders included in a purge set.
OE_PURGE_SETS	22	OE_PURGE_SETS stores purge set information.
OE_REASONS	35	Table to store change reasons for entities inserted into history tables.
OE_RESERVATION_SETS	13	Reservation Set header table
OE_RESERVTNS_IFACE_ALL	39	This is a multi-org table for inventory reservations open interface.
OE_RETROBILL_REQUESTS	34	Retrobill requests table.
OE_RSV_SET_DETAILS	24	Reservation Set detail table
OE_SALES_CREDITS	34	This table stores information about sales credits.
OE_SALES_CREDIT_HISTORY	45	Stores history of attribute changes of Entity Sales Credits
OE_SALES_CREDIT_TYPES	27	This table stores information about sales credit types.
OE_SCHEDULE_LINES_TEMP	2
OE_SCH_ID_LIST_TMP	1
OE_SELECTED_ITEMS	3	Stores the inventory items selected by users in the Advance Item Search Window.
OE_SETS	23	OE_SETS stores information on line sets.
OE_SETS_HISTORY	10	Stores history of Set information
OE_SYSTEM_PARAMETERS_ALL	34	This table is used for storing all system parameter information.
OE_SYSTEM_PARAMS_UPG	24	OE_SYSTEM_PARAMS_UPG is an intermediate table used during upgrade to 11
OE_SYS_PARAMETERS_ALL	24	OM parameter setup table
OE_SYS_PARAMETER_DEF_B	12	OM Parameter Definiton Table.
OE_SYS_PARAMETER_DEF_TL	11	OM Parameter Definition Translation table
OE_TRANSACTION_TYPES_ALL	73	This table stores information about the order and line transaction types
OE_TRANSACTION_TYPES_TL	13	This is a mult-lingual table for OE_TRANSACTION_TYPES_ALL table.
OE_TRXN_TEMP	13
OE_UI_QUERIES_TL	18	This table stores the user defined queries that can be administered in the Sales Order UI.
OE_UI_QUERY_COLUMNS	12	This table stores the column values for the user defined queries that are stored in OE_UI_QUERIES_TL table.
OE_UPGRADE_DISTRIBUTION	6	Stores the Slabs or from and to header ids for parallel upgrade processing.
OE_UPGRADE_ERRORS	8	Stores Errors trapped while Upgrading
OE_UPGRADE_LOG	14	Upgrade Control Information.
OE_UPGRADE_PC_ATTR_MAP	7	Processing constraints upgrade mapping table.
OE_UPGRADE_PC_CONDNS	9	Stores the Conditions to be upgraded to 11i.
OE_UPGRADE_PC_SCOPE	5	Processing constraints upgrade table.
OE_UPGRADE_PC_TEMP	9	Processing constraints upgrade table.
OE_UPGRADE_WF_ACT_MAP	13	Wofkflow upgrade mapping table.
OE_UPGRADE_WF_HIST_TEMP	3	This table is used during OM upgrade for cycles to workflow conversion
OE_UPGRADE_WF_OBS_CODES	2	This table stores the Action names and Result names which are obsoleted in R11i.
OE_UPGRADE_WF_VLD_CYC	2	Temporary table used by OM upgrade for cycles to workflow upgrade.
OE_UPGRADE_WSH_IFACE	55	Sales Order upgrade table - Shipping integration.
OE_WORKFLOW_ASSIGNMENTS	32	This table associates assignments to order types and line types.
ONT_DBI_CHANGE_LOG	5	Event notification for DBI
ONT_PRT_MARGIN_ANALYSIS	12	ONT_PRT_MARGIN_ANALYSIS contains margin analysis information grouped by customer, item, territory, and sales person for three different time
ONT_PRT_MARGIN_ANA_ERR	6	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	7	OM WorkFlow Activity Skip Log.