How You Resolve Travel Itinerary Import and Validation Issues

You run the Import Travel Itineraries process to import and validate travel itineraries from the GetThere travel partner into Oracle Fusion Expenses. Similarly, you run the Validate only process to review the travel itineraries posted from other third-party travel partners.

When you run these processes, the following results may occur:

  • The process completes with an error.

  • The process completes with a warning or success but doesn't import any itineraries.

  • The process completes with a warning.

Process Completes with an Error

Here are some conditions when the Import Travel Itineraries process completes with an error:

  • It can't establish a connection with your GetThere travel partner.

  • It encounters an unexpected error.

  • The GetThere portal or booking site is unavailable.

To identify the error, review the log and output details of the Import Travel Itineraries process by performing the following steps:

  1. Navigate to the Travel Administrator work area.

  2. Select the applicable process.

  3. From the Action menu, select View Process Details.

  4. In the View Process Details dialog box, click the log .txt file.

  5. In the View Output Parameters column, click the output file.

Verify that the travel partner integration values described in the following table are set up correctly on the Edit Travel Partner Integration page for GetThere. Follow these steps to navigate to the page:

  1. In the Setup and Maintenance work area, use the following to navigate to the Manage Travel Partner Integrations page.

    • Offering: Financials

    • Functional Area: Expenses

    • Task: Manage Travel Partner Integrations

  2. On the Manage Travel Partner Integrations page, select the link for GetThere travel partner.

    The Edit Travel Partner Integration page for GetThere is displayed.

Invalid Value

Log File Error

Page

Connection User Name and Password

CreateSesssionWS failed with authentication error.

Edit Travel Partner Integration page for GetThere

Super Site Name

CreateSesssionWS failed with authentication error.

Edit Travel Partner Integration page for GetThere

Create Session Web Service Definition Language (WSDL) location

CreateSessionWS failed with InaccessibleWSDLException.

An error occurs only when the travel partner asks you to change a WSDL location and you enter it incorrectly.

Edit Travel Partner Integration page for GetThere

Retrieve Itinerary Locator WSDL location

RetrieveItinLocatorWS failed with InaccessibleWSDLException

An error occurs only when the travel partner asks you to change a WSDL location and you enter it incorrectly.

Edit Travel Partner Integration page for GetThere

Retrieve Itinerary Details WSDL location

RetrieveItinDetailWS failed with InaccessibleWSDLException

An error occurs only when the travel partner asks you to change a WSDL location and you enter it incorrectly.

Edit Travel Partner Integration page for GetThere

Note: If you see a log file that indicates that the EndSessionWS failed with InaccessibleWSDLException, the Import Travel Itineraries process won't result in an error even if the End Session WSDL location was updated incorrectly. These atypical sessions are removed by your travel partner eventually.

If you want to reset the entries in the WSDL fields to the original values, the following table describes the original WSDL locations.

Web Service Name

Web Service URL

Create Session

https://files.developer.sabre.com/wsdl/sabreXML1.0.00/usg/SessionCreateRQ.wsdl

Note: To download all the necessary files, you can use: https://files.developer.sabre.com/drc/providerdoc/usg/SessionCreateRQ.zip

Retrieve Itinerary Locator

https://files.developer.sabre.com/wsdl/sabreXML1.0.00/GetThere/GT_ERP_TravelItineraryLocatorRead1.0.0RQ.wsdl

Retrieve Itinerary Details

https://files.developer.sabre.com/wsdl/sabreXML1.0.00/GetThere/GT_ERP_TravelItineraryRead1.0.0RQ.wsdl

End Session

https://files.developer.sabre.com/wsdl/sabreXML1.0.00/usg/SessionCloseRQ.wsdl

Note: To download all the necessary files, you can use: https://files.developer.sabre.com/drc/providerdoc/usg/SessionCloseRQ.zip
Tip: If web service connection issues persist after ruling out set up issues, contact your travel partner's administrator or your support representative to validate WSDL locations or to determine whether the travel partner's portal or booking site is down. For other unexpected errors, contact Oracle Support.

Process Completes with a Warning or Success But Doesn't Import Itineraries

