Oracle Apps R12 Technical – Item Conversion

Item import program can be used to create new Inventory items or to update existing inventory items. We can import items with all attributes information or use item templates to set attributes and import items linking with item template.

Uses:

1. Import New Inventory Items in Master Organization

2. Assign Items to child Organization (Step1 has to be finished before this task can be executed)

3. Update existing Inventory item attributes information

4. Assign Item Category Assignments

5. Lot numbers can be imported along with items

6. Serial numbers can be imported along with items

Execution Methods:

1. Run “Import Items” concurrent program from inventory responsibility manually.

2. Use PLSQL wrapper code to kick of the “Import Items” Concurrent program from backend.

Parameters:

All Organizations: Yes / No (Select Yes if you want to import items belonging to various organizations reglardless of current selection in form)

Validate Items: Yes / No (Select Yes if you would like to validate Items. With out validation we can not proceed to Processing)

Process Items: Yes / No (Select Yes to process / import items)

Delete Processed Items: Yes / No (Select Yes to purge data in interface tables for the processed records)

Process Set: You can use this parameter to process records in batches. It will use SET_PROCESS_ID column in interface table.

Create or Update Items: 1 / 2/ 3. (1- Create New Items, 2 – Update Existing Items, 3 – Sync Items. Option 3 should be used if we have some items to be created and some to be updated)

Gather Statistics: Yes / No. (Helps to increase performance of SQL queries based on items table)

Pre-requisites:

1. Master Organization should be defined.

2. Child Organization should be defined.

3. Code Combinations should be defined.

4. Item Templates (If using item templates in interface table)

5. Defining Item Status Codes

6. Item Types should be defined.

Issues:

1. Don’t try to load both master item record and child item record at a time. If you want to do that make sure you use process set column.

2. Revision numbers have to be in chronological order, meaning it can be like AA, BB, CC … or 1,2,3,….but i can’t be AA, 1, BB, 2 etc.

3. Category assingments, Lot numbers, serial numbers has to be linked properly to the respective tables.

Interface tables:

MTL_SYSTEM_ITEMS_INTERFACE
MTL_ITEM_REVISIONS_INTERFACE (If importing revisions)
MTL_ITEM_CATEGORIES_INTERFACE (If importing categories)

Error Tables:

MTL_INTERFACE_ERRORS (View errors after import)

Base tables:
MTL_SYSTEM_ITEMS_B
MTL_ITEM_REVISIONS_B
MTL_CATEGORIES_B
MTL_CATEGORY_SETS_B
MTL_ITEM_STATUS
MTL_ITEM_TEMPLATES

Who this course is for:

• Oracle Apps Technical