My Oracle Support Banner

EEX 9.2: Error Message (2,119) When Trying To Open Existing Travel Authorization Containing Expense Line With Expense Type LODGING, Due to EX_TA_LINE_WRK.MERCHANT_CD Field (Doc ID 2787569.1)

Last updated on JUNE 28, 2021

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


Users are getting an Error Message when trying to open via View or Create/Modify menu options an existing Travel Authorization that contains a transaction line using an Expense Type of LODGING, and that contains a Non-Preferred Merchant value entered online.

The Error Message takes place for any existing Travel Authorization transactions that are tried to be accessed via Create/Modify, View, or through Online Classic Approvals.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as an Expenses User
    2.- Navigate to: Employee Self-Service > Travel and Expenses Center > Travel Authorizations > Create/Modify
    3.- Enter the Employee ID value, and click on ADD button
    4.- Define the values needed at the Travel Authorization Header level (Business Purpose, Description, Default Location, Date From, and Date To fields)
    5.- Proceed to create a new Expense Line, and use Expense Type of LODGING. Define the Description, Payment Type, Billing Type, and Amount fields. Select the radio-button for 'Non-Preferred Merchant', and enter the value of TEST in the Merchant field
    6.- Save For Later the new Travel Authorization
    7.- Get out of the Component
    8.- Navigate again to: Employee Self-Service > Travel and Expenses Center > Travel Authorizations > Create/Modify or View
    9.- Search for the recently created Travel Authorization
    10.- From the search result hits, click on the transaction to open it in Online Classic
    11.- The system throws an Error Message

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 MESSAGE:

  " Assignment of "" to EX_TA_LINE_WRK.MERCHANT_CD failed. (2,119) EX_TA_LINE_WRK.EXPENSE_TYPE.FieldChange Name:BuildMerchDropdown PCPC:1658 Statement:27
    Called from:EX_TA_LINE_WRK.EXPENSE_TYPE.FieldChange Name:display_line Statement:348
    Called from:EX_TA_LINE_WRK.EXPENSE_TYPE.FieldChange Name:display_line_fields Statement:632
    Called from:EX_TAUTH_LINE.LINE_NBR.RowInit Statement:38
    The assignment to the specified field failed.
    The failure can be caused by any one of several problems. The new value could be too long to fit into the field, the new value could have too many digits (possibly including a sign) to the left of the decimal point to fit into the numeric field, there could be problems converting the new value to internal format, the field might not be present in the page buffers (rare), or there could be a memory allocation error (very rare).
    Review the program for errors. If necessary, run a PeopleCode trace to determine the program that failed. A trace including "Show Assignments to Variables" will trace the new value. "

Users are unable to Modify or View any existing Travel Authorization whose Expense Line is having a value as Non-Preferred Merchant field. Transactions cannot be reviewed, nor further updated and submitted for approval, or if already submitted for approval, Online Classic Approvals also gets the Error Message.

The system should not trigger such Error Message, and should instead successfully load online the Travel Authorization transaction selected.

NOTE: In the images/screenshots/examples mentioned and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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