To review warnings, review the log and output details of the Import Travel Itineraries process by performing the steps mentioned in the previous section of this topic.

The following table describes the results when the Import Travel Itineraries process completes with a warning or a success but doesn't import any itineraries from GetThere travel partner.

Invalid Value

Result

Page

Site Identifier

  • No errors in the log file.

  • The count for new itineraries imported is zero in the output file.

  • The Import Travel Itineraries process completes with a warning or success.

Create Booking Site dialog box

Here are the steps to navigate to the Create Booking Site dialog box:

  1. In the Setup and Maintenance work area, use the following to navigate to the Manage Travel Partner Integrations page.

    • Offering: Financials

    • Functional Area: Expenses

    • Task: Manage Travel Partner Integrations

  2. On the Manage Travel Partner Integrations page, select the link for GetThere travel partner to open the Edit Travel Partner Integrations page for GetThere.

  3. In the Booking Sites section, click the Create icon.

Process Completes with a Warning

Here are some conditions when the Import Travel Itineraries process or the Validation only process completes with a warning:

  • Itineraries fail importation

  • Itineraries have critical validation errors

  • Itineraries have invalid data

  • Itineraries have unmatched values

To review warnings, review the log and output details of the Import Travel Itineraries or Validation only process by performing the steps mentioned in the previous section of this topic.

The following table describes the cause and resolution for itinerary import failures.

Log Error Message

Cause

Resolution

The itinerary couldn't be imported because it's missing a value in the Status attribute.

  • The itinerary status is null.

  1. Review the import failure message in the Itinerary Import Failures dialog box.

  2. The Import Travel Itineraries process automatically reattempts to import failed itineraries for a specified number of user-defined days.

  3. If itineraries continue to fail, contact your travel partner's representative to resolve issues.

The itinerary can't be brought in Expenses because the time stamp that indicates whether or not the itinerary has been modified is invalid.

The last modified time stamp on the itinerary is null.

  1. Review the import failure message in the Itinerary Import Failures dialog box.

  2. For GetThere, the Import Travel Itineraries process automatically reattempts to import failed itineraries for a specified number of user-defined days

    For other third-party travel partners, you need to post the itineraries again with the correct time stamps.

  3. If itineraries continue to fail, contact your travel partner's representative to resolve issues.

Missing message text.

The itinerary can't be imported because it contains a reservation, which wasn't reserved and is missing a confirmation number.

Itinerary has a reservation confirmation number that's null.

  1. Review the import failure message in the Itinerary Import Failures dialog box. The Import Travel Itineraries process automatically reattempts to import failed itineraries for a specified number of user-defined days.

  2. If itineraries continue to fail, contact your travel partner's representative to resolve issues.

This itinerary can't be imported because the following error was returned by the itinerary details web service: {ERROR}.

An unexpected error occurs while attempting to import the details for an itinerary.

The Import Travel Itineraries process continues to import itineraries, even if it encounters an unexpected error with a specific itinerary.

  1. Review the import failure message on the Itinerary Import Failures dialog box.

  2. The Import Travel Itineraries process automatically reattempts to import failed itineraries for a specified number of user-defined days.

  3. If itineraries continue to fail, contact Oracle Support.

Your request can't be completed at this time. Verify your request and try again.

Itinerary details can't be retrieved since the itinerary has multiple travelers.

  1. Review the import failure message on the Itinerary Import Failures dialog box.

  2. The Import Travel Itineraries process automatically reattempts to import failed itineraries for a specified number of user-defined days.

  3. Your travel partner doesn't support itineraries booked for multiple travelers.

Errors due to a validation failure are resolved by travel administrators. The following table contains the error, cause, and resolution of critical validation errors.

Validation Error

Cause

Resolution

Invalid employee number:

  • The employee number is null.

  • The employee number doesn't match the employee number in Oracle Fusion Human Capital Management.

  • The employee's user profile in your travel partner's site has a null or invalid employee number.

  • The employee number isn't sent from your travel partner.

  • The traveler is an applicant and not an employee.

  1. Correct the user profile in your travel partner's site.

  2. From the Travel Administration work area, navigate to the Resolve Travel Itinerary Import Errors page.

  3. Assign the correct employee to the itinerary.

