How to write SLA User Defined Formula based on multiple COA segments (Doc ID 2945493.1)

Last updated on AUGUST 28, 2023

Applies to:

Goal

How to write a SLA User defined formula based on COA segment

Currently below rule is setup:

IF ((((ToInteger("Invoice Distribution Account"."Primary Balancing Segment") <= 999999999) AND (ToInteger("Invoice Distribution Account"."Primary Balancing Segment") > 0)) AND (ToInteger("Invoice Distribution Account"."Primary Balancing Segment") != 164601193)) AND (ToInteger("Invoice Distribution Account"."Primary Balancing Segment") != 131201424))
THEN '3000290'

Here the output is 3000290 (THEN) for ACCOUNT segment indicated by THEN condtion, however if the segment is COMPANY we would like to have 1000000000 and for other segments other values. Is it possible to achieve this in one user defined formula query like above?
 

Solution

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