Extract a List of Oracle CX Sales Products

Next you extract the list of products from Oracle CX Sales. To extract the list of products, do the following:

1. Log into Oracle CX Sales as a user with the Product Manager role.

2. Click Navigator, and then click Product Information Management link.

3. Click the Tasks icon, and then in the Item Management area, click the Browse Items link.

4. In the Advanced Search area of the Browse Items page, click the Add Fields button.

5. In the Select and Add: Attributes page, click the Query By Example icon, and then specify a Creation Date value for the attributes.

6. From search result, select the row where Object Item value has the Creation Date Attribute value you entered, and click Add and then click OK.

   Search criteria for the Creation Date field is added.

7. From the Creation Date drop down menu, select After.

8. Select a date that is at least five years ago (for example, 1/1/09).

9. Click the Search button. The list of items appears. If required, you can filter by Item and Organization and Item.

10. Click the Export to Excel icon.

11. Save the file.

Note: Some spreadsheet tools remove the lead zero in a numeric field. This can affect the item numbers if the numbers are only numeric. Use a basic text editor or verify your item numbers to ensure that they are correctly reflected.

For more information on Oracle CX Sales products and creating sales catalogs, see Related Topics.