Results for “industry_attribute4”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The SO_LINE_ATTRIBUTES_INTERFACE table resides in the OE (Order Entry) schema and is classified as VALID in Oracle EBS 12.1.1 and 12.2.2. It stores additional attributes of imported order line information — the supplementary descriptive data that accompanies order lines as they are staged for import into Oracle Order Management through the Order Import concurrent program. Where the primary order line interface holds the core transactional fields, this table carries the extended attribute segments: industry-specific flexfields and global descriptive flexfields.
Functionally, the table is an open interface (staging) structure. Records are populated externally — by external systems, legacy migrations, or EDI/XML feeds — and then consumed by Order Import, which validates each row and moves it into the operational order line tables. It is not a transactional table used at runtime.
Under the heuristic Data Vault classification mined from its foreign key structure, the metadata identifies this object as standalone. As a modeling suggestion, this indicates it functions in isolation from the core hub-and-link web rather than acting as a conformed hub, link, or satellite. Its uniqueness is enforced through a defined interface key rather than through a referenced parent entity.
Key Information Stored
The table contains 52 documented columns, dominated by attribute and flexfield segments. The most significant columns are:
- ORIGINAL_SYSTEM_LINE_REFERENCE — the line-level identifier from the originating external system; the column most frequently searched in this context.
- ORIGINAL_SYSTEM_REFERENCE — the source-system header reference tying the imported line back to its origin document.
- ORDER_SOURCE_ID — identifies the order source (e.g., EDI, legacy, external application) governing the import record.
- OPERATION_CODE — indicates whether the interface row represents an insert or update operation.
- INTERFACE_STATUS and ERROR_FLAG — control and diagnostic fields indicating processing outcome and validation failures.
- INDUSTRY_CONTEXT — identifies the industry/vertical flexfield context applicable to the attribute set.
- INDUSTRY_ATTRIBUTE1 through INDUSTRY_ATTRIBUTE15 — the industry-specific descriptive flexfield segments.
- GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1 through GLOBAL_ATTRIBUTE20 — the global descriptive flexfield category and its twenty free-form segments.
Regarding the primary key: the heuristic model designates SO_LINE_ATTRIBUTES_INT_PK as the primary key. Notably, the documented primary key columns (ORIGINAL_SYSTEM_REFERENCE, ORDER_SOURCE_ID, ORIGINAL_SYSTEM_LINE_REFERENCE) are identical to those of unique index SO_LINE_ATTRIBUTES_INT_U1. There is therefore no distinct surrogate key separate from the business-key candidate; the natural interface identifier itself serves as the uniqueness constraint. Standard Who columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) and concurrent-program audit columns (REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID) are also present.
Common Use Cases and Queries
Typical scenarios include diagnosing failed Order Import runs, reconciling source-system lines against imported orders, and auditing flexfield payloads delivered by external feeds.
To locate an interface row by its originating line reference:
SELECT * FROM oe.so_line_attributes_interface WHERE original_system_line_reference = :line_ref;
To identify failed rows for reprocessing:
SELECT original_system_reference, original_system_line_reference, interface_status, error_flag FROM oe.so_line_attributes_interface WHERE error_flag = 'Y' OR interface_status = 'ERROR';
To inspect flexfield payloads delivered for a given source document:
SELECT original_system_line_reference, global_attribute_category, global_attribute1, global_attribute2 FROM oe.so_line_attributes_interface WHERE original_system_reference = :src_ref;
Reporting leans on joining this table to the main line interface via the composite key (ORIGINAL_SYSTEM_REFERENCE, ORDER_SOURCE_ID, ORIGINAL_SYSTEM_LINE_REFERENCE).
Related Objects
Because the metadata classifies the table as standalone, no foreign keys are documented against it; related objects are therefore identified by shared interface key columns and functional dependency. The most significant are:
- SO_LINES_INTERFACE — the primary order line staging table, joined on ORIGINAL_SYSTEM_REFERENCE, ORDER_SOURCE_ID, and ORIGINAL_SYSTEM_LINE_REFERENCE.
- SO_HEADERS_INTERFACE — the header-level staging table, joined on ORIGINAL_SYSTEM_REFERENCE and ORDER_SOURCE_ID.
- SO_ORDER_SOURCES — reference table resolving ORDER_SOURCE_ID.
- OE_ORDER_LINES_ALL — the destination operational table populated after successful import.
- OE_ORDER_HEADERS_ALL — header destination linked via the order identifier.
- FND_DESCR_FLEX_COLUMN_USAGES — flexfield context metadata for INDUSTRY_CONTEXT and GLOBAL_ATTRIBUTE_CATEGORY.
- Order Import concurrent program (ORDER IMPORT) — the processing engine that consumes and clears these interface rows.
- FND_REQUEST / FND_CONCURRENT_REQUESTS — audit linkage via REQUEST_ID.
-
Additional attributes of imported order line information
-
View: ASO_I_OE_ORDER_LINES_V 12.2.2
This view includes all columns from the Oracle Order Management order lines tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ASO module →
-
View: ECE_CDMO_LINE_V 12.2.2
This view extracts line informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Credit/Debit Memo Line View@rep:category BUSINESS_ENTITY AR_CREDIT_
APPS.ECE_CDMO_LINE_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore EC module →
-
View: OE_LINE_ACKS_V 12.1.1
Information about the acknowledgements for Order Lines
-
View: OE_LINE_ACKS_V 12.2.2
Information about the acknowledgements for Order Lines
-
Temporary Table to Store Brazilian Electronic Invoice Line Attributes during Invoice API process (1:1 extension to Receivables Invoice API PLSQL table for Line details
-
Stores Brazilian Electronic Invoice Line Attributes (1:1 extension to RA_CUSTOMER_TRX_LINES_ALL table
-
Additional attributes of order lines
-
Additional attributes of order lines
-
View: OE_CRM_ORDER_LINES_V 12.1.1
Compatible view provoded for CRM usage only. The view is based on oe_order_lines_all table.
APPS.OE_CRM_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ONT module →
-
View: OE_ORDER_LINES_HIST_V 12.1.1
APPS.OE_ORDER_LINES_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
Additional attributes of imported order line information
-
View: OE_CRM_ORDER_LINES_V 12.2.2
Compatible view provoded for CRM usage only. The view is based on oe_order_lines_all table.
APPS.OE_CRM_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ONT module →
-
View: ASO_I_OE_ORDER_LINES_V 12.1.1
This view includes all columns from the Oracle Order Management order lines tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ASO module →
-
View: OE_SCH_RSV_SET_LINES_V 12.2.2
View used by the new form for scheduling across orders with Reservation set information
APPS.OE_SCH_RSV_SET_LINES_V·↳ AR_LOOKUPS·↳ FND_GLOBAL·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_ORDER_LINES_V 12.2.2
View for Order Lines used in the Sales Order form.
APPS.OE_ORDER_LINES_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
View: ECE_CDMO_LINE_V 12.1.1
This view extracts line informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Credit/Debit Memo Line View@rep:category BUSINESS_ENTITY AR_CREDIT_
APPS.ECE_CDMO_LINE_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore EC module →
-
View: OE_BLKT_LINES_HIST_V 12.1.1
This view is used to get BSA history lines information, which is used in BSA organizer.
APPS.OE_BLKT_LINES_HIST_V·↳ MTL_GRADES·↳ MTL_PARAMETERS·↳ OE_AGREEMENTS_TL·Explore ONT module →
-
Contains the customer invoice line data to support the outbound Invoice (810/INVOIC) transaction.
-
Contains the customer invoice line data to support the outbound Invoice (810/INVOIC) transaction.
-
This table stores the item and item detail level information associated with customer planning, shipping, or production sequenced schedules. For production sequence schedules, the item represents the feature, not the configuration.
-
This is a multi-org table for sales order lines open interface.
-
Table to capture sales agreement lines history.
-
Table to capture sales agreement lines history.
-
OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.
-
View: OE_SCH_ORDER_LINES_V 12.2.2
APPS.OE_SCH_ORDER_LINES_V·↳ AR_LOOKUPS·↳ FND_GLOBAL·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_BLANKET_LINES_V 12.1.1
This view is used to get the BSA lines information, used in BSA entry UI.
APPS.OE_BLANKET_LINES_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
This view is used to get BSA line history information, and it is udes in BSA version comparison UI.
APPS.OE_BLANKET_LINES_HIST_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: OE_BLANKET_LINES_V 12.2.2
This view is used to get the BSA lines information, used in BSA entry UI.
APPS.OE_BLANKET_LINES_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: OE_ORDER_LINES_HIST_V 12.2.2
APPS.OE_ORDER_LINES_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
APPS.RLM_SCHEDULE_INTERFACE_LINES_V·↳ RLM_INTERFACE_HEADERS·↳ RLM_INTERFACE_HEADERS_ALL·↳ RLM_INTERFACE_LINES·Explore RLM module →
-
View: OE_SCH_RSV_SET_LINES_V 12.1.1
View used by the new form for scheduling across orders with Reservation set information
APPS.OE_SCH_RSV_SET_LINES_V·↳ AR_LOOKUPS·↳ FND_GLOBAL·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
This view is used to get BSA line history information, and it is udes in BSA version comparison UI.
APPS.OE_BLANKET_LINES_HIST_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: OE_SCH_ORDER_LINES_V 12.1.1
APPS.OE_SCH_ORDER_LINES_V·↳ AR_LOOKUPS·↳ FND_GLOBAL·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_AK_ORDER_LINES_V 12.1.1
APPS.OE_AK_ORDER_LINES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ OE_ORDER_LINES_ALL·Explore ONT module →
-
View: OE_AK_ORDER_LINES_V 12.2.2
APPS.OE_AK_ORDER_LINES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ OE_ORDER_LINES_ALL·Explore ONT module →
-
APPS.RLM_SCHEDULE_INTERFACE_LINES_V·↳ RLM_INTERFACE_HEADERS·↳ RLM_INTERFACE_HEADERS_ALL·↳ RLM_INTERFACE_LINES·Explore RLM module →
-
View: OE_ORDER_LINES_V 12.1.1
View for Order Lines used in the Sales Order form.
APPS.OE_ORDER_LINES_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
View: OE_BLKT_LINES_HIST_V 12.2.2
This view is used to get BSA history lines information, which is used in BSA organizer.
APPS.OE_BLKT_LINES_HIST_V·↳ MTL_GRADES·↳ MTL_PARAMETERS·↳ OE_AGREEMENTS_TL·Explore ONT module →
-
EDI Inbound Gateway feeds into this table which stores the item and item detail level information associated with customer planning, shipping, or production sequenced schedules.
-
Table to capture sales agreement Line details.(Attributes common between Sales Order and Sales Agreements).
-
Table to capture sales agreement Line details.(Attributes common between Sales Order and Sales Agreements).
-
This table stores information about the acknowledgements for Order Lines.
-
This table stores information about the acknowledgements for Order Lines.
-
This table stores the item and item detail level information associated with customer planning, shipping, or production sequenced schedules. For production sequence schedules, the item represents the feature, not the configuration.
-
Stores history of attribute change for Order Lines.
-
EDI Inbound Gateway feeds into this table which stores the item and item detail level information associated with customer planning, shipping, or production sequenced schedules.
-
OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.
-
Stores history of attribute change for Order Lines.
-
This is a multi-org table for sales order lines open interface.