My Oracle Support Banner

SHDL Load Failing As Value Set Of The Field That Is Being Updated Is Returning Two Values: this field is populated by value set HRX_US_REP_LOCATION (Doc ID 2481023.1)

Last updated on DECEMBER 05, 2018

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.10.0 version, US - United States Legislation

ACTUAL BEHAVIOR
---------------
SHDL load failing as value set of the field that is being updated is returning two values

EXPECTED BEHAVIOR
-----------------------
SHDL load to complete successfully

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. updating HR Reporting Proxy field under 'HRX_US_LOC_EEO_VETS_INF' in location legislative EFF.
(This field is populated by value set HRX_US_REP_LOCATION which derives values using a SQL query)
2. This SQL query is returning same location twice leading to update failure.

+ *Additional mention bellow

Details (on the latest facts):
@Support:
Both tables PER_LOCATION_LEG_F and hr_locations_all contains date-split historical data. Hence you have to add additional condition to "where" clause like below.

SELECT SUBSTR(hl.location_name,1,50),
  hl.location_id
FROM fusion.PER_LOCATION_LEG_F pll,
  fusion.hr_locations_all hl
WHERE pll.location_id = hl.location_id
  AND pll.Lle_Information1='Y'
  AND hl.active_status ='A'
  AND pll.LLE_INFORMATION_CATEGORY LIKE 'HRX_US_LOC_EEO_VETS_INF'
and sysdate between pll.effective_start_date and pll.effective_end_date
and sysdate between hl.effective_start_date and hl.effective_end_date
order by 1

@User feedback:
Value Set: HRX_US_REP_LOCATION is a protected value set and users from front end cannot make any changes. Any changes in the query need to be done from Oracles side.

*Additional mention:
observing that post 18 C update (applied on this instance on 11/2/2018) I see all custom SHDL templates missing. Can you please check ?

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete SHDL load

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.