Hello @Faisal.Iqbl,
Can you please review the below to see if you can find any subject areas in OTBI for your requirement.
https://docs.oracle.com/en/cloud/saas/financials/24d/faofb/index.html
Thanks,
Praveen
Hi Faisal,
For this use case you can perhaps as suggested by Praveen use the general ledger balances (cube) subject area or more detailed transactional balances subject area in OTBI.
https://docs.oracle.com/en/cloud/saas/financials/24d/faofb/General-Ledger--Balances-Real-Time-SA-14.html#General_Ledger__Balances_Real_Time_SA_14_d1e5501
https://docs.oracle.com/en/cloud/saas/financials/24d/faofb/General-Ledger--Transactional-Balances-Real-Time-SA-18.html#General_Ledger__Transactional_Balances_Real_Time_SA_18_d1e6291
But also instead of using using OTBI please have a look at using Financial Reports
using Financial Reports Studio (Hyperion) in application Financials General Ledger or using Narrative Reporting if you are doing Financial Consolidation and Close (FCC) in Enterprise Performance Management (EPM) as part of your business process Close Accounting Period Close Ledgers.
To create statements using financial reports this is your level 3 business process diagrams
Oracle Fusion Business Process Models: 14 Financial Control and Reporting (Doc ID 1578173.1)
L2: 1411 Manage Financial Reporting and Analysis https://support.oracle.com/
And here is your user guides
Oracle Fusion Cloud Financials Implementing Enterprise Structures and General Ledger G12433-01 24D
https://docs.oracle.com/en/cloud/saas/financials/24d/faigl/overview-of-financial-reporting-center.html#s20033201
Oracle® Hyperion Financial Reporting Web Studio User's Guide F13690-06 July 2023
https://docs.oracle.com/en/applications/enterprise-performance-management/11.2/hfwcc/index.html
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
I have a Leave Details Report with the condition below to restrict the report based on the logged-in user's AOR. However, the report is not returning any data for any legislation, when users run it under the 'About Me' context.
Hi All, Good Day. We have created one custom OTBI report and it has "Business Unit" as of one of the parameter. The related list of values is showing all the business units and we want to restrict it to the user who has the related Business Unit data access set access. Please let us know how to achieve this in OTBI report.
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…