You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Feasibility of Dynamic Conditional Account Insertion in Financial Reporting Studio (FRS)

edited Apr 24, 2025 12:13PM in General Ledger & Intercompany 1 comment


We are implementing a financial report in Oracle Financial Reporting Studio (FRS).
The business requirement is as follows:

Based on the sum of two accounts (18600000 and 18700000), we need to insert the result dynamically:

If the sum is greater than zero for the 2 accounts, the total should appear under the "Actif" section/Grid.

If the sum is less than zero for the 2 accounts, the total should appear under the "Passif" section/Grid

However, based on our testing, it appears that FRS does not support dynamic insertion of rows into different sections based on runtime data evaluation.
We can only conditionally suppress or display existing rows, but not move or insert rows dynamically depending on the calculated sum.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!