1. Implementing Product Management
  2. Import Data from the Item Management Interface Tables

Import Data from the Item Management Interface Tables

Once the CSV file is uploaded to Oracle WebCenter Content, you use the Load Interface File for Import scheduled process to move the data from the Oracle WebCenter Content folder to the interface tables.

Perform these steps to move the data into the interface tables:

  1. From the Navigator link, select the Scheduled Process link.

  2. Click the Scheduled New Process button in the Search Result table header.

  3. In the Schedule New Process dialog select the following:

    • Type: Job

    • Name: Load Interface File for Import

  4. Click the OK button.

  5. In the Process Details dialog, enter the following parameters:

    • Import Process: Item Import

    • Data File: the name of the ZIP file you uploaded to Oracle WebCenter Content.

  6. Click the Submit button to start the process.

  7. Monitor the status of the scheduled process for moving the data from the Item Management interface tables to the Item Management production tables by entering the process ID in the Search region in the scheduled processes user interface.

Import the Data from Item Management Interface Tables

At this point in the import process, the data is now loaded into the Item Management interface tables and is ready to be imported into the Item Management production tables. The next process will perform the item import process that will validate the data for import and move the data into the Item Management production tables. After successful completion of this job, the data will be available in the user interface.

  1. From the Navigator link, select the Scheduled Processes action in the Tools section.

  2. Click the Schedule New Process button in the Search Result table header.

  3. In the Schedule New Process dialog select the following:

    • Type: Job

    • Name: Item Import

  4. Click the OK button.

  5. In the Process Details dialog, enter item import for the import process.

  6. Enter the following information in the Process Details dialog:

    • Batch ID: enter a unique identifier of the batch used to import the items.

    • Process All Organizations: Select Yes to import items from all organizations. Select No to not import items from all organizations.

    • Process only: Indicate which transaction-type records need to be processed for an item batch. Values are Create, Sync, Update.

    • Delete Processed Rows: Indicates if the rows in the interface tables are to be deleted after the processing of an item batch. Values are Yes or No.

  7. Click the Submit button to start the process.

  8. After you click the Submit button a Configuration dialog is launched with the process ID. Note the ID.

  9. Multiple processes are created for all of the steps in importing the item. The child processes are: Item Import Preprocessing, Item Import Data Quality, and Item Import.

  10. View the log file for any errors (if applicable), by selecting the row in the Search Results table and clicking the View Log button.

Successfully imported items and related child entities can be queried, modified and validated.

Related Topics