ABMGT: Leave Donation Administrator Page Returns Incorrect RECIPIENT_TYPE And RECIPIENT_EMPLID (Doc ID 3055699.1)

Last updated on FEBRUARY 13, 2025

Applies to:

Symptoms

GP_ABS_LVDN_INIT.GBL.GP_ABS_LVDN_HDR.SavePreChange not working as expected.


The Component variable &RequestType is set when someone clicks on the "View Details" link on the Leave Donation/Initiate Requests page. Clicking on that link opens another page, based on the "Request Type" (Donate/Receive/Return). The code in this program cannot rely on this variable because it will always contain the value from the line on which the "View Details" link was last clicked, rather than the current line being processed in this code which executes at the Component level and applies to all rows entered on the page. The result is that in the scenario where an administrator enters a leave donation request on behalf of two different employees, the first for a donation and the second for a receive, the &RequestType variable is set to "RCV". When the donation request is processed, it winds up being created as a donation to the donating employee, i.e., PS_GP_ABS_LVDN_DTL.REQUEST_TYPE is set to 'E' (employee), rather than a blank, as is expected for a donation to the Bank, and PS_GP_ABS_LVDN_DTL.RECIPIENT_EMPLID is set to the EMPLID of the person for whom the donation request was entered, so the request becomes a “self-donation”.

Steps to Recreate:
1. Navigate to Main Menu > Global Payroll & Absence Mgmt > Payee Data > Leave Donations > Initiate Leave Payee Requests
2. Enter a donation request for one employee, click on the “View Details” link, and enter the appropriate information on the page that opens. Click the “OK” button to return to the Initiate page.
3. Enter a receive request for a second employee, click on the “View Details” link, and enter the appropriate information on the page that opens. Click the “OK” button to return to the Initiate page.
4. Press the “Save” button on the “Initiate” page to save both requests.
5. In SQL Developer, execute the following statement and you will see that the donation request actually has RECIPIENT_TYPE = ‘E’ (employee), rather than a blank, and that the RECIPIENT_EMPLID has been set to the EMPLID for which you entered the donation request, i.e., a “self-donation”.
  select * from ps_gp_abs_lvdn_dtl
  where emplid = ‘’
  and empl_rcd = <EMPL_RCD on donation request>;

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.