Tuesday, 16 April 2024

How to disable IBAN Validation When Createing Bank Account for an Employee

 How to disable IBAN Validation When Createing Bank Account for an Employee


Please check the value of the profile option, Disable Country Specific Bank Validations
This profile can be set (Manage Cash Management Profile Options) at the site, product, or user level. The profile is predefined with a default value of No at the site level.
The country-specific validations pertaining to the bank code, branch number, account number, check digit, and IBAN can be disabled by this profile option. If the profile is set to Yes these validations are not performed. The checks for unique banks, branches, accounts, and the mandatory requirement of bank account number are not affected by this profile.

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.