How to write SLA User Defined Formula based on multiple COA segments
(Doc ID 2945493.1)
Last updated on AUGUST 28, 2023
Applies to:
Oracle Fusion Subledger Accounting Cloud Service - Version 11.13.22.10.0 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |