Import Items Concurrent Program

on Wednesday, December 18, 2013



After you insert valid data into Interface table, you can go to Items > Import > Import Items and run the standard concurrent program. Here is the parameter form




1] All Organizations:
  • Yes: Run the interface for all organization codes in the item interface table.
  • No: Run the interface only for the organization you are currently in. Item interface rows for organizations other than your current organization are ignored.
2] Validate Items:
  • Yes: Validate all items and their data residing in the interface table that have not yet been validated. If items are not validated, they will not be processed into Oracle Inventory.
  • No:  Do not validate items in the interface table.
3] Process Items:
  • Yes: All qualifying items in the interface table are inserted into Oracle Inventory.
  • No: Do not insert items into Oracle Inventory.
4] Delete Processed Rows:
  • Yes: Delete successfully processed items from the item interface tables.
  • No: Leave all rows in the item interface tables.
5] Process Set:
       Enter a number for the set id for the set of rows you want to process. The program picks up the rows marked with that id in the
       SET_PROCESS_ID
column. If you leave this field blank, all rows are picked up for processing  regardless of the SET_PROCESS_ID
       column value.