EEX 9.2: Several SQL Error Messages Getting Triggered When Trying To Add a New Travel Authorization, or Opening an Existing One, in Fluid User Interface (Doc ID 2809717.1)

Last updated on SEPTEMBER 26, 2021

Applies to:

Symptoms

The system is triggering Error Messages when trying to add a new Travel Authorization online through the Fluid User Interface functionality.

This seems to take place if the Travel Authorization - Fluid User Interface set up page has in its Sequence Number 1 row an Expense Type defined that is configured as Expense Type Edit values of: Per Diem, Hotel, or Per Diem Lodging.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as an Expenses User
    2.- Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Purchase > Create Expense Type Codes
    3.- Define 3 new Expense Types, as follows:
              a) Expense Type LODGING, with an Expense Type Edit configuration of HOTEL
              b) Expense Type MIE, with an Expense Type Edit configuration of PER DIEM
              c) Expense Type PDIEML, with an Expense Type Edit configuration of PER DIEM LODGING
    4.- Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Mapping > Maint Travel Auth Expense Type
    5.- Under Set ID SHARE, define the Sequence Number 1 row with Expense Type LODGING, and set it to Active
    6.- Go to the Employee Self Service Fluid Homepage
    7.- Click on the Travel Authorizations Tile
    8.- Click on the Add Travel Authorization button
    9.- ISSUE #1: The system throws an Error Message related to Exceeding Expense Location Amount Comments
    10.- Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Mapping > Maint Travel Auth Expense Type
    11.- Under Set ID SHARE, define the Sequence Number 1 row with Expense Type MIE, and set it to Active
    12.- Go to the Employee Self Service Fluid Homepage
    13.- Click on the Travel Authorizations Tile
    14.- Click on the Add Travel Authorization button
    15.- ISSUE #2: The system throws an Error Message related to getting Per Diem amounts functionality
    16.- Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Mapping > Maint Travel Auth Expense Type
    17.- Under Set ID SHARE, define the Sequence Number 1 row with Expense Type PDIEML, and set it to Active
    18.- Go to the Employee Self Service Fluid Homepage
    19.- Click on the Travel Authorizations Tile
    20.- Click on the Add Travel Authorization button
    21.- ISSUE #3: The system throws an Error Message related to getting Per Diem Lodging amounts functionality

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGES:

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.