In Fluid Approvals Page, On The Summary Info For Marital Status Change,It Is Not Showing The Latest Marital Status Change Value.
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.
On : 9.2 version, Other Issue with eProfile
Fluid Approvals - Marital Status Summary Page
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);
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);
In Fluid approvals, Personnel administrator expects to see latest marital status value and effdt for the direct report.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms