My Oracle Support Banner

ESOCIAL: GPBR_ES_ILB Process Does Not Run In SQL Server Database. (Doc ID 2539450.1)

Last updated on MAY 07, 2019

Applies to:

PeopleSoft Enterprise HCM Global Payroll Brazil - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

GPBR_ES_ILB process stucks in the following query when using SQL Server Database.

INSERT INTO ps_gpbr_dep_tmp11 (
  process_instance,
  gpbr_driver_seq,
  gpbr_drv_split_seq
  )
  SELECT 743092,
  tmp.gpbr_driver_seq,
  tmp.gpbr_drv_split_seq
  FROM ps_gpbr_map_tmp11 tmp,
  ps_gpbr_drvemp_xrf xrf
  WHERE tmp.process_instance = 743092
  AND tmp.gpbr_driver_seq = xrf.gpbr_driver_seq
  AND tmp.gpbr_event_cd IN (
  'S-2299',
  'S-2399'
  )
  AND EXISTS (
  SELECT 'X'
  FROM ps_gpbr_rcrslt_t11 rsl
  WHERE rsl.process_instance = 743092
  AND rsl.gpbr_event_cd = tmp.gpbr_event_cd
  AND rsl.company = tmp.company
  AND rsl.oprid = 'A.JULIO'
  AND rsl.run_cntl_id = 'IB'
  AND rsl.gpbr_es_source = 'ILB'
  )
  AND EXISTS (
  SELECT 'X'
  FROM ps_dep_ben_name nam
  LEFT OUTER JOIN ps_dep_ben_namelng nam_lng ON nam_lng.emplid = nam.emplid
  AND nam_lng.dependent_benef = nam.dependent_benef
  AND nam_lng.language_cd = 'POR',
  ps_dep_ben_eff dbe,
  ps_dep_ben dep
  WHERE dep.emplid = xrf.emplid
  AND dep.emplid = nam.emplid
  AND dep.emplid = dbe.emplid
  AND dep.dependent_benef = nam.dependent_benef
  AND dep.dependent_benef = dbe.dependent_benef
  AND dbe.effdt = (
  SELECT MAX (effdt)
  FROM ps_dep_ben_eff dbe1
  WHERE dbe1.emplid = dbe.emplid
  AND dbe1.dependent_benef = dbe.dependent_benef
  AND dbe1.effdt <= xrf.gpbr_es_ps
  )
  AND nam.effdt = (
  SELECT MAX (effdt)
  FROM ps_dep_ben_name nam1
  WHERE nam1.emplid = nam.emplid
  AND nam1.dependent_benef = nam.dependent_benef
  AND nam1.effdt <= xrf.gpbr_es_ps
  )
  AND ( nam_lng.effdt IS NULL
  OR nam_lng.effdt = nam.effdt )
  AND ( 'POR' = 'ENG'
  AND length ( (nam.first_name
  || ' '
  || nam.middle_name
  || ' '
  || nam.last_name) ) > 70 )
  OR ( 'POR' <> 'ENG'
  AND ( ( nam_lng.name_display IS NOT NULL
  AND length ( (nam_lng.first_name
  || ' '
  || nam_lng.middle_name
  || ' '
  || nam_lng.last_name) ) > 70 )
  OR ( nam_lng.name_display IS NULL
  AND length ( (nam.first_name
  || ' '
  || nam.middle_name
  || ' '
  || nam.last_name) ) > 70 ) ) )
  )


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.