What are the differences between system, extensible, and user lookup types in Oracle Apps R12?

What are the differences between system, extensible, and user lookup types in Oracle Apps R12?

OR

Type of Lookups in Oracle Apps R12

User

• Updating of the start date, end date, and enabled fields are allowed
• Deletion of codes is allowed
• Updating of the tag is allowed
• Insertion of new codes is allowed

Extensible

• Insertion of new codes is allowed
• Updating of the start date, end date, enabled fields, and the tag is allowed only if the code is not 'seed data'
• Deletion of codes is allowed only if the code is not 'seed data'
• Updating of the module is not allowed
• Deletion of lookup type is not allowed

System

• Insertion of new codes is not allowed
• Updating of the start date, end date, and enabled fields are not allowed
• Deletion of codes is not allowed
• Updating of the tag is not allowed
• Updating of the module is not allowed
• Deletion of lookup type is not allowed

For more details please click on HERE.

“A GUIDE FOR ORACLE E-BUSINESS SUITE” –A complete Solution and Learning platform For Oracle Apps R12/11i, Training, India Localization, Technical, P2P, O2C, Drop-shipment, AR/AP Cycle, Implementation, Bug or error in Oracle Apps R12/11i, Up-gradation, Support, Alert, Personalization, Discoverer management, OracleApps R12/11i Module, Finance, SCM, MRP, ASCP, WIP, BOM, FA, AP, AR, OM, INV, AOL, MOAC, TCA structure, Project Accounting, CM, Functional,Oracle DBA, ERP, Techno-functional, OAF, Oracle Apps Interview Question and Error in Oracle apps R12/11i. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide.