We have an FRS (Financial Reporting Studio) report that needs to be scheduled. For each scheduled run, the Accounting Period parameter should automatically increment to the next period. Is there a way to achieve this functionality?
As per my knowledge, FRS (Financial Reporting Studio) reports do not have a built-in "Auto-Increment" checkbox for the Accounting Period parameter like some standard ESS jobs do. However, you can achieve this exact functionality by using the Batch Scheduler in combination with the Current POV (Point of View) function.
Instead of hardcoding a specific period (like "Jan-24") in your schedule, you set the report to look at the "Current" period.
To make the period increment automatically, the report grid must be designed to use the System's Current Period rather than a user prompt. When the scheduled batch runs, it will look at whatever period is marked as "Open" or "Current" in the GL or the user's preferences at that moment.
Hi @User_LDK8D ,
Welcome to the Oracle Analytics community and forum.
Do you have a FRS report built on top of your OBIA?
Because your question is maybe not in the right place…
Are you using FRS on top of a cloud application? In that case you should go to https://community.oracle.com/customerconnect (a parallel but independent forum) that covers all the cloud applications. This forum covers the Oracle Analytics products, and FRS isn't part of them.
for a particular report, when some users click on the link, the new tab opens but after about 10 minutes of loading the system returns
Summary: Hello experts, We are using WLF_ASSIGNMENT_TASKS_F to fetch the data from the learn tables The WLF_ASSIGNMENT_TASKS_F table, in the LAST_UPDATED_BY field, doesn't reflect who actually updates the task. I've attached the query used. Can you please help me? Content (please ensure you mask any confidential…
https://blogs.oracle.com/analytics/announcing-the-general-availability-of-oracle-analytics-server-2026 As announced, OAS 2026 has moved to FMW 14. What does this mean for the future of OBIA? Given that 103PS4 is for 12.2.1.4 , it would seem another required upgrade beyond 103ps4 will have to happen. What should customers…
Hi everyone, we're experiencing an interesting issue with report filters in Oracle Learning Management (or similar). Problem: When we use filters based on SQL queries, for some specific users the report filters disappear completely, making the report non-functional. Technical Details: We've identified the critical point in…
We use OAS 2025, EBS 12.2.12, OBIA 7.9.6.4, Oracle 19c db on Linux. We are trying to build Project to GL Cost reconciliation report that runs for a period, currently it is done manually, by running three analytics reports (one on Project - Cost subject area to get total cost for Contract and Resources, another report on…
