Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for Oracle SCM Views
| Name | Description |
| B2bApplicationPartners | The B2B Application Partners resource gets the details of the cross reference parties (entities) involved in business-to-business message processing. Within Oracle Fusion applications, there are different entities such as customer, supplier, and so on, but they all represent application partners from a business-to-business point of view. |
| B2bApplicationPartnersdocuments | The Application Partner Documents resource gets all the documents associated with the application partner that cross reference between fusion applications and trading partners for business-to-business message processing. |
| B2bLocationCodes | The B2B Location Codes resource manages the details of location codes and the bill to and ship to locations that are configured for a customer. |
| B2bMessageDefinitions | The B2B Message Definitions resource gets the details of a message definition. This resource is used to exchange messages with trading partners or fusion applications. |
| B2bMessageDefinitionsb2bLocationAssignments | The B2B Location Assignments resource gets the details of location assignments that are configured for a message definition. This resource is used to know the XPaths configured for the bill-to and ship-to locations. |
| B2bMessageTransactions | The B2B Message Transactions resource manages business-to-business messages processed from Oracle Fusion applications to trading partners and from trading partners to fusion application using Oracle Fusion Collaboration Messaging Framework. |
| B2bMessageTransactionsdeliveryAttempts | The Delivery Attempts resource gets the failed or error status message transactions reprocessed in Oracle Fusion Collaboration Messaging Framework. If the delivery attempt fails, the message information includes the error subtype and description. |
| B2bMessageTransactionsreceiptConfirmations | The Message Confirmations resource gets the confirm business object document received from the trading partner when the outbound message is set up for the confirm business object document in Oracle Fusion Collaboration Messaging Framework. |
| B2bServiceProviders | The B2B Service Providers resource gets only the relevant details of external parties that provide service to trading partners for message processing. This is a reference to the independent root resource B2B service providers. |
| B2bServiceProvidersdeliveryMethods | The Delivery Methods resource gets the details of mode of communication between Oracle Collaboration Messaging Framework Cloud and trading partners. |
| B2bServiceProvidersdocuments | The Trading Partner Documents resource gets all the documents associated with the trading partner that are exchanged for business-to-business message processing. |
| B2bServiceProvidersinboundCollaborationMessages | The Inbound Collaboration Messages resource gets the details of all the inbound messages that a trading partner sends to Oracle Collaboration Messaging Framework Cloud. |
| B2bServiceProvidersinboundCollaborationMessagesdomainValueMaps | The Domain Value Maps resource gets all the mappings associated with the trading partner that are implemented while processing a message. |
| B2bServiceProvidersoutboundCollaborationMessages | The Outbound Collaboration Messages resource gets the details of all the outbound messages that a trading partner receives from Oracle Collaboration Messaging Framework Cloud. |
| B2bServiceProvidersoutboundCollaborationMessagesdomainValueMaps | The Domain Value Maps resource gets all the mappings associated with the trading partner that are implemented while processing a message. |
| B2bTradingPartners | The B2B Trading Partners resource gets the details of the external parties (entities) involved in business-to-business message processing. Within Oracle Fusion applications, there are different entities such as customer, supplier, and so on, but they all represent trading partners from a business-to-business point of view. |
| B2bTradingPartnersb2bServiceProviders | The B2B Service Providers resource gets the relevant details of external parties that provide service to trading partners for message processing. This is a reference to the independent root resource B2B service providers. |
| B2bTradingPartnersconfirmationCodes | The Confirmation Codes resource gets the status mapping between trading partner and Oracle Collaboration Messaging Framework Cloud required in message processing. |
| B2bTradingPartnersdeliveryMethods | The Delivery Methods resource gets the details of mode of communication between Oracle Collaboration Messaging Framework Cloud and trading partners. |
| B2bTradingPartnersdocuments | The Trading Partner Documents resource gets all the documents associated with the trading partner that are exchanged for business-to-business message processing. |
| B2bTradingPartnersdocumentsmessageProcessingRules | The Message Processing Rules resource gets all the rules associated with the trading partner that are implemented while processing a message. |
| B2bTradingPartnersinboundCollaborationMessages | The Inbound Collaboration Messages resource gets the details of all the inbound messages that a trading partner sends to Oracle Collaboration Messaging Framework Cloud. |
| B2bTradingPartnersinboundCollaborationMessagesdomainValueMaps | The Domain Value Maps resource gets all the mappings associated with the trading partner that are implemented while processing a message. |
| B2bTradingPartnersinboundCollaborationMessagesmessageProcessingRules | The Message Processing Rules resource gets all the rules associated with the trading partner that are implemented while processing a message. |
| B2bTradingPartnersoutboundCollaborationMessages | The Outbound Collaboration Messages resource gets the details of all the outbound messages that a trading partner receives from Oracle Collaboration Messaging Framework Cloud. |
| B2bTradingPartnersoutboundCollaborationMessagesdomainValueMaps | The Domain Value Maps resource gets all the mappings associated with the trading partner that are implemented while processing a message. |
| B2bTradingPartnersoutboundCollaborationMessagesmessageProcessingRules | The Message Processing Rules resource gets all the rules associated with the trading partner that are implemented while processing a message. |
| CollaborationCustomerDemandUploads | The Collaboration Customer Demand Uploads resource manages compressed files containing customer demands that are processed by Oracle Supply Chain Collaboration Cloud. This resource is associated with a feature that requires opt in. |
| CollaborationCustomerDemandUploadsstatusDetails | The Status Details resource gets the errors associated with a customer demand upload request. |
| CollaborationDocumentMeasuresLOV | The Collaboration Document Measures List of Values resource lists the available document measures for collaboration. |
| CollaborationDocumentMetadata | The Collaboration Document Metadata resource gets the metadata for document definitions that are configured for collaboration. |
| CollaborationDocumentMetadatadocumentMeasureMetadata | The Document Measure Metadata resource gets the metadata for measures associated with a document definition. |
| CollaborationDocumentTypesLOV | The Collaboration Document Types List of Values resource lists the available document types for collaboration. |
| CollaborationOrderForecastHistory | The Collaboration Order Forecast History resource gets the historical planning cycle order forecasts that were published for supplier collaboration. |
| CollaborationOrderForecastHistoryaggregatedQuantities | The Aggregated Quantities resource gets the aggregated forecast quantities and commit quantities associated with the historical planning cycles of collaboration order forecasts in weekly, monthly, or quarterly increments. |
| CollaborationOrderForecastHistorycommitQuantities | The Commit Quantities resource gets the commit measure details associated with the historical planning cycles of collaboration order forecasts. |
| CollaborationOrderForecastHistoryforecastQuantities | The Forecast Quantities resource gets the forecast measure details associated with the historical planning cycles of collaboration order forecasts. |
| CollaborationOrderForecastHistoryreferenceQuantities | The Reference Quantities resource gets the additional measures associated with the collaboration order forecast, such as, purchasing measures. |
| CollaborationOrderForecasts | The Collaboration Order Forecasts resource gets the current planning cycle order forecasts that are published for supplier collaboration. You can use this resource to respond to collaboration order forecasts by providing supply commits. |
| CollaborationOrderForecastscommitQuantities | The Commit Quantities resource gets the current commit measure details associated with the collaboration order forecast. This resource can also be used to respond to collaboration order forecasts by providing supply commits. |
| CollaborationOrderForecastsexceptionQuantities | The Exception Quantities resource gets the forecast and commit exceptions associated with the collaboration order forecast, such as, forecast changes and commit mismatches. |
| CollaborationOrderForecastsforecastQuantities | The Forecast Quantities resource gets the current forecast measure details associated with the collaboration order forecast. This resource can also be used to update or create new forecast quantities for collaboration order forecasts. |
| CollaborationOrderForecastsreferenceQuantities | The Reference Quantities resource gets the additional measures associated with the collaboration order forecast, such as, purchasing measures. |
| CollaborationParameters | The Collaboration Parameters resource manages supply chain collaboration settings. |
| CollaborationSupplierOnHandQuantities | The Collaboration Supplier On-Hand Quantities resource manages supplier on-hand quantities for items at supplier sites. |
| CollaborationSupplyDataUploads | The Collaboration Supply Data Uploads resource manages a compressed file containing supply data for externally managed organizations that is processed by Oracle Supply Chain Collaboration Cloud. This resource is associated with a feature that requires opt in. |
| CollaborationSupplyDataUploadsstatusDetails | The Status Details resource gets the errors associated with a supply data upload request. |
| CollaborationUploadCounts | The Collaboration Upload Counts resource gets the status counts by document. |
| FlexFndDffDescriptiveFlexfieldContexts | Descriptive Flexfield Contexts |
| FlexFndPvsCharacterIdCharacterValues | FlexFndPvsCharacterIdCharacterValues |
| FlexFndPvsCharacterValues | FlexFndPvsCharacterValues |
| FlexFndPvsNumberIdCharacterValues | FlexFndPvsNumberIdCharacterValues |
| StandardLookupsLOV | The standard lookups list of values resource is used to query the list of values of standard lookups, which list the available codes and translated meanings. Standard lookups are defined in the standard lookups view and store lookup codes that support reference data sharing. |