Careertail
About UsCoursesCareer PathsBlogOpportunities
Log In
Courses>Database Design & Development>Oracle Apps R12 Technical - Item Conversion
DevelopmentOracle Apps R12 Technical - Item Conversion
Price:Paid
Length:4 hours
Content type:video
level:expert
Updated:26 February 2024
Published:22 August 2022
Similar courses
Opportunities
Courses>Database Design & Development>Oracle Apps R12 Technical - Item Conversion
Oracle Apps R12 Technical - Item Conversion
0.0 (7.0)
4 hours
7 students
What you will learn
1Oracle Apps Technical
2Oracle EBS Technical
3Order to Cash Cycle in Oracle Apps
4Procure to pay cycle in oracle Apps
Target audiences
1Oracle Apps Technical
Requirements
1Oracle SQL and PLSQL
FAQ
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Description

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

Similar courses
Opportunities
Make the most out of your online education
Careertail
Copyright © 2021 Careertail.
All rights reserved
Quick Links
Get StartedLog InAbout UsCourses
Company
BlogContactsPrivacy PolicyCookie PolicyTerms and Conditions
Stay up to date
Trustpilot
Careertail
Courses>Database Design & Development>Oracle Apps R12 Technical - Item Conversion
DevelopmentOracle Apps R12 Technical - Item Conversion
Price:Paid
Length:4 hours
Content type:video
level:expert
Updated:26 February 2024
Published:22 August 2022
Similar courses
Opportunities
Courses>Database Design & Development>Oracle Apps R12 Technical - Item Conversion
Oracle Apps R12 Technical - Item Conversion
0.0 (7.0)
4 hours
7 students
What you will learn
1Oracle Apps Technical
2Oracle EBS Technical
3Order to Cash Cycle in Oracle Apps
4Procure to pay cycle in oracle Apps
Target audiences
1Oracle Apps Technical
Requirements
1Oracle SQL and PLSQL
FAQ
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Description

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

Similar courses
Opportunities
Make the most out of your online education
Careertail
Copyright © 2021 Careertail.
All rights reserved
Quick Links
Get StartedLog InAbout UsCourses
Company
BlogContactsPrivacy PolicyCookie PolicyTerms and Conditions
Stay up to date
Trustpilot