Oracle Fusion · Data dictionary
DOO_FULFILL_LINES_ALL
SharedUsed in 17 subject areas93 reporting columns
Order Management (DOO), line table, one row per line item under the header.
Likely primary key: FULFILL_HEADER_ID, FULFILL_LINE_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): HEADER_ID → DOO_HEADERS_ALL · INVENTORY_ITEM_ID → INV_LICENSE_PLATE_NUMBERS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTUAL_COMPLETION_DATE | ● | Actual completion date. | |
| ACTUAL_SHIP_DATE | ● | Actual shipment date. | |
| ASSET_GROUP_NUMBER | ● | Asset group number. | |
| ASSET_TRACKED_FLAG | ● | Indicator (Y/N) for the asset tracked. | |
| BILLING_SET_ID | ● | Identifier for the billing set. | |
| BILLING_SET_NAME | ● | Name of the billing set. | |
| BILL_TO_SITE_USE_ID | ● | Identifier for the bill to site use. | |
| CANCELED_FLAG | ● | Indicator (Y/N) for the canceled. | |
| CANCELED_QTY | ● | Canceled quantity. | |
| CANCEL_BACKORDERS_FLAG | ● | Indicator (Y/N) for the cancel backorders. | |
| CANCEL_REASON_CODE | ● | Code identifying the cancel reason. | |
| CATEGORY_CODE | ● | Code identifying the category. | |
| CONFIG_ITEM_VERSION | ● | Config item version. | |
| CONTRACT_END_DATE | ● | Contract end date. | |
| CONTRACT_START_DATE | ● | Contract start date. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CUSTOMER_PO_LINE_NUMBER | ● | Customer purchase order line number. | |
| CUSTOMER_PO_NUMBER | ● | Customer purchase order number. | |
| DEMAND_CLASS_CODE | ● | Code identifying the demand class. | |
| DEMAND_SOURCE_LINE_REFERENCE | ● | Demand source line reference. | |
| DRAFT_SCHEDULED_FLAG | ● | Indicator (Y/N) for the draft scheduled. | |
| EARLIEST_ACCEPTABLE_SHIP_DATE | ● | Earliest acceptable shipment date. | |
| END_CREDIT_METHOD_CODE | ● | Code identifying the end credit method. | |
| END_DATE | ● | End date. | |
| END_REASON_CODE | ● | Code identifying the end reason. | |
| ENFORCE_SINGLE_SHIPMENT_FLAG | ● | Indicator (Y/N) for the enforce single shipment. | |
| EXEMPTION_CERTIFICATE_NUMBER | ● | Exemption certificate number. | |
| EXTERNAL_PRICE_BOOK_NAME | ● | Name of the external price book. | |
| FULFILLED_QTY | ● | Fulfilled quantity. | |
| FULFILLMENT_DATE | ● | Fulfillment date. | |
| FULFILLMENT_SPLIT_REF_ID | ● | Identifier for the fulfillment split reference. | |
| FULFILL_HEADER_ID | PK? | ○ | Identifier for the fulfill header. |
| FULFILL_LINE_ID | PK? | ● | Identifier for the fulfill line. |
| FULFILL_LINE_NUMBER | ● | Fulfill line number. | |
| FULFILL_TOLERANCE_ABOVE | ● | Fulfill tolerance above. | |
| FULFILL_TOLERANCE_BELOW | ● | Fulfill tolerance below. | |
| HEADER_ID | ● | Identifier for the header. | |
| INVENTORY_INTERFACED_FLAG | ● | Indicator (Y/N) for the inventory interfaced. | |
| INVENTORY_ITEM_ID | ● | Identifier for the inventory item. | |
| INVENTORY_TRANSACTION_FLAG | ● | Indicator (Y/N) for the inventory transaction. | |
| INVOICE_INTERFACE_STATUS | ● | Status of the invoice interface. | |
| ITEM_SUB_TYPE_CODE | ● | Code identifying the item sub type. | |
| ITEM_TYPE_CODE | ● | Code identifying the item type. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LATEST_ACCEPTABLE_ARRIVAL_DATE | ● | Latest acceptable arrival date. | |
| LATEST_ACCEPTABLE_SHIP_DATE | ● | Latest acceptable shipment date. | |
| LINE_ID | ● | Identifier for the line. | |
| LINE_TYPE_CODE | ● | Code identifying the line type. | |
| ONE_TIME_CONFIG_FLAG | ● | Indicator (Y/N) for the one time config. | |
| ON_HOLD | ● | On hold. | |
| OPEN_FLAG | ● | Indicator (Y/N) for the open. | |
| ORDERED_QTY | ● | Ordered quantity. | |
| ORDERED_UOM | ● | Ordered unit of measure. | |
| PACKING_INSTRUCTIONS | ● | Packing instructions. | |
| PARTIAL_SHIP_ALLOWED_FLAG | ● | Indicator (Y/N) for the partial shipment allowed. | |
| PRICE_USING_SEC_UOM_FLAG | ● | Indicator (Y/N) for the price using sec unit of measure. | |
| PROMISE_ARRIVAL_DATE | ● | Promise arrival date. | |
| PROMISE_SHIP_DATE | ● | Promise shipment date. | |
| PROMOTION_ITEM_FLAG | ● | Indicator (Y/N) for the promotion item. | |
| REQUEST_ARRIVAL_DATE | ● | Request arrival date. | |
| REQUEST_SHIP_DATE | ● | Request shipment date. | |
| RESERVABLE_FLAG | ● | Indicator (Y/N) for the reservable. | |
| RESERVED_QTY | ● | Reserved quantity. | |
| RETURN_REASON_CODE | ● | Code identifying the return reason. | |
| RMA_DELIVERED_QTY | ● | Rma delivered quantity. | |
| ROOT_PARENT_FULFILL_LINE_ID | ● | Identifier for the root parent fulfill line. | |
| SALES_PRODUCT_TYPE_CODE | ● | Code identifying the sales product type. | |
| SCHEDULE_ARRIVAL_DATE | ● | Schedule arrival date. | |
| SCHEDULE_SHIP_DATE | ● | Schedule shipment date. | |
| SCHEDULING_REASON_CODE | ● | Code identifying the scheduling reason. | |
| SECONDARY_FULFILLED_QTY | ● | Secondary fulfilled quantity. | |
| SECONDARY_ORDERED_QTY | ● | Secondary ordered quantity. | |
| SECONDARY_RMA_DELIVERED_QTY | ● | Secondary rma delivered quantity. | |
| SECONDARY_SHIPPED_QTY | ● | Secondary shipped quantity. | |
| SECONDARY_UOM | ● | Secondary unit of measure. | |
| SERVICE_CANCEL_DATE | ● | Service cancel date. | |
| SERVICE_DURATION | ● | Service duration. | |
| SERVICE_DURATION_PERIOD_CODE | ● | Code identifying the service duration period. | |
| SHIPPABLE_FLAG | ● | Indicator (Y/N) for the shippable. | |
| SHIPPED_QTY | ● | Shipped quantity. | |
| SHIPPING_INSTRUCTIONS | ● | Shipping instructions. | |
| SHIP_CLASS_OF_SERVICE | ● | Shipment class of service. | |
| SHIP_MODE_OF_TRANSPORT | ● | Shipment mode of transport. | |
| SHIP_SET_NAME | ● | Name of the shipment set. | |
| SOURCE_LINE_NUMBER | ● | Source line number. | |
| SOURCE_ORDER_NUMBER | ● | Source order number. | |
| STATUS_CODE | ● | Code identifying the status. | |
| SUBSCRIPTION_INTERFACED_FLAG | ● | Indicator (Y/N) for the subscription interfaced. | |
| SUPPLIER_ID | ● | Identifier for the supplier. | |
| TAX_EXEMPT_FLAG | ● | Indicator (Y/N) for the tax exempt. | |
| UNIT_LIST_PRICE | ● | Unit list price. | |
| UNIT_SELLING_PRICE | ● | Unit selling price. | |
| UNREFERENCED_RETURN_FLAG | ● | Indicator (Y/N) for the unreferenced return. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Costing - Cost Accounting Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Distributed Order Orchestration - Order Headers Real Time
- Distributed Order Orchestration - Order Holds Real Time
- Distributed Order Orchestration - Order Lines Real Time
- Distributed Order Orchestration - Price Adjustments Real Time
- Distributed Order Orchestration - Process Instances Real Time
- Fiscal Document Capture Transactions Real Time
- Fiscal Document Holds Real Time
- Fiscal Document Item Deliveries Real Time
- Inventory - Inventory Transfer Order Real Time
- Inventory - Kanban Activity Real Time
- Manufacturing - Work Order Performance Real Time
- Manufacturing - Workstation Supervision Real Time
- Shipping Real Time
- Supply Chain Financial Orchestration Real Time
Need the extract + dbt staging for DOO_FULFILL_LINES_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table