Thursday 4 January 2024

Fusion Absence Management: Error While Saving Absence Plan with Multi year Carryover

 

Error While Saving Absence Plan with Multi year Carryover

Getting below error when we are running "Calculate Accruals and Balances" program for person number 1031582


oracle.jbo.AttrValException: JBO-27035: Attribute ParentRefId is required.


CAUSE:

File Name or Source
-------------------------
select * from fusion.FND_LOOKUP_VALUES_VL where LOOKUP_CODE like'ANC%'

Description
--------------
Checking if any lookup is blocking the functionality.

Relevance to the Issue
---------------------------
The lookup ANC_MULTIYEAR_COVR_DISABLED is enabled. This is causing the issue.


Solution:

Lookyp Type : ANC_PROC_CONFIGS

Lookup Code : ANC_MULTIYEAR_COVR_DISABLED

Disable the lookup ANC_MULTIYEAR_COVR_DISABLED.

Null value check in Fast formula in cloud

 

Null value check in Fast formula in cloud

if isnull(VALUE_SET_VALUE) = 'N' then
  (
  VALUE_SET_VALUE = 0
  )


However, it does the exact opposite of what its name suggests: it returns 'Y' if the value is not null, and it returns 'N' if the value is null.