My Oracle Support Banner

EEX 9.2: The Data in the Field, APPROVER_PROFILE in the records EX_SHEET_NOTES, EX_TAUTH_NOTES, and EX_ADV_NOTES is Displayed Incorrectly (Doc ID 2559436.1)

Last updated on JULY 01, 2019

Applies to:

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

Symptoms

The Data in the Field, APPROVER_PROFILE in the records EX_SHEET_NOTES, EX_TAUTH_NOTES, and EX_ADV_NOTES is Displayed Incorrectly

 

Steps:

1) Use non-SHARE workflow
2) Enter a description for a profile for the non-SHARE setup different from the SHARE setup. For example, change EXPENSE MANAGER to a longer description such as “Department Approver”
3) Submit an item (expense report, travel authorization, and/or cash advance) that uses this setup.
4) Have this approver enter in both a COMMENT and a NOTE
5) View the Notes page
6) An entry will appear for both the COMMENT and NOTE but the Role Description will be for SHARE when selected from EX_APRVL_HIST and truncated when from the EX_SHEET_NOTES

Actual Result:

When Notes are added by the approver they are truncated when saved.

The data in the field, APPROVER_PROFILE in the records EX_SHEET_NOTES, EX_TAUTH_NOTES, and EX_ADV_NOTES is corrupted as follows:
1) Is not the correct field to use – this is defined as a 15 character UPPERCASE field
2) Incorrect data is stored in this field and does not use the correct SETID – the system uses SHARE
3) Data stored in this field is truncated – once the data is retrieved it is usually truncated to fit.
4) Mixed case data is stored in this field

Expected Result:

Notes data in the EX_SHEET_NOTES, EX_TAUTH_NOTES, and EX_ADV_NOTES should not be trundated.

Please see the replication steps document for more details.

NOTE: In 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.