My Oracle Support Banner

EEX 9.2: EMPL_RCD Is Systematically Changed When the ER is Approved (Doc ID 2524131.1)

Last updated on OCTOBER 18, 2021

Applies to:

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

Symptoms

When Expense report is Approved, on the Expense Report Summary page, the EMPL_RCD Value is Changed from 0 to 1 on the EX_SHEET_HDR Record

 

Steps:

1. Create and submit an expense report for approval when the default profile for the employee has a value of 0 in the EMPL_RCD field.
2. A SQL query of the PS_EX_SHEET_HDR shows that the field EMPL_RCD has a value of 0 to match the value on the employee' profile.
3. The employee profile record with a EMPL_RCD field value of 0 is set to a status of Inactive and the default check box is uncheck.
4. Also the second employee profile record with a EMPL_RCD field value of is set as the default profile.
5. The Approver opens the expense report for approval and clicks the Approve button. The expense report has a status of "Approved for Payment".
6. A SQL query of the PS_EX_SHEET_HDR shows that the field EMPL_RCD has been incorrectly changed to a value of 1.
7. When the ER is approved, it is then sent to HR for payment. On the HR side, since EMPL_RCD #1 is not valid for expenses, it cannot be paid.

Actual Result:

When Expense report is Approved, on the Expense Report Summary page, the EMPL_RCD Value is Changed from 0 to 1 on the EX_SHEET_HDR Record.

 

Expected Result:

The EMPL_RCD value should remain 0 after the expense report is approved.

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.