Running Long Time fnd_flex_validation_rules (Doc ID 2515996.1)

Last updated on SEPTEMBER 23, 2023

Applies to:

Symptoms

On : 12.2.4 version, Descriptive flexfields (EXCEPT setup or Flexbuilder issues)

ACTUAL BEHAVIOR
---------------
Query Running long time.

SQL Details: fvf9htgxc5bhq

select R.FLEX_VALIDATION_RULE_NAME
from FND_FLEX_VALIDATION_RULES R
where R.ENABLED_FLAG = 'Y' and ( (:VDATE is null) or ( ( R.START_DATE_ACTIVE is null or R.START_DATE_ACTIVE <= :VDATE) and ( R.END_DATE_ACTIVE is null or R.END_DATE_ACTIVE >= :VDATE))) and R.APPLICATION_ID = :APID and R.ID_FLEX_CODE = :CODE and R.ID_FLEX_NUM = :NUM MINUS
select L.FLEX_VALIDATION_RULE_NAME
from FND_FLEX_INCLUDE_RULE_LINES L
where 1 = 1 and (:FND_BIND1 between nvl(L.SEGMENT11_LOW,:FND_BIND2) and nvl(L.SEGMENT11_HIGH,:FND_BIND3)) and (:FND_BIND4 between nvl(L.SEGMENT10_LOW,:FND_BIND5) and nvl(L.SEGMENT10_HIGH,:FND_BIND6)) and (:FND_BIND7 between nvl(L.SEGMENT9_LOW,:FND_BIND8) and nvl(L.SEGMENT9_HIGH,:FND_BIND9)) and (:FND_BIND10 between nvl(L.SEGMENT8_LOW,:FND_BIND11) and nvl(L.SEGMENT8_HIGH,:FND_BIND12)) and (:FND_BIND13 between nvl(L.SEGMENT7_LOW,:FND_BIND14) and nvl(L.SEGMENT7_HIGH,:FND_BIND15)) and (:FND_BIND16 between nvl(L.SEGMENT6_LOW,:FND_BIND17) and nvl(L.SEGMENT6_HIGH,:FND_BIND18)) and (:FND_BIND19 between nvl(L.SEGMENT5_LOW,:FND_BIND20) and nvl(L.SEGMENT5_HIGH,:FND_BIND21)) and (:FND_BIND22 between nvl(L.SEGMENT4_LOW,:FND_BIND23) and nvl(L.SEGMENT4_HIGH,:FND_BIND24)) and (:FND_BIND25 between nvl(L.SEGMENT3_LOW,:FND_BIND26) and nvl(L.SEGMENT3_HIGH,:FND_BIND27)) and (:FND_BIND28 between nvl(L.SEGMENT2_LOW,:FND_BIND29) and nvl(L.SEGMENT2_HIGH,:FND_BIND30)) and (:FND_BIND31 between nvl(L.SEGMENT1_LOW,:FND_BIND32) and nvl(L.SEGMENT1_HIGH,:FND_BIND33)) and L.APPLICATION_ID = :APID and L.ID_FLEX_CODE = :CODE and L.ID_FLEX_NUM = :NUM and L.ENABLED_FLAG = 'Y'

 

EXPECTED BEHAVIOR
-----------------------
Not to be so long running.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.