My Oracle Support Banner

EEX 9.1+: Expense Report ID Saved As NEXT (SHEET_ID Field), Causing Issues With Other Employees Creating New Expense Report Transactions, Approvals, And Error Messages (Doc ID 1915522.1)

Last updated on NOVEMBER 07, 2019

Applies to:

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


+ Currently in Production with PeopleSoft Enterprise FSCM 9.2 Image #2, with PeopleTools 8.53.00 Version. The Expenses Employees have started complaining today that upon trying to create a brand new Expense Report transaction in the system, as soon as they enter into the Expense Report Entry page, the name of another Employee ID is being displayed in the screen, and existing Lines are being retrieved by the system.

    - Log into the FSCM Online Application as User ID VP1
    - Navigate to: Employee Self-Service > Travel and Expense Center > Expense Report > Create/Update
    - Define employee ID KU0042 (Linked to User ID VP1)
    - Click on the ADD Button
    - At the Expense Report Entry page, instead of showing the name of 'Kenneth Schumacher', the system is displaying some other Employee's name instead
    - When trying to Save For Later, or Submit For Approval, the system throws an Error Message

       " Gray: Row 2 not found in scroll level 1. (2,156) FUNCLIB_EX.SHEET_STATUS.FieldFormula  Name:gray_flds_dist  PCPC:6327  Statement:79
            Called from:FUNCLIB_EX.SHEET_STATUS.FieldFormula  Name:gray_sheet  Statement:318
            Called from:EX_HDR_WRK.TOTAL_SHEET_AMT.RowInit  Statement:48 "

Users are unable to create an Expense Report under their name, even though they selected their own Employee ID before clicking on ADD button to create the new transaction. Additionally, when trying to save the transaction entered, the system does not allow it. At this stage, no Expense Employee can create any further Expense Report.

What could be the cause of this behavior? And how to correct/resolve this situation?


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

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