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 Python Connector 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. |