Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Power BI Connector for Oracle Fusion Cloud SCM Views


Name	Description
DispatchListWorkOrderOperations	Manages operations in work order dispatch lists for assigned work areas and centers.
DispatchListWorkOrderOperationsWorkOrderOperationProductSerial	Tracks product serials for work order operations based on dispatch status.
Finders	Lists finder names and attributes for manufacturing views to streamline data retrieval.
FlexFndDffDescriptiveFlexfieldContexts	Offers API endpoints for accessing and managing descriptive flexfield contexts.
FlexFndPvsCharacterIdCharacterValues	Provides character-based flexfield configurations for manufacturing data.
FlexFndPvsCharacterValues	Contains values for character-based flexfield configurations in manufacturing.
FlexFndPvsNumberIdCharacterValues	Manages numeric flexfield configurations for manufacturing resources.
OperationStartStops	Tracks start and stop times for work order operations, including assembly serials.
ProcessWorkOrders	Manages detailed instructions for manufacturing processes, including outputs, inputs, and resources.
ProcessWorkOrdersOperation	Handles operations for processing manufacturing work orders, tracking resources and outputs.
ProcessWorkOrdersProcessWorkOrderAttachment	Manages attachments related to manufacturing work orders for documentation and reference.
ProcessWorkOrdersProcessWorkOrderDFF	Manages detailed and customizable descriptive flexfields associated with process work orders, allowing tailored data tracking.
ProcessWorkOrdersProcessWorkOrderMaterial	Tracks and manages materials consumed during operations to process work orders, ensuring accurate material planning.
ProcessWorkOrdersProcessWorkOrderMaterialMaterialAttachment	Handles attachments related to input materials, providing additional context and documentation for material usage.
ProcessWorkOrdersProcessWorkOrderMaterialMaterialDFF	Enables detailed tracking of input materials with customizable descriptive flexfields for enhanced operational insights.
ProcessWorkOrdersProcessWorkOrderMaterialMaterialExceptionCount	Tracks the number of exceptions encountered for input materials during operations, facilitating issue resolution and quality control.
ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial	Identifies and manages substitute materials used during work order operations, ensuring flexibility in material sourcing.
ProcessWorkOrdersProcessWorkOrderOutput	Oversees the outputs generated by operations within a process work order, supporting production tracking.
ProcessWorkOrdersProcessWorkOrderOutputOutputAttachment	Manages attachments linked to operation outputs, providing documentation for output-related processes.
ProcessWorkOrdersProcessWorkOrderOutputOutputDFF	Customizes tracking for output materials using descriptive flexfields, offering detailed insights into operational outcomes.
ProcessWorkOrdersProcessWorkOrderReservation	Manages demand documents to reserve output quantities for work orders, optimizing inventory allocation.
ProcessWorkOrdersProcessWorkOrderResource	Tracks resources utilized during work order operations, including labor and equipment.
ProcessWorkOrdersProcessWorkOrderResourceResourceAttachment	Manages documentation and attachments related to resources used in operations, improving resource transparency.
ProcessWorkOrdersProcessWorkOrderResourceResourceDFF	Enhances resource tracking through customizable descriptive flexfields, supporting tailored data management.
ProcessWorkOrdersProcessWorkOrderResourceResourceExceptionCount	Records exceptions encountered for resources during operations, aiding in operational troubleshooting.
ProcessWorkOrdersProcessWorkOrderResourceResourceInstance	Manages individual instances of resources, including specific labor or equipment, for precise operational control.
ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF	Offers detailed customization for resource instances using descriptive flexfields, improving instance-specific insights.
ProcessWorkOrdersProcessWorkOrderStatusHistory	Tracks the status history of work orders, providing visibility into work order progress and changes.
ProcessWorkOrdersProjectDetailsDFF	Customizes project costing attributes for work orders using descriptive flexfields, supporting advanced project tracking.
ProductionResources	Manages production resources such as labor, equipment, and tools within a manufacturing plant, enabling efficient resource allocation.
ProductionResourcesEquipmentInstance	Tracks individual instances of equipment resources, supporting detailed equipment management.
ProductionResourcesEquipmentInstanceEquipmentInstanceDFF	Customizes tracking for equipment instances with descriptive flexfields, enabling detailed equipment insights.
ProductionResourcesLaborInstance	Manages individual instances of labor resources, facilitating labor allocation and tracking.
ProductionResourcesLaborInstanceLaborInstanceDFF	Customizes labor resource tracking with descriptive flexfields, offering detailed labor insights.
ProductionResourcesResourceDFF	Enables detailed customization of production resource tracking through descriptive flexfields.
StandardLookupsLOV	Queries and manages standard lookup codes, providing translations and references for shared data.
WorkAreas	Defines and manages physical work areas within a manufacturing plant, essential for production planning.
WorkAreasWorkAreaDFF	Tracks descriptive flexfields associated with work areas, enabling tailored area-specific data management.
WorkCenters	Manages work centers within work areas, tracking resources and capacities for efficient production planning.
WorkCentersWorkCenterDFF	Enables customization of work center tracking using descriptive flexfields for better resource insights.
WorkCentersWorkCenterResource	Tracks resources allocated to work centers, supporting detailed resource planning and allocation.
WorkCentersWorkCenterResourceWorkCenterResourceShift	Manages shifts assigned to work center resources, streamlining resource scheduling.
WorkCentersWorkCenterSubinventory	Manages subinventories linked to work centers, ensuring efficient inventory management.
WorkDefinitionNames	Defines methods for manufacturing products through work definitions, enabling standardized production planning.
WorkDefinitionNamestranslations	Provides translations for work definition names and descriptions, supporting multi-language usability.
WorkOrders	Manages discrete work orders detailing item, quantity, operations, resources, and timelines for discrete manufacturing.
WorkOrdersMetrics	Tracks key metrics related to work orders, providing performance insights for the manufacturing plant.
WorkOrdersProjectDetailsDFF	Tracks project costing attributes for work orders using customizable descriptive flexfields.
WorkOrderStatuses	Manages statuses of work orders, providing insights into the current state of each order.
WorkOrdersWorkOrderActiveOperation	Tracks active operations in work orders, ensuring visibility into ongoing processes.
WorkOrdersWorkOrderAssemblyComponent	Manages assemblies issued as components to work orders, supporting rework and component tracking.
WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot	Tracks lot information for assemblies issued to rework work orders, aiding in lot traceability.
WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial	Tracks serials for assemblies issued to rework work orders, supporting detailed serial traceability.
WorkOrdersWorkOrderAttachment	Manages documents attached to work orders, providing comprehensive documentation for production.
WorkOrdersWorkOrderDFF	Customizes tracking of work orders using descriptive flexfields, offering detailed order insights.
WorkOrdersWorkOrderExceptionCount	Tracks the count of exceptions for work orders, supporting issue identification and resolution.
WorkOrdersWorkOrderLotNumber	Manages product lots linked to work orders, enabling detailed lot tracking and traceability.
WorkOrdersWorkOrderMaterial	Tracks materials utilized in operations for work orders, supporting material planning and accountability.
WorkOrdersWorkOrderMaterialWorkOrderMaterialExceptionCount	Tracks exceptions related to materials during operations, aiding in quality management.
WorkOrdersWorkOrderMaterialWorkOrderOperationMaterialAttachment	Stores documents attached to materials processed by a specific work order operation, enabling better tracking and reference for operational documents.
WorkOrdersWorkOrderMaterialWorkOrderOperationMaterialDFF	Stores descriptive flexfields for materials processed during work order operations, offering customizable details for material tracking.
WorkOrdersWorkOrderMaterialWorkOrderOperationSubstituteMaterial	Tracks substitute materials used in place of primary materials during work order operations for flexibility and efficiency.
WorkOrdersWorkOrderOperation	Manages the sequence of operations required to process a work order, outlining steps for efficient execution.
WorkOrdersWorkOrderOperationWorkOrderOperationAttachment	Holds documents attached to specific work order operations, facilitating documentation and compliance.
WorkOrdersWorkOrderOperationWorkOrderOperationDFF	Contains descriptive flexfields for work order operations, allowing customization of operation details.
WorkOrdersWorkOrderOperationWorkOrderOperationExceptionCount	Tracks the count of exceptions that occurred during specific work order operations for analysis and troubleshooting.
WorkOrdersWorkOrderOperationWorkOrderOperationMaterial	Manages materials required for work order operations, including material specifications and quantities.
WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount	Records exceptions related to materials during operations, aiding in operational quality assurance.
WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialAttachment	Stores documents attached to materials processed by work order operations, ensuring proper documentation.
WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF	Contains customizable flexfields for detailed information about materials processed in work order operations.
WorkOrdersWorkOrderOperationWorkOrderOperationResource	Tracks resources required for work order operations, such as labor and equipment, ensuring resource planning.
WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceAttachment	Stores attachments related to resources used in work order operations for enhanced resource tracking.
WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF	Contains descriptive flexfields for resources, providing detailed resource attributes used in operations.
WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance	Manages instances of equipment or labor resources utilized in specific work order operations.
WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount	Tracks exceptions related to resources during work order operations, supporting operational diagnostics.
WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber	Manages serial numbers for assemblies processed during work order operations, enabling precise tracking.
WorkOrdersWorkOrderReservation	Handles demand reservations for work order output, ensuring proper allocation and fulfillment.
WorkOrdersWorkOrderResource	Manages resources such as labor and machinery required to execute work orders effectively.
WorkOrdersWorkOrderResourceWorkOrderOperationResourceAttachment	Stores documents attached to resources used in work order operations for improved resource documentation.
WorkOrdersWorkOrderResourceWorkOrderOperationResourceDFF	Contains detailed descriptive flexfields for resources, enhancing resource information management.
WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance	Tracks individual instances of resources, such as specific equipment or labor, used in operations.
WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstanceWOOperationResourceInstanceDFF	Stores customizable descriptive flexfields for detailed information about resource instances in operations.
WorkOrdersWorkOrderResourceWorkOrderResourceExceptionCount	Tracks exceptions related to resources during operations to identify and address resource-related issues.
WorkOrdersWorkOrderSerialNumber	Manages serial numbers for assemblies referenced by work orders, ensuring traceability and quality control.
WorkOrdersWorkOrderStatus	Tracks the status of work orders, providing visibility into their progression and completion.
WorkOrdersWorkOrderStatusHistory	Records the status history of work orders for audit and tracking purposes.