- Maintaining Airport Code
- Maintaining Airport Code
- Begin by navigating to the
- Maintain Airport Code
- page.
- You have completed the
- Maintaining Airport Code
- topic.
- First, add a new airport.
- Airport Codes
- are used as unique keys in the TR_AIRPORT_CODE_Master table and built into the logic of Oracle TRM.
- Airport Codes
- can be upper or lower case and up to 8 characters.
- Next,
- specify the full name of the airport. Airport codes
- appear on the
- Travel Request for Username (Request ID)
- page.
- Saving the airport code makes it available on the
- Travel Request for Username (Request ID)
- page.
- Next, modify the description for the
- OAK
- airport code.
- By default, the first row is automatically selected. When modifying or deleting an airport code, ensure the row you want to take action on is selected. You can click anywhere in the row to select it.
- There are two types of delete, a hard delete and soft delete.
- A hard delete removes the airport code from the database table, provided it is not used in a travel request.
- First, perform a hard delete on the airport code
- OAK
- .
- Confirm that you want to make the
- LHR
- airport code inactive.
- Next, query for all airports in India.
- You can query on any field by clicking into that field.
- You can query using whole or partial words.
- Press the Enter key to initiate the query.
- Use the
- Maintain Airport Code
- page to modify the airport options made available when creating a travel request.
- Use the
- Revert
- button to cancel adding a new airport code. This only works if the airport code has not been saved.
- The airport code
- OAK
- is now added.
- The
- OAK
- airport code is now deleted.
- A soft delete is used for inactivating an airport code already used in travel requests. Inactivated airport codes are not displayed as options on the
- Travel Request for Username (Request ID)
- page.
- Next, perform a soft delete on the LHR airport code.
- Check the
- Do not show this dialog again
- option if you do not want to see this message in the future.
- The
- LHR
- airport code is now inactive.
- Only the airports in India appear.
- The full list of airport code options is viewable again.
- The
- Query By Example
- button can be toggled on or off.
- Clear the query field to display the full list of airport codes. In this example, the field has been cleared for you.
- Original Path
- Adding a new airport code
- Modifying a new airport code
- Deleting a new airport code
- Querying a new airport code
- Links
- New
- Airport Code
- Airport Code
- Airport Name
- Airport Name
- City
- City
- Country Name
- Country Name
- Country Code
- Country Code
- Save
- City
- City
- Save
- Delete
- Save
- Active
- Yes
- Save
- Query By Example
- Country Code
- Country Code
- Active
- Airport Code
- Administration
- Manage Travel Requests
- Airport codes are used to identify a specific airport or other regularly used destination. When creating travel requests, users can search and select a code or manually type it in. Oracle Travel Request Management ships with seeded values for airport codes.
- The seeded values are:
- ATL - Hartsfield-Jackson Atlanta International Airport
- ORD- O'Hare International Airport
- LHR - London Heathrow Airport
- HND - Tokyo International Airport
- LAX - Los Angeles International Airport
- DFW - Dallas-Fort Worth International Airport
- FRA - Frankfurt International Airport
- CDG - Charles De Gaulle International Airport
- AMS - Schiphol Airport
- DEN - Denver International Airport
- PHX - Sky Harbor International Airport
- LAS - McCarran International Airport
- MAD - Barajas International Airport
- IAH - George Bush Intercontinental Airport
- HKG - Hong Kong International Airport
- MSP - Minneapolis/Saint Paul International Airport
- DTW - Detroit Metropolitan Wayne County Airport
- DMK - Don Muang International Airport
- SFO - San Francisco International Airport
- MIA - Miami International Airport
- JFK - John F. Kennedy International Airport
- LGW - London Gatwick Airport
- EWR - Newark Liberty International Airport
- SIN - Changi International Airport
- NRT - Narita International Airport
- PEK - Beijing Capital International Airport
- SEA - Seattle-Tacoma International Airport
- MCO - Orlando International Airport
- YYZ - Toronto Pearson International Airport
- STL - Lambert-Saint Louis International Airport
- DXB - Dubai International Airport
- CGK - Soekarno-Hatta International Airport
- PVG - Shanghai Pudong International Airport
- CLT - Charlotte Douglas International Airport
- MUC - Munich Airport
- BOM - Chhatrapati Shivaji International Airport
- DEL - Indira Gandhi International Airport
- You can add additional airport codes to meet your organization's needs. You can also add a code for a city or destination that is not an airport if you have employees regularly traveling to a specific location.
- In this topic, you will modify airport code options.