Product Lifecycle Management
In the Product Lifecycle data model, the server models data such as ideas, item catalogs and product proposals 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 server.
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 |
| ItemsV2 | Manages details of items such as parts, materials, and products, including attributes that uniquely define them. |
| ItemCategories | Manages item categories, which define the classification and organization of items within catalogs. |
| ItemCategoryAssignments | Defines and manages the association between items and their assigned categories for proper classification. |
| ItemCatalogs | Manages catalog hierarchies and associated categories for product organization. |
| ItemsV2ItemCategory | Manages the relationship between items and their assigned categories within the catalog. |
| ItemsV2ItemRevision | Tracks and manages revision details for items, ensuring accurate record-keeping of changes over time. |
| ItemsV2ItemAttachment | Handles the management of item-specific attachments, linking documents or files to individual items. |
| ItemsV2ItemSupplierAssociation | Manages associations between items and their suppliers, defining supplier-specific attributes for each item. |
| ItemTemplates | Manages item templates, which provide predefined sets of attributes for quicker item creation and standardization. |
| ItemTemplatesitemRevisions | Tracks and manages revision details within item templates for accurate version control. |
| ItemsV2ItemEffCategory | Handles extensible fields for items, enabling the capture of additional characteristics such as color or size. |
| ItemsV2ItemRevisionItemRevisionDFF | Handles descriptive flexfields specific to item revisions for contextual customization. |
| ItemsV2ItemSupplierAssociationItemSupplierEffCategory ; | Handles extensible flexfields for item-supplier associations, enabling custom attribute management. |
| ItemsV2ItemTranslation | Manages translatable fields for items, ensuring attributes such as descriptions are accessible in multiple languages. |
| ItemsV2ItemRevisionItemRevisionTranslation ; | Handles translatable attributes for item revisions to support global operations and localized descriptions. |
| ItemCategoriesDFF | Handles contextual descriptive fields for item categories, enabling additional data storage and categorization. |
| ItemCatalogsDFF | Handles descriptive flexfields specific to item catalogs, allowing for tailored data capture and representation. |
| ItemTemplatesitemDFFs | Handles contextual descriptive flexfields in item templates, allowing for tailored data input. |
| ItemTemplatesitemTranslations | Handles translatable attributes in item templates to support multi-language item definitions. |
| TradingPartnerItemRelationships | Manages relationships between internal items and trading partner items for better collaboration. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including uploading objects like item batches and catalog attachments.