Unable to Compile Flexfield $SRS$.PAYFRASD, APP-FND-00798 (Doc ID 282270.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle HRMS (France) - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

You get an error compiling desc flexfields:

Application Id: 801
Short Name: PAY
Name: Oracle Payroll
Flexfield Name: $SRS$.PAYFRASD
Title: $SRS$.PAYFRASD
Compilation aborted for current descriptive flexfield...
APP-FND-00798: Invalid reference FND_DATE4 in value set attached to segment
Assignment
Please check the WHERE clauses of your table validated value sets.


The Flexfield is associated with report "Attestation ASSEDIC"
The parameter P_ASSIGNMENT has value set "HR_FR_TERMINATED_EMPLOYEES".

Value set "HR_FR_TERMINATED_EMPLOYEES" has following "where" clause:
where 'A' = nvl(:$FLEX$.HR_FR_INVOCATION:NULL,'A')
and a.business_group_id = :$PROFILES$.PER_BUSINESS_GROUP_ID
and a.primary_flag = 'Y'
and a.period_of_service_id = pds.period_of_service_id
and decode(pds.pds_information11,'LAST_DAY_WORKED'
,fnd_date.canonical_to_date(pds.pds_information10)
, pds.actual_termination_date)
between :$FLEX$.FND_DATE4
and :$FLEX$.FND_DATE4_REQUIRED
and decode(pds.pds_information11,'LAST_DAY_WORKED'
,fnd_date.canonical_to_date(pds.pds_information10)
, pds.actual_termination_date)
between a.effective_start_date and a.effective_end_date
and p.person_id = a.person_id
and decode(pds.pds_information11,'LAST_DAY_WORKED'
,fnd_date.canonical_to_date(pds.pds_information10)
, pds.actual_termination_date)
between p.effective_start_date and p.effective_end_date
and :$FLEX$.P_DUMMY IS NOT NULL

 

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