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 JDBC Driver for Oracle Fusion Cloud SCM Views
| Name | Description |
| B2bApplicationPartners | Provides details of cross-referenced entities, such as customers or suppliers, involved in B2B message processing in Oracle Fusion applications. |
| B2bApplicationPartnersdocuments | Retrieves documents associated with application partners for B2B message processing, linking Oracle Fusion applications and trading partners. |
| B2bMessageTransactions | Manages B2B messages exchanged between Oracle Fusion applications and trading partners using the Collaboration Messaging Framework. |
| B2bMessageTransactionsdeliveryAttempts | Tracks reprocessed messages that failed or encountered errors during delivery attempts in the Collaboration Messaging Framework. |
| B2bMessageTransactionsreceiptConfirmations | Captures confirmation messages from trading partners indicating successful receipt of outbound business documents. |
| B2bTradingPartners | Details external entities, such as customers and suppliers, involved in B2B message exchanges within Oracle Fusion applications. |
| B2bTradingPartnersb2bServiceProviders | Provides information about external service providers that facilitate message processing for trading partners. |
| B2bTradingPartnersconfirmationCodes | Maps status codes between trading partners and Oracle's Collaboration Messaging Framework for message processing. |
| B2bTradingPartnersdeliveryMethods | Specifies communication methods between the Collaboration Messaging Framework and trading partners for message exchange. |
| B2bTradingPartnersdocuments | Manages documents exchanged with trading partners for B2B message processing. |
| B2bTradingPartnersdocumentsmessageProcessingRules | Defines message processing rules applied to documents exchanged with trading partners. |
| B2bTradingPartnersinboundCollaborationMessages | Details inbound messages received from trading partners by the Collaboration Messaging Framework. |
| B2bTradingPartnersinboundCollaborationMessagesdomainValueMaps | Manages domain value mappings for inbound messages to ensure proper processing and integration. |
| B2bTradingPartnersinboundCollaborationMessagesmessageProcessingRules | Lists rules applied during processing of inbound messages from trading partners. |
| B2bTradingPartnersoutboundCollaborationMessages | Provides details of outbound messages sent to trading partners from the Collaboration Messaging Framework. |
| B2bTradingPartnersoutboundCollaborationMessagesdomainValueMaps | Manages domain value mappings for outbound message processing. |
| B2bTradingPartnersoutboundCollaborationMessagesmessageProcessingRules | Defines processing rules for outbound messages sent to trading partners. |
| Carriers | Manages carrier entities used for shipping, including shipping methods, contacts, and tracking rules. |
| Carrierscontacts | Stores contact information associated with carriers. |
| CarriersDFF | Maintains descriptive flexfields for carrier entities to support custom attributes. |
| CarriersinboundTrackingRules | Defines tracking rules for shipments managed by carriers, including web service configurations. |
| CarriersinboundTrackingRulesorganizationAssociations | Links tracking rules to inventory organizations authorized to use them. |
| CarriersinboundTrackingRulesparameters | Stores unique parameters required by carrier web services for shipment tracking. |
| CarriersshippingMethods | Defines shipping methods, including transport modes and service levels, offered by carriers. |
| CarriersshippingMethodsDFF | Maintains descriptive flexfields for shipping methods to allow custom configurations. |
| CarriersshippingMethodsorganizationAssociations | Associates shipping methods with inventory organizations authorized to use them. |
| Finders | Lists available finders and their attributes for querying views in Oracle Fusion applications. |
| FlexFndDffDescriptiveFlexfieldContexts | Provides API endpoints to retrieve or query descriptive flexfield contexts. |
| FlexFndPvsCharacterIdCharacterValues | Retrieves character-based values associated with flexfield segments for specific business objects. |
| FlexFndPvsCharacterValues | Manages character-based values for flexfield segments. |
| FlexFndPvsNumberIdCharacterValues | Manages numeric values associated with flexfield segments for specific business objects. |
| InventoryOrganizations | Manages subsets of organizations for logistics, manufacturing, or asset management purposes. |
| InventoryOrganizationsinvOrgParameters | Handles default values for transactions within specific inventory organizations. |
| InventoryOrganizationsinvOrgParametersorganizationParameterDFF | Maintains descriptive flexfields for inventory organization parameters. |
| InventoryOrganizationsplantParameters | Manages default parameters for plant-specific manufacturing or maintenance organizations. |
| ItemUnitOfMeasureConversions | Provides unit conversion details for items to facilitate accurate transaction reporting. |
| PackagingStrings | Manages packaging configurations associated with items for transaction processing. |
| ScheduleExceptions | Defines global schedule changes, such as holidays, applicable to assigned schedules. |
| Schedules | Manages schedules defining working and non-working times for various business objects. |
| SchedulesscheduleExceptionAssociations | Links schedule exceptions to specific schedules for broader applicability. |
| SchedulesscheduleWorkdayPatterns | Assigns workday patterns to schedules for consistent application. |
| Shifts | Defines shifts representing working and non-working times within schedules. |
| ShiftsshiftDetails | Breaks down shifts into detailed time segments for precise schedule management. |
| StandardLookupsLOV | Provides lists of standard lookup codes and their translated meanings for reference. |
| UnitOfMeasureClasses | Organizes units of measure into classes for streamlined management. |
| UnitOfMeasureClassesDFF | Maintains descriptive flexfields for unit of measure classes to allow additional attributes. |
| UnitOfMeasureClassesinterclassConversions | Provides interclass conversion rates for items, enabling accurate measurements between different unit of measure classes in Oracle SCM. |
| UnitsOfMeasure | Defines and manages the units of measure that can be used in transactions across applications, ensuring consistency and compatibility. |
| UnitsOfMeasureDFF | Manages descriptive flexfields for units of measure, enabling customization and extension of unit-specific details. |
| UnitsOfMeasureintraclassConversions | Manages intraclass conversion rates between units of measure and their base unit within the same class, providing more granular control over conversions. |
| WorkdayPatterns | Defines workday patterns by detailing shifts and active days, forming the foundation for scheduling and time management. |
| WorkdayPatternsworkdayPatternShifts | Lists shifts assigned to specific workday patterns, supporting detailed scheduling configurations. |