My Oracle Support Banner

EEX9.2: Partial Time Reports Hours Disappear from Page and or on Submit of Report Encounter Fatal PeopleCode SQL Error (Doc ID 2742189.1)

Last updated on JANUARY 06, 2021

Applies to:

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

Symptoms

Issue 1: Creating Time Report for end of month processing and upon saving the time report the hours disappear from the page.

Issue 2: Create Time Report for end of month processing then save and submit the report encounter a Fatal PeopleCode SQL error.

Replication Steps:

Issue one:  

1) Via Employee Self Service Create a Partial Time Report

2) Add hours for partial week

3) Select Update Totals pushbutton

4) Totals updated. Select the tick box "Submit for Partial Month" then click on Submit

5) Click OK

Hours disappear from page and the Status of the report goes to Submitted for Approval without any hours on the report.

Item two: 

1) Via Employee Self Service Create a Partial Time Report

2) Add hours for partial week

3) Select “Submit for Partial Month” tick box and then click on Save for Later

4) Next Click Submit

5) Click OK

6) The message Fatal PeopleCode SQL Error renders on the page

7) Next Click OK on the message

Subsequent error message occurs. SQL error in Exec (2,280) TE TIME GBLSavePreChange  

 

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.