In Fluid Approvals Page, On The Summary Info For Marital Status Change,It Is Not Showing The Latest Marital Status Change Value.

(Doc ID 2353151.1)

Last updated on JANUARY 25, 2018

Applies to:

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

Symptoms

On : 9.2 version, Other Issue with eProfile

Fluid Approvals - Marital Status Summary Page

ACTUAL BEHAVIOR
---------------
On delivered fluid approvals page, on the summary info for Marital Status Change, it is not showing the latest marital status change value and effdt in approval screen.

The sql in the attached document (mentioned here too) is not using the action date of the transaction. Because of this, it is pulling the info from a wrong action date record and showing the information on the approvals ummary page.

  If %Language <> %Language_Base Then
  SQLExec("select DESCR, DESCR6, Action_DT_SS from ps_marstachg_dtvwl where EMPLID = :1 and effseq=:2 and LANGUAGE_CD=:3", &recApplication.GetField(Field.EMPLID).Value, &recApplication.GetField(Field.EFFSEQ).Value, %Language, &sCurrentM, &sNewM, &dActionDtSS);
  Else
  SQLExec("select DESCR, DESCR6, Action_DT_SS from ps_marstatchg_dtvw where EMPLID = :1 and effseq=:2", &recApplication.GetField(Field.EMPLID).Value, &recApplication.GetField(Field.EFFSEQ).Value, &sCurrentM, &sNewM, &dActionDtSS);
  End-If;
 

EXPECTED BEHAVIOR
-----------------------
In Fluid approvals, Personnel administrator expects to see latest marital status value and effdt for the direct report.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Fluid Self Service>Login as KU0046 and enter marital status change and submit marital status change transaction(No Life event completion needed).
2. Login as PS(Personnel admn) to approve transaction
3. Marital status and effdt is incorrect in approval page.



Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms