My Oracle Support Banner

EEX 9.2: Copy Action on Fluid Expense Report Results in Transaction Being Saved as NEXT (Field SHEET_ID) if Attachment Receipt File Had Been Previously Uploaded (Doc ID 2759547.1)

Last updated on MARCH 11, 2021

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 and later
Information in this document applies to any platform.


Employees are able to save an Expense Report transaction created in Fluid User Interface with an ID value of NEXT, instead of the system generated number.

This is consistently replicable when at the Fluid Expense Report Header level, the Employee uploads a file as an attachment, which generates a numeric Expense Report ID, but later on uses the Expense Report Action option of 'Copy Expense Report'. Then the system changes the numeric ID generated for the value of NEXT, and saves it into PS_EX_SHEET_HDR Record.


    1.- Go to the Employee Self-Service fluid homepage
    2.- Click on the Expenses tile (opens the fluid EX dashboard)
    3.- Click the Create Expense Report tile
    4.- Notice that the Report Id shows “NEXT” (not saved to PS_EX_SHEET_HDR yet)
    5.- Change the Description field (example: “Test NEXT Report”)
    6.- Add an attachment
    7.- Notice that the Report Id now shows a valid Report ID, and it is saved to PS_EX_SHEET_HDR
    8.- Select Action = Copy Expense Report
    9.- Error: The Report ID now shows once again as “NEXT”, and it is saved to PS_EX_SHEET_HDR
    10.- Return to the Expenses dashboard
    11.- Go to My Expense Reports to see existing expense reports, including the “NEXT” report
    12.- Return to the Expenses dashboard
    13.- Click the Create Expense Report tile
    14.- Error: Cannot add a new Expense Report
    15.- Optional: Log in as a different User, and try to create a new Expense Report. It will cause an error by pulling in the NEXT report from a different User.

As the system has saved into Record PS_EX_SHEET_HDR an Expense Report with an ID value of NEXT, it causes that no other Employee can create any new Expense Report transactions.

All Expense Report transactions should be saved into the Record PS_EX_SHEET_HDR with an ID being a numeric value, not NEXT.




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.