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:

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.

Changes

Cause

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