Overview of Writing Formulas
Writing fast formulas enables you to perform a wide variety of tasks using English words and basic mathematical functions. There are several techniques that you can use to ensure your formulas are easy to read, use, and understand.
You write fast formulas to validate or calculate data for payroll and other Oracle Fusion applications.
This table lists the key aspects of writing fast formulas.
Key Aspects |
Description |
---|---|
Using the expression editor |
Use the expression editor with these formula types:
Use these formula types when creating dynamic object groups. Object groups define subsets of deduction components or people for processing or reporting. |
Using formula text |
Most formula types use the text editor to define formulas. The text editor is more flexible than the expression editor. Here's what you can do with the text editor:
Database items are read-only variables that you can use to get application data without having knowledge of the underlying data model, and writing queries to get the data. The input values that you have passed and the output values returned depend upon the context in which you're using the formula. The names and types of these values are defined in many scenarios, so refer the appropriate product documentation. |
Improving performance |
Here's what you can do to improve performance:
|
Avoiding compilation errors |
Compile a modified formula before using it. Here's what you can do to avoid common compilation errors:
|
Avoiding execution errors |
Here's what you can do to avoid common execution errors:
|