Missing reservation pricing information

  • Your travel partner booking site allows employees to book a split flight across two airlines in which pricing is unavailable.

  1. Contact your corporate travel agency to update the missing pricing information.

  2. From the Travel Administration work area, open the Review Travel Itinerary Import Results page to update the missing pricing information for that itinerary.

  3. To eliminate errors in the future, consider a configuration change at the travel booking site to prevent booking without pricing information.

Unexpected error

  • The application encountered an unexpected error while validating an itinerary.

  • The Import Travel Itineraries process continues to import itineraries, even if it encounters an unexpected error with a specific itinerary.

Review the Import Travel Itineraries process log file by performing the following steps:

  1. Navigate to the Travel Administrator work area.

  2. Select the applicable process.

  3. From the Action menu, select View Process Details.

  4. In the View Process Details dialog box, click the log .txt file.

  5. If you can't diagnose the error, contact Oracle Support.

Note: After itinerary import failures and critical validation errors are resolved, rerun the Import Travel Itineraries process in the Validate only process mode to remove errors so a trip can be automatically created from the itinerary.

The following table describes the validation error, cause, and resolution of invalid data validation errors.

Validation Error

Cause

Resolution

Invalid data

  • Missing data

  • Invalid data format

  1. From the Travel Administration work area, open the Review Travel Itinerary Import Results page.

  2. For GetThere, correct the errors and rerun the Import Travel Itineraries process to revalidate the errors or wait for the next scheduled Import Travel Itineraries process to revalidate.

    For other third-party travel partners, correct the errors or post the itineraries again. Then, revalidate the itineraries.

  3. Contact your travel partner and take steps to prevent future errors.

The following table describes the validation error type, cause, and resolution of unmatched value validation errors.

Validation Error

Cause

Resolution

Unmatched values for policy violation.

Missing booking policy violation mapping

  1. Review the values on the Review Travel Itinerary Import Results page and select the correct policy violation.

  2. To add missing booking policy violation mapping to reference data, create a new lookup code for the lookup EXM_POL_VIOLATIONS_TYPES and define the meaning with the booking policy violation text.

  3. To enforce booking policy violation validation for booking sites set up in a foreign language, define the booking policy violation as the lookup code meaning for the foreign language.

  4. If you use a company-defined lookup type for policy violation validation, add the new policy violations as lookup codes for this company-defined lookup type.

  5. If a lookup code for the missing booking policy violation already exists, ensure that the lookup code meaning is defined exactly as the booking policy violation that's provided by your travel partner.

Unmatched value for airline, hotel, rail, car rental code, or name.

Missing merchant codes

  1. Review the values in the Review Travel Itinerary Import Results page and select the correct merchant code.

  2. To add missing merchant codes to merchant reference data, navigate to the Travel Administration work area.

  3. Click the Manage Merchants link.

  4. Download the spreadsheet, add new merchants, and upload.

Unmatched value for class of ticket for air reservation

Missing class of air ticket

  1. Review the values in the Review Travel Itinerary Import Results page and select the correct air ticket class.

  2. To add a missing class of air ticket to reference data, create a new lookup code for the lookup type EXM_TICKET_CLASS and define the meaning with the class of air ticket.

  3. To enforce class of air ticket validation for booking sites setup in a foreign language, define the class of air ticket as the lookup code meaning for the foreign language.

  4. If you use a company-defined lookup type for class of air ticket validation, add the new class of air ticket as lookup codes for this company-defined lookup type.

  5. If a lookup code for the missing class of air ticket already exists, ensure that the lookup code meaning is defined exactly as the class of air ticket provided by your travel partner.

Unmatched value for location.

Missing location

  1. Review the values in the Review Travel Itinerary Import Results page and select the correct location.

  2. To add a missing location to reference data, define missing locations in Oracle Fusion Trading Community Architecture that map to the city, state, and country values sent by your travel partner.

    Navigation: Setup and Maintenance work area > Manage Geographies task > Manage Geographies page.