This chapter covers the following topics:
You can publish the following product data to various consuming systems:
Metadata
Value sets
Attribute groups (publish to other Oracle Product Hub systems only)
Item catalog categories
Items
Structures
Publishing to different systems, such as Siebel Customer Relationship Management, Oracle Billing and Relationship Management, or another Oracle Product Hub instance, enables you to centrally define products in Oracle Product Hub and maintain a common product data model across an enterprise with multiple systems. Before publishing items and structures, you must publish their related value sets, attribute groups (to Oracle Product Hub systems only) and item catalog categories.
For more information about how product data synchronizes with participating applications using the publishing process, see Chapter 2: Oracle Product Master Data Management Integration Base Pack, Oracle Product Master Data Management Integration 2.5 - Implementation Guide. This guide is part of the Oracle Application Integration Architecture Release 2.5 Media Pack , which you can download from http://edelivery.oracle.com.
For more information about how businesses in the communications industry can synchronize product data with participating applications, see: Modeling Communications Entities.
Related Topics
Publishing Value Sets, Oracle Product Hub Implementation Guide
Publishing Attribute Groups, Oracle Product Hub Implementation Guide
Assigning Systems to an Item Catalog Category, Oracle Product Hub Implementation Guide
Publishing Item Catalog Categories, Oracle Product Hub Implementation Guide
Publishing Items and Structures
Using PL/SQL Public APIs to Publish Objects
Viewing the Publishing History
Oracle Product Hub Web Services Overview, Oracle Product Hub Implementation Guide
You can publish an item and its structures from:
The item's simple Search Results page.
The advanced Search Results page.
The Favorite Items page.
The Browse Catalog page.
The item's Overview page.
The Oracle Applications Home Page using:
The Publish Items link.
The Import and Export Workbench link, then the Publish tab (Publish Batch Search page).
PL/SQL Public APIs included in the EGO_PUB_FWK_PK (EGOPFWKS.pls) API package.
You can include items from multiple item catalog categories and organizations in the same batch.
Important: : You can only publish items for which you have the Publish privilege. The Publish action is available from an item's Overview page only if you have the Publish privilege on the item. However, for practical reasons, you can only publish items for which you have the View privilege, too. You are only able to publish those items that you can view.
The item and structure publishing process includes an item's associated attribute values. However, operational attribute values only synchronize with Oracle E-Business Suite systems. Seeded attributes (see: Seeded Item Metadata Libraries, Oracle Product Hub Implementation Guide) do not synchronize with Oracle E-Business Suite systems; the connector service ignores them.
Publishing Structures
When publishing to another Oracle E-Business Suite system, you must create and publish the primary (date effective) structure for an item first. After publishing the primary structure, you can create and publish alternate, revision effective structures (such as engineering, model, and option class bills of material) to the Oracle E-Business Suite system.
Prerequisites
To publish items and structures to a new batch
From the Oracle Applications Home Page, select an appropriate responsibility, then select one of the following options to find items:
Item Simple Search
See: Searching for Items for instructions on how to find items.
Item Advanced Search
See: Searching for Items for instructions on how to find items.
Favorite Items
Browse Catalog
Depending on which option you use to find items, do the following:
In the Search Results page, select the items that you want to publish.
In the Favorite Items page, select the items that you want to publish.
In the Browse Catalog page, under the items tab, select the items that you want to publish.
You can also publish an item from the item's Overview page or from the Oracle Applications Home Page, by selecting an appropriate responsibility, then selecting Publish Items.
In the Select Items field, select Publish, then click Go.
If publishing from an item's Overview page, in the Actions field, select Publish, then click Go to automatically select the item for publishing.
Alternatively, in the Shortcuts field, select Publish Item, then click Go or, from the Oracle Applications Home Page, select the Publish Items link. You can create a new batch or copy an existing batch using either of these navigation methods (see "To publish items and structures copied from an existing batch" below).
In the Publish Items: Batch Details page, enter the following:
Batch Name
Required. Enter a unique batch name to identify the batch.
Structure Name
Optional. If you want to publish a structure for the selected items, select a structure name from the list. The list includes all available structure names defined in the system irrespective of the items selected. The selected structure is relevant to only those items that have this structure defined.
Warning: When publishing a multi-level structure, ensure that you specify the structure names used on all levels. If a component's structure has a different structure name that is not specified, then the component is not included in the published payload.
Structure Explosion Date
If you selected a structure name, then select the effective date of the structure. This date determines which revision of the item is selected and the components effective for the item revision selected.
Number of Levels to Publish
If you selected a structure name, then enter the number of structure levels to publish. The default value is 60, which is the maximum number of levels supported.
Explosion Type
If you selected a structure name, then selecting this parameter determines which components of the structure are selected. Valid values include:
All: All past, current, and future effective components are considered.
Current: This is the default value. Only current effective components are considered.
Current and Future: Only current and future effective components are considered.
Explode Standard BOM
If you selected a structure name, selecting this option explodes the standard BOM.
In the Selected Items region, you can remove any selected items by clicking Remove or you can add new items to the list by clicking Add to Batch.
Click Continue.
In the Publish Items: Source Systems page, enter the following:
Batch Name
You can change the batch name entered earlier if desired.
Workspace Name
Required. This field is used by Siebel for grouping multiple batches into a single group. Enter the name of the Siebel workspace project. If you are not using Siebel, enter any value.
Tip: You can reuse the name of the workspace to publish more items only if the Workspace Reuse option is selected in Siebel. If the workspace name is reused and the Workspace Reuse option is not selected, the process integration creates a new project workspace in Siebel using the workspace name and timestamp.
Auto-Release
Required. Select Default, Yes, or No from the list. This field refers to auto-releasing a Siebel workspace project.
Default - the workspace project auto-releases based on the setting of Auto Release within Siebel.
Yes - once the items are published to Siebel, the workspace project is automatically released.
No - once the items are published to Siebel, you need to manually release the workspace project.
Select the systems to which you want to publish by clicking Add Another Row.
Click Add Another Row as many times as needed to publish to multiple systems.
Tip: You can define default systems for an item catalog category (see: Assigning Systems to an Item Catalog Category, Oracle Product Hub Implementation Guide). The default systems appear automatically in the Publish Items: Source Systems page. You can delete these default systems by selecting them and clicking Remove, if necessary.
Click either Save as Draft or Publish.
The Publish Batch Search page appears, displaying the batch in the search results. See: Managing Publishing Batches.
To publish items and structures copied from an existing batch
You have the choice to either create a new batch or copy an existing batch when publishing items and structures using one of the following navigation paths.
Navigate to the Publish: Copy Batch page using one of the following methods:
From the Oracle Applications Home Page, select an appropriate responsibility, then select Publish Items.
Search for and select an item. In the item's Overview page, in the Shortcuts field, select Publish Item.
In the Publish: Copy Batch page, in the Create field, select Copy of Existing Batch. In the Select Batch field, search for and select a batch to copy. Click Continue.
Note: Alternatively, you can select New Batch. Follow the instructions above in "To publish items and structures to a new batch".
In the Publish Item: Batch Details page, all fields are pre-filled with the values copied from the selected existing batch. Enter a unique batch name.
You can change any of the pre-filled field values as well as add or remove items from the batch.
Click Continue.
In the Publish Items: Source Systems page, all fields are pre-filled with the values copied from the selected existing batch.
You can change any of the pre-filled field values as well as add or remove systems from the batch.
Click Save as Draft or Publish.
The Publish Batch Search page appears, displaying the batch in the search results. See: Managing Publishing Batches.
Related Topics
Publishing Value Sets, Oracle Product Hub Implementation Guide
Assigning Systems to an Item Catalog Category, Oracle Product Hub Implementation Guide
Publishing Item Catalog Categories, Oracle Product Hub Implementation Guide
Using PL/SQL Public APIs to Publish Objects
Viewing the Publishing History
Oracle Product Hub Web Services Overview, Oracle Product Hub Implementation Guide
Oracle provides a set of PL/SQL public APIs in the PIM Publish APIs package (EGO_PUB_FWK_PK) package to perform the following tasks:
Create a draft publication batch (API internal name: Create_batch).
Publish a copy of a batch (API internal name: Copy_batch).
Publish a draft batch (API internal name: Publish_batch).
Delete a publication batch (API internal name: Delete_batch). This API triggers the 'EGO Publish History Purge Program' concurrent program.
You can use the EGO_PUB_FWK_PK package to publish metadata (ICCs, attribute groups, and value sets), items, and structures. However, the package only checks for the Publish and View privileges when publishing items and structures. When publishing metadata, the package only verifies that the user has access to public functions.
For more information about using the PIM Publish APIs package, navigate to the Integrated SOA Gateway responsibility > Integration Repository > Product Lifecycle Management > Advanced Product Catalog > EGO_ITEM_METADATA_PUBLISH (Internal Name: EGO_PUB_FWK_PK). See: My Oracle Support (http://support.oracle.com) Document ID 730164.1 for instructions on how to use the Oracle Product Hub public APIs and code examples.
Related Topics
Publishing Value Sets, Oracle Product Hub Implementation Guide
Publishing Attribute Groups, Oracle Product Hub Implementation Guide
Assigning Systems to an Item Catalog Category, Oracle Product Hub Implementation Guide
Publishing Item Catalog Categories, Oracle Product Hub Implementation Guide
Publishing Items and Structures
Viewing the Publishing History
Oracle Product Hub Web Services Overview, Oracle Product Hub Implementation Guide
From the Publish Batch Search page, you can perform the following actions:
Search for batches using any of the following criteria:
Batch ID
Batch Name
Object Name
Published By
Published Date
Status
System
Workspace Name
Create a draft publication batch (for items, value sets, and attribute groups only).
Update a draft publication batch of items or metadata (item catalog categories, attribute groups, and value sets).
Merge publication batches (for items, value sets, and attribute groups only).
Delete a publication batch of items or metadata.
Publish a draft publication batch of items or metadata.
Copy a publication batch of items or metadata.
View the publishing history of items or metadata.
When managing publishing batches for items, you must use the Import and Export Workbench link from the Oracle Applications Home page to access the Publish Batch Search page. When managing publishing batches for metadata, use the Setup Workbench link to access the page.
To search for a publication batch
Search for either an item or a metadata publication batch:
For an item batch:
From the Oracle Applications Home Page, select an appropriate responsibility, then click Batch Import > Import and Export Workbench. Select the Publish tab.
For a metadata batch:
From the Oracle Applications Home Page, select an appropriate responsibility, then click Setup Workbench. Select the Publish tab.
For a metadata batch, in the Publish Batch Search page, View field, select whether you want to view item catalog categories (ICCs), attribute groups, or value sets.
This field only appears when accessing this page from the Setup Workbench.
Select one of the following options to filter the data:
Show table data when all conditions are met.
Show table data when any condition is met.
You must enter a search criteria value in at least one of the following fields:
Batch ID
Batch Name
System
Status
Optionally, add additional search criteria by selecting a criteria in the Add Another field. Click Add.
You can add as many additional search criteria as needed. In addition to adding more of the search criteria fields listed above, you can also add the following criteria:
Name
Enter the name of an object (ICC, attribute group, or value set).
Published By
Enter the user's name who published the data.
Published Date
Show Associated Entities
Select Yes to show published parent or child ICCs, for example. Select No to show only the entities that meet the search criteria.
Workspace Name
Click Go.
To create a draft publication batch
Navigate to the Publish Batch Search page for either an item or for value sets/attribute groups.
For value sets and attribute groups, in the Publish Batch Search page, View field, select whether you want to view attribute groups or value sets.
In the Publish Batch Search page, click Create.
In the Publish Items: Batch Details page, create a new publication batch as described in Publishing Items and Structures.
To update and publish a draft publication batch
In the Publish Batch Search page, find the draft publication batch that you want to update.
For metadata, in the Publish Batch Search page, View field, select whether you want to view attribute groups, value sets, or ICCs.
Click the Update Batch icon for the batch.
Important: For item batches, only the draft publication batch creator can update the batch.
The Publish Items: Batch Details page opens. The page's fields contain the values for the draft batch.
Update the fields as necessary. You can add or delete items.
Click Continue.
In the Publish Items: Source Systems page, you can add or delete systems.
Click Publish.
To merge publication batches
In the Publish Batch Search page, find and select two or more batches to merge. At least one of the batches must have a status of Draft.
For metadata, in the Publish Batch Search page, View field, select whether you want to view attribute groups or value sets.
Click Merge.
Optionally, in the Publish Items: Batch Details page, click Merge from Other Batches. Search for and select additional batches to merge with the previously selected batches. Click Apply.
In the Target Batch field, select the batch into which to merge.
Optionally, enter a name in the Structure Name field.
If you want to publish a structure for the selected items, select a structure name from the list. The list includes all available structure names defined in the system irrespective of the items selected. The selected structure is relevant to only those items that have this structure defined.
If you enter a structure name, then enter values in all other structure related fields.
Click Remove to remove any of the selected items from the batch or click Add to Batch to search for any additional items to include in the batch.
Important: Items must meet the following criteria for merging:
The user performing the merge must have the Publish privilege.
The user can access the Publish function.
The item revision selected is implemented.
Click Continue.
Change the Destination Parameters, if necessary.
In the Publish Items: Source Systems page, add to or remove the selected systems.
Click Save as Draft or Publish.
To delete selected publication batches
Deleting a publication batch is equivalent to purging the publishing history as described in Viewing the Publishing History
In the Publish Batch Search page, find and select one or more batches that you want to delete.
Click Delete.
In the Delete Batch Parameter page, confirm that you want to purge the selected batch. Click Yes.
A message appears, listing the batches submitted for deletion and the Concurrent Request ID.
To delete publication batches older than the selected number of days
Use this method to delete all publication batches more than a certain number of days old.
In the Publish Batch Search page, click Delete.
In the Delete Batch Parameter page, Number of Days field, select a certain number of days from the list of values.
The system deletes all publication batches more than the selected number of days old. For example, if you select 10 days, all batches more than 10 days old are deleted.
Tip: Your System Administrator can define the Number of Days field list of values according to your business needs. The lookup table for the Number of Days field is EGO_PUB_BATCH_PURGE_DAYS.
Click Yes.
The system returns you to the Publish Batch Search page. A message states that batches have been submitted for deletion and provides a Concurrent Request ID.
To create a copy of a publication batch
In the Publish Batch Search page, find the publication batch that you want to copy.
Important: When you select a publication batch to copy, only those items within the batch for which you have publish privileges are copied to the new publication batch.
Click the Copy icon for the batch.
In the Publish Items: Batch Details page, Batch Name field, enter a unique name.
If you are publishing items, you can update the structure parameters and add or remove items as needed.
Click Continue.
In the Publish Items: Source Systems page, you can add or remove systems and update the destination parameters.
Click Save as Draft or Publish.
To view the publishing history
In the Publish Batch Search page, find the batch for which you want to view the history.
Click the View History icon for the batch.
From the Publish History page search results, click Show to view the Publish Status Message for a batch row.
Click a Batch ID number to view the Batch Details page.
This read-only page displays all of the batch parameters originally selected.
Related Topics
Publishing Value Sets, Oracle Product Hub Implementation Guide
Publishing Attribute Groups, Oracle Product Hub Implementation Guide
Assigning Systems to an Item Catalog Category, Oracle Product Hub Implementation Guide
Publishing Item Catalog Categories, Oracle Product Hub Implementation Guide
Publishing Items and Structures
Using PL/SQL Public APIs to Publish Objects
Viewing the Publishing History
Oracle Product Hub Web Services Overview, Oracle Product Hub Implementation Guide
You can access the Publish History page from an item's Overview page (Publish History shortcut or action) or by using a link from the Oracle Applications Home Page (Item Publish History link).
Plan to periodically purge the publishing history so that large amounts of data do not affect the database's performance.
To view item publishing history
From the Oracle Applications Home Page, select an appropriate responsibility, then click Item Publish History.
Alternatively, you can navigate to the item Publish History page from an item's Overview page. In the Shortcuts or Actions field, select Publish History. The Publish History page opens, automatically displaying the selected item's publishing history.
In the Publish History page, select one of the following options to filter the data:
Show table data when all conditions are met.
Show table data when any condition is met.
You must enter a search criteria value in at least one of the following fields:
Batch ID
System
Status
Item
Optionally, add additional search criteria by selecting a criteria in the Add Another field. Click Add.
You can add as many additional search criteria as needed. In addition to adding more of the search criteria fields listed above, you can also add the following criteria:
Batch Name
Organization
Enter the name of the organization where the data was published.
Published By
Enter the user's name who published the data.
Published Date
Show Associated Entities
Select Yes to show published parent or child structures, for example. If the item structure is published, the status of the components display. Select No to show only the entities that meet the search criteria.
Workspace Name
Click Go.
To view the batch details
From the Publish History page search results, click Show to view the Publish Status Message for a batch row.
Click a Batch ID number to view the Batch Details page.
This read-only page displays all of the batch parameters originally selected.
To purge the publishing history
The system administrator (or someone designated by the system administrator) must purge the publishing history periodically so that large amounts of data do not affect the database's performance. Purging also enables the system to use previously used Batch ID numbers again.
An equivalent method of purging the publishing history is delete a publication batch as described in Managing Publishing Batches.
From the Oracle Applications Home Page, select the System Administrator responsibility, then click Requests.
In the Find Requests window, click Submit a New Request.
In the Submit Request window, Name field, search for and select the EGO Publish History Purge Program.
In the Parameters window, you can optionally enter the following to narrow the range of data purged:
BatchId List split by comma - Provide a list of comma separated Publication Batch_IDs. This concurrent program then purges the Publish history for the batches listed.
If this parameter is provided, then the rest of the parameters are not considered.
Purge Days - Batches published in the past number of days entered are purged. This parameter is considered only if the first parameter is not provided.
Batch Name1 - Purge the publication history for the named Publication batch. The Batch Name1 through Batch Name5 parameters are considered only if the two previous parameters are not provided.
Batch Name2
Batch Name3
Batch Name4
Batch Name5
Click OK.
Click Submit.
Related Topics
Publishing Value Sets, Oracle Product Hub Implementation Guide
Publishing Attribute Groups, Oracle Product Hub Implementation Guide
Assigning Systems to an Item Catalog Category, Oracle Product Hub Implementation Guide
Publishing Item Catalog Categories, Oracle Product Hub Implementation Guide
Publishing Items and Structures