Product Lifecycle Management
In the Product Lifecycle data model, the add-in 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 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 |
| 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.