Skip to main content

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.


    Comments

    Popular posts from this blog

    Error: - APP-PER-50022: Oracle Human Resource Could Not Retrieve a Value For The User Type Profile Option. Please ensure it is set property for your responsibility

    Error: - APP-PER-50022: Oracle Human Resource Could Not Retrieve a Value For The User Type Profile Option. Please ensure it is set the property for your responsibility. Solution-:      (1)  Go to System administrator > Profile > System       (2) Now Search “ HR: User Type ” Profile option at Responsibility level with Respective Responsibility. And Click On FIND Button. Now Select HR: User Type Value “HR with Payroll User” (you can choose another option as well accordingly). And SAVE. Now check your responsibility, error removed. Go ahead with your next step and enjoy Oracle Apps. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide.

    Error "You have exceeded the transaction quantity". Precision Restriction for Quantity Field Up To 6 Decimal Places Performing Lot Receipts (Doc ID 464983.1)

    Error "You have exceeded the transaction quantity".  Applies to:  Information in this document applies to any platform. FORM:RCVRCERC.FMB - Enter Receipts GUI FORM:RCVTXERT.FMB - Enter Receiving Transactions GUI FORM:RCVTXERE.FMB - Enter Returns GUI FORM:RCVTXECO.FMB - Enter Corrections GUI "You have exceeded the transaction quantity" Symptoms: "You have exceeded the transaction quantity" Note: Internal error message may indicate this message: INV_QUANTITY_TOO_BIG Steps: Go to Receiving Screen Enter the qty like 7200.00000489 (6 digits restriction makes it 7200.000005) Go to Lot/Serial form Enter lot number and qty as 7200.00001 (which was rounded to 5 digits) The message "you have exceeded the transaction quantity " Cause Can Be-: a) Restriction of precision support up to 6 decimal places was added for the quantity field  b) Comparing the transaction qty entered in receiving forms and the lot quantity entered in lot-entry form after rounding to...

    Script to insert on hand quantity in to MTL_TRANSACTIONS_INTERFACE

    Script to insert on hand  quantity   into MTL_TRANSACTIONS_INTERFACE To insert on hand  quantity    into  MTL_TRANSACTIONS_INTERFACE INSERT INTO MTL_TRANSACTIONS_INTERFACE                             (     TRANSACTION_INTERFACE_ID,                    SOURCE_CODE,                             SOURCE_LINE_ID,                             SOURCE_HEADER_ID,                             PROCESS_FLAG,                             VALIDATION_REQUIRED,                             TRANSACTI...