EEX 9.2: Performance Degradation Experienced at Fluid Travel Authorization Creation When Using Accounting Tag With Over 18,000+ Definitions (Header and Line Levels) (Doc ID 2939822.1)

Last updated on MAY 15, 2023

Applies to:

Symptoms

Employees in the Travel and Expenses module are suffering performance degradation problems when trying to use the Accounting Tag functionality on the Fluid Travel Authorization pages when creating a new transaction. This problem happens both at the Header and Line levels of the Travel Authorization, when loading the Accounting Tag page (ACCTG_TAG_SEL_SCF), or using the 'Manage Favorites' link/feature.

If the system has defined over 18,000+ Accounting Tags, it takes roughly up to 3 minutes to load the Accounting Tag page (ACCTG_TAG_SEL_SCF), and when trying to use the Manage Favorites feature link, the system spins for over 5 minutes until the User is kicked out of the PeopleSoft session.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as an Expenses User
    2.- Navigate to: Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Accounting Tags > Tag Registration by Products
    3.- Enable Expenses module for the User Accounting Tag check-box
    4.- Navigate to: Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Accounting Tags > Define Accounting Tags Group
    5.- Create a new Group called EXPENSES
    6.- Navigate to: Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Accounting Tags > Accounting Tags
    7.- Define in the system over 18,000+ different Accounting Tag configurations for Accounting Tag Group EXPENSES
    8.- Navigate to: Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Accounting Tags > Assign Tag Groups
    9.- Define a row for Component Name EX_TAUTH_FL, (Travel Authorization), and link it to the Accounting Tag Group EXPENSES
    10.- Go to the Employee Self Service Fluid Homepage
    11.- Click on the Travel Authorizations Tile
    12.- Click on the Add Travel Authorization button available
    13.- Define the Travel Authorization Header information: Business Purpose, Description, Billing Type, Comments, Travel From, Travel To, Date From, Date To
    14.- Click on the Accounting Default button
    15.- Click on the Change Value button
    16.- The system takes 3 minutes to load the Accounting Tag page (ACCTG_TAG_SEL_SCF)
    17.- Click on the Manage Favorites link
    18.- After 5 minutes, the system kicks the User out of the PeopleSoft session through time out

The Employees are unable to successfully make use of the Accounting Tag functionality when creating Fluid Travel Authorizations, which prevents timely approvals and further processing of such transactions in the system. Accounting Tag functionality in FIN Expenses module cannot be rolled out to Users at this stage, complicating data entry tasks for Users who do not know all ChartField Accounting values to enter manually online.

While it is understandable that 18,000+ Accounting Tag definitions is a large number, the Business requires them, and the system should be able to handle such big volume of configuration in a timely manner.

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.