1Z0-520 practice question 23 of 30

Which table stores the categories assigned to a system item?

Full set: 245 questions
Answer options
A: MTL_CATEGORIES_B
B: MTL_CATEGORIES_TL
C: MTL_ITEM_CATEGORIES Correct answer
D: FND_ITEM_CATEGORIES
Correct Answer:
C. MTL_ITEM_CATEGORIES
Explanation

The MTLITEMCATEGORIES table is specifically designed to store the categories assigned to items, linking items to their respective categories within Oracle.

Why Incorrect

A. MTLCATEGORIESB is for category definitions, not assignments.
B. MTLCATEGORIESTL contains translations of category names, not assignments.
D. FNDITEMCATEGORIES is not specifically for system items, mainly used for functional setups.

References

- Oracle Inventory User's Guide, Section on Item Categories, Page 103.

- Oracle E-Business Suite Data Model Documentation, MTLITEMCATEGORIES description.

- Oracle Database Schema Reference, Chapter on Inventory Schema.

- Oracle Documentation on MTLITEMCATEGORIES: http://docs.oracle.com/cd/B4009926/current/html/eng-OracleInventory/HTIAF.html

- Oracle Support Document ID 242666.1.

Scroll to Top