Downloaded 88 times
![How to Add Value in Lookups with Access Level System Edi Yanto [email_address] Oracle Applications Technical Consultant](https://image.slidesharecdn.com/how-to-add-value-in-lookups-with-access-level-system-1234683739555581-2/75/How-To-Add-Value-In-Lookups-With-Access-Level-System-1-2048.jpg)
Uploaded byEdi Yanto
How To Add Value In Lookups With Access Level System
This document provides steps for adding a value to a lookup with an access level of "System" in Oracle Applications. It involves updating the lookup type in System Administration Responsibility, adding the value, and then updating the VIEW_APPLICATION_ID column in the database table to make the new value visible in forms.
In this document
Powered by AI
This presentation covers the process of adding values to lookups in an Access Level System, specifically in Shipping Execution, detailing each administrative step.
How To Add Value In Lookups With Access Level System
- 1. How to AddValue in Lookups with Access Level System Edi Yanto [email_address] Oracle Applications Technical Consultant
- 2. Shipping Execution LookupsValue Before Added Code Value (SHIP) Adding Value for lookups with Level Access System can not be done directly on the Form lookups. To add it done in the System Administration Responsibilty
- 3. Step 1 Navigateto System Administration Responsibility Menu: Lookup Types, find ‘Shipping Execution’ Application Name with Access Level ‘System’
- 4. Step 2 ClickUpdate for ‘Mode of Transport’ Lookup Type Icon Update for Mode of Transport
- 5. Step 3 Clickbutton ‘Update’ for adding the value
- 6. Step 4 Clickbutton ‘Add Another Row’
- 7. Step 5 AddValue ‘SHIP’ and then click Apply Menu Lookups: After update this Lookups, the value doesn't update in the Form Lookups. In order to be used the value that have been added, the one thing to be done is update the table on database
- 8. Step 6 Updatevalue from ‘0’ to ‘665’ in the VIEW_APPLICATION_ID column on the FND_LOOKUP_VALUES_VL simple view or FND_LOOKUP_VALUES table
- 9. Step 7 Afterupdated, the value will appear in the Form Lookups Value Added