What is Item interface?
The Item import Interface(IOI) reads data from following tables for importing items and item details. The MTL_SYSTEMS_ITEM_INTERFACE table is used for new item numbers and all item attributes. This is the main item interface table, and can be. the only table used to import items.
What are interfaces in Oracle Apps?
In Oracle Apps Interfaces are generally tables, which act as a medium to transfer the data from one module to another module or to transfer the data from legacy system into Oracle Applications. There are 352 tables provided by the Oracle Package. Each module has its own Interface Tables.
What is Item conversion in Oracle Apps?
Item conversion is nothing but importing the item and its details from staging table to interface table with some validations and then from interface table to base table.
What is Item category in Oracle Apps?
A category is a logical classification of items that have similar characteristics. A category set is a distinct grouping scheme and consists of categories. The flexibility of category sets allows you to report and inquire on items in a way that best suits your needs.
How do I import items into Oracle Fusion?
The following is an overview of the item import process:
- Download the item import template file from the File-Based Data Import for Oracle Supply Chain Management Cloud.
- Enter data in tabs within the item import template file.
- Generate CSV (ZIP file).
- Upload to Oracle WebCenter Content.
How do I assign a category in Oracle Apps?
To assign an item to a category from the Item windows:
- Navigate to the Master Items Summary or Organization Items Summary window.
- Select an item.
- Choose Categories from the Special menu. The item you selected appears at the top of the Category Assignment window.
- Select a category set.
- Select a category.
- Save your work.
What is item category in SAP SD?
Advertisements. An item category is used to define if an item is suitable for billing or pricing. It defines the additional control functions for a sales document. Example − A standard item function is totally different from the function of a free of charge item or a text item.
What is outbound interface oracle Apps?
Outbound Interface will be used to extract the data from oracle Database tables into the flat files. While developing the outbound Interface we will use UTL_File to Extract the data. Inbound Interface will be used to upload the data from legacy system (Flat files) into Oracle Applications base tables.