SCM Common
In the Oracle SCM Common data model, the add-in models data such as shifts, schedules and workday patterns as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your Oracle Fusion Cloud SCM account are immediately reflected in the add-in.
Views
The Views section, which lists read-only SQL tables, contains samples of what you might have access to in your Oracle Fusion Cloud SCM account.
Common views include:
View | Description |
B2bApplicationPartners | Provides details of cross-referenced entities, such as customers or suppliers, involved in B2B message processing in Oracle Fusion applications. |
B2bTradingPartners | Details external entities, such as customers and suppliers, involved in B2B message exchanges within Oracle Fusion applications. |
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. |
B2bTradingPartnersdocuments | Manages documents exchanged with trading partners for B2B message processing. |
B2bTradingPartnersdeliveryMethods | Specifies communication methods between the Collaboration Messaging Framework and trading partners for message exchange. |
B2bTradingPartnersoutboundCollaborationMessages | Provides details of outbound messages sent to trading partners from the Collaboration Messaging Framework. |
B2bTradingPartnersinboundCollaborationMessages | Details inbound messages received from trading partners by the Collaboration Messaging Framework. |
Carriers | Manages carrier entities used for shipping, including shipping methods, contacts, and tracking rules. |
CarriersshippingMethods | Defines shipping methods, including transport modes and service levels, offered by carriers. |
Carrierscontacts | Stores contact information associated with carriers. |
InventoryOrganizations | Manages subsets of organizations for logistics, manufacturing, or asset management purposes. |
InventoryOrganizationsinvOrgParameters | Handles default values for transactions within specific inventory organizations. |
ItemUnitOfMeasureConversions | Provides unit conversion details for items to facilitate accurate transaction reporting. |
UnitsOfMeasure | Defines and manages the units of measure that can be used in transactions across applications, ensuring consistency and compatibility. |
StandardLookupsLOV | Provides lists of standard lookup codes and their translated meanings for reference. |
Schedules | Manages schedules defining working and non-working times for various business objects. |
ScheduleExceptions | Defines global schedule changes, such as holidays, applicable to assigned schedules. |
Shifts | Defines shifts representing working and non-working times within schedules. |
WorkdayPatterns | Defines workday patterns by detailing shifts and active days, forming the foundation for scheduling and time management. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including resubmiting and reprocessing messages.